Unit 1 — Advanced Word Processing and Desktop Publishing
6 classes
1.1 Explore Advanced Word Processing Features
1.2 Utilize Styles and Formatting for Professional Documents
1.3 Create and Manage Tables for Data Presentation
1.4 Insert and Format Graphics to Enhance Documents
1.5 Implement Desktop Publishing Principles in Design
1.6 Develop a Complete Document Using Advanced Techniques
Unit 2 — Database Management Fundamentals (MS Access)
6 classes
2.1 Understand the Basics of Database Concepts
2.2 Navigate the MS Access Interface Effectively
2.3 Create a Simple Database and Tables
2.4 Design Forms for Data Entry in MS Access
2.5 Query Data Using Basic SQL in MS Access
2.6 Generate Reports to Analyze Database Information
Unit 3 — Advanced Spreadsheets — Formulas, Charts, Macros
6 classes
3.1 Explore Advanced Formula Functions in Spreadsheets
3.2 Implement Conditional Formatting to Visualize Data
3.3 Create and Customize Charts for Data Representation
3.4 Develop Dynamic Dashboards Using Multiple Charts
3.5 Introduce and Record Simple Macros for Automation
3.6 Apply Macros to Streamline Workflow and Processes
Unit 4 — Web Browsing, Email and Digital Collaboration Tools
6 classes
4.1 Understand Web Browsing Basics and Navigation Techniques
4.2 Explore Browser Features: History, Bookmarks, and Extensions
4.3 Practice Safe Browsing: Identifying Secure Websites and Threats
4.4 Set Up and Manage an Email Account Effectively
4.5 Utilize Email Features: Organizing, Archiving, and Professional Etiquette
4.6 Collaborate Using Digital Tools: Sharing Documents and Real-time Communication
Unit 5 — IT Project Work and Practical Assessment
6 classes
5.1 Define IT Project Work: Key Concepts and Importance
5.2 Identify Project Phases: Planning, Execution, and Evaluation
5.3 Develop a Project Proposal: Objectives and Scope
5.4 Utilize Project Management Tools: Introduction to Software Options
5.5 Conduct a Practical Assessment: Criteria and Best Practices
5.6 Present Your IT Project: Effective Communication Techniques