ISO 9001 : 2015 CERTIFIED INSTITUTE
"BECOME COMPLETE TECHNOLOGY SPECIALIST"
Ph : +91 9972198683, 0824 - 2443782
Module 1: Introduction to Computers & Windows (Week 1)
Basics of Computer:
o Definition, characteristics, applications of computers
o Types of computers & peripherals (Monitor, CPU, Keyboard, Mouse, Printers, Scanners, etc.)
o Input, Output, Storage devices
o Booting process and shutting down
Windows Operating System:
o Desktop, Start Menu, Taskbar, Icons, Shortcuts
o File Explorer: Folders, Files, Drives (C, D, E, USB, etc.)
o File Management: Create, Rename, Copy, Cut, Move, Delete, Restore
o Searching files and folders efficiently
o Windows Personalization: Wallpapers, Themes, Screen Savers, Display Settings, Taskbar settings
o Control Panel & Settings basics
o Installing & uninstalling software
Module 2: Basic Applications (Week 2)
Notepad:
o Typing practice, Editing text, Font settings, Saving files, Opening files
o Cut, Copy, Paste, Find & Replace, Word Wrap
o Exercises
Wordpad:
o Formatting text (Font size, color, style)
o Paragraph alignment, Bullets, Numbering
o Inserting images, objects
o Page setup & Printing
o Exercises
Paint:
o Drawing tools (Brushes, Shapes, Colors)
o Text tool, Eraser, Fill tool
o Creating posters, Simple designs
o Saving images in different formats (.bmp, .jpg, .png)
o Exercises
Module 3: Microsoft Word (Week 3 & 4)
• Creating, Saving, Opening documents
• Editing & Formatting text, Paragraphs, Styles, Drop Cap
• Page Layout: Margins, Orientation, Page Breaks, Columns
• Inserting: Tables, Pictures, ClipArt, WordArt, Shapes, Headers/Footers, Page Numbers
• Find, Replace, Spelling & Grammar check
• Mail Merge (Letters, Labels)
• Working with Templates
• Printing documents
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.
BASIC EXCEL
1. Introduction to MS Excel
• What is MS Excel?
• Uses of Excel (school, office, data management)
• Excel versions overview
• Opening, saving, and closing workbooks
• Understanding rows, columns, cells, and worksheets
2. Excel Interface
• Ribbon and tabs (Home, Insert, Page Layout, etc.)
• Quick Access Toolbar
• Workbook vs Worksheet
• Status bar and zoom options
3. Data Entry & Editing
• Entering text, numbers, and dates
• Editing cell content
• Copy, cut, paste
• AutoFill and Flash Fill
• Insert and delete rows/columns
4. Formatting Cells
• Font style, size, and color
• Cell alignment (horizontal & vertical)
• Borders and shading
• Number formatting (currency, percentage, date)
• Wrap text and merge cells
5. Basic Formulas & Functions
• Formula basics (=)
• Arithmetic operators (+, −, ×, ÷)
• Common functions:
o SUM
o AVERAGE
o MIN
o MAX
o COUNT
• Relative and absolute cell references
6. Working with Worksheets
• Adding, renaming, moving sheets
• Copying and deleting sheets
• Protecting sheets and workbooks
7. Basic Charts & Graphs
• Types of charts (Column, Bar, Pie, Line)
• Creating charts
• Editing chart elements (title, labels, legend)
8. Page Setup & Printing
• Page orientation and margins
• Print area
• Header and footer
• Print preview
ADVANCED EXCEL
1. Advanced Formulas & Functions
• Logical functions:
o IF, IFS
o AND, OR, NOT
• Lookup functions:
o VLOOKUP
o HLOOKUP
o XLOOKUP
• Text functions:
o LEFT, RIGHT, MID
o LEN, TRIM, UPPER, LOWER
• Date & time functions:
o TODAY, NOW, DATEDIF
2. Data Sorting & Filtering
• Multi-level sorting
• Custom sort
• AutoFilter
• Advanced Filter
3. Conditional Formatting
• Highlight cell rules
• Data bars
• Color scales
• Icon sets
• Formula-based formatting
4. Data Validation
• Dropdown lists
• Input restrictions
• Error alerts
• Creating dependent dropdowns
5. Pivot Tables & Pivot Charts
• Creating pivot tables
• Summarizing large data
• Grouping data
• Pivot charts
• Slicers and timelines
6. Working with Large Data
• Tables and structured references
• Removing duplicates
• Text to Columns
• Freeze panes
• Data cleaning techniques
7. What-If Analysis
• Goal Seek
• Scenario Manager
• Data Tables
8. Advanced Charts & Dashboards
• Combo charts
• Dynamic charts
• Dashboard design basics
• Using slicers with dashboards
9. Macros & Automation (Optional / Advanced Level)
• Introduction to Macros
• Recording macros
• Basic VBA concepts (very basic level)
• Enabling and disabling macros safely
10. Excel Security & Collaboration
• Workbook protection
• Sheet protection
• Password protection
• Sharing and collaboration basics
Comprehensive Excel Course Syllabus
Course Title: Advanced Microsoft Excel with Analytics and Automation
Duration: 60–80 hours.
Level: Beginner to Advanced.
Format: Practical, Case Study-based Learning.
Prerequisites: Basic Computer Knowledge.
Module 1: Data Structuring and Tables
Chapter 1: Excel Tables
• What is a Table
• Converting Data Ranges into Tables
• Structured References
• Table Styles and Formatting
• Table Sorting & Filtering
• Adding and Removing Columns/Rows in Tables
• Case Study: Student Database using Excel Tables
Chapter 2: Slicers
• Introduction to Slicers
• Adding Slicers to Tables and Pivot Tables
• Customizing Slicer Styles and Connections
• Real-Life Case Study: Department-wise Employee Analysis using Slicers
Module 2: Database Management and Data Analysis
Module 3: Data Comparison and What-If Analysis
Module 4: Advanced Data Validation and Dynamic Lists
Module 5: Lookup and Reference Functions
Module 6: Data Visualization
Module 7: Business Intelligence Tools
Module 8: Formula Auditing and Linking
Module 9: Forecasting, Grouping, and Protection
Module 10: Automation and Programming
Course Outcomes
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.
