Introduction to Electronic… · B6 Computing

Lesson notes

Learning Objectives

Indicator: B6.5.3.1.5 - Modify the appearance of data within a worksheet.

By the end of the lesson, learners can:

Identify at least four formatting options available in the Home ribbon of Microsoft Excel 2016.
Apply bold, italic, underline, and font colour to selected cells to change how data appears.
Change font type and font size of data within a selected range of cells.
Merge and centre a title across a range of cells in a worksheet.
Demonstrate how to wrap text and adjust cell alignment (left, centre, right) to improve how data is displayed.

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: 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.5 - Modify the appearance of data within a worksheet.
Suggested placement: Term 2, Week 6 (Week 18 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.

Exemplars (from the NaCCA curriculum)

Show examples of modified data in (a) worksheet(s), either on projected screens or pictures. Guide learners to modify the appearance of data within a worksheet.