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

Lesson 2 : If Statements and Graph
Objectives
Understand the use of absolute cell referencing.
Understand the use of simple functions (sum,max,min and average in a spreadsheet.
Understand the use of If statements including the logical, true and false statements.
Understand how calculations can be used as True statements
Understand the use of nested if statements including more than one true statement.
Understand the use of count and sum if functions.
Understand the need the need to present data in a graph format.
Understanding the need to present information in different forms (graphs)
IF Statement
VLookup
Test 1 and 2 and 3 for Grade 6/7/8 or Year 7/6/9
Learning Objectives (VLOOKUP)
By the end of this lesson, students will be able to:
Explain what VLOOKUP does (vertical lookup) and when it is useful to retrieve information from a table.
Write a correct VLOOKUP formula using the 4 required parts:lookup_value, table_array, col_index_num, range_lookup (TRUE/FALSE).
Use absolute cell referencing (£) to lock the lookup table so the formula works when filled down.
Choose and justify exact match (FALSE/0) vs approximate match (TRUE/1) and apply the correct option in a task.
Apply VLOOKUP to a real dataset to retrieve missing information (e.g., price/author/stock) accurately and efficiently.
Use supporting functions when needed (e.g., COUNT functions and SUMIF) to summarise the dataset after lookup values are completed.
Evaluate the benefit of VLOOKUP