Teacher Tech

Paperless Is Not A Pedagogy

Menu
  • Teacher
    • Blog Posts
    • Teacher Tech Facebook Group
  • Google Certified Innovator
    • CoffeeEDU
    • Tour of Google Classroom
    • Back to Classroom
  • Author
    • Alice Keeler Books on Amazon
    • Bulk Order Books
  • Developer
    • Schoolytics
    • Google Developer Expert
    • Add-ons By Alice Keeler
      • Doc to Slides by Alice Keeler
      • Roster Extras by Schoolytics
      • TemplateTab
      • toTabs
      • Form Printer
      • Quiz Helper
      • Dice Slides by Alice Keeler
      • Scheduler by Alice Keeler
      • Document Outline by Alice Keeler
      • Missing From (Google Forms™)
      • Randomize Slides by Alice Keeler
      • Speaker Notes by Alice Keeler
      • sheetPusher
      • Seating Chart Slides
      • Hyperlink Slides Choice Board
      • Add-a-Date
      • QuickShare Screenshot
      • Anyone Can View
      • Drive 20
    • Apps Script Tutorials
    • Templates
  • EdTech Coach
    • Premium Membership
    • Free Newsletter
  • Hire Alice
Menu
Create a google sheets template for the new york times graph

Create a What Do You Notice Google Sheets

Posted on October 10, 2018May 11, 2021 by Alice Keeler

Create a google sheets template for the new york times graph

Use Google Sheets to Guide Class Analysis

Every week the New York Times is providing a graph for teachers to use with their students. Using this free activity you can easily include ANALYZE into your lesson plans. The problem with a class discussion can be that not all students can participate in each prompt. “What do you think is going on here” would most likely not be accomplished by going around the room and hearing from each student. Using a spreadsheet or other digital tool can allow all students time to think, to include their observations, and to learn from the observations of everyone in the class. Below are directions on how to create the spreadsheet.

These observations are based on the October 3rd graph.

October 10, 2018 Graph

This week’s graph from the New York Times:
FastFoodLN-superJumbo NYT

I have been doing these graphs with my students and I am loving the discussion. At first, it can start with blank stares and “I don’t knows.” By the end of the discussion, they are giving some insightful interpretations of the graph. I especially enjoyed last weeks graph. Turns out my students have never heard of a Supreme court justice. Nor did they know what a conservative or a liberal meant. Giving a quick definition, I then asked them “Now what do you see in the graph?” Their ability to interpret the graph after a quick definition of conservative impressed me.

Create a Google Spreadsheet

Either go to Google Drive and start a new spreadsheet or go to https://sheets.google.com/create

Select the Awesome Box

In the upper left hand corner of the grid is the awesome box. This is to the left of the column indicator A and above the row indicator 1. Clicking the awesome box selects all.
Click the awesome box

Widen Any Column

You can adjust the width of ANY column and all columns will adjust the same. Hover your mouse between any two column indicators. The mouse will change from the pointer arrow to a sideways dark arrow.
Widen the columns

Widen Any Row

Similarly, widen any row to make all the rows taller. Hover your mouse between any 2 row indicators, the arrow should change style. Hold down and drag the height of the row. Widen the rows

Set Word Wrap

I like to say “Middle, Middle, Middle.” In the toolbar locate the centering icon. You want to center the text of all the cells horizontally and vertically. Then you want to set word wrap on the entire sheet.
Center the spreadsheet      Word wrap

Name the Tab

Double click on the tab at the bottom to name it “Notice.”
What do you notice

Duplicate the Tab

Now your spreadsheet is all set up, don’t recreate the wheel. You will want a copy of the sheet for each question prompt. Click on the tiny triangle on the tab and choose “Duplicate.”
Duplicate the tab

Rename the Tab

Double click on the new tab to rename it to “Wonder.”

Duplicate Again

Click on the tiny triangle on the tab to duplicate the tab to make a 3rd tab. Double click on that tab to rename it to “Headline.” The prompt in the NY Times asks the students to create a headline based on their inferences from the graph.

Share

After creating your spreadsheet, share it with students so they have edit access. You can do this through Google Classroom or by modifying the sharing permissions and linking the students to the spreadsheet.

Display

Display the graph. Verbally, ask the prompt “What do you notice is going on in the graph?” Instead of students raising their hand and shouting out, have them put their response in the spreadsheet. Display the spreadsheet showing the students all inputting their answers. Engage the class in verbal discussion about the responses. “What else can we observe about that?” “What do you think that means?”

Ask students to move onto the next tab in the spreadsheet and indicate things they wonder about the graph. Have the students discuss and respond to the ponderings.

Finally, ask the students to go onto the 3rd tab and write a headline that they think would go along with the graph. Discuss the headlines together.

Template

If you would like to use my spreadsheet I already made here is the template.




A Game-Changing Approach to a Back to School Syllabus by @MeehanEDU

Related

Related Alice Keeler Blog Posts:

  1. Automagically Create a Spiral Warm Up
  2. Google Slides: First Slide – Fast Feedback for a Daily Journal
  3. Easy Peasy Color Code Your Spreadsheet
  4. Google Sheets: Text to Columns in a spreadsheet

Continue Reading

Next Post:
Find Class Comments in Google Classroom
Previous Post:
Google Classroom Student Chooser Feature

2 thoughts on “Create a What Do You Notice Google Sheets”

  1. Pingback: Create an Infographics Report Card - Teacher Tech
  2. Pingback: Create an Infographics Report Card – Dinezh.com

Leave a Reply Cancel reply

You must be logged in to post a comment.

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Alice Keeler is a mom of 5. Current High School math teacher. Developer for Schoolytics.com. Google Certified Innovator, Microsoft Innovative Educator, Google Cloud Innovator Champion, and Google Developer Expert. Founder of #coffeeEDU
Teaching with Google Jamboard
Developer Schoolytics
Schoolytics is FREE for teachers.

Find ALL My Blog Posts


Link to List

Google Classroom Books

Alice Keeler: Mom of 5. Current High School math teacher. Developer for Schoolytics. Founder #coffeeEDU. Google Certified Innovator. Microsoft Innovative Educator. Google Developer Expert. EdTech Specialist.

My Referral Links


Custom Stickers, Die Cut Stickers, Bumper Stickers - Sticker Mule

 

©2022 Teacher Tech | Theme by SuperbThemes