Spreadsheet Scenarios and Activities Bundle for Google Sheets™

Are you looking for fun Google Spreadsheets activities for students to practice their skills in Google Sheets? This is the perfect set of activities to use! Students will need to have some prior knowledge in using Sheets, thus these prove to be excellent resources for consolidation work or even mini tests. This bundle includes the following products as well as many more scenarios…

At the Movies Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of Sum() function
Making predictions by changing data
Creating graphs from data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.

Million Dollars Spreadsheet Activity
Students use this resource to understand how altering data in Google Sheets allow graphs to change. They understand such concepts by trying to spend a Million Dollars in a minute.
This resource allows students to understand the following:
How graphs change when data in Google Sheets is altered
Use of SUM() functions
How graphs are made
Components of a graph
Advantages of spreadsheets over pen and paper methods
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.

Google Sheets & Graphs Skills: Chocolates Scenario
Students have to read through the tasks on the worksheet to insert data into the Chocolates Google Sheet and to create pie charts. Students will also learn how to analyze data held in Google Sheets and charts. They will also learn to change Google Sheets.
This resource teaches the following skills in detail:
Creating Pie Charts
Analyzing Google Sheets Data
Inserting spreadsheet rows
Using =sum() function

Compare Supermarkets Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of simple formula/calculations such as addition, subtraction and multiplication.
Use of Sum() function
Use of min(), max() and mean() functions
Making predictions by changing data
Creating graphs from data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.

My Pocket Money Spreadsheet Activity
A Google Sheets activity which tests student’s knowledge on the following skills:
Cell referencing
Use of simple formula/calculations such as addition, subtraction, multiplication and division.
Use of Sum() function
Making predictions by changing data
Students are then expected to complete the associated worksheet which accompanies the spreadsheet.

End of Year Awards Spreadsheet Activity
This resource encourages students to interpret data in tally chart to then enter into a Excel Spreadsheet. Students are then expected to read the instructions on their worksheet to either add to or modify their spreadsheet.
This resource covers the following skills:
Entering data
Writing and entering formula.
Formatting spreadsheets
Creating graphs and charts