Currently Being ModeratedMay 29, 2012 12:36 PM (in response to Gwyn Plem)
first thing i would suggest, would be to reorganize your data. The way it is above you have to add columns in between existing columns every time you want to add more data for more years. Sounds like its not much, just one time a year, but it introduces points of possible errors, along with rewritting of your equations each time.
Make Reading, Maths, etc... their own tables. Then create a summary table for the students that would pull data from those individual tables. That way you just add a new column to the end of the table for each new year.
As for the gauging if a student is "trending". I would say look into the Slope formula for a simple answer. It will give you the slope of a line of best fit. Which will show you the overall trend for the student. For special needs I would probably make a new column in your main summary table that looks at both slope and special needs category to determine if that row needs to be flagged.
As for teachers, you would need to find some way to summarize by teacher per year. Since teachers change year over year, this is a bit harder to do. Might take some more thinking...
Hope some of this helps,