I'm a teacher trying to create a database of grades. I'm trying to figure out if Google Sheets and Google Forms is sufficient for my task or if I need a real database solution. I need some tables:
STUDENT INFO: Student Name / Student ID Number* / Section Number / Virtual Class Name
WEEKLY GRADE RECORD: Student ID Number* / Week Number / Assignment Grade (I'm simplifying here a bit. The assignment grade is broken down into three independent categories of grade which remain constant for each week, but I'm just sketching things out).
WEBAPP VIRTUAL CLASS: Virtual Teacher/ Virtual Class Name*
SECTION: Period Number / Section Number*
That means essentially the form I will be filling out regularly will be the weekly grade record while the other forms I will need to fill out once.
I need to create two kinds of reports: a) I need to combine all the weekly grade records for one student so that the results appear in a single report. b) I need to create aggregate totals per week by period number.
I know how to create the forms and to import data from one table into another on Google Sheets. But I don't know how to select all weekly grade records for one student and dump it into a single report for that student. I have about 200 students, so it would be time-consuming to manually create reporting tables in Google Sheets for each student.
Can you give me some general advice for what I'm looking for and whether a Google Docs solution is ideal for this kind of task. I know what databases can do and perhaps that is what I need (I might be able to use MS Access --ugh), but I am open to suggestions.
UPDATE: Maybe my needs are best served with a web database. Like Ragic, etc? Still deciding.