BEYOND

THE

BASICS

COURSE AGENDA

Google Sheets is the Google version of Microsoft Excel and is not merely for math and numbers! Google Sheets is a powerful tool that can be used by teachers and students in all subject areas to organize and analyze information and data. This course is designed to explore and demonstrate how you can go beyond the basics in Google Sheets to use it as a tool to increase effectiveness and efficiency. This course will provide explicit instruction in using Google Sheets to organize, analyze, formulate, visually enhance, and use data for other tasks. This course will also provide an introduction to some add-ons and access to other resources for creative uses of Google Sheets.

CMCSSinstructionaltechnology

CLEAR TARGETS

I can create a Google Sheet that includes..

1. Data organization

2. Application of formulas and functions

3. Graphic representations of data

GET READY...GET SET

Complete the questions under each colunt on the Padlet below...just follow the instructions to get your brain stretched and ready!

During the remaining time, look over the infographic below.

GOOGLE SHEETS is Google's equivalent to Microsoft Excel.

There are many similarities between the two and some differences as well.

In regards to FUNCTIONALITY, both are exceptional tools for organizing, manipulating, and analyzing data.

OPEN THESE IN SEPARATE TABS IN GOOGLE CHROME

BUILDING A GOOGLE SHEETS WORKBOOK THAT INCLUDES THESE FEATURES

* Starting from a template

* Inserting rows/columns

* Formatting sheet

* Using find and replace

* Adding/renaming sheets inside workbook

* Preset and manually entered formulas

* Basic functions

* Generated charts/graphs of data

THE HAND OFF...

Follow these steps to create and share a NEW Google Sheet that includes these advanced features.

Open a new, blank Google Sheet.
Add at least the following 2 tabs to this, turning it into a “workbook.”
- Data
- Charts/Graphs
Include at least 3 columns of data with header rows on the “Data” tab.
Use at least 2 different types of formulas on the “Data” tab.
Use at least 1 type of function on the “Data” tab.
Use data from the “Data” tab to create at least 2 different types of charts/graphs on the “Charts/Graphs” page.
Share the link to workbook you created as you complete this Google Sheets: Beyond the Basics Wrap Up Survey

****CLEAR TARGET IS REVISITED IN THE PARTICIPANT’S COMPLETION OF THE WRAP-UP FORM!!!****

REVIEW

3 Ws Strategy

WHAT was learned?

Or something NEW you learned today?

So WHAT ?

- Relevance
- Importance
- Usefulness

Now WHAT?

Next steps
Actionable goals

COMPLETE THIS

EXTRA RESOURCES FOR LATER

GOOGLE SHEETS VIDEO TUTORIAL

by Stephen Kwiecinski from Digital Media Pocketknife on YouTube

This video tutorial explains:

What a Google sheet is/looks like.
How to create, use, and modify a Google Sheet.
How to enhance a Google Sheet.

THE BASICS OF GOOGLE SHEETS FOR STUDENTS AND TEACHERS (Video)

by Technology Teacher from BV Tech Tutorials on YouTube

This video tutorial explains:

Creating tables and formulas.
How make charts and graphs.
How to use basic formulas.

FORMULAS IN GOOGLE SHEETS

FUNCTIONS IN GOOGLE SHEETS

Retrieved from G Suite Learning Center

CREATING CHARTS AND GRAPHS IN GOOGLE SHEETS

This video explains how to make a chart or graph inside Google Sheets.

IN-APP HELP FEATURES

WHERE TO FIND HELP: How to find/access the GSuite Help Center for Google Sheets inside the App

WHAT HELP LOOKS LIKE: The Help Menu for Google Sheets - NOTE: It is searchable by keyword!!!

PIVOT TABLES

"Pivot tables help you summarize data, find patterns, and reorganize information. You can add pivot tables based on suggestions in Google Sheets or create them manually. After you create a pivot table, you can add and move data, add a filter, drill down to see details about a calculation, and more. Note: Pivot tables refresh any time you change the source data."

Click here for instructions for creating/using pivot tables from G Suite for Learning.

RECENT UPDATES TO GOOGLE SHEETS

From G SUITE UPDATES BLOG: (<--CLICK ON THIS LINK)

Record macros in Sheets, skip mundane tasks (video tutorial)
New chart types (waterfall and 3D)
How-to embed charts while keeping data up-to-date in Docs and Slides (even if you move files),
More functions (up to 400+ now)
Additional formatting, print options, and more
Addition of requested features
- ability to add printing page breaks, custom paper sizes,
- more options for row and column grouping
- a way to add checkboxes in cells.
Group your data by time frame (like week, month or year) when you create pivot tables.
Bring the power of Google’s artificial intelligence into Sheets to help teams know what their data knows. (with intelligent pivot tables to help analyze and find new insights, no matter how skilled you are at data analytics).

ADD-ONS FOR GOOGLE SHEETS (third-party):

Translate My Sheet

This add-on can translate data instantly. Either choose the source and target languages or have it auto detect the source. It can then translate your whole sheet or a selection automatically, with the new text showing up in seconds.

Autocrat

Automate the creation and sharing of personalized documents with autoCrat, a multi-purpose document merge tool that allows you to take data from a spreadsheet and merge it into a document by telling it which field to merge and then let it mass-generate personalized documents. Optionally, send documents as email attachments and/or tell it to run when new forms are submitted to create truly automated processes. (How-to video)

Knoema Data Finder

Find detailed statistics on population, crime statistics, exports, land use, and other academic topics using a sidebar to search through and import data on these and dozens of other topics from governments and industry sources around the globe. Knoema will insert a table of the data into your spreadsheet.

Flippity

Easily turn a spreadsheet into a set of online flashcards, quiz show, random selector, mix/match activity and more.

Buzz-in

Free version will allow you to create a buzzer/clicker great for use in the classroom for games and even allow you to see who clicked first.

formMule

Send targeted, personalized emails from a Google Sheet as either a manual email merge.

Split Names

Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters.

Save as Doc

Convert any Google Sheets spreadsheet into a Google Document for improved legibility of lengthy cell text entries.

Flubaroo

Flubaroo helps you quickly grade and analyze online assignments and assessments, as well as instantly share scores with students!

Template Gallery

Save time by using professionally designed documents and spreadsheet templates created by Vertex42.com.

Sort by Color

Sort your color-coded spreadsheet by CELL COLOR or FONT COLOR.

Online Rubric

Create and send customizable rubrics and scores to students by email for any assignment.

Power Tools

Set of tools for daily tasks: change case; sum by color; remove duplicates; split, merge, compare, find, clean up data and more.

More Fonts

You need more than the 6 default fonts to make your spreadsheets amazing! Here you go, 35 of the most requested fonts.

Doctopus

An octopus for docs! Teacher-built tool for scaffolding, managing, organizing, and assessing student projects in Google Drive.

OTHER VALUABLE RESOURCES:

Google for Education Training Center: Google Sheets - includes training lessons for various Google Sheets topics

Google Docs Editors Help Center: Google Sheets - includes information about using, creating, and working with Google Sheets

G Suite Learning Center: Google Sheets Guide - includes guides for those brand new to Google Sheets, refreshers and instructions for users who need it, and tips for using some of the more advanced features.

Google Sheets 101: The Beginner's Guide to Online Spreadsheets by Michael Grubbs-GREAT guide to many of features of Google Sheets with diagrammed screenshots

Spreadsheet Activities for All Subjects by Eric Curts, creator of Control Alt Achieve: Transforming Education with Technology

Google Sheets Educator Templates created/coded by Alice Keeler, creator of Teacher Tech- You can get your own copy of each.

Google Sheets: Spreadsheet Settings created by Alice Keeler, creator of Teacher Tech

The Definitive Guide to Google Sheets by Hiver, "a small team, solving a large problem for a huge number of businesses"

Advanced Formulas 30 Day Challenge by Ben Collins, creator of the "Collins School of Data" - This course is intended for intermediate level users of Google Sheets, who want to become more comfortable with advanced formulas and unlock the full potential of their data (FREE COURSE as of May 2018)