I created this excel spreadsheet using MS Office 365 to track student progress for data meetings. It was designed specifically for CER writing assignments in my science courses which are graded using a rubric, but the formulas are written in such a way that it can adjust to any point based scale. When you input data in the “Data” sheet it will automatically populate the “Analysis” sheet. The “Data” sheet calculates the individual growth for each student as well as the composite median for the ba