Elaine,
With no column headings in columns C thru Q, I can't even guess at their purpose.
It seems to me that you are trying to put too much information on one sheet.
For example, I am sure that you want to enable a teacher to track success more frequently than 3 times a year. For that purpose I personally would have a sheet with dates across the top and a copy of Columns A and B from your attachment in the first two columns. In the Columns below the dates, I would enter the number of students who "graduated" to the Level in that level's row.
To track each students rate of progress, I would, on another sheet, list the students in Column A, their current level in Column B, and again put dates across the top. merely place an X under the date when the next level of reading is met. Then formulas in Column B could be =CountA(Cn:ZZn) + 1. Plus 1 since all students start at level 1, (or place a X in each students Column C)
Finally, you would need a Summaries Sheet which can have Tables, Pivot tables, Charts and any number of other Excel BI functions.
The only Macros I see needed are for the tedious task of entering the dates each semester and auto-scrolling each Sheet to put the current date column to the left. A macro to enter the Number of "graduating" students from the Student listing sheet to the Levels attained sheet would be nice to have
I hope this helps.
SamT
ps: Don't be fooled by my avatar, I have thousands of post on other forums (|:>)
Bookmarks