Assessment Data Tracker Template: Collect & Graph Data with this easy template!

Looking for a way to collect, track & chart assessment data across a semester or school year? This assessment data tracker makes standard mastery & progress monitoring a breeze, helping you plan lessons to target student needs. It has helped me during my National Board Certification process, IEP meetings, formal evaluations, student recommendations, data celebrations & more! 

This editable Google Sheet template has formulas built in to do all the work for you—just plug in your assessment scores throughout the year and watch the magic happen!

You will get a class-average for each assessment & easily track growth across assessments by subject, class period & individual students.  The period/subject sheets supply a master sheet so all your main data is in one place. Graphs are already created that automatically populate as you input data. I love using these graphs to celebrate growth with my students and impress my administrators. 

Perfect for any grade level and any subject, you can adjust it depending on who, how & what you teach. It works for any assessment data! The instructions sheet outlines exactly how to edit/adjust the template to fit your needs without messing up the formulas and how it’s set up. 

Includes 1 Google Sheet with 10 tabs: 

• 1 Master Sheet that holds the averages across all the “Period or Subject” tabbed sheets
• 1 Graph Sheet that has built out graphs that automatically populate as you add data to the “Period or Subject” tabbed sheets
• 7 “Period or Subject” tabbed sheets with formulas built in for a baseline assessment, 6 benchmark assessments, and 1 final assessment (if your have more or less assessments in the year or call them different things, the instructions explain what to do)
• 1 “Make a Copy” tabbed sheet with a template for you to make copies of if you need more