Carrying out a project part I
I can edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.
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
- Using a single spreadsheet workbook with different sheets can help organise all the data in one place.
- Formulas like SUM and functions like IF help you do calculations quickly and accurately.
- Using the fill handle and absolute cell references can make your formulas more efficient.
- 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...
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.
The starter quiz will activate and check your pupils' prior knowledge, with versions available both with and without answers in PDF format.
We use learning cycles to break down learning into key concepts or ideas linked to the learning outcome. Each learning cycle features explanations with checks for understanding and practice tasks with feedback. All of this is found in our slide decks, ready for you to download and edit. The practice tasks are also available as printable worksheets and some lessons have additional materials with extra material you might need for teaching the lesson.
The assessment exit quiz will test your pupils' understanding of the key learning points.
Our video is a tool for planning, showing how other teachers might teach the lesson, offering helpful tips, modelled explanations and inspiration for your own delivery in the classroom. Plus, you can set it as homework or revision for pupils and keep their learning on track by sharing an online pupil version of this lesson.
Explore more key stage 4 computing lessons from the Using IT in project management unit, dive into the full secondary computing curriculum, or learn more about lesson planning.
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.
Equipment
Pupils will need access to spreadsheet software.
Licence
Prior knowledge starter quiz
6 Questions
Q1.Which chart shows the flow and dependencies between tasks using nodes and arrows?
Q2.Which planning tool is used to display project activities against blocks of time?
Q3.Arrange these steps in the correct order for planning a project using a Gantt chart:
Q4.What does a Gantt chart NOT show?
Q5.How does a PERT chart represent tasks?
Q6.Planning tools are important in a project because they ...
Assessment exit quiz
6 Questions
Q1.Which of these is an example of a formula?
Q2.What is the term for a built-in calculation tool in a spreadsheet that performs tasks like adding or finding averages?
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?
Q4.Match the action to its purpose:
copies formulas or values quickly
keeps a cell reference fixed when copying
updates data automatically between sheets
performs calculations based on a condition