B6 Computing · Term 2 Week 5: Introduction to Electronic Spreadsheet (tabs and Ribbons Manipulation)

Lesson notes

Indicator: B6.5.3.1.3 - Perform calculations in an MS-Excel worksheet.

By the end of the lesson, learners can:

Identify the formula bar and cell references in an MS-Excel worksheet.
Create simple formulas in Excel using addition, subtraction and multiplication signs (+, -, *).
Use the SUM function to add up a range of numbers in a worksheet.
Apply formulas to solve everyday arithmetic problems in a worksheet.
Explain how Excel recalculates answers automatically when values change.

Sign in with your phone number to read the full note and download the GES plan - free.

Strand: Programming and Databases (Strand 5)
Sub-strand: Introduction to Electronic Spreadsheet (tabs and Ribbons Manipulation) (5.3)
Content standard: B6.5.3.1 - Demonstrate how to use Spreadsheet.
Indicator: B6.5.3.1.3 - Perform calculations in an MS-Excel worksheet.
Suggested placement: Term 2, Week 5 (Week 17 of the year)
Our suggestion, laid out in curriculum order across three terms of twelve weeks. NaCCA does not fix the week, so follow your school's scheme of learning.
Source document note: The official curriculum document has a fault in this entry, so the curriculum text above is transcribed exactly as printed:

sub strand name - p.41: the page is headed 'SUB-STRAND 2: INTRODUCTION TO ELECTRONIC SPREADSHEET / (TABS AND RIBBONS MANIPULATION)' but every code on it and on p.42 reads sub-strand 3 (B6.5.3.1, B6.5.3.1.1-.7). sub_strand_code follows the codes; this name is the page's own heading
Curriculum reference: Computing Curriculum (Basic 4-6), 2019, p. 41
Transcribed from the official NaCCA publication. Check this page against the source.

Guide learners to develop worksheet that will help in calculating multiplication, addition and subtraction