Computer Science LearnITWithMrC ⛯ Year 7 Year 8 Year 9 GCSE
Responsive image

Formula and function

What am I Learning today?

I am learning how to use use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /)
I am learning how to use the autofill tool to replicate cell data

Knowledge Organiser

×

Lesson

Task 1 - Getting Organised Click to see more

Open your Learning Journal from last week if you were not here last lesson you can click on the image below to download it.


Update your learning objectives


Update your learning objectives for this lesson so that they are red



Task 2 - Starter Task Click to see more

One of the most powerful features in Excel is the ability to calculate numerical information using formulas. Just like a calculator, Excel can add, subtract, multiply, and divide. In this lesson, we'll show you how to use cell references to create simple formulas.

Click on the image below to download the spreadsheet we are going to use for todays lesson activities



  • Screenshot your completed Starter task into your Learning Journal

  • Task 3 - Activity 1 - Times Table Click to see more

    Click on the Activity 1 tab at the bottom of your Activities Spreadsheet

    You need to complete the times table using formula and cell references



  • Screenshot your completed times tables into your Learning Journal
  • Task 4 - Activity 2 - Party time Click to see more

    Click on the Activity 2 - Party time tab at the bottom of your Activities Spreadsheet

    You need to complete the recipes tables using formula and cell references

  • Screenshot your completed recipes into your Learning Journal

  • Task 5 - Explorers task Click to see more

    Click on the Explorers Task tab at the bottom of your Activities Spreadsheet

    Follow the Explorer Task Instructions on the spreadsheet

  • Screenshot your completed tasks into your Learning Journal

  • Task 6 - Final Task - Calculation Quiz Click to see more

    • We practiced using some formaulae. Let's do some more practice.

    • Complete the spreadsheet calculation quiz.


    Task 7 - Reviewing it all Click to see more


    Summing it all up

    Lets look at the learning outcomes and decide which one best describes our current level of understanding :

    Tick the one you feel is closest to your level

    Learning Outcomes I need to learn how to use use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /)

    • I have a basic understanding of how I can use use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /) with a little help from my teacher
    • I can show my teacher that I can use use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /) without their help.
    • I can use use basic formulas with cell references for calculations in a spreadsheet (+, -, *, /) independently and I can also explain it to others and can complete any extension tasks I am given.

    🠜 Now update your learning objectivesClick on the Assessment image


    My Notes: modelling

    Student_Comment_1 not found

    Task Notes/Comments - Add here Click to see more

    Comments/Notes

    Copyright © 2013 - 2025 LearnITwithMrC