Module 4: Microsoft Excel (Week 5 & 6)

• Introduction to Spreadsheets: Rows, Columns, Cells
• Data entry, Formatting, Autofill
• Basic Formulas: SUM, AVERAGE, MAX, MIN, COUNT
• Relative vs Absolute Cell References
• Functions: IF, Nested IF, Date & Time, Text functions
• Sorting & Filtering data
• Charts: Bar, Line, Pie, Column, etc
• Page setup, Printing worksheets
• Mini Project: Create a Sales Report, Attendance Sheet, Budget Sheet

Module 5: Microsoft PowerPoint (Week 7)

• Creating Presentations
• Slide layouts, Themes, Backgrounds
• Inserting Text, Images, Shapes, SmartArt, WordArt, Tables
• Animations & Transitions
• Slide Master, Notes & Handouts
• Running a Slide Show
• Mini Project: Create a Business/Academic Presentation

Module 6: Email & Internet (Week 8)

Outlook Express / MS Outlook:
o Creating an email account
o Composing, Sending, Receiving emails
o Attaching files, Using CC/BCC
o Organizing inbox with folders
o Contacts, Calendar, Meetings

Internet Basics:
o Using Browsers (Edge/Chrome)
o Searching information on Google
o Downloading/uploading files
o Safe browsing, Cyber security awareness

Introduction to Email & Gmail
o What is Email?
o Advantages of Email over traditional communication.
o Introduction to Gmail (History & Features).
o Creating a Gmail account.
o Logging in & Logging out safely.

Gmail Interface & Basic Features
o Gmail Dashboard Overview.
o Inbox, Sent, Drafts, Trash, Spam, Categories.
o Composing a new email.
o Adding subject, CC, BCC, and attachments.
o Sending, replying, and forwarding emails.
o Email formatting options (bold, italics, underline, font styles).

Managing Emails
o Organizing Inbox.
o Starred messages.
o Labels & Folders (Creating, Editing, Deleting).
o Archiving & Deleting emails.
o Search and advanced search options.
o Filters & Rules for automatic organization.

Gmail Contacts & Address Book
o Adding new contacts.
o Editing & deleting contacts.
o Creating contact groups.
o Importing & exporting contacts.

Attachments & File Management
o Attaching files while sending emails.
o Downloading & previewing attachments.
o Using Google Drive with Gmail.
o Sharing files & documents via Gmail.

Gmail Settings & Personalization
o Changing password & recovery options.
o Setting up profile picture & signature.
o Language & theme customization.
o Vacation responder (Auto Reply).

Security & Privacy in Gmail
o Two-step verification.
o Identifying phishing/spam emails.
o Blocking & reporting users.
o Safe logout practices (especially on public computers).

Advanced Gmail Features
o Using multiple tabs (Primary, Social, Promotions).
o Gmail with Chat & Meet integration.
o Scheduling emails (Send later option).
o Using Gmail offline.
o Connecting Gmail with other apps (Calendar, Keep, Tasks).

Practical Assignments & Projects
o Create a Gmail account and send a formatted email to a friend/classmate.
o Attach a document and share it with a teacher.
o Organize inbox using labels and filters.
o Set up a signature and vacation responder.
o Identify and report a spam email.

Extra Topics (Throughout the Course)
• Keyboard typing practice (with typing tutor software)
• Shortcut keys in Windows & MS Office
• Basic Troubleshooting: Printer not working, System hanging, Virus issues
• Introduction to Cloud Storage (Google Drive/OneDrive)
• Awareness of AI tools & modern computer trends (basic intro only)

Assessment & Certification
• Weekly Assignments (file creation, editing tasks)
• Mini Projects (Resume, Sales Report, Presentation)
• Final Practical Exam covering all modules
• Certificate awarded on successful completion

By the end of this course, students will be able to confidently handle Windows OS, manage files, create documents in Word, analyze data in Excel, design presentations in PowerPoint, and use email/internet effectively.

AI in Basic Computer Applications – Course Syllabus

1. Introduction to AI in Office Tools (1 hour)
• What is AI?
• How AI is transforming daily computer applications.
• Benefits: Productivity, automation, accuracy, creativity.
• Real-life examples (Chatbots, Smart Replies, Copilot, Google AI tools).

2. Windows & File Management with AI (1 hour)
• AI-powered search in Windows (Cortana, Windows Search with Copilot).
• Voice commands for opening files & applications.
• AI suggestions for file organization.

3. MS Word + AI (2–3 hours)
• Editor & Grammar Check: AI-powered spelling, grammar, and style suggestions.
• Smart Compose: Predictive text & auto-completion.
• Copilot (MS 365): Drafting letters, resumes, and reports with AI assistance.
• Translation ¯ Dictation: Real-time language translation & voice-to-text.
• Research Tool: Using AI for content ideas & citations.
Activity: Students draft a professional letter using MS Word’s AI Editor and Copilot.

4. MS Excel + AI (3–4 hours)
• Ideas in Excel: AI-driven analysis of data trends and insights.
• Data Cleaning with Power Query + AI suggestions.
• Predictive Analysis: Using AI for forecasting sales, expenses, or growth.
• Copilot in Excel: Automatic formula generation, pivot table suggestions, quick insights.
• Charts & Dashboards: AI recommending best charts for data.
Activity: Students create a sales report and let Excel’s AI generate insights and charts.

5. MS PowerPoint + AI (2–3 hours)
• Designer Tool: AI-generated slide designs & layouts.
• Copilot for PowerPoint: Creating a presentation from a Word document or outline.
• AI in Images & Icons: Suggestions for visuals, SmartArt, and stock images.
• Rehearse with Coach: AI giving feedback on pace, tone, and word choice.
Activity: Students prepare a 5-slide presentation and improve it using AI Designer.

6. Outlook + AI (2 hours)
• Focused Inbox: AI filtering important emails.
• Suggested Replies: Quick one-click responses.
• Copilot in Outlook: Drafting professional emails automatically.
• Scheduling Meetings: AI suggesting best times for meetings.
• Email Summaries: AI-generated summaries of long email threads.

7. Gmail + AI (2 hours)
• Smart Compose & Smart Reply: Predictive text for faster emailing.
• Priority Inbox: AI filtering important emails.
• AI Security: Detecting spam, phishing & unsafe attachments.
• Google Workspace AI (Duet AI): Drafting documents, emails, and summaries.
• Meeting Integration: Using AI with Google Meet & Calendar.
Activity: Students practice sending emails with Smart Compose & identify spam using AI filters.

8. Capstone Project (2–3 hours)
Students complete a Mini Project where they:
• Draft a document in MS Word with AI help.
• Analyze data in Excel using AI insights.
• Prepare a PowerPoint presentation with Designer.
• Send a professional email in Outlook/Gmail using Smart Compose.

CTTI Bonus Course — AI Tools for Everyday Work

Outcome: Students can write professional emails/letters, quickly summarize complex content (webpages & videos), edit images for presentations, and create short AI-assisted videos — all while following legal and ethical best practices.

Module 1 — Professional Writing with AI (Crafting Emails & Letters)

• Learn templates & tone: formal emails, follow-ups, interview thank-you notes, client communication.
• Practical: create 5 common email templates + one personalized cover letter.
• Assignment: submit one job application email + resume; AI will suggest improvements.

Module 2 — Smart Summaries: Videos, Articles & Websites

• How to extract key points from long articles, course videos, and web pages using AI.
• Practical: summarise a 15-minute tutorial video and a 1,500-word article into a one-page brief.
• Tools & prompts: teach students how to craft prompts for accurate summaries and fact-checking.

Module 3 — Image Editing with AI (Backgrounds, Cropping, Annotating, PPT Creation)

• Remove & replace backgrounds (for personal photos, lab images, product shots).
• Crop, circle/highlight parts of images, add captions & annotations for presentations.
• Creating PPTs with AI.

Module 4 — Create Short Videos with AI (From Script to Shareable Clip)

• Write short video scripts from course content (30–90 seconds).
• Use AI tools to generate voiceovers, synthesize slides, animate images, and compile clips.
• Export formats for YouTube, LinkedIn, and WhatsApp status.
• Practical: produce one 60-second course promo/summary video combining text, images, and voice.

Assessment & Certification

• Award a AI Skills Certificate on successful completion.