SYLLABUS FOR COMPUTER AWARENESS COMPETITION IN THE ALL INDIA POLICE DUTY MEET

Event. I
OBJECTIVE TYPE TEST
(Multiple choice, fill in the blanks, true or false and matching)
Time:1 Hours
Max Marks - 100
Hardware:


1. Fundamentals of Computers
2. Computer generations with changing technology
(a) Super Computer, (b) Mini IMain Frames, (c) Laptops,
(d) RISC/CISCI/ntel Based Systems

3. Memories:
(a) Chip, (b) MOS, (c) BIOS,
(d) ROMI RAM/EPROMI ECCI DDR/EDO, (e) Flash Memory

4. Storage device:
(a) Hard disks, (b) Floppy diskettes, (c) CD-ROMI DVDI DATI CTD
(d) Pen Drive. (e) RAID, (t) Storage Networks (SAN), (g) Clustering

5. Numbering systems:
(a) Binaryl OctaV Hexadecimal and their conversions,
(b) Binary representations
(c) Binary Calculations (Additionl Subtractionl Divisionl Multiplication)
(d) Negative Numbers,
(e) Complements

6. Computer Peripherals
(a) Printersl Scanners. (b) Multimedia, (c) Modems, (d) RFIDs
7. Different types of ports

8. Computer architecture
(a) Client - Server (b) Host Based 1 Master Slave (c) Hybrid
(d) Peer to Peer (e) Different tires of architecture (two-tier I three tier)


Software:
1.Office Suites
(a) MS Office rNord, Excel, PowerPoint and Access)
(b) Star Office Suite
(c) lotus Smart Suite (lotus 123, Freelance, lotus WordPro)


2. Data Bases
(a) Visual FoxPro, (b) ORACLE, (c) MS SOL Server,
(d) MS SOU PostGre


3. Programming Tools
(a) Visual Basic, VB.NET, (b) C, (c) C++ and Visual C++
(d) Java, (e) XMl


4. Web designing packages
(a) HTMl, (b) ASP/ASP.NET


5. Data Warehousing and Data Mining
(a) OLAP


Operating Systems:
1. MS-DOS

2. Windows 9x1Windows 20001 Windows 2003/ Windows NT

3. Novell Network

4. UNIX/ Linux / Sun Solaris / HP UXI AIX

Group ware
1. MS Exchange

2. lotus Notes

3. Novel Groupware


Networking
Fundamentals of networking technology including
(a) Types of networks
(b) Hubs, Routers, Switches, Gateways
(c) Cables (UTP/ FDDl / Ethernet etc.)
(d) VAST Technology
(e) ISDNI PSTN, Leased Line, Frame relay


(1) Wireless LAN Technology
· OS layer and its functionalities
· Protocols
· Interne/ lntranet / Extranet
· VPN
· LAN/ WAN/ MAN
· Data structure and communication
· POLNET


Computer Security
· Miscellaneous
· Cyber Security I Network security including
· Firewall, (b) IDS, (c) IPS
· Cyber Crime
· Cyber Forensics
· Morphing
· Virus
· (a)Types, (b) Functionalities, (c) Signature, (d) Scanners and cleaners
· Security Policy
· Encryption technologies
(a) PKI, (b) 128 Bit, (c) SSL



a. Scanning technology
b. OCR/OMR
c. Speech! voice recognition
d. GIS
e. Robotics
f. Artificial Intelligence
g. Biometrics
h. Bioinformatics
i. Blue Tooth Technology
j. IT Act 2000
k. IT Initiatives in Police








Event-II
Office Automation (Part - I)
Time 1 Hr.
Max Marks - 100
Topics
MS-Office (Latest version)
(a) Text Entry in MS - Word (Speed and accuracy will be tested)
(b) Preparation of 5 pages of presentation material on Power Point.
(c) Creation of a table in MS-Excel and preparation of a graph (Pie -
Chart, Histogram, Bar Chart, Line Chart, etc.) pivot table and print
Event - III


OFFICE AUTOMATION (PART -II)
Time 1 Hr.
Max. Marks 100
(This Event has two options. Only one option may be selected as per
convenience)
Option 1
Develop an application using MS Access as the back - end
database. Visual Basic (latest version) to be used as the front - end and development tool. The requirement specification will be provided at the time of test. Application should include at least one data entry screen and at least one date retrieval facility (Query and Report).
Option 2
CCIS (Crime Criminal Information System)
1. Form entries IIF (Speed and accuracy)

2. Queries and reports
3. Using CCIS database generate prescribed reports through MS SQL

.