Education is Everything

M1-R5|CCC

Syllabus of Information Technology Tools and Network Basics (M1-R5)|CCC (Course on Computer Concepts )

Introduction

The module is designed to equip a student to use computers for professional as well as day to day use. It provides theoretical background as well as in-depth knowledgeof Software/ packages.

Objectives

After completing the module, the incumbent will be able to:

Acquire confidence in using computers in Office and General Life

Identify the basic components of computers and terminology

Understand file management

Create documents using word processor, spreadsheet & presentation software

Understand computer networks and browse the Internet, content search,

email and collaborate with peers

Use e-Governance applications and use computer to improve existing skills

and learn new skills

Understanding Social Networking platform

Using the Internet for Digital Financial services

Develop knowledge about FutureSkills

Understand the various financial services and be aware of the various

schemes started by Government.

Duration

120 Hours - (Theory: 48hrs + Practical: 72 hrs)

Marks Distribution

Module Unit

Written Marks (Max.)

1. Introduction to Computer, introduction to Operating System

10

2. Word Processing

20

3. Spreadsheet

20

4. Presentation

20

5. Introduction to Internet and WWW, E-mail,

Social Networking and e-Governance Services

20

6. Digital Financial Tools and Applications,

Overview of FutureSkills& Cyber Security

10

7. Total

100

 

Detailed Syllabus

Introduction to Computer

Computer and Latest IT gadgets, Evolution of Computers & its applications, IT

gadgets and their applications, Basics of Hardware and Software, Central

Processing Unit, Input devices, Output devices, Computer Memory & storage,

Application Software, Systems Software, Utility Software, Open source and

Proprietary Software, Mobile Apps.

(ii) Introduction to Operating System

Operating System, Basics of Operating System, Operating Systems for Desktop

and Laptop, Operating Systems for Mobile Phone and Tablets, User Interface for

Desktop and Laptop, Task Bar, Icons & shortcuts, running an application,

Operating System simple setting, using mouse and changing its properties,

changing system date and time, changing display properties, to add or remove

Program and its features, adding, removing &sharing Printers, File and Folder

management, types of file extensions.


(iii) Word Processing

Word Processing Basics, Opening Word Processing Package, Title Bar, Menu

Bar, Toolbars & Sidebar, Creating a New Document, Opening and Closing

Documents, Opening Documents, Save and Save As, Closing Document, Using

The Help, Page Setup, Page Layout, Borders, Watermark, Print Preview, Printing

of Documents, PDF file and Saving a Document as PDF file, Text Creation and

manipulation, Document Creation, Editing Text, Text Selection, Cut, Copy and

Paste, Font, Color, Style and Size selection, Alignment of Text, Undo & Redo,

AutoCorrect, Spelling & Grammar, Find and Replace, Formatting the Text,

Creating and using user defined Styles, Paragraph Indentation, Bullets and

Numbering, Change case, Header & Footer, Table Manipulation, Insert & Draw

Table, Changing cell width and height, Alignment of Text in cell, Delete /

Insertion of Row, Column and Merging & Splitting of Cells, Border and Shading,

Mail Merge, Table of Contents, Indexes, Adding Comments, Tracking changes,

Macros

(iv) Spreadsheet


Elements of Spread Sheet, Creating of Spread Sheet, Concept of Cell Address

[Row and Column] and selecting a Cell, Entering Data [text, number, date] in

Cells, Page Setup, Printing of Sheet, Saving Spreadsheet, Opening and Closing,

Manipulation of Cells & Sheet, Modifying / Editing Cell Content , Formatting

Cell (Font, Alignment, Style ), Cut, Copy, Paste & Paste Special, Changing Cell

Height and Width, Inserting and Deleting Rows, Column, AutoFill, Sorting &

Filtering, Freezing panes, Formulas, Functions and Charts, Using Formulas for

Numbers (Addition, Subtraction, Multiplication & Division), AutoSum,

Functions (Sum, Count, MAX, MIN, AVERAGE),Sort, Filter, Advanced Filter,

Database Functions ( DSUM, DMIN,DMAX, DCOUNT, DCOUNTA), What-if

Analysis, Pivot table Charts (Bar, Column, Pie, Line), Data Validation.

 

(v) Presentation

 

Creation of Presentation, Creating a Presentation Using a Template, Creating a

Blank Presentation, Inserting & Editing Text on Slides, Inserting and Deleting

Slides in a Presentation, Saving a Presentation, Manipulating Slides, Inserting

Table , Adding Pictures, Inserting Other Objects, Resizing and Scaling an Object,

Creating & using Master Slide, Presentation of Slides , Choosing a Set Up for

Presentation, Running a Slide Show, Transition and Slide Timings, Automating

a Slide Show, Providing Aesthetics to Slides & Printing, Enhancing Text

Presentation, Working with Color and Line Style, Adding Movie and Sound,

Adding Headers, Footers and Notes, Printing Slides and Handouts

 

(vi) Introduction to Internet and WWW

 

Basic of Computer Networks, Local Area Network (LAN), Wide Area Network

(WAN), Network Topology , Internet, Concept of Internet & WWW,

Applications of Internet, Website Address and URL, Introduction to IP Address,

ISP and Role of ISP, Internet Protocol, Modes of Connecting Internet (HotSpot,

Wifi, LAN Cable, BroadBand, USB Tethering), Identifying and uses of

IP/MAC/IMEI of various devices, Popular Web Browsers (Internet

Explorer/Edge, Chrome, Mozilla Firefox, Opera etc.), Exploring the Internet ,

Surfing the web, Popular Search Engines, Searching on Internet, Downloading

Web Pages, Printing Web Pages

 

(vii) E-mail, Social Networking and e-Governance Services

 

Structure of E-mail, Using E-mails, Opening Email account, Mailbox: Inbox and

Outbox, Creating and Sending a new E-mail, Replying to an E-mail message,

Forwarding an E-mail message, Searching emails, Attaching files with email,

Email Signature, Social Networking & e-Commerce, Facebook, Twitter,

Linkedin, Instagram, Instant Messaging (Whatsapp, Facebook Messenger,

Telegram), Introduction to Blogs, Basics of E-commerce, Netiquettes,

Overview of e-Governance Services like Railway Reservation, Passport,

eHospital [ORS], Accessing e-Governance Services on Mobile Using “UMANG

APP”, Digital Locker

 

(viii) Digital Financial Tools and Applications

 

Digital Financial Tools, Understanding OTP [One Time Password]and QR

[Quick Response] Code, UPI [Unified Payment Interface], AEPS [Aadhaar

Enabled Payment System], USSD[Unstructured Supplementary Service Data],

Card [Credit / Debit], eWallet, PoS [Point of Sale], Internet Banking, National

Electronic Fund Transfer (NEFT), Real Time Gross Settlement (RTGS),

Immediate Payment Service (IMPS), Online Bill Payment

(ix) Overview of Futureskills and Cyber Security

Introduction to Internet of Things (IoT), Big Data Analytics, Cloud Computing,

Virtual Reality, Artificial Intelligence, Social & Mobile, Blockchain

Technology, 3D Printing/ Additive Manufacturing, Robotics Process

Automation, Cyber Security, Need of Cyber Security, Securing PC, Securing

Smart Phone


TOP COURSES

SELECTED STUDENTS

selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student selected student