• Introduction of Computer
• Features and Limitations of Computer
• Application of Computer System
• What is Computer System
• Input Devices of Computer System
• Data Information Processing
• Output Device of Computer System
• Memory Management of Computer system
• Primary Memory of Computer System
• Secondary Memory of Computer
• Types of Computer System
• Central Processing Unit
• History and Generations Of Computer
• Internal Components of Computer System
• System Assembling Dissembling
• Introduction to Operating System

Module 1: Introduction to Windows 11
Installing and setting up Windows 11
Navigating the new Start menu
Customizing the taskbar and Start menu
Managing user accounts and sign-in options (PIN, Password, Microsoft Account)

Module 2: File and Folder Management
Creating, renaming, moving, and deleting files/folders
Using File Explorer to manage files
Pinning folders to the Quick Access menu
Searching files and folders in File Explorer
Using the Context Menu (right-click options)
Working with File Extensions and Preview Pane

Module 3: Personalizing Windows 11
Changing the desktop wallpaper and lock screen image
Customizing the taskbar (icons, system tray, transparency)
Changing system themes and colors (light/dark mode)
Setting up multiple desktops and virtual desktops
Adjusting screen resolution and display settings
Using Snap Layouts and Snap Groups for multitasking

Module 4: Working with Windows Settings
Accessing and navigating the Windows Settings app
Configuring system settings (Network, Devices, Time & Language)
Adjusting system sound and notifications
Managing power options and battery settings
Privacy settings and App permissions
Changing system language, region, and keyboard layout
Enabling and configuring Windows Update

Module 5: Managing Apps and Software
Installing, updating, and uninstalling apps from Microsoft Store
Managing installed apps and their permissions
Using Task Manager to monitor and end tasks
Pinning apps to the Start menu and taskbar
Using Settings to manage default apps (browser, email, etc.)

Module 6: File Backup and Recovery
Creating a System Restore Point
Using File History to back up files and restore them
Creating and using Windows 11 backup options (Backup & Restore, OneDrive backup)
Resetting Windows 11 to its default state without losing personal files

Module 7: Security and Privacy Settings
Setting up Windows Defender Antivirus and performing scans
Configuring Windows Security settings (Firewall, Virus & Threat Protection)
Using Windows Hello for secure login (Fingerprint, Face recognition)
Enabling BitLocker for disk encryption
Managing app permissions and privacy settings
Understanding Windows 11 Firewall and network protection

Module 8: Taskbar and Window Management
Customizing the taskbar (alignment, shortcuts, system icons)
Using Windows 11 Snap Assist for multitasking
Managing multiple windows and virtual desktops
Using Quick Settings (Wi-Fi, Bluetooth, Brightness, Focus Assist)
Managing system notifications and widgets
Organizing the desktop using icons, folders, and taskbar shortcuts

Module 9: Networking and Connectivity
Connecting to Wi-Fi and Ethernet networks
Setting up and managing network shares and printers
Troubleshooting network issues using the Network Troubleshooter
Using Airplane Mode, Bluetooth, and VPN settings
Configuring proxy settings and remote desktop connection

Module 10: Windows 11 for Productivity
Using Microsoft Teams and other built-in communication tools
Managing apps using the new Microsoft Store
Using Widgets for news, weather, and personal information
Managing system resources using Task Manager
Working with Windows PowerShell for advanced tasks

Module 11: Updates and Maintenance
Performing manual system updates via Windows Update
Managing update settings (active hours, restart options)
Using Disk Cleanup and Storage Sense for maintenance
Checking system health and performance
Uninstalling apps, software, and cleaning up unnecessary files

Module 12: Advanced Features and Tips
Using Cortana for voice commands and productivity
Configuring advanced security options (Windows Sandbox, Device Encryption)
Using the Windows Subsystem for Linux (WSL)
Exploring PowerToys and other productivity utilities
Managing device drivers and updates using Device Manager

Module 13: Final Project
Students will complete a project incorporating all learned skills. The project may involve:
Customizing the Windows 11 interface and settings
Configuring system and security settings for a personal or business setup
Setting up network connections and sharing files between multiple devices
Troubleshooting common Windows 11 problems and demonstrating solutions

Assessment:
Practical Evaluation: Hands-on exercises and tasks after each module
Final Project: An overall project showcasing the student's learning
Feedback: Continuous feedback after each session to improve practical skills

Tools Required:
Computers with Windows 11 OS installed
Internet access for updates and online resources
External storage devices for backup tasks (USB, External Hard Drives)
Optional: Microsoft Teams for collaboration and online sessions

Module 1: Introduction to MS Word 365
Opening, closing, and saving documents in Word
Navigating the Ribbon and understanding the interface
Using the Quick Access Toolbar and customizing it
Zoom in and zoom out in the document
Creating a new document and using templates

Module 2: Basic Document Formatting
Typing, editing, and deleting text
Changing font style, size, color, and applying bold, italic, underline
Aligning text (left, right, center, justify)
Adjusting line spacing and paragraph spacing
Using bullet points and numbered lists
Using Undo and Redo options
Formatting headings and subheadings using Styles

Module 3: Working with Pages and Layout
Adjusting page margins (Normal, Narrow, Custom)
Changing page orientation (Portrait, Landscape)
Inserting and removing page breaks
Setting up headers and footers (page numbers, date, document title)
Adding and formatting page borders
Changing paper size and orientation

Module 4: Working with Tables
Inserting a table (number of rows and columns)
Adding and deleting rows/columns
Merging and splitting cells
Adjusting column width and row height
Formatting table (borders, shading, text alignment)
Using table styles for quick formatting
Sorting data within a table
Converting text to a table and vice versa

Module 5: Inserting Graphics and Objects
Inserting pictures and resizing them
Using WordArt for creative text effects
Inserting shapes, icons, and SmartArt
Working with text boxes (inserting, resizing, moving)
Inserting charts (column, pie, bar) and customizing them
Using Screenshots and Snipping Tool in Word
Wrapping text around images and objects

Module 6: Advanced Formatting Techniques
Applying and customizing themes and templates
Using the Format Painter to copy formatting
Creating and modifying paragraph styles
Inserting and formatting columns (newspaper-style text)
Creating and formatting lists with bullets, numbering, and multilevel lists
Inserting and formatting footnotes, endnotes, and citations

Module 7: Working with Headers, Footers, and Page Numbers
Inserting and editing headers and footers
Adding different headers/footers for odd and even pages
Customizing page numbers (position, format)
Inserting document date/time in headers or footers
Using Section Breaks for different formatting in sections

Module 8: Reviewing and Proofreading Tools
Using Spelling and Grammar check
Adding comments and track changes for document review
Accepting or rejecting changes in the document
Using the Thesaurus and synonyms tool
Comparing and merging two documents
Checking document readability and readability scores

Module 9: Collaboration and Sharing
Sharing documents via OneDrive or SharePoint
Collaborating in real-time with others (track changes, comments)
Using @mentions and notifications in shared documents
Protecting a document (password protection, restricting editing)
Using the "Compare" and "Combine" features for document comparison
Saving a document in various formats (PDF, Word, etc.)

Module 10: Using Mail Merge
Setting up a Mail Merge (creating a letter template)
Using Excel as a data source for mail merge
Inserting merge fields (name, address, etc.)
Previewing and finishing the Mail Merge (print, email, or save)

Module 11: Using Templates and Forms
Creating documents using built-in templates
Designing a form with fillable fields (using Content Controls)
Protecting forms (restricting editing to fillable areas)
Saving and using custom templates for future documents

Module 12: Final Project
Creating a professional report or newsletter with tables, images, headers, and footers
Performing mail merge for personalized letters
Designing a form with fillable fields and submitting it
Formatting a document with advanced styles, sections, and columns

Assessment:
Practical Assignments: After each module, students will complete hands-on tasks.
Final Project: A final project incorporating all the features covered in the course.
Feedback: Continuous feedback on each task to enhance learning.

Module 1: Introduction to MS Excel 365
Opening, closing, and saving Excel files
Navigating the Excel interface (Ribbon, Formula bar, Cells, Rows, Columns)
Creating a new workbook and worksheet
Understanding the use of cells, rows, columns, and ranges
Adjusting column width and row height
Basic navigation using keyboard shortcuts (e.g., Ctrl + Arrow keys)

Module 2: Data Entry and Formatting
Entering text, numbers, and dates in cells
Formatting cells (font size, style, color)
Number formatting (currency, percentage, decimal places)
Aligning data (left, center, right)
Changing cell borders, fills, and text wrapping
Merging and splitting cells
Using Format Painter to copy formatting

Module 3: Basic Formulas and Functions
Writing simple formulas (addition, subtraction, multiplication, division)
Using AutoSum for quick calculations
Introduction to basic functions (SUM, AVERAGE, MIN, MAX)
Using AutoFill to copy formulas and patterns
Understanding relative, absolute, and mixed references in formulas (e.g., $A$1, A1, A$1)
Using the Quick Analysis tool for basic calculations

Module 4: Working with Data and Sorting
Sorting data (ascending, descending) by one or multiple columns
Filtering data using the Filter tool
Removing duplicates from data
Using Conditional Formatting for highlighting data (color scales, data bars, icon sets)
Using the Flash Fill tool for automatic pattern recognition
Working with Excel tables (inserting, formatting, and managing tables)

Module 5: Advanced Formulas and Functions
Introduction to advanced Excel functions
Using IF function for conditional logic (simple IF, nested IF)
Using COUNTIF, SUMIF, and AVERAGEIF functions for conditional calculations
Working with text functions (CONCATENATE, LEFT, RIGHT, MID, TRIM)
Using date functions (TODAY, NOW, DATE, YEAR, MONTH, DAY)
Using lookup functions (VLOOKUP, HLOOKUP, INDEX, MATCH)
Using logical functions (AND, OR, NOT)

Module 5: Advanced Formulas and Functions
Importance of data visualization in Excel
Creating basic charts (Column, Line, Bar, Pie)
Customizing charts (titles, labels, legends, data series)
Using Pivot Charts to summarize data visually
Adding trendlines to charts
Using the Recommended Charts tool for automatic chart selection
Formatting charts (colors, styles, and 3D effects)
Working with Sparklines for quick data visualization

Module 7: Working with PivotTables and PivotCharts
Creating and modifying PivotTables
Adding and removing fields in PivotTable
Grouping data in PivotTable (by date, numbers, etc.)
Using calculated fields in PivotTables
Refreshing and updating PivotTables
Creating PivotCharts from PivotTables for advanced data analysis

Module 8: Data Analysis Tools and Functions
Introduction to advanced data analysis tools
Using Goal Seek for finding values
Performing data analysis with the What-If analysis tools
Using Data Tables for sensitivity analysis
Using Solver for complex optimization problems
Using Forecasting tools for trend analysis
Analyzing data with Scenario Manager

Module 9: Working with Multiple Sheets and Workbooks
Managing multiple sheets and workbooks in Excel
Linking data between different sheets and workbooks
Copying and pasting data across workbooks
Grouping and ungrouping worksheets
Renaming, adding, and deleting sheets
Protecting worksheets and workbooks (password protection)
Using the Consolidate tool to combine data from multiple sheets

Module 10: Printing and Sharing Excel Workbooks
Setting print areas and adjusting page layout for printing
Using Page Break Preview and Print Titles
Printing selected data and entire workbooks
Saving workbooks as PDF or XPS
Sharing workbooks via OneDrive or email
Co-authoring and collaborating in real-time with other users
Protecting and securing Excel workbooks while sharing

Module 11: Advanced Excel Features (Power Query, Power Pivot)
Using Power Query to import and transform data from external sources
Connecting Excel to databases, text files, and web sources
Using Power Pivot for advanced data modeling and analysis
Creating relationships between different data sources
Using DAX formulas in Power Pivot for complex calculations

Module 12: Final Project
Create and format a complex Excel report with data, tables, formulas, and charts
Use PivotTables and PivotCharts to summarize and analyze data
Implement advanced functions (IF, VLOOKUP, COUNTIF, etc.) in real-world scenarios
Collaborate on a workbook, sharing data and managing version control

Assessment:
Practical Assignments: Hands-on tasks after each module
Final Project: A final project that integrates all the concepts covered in the course
Feedback: Continuous feedback after each practical exercise

Module 1: Introduction to MS PowerPoint 365
Opening, saving, and closing presentations
Navigating the PowerPoint interface (Ribbon, Quick Access Toolbar)
Understanding slide layouts and themes
Creating a new presentation and choosing a template
Using the Design Tab to choose a theme for your presentation
Basic slide navigation (Next, Previous, Go to Slide)

Module 2: Working with Slides
Basics of adding and editing slides
Inserting new slides (title, text, blank, etc.)
Changing slide layouts (Title, Content, Two Content, Comparison)
Deleting, duplicating, and reordering slides
Changing slide background color and design
Applying slide transitions and setting duration
Using the Slide Sorter view for slide organization
Setting up slide master for consistent design

Module 3: Text and Content Formatting
Typing and editing text in text boxes
Formatting text (font style, size, color, bold, italic, underline)
Using bullets, numbering, and multilevel lists
Aligning text (left, center, right, justify)
Inserting text boxes and adjusting their size and position
Copying and pasting content with and without formatting
Formatting paragraphs (line spacing, indentations, etc.)

Module 4: Inserting Visuals and Objects
Inserting images from file and web sources
Inserting icons and graphics from PowerPoint library
Using the "Insert" tab to add shapes, smart art, and charts
Inserting and formatting tables for data display
Inserting screenshots and screen recordings
Using Picture Tools to resize, crop, and adjust images
Applying effects and styles to images (shadows, reflections, borders)
Adding text effects and WordArt

Module 5: Working with Charts and Graphs
Inserting and customizing different types of charts (bar, pie, line, etc.)
Modifying chart data and changing chart types
Formatting chart titles, labels, and legends
Customizing chart colors and styles
Adding trendlines and data labels to charts
Linking Excel data with PowerPoint for dynamic charts
Using the Chart Tools to format and modify charts

Module 6: Animations and Transitions
Applying animations to text, images, and other objects
Customizing animation effects (entrance, emphasis, exit)
Setting animation duration and delay times
Using the Animation Pane for managing animations
Applying slide transitions (Fade, Wipe, Push, etc.)
Setting transition duration and sound effects
Creating interactive animations for engaging presentations

Module 7: Audio, Video, and Multimedia
Inserting and playing audio files in a slide (MP3, WAV)
Inserting and editing video files (MP4, WMV, etc.)
Using the Playback tools for audio and video
Embedding online videos from YouTube or other sources
Adjusting audio and video settings (volume, start, playback options)
Using Action Buttons for interactive presentations (Hyperlinks, triggers)

Module 8: Working with Hyperlinks and Action Buttons
Inserting hyperlinks to navigate to other slides or external websites
Creating interactive presentations using action buttons
Setting up a navigation menu with hyperlinks
Using action buttons to link slides within the presentation
Setting up a self-running presentation with action buttons

Module 9: Collaboration and Sharing
Sharing PowerPoint presentations via OneDrive or SharePoint
Collaborating in real-time with others using Comments and Annotations
Comparing and merging different versions of the presentation
Adding and reviewing comments in slides
Presenting a slide show with notes for the presenter
Exporting presentations to PDF, Word, or video formats
Printing presentations (handouts, notes, and slides)

Module 10: Finalizing and Presenting
Setting up and customizing the Slide Show (loop, auto-advance)
Adding speaker notes and rehearse timings
Using Presenter View during a presentation
Finalizing presentation by checking for consistency
Practicing the presentation using Presenter View
Creating a custom slide show (selecting specific slides for different audiences)
Adding slide transitions for a smoother presentation flow

Module 11: Advanced PowerPoint Features (Optional)
Exploring advanced features for complex presentations
Using PowerPoint Designer to auto-generate slide layouts and designs
Using advanced charts and graphs for complex data presentations
Customizing PowerPoint themes and saving as a template
Using Morph transition for seamless slide animations
Advanced editing of videos within PowerPoint
Creating and using custom slide layouts
Using external add-ins for enhanced functionality

Module 12: Final Project
Students will create a comprehensive presentation that includes:
Custom slide layouts, animations, and transitions
Charts, graphs, images, and multimedia elements
Action buttons and hyperlinks for interactivity
Slide master and consistent design throughout the presentation
Real-time collaboration on a group presentation (if applicable)

Assessment:
Practical Assignments: Hands-on tasks at the end of each module
Final Project: A complete presentation showcasing all learned features
Feedback: Continuous feedback after each session to improve presentation skills

Document Scanning & Printing
System Assembling & Dissembling
System Formatting & Windows Installation
Installation of Drivers and Application

Introduction of Internet & Email System
Gmail Account Creation , Password Change, Sending Email , Attach Any File in Gmail
How to change Profile Picture in Gmail Account ?
How to Change Themes in Gmail Account
What is Two Step Verification ? How to Use Two Step Verification in Gmail ?
What is PAN Card ? Use of Pan Card ?
Apply Pan application using NSDL Portal
Correction Pan application using NSDL Portal
Reprint of PAN Card using NSDL Portal
Introduction of Aadhar Portal https://uidai.gov.in/
What is Aadhaar Features of Aadhaar
Download Aadhaar & Update Aadhaar Data
Order Aadhaar PVC Card o Check Aadhaar PVC Card Status
Check Aadhaar Update Status
National Voter Service Portal https://www.nvsp.in/
Register as a New Elector/Voter
Track Application Status
Download E-EPIC
Passport Seva Portal (https://www.passportindia.gov.in/)
Registration on Passport Seva Portal
Apply Online for the Passport
Book Appointment on PSK
Check Status of Passport
Driving License Portal (https://parivahan.gov.in/)
Apply for DL, Slot Booking,
Ccc online form
Resizing of photo,sign,and thumb impression
E district
CSC
Caste,income residence certificate online