I created a query that averages grades for all assignments in a course. Right now, it takes all assignment grades and simply averages them all. I would like to assign different weight to some assignments. (e.g. Make a chapter quiz worth more toward a grade than daily assignments.) Any suggestions on how to do this would be appreciated.
I have tblAssignments which has fields AssignmentID_PK, CourseID_FK and Assignments; tblGrades with GradeID_PK, SudentID_FK, CourseID_FK, AssignmentID_FK and Grade. Grades are averaged using a query.
SELECT tblGrades.StudentID_FK, tblStudents.FullName, tblGrades.CourseID_FK, tblCourses.Course, Avg(tblGrades.Grade) AS AverageGrade
FROM tblStudents LEFT JOIN (tblCourses RIGHT JOIN tblGrades ON tblCourses.[CourseID_PK] = tblGrades.[CourseID_FK]) ON tblStudents.[StudentID_PK] = tblGrades.[StudentID_FK]
GROUP BY tblGrades.StudentID_FK, tblStudents.FullName, tblGrades.CourseID_FK, tblCourses.Course;
Any suggestions would be greatly appreciated.