This syllabus covers essential topics in MS Word, MS Excel, MS PowerPoint and Basic Internet Skills. The course is divided into four parts

1. Introduction to Keyboard + MS Word (Days 1-10)

2. MS Excel (Days 11-20)

3. MS PowerPoint (Days 21-26)

4. Basic Internet Skills + Freelancing (Days 27-36)

This syllabus covers essential topics in MS Word, MS Excel, MS PowerPoint and Basic Internet Skills. The course is divided into four parts

1. Introduction to Keyboard + MS Word (Days 1-10)

2. MS Excel (Days 11-20)

3. MS PowerPoint (Days 21-26)

4. Basic Internet Skills + Freelancing (Days 27-36)

Week 1 & 2: Keyboard + MS Word (Days 1 - 10)

Day 1:

• Syllabubs writing
• Introduction to keyboard layout:
  • Keyboard keys and their functions
  • Special keys and how they work
• Finger placement practice on Typing Master software
• How to open Control Panel and check Windows specifications

Day 2:

• Create a new file and folder on the desktop
• Change the directory of new files/folders and rename them
• Introduction to MS Word:
  • Overview of MS Word interface (ribbons, toolbars, and menus)
  • Creating, opening, saving, and closing documents
  • Basic text input and navigation
  • Formatting basics (fonts, font size, bold, italics, underline)

Day 3:

• Basic shortcut keys in MS Word
• Paragraph and page formatting:
  • Line spacing and paragraph alignment
  • Indentation and text justification
  • Bullets, numbering, and lists
  • Page setup (margins, orientation, paper size)

Day 4:

• Document editing:
  • Cut, copy, and paste
  • Undo, redo, and find/replace
  • Spell check, grammar check, and thesaurus
  • Track changes and comments

Day 5:

• Working with tables:
  • Creating and formatting tables
  • Adding/deleting rows and columns
  • Merging/splitting cells
  • Adjusting table properties (borders, shading)

Day 6:

• Inserting objects:
  • Pictures, shapes, and text boxes
  • Formatting charts
  • Headers, footers, and page numbers

Day 7:

• Page layout and sections:
  • Page and section breaks
  • Column formatting (single, double, triple)
  • Creating cover and title pages
  • Using watermarks and page borders

Day 8:

• Advanced formatting:
  • Using styles and themes
  • Creating and editing templates
  • Inserting hyperlinks
  • Creating a table of contents, index, and footnotes

Day 9:

• Working with templates:
  • Creating templates from scratch (Admission Forms, Salary Slip, Resumes)
  • Modifying and using existing templates

Day 10:

• Review and practical exercise:
  • Create a fully formatted document (resume, admission form, salary slip)
  • Apply learned skills (formatting, tables, headers, footers, etc.)

Week 3 & 4: MS Excel (Days 11 - 20)

Day 11:

• Introduction to MS Excel:
  • Overview of the Excel interface (ribbon, worksheet, workbooks)
  • Navigating cells, rows, columns
  • Entering data and basic formulas
  • Saving and organizing Excel files

Day 12:

• Formatting cells:
  • Font, alignment, borders, and shading
  • Adjusting column width and row height
  • Merging cells and text wrapping
  • Formatting numbers, dates, and text

Day 13:

• Basic formulas and functions:
  • Arithmetic operations (addition, subtraction, multiplication, division)
  • Introduction to functions (SUM, AVERAGE, MIN, MAX)
  • Cell references (relative, absolute, mixed)

Day 14:

• Working with rows, columns, and sheets:
  • Inserting, deleting, and hiding rows/columns
  • Moving/copying rows, columns, and sheets
  • Renaming and organizing worksheets
  • Freeze panes and split windows

Day 15:

• Sorting and filtering data:
  • Sorting (ascending, descending, custom sort)
  • Using filters to display specific data
  • Removing duplicates

Day 16:

• Charts and graphs:
  • Creating basic charts (column, pie, line)
  • Formatting and editing charts
  • Adding chart titles, legends, and labels

Day 17:

• Data validation and conditional formatting:
  • Setting up data validation rules (dropdown lists, restrictions)
  • Applying conditional formatting (color scales, icon sets, data bars)
  • Custom rules for conditional formatting

Day 18:

• Working with multiple sheets:
  • Linking data between sheets
  • Summarizing data using formulas
  • Creating summary reports

Day 19:

• Review and practical exercise:
  • Create a worksheet with formulas, charts, and conditional formatting
  • Use multiple sheets and link data

Day 20:

• Test and Q&A:
  • Short test on MS Excel skills
  • Review and address questions

Week 5: MS PowerPoint (Days 21 - 26)

Day 21:

• Introduction to MS PowerPoint:
  • Overview of the PowerPoint interface
  • Creating and saving a presentation
  • Slide layouts and themes
  • Inserting and editing text

Day 22:

• Working with images and shapes:
  • Inserting and formatting images
  • Adding and customizing shapes
  • Arranging objects (group, align, order)

Day 23:

• Transitions and animations:
  • Applying slide transitions
  • Using animations for text and objects
  • Timing and customizing animations
  • Previewing transitions and animations

Day 24:

• Creating and formatting charts and tables:
  • Inserting charts and tables
  • Formatting and editing them
  • Importing Excel data into PowerPoint

Day 25:

• Presenting and slide show settings:
  • Setting up slide shows
  • Using Presenter View and Slide Show controls
  • Rehearsing timings and recording narration
  • Printing slides and handouts

Day 26:

• Review and practical exercise:
  • Create a 10-slide presentation with text, images, charts, transitions, and animations

Week 6: Basic Internet Skills + Freelancing (Days 27 - 36)

Day 27:

• Introduction to the internet:
  • Understanding browsers and search engines
  • Basic navigation in web browsers (tabs, address bar, back/forward)
  • Introduction to URLs, hyperlinks, and websites

Day 28:

• Using search engines efficiently:
  • Searching on Google, Bing, etc.
  • Using keywords and advanced search techniques

Day 29:

• Setting up and using email:
  • Creating and managing an email account (Gmail)
  • Sending, receiving, and organizing emails
  • Attachments and email etiquette
  • Setting up an email signature

Day 30:

• Freelancing basics and platforms:
  • Overview of freelancing opportunities
  • Introduction to popular platforms (Upwork, Fiverr, Freelancer)
  • Setting up a profile and portfolio

Day 31 - 33:

• Freelancing with Word and Excel:
  • Common gigs (data entry, formatting, content writing)
  • Tips for optimizing skills

Day 34 - 35:

• Freelancing with PowerPoint:
  • PowerPoint-based freelancing (creating presentations)
  • Project ideas and online marketing skills