Microsoft Office Applications
This module will provide the learner with basic knowledge and skills to familiarise with the use and working of computers using different modern information communication technologies. He/she will acquire hands-on experience in Microsoft Office applications that will enable him/her to digitally access, process, store, and disseminate information.

Learning Outcome
By the end of this module, the learner should be able to operate computer apparatus and elementary programs without any assistance.

Module 1: Microsoft Office Word

Competences

The learner:
• loads a Microsoft word processing application.
• records text in a new word document.
• uses inbuilt formatting tools to make the document appear professional.
• writes and sends letters to a large group using mail merging.
• generates automated table of contents.
• sets page layout to the appropriate measurements.
• saves the document into folder/fixed or portable storage medium.
• prints the processed documents.


Content
• Loading Microsoft Word
• Entering text in a new word document.
• Formatting text (font: colour, bold, size, alignment, line spacing, drop caps, word art, text columns).
• Inserting (pictures, tables, symbols, page numbers, footers, headers, text columns, footnotes/end notes).
• Mail merge
• Paper orientation (portrait and landscape),
• Page background (text and picture watermark, page
borders/textures)
• Automatic Table of contents.
• Saving (on desktop, folder, a fixed and portable storage media e.g. flash or compact disk).
• Printing

Teaching and Learning Strategies
• Demonstrate to learners how to get started with Microsoft Word.
• Use simulations to let learners compose text and proofread.
• Guide learners to set page layout and margins.
• Demonstrate to learners how to set automated table of contents and task them to practise.
• Guide learners to use toolbar buttons to format text to appear professional.
• Group learners andtask them to typeset a document with multiple features.
• Guide learners to save documents on different media.
• Let learners print their own documents.

Assessment Strategies
Assign each learner to typeset a document with multiple features in Microsoft Word and produce hard copies of documents.

Teaching and Learning Resources
• Computer installed with Ms Word
• Internet
• Overhead projector
• Printer
• Compact discs and Flash discs
• Printing paper

Module 2: Microsoft Office Excel

Competences
The learner:
• loads Microsoft electronic spreadsheet application.
• records data into a spreadsheet.
• uses inbuilt formatting tools to rofessionally enter data in the spreadsheet cells.
• computes data using Ms Excel inbuilt functions.
• presents data using auto generated charts, tables, or graphs.
• saves the document into Folder/Fixed or Portable storage medium.
• prints worksheet ocuments.

Content:
• Loading Microsoft Excel
• Entering text/numbers in a worksheet.
• Formatting Cells (Currency, borders, commas, decimal places, alignment, merging cells).
• Computing data with nbuilt functions (Sum, Average, Max, Min, IF and Count IF).
• Formatting cells (currency, borders, commas, decimal places, alignment, merging cells, text irection).
• Data management (sorting, filtering).
• Inserting rows, columns,
• Presenting data in charts, tables, and graphs.
• Page layout (margins and paper orientation).
• Printing a spreadsheet


Teaching and Learning Strategy
• Guide learners to get load the Ms Excel application.
• Demonstrate the recording of data in a worksheet.
• Task learners to compute data using Ms Excel inbuilt functions.
• Task learners toformat cells, sort and filter data.
• Demonstrate how to create graphs and charts in a spreadsheet.
• Demonstrate the computation of data simulations.

Assessment Strategies
Assign learners a class work to:
i) Type names of learners in their class and sort them in alphabetical order.
ii) Filter names of girls from those of boys and use an excel function to establish the total number of girls in the class.

Teaching and Learning Resources
• Computer installed with Ms Excel
• Internet
• Overhead projector
• Printer
• Compact discs and Flash discs
• Printing paper


Module 3: PowerPoint Presentations
Duration: 12 Hours

Competences
The learner:
• identifies the features of a PowerPoint presentation.
• prepares PowerPoint slides using inbuilt formatting tools.
• presents slides with animatiOonsS.
• prints several slides on a page.

Content
• Features of PowerPoint
• Creating new slide:
• Title Slide
• Tabular slide
• Two column-Text slide
• Formatting a slide:
• Background design
• Inserting images (clip art and picture)
• Customised animations and t r ansitions
• Creating a Slide loop
• Running a slide show
• Printing slides

Teaching and Learning Strategy
• Let learners identify the features of a PowerPoint document.
• Demonstrate the functions of design tOols in Ms Publisher.
• Guide learners on hOw to create new Slides
• Demonstrate the artistic formatting of a slide.
• Let learners simulate the customization of slide transitions.
Assessment Strategies
Assign learners to use simulations to create slides and:
i) Format them to appear artistic.
ii) Create a slide Loop and run the slides.
iii) Make PowerPoint presentations in class.

Teaching and Learning Resources
• Computer installed with Ms Excel
• Internet
• Overhead projector
• Printer
• Compact discs and Flash discs
• Printing paper
• External speakers
• Laser Printer

MODULE 4: Microsoft Access
Duration: 13 Hours

Microsoft Access
Competences
The learner:
• loads a Microsoft Access application.
• applies database terminologies correctly.
• organises attributes and relations to attain data integrity.
• populates database using the Form object/tool.
• arranges database using Structured Query Language (SQL).
• presents data using the report object/tool.

Content
• Loading Microsoft Access
• Object/tools of a database
- Table,
- Form,
- Query
- Report
• Data attributes
• Setting primary and foreign keys
• Creating a relationship between 2 tables.
• Database normalisation / third normal form (2NF)
• Populating a database using electronic forms
• Using Reports
• Querying a database using clauses (and, or, like)
• Computations on captured data (add, subtract, multiply, divide and percentages)
• Printing database • Guide learners to get started with Ms Access.
• Demonstrate to learners how to create and normalise a database from (1NF-3NF)
• Demonstrate how to populate a database using electronic forms.

Teaching and Learning Strategy
• Guide learners on hOw to compute data and query a database.
• Demonstrate to learners how database reports are created and displayed, task them to practise.
• Guide learners on how to save and print database details.

Assessment Strategies
Task learners to create databases and carry out the following processes and printout the final documents:
i) Normalise a database to 2NF
ii) Populate a database using hypothetical data
iii) Compute and query database using AOL Clauses
iv) Display reports of specific columns (attributes)

Teaching and Learning Resources
• Computer installed with Ms Access
• Internet
• Overhead projector
• Printer
• Compact discs and Flash discs
• Printing paper

Suggested References
Tutorials Point (2017). Computers Fundamentals. https://www.tutorialspoint.com/computer fundamentals /computer fundamentals tutorial.pdf

Fundamentals of Computer. Question bank.
http://nmu.ac.in/Portals /0/0uestion%20Bank/F.%20Y.%20B.%20S c.(Computer%20Science)%20Paper%20I%20Ouestion%20Bank.pdf

Microsoft Word 2013 Part 1 Introduction to Word, free PDF tutorial for Beginners users. https://www.computer-pdf.com/office/word/619-
tutorial-microsoft-word-2013-part-1-introduction.html

Kennesaw State University, Mail Merge and Creating Forms, programme tutorial training https://www.computer-pdf.com/office /word/475- tutorial-word-2016-mail-merge-and-creating-forms.html

Kennesaw State University, Microsoft Word 2016 - Formatting your Document, programme tutorial. https://www.computer- pdf.com/office/word/474-tutorial-word-2016-formatting-your- document.html

Introduction to word 2016. https://www.computer- pdf.com/office/word/472-tutorial-introduction-to-word-2016.html

Martin, J. (1977). Computer Database Organization. 2nd edn. USA, Prentice Hall.

Sanjay, S. (2010), A First Programme in Computers. 2nd edn: Vikas Publishing House.

Fred Mugivane (2004). Introduction to Computer. Nairobi, Advatech Office Supplies Ltd.

  • Teacher: Jushua Wandera
  • Enrolled students: No students enrolled in this course yet