Easel by TpT
Seamlessly assign resources as digital activities

Learn how in 5 minutes with a tutorial resource. Try it Now  

Grades 6-8 Lesson Plans for Google Sheets™ Distance Learning

Grade Levels
6th - 8th, Adult Education, Homeschool, Staff
Formats Included
  • PDF
  • Google Apps™
76 pages
Share this resource
Includes Google Apps™
The Teacher-Author indicated this resource includes assets from Google Workspace (e.g. docs, slides, etc.).

Also included in

  1. This bundle contains the following Google Software Lessons and Projects to teach your students all about Google Docs, Slides, Sheets and Drawings in detail Resources for Google Docs™ and Google Drawings™:This resource is perfect for introducing and teaching Google Docs™ for beginners but at a grade
    Save $9.80
  2. This beginner skills middle school technology and coding curriculum develops and enhances essential tech and coding skills for middle school students as well as providing them with a varied curriculum of learning for a whole year. This beginner curriculum is perfect for delivery and lays the foundat
    Save $27.00


This is the first entire Google Sheets Bundle (Grades 6-8) 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.

Other Google Drive Resources Available on my Store:

  • Google Slides for Beginners Skills & Activities Bundle: Click Here
  • Google Docs for Beginners Skills & Activities Bundle: Click Here
  • Google Docs & Drawings for Beginners Skills & Activities Bundle: Click Here
  • Google Sheets Grades 6-8 Lesson Plans Bundle: Click Here
  • Google Sheets Grades 1-4 Lesson Plans Bundle: Click Here
  • Technology Activities and Skills Building Bundle for Google Drive™: Click Here
Total Pages
76 pages
Answer Key
Teaching Duration
2 months
Report this Resource to TpT
Reported resources will be reviewed by our team. Report this resource to let us know if this resource violates TpT’s content guidelines.


Questions & Answers

Teachers Pay Teachers is an online marketplace where teachers buy and sell original educational materials.

More About Us

Keep in Touch!

Sign Up