DFI Session 4 Thursday 28th May 2020

Great session this week. Found out lots of new features in Spreadsheets that would be great for students and my personal use for planning and organising data. Loads of new skills in the following areas: 

Hapara Hot Tips: 
(How to manage view and navigate viewing students work)

• Use the search to locate anything within students drives 
• Creating new groups and filtering to see specific groups
• Adjusting how many documents you see in view
• Need to reset to show recent changes 
• Reordering students in your view (who do you want to see) 

This will make it super easier for me to view and comment on students work quicker. 

Forms: 

• Suggestions to start with a blank form
• Selecting different question and answer types 
• Using different features including images, instructions, videos, created videos. 
• Sections = A new page 
• Customise your own Theme
• Settings to lock individuals in (no searching) 
• Access to public 
• Record confirmation/thank you message
• Option to export responses to a spreadsheet
• Sending form via email/link 

Lockdown Survey Form

This would be great for collecting student voice/data 

Google My Maps: 

• Mymaps.google.com
• Drive - Create from here
• Set default view - so people go to a particular place
• Add Marker - Adds a place
• Students not to add their house number
• Add location/image/title 
• Add layer/import information
• Measuring distance from one place to another 

Google My maps was a little confusing, I will need to explore this a little further and get use to the features.  I would need to find more ways that I could utilise this in my classroom or class site. 

Google Sheets: 

• Well thought out and well-designed spreadsheets are easier to use 
• Freeze columns in place when scrolling: View>freeze>columns & rows
• Highlight and change text direction for larger texts 
• Calculating the average 
• Using Autofill by highlighting and dragging - first 3 numbers in sequence 
• Data validation - list of items in a dropdown box 
• Inserting checkboxes - highlighting and add

Sheets on Speed:

• Find average: Formula goes into the "Average" Cell 
• Drag the cell from the first found average to the last (to find average of all)
•  To Rank scores: Click into the cell and organise from a-z 
• "Interesting charts" create the easiest chart. Can go to "Explore" drag and drop ontop of the data. Dont mess with it, its machine marking :D 
• Move to own sheet "Click and choose "move to own sheet"

Spread Sheets/Analysing Data and Using Charts: 

• Blogging > Stats > Overview 
• Protecting cells and giving edit permissions to specific students 
• Looking at the amount of views 
• Audience - Where are the viewers coming from?
• Look at Blog Archives on the left hand side to explore