0% found this document useful (0 votes)
8 views42 pages

JKSSB Complete Computer

The document provides a comprehensive overview of computer fundamentals, including definitions, characteristics, history, generations, classifications, architecture, and memory units. It covers essential hardware components such as input and output devices, along with their functionalities and examples. Additionally, it highlights important abbreviations and includes exam-related questions and answers for better understanding and preparation.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd
0% found this document useful (0 votes)
8 views42 pages

JKSSB Complete Computer

The document provides a comprehensive overview of computer fundamentals, including definitions, characteristics, history, generations, classifications, architecture, and memory units. It covers essential hardware components such as input and output devices, along with their functionalities and examples. Additionally, it highlights important abbreviations and includes exam-related questions and answers for better understanding and preparation.
Copyright
© All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as PDF, TXT or read online on Scribd

YOUTUBE-JK EXAM MADE EASY | Shivam R.

(i) Fundamentals
(ii) Hardware & Software
(iii) I/O Devices
(iv) Operating System
(v) MS Office (Word, Excel, PPT, Access)
(vi) Internet & Email

1. INTRODUCTION TO COMPUTER

• The word "Computer" is derived from the Latin word ‘Computare’, which means "to
calculate".

• Definition: An electronic device that accepts data (Input), processes it under the control of
instructions (Program), produces information (Output), and stores it for future use.

• Functionality (I-P-O Cycle):

1. Input: Takes raw data.

2. Process: CPU works on data.

3. Output: Gives result (Information).

4. Storage: Saves data.

MCQ Extra (Added Info):

• Data vs. Information:

• Data: Raw, unorganized facts (e.g., "Ram", "25").

• Information: Processed, meaningful data (e.g., "Ram is 25 years old").

• GIGO Principle: Garbage In Garbage Out (Accuracy of output depends on accuracy of input).

2. CHARACTERISTICS OF COMPUTER

From PDF:

• Speed: Performs millions of calculations per second.

• Accuracy: Gives 100% correct results (errors are human/input errors).

• Diligence: Never gets tired; can work for hours with same concentration (No fatigue).

• Versatility: Can perform different types of tasks (Music + Typing + Downloading).


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Storage: High capacity to store data.

• No IQ: It cannot think; it is a "Dumb Machine" without instructions.

• No Feelings: No emotions.

MCQ Extra:

• Speed Unit: Measured in Hz (Hertz) for PC, MIPS (Millions of Instructions Per Second) for old
CPUs, and FLOPS for Supercomputers.

3. HISTORY OF COMPUTERS (Evolution)

• Father of Computer: Charles Babbage (Designed 'Analytical Engine' in 1833).

• Lady Ada Lovelace: First Programmer (Suggested Binary Data storage).

• First Electronic Computer: ENIAC (1946) by J.P. Eckert & J.W. Mauchly.

• First Stored Program Computer: EDSAC (1949).

• First Commercial Computer: UNIVAC (1951).

MCQ Extra:

• Abacus: First mechanical calculating device (China, ~3000 BC).

• Pascaline: First mechanical adding machine (Blaise Pascal).

• Father of Modern Computer Science: Alan Turing.

• First Computer in India: HEC-2M (Installed at ISI Kolkata, 1955).

• Siddharth: First computer manufactured in India.

4. GENERATIONS OF COMPUTERS

(The PDF likely has a table; here is the extracted detailed version + examples)

Gen Period Main Component Language Examples (MCQ Gold)

1st 1940-56 Vacuum Tubes Machine (Binary) ENIAC, UNIVAC, EDVAC

2nd 1956-63 Transistors Assembly IBM 1401, IBM 7094

3rd 1964-71 IC (Integrated Circuits) High Level (C, Basic) IBM 360, PDP-8
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Gen Period Main Component Language Examples (MCQ Gold)

4th 1971-Pres Microprocessor (VLSI) SQL, C++ Intel 4004, Cray-1, PC

5th Present ULSI + AI NLP (Natural Lang) Robots, PARAM

MCQ Extra:

• Transistor Inventor: Shockley, Bardeen, Brattain.

• IC Chip Inventor: Jack Kilby (Made of Silicon).

• VLSI: Very Large Scale Integration.

• ULSI: Ultra Large Scale Integration.

5. CLASSIFICATION OF COMPUTERS

From PDF: A. Based on Working Principle:

1. Analog: Continuous data (Speedometer, Voltmeter, Thermometer).

2. Digital: Discrete data (0s and 1s) (Desktop, Mobile).

3. Hybrid: Combination of both (ECG Machine, Dialysis Machine, Petrol Pump).

B. Based on Size/Capacity:

1. Micro Computer: Uses Microprocessor. Single User. (PC, Laptop, PDA).

2. Mini Computer: Mid-range. Supports 4-200 users. Used in small servers.

3. Mainframe Computer: Very large. Supports 1000s of users. Used for Bulk Data
Processing (Banks, Railways, Insurance).

4. Super Computer: Fastest. Used for Complex Calculations (Weather Forecasting, Nuclear
Science).

MCQ Extra:

• World's 1st Supercomputer: Cray-1 (Seymour Cray, 1976).

• India's 1st Supercomputer: PARAM 8000 (1991, C-DAC Pune).

• Architect of PARAM: Dr. Vijay Bhatkar.

• Current Fastest (India): AIRAWAT (AI Supercomputer).

• Current Fastest (World): Frontier (USA).

6. COMPUTER ARCHITECTURE (Block Diagram)

The architecture is based on Von Neumann Model.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Opens in a new window

1. Input Unit: Feeds data.

2. CPU (Central Processing Unit): The "Brain".

• ALU (Arithmetic Logic Unit): Performs Math (+, -, *) and Logic (>, <, =).

• CU (Control Unit): "Nervous System". Decodes instructions and controls data


flow. Does not process data.

• MU (Memory Unit/Registers): Fast, temporary storage inside CPU.

3. Output Unit: Displays result.

MCQ Extra:

• Registers: The fastest memory in a computer.

• Accumulator: Register that stores the intermediate result of ALU operations.

• Program Counter (PC): Register that stores the address of the NEXT instruction.

7. MEMORY UNITS (Data Representation)

From PDF:

• Bit: Binary Digit (0 or 1). Smallest unit.

• Nibble: Group of 4 Bits.

• Byte: Group of 8 Bits. (Standard unit for 1 character).

• Word: Number of bits CPU can process at once (Word Length).

Measurement Table (Memorize):

• 1 KB = 1024 Bytes

• 1 MB = 1024 KB
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• 1 GB = 1024 MB

• 1 TB = 1024 GB

• 1 PB (Petabyte) = 1024 TB

MCQ Extra:

• Binary System Base: 2.

• Decimal System Base: 10.

• Octal Base: 8.

• Hexadecimal Base: 16 (0-9 and A-F).

8. IMPORTANT ABBREVIATIONS FROM TOPIC

• BIOS: Basic Input Output System.

• POST: Power On Self Test.

• CPU: Central Processing Unit.

• ALU: Arithmetic Logic Unit.

• CU: Control Unit.

• VDU: Visual Display Unit.

• ENIAC: Electronic Numerical Integrator and Computer.

• UNIVAC: Universal Automatic Computer.

• GIGO: Garbage In Garbage Out.

• USB: Universal Serial Bus.

TOPIC: HARDWARE (Input & Output Devices)

Definition: Hardware refers to the physical components of a computer that can be touched and seen.

1. INPUT DEVICES

Devices used to enter data and instructions into the computer.

A. Keyboard (Most common input device)

• Inventor: Christopher Latham Sholes.

• Layout: QWERTY is the standard layout.

• Key Types (From PDF & Exam):

• Function Keys: F1 to F12 (12 keys).


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Toggle Keys: Keys that switch a function on/off (Caps Lock, Num Lock, Scroll Lock).

• Modifier Keys: Keys used in combination with others (Ctrl, Shift, Alt).

• Navigation Keys: Arrow keys, Home, End, Page Up, Page Down.

B. Mouse (Pointing Device)

• Inventor: Douglas Engelbart (1964).

• Types:

• Mechanical: Uses a rubber ball (Old).

• Optical: Uses a light beam/laser (Modern).

• Functions: Click (Select), Double Click (Open), Right Click (Context Menu/Properties), Drag &
Drop.

C. Other Pointing Devices

1. Joystick: Used for playing video games (Flight simulators) and controlling robots. It has a
vertical stick.

2. Trackball: Like a mouse but with the ball on top. You move the ball with your thumb. Used in
CAD workstations.

3. Light Pen: A pen-like device used to draw directly on CRT screens. Used by
engineers/architects.

4. Touchpad: Pointing device on Laptops.

5. Stylus: Pen used on tablets/touchscreens.

D. Scanning Devices

1. Scanner: Converts Hard Copy (Paper) into Soft Copy (Digital Image).

2. OCR (Optical Character Recognition): Scans a document and converts it into editable text.

3. OMR (Optical Mark Reader): Scans specific marks (bubbles). Used for checking Exam
Answer Sheets.

4. MICR (Magnetic Ink Character Recognition): Reads special magnetic characters. Used
in Banks for Cheque Clearance.

5. BCR (Bar Code Reader): Reads vertical black and white lines (Barcodes) on products. Used in
Supermarkets.

6. QR Code (Quick Response): 2D matrix barcode (Square shape).

E. Audio/Visual Input

• Microphone: Converts sound (Analog) into Digital signals.

• Webcam: Captures video input.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

2. OUTPUT DEVICES

Devices used to display or print the processed result.

A. Monitor (VDU - Visual Display Unit)

• Soft Copy Output: Shows temporary output on screen.

• Types:

1. CRT (Cathode Ray Tube): Old, bulky, high power consumption.

2. LCD (Liquid Crystal Display): Thinner, lighter. used in Laptops.

3. LED (Light Emitting Diode): Energy efficient, better quality.

4. OLED: Organic LED (Flexible screens).

• MCQ Extra:

• Pixel: Smallest dot on the screen.

• Resolution: Total number of pixels (Width x Height). Higher resolution = Clearer


image.

• Refresh Rate: Measured in Hz (Hertz).

B. Printer

• Hard Copy Output: Prints result on paper.

• Classification of Printers:

Type Mechanism Examples Key Exam Points

Impact Strike a ribbon against paper Dot Matrix, Daisy Low quality, cheap. Dot
Printers (Hammer action). Noisy. Wheel Matrix prints in dots.

Non-Impact Do not strike paper. Quiet & Inkjet, Laser, Thermal High quality.
Printers Fast.

• Specific Printer Types:

1. Laser Printer: Uses Toner (Dry Powder) and static electricity. Fastest and best quality
for text.

2. Inkjet Printer: Uses Ink Cartridges (Liquid ink - CMYK). Good for photos.

3. Thermal Printer: Uses heat on chemically treated paper. Used in ATMs and Receipt
machines.

4. Plotter: A special printer used for printing large, high-quality vector graphics like
Maps, Architectural Blueprints, and 3D designs.

C. Audio Output
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Speakers / Headphones: Convert Digital signals back to Sound (Analog).

D. Projector

• Projects the output onto a large screen or wall.

3. COMPUTER MEMORY (Storage Hardware)

The PDF puts high focus here.

A. Primary Memory (Main Memory)

• Directly accessible by the CPU.

• 1. RAM (Random Access Memory):

• Volatile: Data is lost when power is turned off.

• Read/Write: You can read and modify data.

• Types:

• SRAM (Static RAM): Faster, uses Flip-Flops, used in Cache Memory.

• DRAM (Dynamic RAM): Slower, uses Capacitors, needs constant refreshing.


Used in main PC RAM.

• 2. ROM (Read Only Memory):

• Non-Volatile: Data is permanent.

• Read Only: Can only be read, not written to easily.

• Function: Stores BIOS (Booting instructions).

• Types: PROM (Programmable), EPROM (Erasable by UV light), EEPROM (Electrically


Erasable).

B. Secondary Memory (Auxiliary Storage)

• Used for permanent storage (Backup).

• Sequential Access: Magnetic Tape (Audio Cassette). Slow.

• Direct Access:

1. Magnetic Disk: HDD (Hard Disk Drive). Contains Platters, Tracks, Sectors.

2. Optical Disk: Uses Laser.

• CD (Compact Disc): ~700 MB capacity.

• DVD (Digital Versatile Disc): ~4.7 GB to 8.5 GB.

• Blu-ray Disc: ~25 GB to 50 GB (Highest optical capacity).

3. Flash Memory (Solid State):

• Pen Drive (USB Flash Drive): Portable, plug-and-play.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• SSD (Solid State Drive): Faster than HDD, no moving parts.

• Memory Card: SD Cards used in cameras/phones.

4. "MISSING LINKS" & EXAM TRAPS

(Points not explicitly detailed in every PDF but critical for JKSSB MCQs)

1. Input AND Output Devices: Some devices do both.

• Modem: Sends and receives data.

• Touchscreen: Displays output and accepts input touch.

• Headset: Has Mic (Input) and Speaker (Output).

• Fax Machine: Scans (Input) and Prints (Output).

2. Cache Memory: Placed between CPU and RAM. It is faster than RAM but smaller. It stores
frequently used data to speed up the CPU.

3. Virtual Memory: A technique where a part of the Hard Disk is used as RAM when the actual
RAM is full.

4. Buffer: A temporary storage area used when moving data between devices with different
speeds (e.g., "Printer Buffer").

5. Resolution of Printer: Measured in DPI (Dots Per Inch).

6. Speed of Printer: Measured in PPM (Pages Per Minute).

Q1. Which of the following is the correct chronological order of the switching devices used in the
five generations of computers?

A) Transistors → Vacuum Tubes → ICs → VLSI B) Vacuum Tubes → Transistors → ICs →


Microprocessors (VLSI) C) Vacuum Tubes → ICs → Transistors → ULSI D) Transistors → ICs → Vacuum
Tubes → VLSI

Answer: B) Vacuum Tubes → Transistors → ICs → Microprocessors (VLSI) Explanation:

• 1st Gen: Vacuum Tubes (Huge, hot).

• 2nd Gen: Transistors (Smaller, faster).

• 3rd Gen: Integrated Circuits (ICs) (Miniaturized).

• 4th Gen: Microprocessors/VLSI (Single chip CPU).

• 5th Gen: ULSI & AI.

Q2. Which input device is primarily used in banks to process a large volume of cheques?
YOUTUBE-JK EXAM MADE EASY | Shivam R.

A) OCR (Optical Character Recognition) B) OMR (Optical Mark Reader) C) MICR (Magnetic Ink
Character Recognition) D) BCR (Bar Code Reader)

Answer: C) MICR (Magnetic Ink Character Recognition) Explanation:

• MICR reads the special magnetic ink code at the bottom of cheques (9-digit code). It is
secure and fast.

• OMR is for checking objective exam sheets.

• BCR is for reading product prices in shops.

• OCR converts scanned images into editable text.

Q3. Which of the following memory types is "Volatile" in nature?

A) ROM B) Hard Disk C) RAM D) Flash Memory

Answer: C) RAM Explanation:

• Volatile means data is lost when power is switched off. RAM (Random Access Memory) is
volatile.

• Non-Volatile means permanent storage. ROM, Hard Disk, and Flash Memory (Pen drives)
retain data even without power.

Q4. In a laser printer, which technology is used to print characters on paper?

A) Striking a ribbon against paper B) Spraying liquid ink droplets C) Using heat on chemically treated
paper D) Using toner powder and static electricity

Answer: D) Using toner powder and static electricity Explanation:

• Laser Printers use dry powder called Toner and a laser beam/static charge. They are Non-
Impact.

• Inkjet Printers spray liquid ink.

• Dot Matrix Printers strike a ribbon (Impact).

• Thermal Printers use heat (Receipts).

Q5. Which part of the Central Processing Unit (CPU) is responsible for decoding instructions and
directing the flow of data, but does not perform calculations itself?

A) ALU (Arithmetic Logic Unit) B) Registers C) CU (Control Unit) D) Cache Memory

Answer: C) CU (Control Unit) Explanation:

• CU is the "Manager" or "Nervous System". It decodes commands and tells other parts what
to do.

• ALU is the "Worker". It does the actual Math (+, -) and Logic (<, >).
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Registers are for storage, not control.

Q6. Which of the following is considered both an Input and an Output device?

A) Joystick B) Plotter C) Touchscreen D) Scanner

Answer: C) Touchscreen Explanation:

• Touchscreen displays visuals (Output) and accepts finger taps (Input).

• Modems and Headsets are also dual-purpose devices.

• Joystick is Input only.

• Plotter is Output only.

Q7. Identify the "Odd One Out" regarding Computer Classification based on working principle:

A) Analog Computer B) Digital Computer C) Hybrid Computer D) Mainframe Computer

Answer: D) Mainframe Computer Explanation:

• Analog, Digital, and Hybrid are classifications based on How they work (Working Principle).

• Mainframe (along with Micro, Mini, Super) is a classification based on Size and Capacity.

Q8. One "Nibble" is equal to how many bits?

A) 8 Bits B) 16 Bits C) 4 Bits D) 32 Bits

Answer: C) 4 Bits Explanation:

• 1 Nibble = 4 Bits (Half a Byte).

• 1 Byte = 8 Bits (Standard unit for a character).

• 1 Word = Depending on CPU (16, 32, or 64 bits).

Q9. The "Param 8000", India's first supercomputer, was developed by which organization?

A) ISRO B) DRDO C) C-DAC D) BARC

Answer: C) C-DAC Explanation:

• C-DAC (Centre for Development of Advanced Computing, Pune) developed PARAM 8000
in 1991.

• The architect behind it was Dr. Vijay Bhatkar.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Q10. Which keys on a keyboard are known as "Toggle Keys"?

A) Ctrl, Alt, Shift B) F1 to F12 C) Caps Lock, Num Lock, Scroll Lock D) Arrow Keys, Home, End

Answer: C) Caps Lock, Num Lock, Scroll Lock Explanation:

• Toggle Keys switch a function ON or OFF. (e.g., Caps Lock ON = Capital letters, OFF = Small
letters).

• Modifier Keys are Ctrl, Alt, Shift (They modify other keys).

• Function Keys are F1-F12.

• Navigation Keys are Arrows, Home, End.

TOPIC: COMPUTER SOFTWARE & LANGUAGES

Definition: Software is a set of instructions, data, or programs used to operate computers and
execute specific tasks. It is the opposite of hardware (intangible).

1. TYPES OF SOFTWARE

The PDF classifies software into two main categories:

A. System Software

• Definition: Software designed to run the computer's hardware and application programs. It
acts as the interface between the Hardware and the User.

• Examples:

1. Operating System (OS): The most important system software (e.g., Windows, Linux,
Android).

2. Device Drivers: Programs that allow the OS to control specific hardware (e.g., Printer
Driver, Audio Driver).

3. Language Translators: Convert programming languages into machine code (see


below).

4. Utility Software: (See section below).

B. Application Software

• Definition: Software designed for the end-user to perform specific tasks.

• Types:
YOUTUBE-JK EXAM MADE EASY | Shivam R.

1. General Purpose: Used for a variety of tasks (e.g., MS Word for typing, VLC for
media, Web Browsers).

2. Specific Purpose: Designed for a specific organization or task (e.g., Tally for
accounting, Reservation System for Railways, Billing System for a shop).

2. UTILITY SOFTWARE (Service Programs)

• Definition: A type of system software designed to help analyze, configure, optimize, or


maintain a computer.

• Key Examples (MCQ Gold):

• Antivirus: Protects from malware (Norton, McAfee).

• Disk Defragmenter: Rearranges files on the hard disk to speed up access.

• Backup Software: Creates copies of data.

• Compression Tools: Reduces file size (WinZip, WinRAR).

• Disk Cleanup: Removes unnecessary/junk files.

3. COMPUTER LANGUAGES

The computer does not understand English; it understands electricity (On/Off). Languages bridge this
gap.

A. Low-Level Languages (LLL)

1. Machine Language (1st Gen):

• Uses Binary Code (0s and 1s).

• Directly understood by the CPU (No translator needed).

• Very fast but difficult for humans to write.

2. Assembly Language (2nd Gen):

• Uses Mnemonics (Short codes like ADD, SUB, MOV).

• Needs a translator (Assembler) to convert to machine code.

B. High-Level Languages (HLL)

• 3rd Gen onwards: Uses English-like words and mathematical symbols.

• Examples: C, C++, Java, Python, COBOL, FORTRAN.

• Portable: Can run on any computer (Machine Independent).

4. LANGUAGE TRANSLATORS
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Programs that convert High-Level/Assembly code into Machine Code (0s and 1s).

Translator Function Key MCQ Point

Assembler Converts Assembly Used for 2nd Gen languages.


Language Machine Language.

Compiler Converts High-Level Scans the Whole Program at once. Lists all errors at the
Language Machine Language. end. Generates an Object file (.exe). Fast execution. (e.g.,
C, C++).

Interpreter Converts High-Level Translates Line-by-Line. Stops at the first error. Slower
Language Machine Language. execution. (e.g., Python, BASIC).

5. OPERATING SYSTEM (OS)

• Role: It is the "Resource Manager". It manages CPU, Memory, Files, and Devices.

• Booting: The process of loading the OS into RAM.

• Cold Boot: Turning on the PC from the "Off" state.

• Warm Boot: Restarting the PC (Ctrl + Alt + Del).

• Types of OS Interfaces:

• CUI / CLI (Character User Interface): User types text commands. (e.g., MS-DOS,
UNIX).

• GUI (Graphical User Interface): User uses Mouse, Icons, Menus.


(e.g., Windows, macOS, Ubuntu).

6. OPEN SOURCE vs. PROPRIETARY SOFTWARE

(Critical for JKSSB MCQs)

Feature Open Source Software (OSS) Proprietary (Closed Source)

Source Available to public (Free to modify). Hidden (Trade Secret).


Code

Cost Usually Free. Paid / Licensed.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Feature Open Source Software (OSS) Proprietary (Closed Source)

Examples Linux, Android, Mozilla Firefox, VLC Player, Windows, macOS, MS Office, Adobe
Python, LibreOffice. Photoshop, iOS.

7. "MISSING LINKS" & EXAM TRAPS

1. Linker vs. Loader:

• Linker: Combines object files (created by compiler) into a single executable file.

• Loader: Loads that executable file into the RAM to run it.

2. Freeware vs. Shareware:

• Freeware: Copyrighted software given for free (e.g., Skype, Chrome). Source code is
NOT available.

• Shareware: Software given on a trial basis (free for limited time, then pay). (e.g.,
WinZip).

3. Firmware: Software permanently programmed into hardware (Read-Only). Example: BIOS.

4. Spooling: (Simultaneous Peripheral Operations On-Line) A process used by printers to store


print jobs in a buffer so the CPU can work on other things.

TOPIC (iv): OPERATING SYSTEM (OS)

Definition: The Operating System is the most important System Software. It acts as
an interface between the User and the Computer Hardware. Without an OS, a computer is just a box
of metal (useless).

Core Functions:

1. Process Management: It decides which process (task) gets the CPU and for how long.

2. Memory Management: It manages RAM; allocates space to programs and frees it up when
closed.

3. File Management: Keeps track of where files are stored (Folders, Directories).

4. Device Management: Controls peripherals (Printers, Mouse) via Drivers.

5. Security: Protects data through passwords and firewalls.

1. TYPES OF OPERATING SYSTEMS

(High probability for "Match the Following" MCQs)


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Type Function Examples

Batch OS Processes similar jobs in "batches" (groups) automatically. No Payroll Systems, Bank
user interaction during processing. Statements (Old).

Time-Sharing The CPU switches between multiple users/tasks so fast that it Unix, Linux, Windows
OS looks simultaneous. (Concept: Quantum time slice). Server.

Real-Time OS Used where time is critical. Processing must happen within a Air Traffic Control,
(RTOS) fixed deadline. Robots, Missile Systems.

Distributed OS Multiple computers work together as a single system. Cloud Computing


systems.

Single User OS Only one user can work at a time. MS-DOS, Windows 95.

Multi-User OS Multiple users can access the system simultaneously. UNIX, Linux, Windows
Server.

2. INTERFACES (CUI vs. GUI)

(Common Exam Question: "Which of these is a CUI based OS?")

1. CUI / CLI (Character User Interface):

• The user interacts by typing text commands.

• No Mouse, No Icons. Hard to use.

• Examples: MS-DOS (Microsoft Disk Operating System), UNIX.

2. GUI (Graphical User Interface):

• The user interacts using visual elements like Icons, Windows, Menus, Pointers
(WIMP).

• Easy to use.

• Examples: Windows, macOS, Ubuntu, Android.

3. POPULAR OPERATING SYSTEMS

A. MS-DOS (Microsoft Disk Operating System)

• Year: 1981.

• Type: CUI (Command Line), Single User, Single Tasking.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Key Files: [Link], [Link], [Link].

B. UNIX

• Year: 1969 (Bell Labs).

• Developers: Ken Thompson and Dennis Ritchie.

• Type: CUI, Multi-User, Multi-Tasking. Written in C Language.

C. LINUX

• Year: 1991.

• Developer: Linus Torvalds.

• Type: Open Source (Free code), Multi-User, Multitasking.

• Mascot: Tux (The Penguin).

• Distributions (Flavors): Ubuntu, Fedora, Red Hat, Debian, Kali, Boss (Indian).

D. WINDOWS

• Developer: Microsoft.

• Key Versions:

• Windows 1.0 (1985): First GUI.

• Windows 95: Introduced the Start Button and Taskbar.

• Windows XP: Most popular/stable version for a long time.

• Windows 10/11: Latest versions.

4. MOBILE OPERATING SYSTEMS

1. Android: Based on Linux. Owned by Google. Versions named after desserts (Cupcake,
Donut... Pie, Queen Cake).

2. iOS: Developed by Apple for iPhone/iPad. Proprietary.

3. Symbian: Used in old Nokia phones.

4. BlackBerry OS: Known for high security.

5. IMPORTANT TERMS & "MCQ GOLD"

1. Kernel: The core of the OS. It loads first into RAM and stays there. It controls hardware
directly.

2. Shell: The outer layer of the OS. It takes commands from the user and passes them to the
Kernel.
YOUTUBE-JK EXAM MADE EASY | Shivam R.

3. Booting: The process of loading the OS from Secondary Storage (Hard Disk) to Primary
Storage (RAM).

• Cold Boot: Switching on the computer.

• Warm Boot: Restarting (Ctrl + Alt + Del).

4. BIOS: Basic Input Output System. Firmware stored in ROM that starts the booting process.

5. POST: Power On Self Test. The first check the computer does to ensure RAM, keyboard, etc.,
are connected.

6. Spooling: (Simultaneous Peripheral Operations On-Line). Putting jobs in a buffer (queue) so


the device can work at its own speed (e.g., Printer Spooling).

7. Virtual Memory: A technique that uses Hard Disk space as if it were RAM to run large
programs.

8. Boss Linux: Bharat Operating System Solutions. An Indian Linux distribution developed by C-
DAC.

Q1. Which of the following is an example of "Open Source" operating system software?

A) Microsoft Windows B) Adobe Photoshop C) Linux D) iOS

Answer: C) Linux Explanation:

• Open Source means the source code is free for the public to view and modify. Linux (and
Android) are the prime examples.

• Windows and iOS are Proprietary (Closed Source).

• Photoshop is Application software, not an OS.

Q2. What is the process of loading the Operating System from the secondary storage to the main
memory (RAM) called?

A) Compilation B) Booting C) Spooling D) Troubleshooting

Answer: B) Booting Explanation:

• Booting is the startup sequence where the OS is loaded.

• Compilation is translating code.

• Spooling is managing print jobs.

Q3. A "Translator" that converts a High-Level Language program into Machine Language line-by-
line and stops execution at the first error is called:
YOUTUBE-JK EXAM MADE EASY | Shivam R.

A) Compiler B) Linker C) Assembler D) Interpreter

Answer: D) Interpreter Explanation:

• Interpreter: Translates line-by-line (e.g., Python). Slower execution.

• Compiler: Translates the whole program at once (e.g., C++). Faster execution.

• Assembler: Translates Assembly Language.

Q4. Which of the following is NOT a function of an Operating System?

A) Memory Management B) Process Management C) Virus Protection (by default) D) Database


Management

Answer: D) Database Management Explanation:

• Database Management is done by DBMS software (like Oracle, SQL), which is Application
Software, not the OS itself.

• Memory, Process, and Device management are core OS functions.

• Note: While modern OSs have built-in security (Defender), "Database Management" is
strictly an application task.

Q5. "BOSS" (Bharat Operating System Solutions) is a Linux-based operating system developed by
which Indian organization?

A) ISRO B) C-DAC C) Infosys D) DRDO

Answer: B) C-DAC Explanation:

• C-DAC (Centre for Development of Advanced Computing) developed BOSS to promote the
use of Free/Open Source software in India.

Q6. Which type of Operating System is used in environments where processing must occur within a
fixed, critical time constraint, such as in Air Traffic Control?

A) Batch Processing OS B) Time-Sharing OS C) Real-Time OS (RTOS) D) Distributed OS

Answer: C) Real-Time OS (RTOS) Explanation:

• RTOS guarantees that a task completes within a strict deadline.

• Batch OS works in groups without user interaction.

• Time-Sharing splits time among users.

Q7. The core part of the Operating System that remains in the memory (RAM) and controls the
hardware directly is known as:

A) Shell B) Kernel C) Register D) Compiler

Answer: B) Kernel Explanation:

• Kernel: The "heart" of the OS. It manages hardware and resources.

• Shell: The "outer layer" that interacts with the user (interface).
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Q8. Which key combination is used to perform a "Warm Boot" (Restart) on a computer?

A) Ctrl + Shift + Esc B) Alt + F4 C) Ctrl + Alt + Del D) Shift + Delete

Answer: C) Ctrl + Alt + Del Explanation:

• Ctrl + Alt + Del allows you to reset/restart the system without turning off the power. This
is Warm Booting.

• Cold Booting is turning the switch On.

Q9. "UNIX" is a multi-user, multi-tasking operating system developed in 1969 by:

A) Bill Gates and Paul Allen B) Ken Thompson and Dennis Ritchie C) Steve Jobs D) Linus Torvalds

Answer: B) Ken Thompson and Dennis Ritchie Explanation:

• Developed at AT&T Bell Labs. Written in C Language.

• Linus Torvalds developed Linux.

• Bill Gates is associated with MS-DOS/Windows.

Q10. In the context of computer files, what is the full form of "PDF"?

A) Portable Document Format B) Public Document File C) Printable Data Format D) Personal Digital
File

Answer: A) Portable Document Format Explanation:

• PDF (developed by Adobe) allows documents to be presented regardless of the software or


hardware used.

TOPIC (v): MICROSOFT WORD (Word Processing)

Definition: MS Word is a Word Processing Software (Application Software) used to create, edit,
format, and print text documents.

1. BASIC FACTS (Direct One-Liners)

• Executable File Name: [Link] (Type this in Run command to open Word).

• Default File Name: Document1.

• File Extension:

• Old (before 2007): .doc

• New (2007 onwards): .docx (XML format).

• Template: .dotx

• Default Font: Calibri (Size 11) [In older versions like 2003, it was Times New Roman, Size 12].

• Zoom Range:

• Minimum: 10%
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Maximum: 500% (Note: In Excel/PPT, max is 400%, but in Word, it is 500%).

• Default View: Print Layout View.

2. IMPORTANT INTERFACE ELEMENTS

• Title Bar: Topmost bar displaying the file name.

• Ribbon: The panel containing tabs (Home, Insert, Page Layout, etc.).

• Status Bar: Bottom bar showing Page Number, Word Count, Language, Zoom.

• Ruler: Used to set Margins and Indents.

• Gutter Margin: A special margin added to the binding side of the page (Left or Top) to ensure
text isn't hidden after binding.

• Orientation:

• Portrait: Vertical (Default).

• Landscape: Horizontal.

3. KEY FEATURES (Exam Favorites)

1. Mail Merge: A feature to create multiple documents (letters/labels) at once by merging a


main document with a data source (address list). Used for Bulk Emails.

2. Macro: A tool to record a series of commands/actions to automate repetitive tasks.


Shortcut: Alt + F8.

3. Drop Cap: A large capital letter at the beginning of a paragraph (like in newspapers).

• Default drop lines: 3.

• Maximum drop lines: 10.

4. Thesaurus: A built-in dictionary to find Synonyms (same meaning) and Antonyms.


Shortcut: Shift + F7.

5. Watermark: Faint text/image behind the content (e.g., "CONFIDENTIAL"). Found


in Design/Page Layout tab.

6. Header & Footer: Text repeated at the top/bottom of every page.

7. Footnote vs. Endnote:

• Footnote: Note at the bottom of the current page.

• Endnote: Note at the end of the document.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

8. Change Case (Shift + F3): Switches between Sentence case, lowercase, UPPERCASE,
Capitalize Each Word, and tOGGLE cASE.

4. SHORTCUT KEYS (Memorize These!)

Most questions come from here.

The "Ctrl" Series:

• Ctrl + N: New Document.

• Ctrl + O: Open Document.

• Ctrl + S: Save.

• Ctrl + P: Print.

• Ctrl + A: Select All.

• Ctrl + B: Bold.

• Ctrl + I: Italic.

• Ctrl + U: Underline.

• Ctrl + C: Copy.

• Ctrl + X: Cut.

• Ctrl + V: Paste.

• Ctrl + Z: Undo.

• Ctrl + Y: Redo.

• Ctrl + F: Find.

• Ctrl + H: Replace.

• Ctrl + G: Go To.

• Ctrl + K: Insert Hyperlink (Web link).

• Ctrl + E: Center Alignment (Important!).

• Ctrl + L: Left Alignment.

• Ctrl + R: Right Alignment.

• Ctrl + J: Justify Alignment (Aligns text to both left and right margins).

• Ctrl + W: Close the current document (but not the application).

• Ctrl + D: Open Font Dialog Box.

• Ctrl + Enter: Page Break (Start new page).

Formatting Shortcuts:
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Ctrl + [ or Ctrl + Shift + <: Decrease Font Size.

• Ctrl + ] or Ctrl + Shift + >: Increase Font Size.

• Ctrl + =: Subscript ().

• Ctrl + Shift + +: Superscript ().

• Ctrl + 1: Single Line Spacing.

• Ctrl + 2: Double Line Spacing.

• Ctrl + 5: 1.5 Line Spacing.

Function Keys in Word:

• F1: Help.

• F7: Spelling and Grammar Check (Very Important).

• F12: Save As.

• Shift + F3: Change Case.

• Shift + F7: Thesaurus.

5. EXAM TRAPS (Don't Get Confused)

1. Ctrl + C is NOT Center: Ctrl + C is Copy. Ctrl + E is Center.

2. Zoom Limit: Word max zoom is 500%. Excel/PPT is only 400%.

3. Subscript vs Superscript:

• Sub = Below (). Shortcut uses =

• Super = Above (). Shortcut uses + (Think "Plus" means Add/High).

4. Save vs Save As:

• Save (Ctrl+S): Updates the current file.

• Save As (F12): Saves the file with a new name or format.

TOPIC (v): MICROSOFT EXCEL (Spreadsheet)

Definition: MS Excel is a Spreadsheet Software used for organizing data, calculations, data analysis,
and creating charts.

1. BASIC FACTS (Direct One-Liners)

• Executable File Name: [Link].

• Default File Name: Book1.

• File Extension:
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Old (before 2007): .xls

• New (2007 onwards): .xlsx

• Macro-Enabled: .xlsm

• Zoom Range:

• Minimum: 10%

• Maximum: 400% (Note the difference: Word is 500%).

• Default Number of Sheets:

• Old versions (2013 & prior): 3 Sheets (Sheet1, Sheet2, Sheet3).

• New versions (2016 onwards): 1 Sheet.

2. STRUCTURE & LIMITS (Memorize for MCQs)

Excel is a grid of Rows (Horizontal) and Columns (Vertical).

• Row Numbers: 1, 2, 3...

• Column Names: A, B, C... Z, AA, AB...

• Total Rows (in modern Excel): 1,048,576 ().

• Total Columns (in modern Excel): 16,384 ().

• Last Column Name: XFD.

• Cell: Intersection of a Row and Column (The small rectangular box).

• Cell Address: Column Letter + Row Number (e.g., A1, D5, Z99).

• Active Cell: The selected cell with a thick green border where you are currently typing. Its
address is shown in the Name Box.

3. IMPORTANT TERMINOLOGY

1. Workbook vs. Worksheet:

• Workbook: The entire Excel file (Like a Notebook).

• Worksheet: A single page within the workbook (Like a page in the notebook).

2. Formula Bar: The bar at the top that shows the content or formula of the active cell.

3. Range: A group of cells (e.g., A1:B10).

4. Charts: Visual representation of data.

• F11: Shortcut to create a Chart instantly.

• Types: Column, Bar, Pie, Line, Scatter.

4. FORMULAS & FUNCTIONS (The Technical Part)

• Golden Rule: Every formula in Excel MUST start with an = sign.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Common Functions:

• =SUM(A1:A5): Adds values in cells A1 to A5.

• =AVERAGE(A1:A10): Calculates the mean.

• =COUNT(A1:A10): Counts cells containing Numbers only.

• =COUNTA(A1:A10): Counts cells containing Any data (Text or Numbers).

• =MAX(Range) / =MIN(Range): Finds highest/lowest value.

• =NOW(): Returns current Date and Time.

• =TODAY(): Returns current Date only.

• =LEN(Text): Returns the length (number of characters) in a text string.

• =CONCATENATE(Text1, Text2): Joins two texts together.

Error Codes (Match the Following):

• #####: Column is too narrow to display the number.

• #DIV/0!: Trying to divide a number by zero.

• #VALUE!: Wrong type of argument (e.g., adding Text to a Number).

• #NAME?: Excel doesn't recognize the text in formula (typo in function name).

5. EXCEL SPECIFIC SHORTCUTS

• Ctrl + ; (Semicolon): Insert Current Date.

• Ctrl + Shift + ; (Colon): Insert Current Time.

• F2: Edit the active cell.

• F11: Create a Chart.

• Shift + F11: Insert a New Worksheet.

• Ctrl + 9: Hide Rows.

• Ctrl + 0: Hide Columns.

• Ctrl + Space: Select entire Column.

• Shift + Space: Select entire Row.

• Ctrl + Page Down: Move to Next Sheet.

• Ctrl + Page Up: Move to Previous Sheet.

6. EXAM TRAPS

1. Count vs CountA: COUNT ignores text. COUNTA counts everything except empty cells.

2. Home Key Behavior:

• In Word: Moves cursor to start of line.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• In Excel: Moves selection to the beginning of the row (Column A).

3. Ctrl + A:

• Press once: Selects the data region (current table).

• Press twice: Selects the entire sheet.

Q1. In Microsoft Excel, every formula must begin with which symbol?

A) + (Plus) B) # (Hash) C) = (Equal) D) @ (At)

Answer: C) = (Equal) Explanation:

• Excel treats cell content as text or numbers unless it starts with an equal sign (=).

• Example: SUM(A1:A5) is just text, but =SUM(A1:A5) performs the calculation.

Q2. What is the shortcut key to "Center Align" the selected text in MS Word?

A) Ctrl + C B) Ctrl + E C) Ctrl + J D) Ctrl + M

Answer: B) Ctrl + E Explanation:

• Ctrl + E: Center Alignment.

• Ctrl + C: Copy. (This is the most common trap!).

• Ctrl + J: Justify Alignment.

• Ctrl + L / R: Left / Right Alignment.

Q3. In MS Excel, the intersection of a Row and a Column is called a:

A) Box B) Grid C) Cell D) Range

Answer: C) Cell Explanation:

• A Cell is the basic unit of a worksheet where data is entered.

• Each cell has a unique address (e.g., A5, where A is the column and 5 is the row).

Q4. Which function key is used to run a "Spelling and Grammar" check in MS Word?

A) F5 B) F7 C) Shift + F7 D) Alt + F7

Answer: B) F7 Explanation:

• F7: Spelling and Grammar check.

• Shift + F7: Opens the Thesaurus (Synonyms/Antonyms).

• F5: Opens the "Go To" dialog box (or Slideshow in PPT).
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Q5. Which shortcut key is used to insert the "Current Date" in an Excel cell?

A) Ctrl + D B) Ctrl + Shift + ; (Colon) C) Ctrl + ; (Semicolon) D) Alt + Shift + D

Answer: C) Ctrl + ; (Semicolon) Explanation:

• Ctrl + ; inserts the Current Date.

• Ctrl + Shift + ; inserts the Current Time.

• Ctrl + D: Fills content from the cell above (Fill Down).

Q6. In MS Word, "Portrait" and "Landscape" are examples of:

A) Page Size B) Page Orientation C) Page Margins D) Page Layout

Answer: B) Page Orientation Explanation:

• Orientation determines the direction of the page.

• Portrait: Vertical (Tall).

• Landscape: Horizontal (Wide).

Q7. Which Excel function returns the current Date AND Time?

A) =DATE() B) =TODAY() C) =NOW() D) =TIME()

Answer: C) =NOW() Explanation:

• =NOW(): Returns both Date and Time.

• =TODAY(): Returns only the current Date.

• =DATE(): Creates a valid date from year, month, day numbers.

Q8. To select an entire "Row" in an Excel sheet, which shortcut combination is used?

A) Ctrl + Space B) Shift + Space C) Ctrl + Shift + Space D) Alt + Space

Answer: B) Shift + Space Explanation:

• Shift + Space: Selects the entire Row.

• Ctrl + Space: Selects the entire Column. (Easy way to remember: Ctrl starts with C,
so Column).

Q9. In MS Word, what is the shortcut key to insert a "Hyperlink"?

A) Ctrl + H B) Ctrl + K C) Ctrl + L D) Ctrl + M


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Answer: B) Ctrl + K Explanation:

• Ctrl + K: Insert HyperlinK.

• Ctrl + H: Find and Replace (Hide/Seek concept).

• Ctrl + L: Left Align.

Q10. If a column in Excel is too narrow to display the number inside it, which error code is
displayed?

A) #NAME? B) #DIV/0! C) ##### D) #VALUE!

Answer: C) ##### Explanation:

• ##### appears when the column width is insufficient for the number.

• #DIV/0! appears when dividing by zero.

• #NAME? appears when a formula name is misspelled.

TOPIC (v) Part 3: MS POWERPOINT (Presentation)

Definition: MS PowerPoint is a Presentation Software used to create visual slideshows containing


text, images, charts, and multimedia.

1. BASIC FACTS (Direct One-Liners)

• Executable File Name: [Link].

• Default File Name: Presentation1.

• File Extension:

• Old (before 2007): .ppt

• New (2007 onwards): .pptx

• Slideshow Format: .ppsx (Opens directly in full screen).

• Zoom Range:

• Minimum: 10%
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Maximum: 400% (Same as Excel, unlike Word's 500%).

• Default View: Normal View.

2. KEY TERMS & VIEWS

1. Slide: An individual page in a presentation.

2. Slide Sorter View: Displays all slides as thumbnails (small images). Best used
for rearranging slides.

3. Slide Master: The "Blueprint" slide. Changes made here (like logo or font) apply to ALL slides
automatically.

4. Notes Page: A view where you can add speaker notes (hidden from the audience) below the
slide.

5. Reading View: Plays the slide show in a window (not full screen).

3. TRANSITION vs. ANIMATION (Most Confused Topic)

• Transition: Effect applied to the SLIDE itself when moving from one slide to the next (e.g.,
Fade, Push, Wipe).

• Animation: Effect applied to OBJECTS INSIDE the slide (e.g., Making text fly in, making an
image bounce).

4. POWERPOINT SHORTCUTS

• F5: Start Slideshow from the Beginning.

• Shift + F5: Start Slideshow from the Current Slide.

• Esc: Stop/End the Slideshow.

• Ctrl + M: Insert a New Slide (Note: Ctrl + N creates a New Presentation file).

• Ctrl + D: Duplicate the selected slide.

TOPIC (v) Part 4: MS ACCESS (Database)

Definition: MS Access is a Database Management System (DBMS) used to store and manage large
amounts of data in a structured way.

1. BASIC FACTS

• Executable File Name: [Link].

• File Extension:

• Old: .mdb (Microsoft Database).

• New: .accdb (Access Database).

• Type: It is an RDBMS (Relational Database Management System) because it stores data in


related tables.
YOUTUBE-JK EXAM MADE EASY | Shivam R.

2. FOUR MAIN OBJECTS OF ACCESS

1. Tables: The place where raw data is stored in Rows (Records) and Columns (Fields).

2. Queries: Used to retrieve specific data from tables based on criteria (e.g., "Show all students
with >90 marks").

3. Forms: A user-friendly interface to enter or display data.

4. Reports: Used to print or summarize data in a professional format.

3. KEY TERMINOLOGY

• Primary Key: A unique field that cannot be empty (Null) and cannot have duplicates (e.g.,
Aadhar Number, Roll Number). It identifies every record uniquely.

• Record: A single Row in a table (contains data about one person).

• Field: A single Column in a table (contains one type of data, e.g., Name).

EXAM TRAPS (PPT & ACCESS)

1. New Slide Shortcut: It is Ctrl + M, not Ctrl + N.

2. Starting Slideshow: Don't confuse F5 (Start from 1st) with Shift+F5 (Start from Current).

3. Access Data Storage: Data is stored ONLY in Tables. Queries, Forms, and Reports do not
store data; they just display it.

Q1. Which shortcut key is used to insert a "New Slide" in an existing PowerPoint presentation?

A) Ctrl + N B) Ctrl + S C) Ctrl + M D) Alt + N

Answer: C) Ctrl + M Explanation:

• Ctrl + M: Inserts a new Slide inside the current file.

• Ctrl + N: Creates a completely New Presentation file.

• Ctrl + S: Save.

Q2. In MS Access, a "Primary Key" is used to:

A) Unlock the database B) Uniquely identify each record in a table C) Link two databases together D)
Create a backup of the table

Answer: B) Uniquely identify each record in a table Explanation:

• A Primary Key ensures that every row (Record) is unique.

• It cannot be left blank (Null) and cannot have duplicate values (e.g., Aadhar Number or Roll
No).
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Q3. Which PowerPoint view displays all slides as small "thumbnails" and is best used for
rearranging the order of slides?

A) Normal View B) Slide Master C) Reading View D) Slide Sorter View

Answer: D) Slide Sorter View Explanation:

• Slide Sorter shows all slides on one screen, making it easy to drag and drop them to change
the sequence.

• Slide Master is used for changing the design/layout of all slides at once.

Q4. What is the file extension for a database created in the modern versions of MS Access (2007
onwards)?

A) .mdb B) .accdb C) .dbms D) .sql

Answer: B) .accdb Explanation:

• .accdb: Access Database (New format).

• .mdb: Microsoft Database (Old format, pre-2007).

• .pptx: PowerPoint.

• .xlsx: Excel.

Q5. In PowerPoint, what is the difference between "Transition" and "Animation"?

A) Transition is for text; Animation is for images. B) Transition applies to the Slide; Animation applies
to Objects inside the Slide. C) Transition is automatic; Animation is manual. D) There is no difference.

Answer: B) Transition applies to the Slide; Animation applies to Objects inside the
Slide. Explanation:

• Transition: The effect seen when moving from Slide 1 to Slide 2 (e.g., Wipe, Push).

• Animation: The effect on specific text or images (e.g., Fly In, Bounce).

Q6. To start a PowerPoint Slideshow from the "Current Slide" (not the beginning), which key
combination is used?

A) F5 B) Shift + F5 C) Ctrl + F5 D) Alt + F5

Answer: B) Shift + F5 Explanation:

• Shift + F5: Starts from the Current Slide.

• F5: Starts from the Beginning (Slide 1).

• Esc: Stops the slideshow.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Q7. Which object in MS Access is specifically designed to "Print" or summarize data in a


professional layout?

A) Form B) Query C) Report D) Table

Answer: C) Report Explanation:

• Reports are for output/printing (summarized view).

• Forms are for input/interface.

• Queries are for retrieving/filtering data.

• Tables are for storing data.

Q8. In a Database Table, a "Column" is technically referred to as a:

A) Record B) Tuple C) Field D) File

Answer: C) Field Explanation:

• Field: A Column (stores one type of data, e.g., "Phone Number").

• Record: A Row (stores data about one entity, e.g., "Student details").

• Tuple: Another name for a Row/Record in RDBMS theory.

Q9. The "Slide Master" in PowerPoint is used to:

A) View the slideshow B) Make changes to the default layout and formatting of all slides C) Check
spelling errors D) Add animation to text

Answer: B) Make changes to the default layout and formatting of all slides Explanation:

• Changes made in the Slide Master (like adding a logo or changing the font style) are
automatically applied to every slide in the presentation.

Q10. MS Access is an example of which type of software?

A) Word Processor B) RDBMS (Relational Database Management System) C) Presentation Software D)


Operating System

Answer: B) RDBMS Explanation:

• It stores data in Tables which are "Related" to each other, hence Relational DBMS.

TOPIC (vi): INTERNET & E-MAIL

Definition:
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• Internet: A global network of interconnected computers (Network of Networks).

• Owner: No one owns the Internet. It is decentralized.

• Vint Cerf: Known as the Father of the Internet.

1. HISTORY & EVOLUTION

1. ARPANET (1969): The first network, developed by the US Defense Department.

2. TCP/IP (1983): Standard protocols adopted, creating the modern Internet.

3. WWW (1989): World Wide Web invented by Tim Berners-Lee at CERN.

4. Mosaic (1993): The first graphical web browser (displayed images).

5. Internet in India (1995): Launched by VSNL (Videsh Sanchar Nigam Ltd) on August 15.

2. KEY TERMINOLOGY (Exam Favorites)

1. URL (Uniform Resource Locator): The address of a website (e.g., [Link]).

2. Domain Name: The text name of a website (e.g., [Link]).

• .com = Commercial.

• .org = Organization.

• .gov = Government.

• .edu = Education.

• .in = India (Country Code).

3. IP Address (Internet Protocol): A unique number assigned to every device on the internet.

• IPv4: 32-bit address (e.g., [Link]).

• IPv6: 128-bit address (Alphanumeric).

4. DNS (Domain Name System): The "Phonebook" of the internet. It translates Domain
Names (human-readable) into IP Addresses (machine-readable).

5. Cookie: A small text file stored in your browser by websites to remember your
preferences/login.

6. Cache: Stores temporary copies of web pages to load them faster next time.

3. PROTOCOLS (The "Rules")

• TCP/IP: Transmission Control Protocol / Internet Protocol (The base language of the
internet).

• HTTP: HyperText Transfer Protocol (Rules for transferring web pages).


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• HTTPS: HTTP Secure (Encrypted version; uses SSL).

• FTP: File Transfer Protocol (Used for uploading/downloading files).

• SMTP: Simple Mail Transfer Protocol (Used for SENDING emails).

• POP3: Post Office Protocol (Used for RECEIVING emails; downloads to device).

• IMAP: Internet Message Access Protocol (Used for RECEIVING emails; keeps mail on
server/syncs).

• VoIP: Voice over Internet Protocol (Making calls over internet, e.g., WhatsApp calls).

4. E-MAIL (Electronic Mail)

• Inventor: Ray Tomlinson (1971). He introduced the @ symbol.

• First Free Email Service: Hotmail (founded by Sabeer Bhatia, Indian).

• Structure of Email Address: username@domainname (e.g., student@[Link]).

• CC (Carbon Copy): Sends a copy to others; everyone can see who else got the mail.

• BCC (Blind Carbon Copy): Sends a copy, but recipients cannot see who else got it (Hidden).

• Spam: Unsolicited/Junk emails.

• Trash/Bin: Stores deleted emails (usually for 30 days).

5. NETWORK DEVICES & TYPES

Types of Networks (Range):

1. PAN (Personal Area Network): Very short range (Bluetooth, Hotspot).

2. LAN (Local Area Network): Within a building/office (Ethernet, WiFi).

3. MAN (Metropolitan Area Network): Covers a city (Cable TV network).

4. WAN (Wide Area Network): Covers countries/continents (The Internet).

Hardware:

• Modem: Modulator-Demodulator. Converts Digital signals (PC) to Analog (Phone line) and
vice versa.

• Router: Directs traffic (packets) between networks (connects you to the internet).

• Switch: Connects devices within a LAN (Intelligent).

• Hub: Connects devices within a LAN (Dumb; sends data to everyone).

• Gateway: Connects two networks with different protocols.

6. MALWARE & SECURITY (Internet Threats)


YOUTUBE-JK EXAM MADE EASY | Shivam R.

1. Virus: Attaches to files, spreads when executed.

2. Worm: Spreads automatically across networks (no host needed).

3. Trojan Horse: Hidden malware inside useful software.

4. Phishing: Fake emails/websites designed to steal passwords/credit card info.

5. Spoofing: Faking an identity (Caller ID spoofing).

6. Firewall: Security system (Hardware/Software) that blocks unauthorized access.

10 MCQs on Internet & Email

Q1. Which protocol is primarily used for SENDING emails? A) POP3 B) SMTP C) FTP D) HTTP

Answer: B) SMTP (Simple Mail Transfer Protocol).

Q2. Who is known as the "Father of Email"? A) Tim Berners-Lee B) Vint Cerf C) Ray Tomlinson D)
Charles Babbage

Answer: C) Ray Tomlinson.

Q3. In an email, what does "BCC" stand for? A) Best Carbon Copy B) Blind Carbon Copy C) Basic
Carbon Copy D) Backup Carbon Copy

Answer: B) Blind Carbon Copy.

Q4. The standard protocol of the Internet is: A) TCP/IP B) HTML C) Java D) Flash

Answer: A) TCP/IP.

Q5. "Junk Email" is also known as: A) Spoof B) Spam C) Sniffer Script D) Spool

Answer: B) Spam.

Q6. Which device is required to connect a computer to a telephone line for internet access? A)
Switch B) Router C) Modem D) Hub

Answer: C) Modem (Converts Analog/Digital).

Q7. What is the full form of URL? A) Uniform Resource Locator B) Uniform Resource Link C) Unified
Registered Link D) Uniform Registered Locator

Answer: A) Uniform Resource Locator.

Q8. Which network covers the largest geographical area? A) LAN B) MAN C) PAN D) WAN

Answer: D) WAN (Wide Area Network).

Q9. Which of the following is NOT a web browser? A) Chrome B) Firefox C) Google D) Safari

Answer: C) Google (It is a Search Engine; Chrome is the browser).

Q10. "Phishing" is an example of: A) Identity Theft B) Virus C) Antivirus D) Hardware

Answer: A) Identity Theft (Stealing credentials).


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Revision Sheet: Computer Knowledge (JKSSB/SSC)

1. Confusing Pairs & Exam Traps

• Ctrl + C vs. Ctrl + E

• Ctrl + C: Copy text.

• Ctrl + E: Center Align text (Word).

• Save vs. Save As

• Ctrl + S: Save (Updates current file).

• F12: Save As (Saves with a new name).

• New Slide vs. New File

• Ctrl + M: New Slide (PowerPoint).

• Ctrl + N: New File (Word/Excel/PPT).

• Slideshow Keys

• F5: Start from Beginning.

• Shift + F5: Start from Current Slide.

• Home Key

• Word: Moves to start of the Line.

• Excel: Moves to start of the Row (Column A).

• Ctrl + Home: Moves to the very beginning of the doc/sheet.

2. Memory Units (Memorize Hierarchy)

• Bit (0 or 1) < Nibble (4 bits) < Byte (8 bits) < KB (1024 Bytes).

• Highest Unit: Geopbyte (followed by Brontobyte). Standard high is Yottabyte.

• Fastest Memory: Registers > Cache > RAM > SSD > HDD.

• Volatile (Lost on power off): RAM, Cache, Registers.

• Non-Volatile (Permanent): ROM, HDD, SSD, Flash Drive, DVD.

3. Internet Protocols (Match the Following)

• SMTP: Sending Email (Sending Mail).

• POP3: Receiving Email (Downloads to device, deletes from server usually).

• IMAP: Receiving Email (Syncs across devices, stays on server).

• HTTP: Transferring Webpages.

• FTP: Transferring Files (Upload/Download).


YOUTUBE-JK EXAM MADE EASY | Shivam R.

• VoIP: Voice Calls over Internet.

4. Shortcut Keys (The "F" Keys)

• F1: Help.

• F2: Rename (Files) / Edit Cell (Excel).

• F4: Repeat Last Action / Alt+F4 to Close.

• F5: Refresh (Desktop) / Go To (Word) / Slideshow (PPT).

• F7: Spelling Check (Word).

• F11: Create Chart (Excel).

• F12: Save As.

5. Important Fathers & Inventors

• Computer: Charles Babbage.

• Modern Computer: Alan Turing.

• Internet: Vint Cerf.

• WWW: Tim Berners-Lee.

• Email: Ray Tomlinson.

• Mouse: Douglas Engelbart.

• Supercomputer (World): Seymour Cray.

• Supercomputer (India): Vijay Bhatkar (PARAM 8000).

6. Excel Formulas & Errors

• Formula Start: Always with =

• Current Date: Ctrl + ;

• Current Time: Ctrl + Shift + ;

• #####: Column too narrow.

• #DIV/0!: Divide by Zero error.

7. Hardware Identification

• Input Only: Keyboard, Mouse, Scanner, MICR, OMR, Joystick.

• Output Only: Monitor, Printer, Speaker, Plotter, Projector.

• Both Input & Output: Modem, Touchscreen, Headset, Fax.

8. Extensions (Quick Look)

• .docx: Word

• .xlsx: Excel
YOUTUBE-JK EXAM MADE EASY | Shivam R.

• .pptx: PowerPoint

• .accdb: Access

• .exe: Executable Program

• .zip: Compressed File

• .jpg: Image

1. HISTORY & INVENTORS (Specific Dates & Names)

Crucial for chronological arrangement questions.

Invention Year Inventor / Origin Key Fact / Exam Point

Abacus 1602 China First mechanical calculating device.

Napier's Bones 1617 John Napier (Scotland) Used for multiplication; introduced
"Rabdologia".

Pascaline 1642 Blaise Pascal (France) First mechanical adding machine.

Jacquard's Loom 1801 Joseph Jacquard First use of punched cards for programming.
(France)

Analytical Engine 1837 Charles Babbage First general-purpose computer.


(London)

Tabulating 1890 Herman Hollerith (USA) First electromechanical machine; used


Machine for Census.

MARK-1 1944 Howard Aiken (USA) Electromechanical; used in World War II.

ENIAC 1946 Eckert & Mauchly (USA) First Electronic Digital Computer.

EDSAC 1949 John Von Neumann First computer with Memory/Storage capacity.

UNIVAC 1951 Eckert & Mauchly First General-Purpose Electronic computer.

IBM-650 1953 IBM Company Used in payroll, oil design, and market research.

2. CPU REGISTERS (Deep Dive)


YOUTUBE-JK EXAM MADE EASY | Shivam R.

The PDF provides a specific table for Registers often asked in "Statement" type questions.

Register Name Abbr. Function (From PDF)

Memory Address MAR Holds the address of the active memory location.
Register

Memory Buffer Register MBR Holds the contents (data) of the accessed memory word
(read/written).

Program Control PC Holds the address of the next instruction to be executed.

Accumulator A Holds data to be operated upon, intermediate results, and final results.

Instruction Register I Holds the instruction while it is being executed.

3. PROGRAMMING LANGUAGES & CREATORS

Match the Language to the Inventor.

Language Full Form Inventor / Developer

FORTRAN Formula Translation IBM.

ALGOL Algorithmic Language European Scientists.

LISP List Processing John McCarthy.

COBOL Common Business Oriented Lang. Grace Hopper.

PROLOG Programming Logic Alain Colmerauer (Used for AI).

BASIC Beginner's All-Purpose Symbolic Instruction Code Kemeny.

PASCAL (Named after Blaise Pascal) Niklaus Wirth.

C - Dennis Ritchie.
YOUTUBE-JK EXAM MADE EASY | Shivam R.

Language Full Form Inventor / Developer

C++ - Bjarne Stroustrup.

4. VIRUS HISTORY TIMELINE

The PDF has a specific timeline table for Viruses.

Year Virus Name Key Detail

1971 Creeper First Virus (by Bob Thomas).

1982 Elk Cloner First for Apple II Systems (by Richard Skrenta).

1986 Brain First PC Boot Sector Virus (by Amjad Farooq Alvi, Pakistan).

1988 Morris Worm First Internet Worm.

1999 Melissa Macro Virus.

2000 I Love You Email Worm.

2001 Code Red Attacked Web Servers.

2003 Slammer / Blaster SQL Slammer.

2010 Stuxnet Targeted Industrial Systems.

5. OSI MODEL (7 Layers)

The PDF lists these layers which must be memorized in order (Bottom to Top).

Layer No. Layer Name Example Protocols

7 Application HTTP, FTP, DNS, SNMP, Telnet.

6 Presentation SSL, TLS.


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Layer No. Layer Name Example Protocols

5 Session NetBIOS, PPTP.

4 Transport TCP, UDP.

3 Network IP, ARP, ICMP, IPSec.

2 Data Link PPP, ATM, Ethernet.

1 Physical Ethernet cables, USB, Bluetooth, IEEE802.11.

6. DATA TRANSMISSION MODES

Specific definitions from the PDF.

Mode Definition Example

Simplex Unidirectional flow. One transmits, other only receives. Radio, Television, Keyboard.

Half Duplex Bidirectional, but not at same time. Walkie Talkie.

Full Duplex Bidirectional simultaneously. Mobile Phones.

7. BACKUP TYPES

Important for questions about "Storage efficiency".

Type Definition

Full Backup Creates copies of ALL data selected.

Incremental Backs up ONLY files changed since the last backup (any type). Fastest.

Differential Backs up ONLY files changed since the last FULL backup. Slower than Incremental.

8. MS OFFICE VERSION HISTORY


YOUTUBE-JK EXAM MADE EASY | Shivam R.

Rare but possible MCQs on features.

• Office 97 (1997): Introduced Clippy (Office Assistant).

• Office 2003 (2003): Introduced XML formats.

• Office 2007 (2007): Introduced the Ribbon Interface and .docx formats.

• Office 2010 (2010): Introduced Backstage View.

• Office 2013 (2013): Touchscreen support.

• Office 2016 (2015): Real-time co-authoring.

9. EXTRA PDF "GEMS" (Unique Points)

• Concept Keyboard: Used in Restaurants (Food).

• El Capitan (USA): Listed as the Current Fastest Supercomputer (2025).

• Siddhartha: Listed as the First Computer of India (Developed by TIFR, 1955). (Note: Often
books say HEC-2M, but this PDF explicitly says Siddhartha).

• [Link]: A specific .NET library mentioned for Word processing developers. (Likely a PDF
copy-paste artifact, but good to know if a weird question appears).

• Incognito Mode: Also called "Private Browsing".

• Access Keys: F2 to edit cell, Ctrl+0 to hide columns, Ctrl+9 to hide rows.

You might also like