Google Sheets

-

Well - Google Sheets - not my favourite thing in the world to be honest! I find them very confusing. Working through the tasks today, and applying formulas for working out the average and the totals was okay - I could follow that. When the conditional formatting started I just found I was lost. When I was trying to apply a function to more than one row and I was dragging the blue corner down - all the numbers were changing so that they were all the same - time to stop, take a break and come back to it another time! I can create charts and put them on a separate sheet, also choose from the range of charts available. 

For the work I do in the leadership team looking at data my skills I have are okay - it is something I would like to become more proficient at but at the moment it's nowhere near the top of my to-do list :)





Analysing the blog posts from the archive was interesting - looking at the data it's easy to see the trends and add a narrative as to why these things happen. Data is a great tool to inform decision making.
I had a go at my first screencastify - no video this time - this is something I can see being really useful in teaching year1 and new entrants as they can listen to a familiar voice and not be limited by reading ability.
 

Comments

Post a Comment

Popular posts from this blog

Week 9: Revision

-
Image
 Google Educator Exam Well actually getting into the exam was the hardest part - okay maybe not but totally the most frustrating part! Once in though I had a much more relaxed approach to this exam than the last one. I'm sure there were mistakes made but the process of going through the scenarios and filtering out the definitely not answers in the multiple-choice section was good. Reflecting on the past term I know I have learnt an awful lot of new information, consolidated a lot and now understand a lot more about the why of the Learn Create Share and actually everything we do in the New Entrants and Year 1 area impacts so dramatically (as with all learning) but if we can set up good Kawa of care, cyber smart behaviour and respect for the technology from day dot then our kids have a much better chance of turbocharging their learning.  I now feel that all 1:1 teachers should do DFI - not suggesting that is what I am going to do but would feel a lot more confident integrating a...
Read more

Week 5 Collaboration - Is the learning visible or not?

-
Image
 I really enjoyed today learning about the pedagogy behind the learning sites - is the learning visible or not? A really simple question and one that I have used to look at our existing learning site. The answer - not all learning is visible and this is probably due to a number of factors - none of which are irreversible!  Great to hear about the behavioural engagement with the site and also the cognitive engagement - will the children be attracted to the site and want to engage with it?  Will the content keep them there and challenge them, support them and enhance their learning?  I had previously used the multimodal text approach with year 3 and 4's - now being back with New Entrant and Year 1 children it was so useful to talk through with Latham about how to transfer that to very early reading. Of course so much easier when someone who has used it gives you examples that have worked in the classroom! So below is my addition to the multimodal spreadsheet using a bo...
Read more

Week 3 - Media

-
Image
Another day full of new learning for me! I use slides a lot for planning and previously have used them with older children on iPads for learning.  Today has reinspired me to use them with our Year 1 and New Entrant children. Taking part in the levelling up about slides, and also the Create Slides workshop in the afternoon was great. It was good to hear how other people use slides and also some tips and tricks like the Command D to duplicate rather than having to go to the drop-down menu. Also to group objects and use an image for a background on the slide that cannot be moved by the children whilst they are completing their activities.  I created some slides to use with my maths workshop children next week which I have included a screenshot of here - a total copy of the apple tree in the video - but we all have to start somewhere! Subtraction slides The only moveable items on the slide are the apples. I did not put any equations on the slides because we will use them multiple ...
Read more