Organising, Managing and Presenting… · SHS2 Ict

Lesson notes

Learning Objectives

Indicator: 2.1.1.LI.1 - Describe Spreadsheet software workbooks, worksheets, cell referencing

By the end of the lesson, learners can:

Define a spreadsheet software and identify at least five common features of the spreadsheet window (workbook, worksheet, formula bar, cell, column, row).
Explain the difference between a workbook and a worksheet, stating how many worksheets a new workbook typically contains.
Describe cell referencing using column letters and row numbers, and write the correct cell reference for any given cell.
Differentiate between relative and absolute cell references, and state when each is appropriate for use.
Demonstrate the ability to locate, open, and navigate a spreadsheet application on a computer or mobile device, identifying the key parts of the interface.

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.1 - Describe Spreadsheet software workbooks, worksheets, cell referencing
Suggested placement: Semester 1, Week 1 (Week 1 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)

Whole class discussion: Participate in a class discussion on spreadsheet software, considering its key features and components such as workbooks, worksheets, cell referencing, and formula bars.
Project-Based learning:
- Engage in project-based learning activities to explore and utilise the features of spreadsheet software, demonstrating an understanding of workbooks, worksheets, and cell referencing.
- Interactive multimedia presentations, and video analysis to discuss the concepts and explore techniques for creating electronic spreadsheets. These strategies must respond to inclusivity and equity. For example, input devices should be chosen to ensure all learners with different abilities e.g., people with visual impairment, dyslexia, and dysgraphia can analyse data.
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.1). The document marks these depth-of-knowledge levels for this indicator: Level 3 Strategic reasoning.