SCHEDULE

Computer Literacy Test Syllabus

(Total Marks: 100)
Time: 120 Minutes
Marks:60

PART-1

1. Introduction to Computer:-

(a) What is Computer
(b) Broad Categories of Computers
(c) Language of Computer
(d) Basic applications of Computer
(e) Components of Computer, Memory, CPU,
I/O Devices

2. Introduction to Windows and Windows Concepts:-

(a) Operation System and basic of Windows
(b) The user interface
(c) Windows setting
(d) Advanced Windows

3. MS Word:-

(a) Word Processing of Documents
(b) Opening and closing of Documents
(c) Moving around in a document
(d) Using a Document / Help Wizard
(e) Text creation and manipulation

• Paragraph and Tab setting
• Text selection
• Cut, Copy and Paste
• Font and size selection
• Bold, Italic and Underline
• Alignment of Text – Center, Left, Right and Justify
  (f) Formatting text
  (g) Table Manipulation
  (h) Printing

4.MS Excel :-

(a) Elements of Electronic Spread Sheet- MS Excel

• Application/usage of Spread sheet
• Opening of MS Excel
• The Menu bar
• Work Book and Sheets
• Creation of cell and addressing
• Cell inputting
• Edit features
  (b) Manipulation of cells
• Enter text, numbers and dates
• Insertion of cells, rows and columns
• Formatting of cells, rows and columns
• Creation of tables

Cell height and widths

-Copying and moving cells

(c) Use of formulas
(d) Data Manipulation
(e) Window – Freeze pans, Split, Hide
(f) Charts

Chart and its usage
Different types of Charts- Column, Bar, Line, Pie etc.
Creation of chart
Customization

(g) Spread sheet for small accounting

• Maintaining invoices / budget
• Totaling of various transactions
• Preparing monthly salary bills
• Preparing statistical reports with charts.

5.Power point:

(a) Basics

• Difference between and Presentation
• Using Power Point
• Opening Power Point Presentation

(b) Creation of Presentation

(c) Preparation of slides

• Selection type of slides
• Importing text from documents
• Moving to next slide
• The slide Manager

(d) Providing aesthetics
(e) Slide manipulation and slide show
(f) Presentation of slides
(g) Tips for creation Impactful Presentation.

6. Computer Communication and Internet:-

(a) Basic Computer networks

• LAN, WAN, MAN
  (b) Internet
  -Concept of Internet
• Application of Internet

(c) Service on Internet

• WWW and web sites
• Communication on Internet
  (d) Web browsing software
  (e) Surfing the Internet
• Giving URL address
  Search
• Moving around website
• Printing or saving portion of web pages
• Downloading

(f) Chatting on internet
(g) Remote Work Productivity
(h) Social Media Etiquette

7. Important Computer Abbreviations:-

(a) Computer Abbreviations for Basic Components

(b) Computer Sort Forms Related to Internet and Networ

8. Cyber Security Fundamentals & Awareness:-

(a) Computer Virus & Impact of Viruses

(b) Detection and prevention

(c) Cyber Threats

d) Common Threats and mitigation

e)Cyber Security safety tips

9. E-Mails and communication :-

(a) What is email, Email Drafting

(b) Team communication

(c) Project Communication

(d) Email Security

(e) Feedback and recognition

10. Information & Data Management:-

(a) Data Privacy and Data Protection

(b) IP, Copy Rights

(c) Different DBMS- Files, Cloud, Databases

11. Application used in Government:-

(a) e-office
(b) IPGRS
(c) CCMS
(d) Mahithi Kanaja
(e) Pada Kanaja/e Kannada
(f) RTI ONLINE
(g) KUTUMBA
(h) HRMS
(i) Khajane

12. Emerging Technologies;-

Artificial Intelligence (AI) & Generative AI

PART -2

Marks:40

1. Typing Test.

(a) English-

• Home Row Keys
• Common Keyboard Shortcuts
• Word Processing Skills

b) Kannada

• Kannada Script Basics.
• Nudi
• Unicode