Carrying out a project part I
Lesson details
Learning outcome
I can edit the structure of a provided spreadsheet workbook and apply functions and formulas to each sheet.
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 - performs calculations in a spreadsheet
Function - a predefined formula that performs a calculation
Common misconception
Formulas can only be used on cells within one worksheet in a spreadsheet.
Formulas can work across multiple worksheets in a spreadsheet.
Teacher tip
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.
Equipment
Pupils will need access to a device with spreadsheet software. Examples in this lesson use Google Sheets https://oak.link/google-sheets
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.
Licence
Lesson video
Loading...
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
Q5.What calculation would you use in a spreadsheet to calculate the total of all values from cell A1 to cell A10?
Q6.Put these steps in order for linking data between two worksheets:
To help you plan your 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 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.