Lecture Map
Source order: Class X syllabus hierarchy (Sub-subtopic order)
Theory: 21.5 PYQ: 21.5 Total: 43 Export Excel
Class Lecture Allocation
Edit only Theory and PYQ counts. Lecture names are generated from Primary Sub-subtopic. Use 0.5 + 0.5 to combine Theory and PYQ into one lecture when slots are tight.
Unit Subtopic Primary Sub-subtopic Concept_ID Theory PYQ Total
Unit 1: Digital Documentation (Advanced) Styles and Templates in Writer Writer styles and fill format mode X_IT_U1_WRITER_STYLES_FILL_FORMAT 0
Unit 1: Digital Documentation (Advanced) Styles and Templates in Writer Writer templates X_IT_U1_WRITER_TEMPLATES 0
Unit 1: Digital Documentation (Advanced) Table of Contents in Writer Creating and customizing table of contents X_IT_U1_TABLE_OF_CONTENTS 0
Unit 1: Digital Documentation (Advanced) Images and Drawing Objects in Writer Inserting and modifying images X_IT_U1_IMAGES_INSERT_MODIFY 0
Unit 1: Digital Documentation (Advanced) Images and Drawing Objects in Writer Positioning, wrapping and arranging images X_IT_U1_IMAGES_POSITION_WRAP 0
Unit 1: Digital Documentation (Advanced) Images and Drawing Objects in Writer Drawing objects and grouping X_IT_U1_DRAWING_OBJECTS_GROUPING 0
Unit 1: Digital Documentation (Advanced) Reviewing Documents in Writer Track changes, comments and document comparison X_IT_U1_REVIEW_TRACK_COMPARE 0
Unit 2: Electronic Spreadsheet (Advanced) Linking Data in Calc Sheet references and external data linking X_IT_U2_SHEET_REFERENCES_LINKING 0
Unit 2: Electronic Spreadsheet (Advanced) Linking Data in Calc Spreadsheet hyperlinks X_IT_U2_HYPERLINKS 0
Unit 2: Electronic Spreadsheet (Advanced) Data Consolidation and Subtotals Consolidating data, groups and subtotals X_IT_U2_CONSOLIDATE_GROUP_SUBTOTAL 0
Unit 2: Electronic Spreadsheet (Advanced) What-if Analysis in Calc Scenarios, Goal Seek and Solver X_IT_U2_SCENARIO_GOALSEEK_SOLVER 0
Unit 2: Electronic Spreadsheet (Advanced) Sharing and Reviewing Spreadsheet Sharing, tracking, reviewing and merging changes X_IT_U2_SHARING_REVIEWING_CHANGES 0
Unit 2: Electronic Spreadsheet (Advanced) Macros in Calc Macros in Calc X_IT_U2_MACROS_IN_CALC 0
Unit 5: Employability Skills Communication Skills II Communication methods, types and 7Cs X_IT_U5_COMMUNICATION_METHODS_7CS 0
Unit 5: Employability Skills Communication Skills II Communication barriers, feedback and writing skills X_IT_U5_COMMUNICATION_BARRIERS_FEEDBACK 0
Unit 5: Employability Skills Self-Management Skills II Stress management and emotional intelligence X_IT_U5_STRESS_EMOTIONAL_MANAGEMENT 0
Unit 5: Employability Skills Self-Management Skills II Self-awareness, self-motivation, time management and independent work X_IT_U5_SELF_AWARENESS_MOTIVATION_INDEPENDENT 0
Unit 5: Employability Skills ICT Skills II Operating system and desktop basics X_IT_U5_OS_DESKTOP_BASICS 0
Unit 5: Employability Skills ICT Skills II File and folder management X_IT_U5_FILE_FOLDER_MANAGEMENT 0
Unit 5: Employability Skills ICT Skills II Computer maintenance, malware, internet safety and passwords X_IT_U5_COMPUTER_MAINTENANCE_SECURITY 0
Unit 5: Employability Skills Entrepreneurial Skills II Entrepreneur qualities and myths X_IT_U5_ENTREPRENEUR_QUALITIES_MYTHS 0
Unit 5: Employability Skills Entrepreneurial Skills II Entrepreneur roles, functions and career X_IT_U5_ENTREPRENEUR_ROLE_FUNCTIONS 0
Unit 5: Employability Skills Green Skills II Sustainable development, SDGs and green economy X_IT_U5_SUSTAINABLE_DEVELOPMENT_GREEN_ECONOMY 0
Unit 3: Database Management System DBMS Concepts and Data Models DBMS basics, data and data models X_IT_U3_DBMS_BASICS_DATA_MODELS 0
Unit 3: Database Management System DBMS Concepts and Data Models Database keys and basic relational terms X_IT_U3_KEYS_RELATIONAL_TERMS 0
Unit 3: Database Management System LibreOffice Base Tables Table creation, data types and data entry X_IT_U3_BASE_TABLES_DATATYPES_ENTRY 0
Unit 3: Database Management System LibreOffice Base Tables Sorting and basic table operations X_IT_U3_SORTING_TABLE_OPERATIONS 0
Unit 3: Database Management System Relationships and Referential Integrity Table relationships and referential integrity X_IT_U3_RELATIONSHIPS_REFERENTIAL_INTEGRITY 0
Unit 3: Database Management System Queries in Base Queries, criteria and calculations X_IT_U3_QUERIES_CRITERIA_CALCULATIONS 0
Unit 3: Database Management System Forms and Reports Creating forms and reports X_IT_U3_FORMS_REPORTS 0
Unit 4: Maintain Healthy Safe and Secure Working Environment Workplace Health Safety and Security Safety policies, hazards and hazard control X_IT_U4_SAFETY_POLICIES_HAZARDS 0
Unit 4: Maintain Healthy Safe and Secure Working Environment Workplace Health Safety and Security Fire safety and fire prevention X_IT_U4_FIRE_SAFETY_PREVENTION 0
Unit 4: Maintain Healthy Safe and Secure Working Environment Workplace Health Safety and Security Accidents, first aid, evacuation and drills X_IT_U4_ACCIDENTS_FIRSTAID_EVACUATION 0
Unit 4: Maintain Healthy Safe and Secure Working Environment Workplace Quality and Ergonomics Office ergonomics, RSI and musculoskeletal problems X_IT_U4_ERGONOMICS_RSI_MUSCULOSKELETAL 0
Unit 4: Maintain Healthy Safe and Secure Working Environment Workplace Quality and Ergonomics Eye care, screen safety and workplace wellness X_IT_U4_EYECARE_SCREEN_WELLNESS 0
Totals 21.5 21.5 43
Heads up: submitting rebuilds this class lecture list and schedule from the configured start/end dates. A planner database backup is created first.