Are you tired of writing DSA scores by hand for lots of students every semester/year? And then you have to turn around and enter it again into the Class Record? Then this spreadsheet is for you!
I've designed this for a departmentalized classroom with 25 students in Group A and 25 students in Group B. Inside is a single Excel spreadsheet with multiple tabs including one Class Record, one Student Profile Template, and 50 Student Profile tabs for entering scores from their DSAs. The Profile charts automatically calculate your Stage Knowledge and Total Inventory Knowledge while you type! And then - get this - all of your data for each of your kiddos is automatically populated into the Class Record! What's that you say? Yes, you only have to enter your scores one time. Yay!
If you only need charts for one group of kiddos, you may delete the "B" tabs by right clicking on the tabs and deleting them. The formulas in the Class Record are set up for the two A/B groups. I wouldn't recommend adding more tabs because they will not show up in the Class Record, unless you manually add them. If you need to add more tabs for more students, please let me know and I'll endeavor to help you through the process or will email a new version if time permits.