Entering a grading system

[TSG]

I am working on a database to help teachers manage the classroom better
I am now at the point where I want to install a grading system allowin
the teacher to use a form to enter the grade for a test, worksheet, etc
Also on the form will be a combo box to select the student, and a comb
box to select the class(subject) where the grade will count i.e
Reading, Math, etc. The teacher is going to be able view/print
report that will show all grades by subject for a particular studen
and the avg. at that time. Anyway, I am having trouble on exactly ho
I should structure the table where this information will be stored.
know I will have to link it to the student table that has all of th
students' name and address informaiton. Can someone help me with this

 

[Duane Hookom]

There are a couple "student" related data models on this page
http://www.databaseanswers.org/data_models/index.htm. While the structures
are good, they are only samples. I prefer to always create tables with a
single field primary key. Some sample tables use several field PKs.

 

[PC Datasheet]

Just to let you know that I am available to help you -----

 

[Duane Hookom]

I think there are lots of us here available to help TSG.
Some of use provide on-line assistance for free. Others like to go fishing
for consulting clients in public news groups.

 

[Larry Daugherty]

Hi,

It would be helpful to have the rest of your schema so that we don't have to
assume and then make suggestions based on those assumptions, etc. Have you
ever parsed a s s u m e ?

With the above risk in mind:

call the new entities (test, worksheet, etc.) Assignments and record them
in tblAssignment.

Would you post back and tell us what all you're tracking in your
application"

Teachers, Students, Subjects Classes/sections <- could get rosters from
that, Assignments ??

HTH