Sign in: bit.ly/2019registrar | Open this Worksheet: bit.ly/2lovesheets

Learn to Love Sheets

There are so many features built into Google Sheets that it can become overwhelming to know which are most beneficial for teachers in their day-to-day. Here we will cover many of the most common and handy sheets features!

Using Sheets to Manage & Manipulate Data

Spreadsheets are used to collect data. You can manually enter data into a spreadsheet or get data through the use of Google Forms. Knowing how to manipulate the data and extract or summarize important information are a few essential skills.

  1. Access the Spreadsheet and complete the Activities

Let's Review

  • Expand & Move Columns
  • Select All
  • Freeze Row
  • Sort
  • Filter
  • Split & Concatenate
  • Conditional Formatting
  • Explore Tool
  • Graphs
  • Auto Average & Sum

Try this! Using Charts from Sheets to create a Report in Docs

Data is analyzed and then shared to ‘tell a story.’ Graphs can be inserted into Google Sites & Documents to become part of that story. In this challenge activity you are preparing a report for your administration and want to persuade them with data using an embedded graph.

  1. Open Google Drive
  2. Create a folder called Digital Citizenship
  3. Create a Document called DC Scores
  4. Insert a chart into this document:
    1. Select INSERT
    2. Choose CHART
      1. FROM SHEETS
      2. Select one of your charts

Using Pivot Tables

Data is often represented in spreadsheets. Making tables and graphs that summarize, average or tally specific targets can be invaluable to help in the decision & planning processes. Here we will make 'pivot tables' using large data sets.

Making Sense of Large Data Sets

Beyond creating charts and graphs from data in sheets you can create ‘mini tables’ called ‘Pivot Tables.’ If you have 5000 students listed in a spreadsheet with names, grade, sports, town, etc. You can ask Pivot tables to extract and tell you things like ‘How many freshman students play each sport and break it down to see how many females and males are enrolled in each activity.’

  1. Open this spreadsheet of ‘student scores. https://goo.gl/xuO57g
  2. Practice creating a pivot table by following the directions.
  3. Create a filter to view only two years and two or three schools
  4. Create a Radar Chart to compare the data.

More Conditional Formatting:

  1. Open the Conditional Formatting Spreadsheet https://goo.gl/NL9bB4
  2. Go through each sheet & practice