Unit 1 — Advanced Word Processing and Desktop Publishing
6 classes
1.1 Explore Advanced Formatting Techniques in Word Processing
1.2 Implement Styles and Themes for Consistent Document Design
1.3 Utilize Templates to Streamline Document Creation
1.4 Integrate Tables and Graphics for Enhanced Presentation
1.5 Create Multi-page Layouts for Professional Publications
1.6 Publish and Share Documents Using Desktop Publishing Tools
Unit 2 — Database Management Fundamentals (MS Access)
6 classes
2.1 Understand the Basics of Database Concepts
2.2 Explore MS Access Interface and Features
2.3 Create a Simple Database in MS Access
2.4 Design and Structure Tables for Data Management
2.5 Develop Queries for Effective Data Retrieval
2.6 Generate Reports to Present Database Information
Unit 3 — Advanced Spreadsheets — Formulas, Charts, Macros
6 classes
3.1 Create and Evaluate Complex Formulas in Spreadsheets
3.2 Utilize Functions for Data Analysis and Calculation
3.3 Design and Customize Interactive Charts for Data Visualization
3.4 Implement Conditional Formatting to Enhance Spreadsheet Readability
3.5 Automate Tasks with Basic Macros in Spreadsheets
3.6 Integrate Advanced Features to Optimize Spreadsheet Performance
Unit 4 — Web Browsing, Email and Digital Collaboration Tools
6 classes
4.1 Explore Effective Web Browsing Techniques
4.2 Understand URL Structure and Its Components
4.3 Evaluate and Select Reliable Online Sources
4.4 Master Email Communication Etiquette
4.5 Utilize Digital Collaboration Tools for Teamwork
4.6 Integrate Web Resources into Collaborative Projects
Unit 5 — IT Project Work and Practical Assessment
6 classes
5.1 Define the Key Components of IT Project Management
5.2 Explore the Project Lifecycle Phases in IT
5.3 Identify Stakeholders and Their Roles in IT Projects
5.4 Develop a Project Plan Using Relevant Tools and Techniques
5.5 Implement Project Management Software for Tracking Progress
5.6 Assess and Present Project Outcomes and Learnings