GCE L2 Unit 5 Reflection

 In Unit 5 I learned more about Sheets and ways that I can better organize data. I also was reminded of using conditional formatting, which I have used before but I haven't in a while. I also was reminded of good ways to formatively assess my students.

I am actually very excited to learn about the Pivot Table. Last week I helped the SPED Teacher create a Google Form to track accommodations that were used by teachers for students. I did not know how I was going to organize the data efficiently before learning about the Pivot Table. Now I am going to create a Pivot Table and sort by each student and then the sheet will tell me which accommodations were used on which date for each student. It will really be a lifesaver!

Comments

  1. Lissa BrunanSeptember 29, 2021 at 7:37 AM

    Amy, great reflection on Unit 5. Sheets is probably one of the apps with the biggest gap for users between USE and CAPABILITIES! I'm so glad you could use some conditional formatting and pivot tables to help analyze data. It makes it much easier. Personally I LOVE pivot tables. They were SO INTIMIDATING and I steered clear of them until I was forced to learn for my Level 2 certification. It took some getting used to, but now I'm mad I didn't learn it earlier. It saves me HOURS of trying to answer questions about my data that pivot tables can do with a couple clicks. Have fun continuing to explore and use this new knowledge!! BRAVO!

    ReplyDelete
  2. Tonya JesweakApril 3, 2022 at 8:16 AM

    Love this idea about the Pivot Table! I am a Special Education Teacher Consultant and am often asked by my local schools how to track the use of accommodations in the best way. Right now, they typically use their grading system and rely on the teachers to input whether they used an accommodation and what it is. So I like this idea very much about sending a form and then using the pivot tables for data. I work with a social worker who uses Boomerang for a small fee and it automatically sends google forms to teachers everyday and they take a few minutes to fill out the form each day. Lots to think about here! Thank you!

    ReplyDelete

Post a Comment

Popular posts from this blog

GCE L2 Units 1 & 2 Reflection

 A. I have learned some new ideas for Flipped Learning and Blended Learning. I am excited to do more with a hyperdoc. B. I think that this will be great for my 4th Grade National Park Research. I currently put links in my Google Classroom, however, with a hyperdoc it will all be in one place where the students can write notes directly on the doc. I think it will help with not having to move between multiple tabs and platforms. 
Read more

GCE L2 Units 3 & 4 Reflection

 In Units 3 and 4 I learned more about ways that I can utilize Google Calendar to make appointments. I also learned about better ways to connect with guardians (most of which I already use). Finally, I learned more about a few different extensions that I had not used before. One of the biggest takeaways is that this might be a better way to schedule Student-Led Conferences than what we are currently using (Signupgenius). I like that it automatically puts things on the Google Calendar which is what I use for all of my school and personal scheduling.  I also am really enjoying the extension Grammarly, I had heard about it before, but had not tried it. So far in this blog post it has helped me three times. :)
Read more

GCE L2 Units 6 & 7 Reflection

 In Units 6 and 7 I learned about some features that I didn't know about that I will need to do more research on. I am not fluent in adding videos and YouTube Creator Studio and it is really neat some of the options that they have. I also learned some great lesson ideas that I will be taking forward with me. I was really excited about the idea of a Choose Your Own Adventure Slide Deck. I have used interactive notebooks with Slides before for research and presenting information but this is another fun way to use it. I think I may use this with my 5th Graders this year. I am going to head to the library to check out some books to give them ideas for it. 
Read more