direction for a project

[DUNNER7]

I am trying to create a form for my teachers to use to keep track of student
behavior. The form has 7 periods (one for each class period) and 7 areas in
which the child will be scored. So a 7x7 or 8x8 table, I want the teachers
to be able to score the kids in the 7 areas for each period and be available
(on-line) so that each of his/her next teachers can give their scores. The
totals for each criteria/period would tally based on the assigned score.
Then a daily total would be tallied taking the totals from each period and
adding them together. I am assuming that it would have to be based on a
server to give teachers access to input the information. Can someone give me
a direction to start building this? I have the summer to experiment and work
on it. Can I use Access, or can I design a form using infopath and have data
saved into excel? I would appreciate someone getting me started and I will
be able to plod along from there

Thanks
D. Dobbs

 

[Duane Hookom]

You might want to start by studying a bit on normalization. There are a
couple samples that might get you started at
http://www.rogersaccesslibrary.com/OtherLibraries.asp#Hookom,Duane. Look at
both "At Your Survey" and "Employee Evaluation".

Each individual score should create its own record in your table. Don't
create 7 fields for 7 areas or 7 fields for 7 periods. If you do that, you
might want to stick with Excel.

I would expect your table of scores might look something like:

tblScores
===============
scoScoID autonumber primary key
scoDate date of scoring
scoStudentID
scoPeriodID
scoAreaID
scoScore value of score

This could be normalized to remove the date, student, and period to place in
a parent table.

tblScoreEvents
==============
sceScEID autonumber primary key
sceDate
sceStudentID
scePeriodID
sceEvaluator

Then replace the Date, Student, and Period fields from the previous table
with a field [scoScEID] to store the sceScEID value from tblScoreEvents.