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.
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.
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
* Basic functions
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
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."
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):
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.
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)
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.
Easily turn a spreadsheet into a set of online flashcards, quiz show, random selector, mix/match activity and more.
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.
Send targeted, personalized emails from a Google Sheet as either a manual email merge.
Quickly split full names to several columns with first, middle, last names, titles, and/or post-nominal letters.
Convert any Google Sheets spreadsheet into a Google Document for improved legibility of lengthy cell text entries.
Flubaroo helps you quickly grade and analyze online assignments and assessments, as well as instantly share scores with students!
Save time by using professionally designed documents and spreadsheet templates created by Vertex42.com.
Sort your color-coded spreadsheet by CELL COLOR or FONT COLOR.
Create and send customizable rubrics and scores to students by email for any assignment.
Set of tools for daily tasks: change case; sum by color; remove duplicates; split, merge, compare, find, clean up data and more.
You need more than the 6 default fonts to make your spreadsheets amazing! Here you go, 35 of the most requested fonts.
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)