SHS2 Ict · Semester 1 Week 2: Organising, Managing and Presenting Information Using Essential Productivity

Lesson notes

Learning Objectives

Indicator: 2.1.1.LI.2 - Create and utilise formulae and functions for data analysis.

By the end of the lesson, learners can:

Identify and distinguish between a formula and a built-in function in a spreadsheet, giving at least one example of each.
Create basic arithmetic formulae (addition, subtraction, multiplication, division) using cell references to analyse numerical data.
Utilise the built-in functions SUM, AVERAGE, MIN, MAX, IF, DATE, and TIME to perform data analysis on a given dataset.
Apply the IF function to make logical decisions within a spreadsheet, such as determining pass/fail or profit/loss status.
Explain, orally or in writing, the steps involved in entering a formula or function, demonstrating clear communication of the process.

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

Sign in with phone number

Curriculum details

Strand: ICTs IN THE SOCIETY (Strand 1)
Sub-strand: Organising, Managing and Presenting Information Using Essential Productivity (1.1)
Content standard: 2.1.1.CS.1 - Demonstrate knowledge and understanding of Analysing numerical data using Spreadsheet software 2.1.1.LO.1 Utilise knowledge of Spreadsheet software to create functions for data analysis, interpret graphs and manipulate tables.
Indicator: 2.1.1.LI.2 - Create and utilise formulae and functions for data analysis.
Suggested placement: Semester 1, Week 2 (Week 2 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:

content standard text - p.48: the content-standard token is visibly printed `2.1.1.CS1`, which omits the separator before the final sequence; `2.1.1.CS.1` is used as the import code only to preserve the document's year/strand/sub-strand association
Curriculum reference: NaCCA curriculum document, p. 48

Exemplars (from the NaCCA curriculum)

Project-Based learning:
- Work on practical assignments, individually or in groups, to create and use formulae and functions in spreadsheet software.
- Utilise various built-in functions, such as SUM, AVERAGE, MIN, MAX, IF, DATE, and TIME, to analyse numerical data effectively.
- Participate in interactive multimedia presentations and video analysis to deepen understanding of creating and using formulae and functions.
Teaching and Learning Materials:
- Notepad or exercise book
- Pen
- Smartphones
- Laptops
- Desktop computers
- Tablets
- TV
- Radio
- Open Educational
- Resources (Including
- YouTube, MOOCs -
- Udemy/Coursera, Khan
- Academy, TESSA)
- The iBox (CENDLOS)
- Productivity tools
- Subject-based application software
- Instructional
- Laboratories (with multimedia equipment and smartboards)
- Maintenance and repair workshops
Assessment (2.1.1.AS.2). The document marks these depth-of-knowledge levels for this indicator: Level 4 Extended critical thinking and reasoning.