Google Workspace, Session 5: Processing numerical data using Google Sheets, Part 1

Welcome to Google Workspace Session 5: Processing numerical data using Google Sheets, Part 1.

This is the first of two sessions that will take you through the steps of discovering how useful numerical data processing apps – such as Google Sheets – can be to you as a teacher. We will create documents to use in your teaching during these sessions. In this session, we will create a class list.

By the end of this session, you will:

• understand the purpose of a spreadsheet
• understand the concepts of a cell, a row, a column and sheet
• understand the use of Cell References
• know how to format and edit cells (key in data, wrap text, merge and unmerge cells, align text, add borders and shading and adjust text direction)
• know how to use the Autofill Feature
• know how to use number formats (Plain Text, Number, Currency, Time and Date)
• know how to resize rows and columns
• know how to format and edit spreadsheets (Paper Size, Page Margins and Page Orientation)
• know how to set a print area and print titles (gridlines and repeat rows/columns)

We suggest that you download the Class Notes first so you can follow along during the training.