Spreadsheets Lesson Plans & Activities for Google Sheets - Computer Applications

This Grades 6-8 Google Sheets Bundle teaches youngsters the basic and intermediate skills of Sheets using several google sheets exercises. 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.

❁❁ Click Here to Follow Me

Benefits for you:

• Rating this product allows you to collect credits for money off towards your next TPT purchase.
• Follow me for more Technology & Computer Science resources as well as future offers.

Terms of Use:

• Created by Bal Borde, Copyright © Computer Creations
• All rights reserved. Purchase of this unit entitles the purchaser the right to reproduce the pages in limited quantities for single classroom use only. Duplication for an entire school, an entire school system or commercial purposes is strictly forbidden without written permission from the publisher.
• Copying any part of this product and placing it on the Internet in any form (even a personal/classroom website) is strictly forbidden and is a violation of the Digital Millennium Copyright Act (DMCA). These items can be picked up in a google search and then shared worldwide for free.
• If you have any questions about licensing, please contact me on balborde@gmail.com

Other Google Drive Resources Available on my Store:

• Google Slides for Beginners Skills & Activities Bundle
• Google Docs for Beginners Skills & Activities Bundle
• Google Docs & Drawings for Beginners Skills & Activities Bundle
• Google Sheets Grades 6-8 Lesson Plans Bundle
• Google Sheets Grades 1-4 Lesson Plans Bundle
• Technology Activities and Skills Building Bundle for Google Drive™