1.01 Introduction

How this Training Works

You must have a Google account, and be logged in to complete these activities.

For each activity there will be a short intro and a link you can click to try out the highlighted feature. When you click each link you will go to a "View Only" copy of the sheet. Click "File >> Make a copy" and a new sheet will be created in your Google Drive which you can edit. If you can't type in the sheet, you are in view only mode!

Most sheets have tasks to complete, but a few are just information.

What is a "spreadsheet" and what are they used for?

Spreadsheets were originally created to make life easier on accountants by automating many of the record keeping and calculation functions required in complex financial transactions. It turns out they have many other uses!

General Uses:

• Record Keeping

• Automated Calculations

• Sorting Data

• Creating Data Visualizations (Charts and Graphs)

Classroom Applications:

• Lesson Plan Book

• Seating Charts

• Analysing Form Data

• Importing Data from Edtech Sites to Calculate Grades

• Customized Grade Books