Slice and Dice Data Like a Ninja: Advanced Google Forms and Sheets

 Uncategorized  No Responses »
Jul 122022
 
Permalink: http://bit.ly/googlesheetsninja

Ninja icon

You’ve used Google Forms to quickly collect data. The automatic summaries and charts are great, but what’s next? How can you see beyond simple averages and totals to make better decisions and gain true insights? In this session we will learn more about some powerful features in Forms and Sheets like data validation, data filters, and pivot tables. We’ll also take a look at some useful add-ons that will allow you to do some amazing things for any classroom. Read more if you’d like to learn more, or follow along if you are in my session today! Continue reading »

Google Docs & Drive BBQ at Millard

 Uncategorized  No Responses »
Aug 062018
 

Permalink: bit.ly/GSuiteBBQ

G Suite BBQ Image

Thanks for joining us today to grill up some learning and knowledge with some basic G Suite Apps. I want to know what YOU want and need to learn, so let’s start off with a quick little Google Form. Please mark a few topics under each Google Tool that you would like to know more about and dig a little deeper into.

Google Docs & Drive BBQ Survey

For your reference down the road, please refer to a few helpful posts on my site on G Suite Tools:

URSA 2018 – Session Info and Resources

 Uncategorized  No Responses »
Jul 112018
 
Utah Rural Schools Association (URSA) logoThank you so much for joining me for one (or more) of my sessions at the 2018 URSA Conference. All of the presentation information, links and resources for my sessions are linked from this page (and from the URSA tab above). If you have any questions or comments during or after the conference, you can connect with me @sedcclint on Twitter or on my Facebook Page. Use the #URSA18 hashtag on Twitter to join the Conference conversation.
Wednesday, July 11
  • 3:40 pm: Slice and Dice Data Like a Ninja: Advanced Google Forms and Sheets, ED 339 
    • You’ve used Google Forms to quickly collect data. The automatic summaries and charts are great, but what’s next? How can you see beyond simple averages and totals to make better decisions and gain true insights? Join me to learn more about some powerful features in Forms and Sheets like data validation, data filters, and pivot tables. We’ll also take a look at some useful add-ons that will allow you to do some amazing things for any classroom.
Thursday, July 12
  • 11:35 am: Playground: LocoXtreme Robots & micro:bit, Sharwan Smith Student Center, Brian Head A & B (repeats)
  • 1:30 pm: Playground: LocoXtreme Robots & micro:bit, Sharwan Smith Student Center, Brian Head A & B (repeat)
Friday, July 13
  • 9:00 am: Reach the 4 C’s of 21st Century Learning with HyperDocs, GC 306
    • We all want our students to be creative, collaborative, communicators and critical thinkers, but are you enabling your students to learn this way? HyperDocs just might help get you there. HyperDocs are to worksheets as what Instagram is to passing notes in class. They are interactive, visually engaging Google Docs that allow students explore and engage in topics in depth, and at their own pace. Join me today to learn more about using and crafting HyperDocs for your students, and make the jump to hyperspace with your instruction!
  • 10:10 am: Keep It Together With Google Keep, GC 306
    • You may not have heard of Google Keep, but you NEED to know about it. Keep is an incredible and easy to use tool for organizing all of the bits of information busy educators tend to collect whenever, wherever, that always seems to get lost. Keep allows you to bring together notes, links, photos – really anything you can grab with your computer, tablet and phone! Beyond gathering and organizing your digital ‘stuff,’ you can share your notes, collaborate with others, set reminders… even drag-n-drop text and photos into your Google Docs! Join me today and make Google Keep an integral part of your daily workflow.

Google Drive Documents – URL Tricks for Teachers

 Uncategorized  No Responses »
Jul 072017
 

Below is my quick list of things you can do with your Google Docs, Slides & Sheet URLs. With any of these tricks, replace whatever follows the last ‘/’ of your document URL, which will follow the REALLY LONG unique document ID. For example:

https://docs.google.com/document/d/1TzmsjhO35cyQKw7BgRGbnlGrdGrZkZMH0QKtmcw47M/edit?usp=sharing

Replace whatever is in bold in your doc that follows that last ‘/’ with the following to do some cool things:

  • /copy – will prompt the user to create a copy of that Doc/Slides/Sheets doc. Your original isn’t touched, and they own the copy!
  • /preview – will bring up your Doc/Slides/Sheets in a new window, with no headers or menus – just the content.
  • /present – will open your Slide show in a new window, full screen ready to present, with no headers or menus

Am I missing any? I’ll add more as I remember or learn new ones!

Google Sheets – Your Swiss Army Knife of Google Drive Apps

 Uncategorized  No Responses »
Apr 092014
 
Permalink: http://goo.gl/2Aj0ll (lowercase L’s)
OnTrack Section #: 59500, Course #: 68585

Resources for our training today on Google Sheets: