Introduction to Computer & Basic Concepts
What is Computer: Characteristics of Computer System, Basic Applications of Computer; Processing Unit, Keyboard, mouse and VDU, Other Input devices, Other Output devices, Computer Memory;
Concept of Hardware and Software: Hardware, Software, Application Software, Systems software, Programming Languages; Representation of Data/Information; Concept of Data processing;
Basics of Operating System: Operating system, Basics of popular operating system (LINUX, WINDOWS);
The User Interface: Task Bar, Icons, Start Menu, Running an Application- notepad, paint, etc..;
Operating System Simple Setting: Changing System Date And Time, Changing Display Properties, To Add Or Remove A Windows Component, Changing Mouse Properties, Adding and removing Printers;
File and Directory Management: Types of files, What is a file, Naming conventions, File Extensions, File Pathway, Windows Explorer window, Viewing files, File property dialogue box, Explain file size (bytes, kilo, mega, Giga, tera) and abbreviations used, Create a Folder, Move a file (multiple files)into a folder, Delete files and folders, Recovering deleted files, Renaming files, Searching for files, Creating and deleting shortcuts on the desktop, How programs may save files in a specific location by default. How to find where the file is being saved;
Desktop: exploring the desktop, cleaning the desktop;
Keep Software updated: how to set automatic updates for windows operating system.
Basic Computer Hardware
Getting started with PC hardware support, Electricity and power systems, CPUs and motherboards,
Basic Input/Output System, Memory systems, Bus structures, the color combination of network cable Expansion cards, Ports, connectors, and cables,
Data storage devices,
Video and multimedia input/output devices,
Printers, Portable computers and devices, Connecting computers,
Word Processing Basics: Opening Word Processing Package, Menu Bar, Using The Help, Using The Icons Below Menu Bar;
Opening and closing Documents: Opening Documents, Save and Save as, Page Setup, Print Preview, Printing of Documents;
Text Creation and manipulation: Document Creation, Editing Text, Text Selection, Cut, Copy and Paste, Spell check, Thesaurus;
Formatting the Text: Font and Size selection, Alignment of Text, Paragraph Indenting, Bullets, and Numbering, Changing case;
Formatting a document: Set page margin, paragraphs, and sections within a document, Adjust indents and hanging indents;
Table Manipulation: Draw Table, Changing cell width and height, Alignment of Text in the cell, Delete / Insertion of row and column Border and shading, Table formulas;
Inserting Graphic Elements: Insert a clip art picture, insert symbols and special characters, adding a watermark; Using word art; adding a drop cap;
Mail Merge: Using mail merge; printing mailing labels; merging for sending emails using outlook.
Use of local language
Elements of Electronic Spread Sheet: Opening of Spread Sheet, Addressing of Cells, Printing of Spread Sheet, Saving Workbooks;
Manipulation of Cells: Entering Text, Numbers, and Dates, Creating Text, Number and Date Series, Editing Worksheet Data, Inserting and Deleting Rows, Column, Changing Cell Height and Width;
Formulas and Function: Using Formulas, Function, basic mathematical operators, using AutoSum, etc., using formulas with multiple cell references, finding the right function, relative and absolute cell references, fixing formula errors; Charts: learning about charts, creating charts; Working with graphics; Clip Art; SmartArt.
Use of Pivot Table and Pivot Chart.
Basic Concepts of presentation: Using PowerPoint, Opening A PowerPoint Presentation, Saving A Presentation;
Creation of Presentation: Creating a Presentation Using a Template, Creating a Blank Presentation, Entering and Editing Text, Inserting And Deleting Slides in a Presentation;
Preparation of Slides: Inserting Word Table or An Excel Worksheet, Adding Clip Art Pictures, Inserting Other Objects, Resizing and Scaling an Object;
Presentation of Slides: Viewing A Presentation, Choosing a Set Up for Presentation, Printing Slides, and Handouts;
Slide Show: Running a Slide Show, Transition and Slide Timings, Automating a Slide Show.
Database Management Systems
Introduction to the concepts of the database management system; Creating a database;
Creating a Table: concepts of field, field types; entering data in a table, preview and print a table, changing row and column height; closing and opening of the table, sorting of the table, finding and replacing texts; using queries wizard; creating a report from tables/queries from report wizard, modifying a report, the printing of report; creating a form using wizard, an entry in the forms; basic of formatting of forms and reports.
Cyber Security: Basic concepts of threats, vulnerabilities, controls; risk; confidentiality, integrity, availability; security policies; security mechanisms; Data Security and protection: concept, creating strong passwords; how to stay safe when surfing on the internet: “In private Browsing”, identifying secure website, clear cookies;
Know how to identify a secure website: https, lock symbol; Security Considerations: Know about security threats from websites like viruses, worms, Trojan horses, spyware. Understand the term malware; Netiquettes, DOS, DDOS;
Netiquettes; Security Considerations: Be aware of the possibility of receiving fraudulent and unsolicited e-mail; phishing, Recognize attempted phishing;
Basics of Software Licensing
Overview and understanding of IT Act 2000.
PC Maintenance, Security & Troubleshooting
Computer Maintenance and Security: Overview of Computer Maintenance and Security, Inbuilt PC Security, tools, Securing documents, Antivirus, Upgrading Operating System and Application software. security; Cleaning the monitor, keyboard, CPU;
Deleting unnecessary programs and files: Disk cleanup, deleting toolbars; defrag hard drive;
Computer maintenance programs: Ccleaner, myDefrag, Spinrite, etc.;
Basic troubleshooting: restart the computer, checking cables, uninstalling software, start windows in safe mode, etc.
Windows installation and upgrades, CPUs and motherboards, Memory systems, Expansion cards, Data storage devices, Ports, connectors, and cables, Printers and scanners, Display devices, Portable computers and devices, Networking, Security, Maintaining the PC environment.
Networking & Troubleshooting
Basic of Computer Networks: LAN, WAN, Wi-Fi, Broadband, Bluetooth;
Internet: Concept of the Internet, Applications of the Internet, Connecting to the Internet, Troubleshooting; WWW, TCP/IP, DNS, Search Engine; Key web browser features, Brief about the switch, router, gateway;
Various applications of the Internet: e-mail, information gathering, retailing, etc.;
Methods of connecting to the Internet: Dial-up, ISDN and broadband; Brief introduction to Internet addressing, Internet protocols (TCP/IP, FTP, and HTTP);
Define and understand the terms: Internet Service Provider (ISP), Uniform Resource Locator (URL), hyperlink;
Internet protocols (TCP/IP, FTP, and HTTP);
Define and understand the terms: Internet Service Provider (ISP), Uniform Resource Locator (URL), hyperlink;
Know how to identify a secure website:https, lock symbol; Security Considerations: Know about security threats from websites like: viruses, worms, Trojan horses, spyware.
Using Favorites Folder, Downloading Web Pages, Printing Web Pages, Understanding URL, Set the web browser Home Page/Start page; Bookmark a web page, Delete a bookmark, Publishing on the
Web, Downloading Web Pages, Printing Web
Pages; Complete a web-based form using: text boxes, drop-down menus, list boxes, checkboxes, radio buttons; Understanding benefits of Search Engines and Popular Search Engines (Google, Alta Vista, Excite);
Commerce on Internet, Impact of Internet on Society.
Overview of the use of search engines and e-mail messages;
Instant Messaging and Collaboration: Using Instant messaging, Instant messaging providers,
Use of Social Networking Sites viz. Facebook, Twitter, etc.; Introduction to the concepts of IPv4 and IPv6 networks;
Latest trends in IECT & e-Governance
Applications of IECT: e-governance, Multimedia, and Entertainment;
Project Management using IT tools & related applications
Introduction to Cloud Computing: What is cloud computing, Properties & Characteristics, Service models, Deployment models; Concepts of: IaaS (Infrastructure as a Service), PaaS (Platform as a Service), SaaS (Software as a service), DaaS (Desktop as a Service).
Introduction to Mobile Computing, its components, and characteristics.
Digital signature: definition as per ITA 2000, how digital signature works; the role of certifying authorities: Digital Certificates and their uses, Certifying Authority regulation in India, Obtaining a trial version of a Digital Certificate; legal aspect covering digital signatures in India; how to use digital signatures on electronic documents. Legal aspects covering digital signatures in India.
e-Governance: Definition of e-Governance, Pillars of e-Governance, Infrastructure for e-Governance, Mission Mode Projects (At least 5), Familiarization with terminology like change management, processing engineering, Govt. Processing engineering and Governance, e-Governance project life cycle, electronically delivery of services, messaging system, and case study of any 5 public utility portal related with the Department (especially, public grievance redressal system, RTI, Vigilance, Department working, and financial inclusion, linkage with Aadhar, etc.)
Application of Digital Financial Services
Why savings are needed, Why save in a bank, Banking products-ATM card, Rupay Card, Banking Instruments-Cheque, Demand Draft (DD), Currency Notes, Banking Services Delivery Channels, Know Your Customer (KYC), Opening of bank account and documents required, Types of bank accounts, Bank’s services including remittances, loan, mobile banking, Overdraft, Pension, etc., Types of Insurance, Pradhan Mantri Jan Dhan Yojana (PMJDY), password security and ATM withdrawal, Insurance, Social Security Schemes-Atal Pension Yojana (APY), Pradhan Mantri Suraksha Bima Yojana (PMSBY), Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY), Pradhan Mantri Mudra Yojana (PMMY).
ELECTRONIC MAIL – A detailed view
Basics of E-mail: What is an Electronic Mail,
Mailbox: Inbox and Outbox, Creating and Sending a new E-mail, Forwarding an E-mail message, Sorting and Searching emails, Document collaboration; instant Messaging and Collaboration: Using Instant messaging, Instant messaging providers, Netiquettes;
Configuring mail on mobile, creating groups, message formations, do’s & don’t using the mobile, attachment, the difference between Bcc & Cc
Email Protocols: SMTP, POP3, IMAP4, MIME5; Email Clients: Netscape mail clients, Outlook Express, web-based E-mail; Email encryption.
Introduction to Multimedia
Basic concepts, Hardware requirement for multimedia computer; Textural information;
Components of Multimedia: Images and their types, Animation, Digital audio, Digital Video Software for Multimedia, Introduction to MS-Publisher and Photodraw, Developing simple application and presentations using MS-Publisher.
HTML Programming Basics
Concepts of HTML page structure,
FrontPage / Interdev
HTML text, HTML Links, Using CSS, Using tables,
HTML document tables,
Effective communication: features of effective communication;
Communication Skills & Call Handling Skills
Listening Skills: Types of Listening; Tips for Effective Listening: Academic Listening- (lecturing), Listening to Talks and Presentations, Listening to Announcements.
Listening And Speaking