Google sheet Basic/Intermediate and Advance levels for Grade 6/7/8 or year 7/8/9

Week 1: Learning Objectives:

• Understand what a spreadsheet is and why we use it?
• Recognize Rows, Columns, Active cell, Cell reference, Label, Value, Formula bar and Sheet tabs.
• Open, name and save a new Google Sheet
• How to Merge Cells in Google sheet
• Select the Cells and Add any colour on any cells
• Enter and edit simple data in cells and Format the cells.
• Practical Task: Create a basic School Calendar and Weekly Timetable.

Week 2: Learning Objectives:
By the end of this lesson, students will be able to:
•Enter and edit data accurately
•Use basic arithmetic formulas:

• addition

• subtraction

• multiplication
  / division
  •Apply basic functions:
  SUM()
  AVERAGE()
  MAX()
  MIN()
  •Format cells (font, size, color, alignment)
  •Apply currency formatting (€)
  •Create basic charts (bar, column, pie)
  •Organise data using rows, columns, tables, border

You are now going to complete your first spreadsheet tasks.

Login to your google classroom account :

Part 1: Practical Activities : Open google sheet or Excel spreadsheet and start with Activity 1, Activity 2, Activity 3, Activity 4, Activity 5 and Activity 6.

Part 2: Practical Activities: Open the project Class Party catalogue and open class party spreadsheet and start the activities