My principal has asked me to create a performance tracking application for my school. I have done some work in this area, usually with Excel. Instead of a tracker for my class, it is to be school wide and will track information over several years (ongoing), rather than running the course of a single year such as I usually do for my class.
Some features I would like to include are:
Entering Student Names
Entering Grade 1 Teacher, Homeroom, Standardized Test Scores
Same as above for Grades 2 - 5
Analysis I would like to include:
Graphing a whole grade
Graphing a Homeroom
Graphing all students who had particular teachers
Graphing a particular student's progress from grade 1 - 5
Graphing a group (students with A's, B'sm etc. or all students who previously failed, etc.)
Graphing other things that we think of
Would Excel, Access, or InfoPath be my best bet for this? Or, is there another suggestion? I realize I may have to use a combination of apps. My main experience is in Excel but I am keen to learn other apps.
Teachers will input the data for their class during the year but I will be collecting the data to due the analysis and share the results.
Thank you
Some features I would like to include are:
Entering Student Names
Entering Grade 1 Teacher, Homeroom, Standardized Test Scores
Same as above for Grades 2 - 5
Analysis I would like to include:
Graphing a whole grade
Graphing a Homeroom
Graphing all students who had particular teachers
Graphing a particular student's progress from grade 1 - 5
Graphing a group (students with A's, B'sm etc. or all students who previously failed, etc.)
Graphing other things that we think of
Would Excel, Access, or InfoPath be my best bet for this? Or, is there another suggestion? I realize I may have to use a combination of apps. My main experience is in Excel but I am keen to learn other apps.
Teachers will input the data for their class during the year but I will be collecting the data to due the analysis and share the results.
Thank you