I have two tables, one containing the result of each student's answer to a multiple choice question.
StudentName, StudentID, Q1, Q2, Q3, Q4, Q5, Q6
In the fields Q1, Q2, etc, are 1's and 0's, 1 if the student got the question correct and 0 if they did not.
In another table is the standard that each question number is attached to.
Question_Num, StandardName,StandardDescriptor
For example:
1 N.12.00.A Can add two digit numbers
2 N.13.00.S Can subtract two digit numbers
3 N.12.00.A Can add two digit numbers
4 N.13.00.S Can subtract two digit numbers
5 N.13.00.S Can subtract two digit numbers
6 N.25.01.P Can solve number problems
What I would like is a query that would combine the two tables to find the average of each standard, for each student. For example:
StudentName, StudentID, Avg_N.12.00.A, Avg_N.13.00.S, Avg_N.25.01.P
Right now I export and import the information back and forth between Access and Excel to compute each student's standard average. But I am hoping to automate the process in Access.
The tables above are how the information is retured to us from our state Department of Education.
Thanks!
StudentName, StudentID, Q1, Q2, Q3, Q4, Q5, Q6
In the fields Q1, Q2, etc, are 1's and 0's, 1 if the student got the question correct and 0 if they did not.
In another table is the standard that each question number is attached to.
Question_Num, StandardName,StandardDescriptor
For example:
1 N.12.00.A Can add two digit numbers
2 N.13.00.S Can subtract two digit numbers
3 N.12.00.A Can add two digit numbers
4 N.13.00.S Can subtract two digit numbers
5 N.13.00.S Can subtract two digit numbers
6 N.25.01.P Can solve number problems
What I would like is a query that would combine the two tables to find the average of each standard, for each student. For example:
StudentName, StudentID, Avg_N.12.00.A, Avg_N.13.00.S, Avg_N.25.01.P
Right now I export and import the information back and forth between Access and Excel to compute each student's standard average. But I am hoping to automate the process in Access.
The tables above are how the information is retured to us from our state Department of Education.
Thanks!