One of my schools created a drawing of how they would like students to track their assessment scores in math. Their ideas was to break the assessment into the 6 focus areas and have the students record how they did in each focus area. From there, the students could write goals based on their data. I suggested that Excel to track and display the data. Within Excel, I think two different methods could be successful.
The first method is to setup a table and graph ahead of time in Excel. The students would each have their own copy of this file. After each assessment, the students can enter their scores into the table. The graph will automatically update (when creating the graph, I highlighted all the cell in the chart and this is how it automatically updates) and the students can see their progress in each area. From there, students can write their goals based on real data.
|Using Excel to Graph Data|
|Using Color Coding in Excel|
Here is a link to the Excel spreadsheet. Hope you find it helpful.