110 likes | 241 Views
Be Simple, Do more: Student Tracker. 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.
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