Lunching Microsoft Excel Primary 4 (Basic 4) Term 2 Week 8 Information Technology (Computer Studies)

INFORMATION TECHNOLOGY

COMPUTER STUDIES

SECOND TERM

WEEK 8

PRIMARY 4

THEME – BASIC CONCEPTS OF INFORMATION TECHNOLOGY 

PREVIOUS LESSON – Meaning and Types of Information | Uses of Information Primary 4 (Basic 4) Term 3 Week 4 Information Technology (Computer Studies)

TOPIC – MICROSOFT EXCEL 

LEARNING AREA

1. Introduction

2. Meaning of Microsoft Excel

3. Launching Microsoft Excel

4. Lesson Evaluation and Weekly Assessment (Test)

LEARNING OBJECTIVES 

By the end of the lesson, most pupils should have attained the following objectives –

1. describe Microsoft Excel.

2. lunch Microsoft Excel correctly.

ENTRY BEHAVIOUR

The pupils

INSTRUCTIONAL MATERIALS

The teacher will teach the lesson with the aid of functional computer with Microsoft Excel application.

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

LESSON 1 – INTRODUCTION 

Microsoft Excel is a spreadsheet program designed for everyday tasks such as setting up a budget, maintaining an address list, or keeping track of a list of to-do items.

Microsoft Excel is part of Microsoft Office, and comes pre-loaded on your computer.

It is very similar to Microsoft Excel in appearance.

LAUNCHING MICROSOFT EXCEL 

Open Excel Starter with the Windows Start button.

1. Click the Start button . If Excel Starter is not included among the list of programs you see, click All Programs, and then click Microsoft Office.

2. Click Microsoft Excel.

MICROSOFT EXCEL SPREADSHEET OR WORKBOOK 

The Microsoft Excel startup screen appears, and a blank spreadsheet is displayed.

In Microsoft Excel, the spreadsheet is called a worksheet, and worksheets are stored in a file called a workbook.

Workbooks can have one or more worksheets in them.

LESSON 2 – MICROSOFT SPREADSHEET OR WORKBOOK

 

1. Columns (labeled with letters) and rows (labeled with numbers) make up the cells of your worksheet.

2. Clicking the File tab opens the Backstage view of your workbook, where you can open and save files, get information about the current workbook, and perform other tasks that do not have to do with the content of the workbook, such as printing it or sending a copy of it in e-mail.

3. Each tab in the ribbon displays commands that are grouped by task.

• Use the Home tab, when you’re entering and formatting data.

• Use the Insert tab to add tables, charts, pictures, or other graphics to your worksheet.

• Use the Page Layout tab to adjust margins and layout, especially for printing.

• Use the Formulas tab to make calculations on the data in your worksheet.

4. The pane along the side of the Excel window includes links to Help and shortcuts to templates and clip art, to give you a head-start on creating workbooks for specific tasks, such as managing a membership list or tracking expenses.

The pane also displays advertising and a link to purchase a full-feature edition of Office.

LESSON 3 – LAUNCHING AND CREATING SIMPLE SPREADSHEET 

Teacher guides pupils in groups of create spreadsheet.

PRESENTATION

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

1. To introduce the lesson, the teacher revises the previous lesson. Based on this, he/she asks the pupils some questions;

2. Teacher displays chart showing Microsoft Excel.

3. Teacher organizes pupils in groups or pairs depending on the size of the class.

4. Teacher examples pupils chart.

5. Teacher asks pupils to turn on the computer system(s) with Microsoft Excel application.

6. Teacher guides pupils to locate Microsoft Excel button and asks them to the application on the computer.

7. Teacher lets pupils compare the homepage of Microsoft Excel with the one on the chart.

Pupil’s Activities – Lunch the Microsoft Excel on the computer and compare the homepage of Microsoft Excel with the one on the chart.

8. Teacher uses the chart and computer to introduce the lesson – Microsoft Excel.

Pupil’s Activities – Pay attention to the lesson introduction to understand the concept of Microsoft Excel.

9. Teacher discuss some of the icons on Microsoft Excel and their functions.

Pupil’s Activities – Participate actively in the class discussion by typing and use some of the icons.

10. Teacher summarizes the lesson on the board with appropriate lesson evaluation.

Pupil’s Activities – Participate actively in the summary of the lesson by responding correctly to the lesson evaluation and write as instructed.

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

LESSON EVALUATION 

Ask pupils to:

1. describe Microsoft Excel.

2. lunch Microsoft Excel correctly.