B5 Computing · Term 2, Week 6

Introduction to Electronic Spreadsheet(tabs and Ribbons Manipulation)

Lesson notes

Learning Objectives

Indicator: B5.5.1.2.3 - Learners get familiar with the interface of MS-Excel

By the end of the lesson, learners can:

  1. Identify and name the main parts of the MS-Excel interface, including the Title Bar, Ribbon, Tabs, Formula Bar, Name Box, and Worksheet Area.
  2. Demonstrate how to launch MS-Excel on a computer or gadget using at least two different methods.
  3. Locate and switch between the different Tabs (Home, Insert, Page Layout, etc.) on the Ribbon and describe what each Tab is used for.
  4. Type text into a cell and display it in MS-Excel, then edit the text as required.
  5. Use the File tab to save a workbook with an appropriate name and reopen it.

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.1)
Content standard
B5.5.1.2 - Demonstrate how to use Electronic Spreadsheet.
Indicator
B5.5.1.2.3 - Learners get familiar with the interface of MS-Excel
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.20: the page is headed 'SUB-STRAND 2 : INTRODUCTION TO ELECTRONIC SPREADSHEET(TABS AND RIBBONS MANIPULATION)' but every code on it reads sub-strand 1 (B5.5.1.2, B5.5.1.2.1-.3), the same sub-strand as p.19's 'SUB-STRAND 1: INTRODUCTION TO DATABASES, ALGORITHM AND PROGRAMMING.'. sub_strand_code follows the codes; this name is the page's own heading
Curriculum reference
Computing Curriculum (Basic 4-6), 2019, p. 20

Transcribed from the official NaCCA publication. Check this page against the source.

Exemplars (from the NaCCA curriculum)

Guide Learners to demonstrate how to access MS-Excel on any computer or gadget and display text in MS-Excel.
NB. This is to help the learner with an understanding of application softwares (Electronic Spreadsheet application).