💻 Information Technology Tools & Network Basics

Course Overview:

• Introduction to Computer and IT Gadgets
• Operating System Basics and Functions
• Word Processing using LibreOffice Writer
• Spreadsheet using LibreOffice Calc
• Presentation using LibreOffice Impress
• Internet, WWW, Email and E-Governance
• Digital Financial Tools and Applications
• Future Skills and Cyber Security

📚 INTRODUCTION TO COMPUTER

• Computer and Latest IT Gadgets
• Evolution of Computers and its Applications
• IT Gadgets and their Applications
• Basics of Hardware and Software
• Central Processing Unit (CPU)
• Input Devices
• Output Devices
• Computer Memory and Storage
• Application Software
• System Software
• Utility Software
• Open Source and Proprietary Software
• Mobile Apps

📚 INTRODUCTION TO OPERATING SYSTEM

• Operating System Basics and Functions
• Operating Systems for Desktop and Laptop
• Operating Systems for Mobile Phones and Tablets
• User Interface for Desktop and Laptop
• Task Bar Icons and Shortcuts
• Running an Application
• Operating System Simple Settings
• Using Mouse and Changing its Properties
• Changing System Date and Time
• Changing Display Properties
• Add or Remove Program and Its Features
• Adding, Removing and Sharing Printers
• File and Folder Management
• Types of File Extensions

📚 WORD PROCESSING

• Word Processing Basics
• LibreOffice Writer
• Opening Word Processing Package
• Title Bar, Menu Bar, Toolbars, Sidebar
• Basics of Writer
• Creating, Saving, Opening, Printing and Help
• LibreOffice Writer Keyboard Shortcuts
• LibreOffice Writer Shortcuts by Category
• LibreOffice Writer Menus and Toolbars Overview
• LibreOffice Writer Page Setup and Printing
• LibreOffice Writer File Menu
• LibreOffice Writer Edit Menu
• LibreOffice Writer View Menu
• LibreOffice Writer Insert Menu
• LibreOffice Writer Format Menu
• LibreOffice Writer Styles Menu
• LibreOffice Writer Table Menu
• LibreOffice Writer Form Menu
• LibreOffice Writer Tools Menu
• LibreOffice Writer Window and Help Menu
• LibreOffice Writer Practical File, Edit, View, Insert Menu
• LibreOffice Writer Practical Insert and Format Menu
• LibreOffice Writer Practical Tables Menu
• LibreOffice Writer Mail Merge
• LibreOffice Writer Macros
• LibreOffice Writer Practical Questions

📚 SPREADSHEET

• Elements of Spreadsheet
• Features of LibreOffice Calc
• Creating a Spreadsheet
• Page Setup and Cell Manipulation
• Cell Formatting
• Cell References
• Calc Functions
• Text Functions
• Date and Time Functions
• Logical and Conditional Function
• Math, Financial and Statistical Functions
• Student Mark Sheet
• Salary Sheet
• Electric Bill
• Sales Invoice
• Mark, Salary and Electricity Calculations
• AutoFill, Sorting, Filtering and Freezing
• Formulas, Functions and Charts
• Using Formulas and Functions
• Advance Functions
• Pivot Table and Charts
• Conditional Formatting
• Data Validation
• Data Consolidation and Subtotals
• Data Analysis Tools
• Calc Advance Functions
• Calc Example Tables

📚 PRESENTATION

• Elements of Presentation
• Basics of Impress
• Creation of Presentation
• Manipulating Slides
• Presentation of Slides
• Providing Aesthetics to Slides and Printing
• Adding Animation

📚 INTRODUCTION TO INTERNET AND WWW

• Basics of Computer Networks
• Wired and Wireless Methods for Internet
• Local Area Network (LAN)
• Metropolitan Area Network (MAN)
• Wide Area Network (WAN)
• Network Topology
• Internet and World Wide Web
• Applications of Internet
• Website Address and URL
• Introduction to IP Address
• ISP and Role of ISP
• Internet Protocol
• Modes of Connecting Internet
• Popular Web Browsers
• Popular Search Engines
• Downloading and Printing Web Pages

📚 EMAIL, SOCIAL NETWORKING AND E-GOVERNANCE SERVICES

• Structure of Email
• Email Uses
• Social Networking: Facebook, Twitter, LinkedIn, Instagram
• Instant Messaging
• E-Commerce
• E-Governance Services
• UMANG App Services
• DigiLocker

📚 DIGITAL FINANCIAL TOOLS AND APPLICATIONS

• Digital Financial Tools Overview
• One Time Password (OTP)
• QR Code
• Unified Payments Interface (UPI)
• Aadhaar Enabled Payment System (AEPS)
• Unstructured Supplementary Service Data (USSD)
• Card Payments
• Electronic Wallet
• Point of Sale (POS)
• Internet Banking
• NEFT, RTGS, IMPS, IFSC
• Online Bill Payment

📚 OVERVIEW OF FUTURESKILLS AND CYBER SECURITY

• Overview of FutureSkills and Cyber Security
• Introduction to Internet of Things (IoT)
• Big Data
• Cloud Computing
• Virtual Reality (VR)
• Augmented Reality (AR)
• Artificial Intelligence (AI)
• Blockchain
• Cyber Security
• Securing PC and Smart Phone

📝 Key Learning Areas

• Computer Fundamentals and IT Gadgets
• Operating System and File Management
• Word Processing, Spreadsheet and Presentation Tools
• Internet, Email and E-Governance Services
• Digital Payment Systems and Online Banking
• Future Technologies like AI, IoT and Blockchain
• Cyber Security and Device Protection