Create a student tracker in Google Sheets

[@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