[school-discuss] Gradebook Specification

[Les Richardson <richl@mail.tfsd.sk.ca>]

Hi All,

Reflecting upon a basic gradebook spec, I've come up with several tables
in a database:

1) Student - student information including:
a) Lastname
b) Firstname
c) Student Number (local or state/provincial)
plus any other useful demographic stuff.


2) Tests - a particular assessment device given to students in
a particular class/section taught by a particular teacher.

a) TestID - unique number
b) Subject ID/Description - a particular subject. May match value in
another "subject" table or not.
c) SectionID - a particular "section" or "group taught by a particular
teacher.
d) Description of test/assessment device.
e) Date of test 
f) Maximum Raw Score.
g) Weighting (for total assessment results.)
h) Category A - useful for grouping assessment types.
i) Category B
j) Category C, etc.


3) Results - students' results from tests.
a) Student Number
b) Test Number
c) Raw Score
d) Text Descriptor of result. 

What else is required for data storage in a SQL database?

***************** 
Operations Required: (by a teacher)
a) Enter/Edit/Delete Students
b) Enroll/Drop students in Subject/Section.
c) Add Tests to the Subject/Section.
d) Enter/Edit/Delete Student Results.
e) Print/View results by Student, Test. 
f) Adjust Test Weightings including grouping by category.(overall balance
of course)

Admin programs could of course then pull this data to integrate into
report cards.

*****************

What else?



Les Richardson
H. Hardcastle School
Edam, SK. Canada