Curriculum
- 12 Sections
- 36 Lessons
- 12 Weeks
Expand all sectionsCollapse all sections
- Week 1/12: Fundamentals of Computing3
- 1.1Lecture 1: Fundamentals of computing, Computer Hardware, Software, Windows Components and user accounts1 Week
- 1.2Lecture 2: Navigating the Google Workspace, Understanding cloud storage, its benefits, and Gmail for Professional Email Management1 Week
- 1.3Lecture 3: Google Drive – Cloud Storage & File Management, and file access permissions & Google Meet – Virtual Meetings & Collaboration, and meeting controls1 Week
- Week 2/12: Fundamentals of MS WORD3
- Week 3/12: Design, Formatting and Macro (MS WORD)3
- 3.1Lecture 7: Open Indentation, Paragraph options, find, replace, goto, style, formatting and table of contents
- 3.2Lecture 8: Insert Tables, Shapes, smart art, charts, header & footer, hyperlink, page number, word Art, date & time, symbols and other options of insert tab
- 3.3Lecture 9: Design tab (themes, colors, watermark, page color, page borders), Draw Ribbon, Page layout & Printing techniques
- Week 4/12: Document Customization and Protection (MS WORD)3
- Week 5/12: Fundamentals of MS Excel3
- Week 6/12: Formulas &Functions in MS Excel3
- Week 7/12: Advance Excel3
- 7.1Lecture 19: Difference between Function & Formula, Application of formulas e.g. Sum, Average, Percentage, etc.
- 7.2Lecture 20: Excel Functions (Max, Min, Small, Large, Count, Countif, Vlookup & Hlookup etc.) Absolute Reference, Relative Reference
- 7.3Lecture 21: Logical Functions (If, If else, Nested if etc.) and Validation
- Week 8/12: Fundamentals of MS Power Point3
- 8.1Lecture 22: Conditional formatting, Sum if, Count if, Dsum, Dcount, Dmax, Dmin, Daverage
- 8.2Lecture 23: Logical Operators (AND, OR, NOT, XOR, TRUE, FALSE), proof reading and work sheet protection
- 8.3Lecture 24: Google Sheets – Data Management & Analysis, Essential formulas and functions (SUM, AVERAGE, IF, VLOOKUP), Creating charts and graphs, Collaboration and data sharing
- Week 9/12: Mastering MS Power Point3
- 9.1Lecture 25: Designing of presentation and Inserting media content in Presentation (Image, Audio, Video, etc.)
- 9.2Lecture 26: Designing, Background formatting, Recording of presentation, Font styling, Difference between animations and transitions, and Automating the presentation
- 9.3Lecture 27: Preparing a complete presentation by using slide master view and application of password protection. Google Slides – Professional Presentations, Adding and formatting text, images, and videos, Sharing and collaborating on presentations
- Week 10/12: MS Access, Outlook and Office 3653
- 10.1Lecture 28: Designing Tables, Defining primary keys and relationships in MS Access, understanding the role of queries, Creating basic queries and data retrieval
- 10.2Lecture 29: Tour of the Outlook interface, Configuring email accounts, brief on features like formatting, attachments, and signatures etc.
- 10.3Lecture 30: Exploration of Office 365 – a cloud-based suite of productivity tools, latest features, and improvements in Office 365 Word, Excel, etc.
- Week 11/12: Inpage (Pak Urdu) & Pak Urdu Installer3
- Week 12/12: Recap of Course & Final Project3
- 12.1Lecture 34: Importance of Soft Skills in Business Leadership, Verbal, Non-verbal, and Written Communication
- 12.2Lecture 35: Adaptability, Flexibility and Emotional Intelligence for Effective Interactions
- 12.3Lecture 36: Building a Resilient and Adaptable Professional Persona, Prioritization Techniques, Conflict Resolution, Decision-Making and Problem-Solving