GCE L2 Unit 5 Reflection
a) In Unit 5 I learned how tools like google sheets and the different functions can help sort data, along with Google Forms and Classroom make a much more focused learning environment for students with excellent ways to provide feedback to students. I liked how Google Sheets can be a data tracking tool for myself when looking at student and assessment data, but I also gained a lot of ideas on how to use Sheets as a way to get student's involved while still being able to sort data for my own purposes.
b) I hope to use the "Conditional Formatting" and "Pivot Table" in my future google sheets, it is important to me to sort data in a structured way and I think this could be a great way for me to track student progress. I also see this linking up well with Google Forms, and have students take formative assessments using that tool- and combine it with their own google sheet so they can see clear feedback right away, and also track their learning.
Google SHEETS can really be one of the most powerful and useful tools, however, it can also be a little overwhelming! I'm glad you'll utilize conditional formatting and pivot tables to better analyze your data quickly. If you want someone great to follow in the world of Google Sheets, you should check out Ben Collins. He has a website, YouTube Channel and is on Twitter. I'd start with his website: https://www.benlcollins.com/! Have fun!
ReplyDeleteConditional formatting is truly my best friend! I use lots of Google Forms and instead of grading through Forms, I always use Sheets and conditionally format by color to easily see what is correct (green), incorrect (red), or partially correct (yellow). I also have played around with the color scale this year and it's been super helpful to see a more specific breakdown of student scores. With the scale, for example, it will have a range of greens, yellows, and reds for overall scores so I can see who is where. Plus, it is just so pretty to look at!
ReplyDelete