New
New
Year 11

Carrying out a project part I

I can edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.

New
New
Year 11

Carrying out a project part I

I can edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.

These resources will be removed by end of Summer Term 2025.

Switch to our new teaching resources now - designed by teachers and leading subject experts, and tested in classrooms.

These resources were created for remote use during the pandemic and are not designed for classroom teaching.

Lesson details

Key learning points

  1. Using a single spreadsheet workbook with different sheets can help organise all the data in one place.
  2. Formulas like SUM and functions like IF help you do calculations quickly and accurately.
  3. Using the fill handle and absolute cell references can make your formulas more efficient.
  4. You can use formulas to link cells from one sheet to another, so data updates automatically.

Keywords

  • Workbook - a file in a spreadsheet package that is made up of multiple worksheets

  • Worksheet - a single sheet within a workbook made up of cells

  • Formula - simple calculations within a spreadsheet

  • Function - advanced calculations within a spreadsheet

Common misconception

Formulas can only be used on cells within one worksheet in a spreadsheet.

Formulas can work across multiple worksheets in a spreadsheet.


To help you plan your year 11 computing lesson on: Carrying out a project part I, download all teaching resources for free and adapt to suit your pupils' needs...

Files needed for this lesson

  • Delicious desserts solutions 118.16 KB (XLSX)
  • Delicious desserts 188.42 KB (XLSX)

Download these files to use in the lesson.

This lesson contains downloadable spreadsheet files that pupils will need for the lesson. You could download these files prior to the lesson and make available to pupils on your school's shared drive or cloud storage area.
Teacher tip

Equipment

Pupils will need access to spreadsheet software.

Licence

This content is © Oak National Academy Limited (2025), licensed on Open Government Licence version 3.0 except where otherwise stated. See Oak's terms & conditions (Collection 2).

Lesson video

Loading...

Prior knowledge starter quiz

Download quiz pdf

6 Questions

Q1.
Which chart shows the flow and dependencies between tasks using nodes and arrows?

Correct Answer: PERT chart, PERT

Q2.
Which planning tool is used to display project activities against blocks of time?

Correct Answer: Gantt chart, Gantt

Q3.
Arrange these steps in the correct order for planning a project using a Gantt chart:

1 - list tasks
2 - set start and end dates
3 - display on timeline
4 - track progress

Q4.
What does a Gantt chart NOT show?

task deadlines
task order
Correct answer: budget information
overlapping activities

Q5.
How does a PERT chart represent tasks?

with columns and rows
Correct answer: with nodes and arrows
with blocks of colour
with numbered lists

Q6.
Planning tools are important in a project because they ...

make the project look more impressive.
add more paperwork.
replace the need for teamwork.
Correct answer: help manage time and tasks efficiently.

Assessment exit quiz

Download quiz pdf

6 Questions

Q1.
Which of these is an example of a formula?

=IF(A1>10, "Yes", "No")
=SUM(A1:A10)
Correct answer: =A1+A2
workbook

Q2.
What is the term for a built-in calculation tool in a spreadsheet that performs tasks like adding or finding averages?

Correct Answer: function

Q3.
What calculation would you use in a spreadsheet to display “High” if the value in cell B5 is greater than 10, and “Low” otherwise?

Correct Answer: =IF(B5>10,"High","Low")

Q4.
Match the action to its purpose:

Correct Answer:using the fill handle,copies formulas or values quickly

copies formulas or values quickly

Correct Answer:using absolute cell references,keeps a cell reference fixed when copying

keeps a cell reference fixed when copying

Correct Answer:linking cells across sheets,updates data automatically between sheets

updates data automatically between sheets

Correct Answer:using the IF function,performs calculations based on a condition

performs calculations based on a condition

Q5.
What calculation would you use in a spreadsheet to calculate the total of all values from cell A1 to cell A10?

Correct Answer: =SUM(A1:A10)

Q6.
Put these steps in order for linking data between two worksheets:

1 - select the cell to link
2 - enter the formula referencing the other sheet
3 - press Enter
4 - check the result