MICROSOFT OFFICE APPLICATION (Basic to Intermediate Level)

Course Objectives:

1. To develop fundamental computer literacy skills.
2. To navigate and understand the Microsoft Office interface, ensure a comfortable working environment within Word, Excel, and PowerPoint.
3. To customize and tailor the Microsoft Office applications to individual preferences and needs, ensuring an optimized workflow.
4. To troubleshoot common issues and errors within Microsoft Office applications and seek help when needed.
5. To efficiently employ time-saving techniques, such as keyboard shortcuts, templates, and macros, to boost productivity.

Learning Outcomes:

Microsoft Word (Word Processing):

1. Creating and Formatting Documents:

• Create and format basic documents, including setting fonts, margins, and line spacing.
• Apply styles and themes to enhance the document’s visual appeal.

2. Text Editing and Proofreading:

• Use basic text editing features like copy, cut, paste, and spell check.
• Proofread and correct documents for spelling and grammar errors.

3. Page Layout and Printing:

• Adjust page layout settings, including page size, orientation, and margins.
• Understand and use printing options effectively.

4. Tables and Lists:

• Create and format tables and lists within documents.
• Customize table and list properties.

5. Headers, Footers, and Page Numbers:

• Add headers, footers, and page numbers to documents.

Microsoft Excel (Spreadsheets):

6. Data Entry and Formatting:

• Enter data into cells and format it (e.g., numbers, text, dates).
• Apply basic cell formatting (borders, shading, font styles).

7. Formulas and Functions:

• Create and use simple formulas to perform calculations.
• Utilize common functions (e.g., SUM, AVERAGE, IF) to analyze data.

8. Charts and Graphs:

• Create basic charts and graphs to visually represent data.
• Format and customize charts for clarity and appeal.

9. Data Sorting:

• Sort data in ascending or descending order.

Microsoft PowerPoint (Presentations):

10. Creating Slides:

• Create slides with text, images, and other media elements.
• Apply slide layouts and themes.

11. Slide Transitions and Animations:

• Add slide transitions and animations to enhance presentations.
• Control the timing and effects of transitions and animations.

12. Slide Show Delivery:

• Run and navigate a slide show, including using presenter view.

13. Exporting and Sharing:

• Export presentations in different formats (e.g., PDF).

Methodology:

• Practice and Exploration
• Assessments
• Troubleshooting and Problem Solving
• Understand of Basics Word, Excel, and PowerPoint
• Keyboard Shortcuts

Target Audiences:

1. Students:
• School students, College and university: Students from elementary to high school levels who need to develop basic computer skills and use Office applications for assignments and projects.

2. Professionals:
• Entry-level employees: new hires or individuals transitioning to office jobs who need to learn how to use Office tools for daily tasks.
• Administrative staff: Administrative assistants, receptionists, and clerical workers who rely on Office applications for document management and communication.
• Small business owners: Entrepreneurs and small business owners who use Office applications for various business needs.
3. Job Seekers
• Job seekers and career changers: People looking to improve their Office skills to increase their employability and job prospects.
4. Seniors and Older Adults:
• Older adults: Seniors who want to learn how to use Office applications for personal use.