Google Sheets

Do spreadsheet seem difficult? Google has some  great add-ons for Google Sheets to make working on them a lot easier.

First how to get there: Open a Google Sheet>MenuBar click “Add-ons”> Click “Get Add-ons”  Now you have a search field to find some helpful add-ons to make your tasks on spreadsheets quicker and easier.

Below are some of my favorites:

Power Tools

An easy add-on to work with formulas, add/move/delete cells, change text case and split text. See the overview here.

Flubaroo: an add-on that will quickly grade student answer and place them in a new tab on your sheet

Save as Doc: An easy way to convert a spreadsheet to a google doc. You can choose which cells you want to be on the doc and it will even generate one doc per person (if you have students turning answers on a form.)

By Chrystal Hoe, Secondary Technology Integration Coordinator

Leave a Reply

Your email address will not be published. Required fields are marked *