I work in a small day school with 8 students. Every student is enrolled in a different course than the others based on Grade and the Electives chosen.
Weekly, I send the owner of the school a spreadsheet with the students' current grades in every subject. Right now, I need to go into each course, find the students' grades in the given subject, enter them in the spreadsheet, and then go to the next course.
What I am looking to do is to create a student-specific report that shows all classes they are enrolled in and their current grade.
I know I can pull a spreadsheet for each specific course, but that doesn't give me the student-specific view the owner is requesting. Any advice?
