110 likes | 218 Vues
Keep track of student mastery levels with StudentTracker by Jonathan Abbott. Enter data directly in the spreadsheet, customize grading scales, calculate mastery and more. Utilize Drag-and-drop PivotTables, Quick Filtering, and easy-to-read Histograms.
E N D
Be Simple, Do more: StudentTracker Jonathan Abbott jabbott@mit.edu
Raw Data • Enter directly in spreadsheet • Mark it 0,1,2,3, or 4 • Tip: • Absent = 0 for mastery • Excused = 0 for mastery • overwrite “Excused” for grade
Learning Goals • Calculate mastery for each learning goal. • You customize it.
Grading • Make custom scale (on grading sheet) • It does the lookup
[Just some of] What you get: % Mastery | Weighted Total Grade | Unit Mastery | Custom Grade
More of what you get: • Drag and drop PivotTables and PivotCharts • Quick Filtering • Easy to read Histograms
LastWords Use Time Wisely Keep It Simple