Search this site
EdTech Ideas for Teachers
  • Home
  • CV
  • My Blog
  • EdTech and Marzano
  • Google Docs
    • Spreadsheets
  • Google Docs 101
  • LJA Classroom Ideas
  • Web Tools
  • Workshops
    • #MWGS Be an explorer with Google's geo tools
    • #MWGS Google Drive Add-ons to take home to Mom
    • #MWGS Make and Take - Organizing Information using Graphic Organizers & Lucidchart
    • #TIES13 Chrome & Chromebooks
    • #TIES13 Google Drive Add-ons to Take Back to School
    • #TIES13 Interactive Mapping Tools to Connect Content
    • Apple & Google = Peanut Butter & Jelly | 2:30-3:15
    • Be an Explorer with Google Geo Tools
    • BestPrep TIW
    • Chrome and Chromebooks for BestBrep
    • Chrome and Chromebooks TIES 13
    • Chrome and Google Apps in your Classroom
    • EdTech Moving A District
    • Face to Face Academy
    • Flipped Lesson
    • Formative Assessments using InfuseLearning.com
    • Getting Started with YouTube & Your YouTube Channel
    • Google Apps I
    • Google Drive Add-ons to Take Home to Mom
    • Interactive Graphic Organizers - MN Google Summit
    • iPads in Secondary Classroom
    • iSummit2014
    • Leverage Google Scripts as a classroom teacher
    • LJA Google Sites and more..
      • Embed Documents
    • Maps to Create, Explore...and Learn | 11:30-12:15
    • Maps! Maps! Maps!
    • MASBO 2014 - Digital Communication
    • MASBO Conference - Productivity and Collaboration through Technology
    • Meraki: Free Mobile Device Manager for iOS, Android, Windows, OSx
    • Pierz Gmail, Calendar, Docs
    • Slamdunk Gmail, Calendar, Docs
    • Student & Teacher Creation with Chromebooks and Google Apps - Face to Face Academy
    • SWWC Chrome Make the Internet Work for You | 10:30-11:15
    • TechXploration: Google Apps
    • TIES 2012 Maps You Can't Teach Without
    • TIES2012 Chrome: Make the Internet Work for You
      • My Chrome Add-ons
    • TIW2013
    • Using Video in Your Classroom: Record and Share Student Learning
    • YouTube and other meaningful content #TIW2013
  • YouTube for Educators
EdTech Ideas for Teachers
  • Home
  • CV
  • My Blog
  • EdTech and Marzano
  • Google Docs
    • Spreadsheets
  • Google Docs 101
  • LJA Classroom Ideas
  • Web Tools
  • Workshops
    • #MWGS Be an explorer with Google's geo tools
    • #MWGS Google Drive Add-ons to take home to Mom
    • #MWGS Make and Take - Organizing Information using Graphic Organizers & Lucidchart
    • #TIES13 Chrome & Chromebooks
    • #TIES13 Google Drive Add-ons to Take Back to School
    • #TIES13 Interactive Mapping Tools to Connect Content
    • Apple & Google = Peanut Butter & Jelly | 2:30-3:15
    • Be an Explorer with Google Geo Tools
    • BestPrep TIW
    • Chrome and Chromebooks for BestBrep
    • Chrome and Chromebooks TIES 13
    • Chrome and Google Apps in your Classroom
    • EdTech Moving A District
    • Face to Face Academy
    • Flipped Lesson
    • Formative Assessments using InfuseLearning.com
    • Getting Started with YouTube & Your YouTube Channel
    • Google Apps I
    • Google Drive Add-ons to Take Home to Mom
    • Interactive Graphic Organizers - MN Google Summit
    • iPads in Secondary Classroom
    • iSummit2014
    • Leverage Google Scripts as a classroom teacher
    • LJA Google Sites and more..
      • Embed Documents
    • Maps to Create, Explore...and Learn | 11:30-12:15
    • Maps! Maps! Maps!
    • MASBO 2014 - Digital Communication
    • MASBO Conference - Productivity and Collaboration through Technology
    • Meraki: Free Mobile Device Manager for iOS, Android, Windows, OSx
    • Pierz Gmail, Calendar, Docs
    • Slamdunk Gmail, Calendar, Docs
    • Student & Teacher Creation with Chromebooks and Google Apps - Face to Face Academy
    • SWWC Chrome Make the Internet Work for You | 10:30-11:15
    • TechXploration: Google Apps
    • TIES 2012 Maps You Can't Teach Without
    • TIES2012 Chrome: Make the Internet Work for You
      • My Chrome Add-ons
    • TIW2013
    • Using Video in Your Classroom: Record and Share Student Learning
    • YouTube and other meaningful content #TIW2013
  • YouTube for Educators
  • More
    • Home
    • CV
    • My Blog
    • EdTech and Marzano
    • Google Docs
      • Spreadsheets
    • Google Docs 101
    • LJA Classroom Ideas
    • Web Tools
    • Workshops
      • #MWGS Be an explorer with Google's geo tools
      • #MWGS Google Drive Add-ons to take home to Mom
      • #MWGS Make and Take - Organizing Information using Graphic Organizers & Lucidchart
      • #TIES13 Chrome & Chromebooks
      • #TIES13 Google Drive Add-ons to Take Back to School
      • #TIES13 Interactive Mapping Tools to Connect Content
      • Apple & Google = Peanut Butter & Jelly | 2:30-3:15
      • Be an Explorer with Google Geo Tools
      • BestPrep TIW
      • Chrome and Chromebooks for BestBrep
      • Chrome and Chromebooks TIES 13
      • Chrome and Google Apps in your Classroom
      • EdTech Moving A District
      • Face to Face Academy
      • Flipped Lesson
      • Formative Assessments using InfuseLearning.com
      • Getting Started with YouTube & Your YouTube Channel
      • Google Apps I
      • Google Drive Add-ons to Take Home to Mom
      • Interactive Graphic Organizers - MN Google Summit
      • iPads in Secondary Classroom
      • iSummit2014
      • Leverage Google Scripts as a classroom teacher
      • LJA Google Sites and more..
        • Embed Documents
      • Maps to Create, Explore...and Learn | 11:30-12:15
      • Maps! Maps! Maps!
      • MASBO 2014 - Digital Communication
      • MASBO Conference - Productivity and Collaboration through Technology
      • Meraki: Free Mobile Device Manager for iOS, Android, Windows, OSx
      • Pierz Gmail, Calendar, Docs
      • Slamdunk Gmail, Calendar, Docs
      • Student & Teacher Creation with Chromebooks and Google Apps - Face to Face Academy
      • SWWC Chrome Make the Internet Work for You | 10:30-11:15
      • TechXploration: Google Apps
      • TIES 2012 Maps You Can't Teach Without
      • TIES2012 Chrome: Make the Internet Work for You
        • My Chrome Add-ons
      • TIW2013
      • Using Video in Your Classroom: Record and Share Student Learning
      • YouTube and other meaningful content #TIW2013
    • YouTube for Educators

Spreadsheets

Activity #1

Summer 2012

Activity #2: Create a quiz for your class

Google Form Question Types Explained

79 Interesting Ways to Us...le Forms in the Classroom

Templates

Spreadsheets

Forms

Kern Kelly's Templates

By Tom Barrett thomasgeorgebarrett@gmail.com

Scripts

*The DO Part...*

Create a Choose Your Own Adventure quiz or story

Advanced Functions

=COUNTIF(range, criteria)

=CONCATENATE(text_1, text_2, ..., text_30)=COUNTBLANK(range)

Links

Spreadsheet Basics

Using Google Forms

Complete list of Google Spreadsheet functions

Google Certified Teachers: Google Docs Resources

Survey at the end

Automatically grade Google Forms

Flubaroo

Demo Spreadsheet - Basics of spreadsheets

Spreadsheet Magic

Report abuse
Page details
Page updated
Google Sites
Report abuse