Create a student tracker in Google Sheets

Transform your student tracking process with this detailed Google Sheets tutorial! Learn how to use powerful formulas, including QUERY, and implement error checks to create a professional and easy-to-use tracker for your classroom.
You’ll Learn how to build the Foundation with step-by-step instructions on setting up your own Google Sheet for student tracking.
Learn how to use the QUERY Function and efficiently filter and organise your data. Implement an Error Checks so everything looks great and is easy to use at your school.
See how you can customising my downloadable tracker giving you tips and tricks to adapt the tracker to fit your school and class requirements.
By the end of this tutorial, you’ll have a solid student tracker that I've used successfully for 2 whole school years that is not only functional but also visually polished. Plus, I’ll provide a downloadable template that you can tweak and share with fellow teachers to make tracking student progress a breeze.
The link to download this resource and others is: resources.seth...
Feel free to share the resource link with anyone interested.
💚💚💚
Thank you all our Channel members! If you'd like to become a member as well follow this link:
/ @flippedclassroomtutor...
Or support us on Patreon here: / eduflip
💚💚💚
SERVICES AND SOFTWARE I USE DAILY:
🔵 BEST screen recorder with video editing: sethideclercq....
🔵Web hosting with 20% OFF: sethideclercq....
Amazing screenshots: sethideclercq/Snagit
Screenshots and GIFs: sethideclercq....
Courses: sethideclercq....
Email lists and newsletter: sethideclercq....
Website building: sethideclercq....
GEAR AND RESOURCES:
www.amazon.com....
kit.co/Flipped...
My TPT Store: www.teacherspa....
Disclaimer: Some of these links are affiliate links where I'll earn a small commission if you make a purchase at no additional cost to you. These videos have been made for educational purposes and all views or opinions expressed are my own.

[@atobve]

I was really waiting for this. Thank you Sethi, I'm definitely going to use it.

[@FlippedClassroomTutorials]

You're welcome 😊 Glad the timing of this video worked out for you!

[@farzadmf]

Thank you for the video, very nice walkthough!
Question: why are we using a query for single values (bands)?

[@FlippedClassroomTutorials]

I used the Query to future proof the sheet, so if I decide to add more data points later for example a Band for Students and a second for EAL students or Different Schemes (Our school uses Book band from Oxford Owl Tree, As well as the levelling for Monster Phonics Readers and others) If we ever wanted to add those in using the Query will let me adjust the range and still pull those in.

[@farzadmf]

Makes sense; thank you!

[@Vzr8181]

I love this but how can I implement the results ? My school uses level 1-4.

[@FlippedClassroomTutorials]

If you watch the video I walk you through all the steps in order to customise this report and build you own or tweak the one I share. That way you can change it to fit your school

[@randomguy0336]

I suck at google sheets, I'm trying to create a timestamp system that tracks when a cell changes. However, the changes aren't happening from me directly, I would be editing say cell A2, and A3 would change accordingly due to the formula I have in it (note A3 can change from multiple different cells). I can't seem to find a way to track when cell A3 changes in value, so if you could enlighten me I would appreciate it greatly.

[@FlippedClassroomTutorials]

This is possible with AppsScript but no function like this is available for as far as I'm aware. Happy to share more info on this but it does involve a rather Intermediate level of Coding.

[@FlippedClassroomTutorials]

To help I've tried to create this in basic AppsScript with Annotation that will hopefully help you to understand what is happening in the code: docs.google.com/spreadsheets/d/1a5iE07bLMfRfw9QQnQlA8oHXSfqvdfvnxwpFTAl2_sk/edit?usp=sharing