Syllabus – Course in IT Foundation & Tools Duration – 6 Months Sr. No. Modules 1 IT Foundation and Digital Tools 2 Digital Communication and Collaboration 3 Introduction to e-Governance and Digital Financial Services 4 Creating Website using HTML, CSS and JavaScript 5 Introduction to Open AI (AI and Gen AI) 6 Employability Skills DGT (30 hrs.) 7 OJT/Project & Viva (30 hrs.) Module - 1 IT Foundation and Digital Tools 1. Computer Fundamentals & Operating System • What is a Computer • Characteristics of a Computer • Basic Applications of Computer • Advantages and Disadvantages of a Computer • History of Computer • Generation of Computer • Classification of Computers • Components of computer (Input unit, Arithmetic and logic unit, Control unit, Storage /Memory unit, Output unit) • Computer Memory ( What is computer memory, Types of memory, Difference between Primary memory & Secondary memory) • Concepts of Hardware and Software (Definition of Hardware and Software, Input devices, Secondary Storage devices, Output devices, Mother board, Power supply, System software, Application Software) • Languages (Machine Language, Assembly Language, High Level Language) • Concepts of data and information • Number System (Base conversion, binary, decimal, hexadecimal, and octal systems, conversion from one system to the other) • Binary Arithmetic( Addition, subtraction and multiplication) • IECT (Information Electronics and Communication Technology) and its applications of IECT o E-governance o Multimedia and Entertainment 2. Knowing GUI based Operating System and basic troubleshooting • Operating System and types of operating systems • Functions of Operating System. • GUI Operating Systems. • Types of GUI Operating System (Window, Linux, Android, Apple IOS, MAC OS) • Elements of GUI Operating System(Desktop, Windows, Title Bar, Task Bar, Start Menu/ Launcher, Icon, Button, Menu, Dialogue Box, Tab, Toolbar, Ribbon) • How Graphical User Interface Works? • Advantages and Disadvantages of GUI • Difference between GUI and CUI Operating System • Window Operating System • Managing files and folders in Window Operating System • Control Panel • Connecting keyboard, mouse, monitor, printer and projector to CPU • Basic Troubleshooting for common computer issues (power Supply), Handling issues related to printer (paper jam, printer isn’t printing, paper size mismatch, Printer error etc.), Handling issues related to scanner (paper jam, poor image quality etc.) 3. Introduction to Word Processing • Opening Word Processing Package • Menu Bar • Creating, opening and saving document • Entering and editing text • paragraph creation • Moving text (Cut, Copy & Paste) • Undo, Redo, Using Shortcuts • Formatting Documents ( Setting font styles, size, color, Typeface (Bold, Italic, Underline), Font effects, Change case, Highlighting, paragraph indenting , Alignments, Line Spacing, Drop cap, Bullets & Numberings, Borders & shadings, Header & Footer, Footnote & Endnote, Inserting Page break, Page numbering, Date & Time, Line Break, Word Wrap, Creating Cover page, Page Border, Table of Contents, Using Page Themes & Color, Inserting Watermarks) • Working with Tables (Creating tables, Table Styles, Borders & Shadings, Cell Alignment, Inserting & Deleting rows or columns, Merging, Splitting, Sorting, Using formula. Converting table into graphs) • Inserting Objects- Inserting Pictures, Formatting & editing pictures, picture styles, Picture borders, effects & layouts, Positioning, grouping & ordering, rotating and cropping, Adding and Editing Textbox, Shapes & SmartArt, Inserting Various types of charts, Charts layout and formatting. • Page Layout & Printing- Page Orientation, Setting page margins, Page size, Columns, Page Setup & Printing. • Features & Tools- Find and Replace, Auto Correct, Bookmarks, Hyperlinks, Spell Check, Thesaurus, Mail Merge. • Converting document into pdf 4. Typing Skills • Keyboard basics • Correct way of typing • Alphabet Placement and Positioning • Typing with Various keys • Speed typing • Using shortcut keys. 5. Introduction to Spreadsheet • Opening, creating and saving Spreadsheet. • Entering & editing data, Selecting Range • Cell Addressing • Creating text, number and date series. • Inserting, Deleting or Hiding a Row & Column. • Changing Cell Height & Width. • Formulas & Functions • Cell Referencing (Absolute, Relative & Mixed) • HLookup & VLookup. • Conditional Formatting. • Data Sorting & Filtering, Creating Data List, Data Validation • Consolidation, What-if Analysis. • Creating Charts and Graphs- Adding different types of Charts, Charts layout and formatting. • Find & Replace, Spell Check, Thesaurus • Page Setup & Printing. 6. Introduction to Digital Presentation • Creating a Presentation using Template • Creating a Blank Presentation • Opening and saving a Presentation • Entering and Editing Text • Inserting and Deleting Slides in a Presentation • Applying Themes & Background • Adding Pictures, Textbox, Tables, Charts, Shapes, Word Tables or Excel Worksheets • Adding Text to Shapes, Group/Ungroup Objects • Adding Header & Footer, Using Slide Master. • Setting Animation & Transition effects, Adding Audio & Video. • Running a slide show • Save as PDF, Image or Video file, PowerPoint Views, Printing handouts and slides. 7. Secure Web Access and communication • Concept of Internet (What is Network, Types of networks, Concept of Client and Server, Network Topologies, Network communication media, Concept of Internet and its applications, Advantages and disadvantages of internet, Internet protocol, Domain Name System, IP Address, URL, Internet Connectivity, Using WiFi & Bluetooth on digital devices, WWW and Web browsers, Popular Search Engines, Navigating through web, Uploading & Downloading, Services on web, Using Online Services (Banking, Using egovernance websites, Shopping, Streaming, social networking sites)) • Introduction to E-mail (History of Email, E-mail addressing, Creating new email account, Composing & sending email without and with attachments, Email Drafts and Scheduled sending, Replying & forwarding, Sorting & searching email, Sending email to multiple users, CC and BCC, Email protocol, Signatures (appended to the end of outgoing messages) • Basic Internet Security Concepts (Need of Security over internet, security threats, viruses and malwares, e-mail spam, security and privacy issues related to online shopping and social networking sites, safety measureschoosing strong password, Antivirus, Firewalls, safe browsing) 8. Cloud Storage and Online Collaboration • What is cloud and cloud storage • Types of cloud storage (Public, private, hybrid and community cloud) • Cloud Storage Service Providers(Google Drive, OneDrive, Dropbox) • Benefits of online storage over local storage and portable storage • Creating and Managing Files on the Cloud • Sharing and Collaborating on Documents • Syncing Files Across Devices • Introduction to Online Collaboration Tools (Google Workspace, Microsoft Office 365) Module-2 Digital Communication and Collaboration 1. Instant Messaging • What is Instant Messaging • Features of Instant Messaging • Types of Instant Messaging o Whatsapp o Social Media (Facebook and Instagram Messenger) o Telegram o Snapchat 2. Video Conferencing • What is video conferencing • Uses of video conferencing • Devices used in Video Conferencing • Video conferencing through Zoom, Skype, Google Meet, Microsoft Team, FaceTime and others 3. Social Media • What is Social Media • Pros & Cons of Social Media • Social Media Platforms o Facebook o YouTube o WhatsApp o Instagram o Telegram o Snapchat o Linkedin o X(Twitter) 4. Google Workspace • What is Google Workspace • Google Collaboration Tools o Gmail o Google Calendar o Google Meet & Google Chat o Google Drive o Google Docs, Sheets & Slides • Create, edit, share, and print documents with Google Docs • Create and edit spreadsheets from Google • Create Presentation with Google Slides • Using Google Forms • Google Translate • Switch from Microsoft Word to Google Docs • Switch from Excel to Google Sheets • Switch from Microsoft PowerPoint to Google Slides • How your Google storage works Module 3 Introduction to e-Governance and Digital Financial Services 1. Introduction to e-Governance • What is e-Governance • Pillars of e-Governance • Benefits of e- Governance • Limitations of e-Governance • Major implementation areas • Types of Interactions in e-Governance • National e-Governance Programs • E-Governance services in India. • Using e-Governance sites 2. Introduction to Digital Financial Services • What is digital financial services • Moving from traditional to digital banking • Types of Digital Banking Services o Card Payments(Debit Card, Credit Card, Withdraw cash from ATM) o United Payment Interface(UPI) o Internet Banking(NEFT, IMPS, RTGS, Checking bank statements) o Mobile Banking(Digital wallets) o Point of sale(PoS) • knowledge of Safety and Security of Digital Payments Module 4 Creating Website using HTML, CSS and Javascript 1. Introduction to HTML • HTML elements, tags and Attributes • Creating HTML Page • HTML links, List types • Creating HTML tables • Adding pictures & images • Adding audio & video • Working with Forms • HTML 5 new tags (new elements, Input Types, Form Elements, Form Attributes, Canvas, SVG, Video, Audio) 2. Introduction to CSS • What is CSS • Types of CSS(Inline, Internal & External) • CSS2 (Backgrounds, Margins, Padding, Border, Positioning, Float, Z-index, Links, Text, Outline) • CSS3 (Selectors, Border, Background, Text, Text effects, Box Shadow, 2D & 3D Transforms, Transition, Animation) 3. Introduction to JavaScript • Basic structure • Control Structure • Arrays and Strings • Functions • Document Object Model • Events and Methods • Validation Module – 5 Introduction to Open AI (AI and Gen AI) • Understanding AI (what is AI, History of AI, Features of AI, AI in Everyday Life (examples - Examples: Self-driving cars, Google Translate, Virtual Assistants), How AI helps in daily tasks, Difference between AI, Machine Learning, and Robots • Generative AI/ Gen AI (What is Generative AI, Difference between traditional AI and Generative AI, Applications of Gen AI: Text generation, image generation, music, coding, Exploring Generative AI Tools: Text generationChatGPT, Gemini, Image generation- DALL·E, MidJourney, AI in coding - GitHub, Copilot) • Physical AI (What is Physical AI, Simple Examples, Technologies Enabling Physical AI – Sensors, AI and Machine Learning, Robotics, edge computing, Applications of Physical AI- in education, healthcare, automation, agriculture, transportation • The Future of AI & Generative (AI’s impact on jobs and industries, Future AI trends, Ethical consideration of AI, Challenges & Opportunities Module- 6 Employability Skills (DGT 30 hrs.) • Introduction to Employability Skills • Constitutional values - Citizenship • Becoming a Professional in the 21st • Century • Basic English Skills • Communication Skills • Diversity & Inclusion • Financial and Legal Literacy • Essential Digital Skills • Entrepreneurship • Customer Service • Getting ready for apprenticeship & Jobs Module - 7 OJT/Project & Viva