Year 11 Computer Education Study Guide

Structure and Functions of a Computer

Definition of a Computer: An electronic device operating under the control of instructions stored in its own memory that accepts input data, processes data according to defined rules, produces output as useful information, and stores results for future use.
Hardware versus Software:
- Hardware: Physical machinery, components, and equipment comprising the computer system (e.g., monitor, keyboard, processor, printer, chassis).
- Software: Computer programs and abstract collections of instructions that direct hardware to perform specific tasks (e.g., Word, Excel, Access).
Fundamental Definitions:
- Data: Unprocessed, raw facts, figures, symbols, images, or sound signals lacking context.
- Information: Data that has been manipulated, structured, organized, and formatted to be meaningful, useful, and actionable.
- System: A set of interrelated parts functioning together to achieve a specific common objective.
Major Functions and Information Flow:
- Input Unit: Accepts instructions and raw data from users, storage, or external devices and translates them into machine-readable form.
- Processing Unit (CPU): Executes program instructions, performs calculations, and processes data into results.
- Output Unit: Translates machine-processed information into human-readable hard copy or soft copy form.
- Storage Unit: Retains data, instructions, and information permanently or temporarily for future retrieval.

Flow of Information

Hardware Components

Hardware Components of a Computer System

Input Devices

Input Category Classification:
- Keyboard Entry: Data is manually typed into the system using a key-based input device.
- Direct Entry: Data is read directly from source documents or captured from the environment without manual keying, reducing human error and operational cost.
Keyboard Layout and Design:
- Standard QWERTY Layout: Named after the first six letters on the top alphabetic line.
- Key Types:
- Escape Key ( $\text{Esc}$ ): Cancels current selections or commands.
- Function Keys ( $\text{F1}$ to $\text{F12}$ ): Execute specific software shortcuts.
- Typewriter Keys: Main alphanumeric character keys.
- Numeric Keypad: Dedicated block for entering numbers, arithmetic operators, or controlling cursors.
- Toggle Keys: Switches a hardware feature on or off (e.g., Caps Lock, Num Lock).
- Combination Keys: Executes shortcuts when held down simultaneously with another key (e.g., $\text{Ctrl}$ , $\text{Alt}$ ).
- Navigation Keys: Controls cursor or insertion point positioning.
- Multimedia Controls: Adjusts media playback and audio levels.
- Keyboard Varieties:
- Traditional Keyboards: Full-sized, rigid, rectangular desktop keyboards.
- Flexible Keyboards: Soft, rollable/foldable keyboards designed for portable mobile use.
- Ergonomic Keyboards: V-shaped or split layout with integrated palm rests designed to minimize wrist strain and repetitive motion injuries.
- Wireless Keyboards: Battery-powered devices transmitting data via radio frequency ( $\text{RF}$ ) or infrared signals.
- Personal Digital Assistant ( $\text{PDA}$ ) Keyboards: Miniature attached or integrated keypads.
Direct Entry Pointing Devices:
- Mouse Types:
- Mechanical Mouse: Features a rolling metal or rubber ball on the underside connected via a physical cord.
- Optical Mouse: Emits and senses light beams to detect positional movement.
- Wireless Mouse: Battery-operated pointing device communicating via radio or infrared signals.
- Joystick: Vertical lever controlling speed, direction, and pressure in gaming environments.
- Touch Screen: Monitor overlay containing invisible crisscrossed infrared light beams or capacitive sensors detecting finger presses.
- Game Controllers: Specialized gaming inputs including joysticks, dance pads (pressure-sensitive floor mats), gamepads (held with both hands for multi-axis control), and motion-sensing devices (capturing physical spatial body movement).
- Light Pen: Photoelectric pen-like sensor pressed directly against a $\text{CRT}$ display to complete a circuit and detect coordinate locations.
- Stylus: Pen-shaped instrument using pressure to write or draw on specialized screens via handwriting recognition software.
- Digitizer: Tablet board capturing physical drawings or traced photographs and converting coordinate points into digital vector graphics.
Direct Entry Scanning Devices:
- Optical Scanners: Converts physical photos or text into machine-readable digital bitmap files (Flatbed and Portable variants).
- Bar Code Readers: Photoelectric devices reading vertical zebra-striped patterns; widely used in retail via the Universal Product Code ( $\text{UPC}$ ) linked to Point of Sale ( $\text{POS}$ ) systems.
- Radio-Frequency Identification ( $\text{RFID}$ ) Readers: Scans embedded $\text{RFID}$ microchips wirelessly across distances of several yards.
- Character and Mark Recognition Devices:
- Magnetic Ink Character Recognition ( $\text{MICR}$ ): Used by banking institutions to read magnetized particle numbers at the bottom of cheques using reader/sorter units.
- Optical Character Recognition ( $\text{OCR}$ ): Light-based handheld wand or flatbed devices reading pre-printed character fonts.
- Optical Mark Recognition ( $\text{OMR}$ ): Senses the presence or absence of pencil marks on standardized multiple-choice answer sheets.
Image Capturing and Audio Input Devices:
- Digital Cameras & Video Cameras: Capture still images or motion video directly onto internal flash memory or memory cards.
- Webcams: Specialized continuous video capture devices sending feeds over internet networks.
- Voice Input / Speech Recognition: Converts vocal audio frequencies captured via microphones into digital code patterns matched against stored audio models.
- Musical Instrument Digital Interface ( $\text{MIDI}$ ): Interface standard and port allowing electronic instruments to transmit synthesized performance data to computers.

Output Devices

Output Forms: Soft copy (transient screen display or audio output) and Hard copy (permanent paper output).
Display Monitors:
- Cathode Ray Tube ( $\text{CRT}$ ): Bulky, heavy, high power consumption, inexpensive glass-tube displays.
- Liquid Crystal Display ( $\text{LCD}$ ): Flat-panel display manipulating light through liquid crystal cells via Thin Film Transistor ( $\text{TFT}$ ) technology; compact, lightweight, low radiation.
- Plasma Displays: Matrix of miniature gas-filled cells illuminated by electrical luminescence; high contrast, flat profile.
- Digital and Interactive Whiteboards: Large display boards connected to computers controlled via electronic pens or touch interaction.
- High-Definition Television ( $\text{HDTV}$ ): Digital wide-screen monitors outputting high pixel resolutions.
- E-Book Readers: Handheld display units optimized for reading digital books, newspapers, and periodicals.
Printers:
- Impact Printers: Mechanical pins or character wheels striking an ink ribbon against paper; capable of printing multi-part carbon forms; noisy.
- Line Printers: High-speed text-only printers (e.g., Daisy Wheel).
- Character Printers: Prints individual characters sequentially; includes Dot Matrix printers forming characters via matrix pin patterns.
- Non-Impact Printers: Quiet operation, cannot produce multi-part carbon copies.
- Laser Printers: Uses a laser beam to create electrostatic charges attracting dry toner powder to paper; high speed and quality.
- Inkjet Printers: Sprays fine droplets of liquid ink onto paper; affordable color printing.
- Thermal Printers: Uses heated dot-matrix pins pressing against heat-sensitive paper or wax ribbons; common in $\text{POS}$ receipt printers.
- $\text{3-D}$ Printers: Additive manufacturing devices depositing thin material layers sequentially to form solid three-dimensional objects.
- Cloud Printers: Internet-connected printing units receiving jobs remotely (e.g., Google Cloud Print).
Plotters: High-precision line-drawing output devices used for Computer-Aided Design ( $\text{CAD}$ ) blueprints and architectural graphics.
- Types: Pen Plotters (moving physical ink pens over paper), Inkjet Plotters, Electrostatic Plotters (charging specialized paper), and Direct Image Thermal Plotters.
Voice-Output Devices: Synthesizers and speakers converting digital audio data into prerecorded or generated vocal speech.

System Unit

Definition: The main enclosure (chassis or system cabinet) housing the primary processing components, power supply, and internal peripheral connections.

System Unit Back Panel Ports

Motherboard (System Board): The central printed circuit board ( $\text{PCB}$ ) containing sockets, slots, and buses connecting all hardware components.
Microprocessor (Central Processing Unit / $\text{CPU}$ ):
- Primary Manufacturers: Intel and AMD.
- Word Size Capacity: The number of bits processed simultaneously ( $8$ , $16$ , $32$ , or $64$ \text{ bits}).
- A $16\text{-bit}$ word accesses $2\,\text{bytes}$ at a time (since $1\,\text{byte} = 8\,\text{bits}$ ).
- A $64\text{-bit}$ word accesses $8\,\text{bytes}$ at a time.
- Internal CPU Structure:
- Control Unit ( $\text{CU}$ ): Fetches instructions from primary memory, decodes them, and coordinates the flow of electronic signals across the system.
- Arithmetic Logic Unit ( $\text{ALU}$ ): Performs arithmetic calculations ( $+$ , $-$ , $\times$ , $\div$ ) and logical comparisons ( $<$ , $>$ , $=$ ).
- Registers: Ultra-fast temporary internal storage locations inside the CPU.
System Memory (Primary Storage):
- Random Access Memory ( $\text{RAM}$ ): Volatile primary memory holding active data and instructions.
- Cache Memory: High-speed static $\text{RAM}$ buffer residing between main memory and CPU.
- Flash Memory: Non-volatile solid-state $\text{RAM}$ used in mobile units.
- Virtual Memory: Hard drive space allocated by the operating system to extend physical $\text{RAM}$ capacity.
- Variants: $\text{DRAM}$ , $\text{SDRAM}$ , $\text{DDR SDRAM}$ , $\text{Direct RDRAM}$ .
- Read-Only Memory ( $\text{ROM}$ ): Non-volatile permanent firmware holding startup routines ( $\text{ROM BIOS}$ ). Variations include $\text{PROM}$ , $\text{EPROM}$ , and $\text{EEPROM}$ .
- Complementary Metal-Oxide Semiconductor ( $\text{CMOS}$ ): Battery-powered chip retaining clock time, date, and hardware configuration details.
Memory Measurement Standards:
- Bit ( $\text{b}$ ): Single binary digit ( $0$ or $1$ ).
- Nibble: Group of $4\,\text{bits}$ .
- Byte ( $\text{B}$ ): Group of $8\,\text{bits}$ ; represents a single character.
- Kilobyte ( $\text{KB}$ ): $2^{10}\,\text{bytes} = 1024\,\text{bytes}$ .
- Megabyte ( $\text{MB}$ ): $2^{10}\,\text{KB} = 1,048,576\,\text{bytes}$ .
- Gigabyte ( $\text{GB}$ ): $2^{10}\,\text{MB} = 1,073,741,824\,\text{bytes}$ .
- Terabyte ( $\text{TB}$ ): $2^{10}\,\text{GB} = 1,099,511,627,776\,\text{bytes}$ .
System Clock: Quartz crystal circuit emitting steady timing pulses measuring CPU execution cycles in Hertz ( $\text{Hz}$ ), Megahertz ( $\text{MHz}$ ), or Gigahertz ( $\text{GHz}$ ).
- Execution Example: A $2.5\,\text{GHz}$ CPU executes approximately $2.5 \times 10^9\,\text{cycles per second}$ .
Buses and Expansion Slots:
- Buses: Internal electrical pathways transferring binary data between CPU, memory, and peripheral controllers.
- Standard Ports: Serial (DB-9/DB-25, 1 bit sequentially), Parallel (DB-25, multiple bits simultaneously), Universal Serial Bus ( $\text{USB}$ ), FireWire ( $\text{HPSB}$ ).
- Specialized Ports: $\text{MIDI}$ (audio instruments), $\text{SCSI}$ (high-speed parallel daisy-chaining), $\text{IrDA}$ (infrared wireless transmission).
- Expansion Cards: Circuit boards plugged into motherboard expansion slots to provide auxiliary interfaces (graphics cards, sound cards, network interface cards).

Secondary Storage

Non-volatile storage holding data, programs, and files permanently outside primary memory.
Hard Disk Drives ( $\text{HDD}$ ):
- Rigid metallic platters coated with magnetic material rotated on a spindle, read/written by electromagnetic heads.
- Head Crash: Catastrophic failure occurring when a read/write head touches the platter surface, permanently destroying magnetic data.
- Configurations: Internal Hard Disks, External Hard-Disk Drives, Hard Disk Cartridges, Removable Drive Systems, Hard Disk Packs.
Optical Storage Media:
- Read and written using focused laser beams burning and detecting microscopic pits and lands.
- Compact Disc ( $\text{CD}$ ): $650\,\text{MB}$ to $700\,\text{MB}$ capacity ( $72\,\text{minutes}$ audio/video).
- $\text{CD-ROM}$ : Read-Only Memory.
- $\text{CD-R}$ : Write-Once Read-Many ( $\text{WORM}$ ).
- $\text{CD-RW}$ : Rewritable optical disc using magnetic-optical phase changes.
- Digital Versatile Disc ( $\text{DVD}$ ): $4.7\,\text{GB}$ per layer/side up to $17\,\text{GB}$ capacity.
- Blu-ray Disc ( $\text{BD}$ ): Uses blue-violet laser beams; $25\,\text{GB}$ single-layer, $50\,\text{GB}$ dual-layer capacity.
Solid-State Storage:
- Non-volatile semiconductor storage with no moving parts; shock-resistant, fast access, low power.
- Types: $\text{USB}$ Flash Drives, Flash Memory Cards, CompactFlash ( $\text{CF}$ ), MultiMediaCard ( $\text{MMC}$ ), Solid-State Drives ( $\text{SSD}$ ).
Magnetic Tape: Sequential access medium stored on reels or cartridges; highly cost-effective for enterprise archival backups (e.g., Digital Audio Tape / $\text{DAT}$ ).

Categories of Computers

Microcomputers (Personal Computers / $\text{PCs}$ ):
- General-purpose desktop or portable systems processing approximately $1 \times 10^9\,\text{operations per second}$ .
- Sub-categories: Desktop $\text{PCs}$ , Notebooks/Laptops, Ultrabooks (ultraportable mini notebooks), Tablets, Handheld/Palmtops ( $\text{PDAs}$ , Smartphones).
Servers: Dedicated network hardware running server software (File, Mail, Database, Print, Web servers) providing centralized resource sharing for connected clients.
Supercomputers: The fastest, largest, most expensive systems capable of processing over $1 \times 10^{15}\,\text{floating-point operations per second}$ ( $1\,\text{PFLOPS}$ ).
- Applications: Weather forecasting, nuclear simulation, space exploration, oil discovery.
- Notable Benchmarks:
- Sunway TaihuLight ( $93.01\,\text{PFLOPS}$ , Wuxi, China)
- NUDT Tianhe-2 ( $33.86\,\text{PFLOPS}$ , Guangzhou, China)
- Cray Titan ( $17.59\,\text{PFLOPS}$ , Oak Ridge, USA)
- IBM Sequoia ( $17.17\,\text{PFLOPS}$ , Livermore, USA)
- Fujitsu K computer ( $10.51\,\text{PFLOPS}$ , Kobe, Japan)

Health and Safety Issues

Ergonomics

Definition: The scientific study of designing and arranging equipment and workplaces to optimize human well-being, safety, efficiency, and performance.

Ergonomic Workstation Layout

Physical Health Factors and Mitigation Strategies:
- Eyestrain and Headaches:
- Take a $15\,\text{minute}$ rest break every $1\text{ to }2\,\text{hours}$ .
- Position screens to eliminate glare from windows and overhead lighting.
- Install glare shields and keep screens free of dust.
- Maintain equal focal distances between document holders and screens.
- Back and Neck Pain:
- Use fully adjustable ergonomic chairs with lumbar support.
- Position monitor tops at or slightly below eye level.
- Repetitive Strain Injury ( $\text{RSI}$ ) / Cumulative Trauma Disorder:
- Caused by repetitive high-speed wrist, hand, or arm movements.
- Carpal Tunnel Syndrome: Damage to wrist nerves and tendons caused by improper typing posture.
- Electromagnetic Fields ( $\text{EMFs}$ ):
- Prudent Avoidance: Sit at least $2\,\text{feet}$ ( $0.6\,\text{m}$ ) from the computer screen and $3\,\text{feet}$ ( $0.9\,\text{m}$ ) away from the sides/back of adjacent monitors.
Mental Health Factors:
- Noise Control: Use head-mounted earphones/microphones, acoustical office tiles, and sound-muffling printer covers.
- Techno-stress: Mental stress and fatigue resulting from adapting to rapid technological changes or continuous electronic employee surveillance.

Workplace Safety Rules

General Workplace Precautions:
- Remove watches and jewelry; tie back loose clothing.
- Turn off and disconnect power cables before servicing internal hardware.
- Apply protective tape over sharp chassis edges inside computer cases.
- Never disassemble power supply units or $\text{CRT}$ displays due to high voltage retention.
- Keep food, liquids, and clutter away from computer equipment.
- Bend knees when lifting heavy desktop equipment to avoid lumbar injury.
Fire Safety & Extinguisher Operation:
- Extinguisher Operation Acronym ( $\text{P-A-S-S}$ ):

Operation of Extinguisher PASS Method

P: Pull the pin.
A: Aim low at the base of the fire.
S: Squeeze the lever.
S: Sweep the nozzle from side to side.
- Power Fluctuations:
Blackout: Complete loss of electrical power.
Brownout: Prolonged reduction in line voltage below $80\%$ of normal levels.
Line Noise: Electrical interference from lightning or industrial generators.
Spike: Instantaneous voltage surge exceeding $100\%$ of normal voltage.
Power Surge: Brief dramatic increase in line voltage lasting nanoseconds.
Protective Hardware:
- Surge Suppressor: Diverts excess transient voltage directly to ground.
- Uninterruptible Power Supply ( $\text{UPS}$ ): Battery-backed inverter system providing continuous filtered power during blackouts. Warning: Never plug laser printers into a $\text{UPS}$ as heating elements overload battery circuits.
- Standby Power Supply ( $\text{SPS}$ ): Battery system that switches on when line voltage drops below thresholds.
- Equipment Disposal Procedures:
Heavy Metal Hazards: Computer components contain lead, cadmium, mercury, chromium, and beryllium.
$\text{CRT}$ Displays: Contain approximately $4\,\text{lbs}$ ( $1.8\,\text{kg}$ ) of toxic lead within glass tubes.
Chemical Waste: Solvent cans and toner cartridges must be recycled through certified e-waste facilities to prevent environmental leaching.

Green Computing

Definition: The environmentally responsible and sustainable design, manufacture, use, and disposal of computers, servers, and associated peripheral devices.
Core Lifecycle Pillars:
- Green Design: Constructing energy-efficient hardware, components, and eco-friendly data centers.
- Green Manufacturing: Producing electronic components with minimal environmental impact and non-toxic materials.
- Green Use: Reducing power consumption of operational computers and executing software efficiently.
- Green Disposal: Reusing, refurbishing, and recycling out-of-service electronics ( $\text{e-waste}$ ) to keep heavy metals out of landfills.
Examples of Green Innovations:
- Blackle: Search engine displaying a black background; reduces monitor power draw from $74\,\text{W}$ (white screen) down to $59\,\text{W}$ .
- Fit-PC: Miniature low-power desktop drawing only $5\,\text{W}$ of electricity.
- Sun Ray Thin Client: Desktop terminal drawing $4\text{ to }8\,\text{W}$ , offloading heavy computations to a centralized server.
Strategies for Energy Reduction:
- Configure Operating System Power Management: Monitor sleep ( $\le 15\,\text{minutes}$ ), hard drive sleep ( $\le 15\,\text{minutes}$ ), system standby ( $\le 30\,\text{minutes}$ ).
- Shut down equipment when idle overnight.
- Avoid high-energy screen savers; lower monitor display brightness.
- Use power strips to eliminate "phantom" or standby power draw.
Resource Conservation (The 4 R's):
- Reduce: Decrease raw material and paper consumption (e.g., double-sided printing, digital document storage).
- Reuse / Refurbish: Repair, upgrade, or repurpose older computer hardware.
- Recycle: Reclaim raw base materials (glass, copper, gold, plastic) from obsolete components.
- Replace: Upgrade obsolete $\text{CRT}$ displays to energy-efficient $\text{LCD}$ or $\text{LED}$ monitors containing no mercury backlights.

Software

Definition: The set of electronic instructions or programs directing computer hardware to execute processing tasks.
Primary Categories:
- System Software: Background programs managing hardware resources and providing a platform for application programs.
- Application Software: Programs performing specific end-user tasks.

System Software

Four Main Types:
1. Operating Systems ( $\text{OS}$ ): Coordinates computer resources, manages files, handles hardware $\text{I/O}$ , and executes applications.
2. Utilities: Service programs carrying out specialized resource management tasks.
3. Device Drivers: Specialized interface programs enabling communication between operating systems and hardware peripherals.
4. Language Translators: Translates high-level programming code into machine language ( $0\text{s and }1\text{s}$ ).
Operating System Execution Features:
- Booting: Cold Boot (powering on a completely turned-off computer) versus Warm Boot (restarting without turning off primary power via $\text{Ctrl}+\text{Alt}+\text{Delete}$ or reset button).
- User Interfaces: Command-Line Interface ( $\text{CLI}$ ) requiring typed commands versus Graphical User Interface ( $\text{GUI}$ ) using visual desktop environments.
- $\text{GUI}$ Components: Icons, Pointers, Windows, Menus, Dialog Boxes, Toolbars, Ribbons.
- $\text{OS}$ Categories:
- Stand-Alone / Client $\text{OS}$ : Windows 10, Mac OS X, Linux.
- Network Operating System ( $\text{NOS}$ ): Windows Server, $\text{UNIX}$ , Linux, NetWare, Cisco $\text{IOS}$ .
- Embedded $\text{OS}$ : Mobile and smart device systems (Android, iOS, Windows $\text{CE}$ , Symbian).
Utility Programs:
- Diagnostic / Troubleshooting Programs: Identifies and repairs hardware/software problems.
- Antivirus Software: Scans for, isolates, and removes malicious code/viruses.
- Uninstaller Utilities: Safely removes applications and associated registry entries.
- Backup Utilities: Creates redundant file copies for disaster recovery.
- File Compression Utilities: Reduces file storage size using compression algorithms (e.g., $\text{ZIP}$ , $\text{RAR}$ ).
- Disk Defragmenter: Rearranges fragmented file sectors on hard drives to optimize access speed.
- Utility Suites: Bundled software packages containing multiple maintenance tools (e.g., Norton SystemWorks, McAfee Office).
Language Translators:
- Compilers: Converts entire high-level source code programs into executable machine object code prior to execution.
- Interpreters: Translates high-level source code line-by-line interactively during runtime.
- Assemblers: Translates assembly language mnemonics into binary machine code.

Application Software

General-Purpose Applications: Broadly used tools designed for common business and personal tasks.
- Word Processors: Used to create, edit, format, and print text-based documents (Microsoft Word, Corel WordPerfect, Lotus Word Pro).
- Features: Word wrap, spelling/grammar checking, thesaurus, mail merge, hypertext links, $\text{WYSIWYG}$ ("What You See Is What You Get").
- Spreadsheets: Numeric organization and manipulation tools arranged in rows (numbers) and columns (letters) forming cells (e.g., $\text{B10}$ ).

Spreadsheet Layout in MS Excel

- Key Elements: Labels (text/headings), Values (numbers), Formulas (custom user calculations, e.g.,  $=\text{C7}+\text{D7}$ ), Functions (built-in algorithms, e.g.,  $=\text{SUM}(\text{C7}:\text{K7})$ ), Automatic Recalculation, "What-If" Analysis, Analytical Charts.

Database Management Systems ( $\text{DBMS}$ ): Programs creating, structuring, updating, and querying relational data tables (Microsoft Access, Corel Paradox, Oracle).
Presentation Graphics: Software creating visual slide shows combining text, graphics, animations, and transitions (Microsoft PowerPoint, Corel Presentations).
- Software Integration Options:
Integrated Packages: A single low-cost program combining simplified functions of multiple applications (e.g., Microsoft Works).
Software Suites: A bundled collection of full-featured individual application programs sold together (e.g., Microsoft Office).
- Advanced Applications:
Desktop Publishing ( $\text{DTP}$ ): Layout-focused page design software for professional publishing (Adobe PageMaker, QuarkXPress).
Image Editors (Paint Programs): Edits pixel-based bitmap graphic images (Adobe Photoshop).
Illustration Programs (Draw Programs): Edits vector graphic files composed of geometric shapes and mathematical lines (CorelDRAW).
Web Authoring Software: $\text{HTML}$ page design software for website construction (Adobe Dreamweaver, FrontPage).
Artificial Intelligence ( $\text{AI}$ ):
- Robotics: Industrial Robots (assembly lines, welding), Mobile Robots (explosive disposal), Humanoids (mimicking human appearance/behavior).
- Expert Systems / Knowledge-Based Systems: Uses facts and inference rules to provide decision-making recommendations.
- Virtual Reality ( $\text{VR}$ ): Interactive 3D computer-simulated environments navigated using head-mounted displays and sensory gloves.

Programming

Definition of a Program: A logical sequence of step-by-step instructions directing a computer to process data into information.

Software Development Life Cycle (SDLC)

The six formal steps in software development:
1. Program Specification (Analysis): Defining program objectives, desired outputs, required inputs, and processing constraints; documented in a specification report.
2. Program Design: Formulating structured solution logic using design tools.
- Top-Down Program Design: Breaking complex tasks into smaller, manageable functional program modules.
- Pseudocode: An outline of program logic written in plain human language.
- Algorithm: A structured set of logical steps to solve a problem.
- Flowcharting: Visual representation of program logic using standard geometric symbols.
  - Terminal Symbol (Oval): Indicates start or end of execution.
  - Input/Output Symbol (Parallelogram): Represents reading input or displaying output.
  - Process Symbol (Rectangle): Represents arithmetic operations or memory manipulation.
  - Decision Symbol (Diamond): Evaluates true/false logic conditions.
  - Predefined Process Symbol: Represents subroutines.
  - Flowlines & Connectors: Direct execution flow.
- Control Structures:

Logic Structures Sequential Conditional Loop

   - Sequence: Statements execute one after another in order.
   - Selection ( $\text{IF-THEN-ELSE}$ ): Branching logic based on decision evaluations.
   - Iteration / Loop ( $\text{DO-WHILE}$  /  $\text{REPEAT-UNTIL}$ ): Repeated statement execution while conditions hold true.

Program Coding: Writing actual code statements using a selected programming language (e.g., Visual Basic, C++, Java, Python).
Program Testing (Debugging): Identifying and resolving bugs (syntax and logic errors).
- Syntax Errors: Violations of programming language grammar rules.
- Logic Errors: Flaws in algorithm reasoning causing incorrect output results.
- Testing Methods: Desk checking (code proofreading), manual data testing, compilation/translation checks, computer test runs with sample data, Beta testing (end-user field testing).
Program Documentation: Developing user manuals, operator guides, and technical code comments for future maintenance.
Program Maintenance: Ongoing operational support, bug fixing, and updating code to meet evolving legal or business requirements.

Generations of Programming Languages

Evolution of programming paradigms across five generations:
- First Generation ( $1\,\text{GL}$ ) - Machine Language: Binary code ( $0\text{s and }1\text{s}$ ) directly executable by CPU hardware; platform-dependent and difficult for humans.
- Second Generation ( $2\,\text{GL}$ ) - Assembly Language: Uses human-readable alphanumeric mnemonics (e.g., $\text{ADD}$ , $\text{MOV}$ ) translated via an assembler; low-level.
- Third Generation ( $3\,\text{GL}$ ) - High-Level Procedural Languages: English-like procedural statements expressing solution algorithms (BASIC, Pascal, C, $\text{COBOL}$ , $\text{FORTRAN}$ ); translated via compilers or interpreters.
- Fourth Generation ( $4\,\text{GL}$ ) - Problem-Oriented Languages: Non-procedural, task-focused languages including database query languages ( $\text{SQL}$ ) and application generators.
- Fifth Generation ( $5\,\text{GL}$ ) - Natural Languages: Human natural language processing interfaces connected to artificial intelligence systems.

Computers and Information Processing

Data and Information Processing

Data Types: Numeric data (numbers), Alpha data (letters/text), Alphanumeric data (combinations of letters, numbers, and symbols).
Data Hierarchy:
- Character: Individual letter, digit, or symbol.
- Field (Column): Logical grouping of related characters representing a single attribute (e.g., First Name).
- Record (Row): Collection of logically related fields representing a single entity.
- File (Table): Collection of logically related records.
- Database: Integrated collection of logically related data files/tables.
Data Processing Procedures:
1. Collecting Data: Gathering input from source documents.
2. Organizing Data: Classifying items into defined categories.
3. Combining Data: Merging datasets to eliminate processing redundancy.
4. Sorting Data: Ordering records alphabetically, numerically, or chronologically.
5. Manipulating Data: Executing mathematical calculations and evaluations.
6. Summarizing Data: Synthesizing large datasets into executive summary reports.
Processing Modes:
- Batch Processing: Accumulates transactions over a period (hours, days, weeks) and processes them simultaneously as a single batch.
- Real-Time Processing: Processes transactions instantly at the moment of occurrence using direct-access storage.

Database Management Systems ( $\text{DBMS}$ )

Database Table Structure in MS Access

Key Field (Primary Key): A field that uniquely identifies a specific record in a table (e.g., Student $\text{ID}$ Number). Composite keys use multiple combined fields when single fields are insufficient.
Advantages of Database Systems:
- Data Sharing: Enables simultaneous organizational data access across multiple departments.
- Enhanced Security: Enforces access privileges so users view only authorized data.
- Reduced Data Redundancy: Eliminates duplicate files across departments.
- Data Integrity: Instantaneous synchronized updates prevent data inconsistencies.
Disadvantages of Database Systems:
- High Implementation & Maintenance Costs.
- Increased Technical Complexity.
- Vendor Dependence and Frequent Upgrade Cycles.
Core $\text{DBMS}$ Components:
- Data Dictionary: Metadata repository defining field names, data types, character lengths, captions, and key field constraints.
- Query Language: Structured Query Language ( $\text{SQL}$ ) using standardized commands ( $\text{SELECT}$ , $\text{ADD}$ , $\text{UPDATE}$ , $\text{JOIN}$ ) to extract matching records.
- Report Generator: Formatting tool creating professional decision-making presentations from query results.
- Resource Locking: Multi-user database control mechanism preventing concurrent edit conflicts and double-booking errors.