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

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

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

Internet Basics:
o Using Browsers (Edge/Chrome)
o Searching information on Google

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.