Study Notes: CCS1401 Computing and ICT Skills - Final Examination Guide

Examination Overview and Administrative Details

  • Institution: ZCAS University
  • Course Code: CCS1401
  • Course Name: Computing and ICT Skills
  • Assessment Type: Final Examination
  • Date: Tuesday 28th May, 2025
  • Time Allotted:     * Reading and Writing: 33 hours (14:0014:00 HRS - 17:0017:00 HRS)     * Uploading Answer Script: 3030 minutes
  • Examination Structure:     * Section A: Question One is compulsory (4040 marks).     * Section B: Answer any THREE (33) questions (2020 marks each).     * Total Marks: 100100 marks.

Section A: Spreadsheet Modeling and Data Management

Logistics Record Dataset Structure

The dataset tracks delivery data for a logistics company with the following columns:

  • A: Invoice ID (e.g., INV001 to INV010)
  • B: Subject (Purpose of delivery, e.g., Pharmacy Delivery, Office Supplies)
  • C: Number of Trips
  • D: Distance per Trip (kmkm)
  • E: Cost per kmkm (USDUSD)
  • F: Total Distance (kmkm)
  • G: Initial Transport Cost (USDUSD)
  • H: Discount (USDUSD)
  • I: Final Cost (USDUSD)
  • J: VAT (16%16\%)
  • K: Total Payable (USDUSD)

Excel Formulas for Calculation Tasks

The following formulas are required for the logistics spreadsheet (assuming row 22 as the first data row):

  • Total Distance (Column F): Calculates the product of the number of trips and the distance per trip.     * Formula: =C2×D2=C2 \times D2
  • Initial Transport Cost (Column G): Calculates the product of total distance and cost per kilometer.     * Formula: =F2×E2=F2 \times E2
  • Discount Amount (Column H): Uses a nested IF structure based on the initial cost threshold.     * Criteria:         * Less than 100 USD→2%100\,USD \rightarrow 2\% discount         * 100 USD100\,USD to less than 500 USD→5%500\,USD \rightarrow 5\% discount         * 500 USD500\,USD and above →8%\rightarrow 8\% discount     * Formula: =IF(G2<100,G2×0.02,IF(G2<500,G2×0.05,G2×0.08))=IF(G2 < 100, G2 \times 0.02, IF(G2 < 500, G2 \times 0.05, G2 \times 0.08))
  • Final Cost (Column I): Subtracts discount from initial cost.     * Formula: =G2−H2=G2 - H2
  • VAT Amount (Column J): Fixed VAT rate of 16%16\%.     * Formula: =I2×0.16=I2 \times 0.16
  • Total Payable (Column K): Sum of final cost and VAT.     * Formula: =I2+J2=I2 + J2

Summary Functions and Analysis

  • Conditional Summation: To find the total initial transport cost for all "Grocery Refill" entries:     * Formula: =SUMIF(B2:B11,"Grocery Refill",G2:G11)=SUMIF(B2:B11, "Grocery\,Refill", G2:G11)
  • Conditional Count: To count deliveries with more than 1010 trips:     * Formula: =COUNTIF(C2:C11,">10")=COUNTIF(C2:C11, ">10")
  • Statistical Functions:     * Highest Initial Transport Cost: =MAX(G2:G11)=MAX(G2:G11)     * Lowest Number of Trips: =MIN(C2:C11)=MIN(C2:C11)     * Average Distance per Trip: =AVERAGE(D2:D11)=AVERAGE(D2:D11)

Section B: Computer Systems and Hardware

System Software Groupings

System software manages and supports the hardware and infrastructure of a computer. It is generally categorized into four types:

  • Operating Systems (OS): The core software that manages hardware resources (CPU, memory) and provides the interface for users and applications (e.g., Windows, macOS, Linux).
  • Utility Programs: Tools designed to help analyze, configure, optimize, or maintain a computer, such as antivirus software, file compression tools (WinZip), and disk defragmenters.
  • Device Drivers: Specialist software that allows the operating system to communicate with specific hardware devices (e.g., printer drivers, graphics card drivers).
  • Language Translators: Software that converts programming code into machine-readable format, including Compilers, Interpreters, and Assemblers.

Storage Media Comparison

When evaluating storage media for a company, four factors are considered:

  • Hard Drive (HDD):     * Access Speed: High (slower than SSD but faster than optical/tape).     * Cost: Low per unit of storage.     * Robustness: Moderate; sensitive to physical shocks due to moving parts.     * Capacity: High (standard sizes in TBTB).
  • Flash Disk (SSD/USB):     * Access Speed: Very High.     * Cost: Higher than HDD/Tape per GBGB.     * Robustness: High; no moving parts, resistant to drop damage.     * Capacity: Moderate to High.
  • Magnetic Tapes:     * Access Speed: Very Low (Sequential access).     * Cost: Lowest for large-scale archival storage.     * Robustness: High for long-term storage but sensitive to magnets and heat.     * Capacity: Very High (TBTB to PBPB in tape libraries).
  • Optical Disks (CD/DVD/Blu-ray):     * Access Speed: Low.     * Cost: Competitive for small data distribution.     * Robustness: Low; easily scratched or damaged by light.     * Capacity: Low (max approx. 50 GB50\,GB for dual-layer Blu-ray).

Database Systems (MS Access)

Primary School Database Schema

The database consists of four related tables:

  • Student: StudentID (PK), Name, Age, Gender, ClassID (FK).
  • Teacher: TeacherID (PK), Name, SubjectID (FK).
  • Class: ClassID (PK), ClassName, TeacherID (FK).
  • Subject: SubjectID (PK), SubjectName.

MS Access Query Criteria Syntax

  • Age Range and Class: To find students aged between 1414 and 1616 in Math class:     * Criteria: Between 14 And 16 (under Age) and "Math" (under ClassName).
  • Wildcard Search (Starts With): To retrieve students with a name starting with 'J':     * Criteria: Like "J*".
  • Wildcard Search (Contains): To find a student with the middle name "Peter" (e.g., Tom Peter Green):     * Criteria: Like "* Peter *".
  • Specific Character Placement: Names where the second letter is 'O':     * Criteria: Like "?o*".

Windows Operating System Features

  • User Account Control (UAC):     * Function: A security feature that prevents unauthorized changes to the operating system.     * Significance: It prompts the user for permission or an administrator password before performing actions that could affect computer operation or change settings that affect other users.
  • Windows Defender:     * Function: A built-in anti-malware component.     * Significance: Provides real-time protection against viruses, spyware, and other malicious software, ensuring system integrity without requiring third-party software.
  • Task Manager:     * Function: Provides information about computer performance and running applications.     * Significance: Allows users to monitor resource usage (CPU, Memory, Disk), terminate non-responsive processes, and manage startup programs.
  • File Explorer:     * Function: The file management application used to browse folders and files.     * Significance: Provides a graphical user interface for accessing the file system, allowing users to copy, move, delete, and organize data efficiently.
  • Windows Update:     * Function: A service that provides updates for the Windows OS and its components.     * Significance: Crucial for security; it delivers patches, bug fixes, and feature updates to protect the system against new vulnerabilities.

Advanced Spreadsheet and Database Concepts

Cell Referencing and Functions

  • Relative vs. Absolute References:     * If cell D4D4 contains =C1+C2, copying it to E5E5 results in =D2+D3 (Relative change: one column right, one row down).     * Absolute Reference: Denoted by the dollar sign (e.g., C$1). When copied to a new location, the reference does not change.
  • Internal Rate of Return (IRR) Logic:     * The correct formula to check against a decision rule in cell E2E2 that can be dragged down is: =IF(B2 >= $E$2, "Accept", "Reject").
  • What-If Analysis Tools:     * Goal Seek: An analytical function used to find a specific input value (e.g., Loan Amount) required to achieve a desired output (e.g., Monthly Payment of 3,8503,850).     * Solver: Used for more complex problems with multiple variables and constraints.
  • Macros: A series of instructions contained in one command used to automate repetitive tasks.
  • Pivot Tables: A powerful tool used to quickly group, summarize, and rearrange larger datasets (shown in the summation of amounts by Buyer/Type).

Data Management Fundamentals

  • Data Hierarchy (Ascending Order):     1. Bit (Smallest unit: 00 or 11)     2. Byte (Typically 88 bits; represents one character)     3. Field (A single unit of data, e.g., Last Name)     4. Record (A collection of related fields)     5. File (A collection of related records/Table)     6. Database (A collection of integrated files)
  • Multi-Table Queries: In a scenario for Customer pre-orders in December, relevant fields across Customers and Orders tables include First Name, Last Name, Email, Pre Order, and Pickup Date.