Syllabus: Computer Advance and Digital Literacy Course (CADLC)

Module 1: Advanced Computer Concepts

• Evolution of computers and IT gadgets
• Advanced hardware concepts (CPU, memory, storage)
• System software, application software, utility software
• Open-source vs proprietary software
• Mobile apps and their applications

Module 2: Operating System – Advanced Windows

• Operating systems for desktop, laptop, mobile, and tablets
• Desktop interface, taskbar, icons, shortcuts
• Advanced system settings (date, time, display)
• Add/remove programs and features
• Printer management and file sharing
• Advanced file and folder management
• File extensions and system utilities

Module 3: Advanced Word Processing (MS Word)

• Advanced document creation and formatting
• Headers, footers, tables, styles
• Spell check, auto-correct, find & replace
• Mail merge for bulk documents
• Saving and exporting documents as PDF

Module 4: Spreadsheet & Data Handling (MS Excel)

• Advanced worksheet creation
• Data entry, sorting, filtering
• Formulas and functions (SUM, COUNT, MAX, MIN, AVERAGE)
• Charts and data visualization
• Page setup and printing worksheets

Module 5: Advanced Presentations (MS PowerPoint)

• Creating professional presentations
• Slide design, themes, and layouts
• Multimedia integration (images, audio, video)
• Transitions, animations, and slide timings
• Running and automating slide shows
• Printing slides and handouts

Module 6: Internet, Networks & Online Services

• Computer networks (LAN, WAN, network topology)
• Internet, WWW, ISP, browsers
• Searching, downloading, and printing online information
• Identifying IP, MAC, and IMEI of devices

Module 7: Email, Social Networking & e-Governance

• Advanced email usage (attachments, signatures, sorting)
• Social networking platforms and netiquette
• Blogs and basic e-commerce concepts
• e-Governance services (Railway, Passport, eHospital, UMANG)
• Digital Locker usage

Module 8: Digital Financial Literacy

• OTP and QR code usage
• UPI, AEPS, USSD, debit/credit cards
• Internet banking (NEFT, RTGS, IMPS)
• Online bill payments and secure transactions

Module 9: Future Technologies & Cyber Security

• Industry 4.0 overview
• Artificial Intelligence (AI)
• Internet of Things (IoT)
• Cloud Computing, Big Data, Blockchain
• Cyber security fundamentals
• Securing computers and mobile devices

Assessment & Certification

• Module-wise assessments
• Practical and theory examinations
• Certification after successful completion