Encyclopedic Study Guide for Computer Fundamentals and Information Technology

Types of Computers and Core Fundamentals

Supercomputer
- Description: These are the fastest and most powerful computers currently in existence.
- Primary Application: Used for high-intensity task such as weather forecasting.
- Key Identifier: Speed is the defining characteristic.
Mainframe Computer
- Description: Large-scale computers designed to handle thousands of users simultaneously and process massive quantities of data.
- Primary Application: Utilized extensively in banking institutions.
- Key Identifier: Capability to support many users concurrently.
Desktop Computer
- Description: A personal computer designed for individual use at a fixed location.
- Examples: Common personal computers found in school labs or home offices.
Mobile Device
- Description: Highly portable computers designed for use on the go.
- Examples: Smartphones and tablets.
Embedded Device
- Description: A specialized computer system built into a larger device to control its functions.
- Examples: Microprocessors in microwaves and automobiles.
The IPOS Cycle
- The Information Processing Cycle consists of four distinct stages:
  1. Input: Entering data into the computer. (Example: Keyboard)
  2. Processing: Performing operations on the data to convert it into information. (Example: CPU)
  3. Output: Presenting the processed results to the user. (Example: Monitor)
  4. Storage: Saving data or information for future use. (Example: Hard Drive)

Peripheral Devices: Input and Output

Input Devices
- Keyboard: Used to enter text and numerical data.
- Mouse: A pointing device used to select items on the screen.
- Card Reader: A device used to read data from cards (such as magnetic stripe or chip cards).
- Biometric Scanner: Used for security and identity verification through fingerprint or facial recognition.
- Scanner: Converts physical paper documents into digital formats.
Output Devices
- Monitor: Displays visual information and graphics.
- Printer: Produces hard copies of digital documents.
- Speakers: Outputs audio/sound.
- Headphones: Personal audio output device.
- Projector: Displays computer images onto a larger surface or screen.

The Central Processing Unit (CPU) and Storage

The CPU
- Commonly referred to as the "brain" of the computer.
- Primary Functions:
  1. Executes software instructions.
  2. Performs mathematical calculations.
  3. Controls the general operations of the computer system.
Primary Storage (Memory)
- RAM (Random Access Memory): Temporary storage used while the computer is running. It is volatile, meaning data is lost when the power is turned off.
- ROM (Read-Only Memory): Permanent storage containing essential startup instructions. It is non-volatile, meaning data is retained even without power.
Secondary Storage
- Used for long-term storage of files and programs.
- Hard Disk (HDD): Traditional magnetic storage.
- SSD (Solid State Drive): Faster, flash-based storage.
- Flash Drive: Portable USB storage.
- CD/DVD: Optical storage media.
Storage Units and Measurement
- Bit: The smallest unit of data ( $0$ or $1$ ).
- Byte: Comprised of $8\,\text{bits}$ .
- Kilobyte (KB): $1024\,\text{bytes}$ .
- Megabyte (MB): $1024\,\text{KB}$ .
- Gigabyte (GB): $1024\,\text{MB}$ .
- Terabyte (TB): $1024\,\text{GB}$ .

Storage Methods and Troubleshooting

Cloud Storage vs. Local Storage
- Cloud Storage:
  - Requires an active internet connection.
  - Accessible from any location with internet access.
  - Backups are typically easy and automated by the provider.
  - Example: Google Drive.
- Local Storage:
  - No internet connection required for access.
  - Access is limited to the physical device.
  - The user is responsible for managing and creating backups.
  - Example: Internal Hard Drive.
Common Hardware Troubleshooting
- Computer will not start: Check the power supply and connections.
- No sound: Verify that speakers or headphones are properly connected.
- Printer not printing: Check for paper jams and ensure connections are secure.
- Slow performance: Close unnecessary programs or add more $RAM$ .

Computer Software and User Interfaces

System Software
- Controls the internal operations of the computer hardware.
- Examples: Operating Systems (OS) and Utility Programs.
Application Software
- Helps users perform specific tasks beyond the basic operation of the computer.
- Examples: Word processors, spreadsheets, and video games.
General Purpose vs. Special Purpose Software
- General Purpose: Designed to perform a wide variety of tasks. (Examples: Microsoft Word, Microsoft Excel).
- Special Purpose: Designed for one specific, niche task. (Examples: Payroll software, School management systems).
Software Acquisition Sources
- Off-the-Shelf: Ready-made software available for purchase by the general public.
- Custom Software: Software built specifically from scratch for one organization's unique requirements.
- Customized Software: Pre-existing software that is modified or tweaked to better suit a specific user's needs.
Types of User Interfaces
- GUI (Graphical User Interface): Uses visual elements like icons, windows, and pointers for navigation (Example: Windows OS).
- Menu-Driven Interface: The user interacts by selecting options from a list or menu (Example: ATM machines).
- Command Line Interface (CLI): The user interacts by typing specific textual commands (Example: Command Prompt).

Data Management and File Organization

Data vs. Information
- Data: Raw, unorganized facts without context (Example: $75$ , $80$ , $90$ ).
- Information: Processed, organized data that has meaning (Example: Average score = $82\%$ ).
Validation vs. Verification
- Validation: An automated check to ensure data is sensible and reasonable (Example: A check to ensure an Age field does not contain a negative value like $-5$ ).
- Verification: A check to ensure that the data entered matches the original source material (Example: Double entry checking).
File Organization Methods
- Sequential: Records are stored and accessed in a specific, predetermined order.
- Serial: Records are stored in the order they are received without any specific sorting.
- Direct/Random Access: Records can be accessed directly without reading preceding records (Example: Banking ATM database).

Networking and Web Technologies

Types of Networks (Coverage Areas)
- LAN (Local Area Network): Covers a small geographic area, such as a single school or office building.
- MAN (Metropolitan Area Network): Covers a city-wide area (Example: A network connecting sites across Kingston).
- WAN (Wide Area Network): Covers a country or the entire world (Example: The Internet).
Internet Access Control
- Internet: Public access for everyone.
- Intranet: Private access restricted to employees of a specific organization only.
- Extranet: Access granted to employees plus authorized external partners/outsiders.
Essential Network Devices
- Router: Used to connect different networks together.
- Switch: Connects individual devices together within a single network.
- Modem: Connects a home or office to an Internet Service Provider (ISP).
- NIC (Network Interface Card): A hardware component that allows a device to connect to a network.
Transmission Media
- Wired: Ethernet cables or Fibre optic cables.
- Wireless: Wi-Fi or Bluetooth technologies.
Web Terminology and Technologies
- WWW: World Wide Web.
- HTML: HyperText Markup Language, used to create the structure of webpages.
- HTTP: HyperText Transfer Protocol, the protocol used for transferring webpages.
- Hyperlink: A clickable link that connects one webpage to another.
- URL (Uniform Resource Locator): A web address (Example: $https://www.google.com$ ).
- FTP: File Transfer Protocol, used for transferring files between computers.
- Web Browser: Software used to view websites (Example: Chrome, Edge, Firefox).
- Web Server: A computer that stores and serves website content.

Spreadsheets (Section 5)

Spreadsheet Terminology
- Workbook: The entire spreadsheet file.
- Worksheet: A single page or sheet within the workbook.
- Cell: The intersection point of a row and a column.
- Range: A group or block of selected cells (Example: $A1:A10$ ).
Common Functions
- SUM: Adds values in a range. Syntax: $\text{=SUM}(A1:A10)$ .
- AVERAGE: Calculates the mean of a range. Syntax: $\text{=AVERAGE}(A1:A10)$ .
- COUNTIF: Counts cells that meet a specific condition. Syntax: $\text{=COUNTIF}(A1:A10, ">50")$ .
- IF: Performs a logical test. Syntax: $\text{=IF}(A1 \geq 50, \text{"Pass"}, \text{"Fail"})$ .
- VLOOKUP: Searches for data vertically in a table. Syntax: $\text{=VLOOKUP}(A1, D1:F10, 2, \text{FALSE})$ .
Cell References
- Relative Reference: Changes when the formula is copied to another cell (Example: $=A1+B1$ ).
- Absolute Reference: Remains constant and does not change when copied (Example: =$A$1+$B$1).
Data Analysis Tools
- Sorting: Arranging data in Ascending ( $A-Z$ ) or Descending ( $Z-A$ ) order.
- Filtering: Displays only the records that meet specific criteria.
- Pivot Table: Used to summarize and analyze large datasets.
Chart Types
- Column Chart: Used to compare discrete values.
- Line Chart: Used to show trends or changes over a period of time.
- Pie Chart: Used to show proportions or percentages of a whole.
- Bar Chart: Used to compare categories of data.

Database Management (Section 6)

Database Fundamentals
- Database: A structured and organized collection of related data.
- Field: A single piece of data or a specific category (Example: Last Name).
- Record: A complete horizontal row of related data fields.
- Table: A collection of many related records.
Database Views
- Design View: Used to create and modify the structure/schema of the table.
- Datasheet View: Used to enter, edit, and view the actual data within the table.
Key Constraints
- Primary Key: A field that uniquely identifies each record in a table (Example: Student ID).
- Foreign Key: A field in one table that links to the primary key of another table to create a relationship.
Relationship Types
- One-to-One: Each record in Table A matches exactly one record in Table B.
- One-to-Many: One record in Table A matches multiple records in Table B (Example: One teacher leads many students).
- Many-to-Many: Multiple records in Table A match multiple records in Table B (Example: Many students enrolled in many subjects).
Queries
- Database objects used to search for specific data, filter records, sort results, and perform calculations.

Likely Paper 2 Examination Questions

Compare the characteristics of RAM and ROM.
Explain the stages and flow of the IPOS cycle.
Distinguish between the coverage areas of LAN, MAN, and WAN.
Compare the advantages and disadvantages of cloud storage versus local storage.
Explain the difference between data validation and data verification using examples.
Describe the specific functions of a router and a switch within a network.
Explain the difference between relative and absolute cell references in spreadsheets.
Distinguish between a primary key and a foreign key.
Compare system software and application software and provide examples of each.
Explain the advantages and socio-economic importance of mobile communication technologies (e.g., in Education, Journalism, Banking, E-commerce).