Are you looking for fun google spreadsheets activities for students to practise 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 which can also be bought separately from my store:
1. At the Movies Spreadsheet Activity
A Google Sheets activity which tests students’ 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.
2. 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.
3. 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 analyse 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
- Analysing Google Sheets Data
- Inserting spreadsheet rows
- Using =sum() function
4. Compare Supermarkets Spreadsheet Activity
A Google Sheets activity which tests students’ knowledge on the following skills:
Cell referencing
- Use of simple formulae/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.
5. My Pocket Money Spreadsheet Activity
A Google Sheets activity which tests students’ knowledge on the following skills:
- Cell referencing
- Use of simple formulae/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.
6. 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 formulae.
- Formatting spreadsheets
- Creating graphs and charts
7. Christmas Shopping List Spreadsheet Activity
A fantastic Christmas themed Google Sheet spreadsheet which teaches students to enter data, work with formula and create graphs.
This resource allows students to understand the following:
- How graphs change when data in spreadsheets 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.
8. Ice-Cream Shop Spreadsheet Activity
A Google Sheets spreadsheet and worksheet activity which tests students’ knowledge on the following skills:
- Cell referencing
- Use of formulae/calculations such as subtraction and multiplication.
- Making predictions by changing data
- Use of Sum() function
- What if questions
9. Google Sheets: I Can Statements
Use this 3 page set of I Can Statements to tick off each statement when the relevant skills are developed by your students in Google Sheets.
I Can Statements for Google Sheets fall under the following 6 categories:
- Text & Number Formatting
- Cell Formatting
- Creating & Formatting Graphs
- Using Formulae & Functions
- Sheet Operations
- Sheet Layout & Appearance
10. Google Sheets: Task Cards
A set of 20 task cards which allow students to practice the following skills in Google Sheets independently:
- Inserting columns
- Deleting columns
- Deleting rows
- Inserting rows
- Adding currency
- Removing currency
- Adding decimal places
- Removing decimal places
- Adding borders
- Changing border color
- Adding fill color
- Sorting data
- Merging cells
- Unmerging cells
- Creating charts
- Customizing Pie Charts – A closer look
- Moving charts to new sheets
- Changing Chart types
- Adding New Sheets
- Deleting sheets
These task cards have promoted independent learning in my classroom. This file contains 4 tasks cards per page (5 pages in total). Tasks cards can be printed in color, cut out, laminated and then given to students to use.