COURSE OUTLINE FOR 2023
MODULE 1: GENERAL BASIC CONCEPTS
In this course, students will learn the features and functionality of the Windows 10 operating system for professional and personal use.
| Operating system (window 10) | INTERNET BROWSING |
|---|---|
| Discover the Start menu in Windows 10 | Internet Service Provider (ISP) |
| The desktop | Understanding the concept of Internet browser |
| Hard drive management | Finding information on the internet |
| Types of files | Saving information found on the internet |
| Launching an application from the Windows 10 menu | Downloading information found on the internet |
| File Manager | Managing bookmarks |
| System settings in Windows 10 | |
| Using and formatting a USB drive | Search Engine |
Module II – Data processing with Microsoft Word
Microsoft Word is designed to help you move smoothly through the task of creating professional-looking documents. Its rich features and powerful tools can make your work easy, and even fun. In this course, you will learn fundamental Word skills.
You will:
Navigate and perform common tasks in Word, such as opening, viewing, editing, saving, and printing documents, and configuring the application.
Format text and paragraphs.
Perform repetitive operations efficiently using tools such as Find and Replace, Format Painter, and Styles.
Enhance lists by sorting, renumbering, and customizing list styles.
Create and format tables.
Insert graphic objects into a document, including symbols, special characters, illustrations, pictures, and clip art.
Format the overall appearance of a page through page borders and colors, watermarks, headers and footers, and page layout.
Use Word features to help identify and correct problems with spelling, grammar, readability, and accessibility.
| Level 1: Basic Notions of Word | Level 2: Advanced Notions of Word |
|---|---|
| Basic functions of Microsoft Word | Text 1: Letter template to reproduce |
| Layouts of a Word document | Text styles in Word |
| Text correction and manipulation tools | Text formatting in journal mode |
| Lists and numbering | Inserting images in a Word document |
| Managing document printing and orientation | Managing illustrations in Word |
| Headers, footers, and page numbers | Creating document templates |
| Different types of tables in Word | Creating a signature in Word |
| Table formatting | Using Word’s reference tools |
| Page breaks and page numbers | Standard page numbers |
| Creating a form in Word | |
| Adding document protection in Word | |
| Table of contents for a standard document | |
| Concept of mail merge in Word | |
| Concept of macro commands in Word |
Module III – Microsoft Excel data sheet
This course aims to provide you with a foundation for Excel knowledge and skills. Fortunately, Microsoft Office Excel can help you organize, calculate, analyze, revise, update, and present your data in a simplify ways.
| LEVEL 1: BASIC CONCEPTS | LEVEL 2: ADVANCED CONCEPTS |
|---|---|
| Knowledge of Excel | Data entry in multiple forms |
| Entering data in a cell | Calculations in Excel |
| Alignment in a cell | Graphs in Excel |
| Cell formatting | Customizing a graph |
| Creating a simple table | Data lists |
| Formatting a table | Freezing panes |
| Arithmetic operations (basic calculations) | Filters |
| Graphs in Excel | Advanced functions |
| Basic functions | Pivot tables |
| Printing a sheet | Working with multiple workbooks |
| Naming a sheet | Dashboard in Excel |
| Recording Excel macros | |
| Using data analysis tools |