ICT Exam Solutions and Technical Concepts

1. Hardware and Spreadsheet Fundamentals

1(a) Input and Output Devices

• 1(a)(i) Output
• 1(a)(ii) Input
• 1(a)(iii) Input
• 1(a)(iv) Output
• 1(a)(v) Input

1(b) Network Types and Components

• 1(b)(i) LAN
• 1(b)(ii) MAN
• 1(b)(iii) WAN

Wireless Networking

• Component: Wireless NIC, Wi-Fi adapter
• Reason: Connects device to wireless network without cables

1(c) Spreadsheet Operations

• 1(c)(i) =C2*D2
• 1(c)(ii) Average item cost: C8; Grand total: E8
• 1(c)(iii) =AVERAGE(C2:C7)
• 1(c)(iv) Stock ID: Text; Total Value: Currency
• 1(c)(v) Dinghy, Fender

2. Data Processing and Validation

2(a) Data Entry Devices

• 2(a)(i) MICR
• 2(a)(ii) Sensor
• 2(a)(iii) OMR
• 2(a)(iv) OCR

2(b) Validation Checks

• 2(b)(i) Presence check
• 2(b)(ii) Range check
• 2(b)(iii) Format check

2(c) Database Concepts

• 2(c)(i) Boolean: Stores only two possible values (e.g., Yes/No or True/False).
• 2(c)(ii) RegNo: Unique for each student
• 2(c)(iii) 1033000
• 2(c)(iv) RegNo: Eastmond
• 2(c)(v)(a) 5
• 2(c)(v)(b) 1
• 2(c)(vi) Specialization, Sex

3. System Specifications and Logic

3(a) Computer Hardware Specs

• 3(a)(i) 512 GB SSD
• 3(a)(ii) 2.9 GHz
• 3(a)(iii) Google Chrome
• 3(a)(iv) 14-inch touchscreen
• 3(a)(v) Intel Wi-Fi card

3(b) Advanced Spreadsheet Features

• 3(b)(i) Merged and centred
• 3(b)(ii) Mixed cell reference
• 3(b)(iii) Alcoholic products
• 3(b)(iv) =IF(E8>300,"GOOD","POOR")
• 3(b)(v) Pie chart
• 3(b)(vi) B3:D3 and B10:D10
• 3(b)(vii) Category name, Percentage

3(c) Programming Logic

• 3(c)(i) TAX
• 3(c)(ii) Selection, IF...ELSE
• 3(c)(iii) Line 6
• 3(c)(iv) AND
• 3(c)(v) John: $25,000; Mary: $120,000
• 3(c)(vi) Algorithm: Start, Input mthpay, If mthpay > 75000 AND mthpay <= 200000? Yes → TAX = (mthpay - 75000) * 0.25, No → TAX = (mthpay - (0.25 * mthpay)) * 0.40, Output TAX, Stop

4. Programming and Networking

4(a) Temperature Conversion Logic

Inputs a choice, then converts Fahrenheit to Celsius if choice is 1, or Celsius to Fahrenheit if choice is 2, then displays the result.

4(b) Algorithm Design

• Input: Temp, Fah, Cel
• Processing: If Temp = 1, Cel = (Fah - 32) * 5/9, else Fah = (Cel * 9/5) + 32
• Output: Degrees Celsius, degrees Fahrenheit

4(c) Iteration

• 4(c)(i) FOR number ← 1 TO 10, NEXT number
• 4(c)(ii) Number of repetitions is known (ten calculations).

4(d) Repeat Until Loop

number ← 1, REPEAT [conversion steps], number ← number + 1, UNTIL number > 10

4(e) Network Hardware

• Switch
• Router
• NIC
• Ethernet cables

4(f) Internet vs WWW

• Internet: Worldwide network of connected computers and devices
• WWW: Service on the Internet used to access web pages and websites

4(g) URL Structure

• 4(g)(i) Uniform Resource Locator
• 4(g)(ii) https: secure protocol; cxc.org: domain name, website address; /student-results: path, page location on server