Chetan’s
The Basic Computer
with Financial Literacy
By: Chetan Chouhan
2023
I designed this course for everyone including students, common man and for house wives. After
completing the course the learner will have the basic knowledge of computer’s software and
hardware, and also will be able to understand how a computer system works. The learner will also
be able to use the computer for basic purposes such as surfing the internet, prepare personal
letters, use Microsoft Office apps such as Excel, Word and PowerPoint, maintain personal works,
create MS Word documents, create and maintain monthly budget for home. This course allows a
common man or housewife to be a part of computer users list by making them digitally literate.
This course helps the learner to maintain their small account using the computers and enjoy in the
world of Information Technology. The module on financial literacy will help the learner to
understand the importance of savings and will enable the individuals to understand the various
financial services and be aware of the various schemes of Government of India. The course has
some contents similar to “Basic Computer Course” (BCC) by “National Institute of Electronics and
Information Technology” (NIELIT) but my course is very different from the course provided by
NIELIT.
Chetan Chouhan
2
Computer syllabus
S. no. Topic Duration
1. Knowing Computer
2. Operating computer using GUI based operating system
3. Introduction to Internet, WWW and web browsers
4. MS Excel
5. MS Word
6. PowerPoint
7. Financial Literacy for Banking Scheme and Applications
SYLLABUS OUTLINE:
1. Knowing computer: What is Computer, Basic Applications of Computer; Components of Computer
System, Central Processing Unit (CPU), VDU, Keyboard and Mouse, Other input/output Devices,
Computer Memory, Concepts of Hardware and Software; Concept of Computing, Data and
Information; Applications of IECT; Connecting keyboard, mouse, monitor and printer to CPU and
checking power supply.
2. Operating Computer using GUI Based Operating System: What is an Operating System; Basics of
Popular Operating Systems; The User Interface, Using Mouse; Using right Button of the Mouse and
Moving Icons on the screen, Use of Common Icons, Status Bar, Using Menu and Menu-selection,
Running an Application, Viewing of File, Folders and Directories, Creating and Renaming of files and
folders, Opening and closing of different Windows; Using help; Creating Short cuts, Basics of O.S
Setup; Common utilities.
3. Introduction to Internet, WWW and Web Browsers: Basic of Computer networks; LAN, WAN;
Concept of Internet; Applications of Internet; connecting to internet; What is ISP; Knowing the
Internet; Basics of internet connectivity related troubleshooting, World Wide Web; Web Browsing
software, Search Engines; Understanding URL; Domain name; IP Address; Using e-governance
website.
4. MS Excel: What is MS Office; What is MS Excel; How to open Excel in any Computer, Basics of
Excel - File menu, Title bar, Quick access toolbar, Status Bar, Ribbons, Name box, Formula bar,
Workbook, Sheets, Columns and Rows, Cell, Cell range; Home - Clipboard, Font, Alignment, Number
Format, Format as Table; Formulas - Sum, Auto sum, Average, Count, CountA, Min, Max, Proper,
Upper, Lower, Now, Today, Fact, Power, Product, Sqrt; Insert - Table, Pictures, Shapes, Charts,
Comments, Text Box; Page Layout – Themes, Margins, Orientation, size, Print area; Data – Sort &
Filter, Remove Duplicates; View – Workbook Views, Show/Hide, Zoom;
5. MS Word: What is MS Word; How to open MS Word in any Computer, Basics of MS Word – File
menu, Title bar, Quick access toolbar, Status Bar, Ribbons; Home Ribbon – Clipboard, Font,
Paragraph, Styles; Insert – Pages, Tables, Pictures, Clip Art, Shapes, Smart Art, Chart, Header and
Footer, Text Box; Page Layout – Themes, Margins, Orientation, Size, Columns, Watermark, Page
Colour, Page Borders; View – Print layout, Full screen reading, Show/Hide, Zoom;
3
6. PowerPoint:
7. Financial Literacy for Banking Scheme and Applications: Why savings are needed, Why save in a
bank, Banking products-ATM card, Banking Instruments-Cheque, Demand Draft (DD), 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., 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).
DETAILED SYLLABUS
1. KNOWING COMPUTER
1.0 Introduction
1.1 Objectives
1.2 What is Computer?
1.2.1 Basic Applications of Computer
1.3 Components of Computer System
1.3.1 Central Processing Unit
1.3.2 Keyboard, mouse and VDU
1.3.3 Other Input devices
1.3.4 Other Output devices
1.3.5 Computer Memory
1.4 Concept of Hardware and Software
1.4.1 Hardware
1.4.2 Software
1.4.2.1 Application Software
1.4.2.2 Systems software
1.5 Concept of computing, data and information
1.6 Applications of IECT
1.6.1 e-governance
1.6.2 Entertainment
1.7 Bringing computer to life
1.7.1 Connecting keyboard, mouse, monitor and printer to CPU
1.7.2 Checking power supply
1.8 Summary
1.9 Model Answers
2. OPERATING COMPUTER USING GUI BASED OPERATING SYSTEM
2.0 Introduction
4
2.1 Objectives
2.2 Basics of Operating System
2.2.1 Operating system
2.2.2 Basics of popular operating system (LINUX, WINDOWS)
2.3 The User Interface
2.3.1 Task Bar
2.3.2 Icons
2.3.3 Menu
2.3.4 Running an Application
2.4 Operating System Simple Setting
2.4.1 Changing System Date and Time
2.4.2 Changing Display Properties
2.4.3 To Add or Remove a Windows Component
2.4.4 Changing Mouse Properties
2.4.5 Adding and removing Printers
2.5 File and Directory Management
2.5.1 Creating and renaming of files and directories
2.6 Common utilities
2.7 Summary
2.8 Model Answers
3. INTRODUCTION TO INTERNET, WWW AND WEB BROWSERS
3.0 Introduction
3.1 Objectives
3.2 Basic of Computer Networks
3.2.1 Local Area Network (LAN)
3.2.2 Wide Area Network (WAN)
3.3 Internet
3.3.1 Concept of Internet
3.3.2 Applications of Internet
3.3.3 Connecting to the Internet
3.3.4 Troubleshooting
3.4 World Wide Web (WWW)
3.5 Web Browsing Softwares
3.5.1 Popular Web Browsing Softwares
3.6 Search Engines
3.6.1 Popular Search Engines / Search for content
3.6.2 Accessing Web Browser
3.6.3 Using Favourites Folder
3.6.4 Downloading Web Pages
3.6.5 Printing Web Pages
3.7 Understanding URL
3.8 Surfing the web
5
3.8.1 Using e-governance website
3.9 Summary
3.10 Model Answers
4. EXCEL
4.0
5. MS WORD
5.0
6. POWERPOINT
6.0
7. FINANCIAL LITERACY FOR BANKING SCHEME AND APPLICATIONS
7.0 Introduction
7.1 Objectives
7.2 Why Savings are needed?
7.2.1 Emergencies
7.2.2 Future Needs
7.2.3 Large expenses
7.3 Drawbacks of keeping Cash at home
7.3.1 Unsafe
7.3.2 Loss of Growth Opportunity
7.3.3 No Credit Eligibility
7.4 Why Bank is needed?
7.4.1 Secure Money, Earn Interest, Get Loan
7.4.2 Inculcate habit of saving
7.4.3 Remittances using Cheque Demand Draft
7.4.4 Avoid risk of chit funds, sahukars
7.4.5 Documents needed for opening a bank account
7.5 Banking Products
7.5.1 Types of Accounts and Deposit
7.5.2 Types of Loan and Overdrafts
7.5.3 Filling up of Cheques, Demand Drafts
7.6 Banking Service Delivery Channels - I
7.6.1 Bank Branch, ATM
7.6.2 Bank Mitra with Micro ATM
6
7.7 Banking Service Delivery Channels - II
7.7.1 Internet Banking
7.7.2 National Electronic Fund Transfer (NEFT), Real Time Gross Settlement (RTGS)
7.8 Various Schemes
7.8.1 Pradhan Mantri Jan-Dhan Yojana (PMJDY)
7.8.2 Social Security Schemes
7.8.2.1 Pradhan Mantri Suraksha Bima Yojana (PMSBY)
7.8.2.2 Pradhan Mantri Jeevan Jyoti Bima Yojana (PMJJBY)
7.8.2.3 Atal Pension Yojana (APY)
7.8.2.4 Pradhan Mantri Mudra Yojana (PMMY)
7.8.3 National Pension Scheme
7.8.4 Public Provident Fund (PPF) Scheme
7.9 Bank on your mobile
7.9.1 Mobile Banking
7.9.2 Mobile Wallets
7.10 Insurance
7.10.1 Necessity of Insurance
7.10.2 Life Insurance and Non-life Insurance
7.11 Summary
7.12 Model Answers
