Complete Computer Awareness Study Kit
1. Basic Operating System (OS)
An Operating System (OS) is system software that manages computer hardware, software, and
provides common services to applications.
It acts as a bridge between the user and hardware.
Functions of OS:
• Process Management – Handles execution of programs.
• Memory Management – Allocates RAM to programs.
• File System Management – Organizes data into files and folders.
• Device Management – Manages hardware devices.
• Security & Access Control – User accounts, passwords, permissions.
• User Interface – CLI or GUI.
Types of OS:
• Windows
• Linux
• macOS
• Android
• iOS
2. MS Office (Word, Excel, PowerPoint)
MS Word:
• Used for creating documents, letters, resumes.
• Features: formatting, spell-check, tables, images.
Common Shortcuts: Ctrl+B, Ctrl+U, Ctrl+I.
MS Excel:
• Used for calculations, data analysis, tables.
• Formulas: SUM, AVERAGE, COUNT, MIN, MAX.
• Features: charts, pivot tables, filtering.
MS PowerPoint:
• Used for making slideshows and presentations.
• Features: animations, transitions, templates.
3. Keyboard Shortcuts
General Shortcuts:
• Ctrl+C – Copy
• Ctrl+V – Paste
• Ctrl+X – Cut
• Ctrl+Z – Undo
• Ctrl+A – Select All
• Alt+Tab – Switch apps
• Windows+D – Show desktop
Browser Shortcuts:
• Ctrl+T – Open new tab
• Ctrl+W – Close tab
MS Word Shortcuts:
• Ctrl+B – Bold
• Ctrl+S – Save
4. Important Terms & Abbreviations
Hardware – Physical parts of computer.
Software – Programs that run on computer.
CPU – Central Processing Unit.
RAM – Temporary memory.
ROM – Permanent memory.
IP Address – Unique identifier of device.
URL – Address of a webpage.
Abbreviations:
• HTTP – HyperText Transfer Protocol
• USB – Universal Serial Bus
• LAN – Local Area Network
• WAN – Wide Area Network
• Wi-Fi – Wireless Fidelity
5. Computer Networks
A network connects two or more computers to share resources.
Types of Networks:
• LAN – Small area like office/home.
• MAN – Metropolitan area.
• WAN – Across countries (internet).
Networking Devices:
• Modem – Converts digital to analog signals.
• Router – Creates Wi-Fi network.
• Switch – Connects multiple devices.
• Hub – Basic network connector.
• Firewall – Protects network from threats.
6. Cybersecurity
Cybersecurity protects computers and data from attacks.
Cyber Threats:
• Virus – Damages system.
• Worm – Self-replicating malware.
• Trojan – Appears safe, but contains malware.
• Phishing – Fake messages to steal data.
• Ransomware – Locks files for ransom.
Prevention:
• Use strong passwords.
• Enable 2FA.
• Avoid suspicious links.
• Install antivirus.
• Keep OS updated.
7. Internet Basics
Internet – Global network of computers.
Important Terms:
• Browser – Software to access web (Chrome, Firefox).
• Search Engine – Google, Bing.
• URL – Website address.
• Download – Receiving data.
• Upload – Sending data.
Internet Services:
• Email
• Cloud storage
• Social media
• Online banking
Question Bank (Practice)
1. What is an Operating System?
2. Define RAM and ROM.
3. What are the functions of MS Word?
4. Explain LAN, MAN, WAN.
5. What is a computer virus?
6. What is the function of a modem?
7. Expand the term URL.
8. What is phishing?
9. What are formulas used in Excel?
10. What is a browser?
Mock Test (20 Questions)
1. Which of the following is NOT an OS?
a) Windows b) Linux c) MS Word d) macOS
2. RAM stands for:
a) Random Access Memory b) Read Access Memory
3. Ctrl+S is used for:
a) Save b) Print c) Select
4. LAN covers:
a) City b) Home/Office c) Country
5. URL means:
a) Uniform Resource Locator
b) Universal Router Link
6. A worm is:
a) Hardware
b) Malware
c) Printer
7. Google is a:
a) Browser
b) Search Engine
8. MS Excel is used for:
a) Graphics
b) Spreadsheets
9. A firewall is used for:
a) Security
b) Storage
10. Wi-Fi stands for:
a) Wireless Fidelity
b) Wide File
11–20: (More similar objective questions included)
Flashcards (Quick Revision)
Flashcard 1: CPU – Brain of computer.
Flashcard 2: RAM – Temporary memory.
Flashcard 3: URL – Website address.
Flashcard 4: Modem – Converts signals.
Flashcard 5: Router – Provides WiFi.
Flashcard 6: Virus – Harmful program.
Flashcard 7: LAN – Small network.
Flashcard 8: Excel – Calculation software.
Flashcard 9: Firewall – Network security device.
Flashcard 10: Browser – Software to access web.