Microsoft Excel: Meaning and How to Launch Microsoft Excel Primary 4 (Basic 4) Third Term Week 8 Information Technology – Computer Studies

MICROSOFT EXCEL: MEANING AND LAUNCHING EXCEL

INFORMATION TECHNOLOGY (COMPUTER STUDIES)

PRIMARY 4 – THIRD TERM – WEEK 8

THEME – BASIC COMPUTER OPERATIONS 

PREVIOUS LESSON – Microsoft PowerPoint: Meaning of Microsoft PowerPoint Toolbars and Their Functions Primary 4 (Basic 4) First Term Week 5 and Week 6 Information Technology – Computer Studies

TOPIC – MICROSOFT EXCEL 

LEARNING AREA

1. Introduction

2. Meaning and Uses of Microsoft Excel

3. How to Launch Microsoft Excel

4. Features and Importance of Microsoft Excel

5. Weekly Assessment: Test Questions and Answers/Assignment

6. Summary

LEARNING OBJECTIVES 

By the end of the lesson, pupils should be able to:

1. Explain the meaning of Microsoft Excel.

2. State the uses of Microsoft Excel.

3. Identify the Microsoft Excel icon.

4. Demonstrate how to launch Microsoft Excel.

5. Appreciate the importance of Microsoft Excel in everyday activities.

ENTRY BEHAVIOUR

Pupils have previously learned how to launch and use Microsoft PowerPoint to create presentations. They know that different Microsoft Office applications perform different tasks.

This lesson builds on that knowledge by introducing Microsoft Excel, another Microsoft Office application used for entering, organising, calculating, and analysing data. Pupils will also learn how to launch Microsoft Excel on a computer.

INSTRUCTIONAL MATERIALS

The teacher will teach the lesson with the aid of:

1. Computer or laptop

2. Microsoft Excel application

3. Projector (if available)

4. Charts showing the Microsoft Excel icon

5. Whiteboard and marker

METHOD OF TEACHING

Choose a suitable and appropriate methods for the lessons.

Note – Irrespective of choosing methods of teaching, always introduce an activities that will arouse pupil’s interest or lead them to the lessons. 

REFERENCE MATERIALS

1. Scheme of Work

2. 9 – Years Basic Education Curriculum

3. Course Book

4. All Relevant Material

5. Online Information

CONTENT OF THE LESSON

INTRODUCTION

People often need to organise numbers, calculate totals, prepare tables, and keep records. Microsoft Excel is a computer application that makes these tasks easy and accurate.

In this lesson, pupils will learn the meaning of Microsoft Excel, its common uses, and the steps involved in launching Microsoft Excel on a computer.

LESSON 2 – MEANING OF MICROSOFT EXCEL

Microsoft Excel is a spreadsheet application developed by Microsoft. It is used to enter, organise, calculate, store, and analyse data using rows and columns.

It helps users prepare tables, perform calculations, and present information clearly.

USES OF MICROSOFT EXCEL

Microsoft Excel is used to:

1. Enter and organise data.

2. Perform mathematical calculations.

3. Prepare tables and records.

4. Create charts and graphs.

5. Keep financial records.

6. Prepare examination scores.

7. Analyse data.

8. Prepare budgets and reports.

LESSON 2 – THE MICROSOFT EXCEL ICON

The Microsoft Excel icon is usually green with the letter X on it.

Pupils should learn to identify the Excel icon on the desktop, Start Menu, or taskbar.

FEATURES SEEN WHEN MICROSOFT EXCEL OPENS (PRACTICAL ACTIVITIES WITH COMPUTER)

When Microsoft Excel opens, you will see:

1. Title Bar – The Title Bar is at the top of the Excel window. It displays the name of the workbook and the Microsoft Excel application.

2. Ribbon – The Ribbon contains different tabs and groups of commands used to create, edit, and format worksheets.

3. Quick Access Toolbar – The Quick Access Toolbar contains commonly used commands such as Save, Undo, and Redo for quick access.

4. Workbook – A Workbook is an Excel file that contains one or more worksheets.

5. Worksheet – A Worksheet is a single page inside a workbook where data is entered and organised.

6. Rows – Rows are the horizontal lines in a worksheet. They are identified by numbers such as 1, 2, 3, 4…

7. Columns – Columns are the vertical lines in a worksheet. They are identified by letters such as A, B, C, D…

8. Cells – A Cell is the box where a row and a column meet. It is used for entering data, numbers, or formulas.

9. Formula Bar – The Formula Bar displays the contents of the selected cell and is used to enter or edit formulas and data.

10. Sheet Tabs – Sheet Tabs are found at the bottom of the workbook. They allow users to switch from one worksheet to another.

11. Status Bar – The Status Bar is located at the bottom of the Excel window. It displays information about the current worksheet, such as the page status, calculation results, and zoom level.

LESSON 3 – HOW TO LAUNCH MICROSOFT EXCEL (PRACTICAL ACTIVITIES WITH COMPUTER)

Method 1: Using the Start Menu

1. Click the Start button.

2. Click All Apps or All Programs.

3. Scroll to Microsoft Office or Microsoft 365.

4. Click Microsoft Excel.

Method 2: Using the Search Box

1. Click the Search box on the taskbar.

2. Type Excel.

3. Click Microsoft Excel from the search results.

Method 3: Using a Desktop Shortcut

1. Locate the Microsoft Excel icon on the desktop.

2. Double-click the Excel icon.

3. Wait for Microsoft Excel to open.

IMPORTANCE OF MICROSOFT EXCEL

1. It makes calculations easy.

2. It saves time when working with numbers.

3. It organises data neatly.

4. It reduces calculation errors.

5. It jelps prepare reports and records.

6. It improves accuracy in record keeping.

WEEKLY ASSESSMENT: TEST QUESTIONS AND ANSWERS/ASSIGNMENT 

A. Multiple Choice Questions (5 Marks)

1. Microsoft Excel is a ______ application.

A. drawing

B. spreadsheet

C. music

D. video

2. Microsoft Excel is mainly used to ______.

A. play games

B. watch movies

C. browse the internet

D. organise and calculate data

3. Which letter appears on the Microsoft Excel icon?

A. P

B. W

C. X

D. E

4. Which button is clicked first to launch Microsoft Excel from the Start Menu?

A. Start

B. Close

C. Save

D. Refresh

5. Microsoft Excel is developed by ______.

A. Google

B. Apple

C. Microsoft

D. Samsung

B. Fill in the Blanks (5 Marks)

6. Microsoft Excel is a ______ application.

7. Microsoft Excel organises data into ______ and columns.

8. The Microsoft Excel icon is usually ______ in colour.

9. A workbook contains one or more ______.

10. You can launch Microsoft Excel by clicking the ______ button.

C. True or False (5 Marks)

11. Microsoft Excel is used to organise and calculate data. ______

12. The Microsoft Excel icon contains the letter X. ______

13. Microsoft Excel can be launched from the Start Menu. ______

14. Microsoft Excel is used mainly for creating slide presentations. ______

15. Rows and columns are found in Microsoft Excel. ______

D. Match Column A with Column B (5 Marks)

Column A – Column B

16. Microsoft Excel – A. Green icon with the letter X

17. Workbook – B. Spreadsheet application

18. Worksheet – C. A page inside a workbook

19. Rows – D. Horizontal lines in a worksheet

20. Excel Icon – E. Contains one or more worksheets

ANSWER KEYS

1. B – Spreadsheet

2. D – Organise and calculate data

3. C – X

4. A – Start

5. C – Microsoft

6. spreadsheet

7. rows

8. green

9. worksheets

10. Start

11. True

12. True

13. True

14. False

15. True

16. B – Spreadsheet application

17. E – Contains one or more worksheets

18. C – A page inside a workbook

19. D – Horizontal lines in a worksheet

20. A – Green icon with the letter X

SUMMARY

In this lesson, pupils learned that Microsoft Excel is a spreadsheet application developed by Microsoft for entering, organising, calculating, storing, and analysing data.

They also learned the common uses of Microsoft Excel, such as preparing tables, performing calculations, keeping records, analysing data, creating charts, preparing examination scores, and managing budgets.

Pupils identified the Microsoft Excel icon, which is usually green with the letter X, and learned different ways of launching Microsoft Excel, including through the Start Menu, Search Box, and Desktop Shortcut.

Finally, pupils identified the main parts of the Microsoft Excel window, including the Title Bar, Ribbon, Quick Access Toolbar, Workbook, Worksheet, Rows, Columns, Cells, Formula Bar, Sheet Tabs, and Status Bar. They understood that these features help users enter, organise, edit, and manage data efficiently.

PRESENTATION

To deliver the lesson, the teacher adopts the following steps:

Step 1: Introduction – The teacher displays a table containing pupils’ names and examination scores and asks how such records can be organised and calculated easily. The teacher introduces Microsoft Excel as a spreadsheet application used for organising and calculating data.

Pupils’ Activities: Pupils observe the table and discuss how computers can help organise information.

Step 2: Meaning of Microsoft Excel – The teacher explains that Microsoft Excel is a spreadsheet application used to enter, organise, calculate, store, and analyse data.

Pupils’ Activities: Pupils explain the meaning of Microsoft Excel in their own words.

Step 3: Uses of Microsoft Excel – The teacher discusses the uses of Microsoft Excel, including:

• Entering and organising data.

• Performing calculations.

• Preparing tables and records.

• Creating charts and graphs.

• Preparing examination results.

• Keeping financial records.

Pupils’ Activities: Pupils mention different uses of Microsoft Excel.

Step 4: Demonstration of How to Launch Microsoft Excel – The teacher demonstrates the different methods of launching Microsoft Excel:

• Using the Start Menu.

• Using the Search Box.

• Using the Desktop Shortcut.

The teacher opens Microsoft Excel for the class to observe.

Pupils’ Activities: Pupils observe the demonstration and identify the Microsoft Excel icon.

Step 5: Identifying the Features of Microsoft Excel – The teacher points out and explains the following features:

• Title Bar

• Ribbon

• Quick Access Toolbar

• Workbook

• Worksheet

• Rows

• Columns

• Cells

• Formula Bar

• Sheet Tabs

• Status Bar

Pupils’ Activities: Pupils identify each feature on the Excel window as the teacher explains its function.

Step 6: Group Activity – The teacher divides the class into four groups and assigns the following activities:

• Group 1: Explain the meaning of Microsoft Excel and state five uses.

• Group 2: Demonstrate how to launch Microsoft Excel using the Start Menu or Search Box.

• Group 3: Identify and label the main features of the Microsoft Excel window.

• Group 4: Demonstrate how to open a workbook and identify rows, columns, and cells.

Each group presents its work before the class.

Pupils’ Activities: Pupils discuss, perform the assigned activities, and present their findings.

Step 7: Lesson Summary – The teacher reviews the meaning, uses, methods of launching Microsoft Excel, and the main features of the Excel window.

Pupils’ Activities: Pupils answer oral questions and summarise the lesson.

Step 8: Evaluation – The teacher asks oral and written questions to assess pupils’ understanding of Microsoft Excel, its uses, how to launch it, and its basic features.

Pupils’ Activities: Pupils answer the evaluation questions and participate actively in the lesson.

CONCLUSION

To conclude the lesson for the week, the teacher revises the entire lesson and links it to the following week’s lesson.

NEXT LESSON

Introduction to Programming Languages: Visual-Based and Text-Based Programming Languages Primary 4 (Basic 4) Third Term Week 9 Information Technology – Computer Studies

LESSON EVALUATION 

Teacher asks pupils,

1. What is Microsoft Excel?

2. State five uses of Microsoft Excel.

3. Mention three ways of launching Microsoft Excel.

4. Describe the Microsoft Excel icon.

5. Mention eight features of the Microsoft Excel window.

6. What is the function of each of the following?

(a) Title Bar

(b) Ribbon

(c) Formula Bar

(d) Status Bar

7. Differentiate between a workbook and a worksheet.

8. Explain the difference between rows, columns, and cells in Microsoft Excel.

9. Why is Microsoft Excel important in schools, offices, and businesses?

10. Demonstrate how to launch Microsoft Excel on a computer and identify the following features: Title Bar, Ribbon, Quick Access Toolbar, Workbook, Worksheet, Rows, Columns, Cells, Formula Bar, Sheet Tabs, and Status Bar.