Certificate in Computers Application Packages | Microsoft Office

Course Modules

Course instrutor >> Mr. Dominic

Summary

In today's digital world, computers are integral to almost every field, making computer literacy an essential skill. This course offers a comprehensive understanding of the basic concepts, components, and uses of computers. Moreover, Plus, I'll guide you through the famous Microsoft Office apps, from beginner to expert—step by step!

The course is structured to guide learners from foundational knowledge to practical skills, ensuring you are well-equipped to navigate and leverage computer technology in your personal, academic, and professional life.

Below is a detailed outline of what this course covers, giving you an in-depth look at each module and its learning objectives.

Module 1: Introduction to Computer

---

This module covers the basic concepts of what a computer is, its history, classification and why it's essential in today's world. Here, we will cover basic concepts including;

• Definition of a Terms
• History of Computers
• Classification of Computers
• Importance of computer in our daily lives and various fields
• Click here to Watch the Video
• Click here to open the Module Quiz

Outcome: The student will understand the fundamental role of computers in our modern society.

Module 2.1: Computer System -- Hardware

---

Here, you will learn about the hardware and software components that make up a computer system.

• Hardware Components
• Definition of Terms
• Input Devices
• Output Devices
• Processing Hardware
• Storage Hardware
• Click here to Watch the Video
• Click here to open the Module Quiz

Objectives You will be able to identify and explain the roles of each hardware component.

Module 2.2: Computer System -- Software

---

Here, you will learn about the software components that make up a computer system.

• Computer Software
• Definition of Terms
• Classification of Computer Software
• According to purpose
• According to acquitition
• According to user-licence agreement
• System Software
• Application Software
• Click here to Watch the Video
• Click here to open the Module Quiz

Objectives

• Computer software can help you communicate ideas, data, and information through documents, presentations, and visual media.
• Learning computer software will help you develop problem-solving skills.
• You'll develop a creative mindset that can lead to more efficient and user-friendly software applications.
• Learning computer software will help you prepare for a career in a field that uses computers, such as software development, web design, data analysis, or digital marketing.

Module 3: Operating Systems and Software Applications

In this module, we explore operating systems (OS) and common software applications that enable us to interact with computers effectively:

• Operating Systems Basics: Learn OS is, its primary functions, and explore popular operating systems like Windows, macOS, Linux, and mobile OS like Android and iOS.
• File Management and System Navigation: Understand how to navigate the OS, organize files, and utilize system settings.
• Introduction to Software Applications: Get familiar with essential software applications, including word processors, spreadsheets, web browsers, and email clients.
• Click here to Watch the Video
• Click here to open the Module Quiz

Outcome: You'll gain a working knowledge of operating systems and essential software, allowing you to navigate and manage files efficiently.

Module 4: Internet and Networking Basics

This module introduces you to the world of internet connectivity and networks, explaining how computers communicate:

• What is the Internet? Learn about the Internet’s role in connecting people and devices globally.
• Networking Basics:Understand how networks (LAN, WAN) work and the significance of routers, switches, and servers.
• Safe Internet Browsing and Security:Tips for safe browsing, recognizing threats (like viruses and malware), and protecting personal information online.
• Click here to Watch the Video
• Click here to open the Module Quiz

Outcome: Identify and explain the roles of each component in a computer system.

Module 5: Productivity Tools and Applications

In this section, we dive into productivity applications, essential tools for both students and professionals

• Document Processing with Microsoft Word.
• Spreadsheets with Microsoft Excel.
• Data Management with Microsoft Access.
• Presentations with Microsoft PowerPoint.
• Graphics and Design with Microsoft Publisher.
• Click here to Watch the Video
• Click here to open the Module Quiz

Outcome:

• You’ll comfortably create, edit, and format documents using popular programs like Microsoft Word and Google Docs.
• Learn the basics of spreadsheets with tools like Microsoft Excel, including how to input data, use formulas, and create charts.
• Learn how to create presentations using software like PowerPoint or Google Slides.

Module 6: Microsoft Word for Everyday Use

Learn how to use MS Word in this free online course that covers the word processor’s basic and advanced features.

---

This Microsoft Word tutorial explains step by step how to use this popular word processor to complete everyday professional and personal tasks.
MS Word remains the most-used word-processing software in the world and proficiency in the program is required by most individuals and organizations for a range of purposes every day.

---

This MS Word tutorial course suits both beginner and advanced users as it explores the program’s many useful features.

• Introduction to Word
• Creating and Saving Documents
• Formatting elements in Microsoft Word
• Page settings and Printing
• Working with images and shapes
• Working with Tables
• Click here to Watch the Video
• Click here to open the Module Quiz

Objectives

• Learn how to navigate Microsoft Word, create, open, and save documents efficiently.
• Apply text formatting, styles, and layout options to enhance document presentation.
• Adjust margins, orientation, and printing settings to prepare documents for professional use.
• Insert and manipulate images, shapes, and other graphic elements to improve document design.
• Create, format, and edit tables to structure information effectively for reports and presentations.

Module 7: Online Microsoft Excel Course

Learn Microsoft Excel and conquer your spreadsheet demons with this free online Excel video course.

This online Microsoft Excel course is perfect for those brand new to Excel and who are using Excel 2019 and hirer editions. You'll learn everything from how to create basic formulas in Excel, to how to print the correct part of your spreadsheet! In this course, your expert author gives you a solid grounding in the basics of Excel and guides you towards becoming more confident with spreadsheets.

• Introduction to Excel
• Creating and Saving Workbooks
• Navigating Workbooks
• Page-set up and Print options
• Working with Rows, Columns, and Cells
• Moving Data
• Formulas and Functions
• Working with Sheets
• Click here to Watch the Video
• Click here to open your course assessment.

Outcomes In This Course, You Will Learn How To;

• Describe how to create basic formulas in Excel
• Explain how Relative References and Order of Operations works in Excel
• Explain how to save your work and use file extensions
• Explain how to insert headers and footers in Excel
• Describe how to use copy, cut and paste commands to save time
• Explain how to print the correct part of your spreadsheet
• Describe how to add rows and columns and how to change column widths
• Explain how formulas in Excel work and how to use essential functions

Module 8: Advanced Features in Microsoft PowerPoint

Become expert in Microsoft PowerPoint by mastering some of its advanced features with this online course.

This online course shows you how to use some of Microsoft PowerPoint‘s advanced features. We take you beyond the ordinary features of the program to some of its more high-level capabilities that can make your presentations more engaging and lively. This course suits anyone who often meets clients or students and would like to captivate their audience with advanced presentation skills.

• Introduction to PowerPoint Presentation
• Modifying PowerPoint Environment
• Customizing Design Templates
• Adding SmartArt and Math Equations to a presentation
• Working with Media and animations
• Collaborating on presentation
• Customizing a slideshow
• Securing and distributing a presentation
• Click here to Watch the Video
• Click here to open your course assessment

Objectives:

• Explain customizing the status bar of your PowerPoint 2016 to suit your specific needs
• Compare contents on slides by creating multiple presentation windows
• Outline how to configure the program to automatically save your work after specific time intervals.
• Arrange sections in your presentation and organize your slides
• Compare and merge slides in PowerPoint 2016
• Describe how to use the ‘annotation’ tool to improve the quality of your presentation
• Select action buttons to a slide show to help your audience navigate some of the slides by themselves.