Introduction to Electronic… · JHS1 Computing

Lesson notes

Learning Objectives

Indicator: B7.2.3.1.4 - Demonstrate how to use Align Text, Merge & Wrap, Borders and Shades

By the end of the lesson, learners can:

change the alignment of text in a cell both horizontally (left, center, right) and vertically (top, middle, bottom) using the Alignment group on the Home tab.
merge two or more cells into one and split a merged cell back into separate cells.
apply wrap text to a cell so that long text displays on multiple lines within the same cell.
add borders and shading (fill colour) to cells or ranges to improve the appearance of a worksheet.
explain why each formatting feature is useful for making a spreadsheet clearer and more organised, drawing on earlier lessons about the importance of spreadsheets.

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.4 - Demonstrate how to use Align Text, Merge & Wrap, Borders and Shades
Suggested placement: Term 2, Week 10 (Week 22 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. 14
Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

1. Demonstrate how to change text alignment (Horizontal & Vertical), merge cells and wrap text.
2. Investigate how to access border & shade features and format the appearance of a worksheet as group work.