This KS3 Google Sheets Bundle will enable you to teach youngsters the basic and intermediate skills of the software. This bundle teaches students the very basic skills up to more advanced skills such as absolute cell referencing. The google sheets exercises in this bundle also prove to be excellent resources for consolidation work or even mini tests.

I have used the resources in my computer lab for 1 hour lessons per week and they have lasted for up to 10 weeks. The timing can alter depending on the ability level of the students completing the worksheets and activities.

Topics in this bundle include:
- Introduction to Google Sheets
- Calculations in Google Sheets
- Understanding and Naming Cell references
- Use of simple formulae/calculations such as addition, subtraction and multiplication.
- Functions in Google Sheets (sum, min, max, average, mode)
- Tallying data in spreadsheets
- Making predictions by changing data
- Components of a graph
- Advantages of spreadsheets over pen and paper methods
- Analysing Google Sheets Data
- Inserting spreadsheet rows
- Practising and Creating Google Sheets from scenarios
- Understanding, creating & analysing Graphs in Google Sheets
- Absolute & relative cell referencing

Resources included in this bundle:
1. Seven Detailed lesson plans
2. Student Worksheets - can be shared via Drive or Classroom for students to type answers into.
3. Google sheets exercises with accompanying worksheets
4. I Can Statements which cover the following 6 categories:
- Text & Number Formatting
- Cell Formatting
- Creating & Formatting Graphs
- Using Formulae & Functions
- Sheet Operations
- Sheet Layout & Appearance
5. 20 Task Cards which allow students to practise 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.