Skip to main content

Posts

Showing posts from March, 2020

3 Activities to Get You Started With Google Sheets on iPad

I love Google Sheets and I know you will too! So many teachers I know are not sure how to get started because spreadsheets can be intimidating. Try these 3 activities to get started.

Activity 1- Averaging Scores

Create a new sheetIn the top row label the first three boxes:First Name | Last Name | ScoreType in sample data for 5 studentsIn the bottom row, for student name type “average”In the cell under all the scores type=average(While still in the cell, select all the scores you want to averageAt the bottom of your sheet, click on the tab and rename it “averaging”
Activity 2- Sorting Data
At the bottom of your sheet from activity 1, click on the tab and select “duplicate”Rename you new tab “sorting”In your sorting tab, delete the row with the averages and the row with the titlesTap C and then use the > to find “Sort A-Z” This will sort your data by column C (by grade)Tac B and then use the > to find “Sort A-Z” This will sort your data by column B (last name)
Activity 3- Visualizing D…