COMPUTER AWARENESS COMPETITION

COMPUTER AWARENESS COMPETITION

Aim

1. The aim of the competition is to generate computer wareness and to cultivate computer culture among the Police personnel, promote office automation and to identify and encourage the existing talent through a spirit of healthy competition. This competition has been introduced from 1992.

Scope

The Scope of the competition is as follows:

i) Event - I: Computer Awareness and basic

Knowledge to be tested in the form of an objective type test. There shall be negative marking for wrong answers. For every 4 wrong answers 0.25 negative marks shall be deducted. There will be no negative marks for question with NO ANSWER (left blank / not answered).

ii) Event - ll: Practical tests involving Office Automation as follows:

a. Text Entry MS-Word (for testing speed and accuracy)

b. Preparation of a Presentation material in MS PowerPoint - 5 pages

c. Creating of a table in MS-Excel. Preparation of graph (Pie-chart, histogram, bar-chart, line-chart etc.) and printing.

iii) Event - Ill: This event has two options out of which one option is to be selected, as per convenience.

a. Option -I: Develop a prescribed program using Visual Basic Version 6.0 for Data entry and retrieval. Make appropriate validation on one of the screens. MS - Access to be used as database.

b. Option - II: Practice application of CCIS ~ MLe (Crime Criminal Information System Multi Lingual)

i) Form Entries -IIFs (to test speed and accuracy of data entry)

ii) Queries and reports

iii) Using CCls database, generate prescribed report through SQL

Method Of Conduct

3. The competition will be conducted for the Events - I and 11 as individual events and Event - III will be team event. Individual scores will be aggregated for the individual events to get the team scores.

Team Composition

4. A maximum number of participants in a team, for each State/UT/CPO will be 5 (five) and shall not be above the rank of a Dy. SP. In Event-I, a maximum of four members from an organization can participate, while in Event - 11 only one member of the team from an organization can participate. In Event - Ill, any two members of the team can participate. Each participant will be free to participate in more than one event.

Eliaibility

5. All States/UT Police/ CPOs are eligible to participate, except NCRB, which will be Coordinating and conducting the Competition.

Referees

6. Referees for the conduct of the competition and evaluation will be nominated by NCRB. In the event of any protest, the decision of Chief Judge will be final and binding on all the teams. In the event of a tie of positions the following methods shall be used.

Event-I: Contestant having more correct answers shall be decaled the winner. In case of a tie in number of correct answers also, no. of wrong answers shall be taken into reckoning. Contestant with lesser negative marks shall be the winner.

Event- II: Contestant taking lesser time in completing the tasks will be declared the winner.

Event - III: Team taking lesser time in completing the tasks will be decaled the winner.

Prizes

Event -I: Individual Gold, Silver and Bronze for contestants standing First, Second and Third respectively. Eve

Event- II: Individual Gold, Silver and Bronze for contestants standing First, Second and Third respectively

Event- III: Both members of the team will get Gold, Silver and Bronze for team standing First, Second and Third respectively.

Best Team for Overall performance of Event - I, 11 and III

Winner Trophy : One

Runners Up Trophy : One

Overall performance is adjudged by the following formula

(a) Average scores of Event - I + Score of Event - II + Score of Event - III

(b) In case of a tie (Le. if two or more teams end up with the same score, then team that has higher average score is Event - I shall be the winner.

(c) In case of tie in over all aggregate and the average ~ Event - I score highest individual score in Event - I shall decide the winner. Example.

Team A, Team B and Team C have same final aggregate of 76 marks.

Average Score in Event - I for Team A and Team C is 40 marks and that of Team B is 41. In this case Team B shall take first Position.

For second and third position, Team A and Team C are tied. Team A and Team C had two contestants each in Event I. Score of individual contestants for Team A and C are as follows

Team - A Team - C

Contestant A1 – 60 Contestant C1- 15

Contestant A2 - 20 Contestant C2 - 65

In this case Contestant C2 of Team C has scored highest amount the 4 contestants. Therefore, Team C shall take second position while Team A finished third.

Final Ranking: Team B followed by Team C and Team A in that order.

(c)In case of tie in over all aggregate and the average Event - I score highest individual score in Event I shall decide the winner. Example.

Team A, Team B and Team C have same final aggregate of 76 marks.

Average Score in Event - I for Team A and Team C is 40 marks and that of Team B is 41. In this case Team B shall take first Position.

For second and third position, Team A and Team C are tied. Team A and Team C had two contestants each in Event I. Score of individual contestants for Team A and C are as follows

Team - A

Team - C

Contestant Ai - 60 Contestant A2 - 20

Contestant Cl- 15 Contestant C2 - 65

In this case Contestant C2 of Team C has scored highest amount the 4 contestants. Therefore, Team C shall take second position while Team A finished third.

Final Ranking: Team B followed by Team C and Team A in that order.

6. Computer Peripherals

(a) Printers/ Scanners, (b) Multimedia, (c) Modems, (d) RFIDs

7. Different types of ports

8. Computer architecture

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

Software:

1. Office Suites

(a) MS Office (Word, Excel, PowerPoint and Access)

(b) Star Office Suite

2. Data Bases

(a) Visual FoxPro, (b) ORACLE, (c) MS SQL Server, (d) MS SQL/ PostGre

3. Programming Tools

(a) Visual Basic, VB. NET, (b) C, C++ (d) Java, (e) XML

4. Web designing packages

(a) HTML, (b) ASP/ASP.NET

5. Data Warehousing and Data Mining

(a) OLAP

Compute Security

1. Cyber Security / Network security including

(a) Firewall, (b) lDS, (c) IPS

2. Cyber Crime

3. Cyber Forensics

4. Morphing

5. Virus

(a)Types, (b) Functionalities, (c) Signature, (d) Scanners and cleaners

6. Security Policy

7. Encryption technologies

(a) PKI, (b) 128 Bit, (c) SSL

Miscellaneous

(a) Scanning technology

(b) OCR/OMR

(d) GIS

(e) Robotics

(f) Artificial Intelligence

(g) Biometrics

(h) Bioinformatics

(i) Blue Tooth Technology

(j) IT Act 2000

(k) IT Initiatives in Police

All India Police Duty Meet

Operatina Systems:

1. MS-DOS

2. Windows 9x/Windows 2000/ Windows 2003/ Windows NT

3. Novell Network

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

Groupware

1.	MS Exchange
2.	Lotus Notes
3.	Novel Groupware

Networking

1. Fundamentals of networking technology including (a) Types of networks

(b) Hubs, Routers, Switches, Gateways

(d) VAST Technology

(e) ISDN/ PSTN, Leased Line, Frame relay

(f) Wireless LAN Technology

2. OSI Layer and its functionalities

3. Protocols

4. Internet/Intranet/ Extranet

5. VPN

6. LAN/ WAN/ MAN

7. Data structure and communication

8. POLNET

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 - 11)

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 data 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

ENTRY FORM FOR COMPUTER AWARENESS COMPETITION

1. NAME OF THE STATE:

2. NAME OF THE GAZETTED OFFICER IN-CHARGE:

S.NO.	NAME OF THE COMPETITOR	RANK
1.
2.
3.
4.

CERTIFIED THAT

1. All the competitors listed above have served for more than one year in the Police Department as on (date of competition).

2. None of the above competitors has attained 1st, 2nd or 3rd position in the competitions during the preceding three meets.

3. The entry fee of above competitors has been paid to the Org. Secretary_- All India Police Duty Meet.

4. "---" of the above competitors are Non-vegetarians and "---" are Vegetarians.

Back