Google Sheets

bit.ly/kjsissh

In this unit we will learn how to:

Work with spreadsheets
Automate calculations in a spreadsheet using FUNCTIONS
Track and visualize data

STEP 1

To begin please:

A. Get the spelling results your teacher has had you collect.

B. Sign in to your Google Drive account.

C. Go to this GOOGLE SHEETS page of the website

Once you have accomplished this, please close your laptop so I am aware you are ready.
You may help a classmate if they ask.

STEP 2

Let's open a new Google Sheet and give it a relevant, easily discoverable title. I will show you as a class but there is also a gif demonstrating the steps repetitively below:

STEP 3

Now we will set up Titles in a Header Row (1).

A1: Test

B1: Score

C1: Out of

D1: Percentage

This will allow us to produce a graph later after we have entered:

1. The relevant information in the correct cells

3. The formatting to calculate the results as percentages in column 4

STEP 4

Input the data for columns B & C

Simply select a cell and type in the data

STEP 5

Let's format it to automatically calculate as percentages.

QUESTION: Are different tests out of different number total?

* If so we need to format the cells differently in COLUMN C

Now click and drag on the small blue square and drag it down as long as you have data in rows (I will show you or you can follow the instructions as demonstrated in the gif below)

Session 2(?)

STEP 6

Generate a Graph

1. Select all relevant cells by clicking and dragging

2. Choose "Insert" from the toolbar

3. Select "Chart"

4. Let's play around with the types of graphs (often referred to as charts as well)

5. Let's remove the data from column B

Generate a graph (chart)

Altering graph (chart) type and removing data

Let's look at CONDITIONAL FORMATTING

Have we time to DUPLICATE this "Sheet" of our "Workbook" and plot some new data?

Report abuse