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

Lesson 1 - Formatting and Formula

Overview
Flight Path
Learning Objectives
0 results forGuest
IDSkill_name
 1 I can calculate sums using a spreadsheet.
 3 I can identify the different elements of a spreadsheet e.g. 'row', 'column', 'cell' etc.
 2 I can adjust cell height/width and edit columns and rows

🏁 Learning Objective 1 :- I can calculate sums using a spreadsheet.


Calculating Sums

Exercise - Answer the questions below

Using the calculator or by hand work out the following sums:

  1. 176 + 119
  2. 25 * 17
  3. 176 - 119
  4. 282 / 6

Extension activity

Put the above sums into an excel worksheet.

See if you can use a simple formula to work them out?

Update your objectives

control

🏁 Learning Objective 2 :- I can identify the different elements of a spreadsheet e.g. 'row', 'column', 'cell' etc.


Elements of a Spreadsheet

How spreadsheets work

A spreadsheet appears as a grid - each row has its own number and each column its own letter. This labelling of rows and columns is used to give each cell a cell address or reference, for example, C5 means column C, row 5.

It is also possible to refer to a range of cells collectively, ie E4:E12 includes E4, E12 and all of the cells in-between.

Cells can contain numbers, text or formulae.

Exercise - Check your understanding

Click on the Kahoot Image below to start the spreadsheet quiz


Update your objectives

control

🏁 Learning Objective 3 :- I can adjust cell height/width and edit columns and rows


Modifying Spreadsheet Cells

Click on the image below to complete the Modifying Worksheets tasks

Update your learning objectives

control

Creating Charts

Click on the image below to complete the Modifying Worksheets tasks

Update your learning objectives

control
0 results forGuest
Recent Comments

Teacher Date: 2026-06-13


Guest