Learning Intentions & Success Criteria Assessment Tracker | Google Sheets
Take the guesswork out of formative assessment and visible learning with this comprehensive Learning Intentions & Success Criteria Assessment Tracker for Google Sheets! Built specifically for primary and secondary teachers, this analytical tool allows you to monitor student growth directly against explicit success criteria, record pre/post-assessment scores, and automatically calculate class mastery metrics in real time.
Whether you're facilitating explicit teaching cycles, gathering data for semester reports, or moderating work with your team, this tracker provides clear, objective evidence of student learning.
📥 WHAT’S INCLUDED?
-
🎯 Explicit Success Criteria Tracker: Pre-built Google Sheets template featuring:
📝 Learning Intentions ("We are learning to...") organized across units or terms.
✅ Interactive Checkboxes to record success criteria mastery for individual students.
📊 Auto-Calculated Class Average Mastery Percentages for each success criterion.
📈 Pre-Assessment, Classwork & Post-Assessment Score Columns to track distance travelled and overall growth.
👤 Individual Student Average Mastery Indicators updated automatically.
📋 Setup & User Guide: Quick steps to customize learning goals, edit criteria, and manage student rosters.
✨ KEY FEATURES & BENEFITS
📊 Automated Growth Analytics: Built-in formulas calculate overall student averages and whole-class mastery percentages as soon as you check off criteria.
🎯 Visible Learning Alignment: Directly links daily assessment to explicit learning intentions and success criteria for targeted feedback and differentiation.
💡 Evidence-Based Reporting: Provides clear, visual evidence of student achievement to streamline report writing, parent-teacher interviews, and IEP meetings.
📱 Multi-Device Compatibility: Assess on the go using your laptop, iPad, or tablet during guided groups and walking observations.
♾️ 100% Customisable & Reusable: Easily update subjects, criteria, and class lists to use across any learning area, term, or year level.
📂 FILE FORMAT
💡 PLEASE NOTE
