Desktop Publishing Applications: Microsoft Word, Microsoft Excel and Microsoft PowerPoint Primary 5 (Basic 5) Third Term Week 6 Information Technology – Computer Studies

DESKTOP PUBLISHING APPLICATIONS: MICROSOFT WORD, MICROSOFT EXCEL AND MICROSOFT POWERPOINT

INFORMATION TECHNOLOGY (COMPUTER STUDIES)

PRIMARY 5 – THIRD TERM – WEEK 6

THEME – BASIC COMPUTER OPERATIONS 

PREVIOUS LESSON – Digital Skills: Meaning, Components and Importance of Digital Skills Primary 5 (Basic 5) Third Term Week 5 Information Technology – Computer Studies

TOPIC – DESKTOP PUBLISHING APPLICATIONS 

LEARNING AREA

1. Introduction

2. Microsoft Word, Microsoft Excel and Microsoft PowerPoint

3. Difference Between Microsoft Word, Microsoft Excel and Microsoft PowerPoint

4. Practical Application of Desktop Publishing Applications

5. Weekly Assessment: Test Questions and Answers/Assignment

6. Summary

LEARNING OBJECTIVES 

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

1. Define desktop publishing applications.

2. Identify Microsoft Word, Microsoft Excel, and Microsoft PowerPoint as desktop publishing applications.

3. Explain the uses of Microsoft Word.

4. Explain the uses of Microsoft Excel.

5. Explain the uses of Microsoft PowerPoint.

6. Differentiate between Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

ENTRY BEHAVIOUR

In the previous lesson, pupils learned about digital skills and the practical abilities needed to use computers and other digital devices effectively.

Building on that knowledge, pupils will now learn about desktop publishing applications, such as Microsoft Word, Microsoft Excel, and Microsoft PowerPoint, which are software programs used to create documents, perform calculations, organise data, and prepare presentations.

INSTRUCTIONAL MATERIALS

The teacher will teach the lesson with the aid of:

1. Desktop or laptop computer

2. Microsoft Word

3. Microsoft Excel

4. Microsoft PowerPoint

5. Projector (if available)

6. Whiteboard and marker

7. Sample documents, spreadsheets, and presentations

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

Every day, people use computers to type letters, prepare reports, organise information, calculate numbers, and create presentations. To perform these tasks, they use special computer programs called desktop publishing applications.

Some of the most common desktop publishing applications are Microsoft Word, Microsoft Excel, and Microsoft PowerPoint. In this lesson, pupils will learn the meaning of desktop publishing applications, the uses of these three Microsoft Office programs, and how each one helps people complete different tasks at school, at home, and in the workplace.

LESSON 1 – MEANING OF DESKTOP PUBLISHING APPLICATIONS

Desktop publishing applications are computer software programs used to create, edit, format, organise, and print documents, spreadsheets, presentations, and other digital publications.

They help users produce neat and professional work using a computer.

MICROSOFT WORD

Microsoft Word is a word processing application used to create, edit, format, save, and print text documents.

Uses of Microsoft Word

1. Typing letters.

2. Preparing assignments.

3. Writing reports.

4. Creating notes.

5. Designing certificates.

6. Preparing examination questions.

7. Printing documents.

8. Creating newsletters and simple brochures.

MICROSOFT EXCEL

Microsoft Excel is a spreadsheet application used to organise data, perform calculations, and create charts.

Uses of Microsoft Excel

1. Performing calculations.

2. Recording pupils’ scores.

3. Preparing class attendance.

4. Organising data in rows and columns.

5. Creating tables.

6. Producing charts and graphs.

7. Preparing budgets.

8. Managing records.

MICROSOFT POWERPOINT

Microsoft PowerPoint is a presentation application used to create and display slides.

Uses of Microsoft PowerPoint

1. Preparing classroom presentations.

2. Teaching lessons using slides.

3. Presenting projects.

4. Displaying pictures and videos.

5. Creating educational slide shows.

6. Presenting seminar topics.

7. Creating animations.

8. Sharing information during meetings.

LESSON 2 – DIFFERENCE BETWEEN MICROSOFT WORD, MICROSOFT EXCEL AND MICROSOFT POWERPOINT

1. Microsoft Word

• Used mainly for typing and formatting text documents.

• Produces letters, reports, assignments, and notes.

2. Microsoft Excel

• Used mainly for calculations and organising data.

• Produces spreadsheets, tables, charts, and records.

3. Microsoft PowerPoint

• Used mainly for creating slide presentations.

• Produces slides used during teaching, meetings, and public presentations.

IMPORTANCE OF DESKTOP PUBLISHING APPLICATIONS

Desktop publishing applications help people to:

1. Prepare professional documents.

2. Organise information properly.

3. Perform calculations quickly.

4. Create attractive presentations.

5. Save time and effort.

6. Improve learning and communication.

7. Store and retrieve information easily.

8. Increase productivity at school, home, and work.

LESSON 3 – PRACTICAL APPLICATION OF DESKTOP PUBLISHING APPLICATIONS

The teacher demonstrates how to use the three desktop publishing applications.

Activity 1: Microsoft Word

1. Open Microsoft Word.

2. Type your name, class, and school.

3. Format the text by changing the font size, font colour, and alignment.

4. Save the document as My First Document.

Activity 2: Microsoft Excel

1. Open Microsoft Excel.

2. Create a simple table with the headings:

• Name

• English

• Mathematics

3. Enter the names and scores of three pupils.

4. Save the spreadsheet as Pupils’ Scores.

Activity 3: Microsoft PowerPoint

1. Open Microsoft PowerPoint.

2. Create a presentation with two slides.

• Slide 1: Title – Desktop Publishing Applications

• Slide 2: List Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

3. Apply a simple design theme.

4. Save the presentation as My Presentation.

CLASS PRACTICAL

Each pupil should:

1. Open Microsoft Word and type a short paragraph about themselves.

2. Open Microsoft Excel and create a simple table containing three subjects and their scores.

3. Open Microsoft PowerPoint and prepare a two-slide presentation introducing themselves.

4. Save all three files in a folder named Desktop Publishing Practice.

WEEKLY ASSESSMENT: TEST QUESTIONS AND ANSWERS/ASSIGNMENT 

A. Multiple Choice Questions (5 Marks)

1. Desktop publishing applications are used to create and edit ________.

A. digital documents

B. vehicles

C. roads

D. digital documents

2. Which application is mainly used for typing letters and reports?

A. Microsoft Word

B. Microsoft Excel

C. Microsoft PowerPoint

D. Paint

3. Which application is mainly used for calculations and tables?

A. Microsoft Word

B. Microsoft Excel

C. Microsoft PowerPoint

D. Notepad

4. Which application is mainly used for slide presentations?

A. Microsoft Excel

B. Microsoft Word

C. Microsoft PowerPoint

D. Calculator

5. Which of the following is not a desktop publishing application?

A. Microsoft Word

B. Microsoft Excel

C. Microsoft PowerPoint

D. Microsoft Edge

B. Fill in the Blanks (5 Marks)

6. ________ is used to prepare text documents.

7. ________ is used to organise data and perform calculations.

8. ________ is used to create slide presentations.

9. Desktop publishing applications help people produce ________ documents.

10. Microsoft Excel stores information in ________ and columns.

C. True or False (5 Marks)

11. Microsoft Excel is used for typing documents. ________

12. Microsoft Word is used to create spreadsheets. ________

13. Microsoft PowerPoint is used for presentations. ________

14. Microsoft Word is mainly used for calculations. ________

15. Desktop publishing applications improve productivity. ________

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

Column A – Column B

16. Microsoft Word – A. Creates presentations

17. Microsoft Excel – B. Types documents

18. Microsoft PowerPoint – C. Performs calculations

19. Spreadsheet – D. Organises data in rows and columns

20. Presentation – E. Collection of slides

ANSWER KEYS

1. D

2. A

3. B

4. C

5. D

B. Fill in the Blanks

6. Microsoft Word

7. Microsoft Excel

8. Microsoft PowerPoint

9. professional

10. rows

11. False

12. False

13. True

14. False

15. True

16. B – Types documents

17. C – Performs calculations

18. A – Creates presentations

19. D – Organises data in rows and columns

20. E – Collection of slides

SUMMARY

In this lesson, pupils learned that desktop publishing applications are computer software programs used to create, edit, format, organise, and print digital documents, spreadsheets, and presentations.

They learned about Microsoft Word, which is used for typing and formatting documents such as letters, reports, assignments, and notes.

They also learned about Microsoft Excel, which is used to organise data, perform calculations, prepare tables, create charts, and manage records.

Furthermore, pupils learned that Microsoft PowerPoint is used to create and present slide shows for teaching, learning, meetings, seminars, and project presentations.

Finally, pupils understood the differences between Microsoft Word, Microsoft Excel, and Microsoft PowerPoint, and appreciated the importance of desktop publishing applications in improving learning, communication, organisation, and productivity.

PRESENTATION

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

Step 1: Introduction – The teacher displays the icons of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint and asks pupils if they have seen or used any of them. The teacher explains that these are desktop publishing applications used for different computer tasks.

Pupils’ Activities: Pupils identify the applications they have seen or used.

Step 2: Meaning of Desktop Publishing Applications – The teacher explains that desktop publishing applications are computer programs used to create, edit, organise, format, and print digital documents, spreadsheets, and presentations.

Pupils’ Activities: Pupils explain the meaning of desktop publishing applications in their own words.

Step 3: Microsoft Word – The teacher explains that Microsoft Word is a word processing application used for typing and formatting documents.

Also, discusses its uses, including:

• Typing letters

• Writing assignments

• Preparing reports

• Printing documents

Pupils’ Activities: Pupils mention documents that can be created using Microsoft Word.

Step 4: Microsoft Excel – The teacher explains that Microsoft Excel is a spreadsheet application used for organising data and performing calculations.

Also, discusses its uses, including:

• Recording scores

• Preparing attendance

• Performing calculations

• Creating tables and charts

Pupils’ Activities: Pupils identify tasks that can be done with Microsoft Excel.

Step 5: Microsoft PowerPoint – The teacher explains that Microsoft PowerPoint is a presentation application used to create slide presentations.

Also, discusses its uses, including:

• Classroom teaching

• Project presentations

• Meetings

• Educational slide shows

Pupils’ Activities: Pupils identify situations where PowerPoint presentations are used.

Step 6: Differences Between the Applications – The teacher explains the differences:

• Microsoft Word – Used for typing and formatting documents.

• Microsoft Excel – Used for calculations and organising data.

• Microsoft PowerPoint – Used for creating slide presentations.

Pupils’ Activities: Pupils compare the three applications and state their different uses.

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

• Group 1: Explain the meaning of desktop publishing applications.

• Group 2: Discuss the uses of Microsoft Word.

• Group 3: Explain the uses of Microsoft Excel.

• Group 4: Explain the uses of Microsoft PowerPoint and compare the three applications.

Each group presents its work before the class.

Pupils’ Activities: Pupils discuss, complete the assigned tasks, and present their findings.

Step 8: Lesson Summary – The teacher reviews the meaning of desktop publishing applications and the uses of Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

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

Step 9: Evaluation – The teacher asks oral and written questions to assess pupils’ understanding of the lesson.

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

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

Primary 5 – Information Technology Mid Term Test Questions and Answers

Setting Up HTML and How Html Works | Primary 5 (Basic 5) Information Technology (Computer Studies) | Third Term Week 8

LESSON EVALUATION 

Teacher asks pupils,

1. Define desktop publishing applications.

2. Mention three desktop publishing applications studied in this lesson.

3. Explain the meaning of Microsoft Word.

4. State five uses of Microsoft Word.

5. Explain the meaning of Microsoft Excel.

6. State five uses of Microsoft Excel.

7. Explain the meaning of Microsoft PowerPoint.

8. State five uses of Microsoft PowerPoint.

9. Differentiate between Microsoft Word, Microsoft Excel, and Microsoft PowerPoint.

10. Demonstrate your understanding by opening Microsoft Word to type a short paragraph, Microsoft Excel to create a simple table, and Microsoft PowerPoint to prepare a two-slide presentation.