हिंदी
PrepZen Daily Current Affairs & Exam Desk

Computer Awareness

32 chapters

Computer fundamentals, MS Office, internet & networking, databases and more — for IBPS, SBI, SSC and RRB exams.

Computer notes

01 Computer Fundamentals A computer is an electronic machine that accepts data (input), processes it according to a set of instructions (program), stores it, and produces usef…

What is a Computer?

A computer is an electronic machine that accepts data (input), processes it according to a set of instructions (program), stores it, and produces useful results (output).

The word "computer" comes from the Latin word "computare", which means "to calculate".

REMEMBER: Charles Babbage is called the "Father of the Computer". He designed the Difference Engine and the Analytical Engine.

The IPO Cycle

Every computer works on the IPO cycle — Input → Process → Output — with Storage supporting every step.

StageWhat happensExample
InputData and instructions enter the computerTyping on a keyboard
ProcessThe CPU works on the dataAdding two numbers
OutputThe result is shown or printedAnswer on the monitor
StorageData is saved for later useSaving a file on SSD

Data vs Information

- Data: raw facts and figures with no meaning on their own (e.g. 45, 67, 89)

- Information: processed, organised data that is meaningful (e.g. "Average marks = 67")

- GIGO: Garbage In, Garbage Out — wrong input always gives wrong output

Characteristics of a Computer

- Speed: performs millions of instructions per second; speed is measured in MIPS, FLOPS or clock speed (GHz)

- Accuracy: results are accurate if input and program are correct

- Diligence: works for hours without tiredness or loss of concentration

- Versatility: can do many different types of work

- Storage: can store huge amounts of data permanently

- No IQ: a computer cannot think on its own; it only follows instructions

- No feelings: it cannot take decisions based on emotions

Block Diagram of a Computer

The basic parts of a computer are the Input Unit, the Central Processing Unit (CPU), the Memory Unit and the Output Unit.

- Input Unit: keyboard, mouse, scanner

- CPU: ALU (Arithmetic Logic Unit) + CU (Control Unit) + Registers

- Memory Unit: primary memory (RAM, ROM) and secondary storage (HDD, SSD)

- Output Unit: monitor, printer, speaker

Types of Computers by Working Principle

TypeWorks onExample
AnalogContinuous physical quantities (temperature, pressure, voltage)Speedometer, thermometer, seismograph
DigitalDiscrete values — binary 0 and 1Laptop, desktop, calculator
HybridBoth analog and digitalICU patient-monitoring machines, petrol pump machines

Types of Computers by Size and Power

TypeKey factsExamples
SupercomputerFastest and most powerful; speed measured in FLOPS; used for weather forecasting, research, nuclear simulationPARAM (India), Frontier, Fugaku
MainframeLarge; supports thousands of users at once; used by banks, railways, airlinesIBM zSeries
MinicomputerMedium size; multi-user; used by small organisationsPDP-11
MicrocomputerPersonal computer with a microprocessor; single userDesktop, laptop, tablet, smartphone

TIP: PARAM 8000 (1991) was India's first supercomputer, developed by C-DAC, Pune. Vijay Bhatkar is called the father of Indian supercomputers.

Types of Computers by Purpose

- General purpose: can do many kinds of tasks (PCs, laptops)

- Special purpose: designed for one task (ATM machine, traffic-light controller, washing-machine controller)

Hardware, Software, Firmware, Liveware

- Hardware: physical parts you can touch — keyboard, CPU, monitor

- Software: programs that tell the hardware what to do — Windows, MS Word

- Firmware: software permanently stored in hardware (in ROM) — BIOS

- Liveware: the people who use the computer — users, programmers

Exam Focus

- The "brain" of the computer is the CPU; the "heart" of the computer is often said to be the motherboard

- Microprocessor = the whole CPU on a single chip; the first microprocessor was Intel 4004 (1971)

- Computer speed is measured in hertz (clock speed), MIPS (instructions) and FLOPS (supercomputers)

- A computer cannot work without an operating system; it cannot think without a program

02 Computer Generations & History - ENIAC (1946): Electronic Numerical Integrator and Computer — first general-purpose electronic digital computer; built by J. Presper Eckert and John…

Early Calculating Devices

DeviceInventorYear / PeriodKey fact
AbacusChina (also Babylon)About 3000 BCFirst known calculating device; uses beads on rods
Napier's BonesJohn Napier1617Used for multiplication and division
Slide RuleWilliam Oughtred1622Based on logarithms
PascalineBlaise Pascal1642First mechanical adding machine
Stepped ReckonerGottfried Leibniz1673Could add, subtract, multiply and divide
Jacquard LoomJoseph Marie Jacquard1801Used punched cards to control weaving patterns
Difference EngineCharles Babbage1822Mechanical calculator for tables
Analytical EngineCharles Babbage1837First design of a general-purpose programmable computer
Tabulating MachineHerman Hollerith1890Used punched cards for the US census; his company later became IBM

REMEMBER: Lady Ada Lovelace wrote the first algorithm for Babbage's Analytical Engine, so she is called the world's first computer programmer.

Famous Early Electronic Computers

- ENIAC (1946): Electronic Numerical Integrator and Computer — first general-purpose electronic digital computer; built by J. Presper Eckert and John Mauchly; used about 18,000 vacuum tubes

- EDVAC: Electronic Discrete Variable Automatic Computer — based on von Neumann's stored-program idea

- EDSAC (1949): Electronic Delay Storage Automatic Calculator — one of the first practical stored-program computers

- UNIVAC I (1951): Universal Automatic Computer — first commercial computer in the USA

- Mark I (1944): electromechanical computer built by Howard Aiken with IBM

The Five Generations of Computers

GenerationPeriod (approx.)Main technologyLanguageExamples
First1940–1956Vacuum tubesMachine languageENIAC, EDVAC, UNIVAC I
Second1956–1963TransistorsAssembly language; early FORTRAN and COBOLIBM 1401, IBM 7094
Third1964–1971Integrated Circuits (IC)High-level languagesIBM 360 series
Fourth1971–presentMicroprocessor (VLSI)High-level languages, GUIPersonal computers, Apple Macintosh
FifthPresent and futureArtificial Intelligence (ULSI), parallel processingAI languages, natural languageRobots, expert systems, AI assistants

Key Facts by Generation

- First generation: very large, consumed a lot of power, produced a lot of heat; used magnetic drums for memory and punched cards for input

- Second generation: transistor invented in 1947 at Bell Labs (Shockley, Bardeen, Brattain); used magnetic-core memory

- Third generation: Integrated Circuit invented by Jack Kilby (1958) and Robert Noyce; keyboards and monitors began to be used; operating systems appeared

- Fourth generation: microprocessor — the whole CPU on one chip (Intel 4004, 1971); personal computers and networks grew

- Fifth generation: aims at computers that can learn and reason; based on AI, ULSI and parallel processing

Computers in India

- TIFRAC (1960): first computer designed and built in India, at the Tata Institute of Fundamental Research (TIFR), Mumbai

- Siddharth: first Indian-made personal/mini computer series, made by ECIL

- PARAM 8000 (1991): first Indian supercomputer, by C-DAC Pune

- National Supercomputing Mission (NSM) is building PARAM supercomputers across India

Exam Focus

- Father of the computer: Charles Babbage; first programmer: Ada Lovelace

- Father of modern computer science and AI theory: Alan Turing (Turing machine, Turing test)

- Von Neumann gave the "stored program concept" — programs and data stored together in memory

- Vacuum tube → transistor → IC → microprocessor → AI: the order of generations

03 Cpu, Motherboard & Ports The CPU (also called the processor) carries out all instructions of a program. It is called the brain of the computer.

Central Processing Unit (CPU)

The CPU (also called the processor) carries out all instructions of a program. It is called the brain of the computer.

- ALU (Arithmetic Logic Unit): does arithmetic (+, −, ×, ÷) and logical operations (AND, OR, NOT, comparisons)

- CU (Control Unit): directs and coordinates all parts of the computer; fetches and decodes instructions; it does not process data itself

- Registers: very small, very fast storage inside the CPU

Machine Cycle (Instruction Cycle)

The CPU repeats four steps for every instruction:

StepWhat happens
FetchGet the instruction from memory
DecodeUnderstand what the instruction means
ExecuteCarry out the instruction (ALU works here)
StoreWrite the result back to memory or a register

Important CPU Registers

RegisterFull formJob
PCProgram CounterHolds the address of the next instruction
IRInstruction RegisterHolds the instruction being executed
MARMemory Address RegisterHolds the memory address to read or write
MBR / MDRMemory Buffer / Data RegisterHolds the data read from or written to memory
ACCAccumulatorHolds intermediate results of the ALU

Processor Speed and Cores

- Clock speed: measured in hertz — today usually in GHz (gigahertz = billions of cycles per second)

- Core: an independent processing unit inside the CPU; dual-core = 2, quad-core = 4, octa-core = 8

- Word size: number of bits a CPU processes at once — 32-bit or 64-bit

- Major CPU makers: Intel (Core i3/i5/i7/i9), AMD (Ryzen), Apple (M-series), Qualcomm (Snapdragon for phones)

TIP: GPU (Graphics Processing Unit) handles images and video; it is also used for AI work. NVIDIA and AMD are leading GPU makers.

Motherboard

The motherboard is the main circuit board of the computer. Every component connects to it.

- It holds the CPU socket, RAM slots, chipset, BIOS/UEFI chip, expansion slots and ports

- Other names: mainboard, system board, logic board

- A CMOS battery on the motherboard keeps the date, time and BIOS settings when the computer is off

Buses

A bus is a set of wires that carries signals between parts of the computer.

- Data bus: carries data (two-way)

- Address bus: carries memory addresses (one-way, from CPU)

- Control bus: carries control signals such as read/write

BIOS, UEFI and Booting

- BIOS: Basic Input Output System — firmware stored in ROM that starts the computer

- UEFI: Unified Extensible Firmware Interface — the modern replacement of BIOS

- POST: Power-On Self-Test — the first check BIOS runs to test hardware when the computer starts

- Booting: the process of starting a computer and loading the operating system

- Cold booting: starting the computer from power OFF; warm booting: restarting it while it is on (Ctrl + Alt + Del / Restart)

Ports and Connectors

PortUsed for
USB (Universal Serial Bus)Pen drives, keyboards, mice, phones; USB Type-C is reversible
HDMIHigh-Definition video + audio to TV or monitor
VGAOlder analog video port for monitors
Ethernet (RJ-45)Wired network / internet cable
RJ-11Telephone line / DSL modem
PS/2Older keyboard (purple) and mouse (green) port
Audio jack (3.5 mm)Headphones, speakers, microphone
Serial portOld modems, mouse — sends one bit at a time
Parallel portOld printers — sends several bits at once

Exam Focus

- ALU = calculations and logic; CU = control and coordination

- Program Counter holds the address of the next instruction

- POST is done by the BIOS; CMOS battery keeps the clock and BIOS settings

- USB was introduced in 1996; HDMI carries both audio and video

04 Input Devices An input device sends data and instructions into the computer. The computer converts this input into binary (0s and 1s).

What is an Input Device?

An input device sends data and instructions into the computer. The computer converts this input into binary (0s and 1s).

Keyboard

- The most common input device; a standard keyboard has about 104 keys

- QWERTY layout was designed by Christopher Latham Sholes (1870s) for typewriters

- Keys: alphanumeric, function keys (F1–F12), modifier keys (Shift, Ctrl, Alt), toggle keys (Caps Lock, Num Lock, Scroll Lock), navigation keys (arrows, Home, End, Page Up, Page Down)

- F and J keys have small bumps to help touch typists find the home row

Mouse and Pointing Devices

- Mouse: invented by Douglas Engelbart (1960s); a pointing device that controls the cursor; types — mechanical (ball), optical, laser, wireless

- Mouse actions: click, double-click, right-click (shortcut menu), drag and drop, scroll

- Trackball: an upside-down mouse; the ball is rolled with the thumb

- Touchpad / trackpad: used on laptops

- Joystick: used in games, flight simulators and to control cranes and robots

- Light pen: a pen-shaped device used to draw or select directly on a screen

- Stylus: used with touch screens and graphic tablets

Scanning and Reading Devices

DeviceFull formReads / used for
Scanner—Converts paper documents and photos into digital images
OCROptical Character RecognitionReads printed or handwritten text and converts it into editable text
OMROptical Mark Reader / RecognitionReads pencil or pen marks — used for checking objective (bubble) answer sheets
MICRMagnetic Ink Character RecognitionReads characters printed with magnetic ink — used by banks to process cheques
BCRBar Code ReaderReads bar codes on products at shop counters
QR code scannerQuick Response codeReads 2D codes — used for UPI payments
RFID readerRadio Frequency IdentificationReads RFID tags — FASTag at toll plazas

REMEMBER: MICR is used in banking for cheque processing. The 9-digit MICR code at the bottom of a cheque identifies the bank and branch.

Other Input Devices

- Microphone: audio input; used with speech-recognition software

- Webcam / digital camera: video and image input

- Touch screen: works as both input and output device

- Graphic tablet (digitizer): converts hand drawings into digital form

- Biometric devices: read fingerprints, iris, face or voice — used in Aadhaar authentication and AePS

- Sensors: temperature, motion and light sensors give input to embedded systems

Devices that are Both Input and Output

- Touch screen, modem, network card, headset with microphone, multi-function printer (scan + print)

Exam Focus

- MICR = banks (cheques); OMR = exams (answer sheets); OCR = converts text in images into editable text; BCR = bar codes in shops

- Douglas Engelbart invented the mouse; Christopher Latham Sholes designed QWERTY

- A touch screen is both an input and an output device

05 Output Devices An output device shows or delivers the result of processing to the user — as soft copy (on screen) or hard copy (on paper).

What is an Output Device?

An output device shows or delivers the result of processing to the user — as soft copy (on screen) or hard copy (on paper).

- Soft copy: output seen on a screen; it is temporary

- Hard copy: output printed on paper; it is permanent

Monitors (Visual Display Unit)

TypeFull formKey fact
CRTCathode Ray TubeOld, bulky monitors; use an electron gun
LCDLiquid Crystal DisplayFlat; needs a backlight
LEDLight Emitting DiodeLCD panel lit by LEDs; thinner and saves power
OLEDOrganic LEDEach pixel makes its own light; true black; used in phones
Plasma—Used in older large TVs

- Pixel: the smallest dot on a screen (Picture Element)

- Resolution: number of pixels — e.g. 1920 × 1080 (Full HD), 3840 × 2160 (4K)

- Refresh rate: how many times per second the screen redraws — measured in hertz (Hz)

- Screen size is measured diagonally, in inches

Printers

Impact Printers (strike the paper — noisy)

- Dot matrix printer: prints with pins striking an ink ribbon; speed measured in CPS (characters per second); used for bills and multi-part forms

- Daisy wheel printer: letter-quality text; cannot print graphics

- Line printer: prints one full line at a time; speed in LPM (lines per minute)

Non-Impact Printers (no striking — quiet)

- Inkjet printer: sprays tiny drops of liquid ink; good for colour photos

- Laser printer: uses a laser, a drum and toner powder; fast and sharp; speed in PPM (pages per minute)

- Thermal printer: uses heat-sensitive paper — ATM slips, bus tickets, billing receipts

REMEMBER: Printer resolution (quality) is measured in DPI — Dots Per Inch.

Other Output Devices

- Plotter: prints large drawings, maps, engineering designs and banners (drum and flatbed types)

- Speaker and headphones: sound output

- Projector: shows the screen image on a large surface

- 3D printer: builds solid objects layer by layer

- Braille embosser: prints Braille for visually impaired readers

Exam Focus

- Soft copy = screen; hard copy = paper

- Dot matrix is an impact printer; laser and inkjet are non-impact printers

- Speed units: CPS (dot matrix), LPM (line printer), PPM (laser); quality: DPI

- Plotters are used for large engineering drawings and maps

06 Computer Memory — Overview Memory stores data and instructions. A computer uses different types of memory, from very small and very fast (inside the CPU) to very large and slowe…

What is Memory?

Memory stores data and instructions. A computer uses different types of memory, from very small and very fast (inside the CPU) to very large and slower (hard disk).

Primary vs Secondary Memory

FeaturePrimary memorySecondary memory
Also calledMain / internal memoryAuxiliary / external / backup storage
ExamplesRAM, ROM, cache, registersHard disk, SSD, pen drive, CD/DVD, memory card
SpeedFastSlower
CapacitySmallerMuch larger
Cost per GBHigherLower
CPU accessCPU accesses it directlyCPU cannot access it directly; data is first loaded into RAM
VolatilityRAM is volatile; ROM is non-volatileNon-volatile

Volatile vs Non-Volatile

- Volatile memory loses its data when power is switched off — RAM, cache, registers

- Non-volatile memory keeps data without power — ROM, hard disk, SSD, flash memory, CD/DVD

Memory Hierarchy (Fastest to Slowest)

LevelMemorySpeedSize
1RegistersFastestSmallest
2Cache (L1 → L2 → L3)Very fastVery small
3RAM (main memory)FastMedium
4SSD / flash storageSlowerLarge
5Hard disk (HDD)Slower stillLarge
6Optical disc / magnetic tapeSlowestVery large (tape) / small (CD)

REMEMBER: Speed and cost per byte go DOWN as we move down the hierarchy; capacity goes UP.

Ways of Accessing Data

- Random / direct access: any location can be reached directly — RAM, hard disk, SSD

- Sequential access: data is read in order, one after another — magnetic tape

Semiconductor Memory

- Primary memory is built from semiconductor chips, so it is also called semiconductor memory

- Flash memory (pen drives, SSDs) is also semiconductor memory, but it is used as secondary storage

Exam Focus

- Registers are the fastest memory; magnetic tape is the slowest common storage

- RAM is volatile; ROM is non-volatile

- The CPU can directly access only primary memory

- Magnetic tape uses sequential access; it is used for backups and archives

07 Ram & Rom RAM is the computer's working memory. It holds the programs and data being used right now. It is volatile — everything in it is lost when the power go…

RAM — Random Access Memory

RAM is the computer's working memory. It holds the programs and data being used right now. It is volatile — everything in it is lost when the power goes off.

- Read and write memory: data can be read and changed

- More RAM lets you run more programs at the same time

- RAM capacity is measured in GB; common sizes are 4 GB, 8 GB, 16 GB

- Dynamic RAM was invented by Robert H. Dennard at IBM (1966)

Types of RAM

FeatureSRAM (Static RAM)DRAM (Dynamic RAM)
Built fromFlip-flops (transistors)Capacitors (+ a transistor per bit)
RefreshingDoes not need refreshingMust be refreshed thousands of times per second
SpeedFasterSlower
CostCostlierCheaper
DensityLessMore (more data per chip)
Used asCache memoryMain memory (RAM sticks)

SDRAM and DDR

- SDRAM: Synchronous DRAM — works in step with the system clock

- DDR SDRAM: Double Data Rate — transfers data twice per clock cycle

- Generations: DDR → DDR2 → DDR3 → DDR4 → DDR5; each is faster and uses less power

- LPDDR (Low-Power DDR) is used in mobile phones

ROM — Read Only Memory

ROM is non-volatile memory that keeps its data without power. It stores the instructions needed to start the computer.

- Stores firmware such as the BIOS / UEFI

- The process of writing data into a ROM chip is called "burning"

- ROM is used in calculators, washing machines, TVs and other embedded devices

Types of ROM

TypeFull formCan be changed?How
MROMMasked ROMNoData is written by the manufacturer during making
PROMProgrammable ROMOnce onlyThe user can program it one time (OTP — one-time programmable)
EPROMErasable Programmable ROMYesErased with ultraviolet (UV) light, then reprogrammed
EEPROMElectrically Erasable Programmable ROMYesErased and rewritten with electric signals, byte by byte
Flash(a type of EEPROM)YesErased electrically in blocks — pen drives, SSDs, phone storage

TIP: PROM was invented by Wen Tsing Chow (1956). EPROM was invented by Dov Frohman at Intel (1971).

RAM vs ROM

RAMROM
VolatileNon-volatile
Read and writeMainly read only
Temporary storage of running programsPermanent storage of startup instructions
Larger capacitySmaller capacity
FasterSlower

Exam Focus

- SRAM is used for cache; DRAM is used for main memory

- DRAM must be refreshed; SRAM need not be refreshed

- EPROM is erased by UV light; EEPROM is erased electrically

- BIOS is stored in ROM (flash ROM in modern PCs)

08 Cache, Registers, Virtual & Buffer Memory Cache is a very fast, small memory between the CPU and RAM. It stores data and instructions the CPU uses often, so the CPU does not wait for slower RA…

Cache Memory

Cache is a very fast, small memory between the CPU and RAM. It stores data and instructions the CPU uses often, so the CPU does not wait for slower RAM.

- Made of SRAM

- Levels: L1 (inside each core, smallest and fastest), L2 (larger), L3 (shared by all cores, largest and slowest of the three)

- Cache hit: the data the CPU needs is found in cache

- Cache miss: the data is not in cache, so it is fetched from RAM

Registers

- Registers are the smallest and fastest memory, inside the CPU

- They hold the data and instructions the CPU is using at this moment

- Register size equals the CPU's word size (for example 64 bits)

- A register is built from flip-flops; one flip-flop stores one bit

Virtual Memory

Virtual memory lets a computer use part of the hard disk / SSD as if it were extra RAM.

- When RAM is full, less-used data is moved to a file on the disk (page file / swap file)

- Paging: memory is divided into fixed-size blocks called pages (in RAM, page frames)

- Thrashing: when the computer spends more time swapping pages than doing work, so it becomes very slow

- Virtual memory is slower than real RAM

Buffer Memory

- A buffer is a temporary storage area that holds data while it moves between two devices working at different speeds

- Example: printer buffer (spooling), video buffering while streaming, keyboard buffer

- Spooling: Simultaneous Peripheral Operations On-Line — print jobs wait in a queue

Other Special Memories

- Flash memory: non-volatile, electrically erasable memory used in pen drives and SSDs

- VRAM (Video RAM): memory on a graphics card for screen images

- CMOS memory: a small memory that stores BIOS settings, kept alive by the CMOS battery

Exam Focus

- Cache uses SRAM; L1 is the fastest cache

- Virtual memory uses the hard disk to extend RAM; it is managed by the operating system

- Thrashing = too much paging

- Spooling is used with printers

09 Secondary Storage Devices Secondary storage keeps data permanently, even when the computer is off. It is non-volatile, larger and cheaper than RAM, but slower.

What is Secondary Storage?

Secondary storage keeps data permanently, even when the computer is off. It is non-volatile, larger and cheaper than RAM, but slower.

Magnetic Storage

Hard Disk Drive (HDD)

- Stores data magnetically on spinning metal platters coated with magnetic material

- A read/write head moves over the platters on an arm

- The first hard disk was the IBM 350 (RAMAC), introduced in 1956

- Speed of spinning is measured in RPM — common speeds are 5400 and 7200 RPM

- Track: a circle on the platter; Sector: a part of a track (the smallest storage unit on the disk); Cylinder: the same track on all platters

- Seek time: time to move the head to the right track; Latency: time for the sector to rotate under the head; Access time = seek time + latency

- Formatting prepares a disk for use by creating tracks, sectors and a file system

Floppy Disk

- Old portable magnetic storage; the 3.5-inch floppy held 1.44 MB

- Invented by IBM (1971); now obsolete

Magnetic Tape

- Sequential-access storage; very cheap per GB; used for large backups and archives

Solid State Storage

- SSD (Solid State Drive): uses flash memory, no moving parts; much faster, quieter and more shock-proof than HDD

- NVMe SSDs connect through PCIe and are faster than SATA SSDs

- Pen drive (USB flash drive): portable flash storage

- Memory card (SD, microSD): used in phones and cameras

Optical Storage (read with a laser)

DiscTypical capacityNotes
CD (Compact Disc)700 MBInfrared laser; CD-ROM, CD-R (write once), CD-RW (rewritable)
DVD (Digital Versatile Disc)4.7 GB (single layer), 8.5 GB (dual layer)Red laser
Blu-ray Disc25 GB (single layer), 50 GB (dual layer)Blue-violet laser — shorter wavelength stores more

REMEMBER: ROM = read only; R = Recordable once (WORM — Write Once Read Many); RW = ReWritable many times.

Cloud Storage

- Data is stored on remote internet servers and accessed online

- Examples: Google Drive, OneDrive, Dropbox, iCloud, DigiLocker (Government of India)

Exam Focus

- Sector is the smallest unit of storage on a disk

- HDD speed is in RPM; SSD has no moving parts

- CD 700 MB, DVD 4.7 GB, Blu-ray 25 GB (single layer)

- CD-R is a WORM medium; magnetic tape is sequential access

10 Memory Units - Bit (Binary Digit): the smallest unit of data — 0 or 1

Bits and Bytes

- Bit (Binary Digit): the smallest unit of data — 0 or 1

- Nibble: 4 bits

- Byte: 8 bits — enough to store one character (such as "A")

- Word: the number of bits a CPU processes at once (16, 32 or 64 bits)

Memory Unit Chart (Binary system — used inside computers)

UnitEqual to
1 Nibble4 bits
1 Byte8 bits
1 Kilobyte (KB)1024 bytes
1 Megabyte (MB)1024 KB
1 Gigabyte (GB)1024 MB
1 Terabyte (TB)1024 GB
1 Petabyte (PB)1024 TB
1 Exabyte (EB)1024 PB
1 Zettabyte (ZB)1024 EB
1 Yottabyte (YB)1024 ZB

TIP: Memory trick for the order of units — "Kids Make Great Toys, Playing Every Zone Yearly" = K, M, G, T, P, E, Z, Y.

Decimal vs Binary Units

- Storage makers use decimal units: 1 KB = 1000 bytes, 1 GB = 10⁹ bytes

- Computers use binary units: 1 KiB = 1024 bytes (2¹⁰)

- This is why a "1 TB" drive shows only about 931 GB in Windows

- IEC binary names: KiB (kibibyte), MiB (mebibyte), GiB (gibibyte), TiB (tebibyte)

Powers of 2 to Remember

UnitBytes as power of 2
1 KB2¹⁰ bytes
1 MB2²⁰ bytes
1 GB2³⁰ bytes
1 TB2⁴⁰ bytes

Data Transfer Units

- Internet speed is measured in bits per second (bps): Kbps, Mbps, Gbps

- Note: Mbps (megabits) is different from MBps (megabytes); 8 Mbps = 1 MBps

Exam Focus

- 1 byte = 8 bits; 1 nibble = 4 bits

- 1 KB = 1024 bytes = 2¹⁰ bytes

- The largest standard unit is the yottabyte (newer ronnabyte and quettabyte were added in 2022)

- Internet speed uses bits; file size uses bytes

11 Number System Multiply each bit by 2 raised to its position (from the right, starting at 0) and add.

Types of Number Systems

SystemBaseDigits usedExample
Binary20, 1(1011)₂
Octal80 to 7(17)₈
Decimal100 to 9(25)₁₀
Hexadecimal160–9 and A–F (A=10, B=11, C=12, D=13, E=14, F=15)(1F)₁₆

REMEMBER: Computers understand only binary. One octal digit = 3 bits; one hexadecimal digit = 4 bits.

Binary to Decimal

Multiply each bit by 2 raised to its position (from the right, starting at 0) and add.

Example: (1011)₂ = 1×8 + 0×4 + 1×2 + 1×1 = 11

Decimal to Binary

Divide by 2 repeatedly and write the remainders from bottom to top.

Example: 13 ÷ 2 = 6 r1; 6 ÷ 2 = 3 r0; 3 ÷ 2 = 1 r1; 1 ÷ 2 = 0 r1 → (1101)₂

Octal and Hexadecimal Conversions

- Binary → octal: group bits in 3s from the right. (110 101)₂ = (65)₈

- Binary → hex: group bits in 4s from the right. (1010 1111)₂ = (AF)₁₆

- Hex → decimal: (2A)₁₆ = 2×16 + 10 = 42

- Octal → decimal: (17)₈ = 1×8 + 7 = 15

Binary Arithmetic

AdditionResult
0 + 00
0 + 11
1 + 01
1 + 110 (0, carry 1)
1 + 1 + 111 (1, carry 1)

1's and 2's Complement (for negative numbers)

- 1's complement: change every 0 to 1 and every 1 to 0. 1's complement of 1010 is 0101

- 2's complement: 1's complement + 1. 2's complement of 1010 is 0110

- Computers use 2's complement to store negative numbers and to subtract

Character Codes

CodeFull formBits
ASCIIAmerican Standard Code for Information Interchange7 bits (128 characters); extended ASCII uses 8 bits
EBCDICExtended Binary Coded Decimal Interchange Code8 bits; used in IBM mainframes
Unicode—Up to 32 bits; covers all world scripts including Hindi and emojis
BCDBinary Coded Decimal4 bits per decimal digit

Exam Focus

- Base: binary 2, octal 8, decimal 10, hexadecimal 16

- Hex F = 15; hex A = 10

- ASCII of "A" = 65, "a" = 97, "0" = 48

- 2's complement = 1's complement + 1

12 Logic Gates & Boolean Algebra A logic gate is a basic electronic circuit that takes one or more binary inputs (0 or 1) and gives one output. All digital circuits, including the CPU…

What is a Logic Gate?

A logic gate is a basic electronic circuit that takes one or more binary inputs (0 or 1) and gives one output. All digital circuits, including the CPU, are built from logic gates.

- Boolean algebra (the maths of 0 and 1) was developed by George Boole

- 1 = TRUE / ON / HIGH; 0 = FALSE / OFF / LOW

Basic Gates

GateSymbol in expressionOutput is 1 when
ANDA · BAll inputs are 1
ORA + BAt least one input is 1
NOTA' or ĀThe input is 0 (it inverts the input; only one input)

Derived Gates

GateMeaningOutput is 1 when
NANDNOT of ANDAt least one input is 0
NORNOT of ORAll inputs are 0
XORExclusive ORInputs are different
XNORExclusive NORInputs are the same

REMEMBER: NAND and NOR are called Universal Gates — any other gate can be built using only NAND gates or only NOR gates.

Truth Table (two inputs A and B)

ABANDORNANDNORXORXNOR
00001101
01011010
10011010
11110001

Important Boolean Laws

- Identity: A + 0 = A; A · 1 = A

- Null: A + 1 = 1; A · 0 = 0

- Idempotent: A + A = A; A · A = A

- Complement: A + A' = 1; A · A' = 0

- Double negation: (A')' = A

- De Morgan's theorems: (A · B)' = A' + B' and (A + B)' = A' · B'

Exam Focus

- AND = multiplication; OR = addition; NOT = inversion

- Universal gates: NAND and NOR

- XOR gives 1 only when inputs differ

- A truth table with n inputs has 2ⁿ rows

13 Software Software is a set of programs (instructions) that tells the computer what to do. Unlike hardware, software cannot be touched.

What is Software?

Software is a set of programs (instructions) that tells the computer what to do. Unlike hardware, software cannot be touched.

Main Types of Software

TypePurposeExamples
System softwareRuns and manages the computer hardwareOperating systems, device drivers, BIOS, utilities
Application softwareHelps the user do a specific taskMS Word, Excel, Chrome, Tally, Photoshop, WhatsApp
Utility softwareMaintains and protects the computerAntivirus, disk cleanup, defragmenter, backup, file compression (WinZip, WinRAR)
Programming / development softwareHelps write programsCompilers, interpreters, IDEs such as VS Code

System Software in Detail

- Operating system: the main system software — Windows, Linux, macOS, Android

- Device driver: a small program that lets the OS talk to a hardware device such as a printer

- Language translators: compiler, interpreter, assembler

- Firmware: software built into hardware (BIOS)

Application Software Categories

- Word processor: MS Word, Google Docs, LibreOffice Writer

- Spreadsheet: MS Excel, Google Sheets

- Presentation: MS PowerPoint, Google Slides

- Database: MS Access, Oracle, MySQL

- Graphics: Photoshop, CorelDRAW

- Accounting: Tally

- Web browser: Chrome, Firefox, Edge, Safari

Software by Licence and Price

TypeMeaningExample
Proprietary (closed source)Owned by a company; source code is secret; usually paidMS Office, Windows
Open sourceSource code is free to see, change and shareLinux, Firefox, LibreOffice, Android (AOSP)
FreewareFree to use, but source code is not sharedAdobe Acrobat Reader, Skype
SharewareFree to try for a limited time or with limited features, then payWinRAR (trial)
Public domainNo copyright; anyone can use it freelySome old programs

REMEMBER: Open source ≠ freeware. Freeware is free of cost; open source means the source code is open.

Software Terms

- EULA: End User Licence Agreement — the terms you accept before installing software

- Patch: a small update that fixes bugs or security holes

- Version: a numbered release of software (e.g. Windows 11)

- Beta version: an early test version released to users

- Bug: an error in a program; debugging: finding and removing bugs

- Installation: copying and setting up software; uninstallation removes it

- Horizontal software is general (used by anyone); vertical software is made for one industry (hospital or bank software)

Exam Focus

- Operating system = most important system software

- Antivirus, disk defragmenter and backup tools are utility software

- Linux is open source; Windows is proprietary

- Device drivers connect the OS with hardware

14 Operating System An operating system (OS) is system software that manages the computer's hardware and software and acts as an interface between the user and the comput…

What is an Operating System?

An operating system (OS) is system software that manages the computer's hardware and software and acts as an interface between the user and the computer. A computer cannot run without an OS.

Functions of an Operating System

- Process management: runs programs, decides which program gets the CPU (CPU scheduling)

- Memory management: allots RAM to programs and frees it; manages virtual memory

- File management: creates, saves, deletes and organises files and folders

- Device management: controls input/output devices through drivers

- Security: user accounts, passwords and permissions

- User interface: CLI or GUI

Parts of an OS

- Kernel: the core of the OS; it stays in memory and controls hardware directly

- Shell: the outer layer that takes user commands and passes them to the kernel

User Interfaces

TypeFull formHow you use itExample
CLI / CUICommand Line / Character User InterfaceTyping commandsMS-DOS, Linux terminal
GUIGraphical User InterfaceIcons, windows, menus and a mouseWindows, macOS

REMEMBER: GUI was first developed at Xerox PARC. Apple's Macintosh (1984) made GUI popular; Windows 1.0 came in 1985.

Types of Operating Systems

TypeMeaningExample
Batch OSJobs with similar needs are grouped and run one after another without user interactionEarly IBM mainframes, payroll processing
MultiprogrammingSeveral programs are kept in memory so the CPU is never idle—
Multitasking / time-sharingThe CPU switches quickly between tasks so each user gets a time sliceWindows, Linux, Unix
MultiprocessingUses two or more CPUs togetherServers
Real-time OS (RTOS)Responds within a fixed, very short timeAir-traffic control, missile systems, ATMs, robots
Distributed OSMany connected computers work as one system—
Network OSManages computers and resources on a networkWindows Server
Mobile OSMade for phones and tabletsAndroid, iOS, HarmonyOS

Popular Operating Systems

- Windows (Microsoft): most used desktop OS; first version Windows 1.0 (1985)

- macOS (Apple): for Mac computers

- Linux: open-source OS created by Linus Torvalds (1991); versions (distributions) include Ubuntu, Fedora, Red Hat, Debian

- Unix: developed at Bell Labs (1969) by Ken Thompson and Dennis Ritchie

- Android: mobile OS based on the Linux kernel, owned by Google

- iOS: Apple's mobile OS for iPhone

- MS-DOS: Microsoft Disk Operating System — single-user, single-tasking, command-line OS (1981)

- BharOS: an Indian mobile OS developed with IIT Madras support

Booting

- Booting: loading the OS into RAM when the computer starts

- Cold boot: starting a switched-off computer; warm boot: restarting a running computer

- Bootstrap loader: the small program in ROM that starts loading the OS

- Safe mode: starts Windows with only basic drivers to fix problems

File Systems

- FAT32, NTFS (Windows), exFAT (pen drives), ext4 (Linux), APFS (macOS)

Exam Focus

- Kernel is the core; shell is the interface

- Linux was created by Linus Torvalds; Android is based on Linux

- Real-time OS is used where immediate response is critical

- MS-DOS is a single-user, single-tasking CLI OS

15 Microsoft Windows Windows is a GUI operating system made by Microsoft. Bill Gates and Paul Allen founded Microsoft in 1975.

About Windows

Windows is a GUI operating system made by Microsoft. Bill Gates and Paul Allen founded Microsoft in 1975.

VersionYearNote
Windows 1.01985First version
Windows 951995Introduced the Start button and taskbar
Windows XP2001Very popular for many years
Windows 72009—
Windows 102015Introduced the Edge browser
Windows 112021Centred Start menu and taskbar

Parts of the Windows Desktop

- Desktop: the main screen you see after logging in

- Icons: small pictures that stand for files, folders or programs

- Taskbar: the bar (usually at the bottom) that shows the Start button and open programs

- Start menu: opens apps, settings and the power options

- System tray / notification area: right side of the taskbar — clock, volume, network, battery

- Recycle Bin: holds deleted files until it is emptied; files can be restored from it

- Shortcut: an icon that points to a file or program; it has a small arrow on it

- File Explorer: used to browse and manage files and folders

- Control Panel / Settings: change system settings

- Task Manager: shows running programs and processes; used to end a frozen program (Ctrl + Shift + Esc)

REMEMBER: Shift + Delete deletes a file permanently — it does NOT go to the Recycle Bin.

Files and Folders

- File: a collection of data with a name and an extension (report.docx)

- Folder (directory): a container for files and other folders

- Path: the location of a file, e.g. C:\Users\Asha\Documents\report.docx

- Root directory: the top-level folder of a drive (C:\)

- File names in Windows cannot contain \ / : * ? " < > |

Useful Windows Features

- Clipboard: temporary storage for cut/copied items (Windows key + V shows its history)

- Snipping Tool: takes screenshots (Windows key + Shift + S)

- Notepad: simple text editor (.txt); WordPad: basic word processor; Paint: simple drawing program

- Disk Cleanup and Defragment: utilities to free space and arrange files

- Sleep mode keeps work in RAM using little power; Hibernate saves work to the disk and switches off

Windows Shortcuts

ShortcutAction
Windows keyOpen the Start menu
Windows + DShow desktop
Windows + EOpen File Explorer
Windows + LLock the computer
Windows + ROpen the Run box
Windows + IOpen Settings
Windows + TabTask View
Alt + TabSwitch between open windows
Alt + F4Close the active window / shut down dialog on desktop
Ctrl + Shift + EscOpen Task Manager directly
F2Rename the selected file
F5Refresh

Exam Focus

- Recycle Bin stores deleted files; Shift + Delete bypasses it

- Windows + L locks the PC; Windows + D shows the desktop

- Notepad saves files as .txt

- Microsoft was founded by Bill Gates and Paul Allen in 1975

16 Keyboard & Shortcut Keys - Alphanumeric keys: letters and numbers

Types of Keys

- Alphanumeric keys: letters and numbers

- Function keys: F1 to F12 at the top

- Modifier keys: Ctrl, Alt, Shift, Windows key — they work together with other keys

- Toggle keys: Caps Lock, Num Lock, Scroll Lock — they switch a mode on or off

- Navigation keys: arrow keys, Home, End, Page Up, Page Down

- Editing keys: Insert, Delete, Backspace

- Numeric keypad: on the right side; works as numbers when Num Lock is on

TIP: Backspace deletes the character to the LEFT of the cursor; Delete removes the character to the RIGHT of the cursor.

Function Keys

KeyCommon use
F1Help
F2Rename the selected file or folder
F3Search / Find (in File Explorer and browsers)
F4Repeat the last action (MS Word); Alt + F4 closes the window
F5Refresh a page; start a slide show (PowerPoint)
F6Move to the address bar (browser)
F7Spelling and grammar check (MS Word)
F11Full screen (browser)
F12Save As (MS Office); developer tools (browser)

Ctrl Shortcuts (Windows and MS Office)

ShortcutAction
Ctrl + ASelect all
Ctrl + BBold
Ctrl + CCopy
Ctrl + DFont dialog (Word); bookmark (browser)
Ctrl + ECentre align
Ctrl + FFind
Ctrl + GGo To
Ctrl + HReplace (Word); history (browser)
Ctrl + IItalic
Ctrl + JJustify
Ctrl + KInsert hyperlink
Ctrl + LLeft align
Ctrl + NNew document / window
Ctrl + OOpen
Ctrl + PPrint
Ctrl + RRight align
Ctrl + SSave
Ctrl + UUnderline
Ctrl + VPaste
Ctrl + WClose document / tab
Ctrl + XCut
Ctrl + YRedo
Ctrl + ZUndo
Ctrl + Home / Ctrl + EndGo to the beginning / end of the document

Browser Shortcuts

ShortcutAction
Ctrl + TNew tab
Ctrl + Shift + TReopen the last closed tab
Ctrl + Shift + NNew incognito (private) window in Chrome
Ctrl + TabNext tab
Ctrl + + / Ctrl + −Zoom in / zoom out
Ctrl + DBookmark the page

Other Useful Combinations

- Ctrl + Alt + Delete: security screen (lock, sign out, Task Manager); in old PCs it restarted the system

- Alt + Tab: switch between programs

- Shift + F10: right-click menu

- Ctrl + Shift + Esc: Task Manager

- Print Screen (PrtSc): copies the screen image to the clipboard

Exam Focus

- Ctrl + Z undo; Ctrl + Y redo

- F7 spell check; F12 Save As; Shift + F7 thesaurus in Word

- Ctrl + K hyperlink; Ctrl + J justify; Ctrl + E centre

- A standard keyboard has 12 function keys

17 Ms Word MS Word is a word-processing program from Microsoft used to create, edit, format and print documents. It was first released in 1983, developed by Char…

About MS Word

MS Word is a word-processing program from Microsoft used to create, edit, format and print documents. It was first released in 1983, developed by Charles Simonyi and Richard Brodie.

File Extensions

ExtensionMeaning
.docxWord document (Word 2007 and later)
.docWord 97–2003 document
.dotxWord template
.docmMacro-enabled document
.rtfRich Text Format (opens in most word processors)
.pdfCan be saved as PDF (File → Save As)

Default Settings

- Default font: Calibri 11 pt in Office 2007–2021 (newer Microsoft 365 uses Aptos)

- Default orientation: Portrait

- Default margins: 1 inch (2.54 cm) on all sides ("Normal")

- Default paper size: A4 in India (Letter in the USA)

- Default alignment: Left

- Zoom range: 10% to 500%

Ribbon Tabs and What They Contain

TabImportant tools
File (Backstage view)Save, Save As, Print, Open, Share, Export
HomeFont, paragraph, styles, Format Painter, Find & Replace, clipboard
InsertTable, pictures, shapes, SmartArt, chart, header & footer, page number, text box, WordArt, Drop Cap, symbol, equation, hyperlink
DesignThemes, watermark, page colour, page borders
LayoutMargins, orientation, size, columns, breaks, line numbers, indent, spacing
ReferencesTable of contents, footnotes, endnotes, citations, bibliography, captions
MailingsMail Merge, envelopes, labels
ReviewSpelling & grammar, thesaurus, word count, comments, track changes, protect document
ViewRead Mode, Print Layout, Web Layout, Outline, Draft, ruler, zoom, macros

Important Features

- Mail Merge (Mailings tab): sends the same letter to many people with different names and addresses; it needs a main document and a data source

- Format Painter (Home tab): copies formatting from one text to another; double-click to apply many times

- Drop Cap (Insert tab): a large first letter at the start of a paragraph

- Watermark (Design tab): faint text or picture behind the page text, e.g. "CONFIDENTIAL"

- Track Changes (Review tab): records every edit made to the document

- Macro: a recorded set of steps that runs with one click

- Header and footer: text at the top/bottom of every page

- Gutter margin: extra space for binding

- Thesaurus (Shift + F7): finds synonyms

- AutoCorrect: fixes common typing mistakes automatically

Word Shortcuts

ShortcutAction
Ctrl + EnterPage break
Ctrl + 1 / 2 / 5Single / double / 1.5 line spacing
Shift + F3Change case (UPPER / lower / Title)
Ctrl + ] or Ctrl + Shift + >Increase font size
Ctrl + [ or Ctrl + Shift + <Decrease font size
Ctrl + =Subscript (H₂O)
Ctrl + Shift + =Superscript (x²)
Ctrl + DFont dialog box
Shift + F7Thesaurus
F7Spelling and grammar
Ctrl + MIndent paragraph

Word Views

- Read Mode, Print Layout (default), Web Layout, Outline, Draft

Exam Focus

- .docx is the default Word format; .dotx is a template

- Mail Merge is in the Mailings tab; Drop Cap is in the Insert tab; Watermark is in the Design tab

- Default orientation is Portrait; default margin 1 inch

- Ctrl + Enter inserts a page break; Shift + F3 changes case

18 Ms Excel MS Excel is a spreadsheet program used for calculations, data analysis, charts and tables. It was first released in 1985.

About MS Excel

MS Excel is a spreadsheet program used for calculations, data analysis, charts and tables. It was first released in 1985.

- Workbook: the Excel file (.xlsx); it contains worksheets

- Worksheet: one sheet made of rows and columns

- Cell: the box where a row and a column meet; named by column letter + row number, e.g. B5

- Active cell: the selected cell (shown in the Name Box)

- Range: a group of cells, e.g. A1:A10

Size of a Worksheet (Excel 2007 and later)

ItemLimit
Rows1,048,576 (numbered)
Columns16,384 (lettered, A to XFD)
Last cellXFD1048576
New workbook1 sheet by default (Excel 2013 and later)

File Extensions

ExtensionMeaning
.xlsxExcel workbook
.xlsExcel 97–2003 workbook
.xlsmMacro-enabled workbook
.xltxExcel template
.csvComma-separated values (plain text)

Formulas and Functions

Every formula starts with an equals sign (=).

FunctionUse
=SUM(A1:A5)Adds values
=AVERAGE(A1:A5)Mean of values
=COUNT(A1:A5)Counts cells with numbers
=COUNTA(A1:A5)Counts non-empty cells
=MAX() / =MIN()Largest / smallest value
=IF(A1>40,"Pass","Fail")Checks a condition
=VLOOKUP() / =HLOOKUP()Looks up a value vertically / horizontally
=ROUND(A1,2)Rounds to 2 decimals
=TODAY() / =NOW()Today's date / date and time
=CONCAT()Joins text

Cell References

- Relative (A1): changes when the formula is copied

- Absolute ($A$1): does not change when copied

- Mixed ($A1 or A$1): only the column or only the row is fixed

- Press F4 to switch between reference types

Common Error Values

ErrorMeaning
#DIV/0!Division by zero
#NAME?Excel does not recognise a function or name
#VALUE!Wrong type of value (e.g. text in maths)
#REF!Invalid cell reference (a referenced cell was deleted)
#N/AValue not available (common in VLOOKUP)
#####Column is too narrow to show the value

Important Features

- Chart: visual display of data (column, bar, line, pie)

- Pivot Table: summarises large data quickly

- Freeze Panes (View tab): keeps headings visible while scrolling

- Conditional Formatting: changes cell colour based on rules

- Filter and Sort (Data tab); Data Validation limits what can be entered

- AutoFill: the fill handle copies a series (1, 2, 3 or Jan, Feb…)

- Name Box shows the address of the active cell; Formula Bar shows the content of the cell

Excel Shortcuts

ShortcutAction
F2Edit the active cell
Alt + =AutoSum
Ctrl + ;Insert today's date
Ctrl + Shift + ;Insert the current time
Ctrl + Space / Shift + SpaceSelect whole column / whole row
Shift + F11Insert a new worksheet
Ctrl + Page Up / Page DownMove between sheets
F11Create a chart on a new sheet

Exam Focus

- Formulas start with =; rows are numbers, columns are letters

- 1,048,576 rows and 16,384 columns (last column XFD)

- $A$1 is an absolute reference; F4 toggles references

- #DIV/0! = division by zero; ##### = column too narrow

19 Ms Powerpoint MS PowerPoint is presentation software used to create slide shows with text, pictures, charts, audio and video. It was created by Robert Gaskins and D…

About PowerPoint

MS PowerPoint is presentation software used to create slide shows with text, pictures, charts, audio and video. It was created by Robert Gaskins and Dennis Austin (originally named "Presenter") and released in 1987; Microsoft bought it the same year.

- Presentation: the whole PowerPoint file

- Slide: one page of a presentation

File Extensions

ExtensionMeaning
.pptxPowerPoint presentation (2007 and later)
.pptPowerPoint 97–2003 presentation
.ppsxPowerPoint Show — opens directly as a slide show
.potxPowerPoint template
.pptmMacro-enabled presentation

Views in PowerPoint

ViewUse
NormalDefault view for editing slides
Outline ViewShows only the text of slides
Slide SorterShows all slides as thumbnails — to rearrange, delete or copy slides
Notes PageShows the slide with speaker notes below it
Reading ViewPlays the show inside the PowerPoint window
Slide ShowFull-screen presentation

Transitions vs Animations

- Transition: the effect when moving from one slide to the next (Transitions tab)

- Animation: the effect on an object (text or picture) within a slide — entrance, emphasis, exit, motion path (Animations tab)

- Animation Painter copies animation effects to another object

Important Features

- Slide Master (View tab): controls the design and layout of all slides at once

- Design themes (Design tab): ready-made colours, fonts and backgrounds

- Speaker notes: notes for the presenter that the audience does not see

- Hyperlinks and action buttons for moving between slides

- Rehearse Timings: records how long each slide is shown

- SmartArt: diagrams such as lists and processes

PowerPoint Shortcuts

ShortcutAction
F5Start slide show from the first slide
Shift + F5Start slide show from the current slide
Ctrl + MInsert a new slide
Ctrl + DDuplicate the selected slide
EscEnd the slide show
B / W (during show)Black / white screen
N or →Next slide; P or ← previous slide

Exam Focus

- F5 starts from the beginning; Shift + F5 from the current slide

- Slide Sorter view is used to rearrange slides

- Transition = between slides; Animation = on objects inside a slide

- Slide Master controls the look of all slides; .ppsx opens directly as a show

20 Ms Office Suite, Access & Outlook MS Office is a suite (group) of office programs from Microsoft. The first Office suite was released in 1990 (1989 for Mac).

MS Office

MS Office is a suite (group) of office programs from Microsoft. The first Office suite was released in 1990 (1989 for Mac).

ProgramUsed forFile extension
WordDocuments.docx
ExcelSpreadsheets.xlsx
PowerPointPresentations.pptx
AccessDatabases.accdb
OutlookEmail, calendar, contacts.pst (data file)
OneNoteDigital notes.one
PublisherDesktop publishing (brochures, newsletters).pub
TeamsChat, meetings, collaboration—

- Microsoft 365 (earlier Office 365): the subscription, cloud-connected version of Office

- Alternatives: Google Workspace (Docs, Sheets, Slides), LibreOffice (Writer, Calc, Impress), Apple iWork (Pages, Numbers, Keynote), WPS Office

MS Access

MS Access is a database management system (DBMS) for storing and organising data in tables.

ObjectPurpose
TableStores data in rows (records) and columns (fields)
QueryAsks questions of the data — finds, filters and calculates
FormA user-friendly screen to enter and view data
ReportA formatted output of data for printing
MacroAutomates tasks
ModuleVBA (Visual Basic for Applications) code

- Primary key: a field that uniquely identifies each record

- File extension: .accdb (Access 2007 and later); .mdb in older versions

- Design View is used to create the structure of a table; Datasheet View shows the data

MS Outlook

- An email client and Personal Information Manager (PIM)

- Manages email, calendar, contacts (People), tasks and notes

- Stores data in .pst files (Personal Storage Table) on the computer

- Outlook.com is Microsoft's free webmail (it replaced Hotmail)

Other Office Facts

- Clipboard in Office can hold up to 24 items

- Backstage view opens from the File tab

- Quick Access Toolbar: small toolbar for frequently used commands (Save, Undo)

- Ribbon: the strip of tabs and groups at the top of Office programs (introduced in Office 2007)

- Status bar: the bar at the bottom showing page number, word count and zoom

Exam Focus

- Access objects: Table, Query, Form, Report, Macro, Module

- Primary key uniquely identifies a record; .accdb is an Access database

- Outlook = email + calendar + contacts (PIM)

- The Ribbon was introduced in Office 2007; the Office clipboard holds 24 items

21 Programming Languages & Translators A programming language is a set of words, symbols and rules used to write instructions (programs) for a computer.

What is a Programming Language?

A programming language is a set of words, symbols and rules used to write instructions (programs) for a computer.

Levels of Programming Languages

LevelDescriptionExample
Machine language (1GL)Written in binary (0 and 1); understood directly by the CPU; fastest but very hard to write10110000 01100001
Assembly language (2GL)Uses short codes called mnemonics (ADD, MOV, SUB); needs an assemblerMOV A, B
High-level language (3GL)Close to English; easy to write; machine-independentC, C++, Java, Python, COBOL, FORTRAN
4GLEven closer to human language; used for databases and reportsSQL
5GLBased on solving problems with constraints; used in AIProlog

REMEMBER: Machine language and assembly language are low-level languages. Machine language is the only language the computer understands directly.

Language Translators

TranslatorConvertsHow
AssemblerAssembly language → machine code—
CompilerHigh-level language → machine codeTranslates the whole program at once; shows all errors together; runs faster afterwards (C, C++)
InterpreterHigh-level language → machine codeTranslates and runs line by line; stops at the first error (Python, JavaScript, BASIC)

- Source code: the program written by the programmer

- Object code: the machine code produced by the compiler

- Linker: joins object files and libraries into one executable program

- Loader: loads the executable program into memory to run it

Important Programming Languages

LanguageDeveloperYearUsed for
FORTRANJohn Backus (IBM)1957Scientific calculations — first high-level language
COBOLGrace Hopper (team)1959Business and banking applications
BASICJohn Kemeny and Thomas Kurtz1964Beginners
PascalNiklaus Wirth1970Teaching programming
CDennis Ritchie (Bell Labs)1972System programming; Unix was rewritten in C
C++Bjarne Stroustrup1983Object-oriented version of C
PythonGuido van Rossum1991General purpose, AI and data science
JavaJames Gosling (Sun Microsystems)1995"Write once, run anywhere"; Android apps
JavaScriptBrendan Eich (Netscape)1995Web pages
PHPRasmus Lerdorf1995Server-side web programming
C#Microsoft (Anders Hejlsberg)2000Windows and .NET applications

Web Languages

- HTML: HyperText Markup Language — structure of web pages (a markup language, not a programming language)

- CSS: Cascading Style Sheets — design and layout of web pages

- XML: eXtensible Markup Language — stores and transports data

Programming Terms

- Algorithm: step-by-step method to solve a problem; flowchart: a diagram of an algorithm

- Bug: an error; debugging: removing errors. The term "bug" became popular after Grace Hopper's team found a moth in the Mark II computer (1947)

- Syntax error: breaking the rules of the language; logical error: the program runs but gives a wrong result; runtime error: occurs while the program is running

- OOP (Object-Oriented Programming) concepts: class, object, inheritance, polymorphism, encapsulation, abstraction

Exam Focus

- FORTRAN is the first high-level language; COBOL is for business

- Compiler = whole program at once; interpreter = line by line

- C was developed by Dennis Ritchie; Java by James Gosling; Python by Guido van Rossum

- HTML is a markup language

22 Database Management System (Dbms) - Data: raw facts; Database: an organised collection of related data

Basic Terms

- Data: raw facts; Database: an organised collection of related data

- DBMS: software that creates, stores, manages and retrieves data from a database — e.g. MySQL, Oracle, MS Access, SQL Server, PostgreSQL

- RDBMS: Relational DBMS — stores data in related tables; the relational model was given by E. F. Codd (1970)

- Field (column / attribute): one piece of information, such as Name

- Record (row / tuple): all fields about one item, such as one customer

- Table (relation): a set of rows and columns

Keys in a Database

KeyMeaning
Primary keyUniquely identifies each record; cannot be empty (NULL) or repeated
Candidate keyAny field that could be a primary key
Alternate keyA candidate key that was not chosen as the primary key
Foreign keyA field in one table that refers to the primary key of another table; links tables
Composite keyA primary key made of two or more fields
Super keyAny set of fields that can uniquely identify a record

REMEMBER: Each table can have only ONE primary key, but it can have many foreign keys.

SQL (Structured Query Language)

TypeFull formCommands
DDLData Definition LanguageCREATE, ALTER, DROP, TRUNCATE, RENAME
DMLData Manipulation LanguageINSERT, UPDATE, DELETE, SELECT
DCLData Control LanguageGRANT, REVOKE
TCLTransaction Control LanguageCOMMIT, ROLLBACK, SAVEPOINT

- SELECT * FROM Students WHERE marks > 60; — shows students with marks above 60

- DELETE removes rows (can be rolled back); TRUNCATE removes all rows quickly; DROP removes the whole table

Advantages of DBMS

- Less data redundancy (duplication) and better consistency

- Data sharing among many users; security and access control

- Backup and recovery; data integrity

Other Database Concepts

- Normalisation: organising tables to reduce redundancy (1NF, 2NF, 3NF, BCNF)

- ACID properties of transactions: Atomicity, Consistency, Isolation, Durability

- Data warehouse: large store of historical data used for analysis; data mining: finding patterns in large data

- Schema: the structure/design of the database

- Big data: very large data sets described by Volume, Velocity and Variety

Exam Focus

- E. F. Codd gave the relational model

- Primary key: unique and not NULL; foreign key links two tables

- DDL defines structure (CREATE, ALTER, DROP); DML handles data (INSERT, UPDATE, DELETE, SELECT)

- ACID = Atomicity, Consistency, Isolation, Durability

23 Computer Networks A computer network is two or more computers connected to share data, files, printers and the internet.

What is a Network?

A computer network is two or more computers connected to share data, files, printers and the internet.

Types of Networks by Area

TypeFull formAreaExample
PANPersonal Area NetworkA few metresBluetooth earphones, phone hotspot
LANLocal Area NetworkA room, building or campusOffice or school network
CANCampus Area NetworkA university campusCollege network
MANMetropolitan Area NetworkA cityCable TV network in a city
WANWide Area NetworkCountry or worldThe Internet (the largest WAN)

- WLAN: Wireless LAN (Wi-Fi); VPN: Virtual Private Network — a secure, encrypted connection over a public network

Network Topologies (how devices are arranged)

TopologyArrangementKey point
BusAll devices on one main cable (backbone)Cheap; if the main cable fails, the whole network fails
StarAll devices connect to a central hub/switchMost common; if the hub fails, the network stops
RingEach device connects to two others in a circleData travels in one direction; token passing
MeshEvery device connects to every otherMost reliable; costly; needs n(n−1)/2 links
TreeGroups of star networks joined to a busHierarchical
HybridMix of two or more topologiesFlexible

Network Devices

DeviceJob
HubSends incoming data to all ports (not intelligent)
SwitchSends data only to the correct device using MAC addresses
RouterConnects different networks and finds the best path using IP addresses
ModemMOdulator-DEModulator: converts digital signals to analog and back
RepeaterBoosts (regenerates) weak signals to extend distance
BridgeConnects two LAN segments
GatewayConnects networks that use different protocols
NICNetwork Interface Card — gives a computer its network connection and MAC address
Access pointProvides Wi-Fi to devices on a wired network

Transmission Media

- Guided (wired): twisted-pair cable (most common in LANs), coaxial cable (cable TV), optical fibre (fastest; uses light; total internal reflection)

- Unguided (wireless): radio waves (Wi-Fi, Bluetooth), microwaves, infrared (TV remotes), satellite

Data Transmission Modes

- Simplex: one direction only — keyboard to computer, radio broadcast

- Half-duplex: both directions, but one at a time — walkie-talkie

- Full-duplex: both directions at the same time — telephone call

Other Terms

- Bandwidth: the maximum data rate of a connection, in bps

- Client-server network: central server gives services; peer-to-peer (P2P): all computers are equal

- MAC address: 48-bit physical address of a network card (hexadecimal)

Exam Focus

- The Internet is the largest WAN; Bluetooth forms a PAN

- Star topology is the most common; mesh is the most reliable

- Router uses IP addresses; switch uses MAC addresses

- Optical fibre is the fastest medium; modem = modulator-demodulator

24 Osi & Tcp/Ip Models The OSI (Open Systems Interconnection) model was developed by the ISO (International Organization for Standardization) in 1984. It explains how data t…

OSI Model

The OSI (Open Systems Interconnection) model was developed by the ISO (International Organization for Standardization) in 1984. It explains how data travels across a network in 7 layers.

LayerNameJobExamples / data unit
7ApplicationServices for user applicationsHTTP, FTP, SMTP, DNS, Telnet
6PresentationTranslation, encryption and compression of dataJPEG, MPEG, SSL/TLS, ASCII
5SessionStarts, manages and ends sessionsNetBIOS, RPC
4TransportEnd-to-end delivery, error checking, segmentationTCP, UDP — data unit: segment
3NetworkLogical addressing and routingIP, ICMP — data unit: packet; device: router
2Data LinkPhysical (MAC) addressing, framing, error detectionEthernet — data unit: frame; devices: switch, bridge
1PhysicalTransmits raw bits over the mediumCables, hubs, repeaters — data unit: bit

TIP: Memory trick from top to bottom — "All People Seem To Need Data Processing" (Application, Presentation, Session, Transport, Network, Data Link, Physical).

TCP/IP Model

The TCP/IP model is the practical model used by the Internet. It was developed by the US Department of Defense (ARPANET); Vint Cerf and Bob Kahn are called the fathers of the Internet for designing TCP/IP.

TCP/IP layerMatches OSI layersProtocols
ApplicationApplication + Presentation + SessionHTTP, HTTPS, FTP, SMTP, DNS, DHCP
TransportTransportTCP, UDP
InternetNetworkIP, ICMP, ARP
Network Access (Link)Data Link + PhysicalEthernet, Wi-Fi

- The TCP/IP model has 4 layers (some books show 5, splitting Network Access into Data Link and Physical)

TCP vs UDP

TCPUDP
Transmission Control ProtocolUser Datagram Protocol
Connection-oriented (handshake first)Connectionless
Reliable — confirms delivery and resends lost dataNot reliable — no confirmation
SlowerFaster
Web pages, email, file transferVideo streaming, online games, voice calls, DNS queries

Other Protocols

- IP: Internet Protocol — gives addresses and routes packets

- ICMP: used by the "ping" command to test connections

- ARP: Address Resolution Protocol — finds the MAC address for an IP address

- DHCP: automatically gives IP addresses to devices

Exam Focus

- OSI has 7 layers; TCP/IP has 4

- Router works at the Network layer; switch at the Data Link layer; hub at the Physical layer

- Encryption and compression happen at the Presentation layer

- TCP is reliable and connection-oriented; UDP is fast and connectionless

25 Internet & World Wide Web The Internet is a global network of networks that connects millions of computers using the TCP/IP protocol.

The Internet

The Internet is a global network of networks that connects millions of computers using the TCP/IP protocol.

- ARPANET (1969), a US Department of Defense project, was the first network that grew into the Internet

- Vint Cerf and Bob Kahn are called the fathers of the Internet (TCP/IP)

- Internet came to India for the public on 15 August 1995 through VSNL (Videsh Sanchar Nigam Limited)

- ISP: Internet Service Provider — a company that gives internet access (Jio, Airtel, BSNL)

World Wide Web (WWW)

- The WWW is a system of web pages linked by hyperlinks, accessed through the Internet

- Invented by Tim Berners-Lee in 1989 at CERN (Switzerland); the first website, info.cern.ch, went live in 1991

- The Web is a service that runs on the Internet; the Internet and the Web are not the same

- W3C (World Wide Web Consortium) sets web standards; founded by Tim Berners-Lee

- First web browser: WorldWideWeb (later Nexus); Mosaic (1993) was the first popular graphical browser

Web Terms

TermMeaning
Web pageA single document on the web, written in HTML
WebsiteA collection of related web pages
Home pageThe first / main page of a website
Web browserSoftware to view web pages — Chrome, Firefox, Edge, Safari
Search engineA website that finds information — Google, Bing, DuckDuckGo
HyperlinkClickable text or image that opens another page
Bookmark / FavouriteSaved link to a website
CookieSmall file a website stores in your browser to remember you
Cache (browser)Saved copies of web pages for faster loading
Web serverA computer that stores websites and sends pages to browsers

REMEMBER: Google is a search engine; Chrome is a web browser. Google was founded by Larry Page and Sergey Brin in 1998.

URL (Uniform Resource Locator)

Example: https://www.prepzen.in/current-affairs/index.html

- https — protocol

- www.prepzen.in — domain name (prepzen = second-level domain, .in = top-level domain)

- /current-affairs/index.html — path to the file

Domain Names

DomainUsed by
.comCommercial organisations
.orgNon-profit organisations
.netNetwork providers
.eduEducational institutions
.gov / .gov.inGovernment (India uses .gov.in)
.milUS military
.inIndia (country code); .uk United Kingdom; .jp Japan

IP Address and DNS

- IP address: a unique number that identifies a device on a network

- IPv4: 32-bit address, written as four numbers 0–255 (e.g. 192.168.1.1); about 4.3 billion addresses

- IPv6: 128-bit address written in hexadecimal; created because IPv4 addresses were running out

- DNS (Domain Name System): converts domain names into IP addresses — like a phone book of the internet

Types of Web and Networks

- Intranet: a private network used only inside an organisation

- Extranet: an intranet that gives limited access to outside partners such as suppliers

- Surface web: pages found by search engines; deep web: pages not indexed (net banking, email inbox); dark web: hidden sites reached with special software like Tor

- Web 1.0: read-only static web; Web 2.0: interactive and social (YouTube, Facebook); Web 3.0: semantic, decentralised web (blockchain, AI)

Exam Focus

- Tim Berners-Lee invented the WWW (1989, CERN); first website info.cern.ch

- ARPANET (1969) was the first network; VSNL brought the internet to India on 15 August 1995

- DNS converts domain names to IP addresses; IPv4 = 32 bits, IPv6 = 128 bits

- Intranet = private; extranet = private with limited outside access

26 Internet Protocols & Port Numbers A protocol is a set of rules that devices follow to communicate over a network. A port number identifies a specific service on a computer.

What is a Protocol?

A protocol is a set of rules that devices follow to communicate over a network. A port number identifies a specific service on a computer.

Important Protocols and Ports

ProtocolFull formPortUsed for
HTTPHyperText Transfer Protocol80Loading web pages (not encrypted)
HTTPSHTTP Secure443Secure web pages; uses SSL/TLS encryption — shows a padlock
FTPFile Transfer Protocol20 (data), 21 (control)Uploading and downloading files
SFTPSSH File Transfer Protocol22Secure file transfer
SSHSecure Shell22Secure remote login
TelnetTeletype Network23Remote login (not secure)
SMTPSimple Mail Transfer Protocol25 (587 for submission)Sending email
DNSDomain Name System53Converting domain names to IP addresses
DHCPDynamic Host Configuration Protocol67 / 68Giving IP addresses automatically
POP3Post Office Protocol version 3110Downloading email to one device
IMAPInternet Message Access Protocol143Reading email on the server; syncs across devices
SNMPSimple Network Management Protocol161Monitoring network devices
RDPRemote Desktop Protocol3389Remote desktop on Windows

TIP: SMTP sends mail ("S for Send"); POP3 and IMAP receive mail.

Security Protocols

- SSL: Secure Sockets Layer; TLS: Transport Layer Security (the modern successor of SSL) — encrypt data between browser and server

- HTTPS = HTTP + SSL/TLS

- IPsec: secures IP traffic, used in VPNs

- WPA2 / WPA3: Wi-Fi security protocols

Other Protocols to Know

- TCP and UDP: transport protocols

- IP: addressing and routing

- ARP: finds a MAC address from an IP address

- ICMP: error and "ping" messages

- NTP: Network Time Protocol — keeps clocks in sync (port 123)

- VoIP: Voice over Internet Protocol — phone calls over the internet (WhatsApp calls)

Exam Focus

- HTTP 80; HTTPS 443; FTP 20/21; SSH 22; Telnet 23; SMTP 25; DNS 53; POP3 110; IMAP 143

- HTTPS uses SSL/TLS; the padlock in the address bar shows a secure site

- SMTP sends; POP3/IMAP receive; IMAP keeps mail on the server

- Telnet is insecure; SSH is its secure replacement

27 Email (Electronic Mail) Email is a way of sending messages and files electronically over the internet.

About Email

Email is a way of sending messages and files electronically over the internet.

- Ray Tomlinson sent the first network email in 1971 on ARPANET and chose the "@" symbol

- Email address format: username@domain — e.g. prepzen.app@gmail.com

- An email address cannot contain spaces

Parts of an Email

PartMeaning
FromSender's email address
ToMain receiver(s)
CCCarbon Copy — others who receive a copy; all receivers can see CC addresses
BCCBlind Carbon Copy — receivers who get a copy secretly; other receivers cannot see BCC addresses
SubjectShort title of the email
BodyThe main message
AttachmentA file sent with the email (shown with a paper-clip icon)
SignatureText added automatically at the end — name, designation, phone

Email Folders and Actions

- Inbox: received emails; Outbox: emails waiting to be sent; Sent: emails already sent

- Drafts: unfinished emails saved for later

- Spam / Junk: unwanted bulk emails

- Trash / Bin: deleted emails (removed permanently after some days)

- Archive: removes an email from the inbox without deleting it

- Reply: answers only the sender; Reply All: answers the sender and all receivers; Forward: sends the email to someone new

REMEMBER: Use BCC when sending one email to many people who should not see each other's addresses.

Email Protocols

- SMTP: sends emails

- POP3: downloads emails to one device (usually removes them from the server)

- IMAP: keeps emails on the server and syncs all devices

- MIME: Multipurpose Internet Mail Extensions — lets emails carry attachments, images and non-English text

Email Services

ServiceFact
GmailGoogle's email, launched in 2004; developed by Paul Buchheit
HotmailFounded in 1996 by Sabeer Bhatia (Indian-origin) and Jack Smith; now Outlook.com
Yahoo MailLaunched in 1997
RediffmailIndian email service

- Webmail: email used inside a browser (Gmail website); email client: a program installed on the device (MS Outlook, Thunderbird)

Email Safety

- Spam: unsolicited bulk email; phishing emails trick users into sharing passwords or OTPs

- Never open attachments or links from unknown senders

- Spoofing: an email that pretends to come from someone else

Exam Focus

- Ray Tomlinson: first email (1971) and the @ sign

- CC = visible copy; BCC = hidden copy

- SMTP sends; POP3 / IMAP receive; MIME handles attachments

- Sabeer Bhatia co-founded Hotmail

28 Cyber Security Cyber security is the protection of computers, networks, data and users from attacks, damage and unauthorised access.

What is Cyber Security?

Cyber security is the protection of computers, networks, data and users from attacks, damage and unauthorised access.

Malware (Malicious Software)

TypeWhat it does
VirusAttaches itself to a file or program and spreads when that file is opened; needs user action
WormCopies itself and spreads across networks on its own, without a host file
Trojan horseLooks like a useful program but secretly harms the system or opens a backdoor
RansomwareLocks or encrypts files and demands money (ransom) to unlock them — e.g. WannaCry (2017)
SpywareSecretly collects the user's information
KeyloggerRecords every key pressed to steal passwords
AdwareShows unwanted advertisements
RootkitHides deep in the system to give attackers control
BotnetA network of infected computers ("bots/zombies") controlled by an attacker
Logic bombMalicious code that activates when a condition or date is reached

REMEMBER: Creeper (1971) is considered the first computer virus/worm. Brain (1986) was the first virus for MS-DOS PCs.

Online Frauds and Attacks

AttackMeaning
PhishingFake emails or websites that trick people into giving passwords, card or bank details
VishingVoice phishing — fraud phone calls (fake bank officer asking for OTP)
SmishingSMS phishing — fraud text messages with links
PharmingRedirecting users from a real website to a fake one
SpoofingPretending to be a trusted source (fake email, caller ID or website)
DoS / DDoS(Distributed) Denial of Service — flooding a server with traffic so it stops working
Man-in-the-middleSecretly intercepting communication between two parties
Social engineeringTricking people psychologically into giving information
SQL injectionInserting harmful code into a website's database query
Identity theftStealing someone's personal details to commit fraud
HackingGaining unauthorised access; ethical (white-hat) hackers test security legally

Protection Methods

- Antivirus: detects and removes malware — e.g. Quick Heal (Indian), Norton, McAfee, Kaspersky

- Firewall: hardware or software that blocks unauthorised network traffic

- Encryption: converting readable plain text into unreadable cipher text; decryption reverses it

- Two-factor / multi-factor authentication (2FA/MFA): password + OTP or fingerprint

- Strong passwords, regular software updates (patches), backups

- CAPTCHA: test that tells humans and bots apart

- Digital signature: proves who sent a document and that it was not changed

- VPN: secure encrypted connection over public networks

Cyber Security in India

- IT Act, 2000: India's main cyber law (amended in 2008); Section 66 covers computer-related offences

- CERT-In: Indian Computer Emergency Response Team — national agency for cyber incidents, under MeitY

- I4C: Indian Cyber Crime Coordination Centre — under the Ministry of Home Affairs

- Cyber crime helpline number 1930; complaints at cybercrime.gov.in

- Digital Personal Data Protection (DPDP) Act, 2023: protects personal data

Exam Focus

- Virus needs a host file; worm spreads on its own; Trojan disguises itself

- Phishing = email; vishing = voice call; smishing = SMS

- Firewall blocks unauthorised access; encryption turns plain text into cipher text

- CERT-In is India's national cyber-incident agency; helpline 1930

29 File Extensions A file extension is the part of a file name after the last dot. It tells the computer which type of file it is and which program opens it. Example: re…

What is a File Extension?

A file extension is the part of a file name after the last dot. It tells the computer which type of file it is and which program opens it. Example: report.docx → extension .docx

Documents and Office Files

ExtensionFile type
.docx / .docMS Word document
.xlsx / .xlsMS Excel workbook
.pptx / .pptMS PowerPoint presentation
.accdb / .mdbMS Access database
.pdfPortable Document Format (Adobe)
.txtPlain text (Notepad)
.rtfRich Text Format
.csvComma-Separated Values
.odt / .ods / .odpOpenDocument text / spreadsheet / presentation (LibreOffice)

Images

ExtensionFile type
.jpg / .jpegJoint Photographic Experts Group — compressed photos
.pngPortable Network Graphics — lossless, supports transparency
.gifGraphics Interchange Format — supports simple animation
.bmpBitmap image (uncompressed)
.tiff / .tifTagged Image File Format — high-quality printing
.svgScalable Vector Graphics — does not blur when enlarged
.psdAdobe Photoshop document
.webpWeb image format by Google

Audio and Video

ExtensionFile type
.mp3MPEG-1 Audio Layer 3 — compressed audio
.wavWaveform audio (uncompressed)
.aac / .m4aAdvanced Audio Coding
.mp4MPEG-4 video
.aviAudio Video Interleave (Microsoft)
.mkvMatroska video
.movApple QuickTime video
.wmvWindows Media Video

Programs, Web and Compressed Files

ExtensionFile type
.exeExecutable program (Windows)
.batBatch file (Windows commands)
.dllDynamic Link Library
.apkAndroid app package
.html / .htmWeb page
.cssStyle sheet for web pages
.jsJavaScript
.phpPHP web script
.pyPython program
.java / .classJava source / compiled class
.c / .cppC / C++ program
.zip / .rar / .7zCompressed archive
.isoDisc image
.tmpTemporary file
.bakBackup file
.sysSystem file

REMEMBER: JPG uses lossy compression (some quality lost); PNG uses lossless compression. GIF supports animation.

Exam Focus

- .exe = executable program; .apk = Android app; .dll = library

- .jpg photos; .png lossless with transparency; .gif animation

- .mp3 audio; .mp4 video; .zip / .rar compressed files

- .txt Notepad; .csv comma-separated data; .pdf Adobe document

30 Computer Abbreviations - CAPTCHA, ASCII, EBCDIC, BIOS and SMPS are frequently asked full forms

Hardware and Memory

AbbreviationFull form
ALUArithmetic Logic Unit
CPUCentral Processing Unit
CUControl Unit
GPUGraphics Processing Unit
RAMRandom Access Memory
ROMRead Only Memory
SRAM / DRAMStatic / Dynamic Random Access Memory
PROMProgrammable Read Only Memory
EPROMErasable Programmable Read Only Memory
EEPROMElectrically Erasable Programmable Read Only Memory
HDDHard Disk Drive
SSDSolid State Drive
CDCompact Disc
DVDDigital Versatile Disc
USBUniversal Serial Bus
BIOSBasic Input Output System
UEFIUnified Extensible Firmware Interface
CMOSComplementary Metal Oxide Semiconductor
POSTPower-On Self-Test
SMPSSwitched-Mode Power Supply
UPSUninterruptible Power Supply
VDUVisual Display Unit
LCDLiquid Crystal Display
LEDLight Emitting Diode
CRTCathode Ray Tube
VGAVideo Graphics Array
HDMIHigh-Definition Multimedia Interface
NICNetwork Interface Card
MICRMagnetic Ink Character Recognition
OCROptical Character Recognition
OMROptical Mark Reader / Recognition
BCRBar Code Reader
RFIDRadio Frequency Identification
DPIDots Per Inch
PPMPages Per Minute
CPSCharacters Per Second
RPMRevolutions Per Minute
MIPSMillion Instructions Per Second
FLOPSFloating Point Operations Per Second
ICIntegrated Circuit
VLSIVery Large Scale Integration
ULSIUltra Large Scale Integration

Software and Programming

AbbreviationFull form
OSOperating System
GUIGraphical User Interface
CLICommand Line Interface
DOSDisk Operating System
NTFSNew Technology File System
FATFile Allocation Table
EULAEnd User Licence Agreement
HTMLHyperText Markup Language
XMLeXtensible Markup Language
CSSCascading Style Sheets
SQLStructured Query Language
DBMSDatabase Management System
RDBMSRelational Database Management System
COBOLCommon Business-Oriented Language
FORTRANFormula Translation
BASICBeginner's All-purpose Symbolic Instruction Code
OOPObject-Oriented Programming
IDEIntegrated Development Environment
APIApplication Programming Interface
ASCIIAmerican Standard Code for Information Interchange
EBCDICExtended Binary Coded Decimal Interchange Code
BCDBinary Coded Decimal
PDFPortable Document Format
JPEGJoint Photographic Experts Group
GIFGraphics Interchange Format
PNGPortable Network Graphics
MPEGMoving Picture Experts Group
VBAVisual Basic for Applications

Internet and Networking

AbbreviationFull form
WWWWorld Wide Web
URLUniform Resource Locator
HTTPHyperText Transfer Protocol
HTTPSHyperText Transfer Protocol Secure
FTPFile Transfer Protocol
SMTPSimple Mail Transfer Protocol
POPPost Office Protocol
IMAPInternet Message Access Protocol
TCPTransmission Control Protocol
IPInternet Protocol
UDPUser Datagram Protocol
DNSDomain Name System
DHCPDynamic Host Configuration Protocol
ARPAddress Resolution Protocol
ISPInternet Service Provider
LANLocal Area Network
MANMetropolitan Area Network
WANWide Area Network
PANPersonal Area Network
VPNVirtual Private Network
Wi-FiWireless Fidelity
MACMedia Access Control
OSIOpen Systems Interconnection
ARPANETAdvanced Research Projects Agency Network
VoIPVoice over Internet Protocol
SSL / TLSSecure Sockets Layer / Transport Layer Security
SSHSecure Shell
MIMEMultipurpose Internet Mail Extensions
CC / BCCCarbon Copy / Blind Carbon Copy
SEOSearch Engine Optimisation
W3CWorld Wide Web Consortium
IoTInternet of Things
5GFifth Generation (mobile network)
LTELong Term Evolution
GPSGlobal Positioning System
NFCNear Field Communication

Security, Cloud and Others

AbbreviationFull form
CERT-InIndian Computer Emergency Response Team
DDoSDistributed Denial of Service
OTPOne-Time Password
PINPersonal Identification Number
2FA / MFATwo-Factor / Multi-Factor Authentication
CAPTCHACompletely Automated Public Turing test to tell Computers and Humans Apart
AIArtificial Intelligence
MLMachine Learning
AR / VRAugmented Reality / Virtual Reality
IaaSInfrastructure as a Service
PaaSPlatform as a Service
SaaSSoftware as a Service
ERPEnterprise Resource Planning
CRMCustomer Relationship Management
ICTInformation and Communication Technology
C-DACCentre for Development of Advanced Computing
MeitYMinistry of Electronics and Information Technology
NIC (Govt.)National Informatics Centre

Exam Focus

- CAPTCHA, ASCII, EBCDIC, BIOS and SMPS are frequently asked full forms

- UPS keeps a computer running during a power cut; SMPS converts AC to DC inside the cabinet

- NIC can mean Network Interface Card or National Informatics Centre (Government of India)

31 Cloud Computing & Emerging Technologies Cloud computing means using computing services — storage, servers, software, databases — over the internet instead of on your own computer. You pay on…

Cloud Computing

Cloud computing means using computing services — storage, servers, software, databases — over the internet instead of on your own computer. You pay only for what you use.

Service Models

ModelFull formWhat you getExamples
IaaSInfrastructure as a ServiceVirtual servers, storage and networksAmazon EC2 (AWS), Microsoft Azure VMs, Google Compute Engine
PaaSPlatform as a ServiceA ready platform to build and run appsGoogle App Engine, Heroku
SaaSSoftware as a ServiceReady-to-use software in a browserGmail, Google Docs, Microsoft 365, Zoom

Deployment Models

- Public cloud: shared by many customers over the internet (AWS, Azure, Google Cloud)

- Private cloud: used by a single organisation

- Hybrid cloud: a mix of public and private clouds

- Community cloud: shared by organisations with common needs

- MeghRaj: the Government of India's cloud computing initiative

Artificial Intelligence (AI)

- AI is the ability of machines to perform tasks that need human intelligence — learning, reasoning, understanding language

- The term "Artificial Intelligence" was coined by John McCarthy in 1956; he is called the father of AI

- Machine Learning (ML): systems learn from data without being explicitly programmed

- Deep Learning: ML using many-layered artificial neural networks

- Generative AI: creates new text, images or audio — e.g. ChatGPT, Gemini, Claude

- NLP (Natural Language Processing): machines understanding human language; chatbots use NLP

- IndiaAI Mission (2024): Government of India mission to build AI capacity

Other Emerging Technologies

TechnologyKey facts
Internet of Things (IoT)Everyday devices connected to the internet (smart meters, smart watches); term coined by Kevin Ashton (1999)
BlockchainA shared, tamper-proof digital ledger of records (blocks); basis of Bitcoin, introduced by "Satoshi Nakamoto" (2008)
Big DataVery large data sets; described by the 3 Vs — Volume, Velocity, Variety
Augmented Reality (AR)Adds digital objects to the real world (Pokémon Go, Snapchat filters)
Virtual Reality (VR)A fully computer-made 3D world seen through a headset
Quantum computingUses qubits, which can be 0 and 1 at the same time; India's National Quantum Mission was approved in 2023
5GFifth-generation mobile network — very high speed and low delay; launched in India on 1 October 2022
Edge computingProcessing data near where it is produced instead of a far-away data centre
RoboticsMachines that do tasks automatically; robots in factories, surgery and delivery
Drones (UAV)Unmanned Aerial Vehicles used for mapping, delivery and agriculture
CryptocurrencyDigital money secured by cryptography (Bitcoin, Ethereum); not legal tender in India
CBDCCentral Bank Digital Currency — India's Digital Rupee (e₹) by RBI, piloted from 2022

Exam Focus

- IaaS, PaaS, SaaS: Gmail and Google Docs are SaaS

- John McCarthy coined "AI" (1956); Kevin Ashton coined "IoT" (1999)

- Blockchain is a distributed ledger; Bitcoin by Satoshi Nakamoto

- 5G launched in India on 1 October 2022; MeghRaj is the government cloud initiative

32 Banking & Digital Payment Technology - CBS lets customers use their account from any branch of the bank, because all branches share one central database

Core Banking Solution (CBS)

- CBS lets customers use their account from any branch of the bank, because all branches share one central database

- "CORE" is often expanded as Centralised Online Real-time Exchange

- Popular CBS software: Finacle (Infosys), Flexcube (Oracle), BaNCS (TCS)

Fund Transfer Systems

SystemFull formKey facts
NEFTNational Electronic Funds TransferSettles in half-hourly batches; available 24×7 since December 2019; no minimum amount; run by RBI
RTGSReal Time Gross SettlementInstant, one-by-one settlement; minimum ₹2 lakh; 24×7 since December 2020; run by RBI
IMPSImmediate Payment ServiceInstant transfer 24×7 using account + IFSC or mobile number + MMID; run by NPCI
UPIUnified Payments InterfaceInstant mobile payments using a virtual payment address (UPI ID) or QR code; launched by NPCI in 2016

REMEMBER: NEFT and RTGS are operated by the RBI; IMPS, UPI, RuPay, NACH, AePS and BHIM are run by NPCI (National Payments Corporation of India, set up in 2008, Mumbai).

NPCI Products

- UPI: launched in April 2016; UPI Lite for small payments; UPI 123PAY for feature phones without internet

- BHIM: Bharat Interface for Money — UPI app launched in December 2016

- RuPay: India's own card payment network (launched 2012)

- NACH: National Automated Clearing House — bulk payments such as salaries, EMIs, subsidies

- AePS: Aadhaar Enabled Payment System — banking with Aadhaar number and fingerprint at micro-ATMs

- NETC FASTag: electronic toll collection using RFID

- BBPS: Bharat Bill Payment System — paying electricity, water and phone bills

Bank Codes

CodeLengthUse
IFSC11 characters (alphanumeric)Identifies a bank branch for NEFT, RTGS, IMPS; first 4 letters = bank, 5th character = 0, last 6 = branch
MICR9 digitsPrinted on cheques; identifies city, bank and branch for cheque clearing
SWIFT / BIC8 or 11 charactersInternational bank transfers

Cheques and Clearing

- CTS: Cheque Truncation System — cheque images are sent electronically instead of moving the paper cheque

- Cheques are read by MICR machines; CTS-2010 is the standard cheque format

- Positive Pay System: the customer confirms the details of a high-value cheque in advance to prevent fraud

ATMs, Cards and Digital Channels

- ATM: Automated Teller Machine; White Label ATMs are run by non-bank companies authorised by RBI; Brown Label ATMs are owned by a service provider but carry a bank's brand

- Micro-ATM: handheld device used by banking correspondents in villages

- POS: Point of Sale terminal for card payments in shops; NFC enables tap-to-pay

- Card security: PIN (4 or 6 digits), CVV (3 digits on the back), EMV chip

- Net banking, mobile banking and Internet banking let customers bank online

- e-RUPI: prepaid digital voucher for specific purposes, launched in 2021

- Digital Rupee (e₹): RBI's Central Bank Digital Currency, piloted from 2022

Exam Focus

- RTGS minimum ₹2 lakh; NEFT has no minimum; both 24×7

- NPCI runs UPI, IMPS, RuPay, NACH, AePS, BHIM, FASTag (NETC)

- IFSC = 11 characters; MICR = 9 digits

- CTS sends cheque images electronically; Finacle is Infosys's CBS software

Technology current affairs

More technology news →

Quick topics

LEARNING DOESN'T STOP HERE

Your daily study circle.

Study notes, quick revision and practice.
Choose where you follow PrepZen.