Computer Knowledge — Study Notes for MH Police Bharti
Overview
Computer Knowledge is a scoring section in the Maharashtra Police Bharti exam. Questions test your understanding of basic computer components, common software applications, and internet fundamentals. You don't need deep technical expertise—the focus is on practical awareness that any computer-literate person should have.
Since the concepts are straightforward and factual, mastering this section can give you quick, easy marks. Focus on memorising key terms, full forms of abbreviations, and understanding what each component does rather than how it works internally.
Most questions are direct—identifying parts of a computer, matching software to its function, or recognising internet-related terms. A solid grasp of MS Office basics (Word, Excel, PowerPoint) is especially important as these appear frequently.
Key Concepts
- Hardware vs Software: Hardware is physical (keyboard, monitor, CPU); software is programs/instructions (Windows, MS Word). Hardware you can touch, software you cannot.
- Input-Process-Output Model: Computer takes input (keyboard, mouse), processes it (CPU), and gives output (monitor, printer). This is the fundamental working cycle.
- Primary vs Secondary Memory: RAM is primary (temporary, fast, volatile); Hard Disk/SSD is secondary (permanent, slower, non-volatile). RAM loses data when power is off.
- Operating System (OS): Software that manages hardware and runs other programs. Examples: Windows, Linux, macOS, Android. Without OS, computer cannot function.
- Application Software: Programs for specific tasks—MS Word for documents, Excel for calculations, Chrome for browsing. Different from system software.
- Internet vs Intranet: Internet is global public network; Intranet is private network within an organisation. Both use similar technology but differ in access.
- Computer Generations: Evolution from vacuum tubes (1st) → transistors (2nd) → ICs (3rd) → microprocessors (4th) → AI-based (5th).
- Binary System: Computers use 0 and 1 (binary/machine language). All data—text, images, video—is ultimately stored as binary.
Key Facts (Must Remember)
| Term | Full Form / Meaning |
|---|---|
| CPU | Central Processing Unit — "brain" of computer |
| RAM | Random Access Memory — temporary working memory |
| ROM | Read Only Memory — permanent, stores startup instructions |
| HDD | Hard Disk Drive — magnetic storage |
| SSD | Solid State Drive — faster, no moving parts |
| USB | Universal Serial Bus — connecting devices |
| HTTP | HyperText Transfer Protocol — web communication |
| HTTPS | HTTP Secure — encrypted web communication |
| URL | Uniform Resource Locator — web address |
| WWW | World Wide Web — system of interlinked web pages |
| LAN | Local Area Network — small area like office |
| WAN | Wide Area Network — large area like country |
| ISP | Internet Service Provider — gives internet access |
| GUI | Graphical User Interface — visual interaction |
| BIOS | Basic Input Output System — startup firmware |
MS Office Components:
- MS Word — Document/letter creation
- MS Excel — Spreadsheets and calculations
- MS PowerPoint — Presentations
- MS Access — Database management
- MS Outlook — Email client
Important Keyboard Shortcuts:
- Ctrl + C = Copy
- Ctrl + V = Paste
- Ctrl + X = Cut
- Ctrl + Z = Undo
- Ctrl + S = Save
- Ctrl + P = Print
- Ctrl + A = Select All
- Alt + F4 = Close program
Worked Examples
Example 1: Hardware Identification
Question: Which of the following is an output device? (A) Keyboard (B) Mouse (C) Scanner (D) Printer
Solution:
- Step 1: Output device shows/gives result from computer
- Step 2: Keyboard, Mouse, Scanner all send data TO computer = Input devices
- Step 3: Printer produces physical output FROM computer
- Answer: (D) Printer
Example 2: Memory Type
Question: Which memory loses its content when computer is switched off? (A) ROM (B) Hard Disk (C) RAM (D) CD-ROM
Solution:
- Step 1: "Loses content when power off" = Volatile memory
- Step 2: ROM, Hard Disk, CD-ROM retain data = Non-volatile
- Step 3: RAM is volatile (temporary working memory)
- Answer: (C) RAM
Example 3: MS Excel Function
Question: In MS Excel, which function adds all values in a range? (A) COUNT (B) SUM (C) AVERAGE (D) MAX
Solution:
- COUNT = counts number of cells with data
- SUM = adds all values
- AVERAGE = calculates mean
- MAX = finds largest value
- Answer: (B) SUM
Common Mistakes
| Wrong Thinking | Correct Understanding |
|---|---|
| "CPU is the whole computer cabinet" | CPU is only the processor chip inside. The cabinet/tower is called the "system unit" or "cabinet." |
| "More RAM means more storage space" | RAM is temporary working memory, not storage. Hard disk/SSD is for storage. More RAM = faster multitasking, not more files. |
| "Internet and WWW are the same thing" | Internet is the network infrastructure. WWW is a service that runs ON the internet (like email is another service). |
| "Scanner is an output device because it produces images" | Scanner sends data TO computer (digitises physical documents) = Input device. It doesn't produce output FROM computer. |
| "1 KB = 1000 bytes" | In computing: 1 KB = 1024 bytes, 1 MB = 1024 KB, 1 GB = 1024 MB. Based on powers of 2, not 10. |
| "Ctrl +(blank) shortcuts work only in MS Office" | Most Ctrl shortcuts (Copy, Paste, Save) work across almost all Windows applications. |
Quick Reference
- Input devices: Keyboard, Mouse, Scanner, Microphone, Webcam, Joystick
- Output devices: Monitor, Printer, Speaker, Projector, Headphones
- 1 GB = 1024 MB = 1024 × 1024 KB = 1024 × 1024 × 1024 bytes
- Father of Computer: Charles Babbage
- First Computer Programmer: Ada Lovelace
- Extension files: .docx (Word), .xlsx (Excel), .pptx (PowerPoint), .pdf (Portable Document)
- Virus = malicious program; Antivirus = software that detects/removes viruses
- Browser examples: Chrome, Firefox, Edge, Safari — used to access websites