Learn more about Sheets

• Taxonomy Activity- Use for ANY subject!

• Conferences

  • • Field Trips

    • Classroom Volunteers

    • Reading Buddies

Spreadsheets Resources

• Spreadsheets in the classroom

• Enter data into spreadsheets

• Share and collaborate with spreadsheet data

• Useful functions and formulas

• Manage your spreadsheet

• Analyze spreadsheet data

• Create and publish charts

Introduction to Spreadsheets in Google Docs

Skill level: Beginner

Lead by John Sowash, Derrick Wlodarz, Google Apps for Education Certified Trainers

Got Data? Then you need to be using Google Docs Spreadsheet! This tool allows you to collect and use data in interesting and helpful ways. The built in collaborative features of Google Docs allows multiple users to view and edit spreadsheets simultaneously.

This introductory session will cover the basics about spreadsheets:- Entering and manipulating data-

• Creating multiple sheets within a workbook

• Using data to generate charts and graphs

• Using forms to collect data

• Sharing spreadsheets with others

Slide presentation

Transcript

Overview of Spreadsheets

Enter data into spreadsheets

Edit a cell

Change cell data type

Copy and paste

Add links in a spreadsheet

Add images in a spreadsheet

Repeat or extend patterns with auto-fill

Keyboard Shortcuts

Share and collaborate with spreadsheet data

View and edit spreadsheets together

Prevent others from editing the same cell

Chat with other collaborators

Prevent others from editing specific sheets

Stay informed when others modify a spreadsheet

Ensure entered data is the right format

Activity #1: Creating, Sharing, and Uploading

• Create a spreadsheet with the following column headers:

  • Name

  • Favorite vacation spot

    • Approximate # of miles from Blake to vacation spot

    • Approximate time to reach destination on the highway

• Enter the data in row 1 including:

  • Your name

  • Favorite vacation spot

    • Approximate # of miles from Blake to vacation spot

• Rename the title of the document. The title should have your name. (e.g. My Favorite Vacation by Joe Smith)

  • Share the spreadhseet with your neighbor (on your right) with editing rights

• Upload an existing MS-Office Spreadsheet and Convert it to a Google Spreadsheet.

Useful functions and formulas

About formulas

Shortcuts for entering formulas

Quick sum

Import data from webpages

Translate text and detect language in cells

Split cell text into multiple cells

Combine text into a single cell

Activity #2: Privacy, Formulas, and Organization

• Open the Google Spreadsheet from your neighbor (on your left)

• Calculate the "Approximate time to reach destination on the highway"

• Enter the data in row 2 on your neighbor's spreadsheet including:

  • Your name

  • Favorite vacation spot

    • Approximate # of miles from Blake to vacation spot

• Extend the formula from Row 1 to Row 2.

• Share the document with your workshop leader and give them commenting rights.

• Compare the revision history.

  • Create a folder entitled "Google Docs Workshop by YOUR NAME" (e.g. Google Docs Workshop by Joe Smith)

  • Place all of the Google Docs from the workshop into the folder

Manage your spreadsheet

About sheets

Move or copy sheets

Hide sheets

Adjust rows and columns

Show, hide, and freeze rows and columns

Merge cells horizontally or vertically

Spreadsheet formatting and rules

Copy cell formatting with format painter

List view for simple spreadsheet display

Check spelling

Cell data validation

Doing more with Google Spreadsheets

Skill level: Intermediate/Advanced

Lead by Ronald Ho, Google Product Manager

In this webinar, we'll look at advanced spreadsheets features including new chart types, gadgets, and data validation. We'll also cover how to quickly grade self-grading quizzes with spreadsheet forms.

You'll come out of this seminar with a whole set of new tricks for the classroom!

Topics covered:- Charts -

• • Charts - help content for all chart types

    • Line chart

    • Use multiple chart ranges

    • Motion chart

    • Gauges

    • Annotated Timeline

    • Org Chart

    • Gadgets

    • Word Cloud template from Google Docs template gallery (gadget already embedded)

    • Tree map gadget template from Google Docs template gallery (gadget already embedded)

    • Fun stuff (for sharing at the dinner table)

    • Google sets for autofill - hold down ctrl on pc or alt on a mac

    • Google Finance

    • Google Translate

    • Tips & Tricks Ronald didn’t have time to share:

    • Hidden gridlines

    • new revisions history

    • In-cell drop downs

    • On the go spreadsheets

• Q&A transcript

• Features outline

Activity #3: Pivot Tables and Protecting your Data

• Open the Timesheet Template from the Google Docs Template Gallery

• Rename the title of the document. The title should have your name. (e.g. Timesheet Template by Joe Smith)

• Add a Pivot Table Report (Worksheet) on Time by Description

Scripts and Google Spreadsheets

Automating School Processes with Apps Scripts

Skill level: Intermediate

Lead by Dana Nguyen, Google Apps for Education

Listen to examples of how schools are creating workflows with forms, emails, calendars, and sites using Google Apps Scripts.

Create and publish charts

Create charts from spreadsheet data

Chart multiple ranges

Edit chart data settings

Customizing charts

Copy and paste charts

Publish and export charts