Tracking Student Data in Google Sheets Part 2: Individual Student Data Sheets

In my first Tracking Data with Google Sheets video I walk you through setting up the spreadsheet to auto-calculate student percentages and averages, and conditional formatting to color code based on student mastery. In this Part 2 Google Sheets video, I walk you through using formulas to create individual student reporting pages based on your inputted data.

This Google Sheets video tutorial walks through pulling information from cells in another tab or sheet, adding graphs, and using the find and replace tool to duplicate the work simply and easily.

These individual student reporting pages are perfect for data conversations. They are easy to use for RtI or MTSS meetings, parent-conferences, or your PLC meetings.

Want to save yourself time? Grab my free, easy to use templates!
Individual test assessment tracker: https://docs.google.com/spreadsheets/...

Are you a 1st grade, 2nd grade, 3rd grade, or 4th grade teacher looking to track your math data? I've got you covered! Download your Standard-by-Standard Math Tracking Spreadsheet here: https://www.talesfromoutsidetheclassr...