IT Tools and Networking Basics (M1-R5)
Chapter-1 Introduction to Computer
- What is Computer ? Functions & its Characteristics
- Computer and Latest IT gadgets
- Evolution of Computers & its applications
- IT gadgets and their applications
- Basics of Hardware and Software
- Hardware
- Central Processing Unit
- Input devices
- Output devices
- Computer Memory & storage
- Software
- Application Software
- Systems Software
- Utility Software
- Open source and Proprietary Software
- Mobile Apps
Chapter-2 Introduction to Operating System
- What is Operating System, Features and function of OS
- Operating System for Desktop and Laptop
- Linux Operating and its Features
- Operating System for Mobile and Tablets
- File and Folder Management
Chapter-3 WORD PROCESSING
- What is LibreOffice
- What is Word processor & its Basic Features
- LibreOffice Writer & Part of Writer Window.
- Opening and Closing Document in Writer
- Text Creation and Manipulation in LibreOffice.
- Table Manipulation in LibreOffice Writer
- Mail Merge in LibreOffice Writer
- Table of Contents in LibreOffice Writer
- Track Changes in LibreOffice Writer
- Adding Comments in Writer
- Writer Document View
Chapter-4 SPREADSHEET
4.0 Introduction
4.1 Objectives
4.2 Elements of Spread Sheet
4.2.1 Creating of Spread Sheet
4.2.2 Concept of Cell Address [Row and Column] and selecting a Cell
4.2.3 Entering Data [text, number, date] in Cells
4.2.4 Page Setup
4.2.5 Printing of Sheet
4.2.6 Saving Spreadsheet
4.2.7 Opening and Closing
4.3 Manipulation of Cells & Sheet
4.3.1 Modifying / Editing Cell Content
4.3.2 Formatting Cell (Font, Alignment, Style )
4.3.3 Cut, Copy, Paste & Paste Special
4.3.4 Changing Cell Height and Width
4.3.5 Inserting and Deleting Rows, Column
4.3.6 AutoFill
4.3.7 Sorting & Filtering
4.3.8 Freezing panes
4.4 Formulas, Functions and Charts
4.4.1 Using Formulas for Numbers (Addition, Subtraction, Multiplication & Division)
4.4.2 AutoSum
4.4.3 Functions (Sum, Count, MAX, MIN, AVERAGE)
4.4.4 Charts (Bar, Pie, Line)
Chapter-5 Presentation
5.0 Introduction
5.1 Objectives
5.2 Creation of Presentation
5.2.1 Creating a Presentation Using a Template
5.2.2 Creating a Blank Presentation
5.2.3 Inserting & Editing Text on Slides
5.2.4 Inserting and Deleting Slides in a Presentation
5.2.5 Saving a Presentation
5.3 Manipulating Slides
5.3.1 Inserting Table
5.3.2 Adding ClipArt Pictures
5.3.3 Inserting Other Objects
5.3.4 Resizing and Scaling an Object
5.3.5 Creating & using Master Slide
5.4 Presentation of Slides
5.4.1 Choosing a Set Up for Presentation
5.4.2 Running a Slide Show
5.4.3 Transition and Slide Timings
5.4.4 Automating a Slide Show
5.5 Providing Aesthetics to Slides & Printing
5.5.1 Enhancing Text Presentation
5.5.2 Working with Color and Line Style
5.5.3 Adding Movie and Sound
5.5.4 Adding Headers, Footers and Notes
5.5.5 Printing Slides and Handouts
Chapter-6 INTRODUCTION TO INTERNET AND WWW
6.0 Introduction
6.1 Objectives
6.2 Basic of Computer Networks
6.2.1 Local Area Network (LAN)
6.2.2 Wide Area Network (WAN)
6.2.3 Network Topology
6.3 Internet
6.3.1 Concept of Internet & WWW
6.3.2 Applications of Internet
6.3.3 Website Address and URL
6.3.4 Introduction to IP Address
6.3.5 ISP and Role of ISP
6.3.6 Internet Protocol
6.3.7 Modes of Connecting Internet (Hotspot, Wi- Fi, LAN
Cable, Broadband, USB Tethering)
6.3.8 Identifying and uses of IP/MAC/IMEI of various devices
6.4 Popular Web Browsers (Internet Explorer/Edge, Chrome,
Mozilla Firefox, Opera etc.)
6.5 Exploring the Internet
6.5.1 Surfing the web
6.5.2 Popular Search Engines
6.5.3 Searching on Internet
6.5.4 Downloading Web Pages
6.5.5 Printing Web Pages
Chapter-7 E-mail, Social Networking and e-Governance Services
7.0 Introduction
7.1 Objectives
7.2 Structure of E-mail
7.3 Using E-mails
7.3.1 Opening Email account
7.3.2 Mailbox: Inbox and Outbox
7.3.3 Creating and Sending a new E-mail
7.3.4 Replying to an E-mail message
7.3.5 Forwarding an E-mail message
7.3.6 Searching emails
7.3.7 Attaching files with email
7.3.8 Email Signature
7.4 Social Networking & e-Commerce
7.4.1 Facebook, Twitter, LinkedIn, Instagram
7.4.2 Instant Messaging (WhatsApp, Facebook Messenger, Telegram)
7.4.3 Introduction to Blogs
7.4.4 Basics of E-commerce
7.4.5 Netiquettes
7.5 Overview of e-Governance Services like Railway Reservation, Passport, eHospital [ORS]
7.6 Accessing e-Governance Services on Mobile Using “UMANG APP”
7.7 Digital Locker
Chapter-8 DIGITAL FINANCIAL TOOLS AND APPLICATIONS
8.0 Introduction
8.1 Objectives
8.2 Digital Financial Tools
8.2.1. Understanding OTP [One Time Password]and
QR [Quick Response] Code
8.2.2 UPI [Unified Payment Interface]
8.2.3 AEPS [Aadhaar Enabled Payment System]
8.2.4 USSD[Unstructured Supplementary Service Data]
8.2.5 Card [Credit / Debit]
8.2.6 eWallet
8.2.7 PoS [Point of Sale]
8.3 Internet Banking
8.3.1 National Electronic Fund Transfer (NEFT)
8.3.2 Real Time Gross Settlement (RTGS)
8.3.3 Immediate Payment Service (IMPS)
8.4 Online Bill Payment
Chapter-9 Overview of Futureskills & Cyber Security
9.0 Introduction to Futureskills
9.1 Introduction to
9.1.1 Internet of Things (IoT)
9.1.2 Big Data Analytics
9.1.3 Cloud Computing
9.1.4 Virtual Reality
9.1.5 Artificial Intelligence
9.1.6 Social & Mobile
9.1.7 Blockchain Technology
9.1.8 3D Printing/ Additive Manufacturing
9.1.9 Robotics Process Automation
9.2 Cyber Security
9.2.1 Need of Cyber Security
9.2.2 Securing PC
9.2.3 Securing Smart Phone