UP Police Computer Operator study plan

Draw and label the block diagram of a computer (CPU, ALU, control unit, registers, memory hierarchy, I/O) from memory and explain each unit's role in one sentence

Convert numbers between binary, octal, decimal and hexadecimal by hand and verify ten conversions with a calculator

Solve ten practice problems on 1's and 2's complement, signed magnitude and overflow detection

List at least fifteen file extensions and the software category each belongs to (system, application, utility, antivirus)

Write a one-page comparison of primary vs secondary memory covering speed, cost, volatility and two example devices each

Perform in Excel: relative vs absolute references, five functions (SUM, AVERAGE, IF, VLOOKUP, COUNTIF), sorting, filtering, conditional formatting and one chart, on a 20-row practice sheet

Build a Word document with headings, table of contents, mail merge from a 5-record list, and section-based page numbering

Create a 6-slide PowerPoint with a consistent theme, transitions, speaker notes and one SmartArt or chart

Explain the OS functions (process, memory, file, device management) and differentiate GUI vs CLI, multitasking vs multiprocessing, and 32-bit vs 64-bit

Compare Windows, Linux and mobile OS file systems and list five keyboard shortcuts for each of Windows and MS Office

Map the OSI and TCP/IP models layer by layer and match at least two protocols and one device to each layer

Classify IP addresses into classes, identify private ranges, and compute subnets for at least eight practice addresses

Describe DNS resolution, HTTP request-response and DHCP lease steps in sequence without notes

Explain symmetric vs asymmetric encryption, hashing, digital signature, firewall types and SSL/TLS in plain language

Summarise key provisions of the IT Act 2000 (as amended 2008), including Sections 66, 66C, 66D, 67 and 72, and list three cybercrime categories with reporting channels

Write SQL queries using SELECT, WHERE, ORDER BY, GROUP BY with HAVING, INNER and LEFT JOIN, and subqueries on a 3-table practice schema

Define primary key, foreign key, candidate key, normalisation up to 3NF, and ACID properties with one example each

Code and dry-run ten C programs covering loops, arrays, strings, functions and pointers

Trace C++ output for five snippets involving classes, constructors and inheritance, and list four OOP pillars with an example

Differentiate compile-time vs runtime errors, and trace a small Java program using classes, objects and arrays

Complete 60 Hindi grammar questions covering संधि, समास, उपसर्ग-प्रत्यय, तत्सम-तद्भव and मुहावरे, and record every error with the rule

Complete 60 English questions on tenses, articles, prepositions, subject-verb agreement, synonyms and antonyms, and note the rule behind each error

Solve 40 quantitative aptitude questions on percentage, ratio, average, profit-loss, time-work and simple-compound interest

Solve 40 reasoning questions on series, coding-decoding, blood relations, direction sense and syllogisms, timing each set

Write two short paragraphs (one Hindi, one English) of 100 words each on a policing-related topic with correct grammar

Memorise and recite the UP Police structure (DGP, zones, ranges, districts, police stations) and the ranks hierarchy with insignia descriptions

List ten important UP police initiatives and citizen services (for example UP 112, Mission Shakti, Women Power Line 1090, cyber crime helpline 1930) and state what each does

Summarise ten current affairs items from the last six months related to UP, national security and technology, in two lines each

Explain digital forensics basics: chain of custody, imaging, hash verification, volatile vs non-volatile evidence, and the legal value of electronic evidence under the IT Act and Evidence Act

Describe three real cybercrime patterns (OTP fraud, phishing, sextortion) with prevention advice a police officer would give

Re-solve twenty previously wrong questions each from computer fundamentals, MS Office and DBMS/SQL without looking at the answer key

Recreate the Week 2 Excel and Word tasks in half the time taken earlier

Write ten SQL queries and ten C snippets under a five-minute-per-question timer

Explain aloud, in under two minutes each, five core topics (memory hierarchy, normalisation, OSI model, mail merge, OOP pillars) as if teaching a colleague

Take two full-length timed mock tests simulating exam conditions and review every wrong answer the same day

Revise the Week 1 formula sheet, Week 3 network and cyber-law sheets, and Week 6 UP policing fact sheet once each

Practise 30 speed questions each in Hindi grammar, English grammar and quantitative aptitude in 15-minute blocks

Prepare a final one-page revision card of the ten facts you forget most often and read it daily for the last three days