Introduction to Electronic… · JHS1 Computing

Lesson notes

Learning Objectives

Indicator: B7.2.3.1.3 - Demonstrate how to set the cell datatype (General, Number, Currency, etc.).

By the end of the lesson, learners can:

Identify the default cell datatype in a spreadsheet and explain why it matters.
Demonstrate how to set a cell datatype to General, Number, Currency, Date, Time, and Text using the Format Cells dialog box.
Enter values, text, dates, and time in worksheet cells and change their formats for presentation.
Compare how the same entry (e.g., 5000) appears under different datatypes (General, Number, Currency, Accounting).
Apply appropriate datatypes to real-life data such as market prices, school fees, and dates of events.

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: Productivity Software (Strand 2)
Sub-strand: Introduction to Electronic Spreadsheet (2.3)
Content standard: B7.2.3.1 - Demonstrate how to use the Spreadsheet (Editing Worksheets)
Indicator: B7.2.3.1.3 - Demonstrate how to set the cell datatype (General, Number, Currency, etc.).
Suggested placement: Term 2, Week 9 (Week 21 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.
Curriculum reference: Computing, Common Core Programme (JHS1-JHS3), 2023, p. 13
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

1. Investigate how to set and modify the cell type of values and text.
2. Enter values, text, dates and time in worksheet cells and change the formats for presentation. E.g. General, Number, Currency, Accounting, Dates, Time, etc.