Help with student mark database

[Perpenderp]

I am creating a student mark database for a teacher. There should be an entry form to create an assignment and once the assignment is created he should be able to quickly input marks for each student (possibly going down a table using the number pad and arrow keys unless there is a better way). Is there a way to create a new table for the assignment (with student names in the rows and different assessment criteria in the columns) each time he creates an assignment or should this be done another way?

[pbaldy]

It should be done another way. Research normalization; here's one link:

Fundamentals of Relational Database Design -- r937.com

In your case, the relevant tables would be students, assignments, and what's sometimes called a many-to-many junction table. It would contain each combination of student and assignment. It would have at least 3 fields: it's own primary key, the key field from students, and the key field from assignments. If I'm a student with 3 assignments, I have 3 records in that table.

[ranman256]

Teacher would create a test in the tWork table

tWork (all tests,quizes given to class)
----------
WorkID (auto)
RosterID
WorkType (test,lab,quiz)
GradePts

an append query would add this WorkID to all students, tStudentWork table

tStudentWork (grade student got on test)
-------------
StudentWorkID
StudentID (long)
WorkID
Grade

then a form could display all students in the class where you can go down the list giving the grade. (mark)

[Perpenderp]

@pbaldy


I'm planning on have three tables so far:
* Classes table (class ID, class name)
* Students table (first/last name, student #, gender, class ID)
* Assignments table (name, criterias assessed, max for each criteria, weighting, class ID)

The assignments table will have a list of all the assignments and their mark breakdowns but how should I actually store the marks of the students? The four criterias for an assignment are knowledge, thinking, application and communication and each assignment will have at least 1 of these criteria but doesnt have to have all four. A max mark will be given for each criteria (e.g. /10 knowledge, /20 thinking, etc) and a total mark will close be calculated, The table containing all the student marks should show that they got (for example) 5/10 knowledge (maybe in one column), 20/20 thinking (another column) and 25/30 total. I feel like having a table containing the marks for all the students for each assignment makes the most sense but im not sure how to create something like this.

EDIT: ideally the teacher should be able to create the assignment using an entry form (assignment name, class, criterias assessed, max for each criteria, and weighting). Weighting is simply a multiplier giving a test more importance compared to a quiz. The weighting would be considered in the final calculation of the student's mark. Next he should be taken to a table where he can easily input the marks of all of his students for that assignment.

[andy49]

Best way I've found to enter results (teachers hat on) is to create a continuous form and set the options so the Enter button moves to the next field.


Sent from my iPhone using Tapatalk