http://bit.ly/CMCSSinstructionaltechnology

THE HAND OFF...

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

1. Open a new, blank Google Sheet.

2. Add at least the following 2 tabs to this, turning it into a “workbook.”

   • Data

   • Charts/Graphs

3. Include at least 3 columns of data with header rows on the “Data” tab.

4. Use at least 2 different types of formulas on the “Data” tab.

5. Use at least 1 type of function on the “Data” tab.

6. Use data from the “Data” tab to create at least 2 different types of charts/graphs on the “Charts/Graphs” page.

7. 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!!!****

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).

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)