Re: [school-discuss] gradebook data definitions

[Chris Francy <francyci@yahoo.com>]

It isn't quite that simple there should be a way to excuse a student from a 
assignment.  A excused 'test' should neither be 0 or 15 rather the 'test' 
should be removed from the calculation.

Total_Pts_Test1 = 15
Total_Pts_Test2 = 15
Total_Pts_Test3 = 30
Total_Pts_Test4 = 15

Name,T1,T2,T3,T4 = Total
Mary,8,9,x,15 = 32 / 60
Joe,9,12,28,5 = 54 / 75
Bob,4,14,27,12 = 57 / 75

The are probably other things to that should be taken into account.

Might be good to download a demo copy of a couple existing commercial grade 
packages and do some research...  Or perhaps find a teacher who still uses 
a paper-based grade book and get them to describe their process to you.

Chris

At 01:01 PM 4/29/2002, you wrote:
>Hi,
>
>Roughly speaking in order to add a gradebook function onto an existing
>system containing demographic data could be implemented by using 2
>tables:
>1) Tests - containing information about a particular test including
>class/section its for, maximum score (text or numeric), date, etc.
>
>2) Results - which store specific results for each student in each test;
>one record for each. It would contain student number, result (raw score;
>ie. 8 out of 15; the 15 would be stored in the tests table, the 8 in this
>record.), the test number (matching the record in the "tests" table.)
>
>Any other structural requirements anyone can think of?
>
>
>Les Richardson