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: hours ( HRS - HRS) * Uploading Answer Script: minutes
- Examination Structure: * Section A: Question One is compulsory ( marks). * Section B: Answer any THREE () questions ( marks each). * Total Marks: 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 ()
- E: Cost per ()
- F: Total Distance ()
- G: Initial Transport Cost ()
- H: Discount ()
- I: Final Cost ()
- J: VAT ()
- K: Total Payable ()
Excel Formulas for Calculation Tasks
The following formulas are required for the logistics spreadsheet (assuming row as the first data row):
- Total Distance (Column F): Calculates the product of the number of trips and the distance per trip. * Formula:
- Initial Transport Cost (Column G): Calculates the product of total distance and cost per kilometer. * Formula:
- Discount Amount (Column H): Uses a nested IF structure based on the initial cost threshold. * Criteria: * Less than discount * to less than discount * and above discount * Formula:
- Final Cost (Column I): Subtracts discount from initial cost. * Formula:
- VAT Amount (Column J): Fixed VAT rate of . * Formula:
- Total Payable (Column K): Sum of final cost and VAT. * Formula:
Summary Functions and Analysis
- Conditional Summation: To find the total initial transport cost for all "Grocery Refill" entries: * Formula:
- Conditional Count: To count deliveries with more than trips: * Formula:
- Statistical Functions: * Highest Initial Transport Cost: * Lowest Number of Trips: * Average Distance per Trip:
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 ).
- Flash Disk (SSD/USB): * Access Speed: Very High. * Cost: Higher than HDD/Tape per . * 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 ( to 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. 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 and 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 contains
=C1+C2, copying it to 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 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 ). * 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: or ) 2. Byte (Typically 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
CustomersandOrderstables include First Name, Last Name, Email, Pre Order, and Pickup Date.