[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

Re: [school-discuss] gradebook data definitions



Hi Chris,

A "noncounting" result would simply not have a record. A record with 0 is
the only way to get a zero. That's the way that I would approach it.

Les


At 08:12 PM 4/29/02 -0700, you wrote:
>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
>
>