Re: [school-discuss] Collecting Assessments at District Level

[Stephen Braunius <sbrauniu@zeeland.k12.mi.us>]

Thank you for the follow-up.  That answers my question about a better way
to form my tables.  I had been doing tons of small tables and relating them...I
guess thinking that then I don't have to have duplicate information in various
tables.  It's all starting to make sense now :^).  More information in a
table now=easier querying in the future.

Since no one has commented on their being any pre-created solutions out there
for linux that are set up for the type of assessment stuff I'm asking about
with graph and chart options, I'll just keep talking to the various vendors
of other solutions while creating my own to meet our district's needs.

I'll share more as I get this thing developed...
-- 
Stephen Braunius
Director of Instructional Technology
Zeeland Public Schools - http://www.zeeland.k12.mi.us
Zeeland, Michigan


Les Richardson wrote:
> Pine.LNX.4.10.10203131518330.15230-100000@strider.tfsd.sk.ca">
> Hi,
>
> Sorry, I misunderstood your question.
>
> So you want reports by:
> student, class, location
>
> There are a couple of approaches in terms of data structures:
> a) Fewer larger tables that simplify querying but complicate entry.
> b) More smaller tables that make querying harder. 
>
> Anyway, what will we need in a table to store the assessment results:
>
> StudentID:  - student id
> AsResult: - assessment result
> Type: (percent or scale) - it could be a number representing the max value
> (ie. 100 or 4, etc.)
> LocationCode:  - a number for the building.
> ClassCode - a number for the year, subject, form,
>
> These last two fields could be combined or multiple fields could be
> created, depending on needs. For simplified querying, it might be nice to
> have separate locationcode, subjectcode(ie. Gr 11 chemistry = 8212),
> year, etc.
>
> Then linked tables for locations, subjects, etc. would also be required.
>
> This
>  should be enough to store all your assessment data results
> quite easily and also allow reasonable querying/reporting.
>
>
> > scale, quantatative/qualitative, curricular area, etc) and a table with 
> > just data and the associated test?  
> >     
>
> So you also have the assessment device (ie. the test) also?
>
>
>
> > I would like an individual teacher to be able to pull up information 
> > about each student, the average for their class, and the average for the 
> > building in each area.
> >       
>
> A simple query will easily give these results, either with a web interface
> or some sort of MySQL client or an ODBC/JDBC connection to some sort of
> front end.
>
> > MySQL with with fields like this: student id, score1, score2, etc.  They 
> > are then associated with a table that has some very general test 
> > information.
> >         
>
> What is the "very general test information"? and why do you want that?
>
> Les Richardson
> HHS.
>
>
>