city guilds model questions vol1 2025 information_technology | Practical

Prepare for your exams with city guilds model questions vol1 questions? Reviewing past/model questions is one of the most effective ways to guarantee a high score. This practice hub features authentic 2025 information_technology (Practical) questions designed to simulate the real exam environment.

Practice these randomly selected questions to test your readiness.

Question 1 View Details
A text file named **DATA.TXT** contains the following decimal numbers, each on a separate line: 72, 101, 108, 108, 111, 32, 87, 111, 114, 108, 100. The file is opened in a simple binary editor that displays each number in its 8‑bit binary form. Using the information displayed, answer the following questions.
Question Parts
(a)
Convert each decimal number to its 8‑bit binary equivalent.
(b)
Group the binary values into groups of 8 bits and interpret each group as an ASCII code to obtain the corresponding character.
(c)
State the word formed by the characters and explain briefly what the original file was likely used for.
Detailed Essay Solution & Marking Scheme Available

Get the step-by-step mathematical proofs, key points required by examiners, and a comprehensive breakdown from our AI Tutor.

Reveal Answer
Question 2 View Details
A Linux system administrator captures a snapshot of the process table using the command `ps -eo pid,time,pmem,stat` and records the following data: | PID | CPU Time (seconds) | Memory (MB) | Status | |-----|--------------------|------------|--------| | 101 | 120 | 150 | R | | 102 | 45 | 80 | S | | 103 | 200 | 300 | R | | 104 | 30 | 50 | T | | 105 | 90 | 120 | R | `R` = Running, `S` = Sleeping, `T` = Stopped. Using this information, answer the questions below.
Question Parts
(a)
Calculate the total CPU time consumed by all the listed processes.
(b)
Determine the average memory usage of the five processes (in MB, rounded to one decimal place).
(c)
Identify the process that consumes the most memory and state its PID.
(d)
If the process identified in part (c) is terminated, recalculate: i. the total memory usage of the remaining processes; ii. the new average memory usage (rounded to one decimal place). Finally, write the exact Linux command that would be used to terminate that process.
Detailed Essay Solution & Marking Scheme Available

Get the step-by-step mathematical proofs, key points required by examiners, and a comprehensive breakdown from our AI Tutor.

Reveal Answer
Question 3 View Details
A student is preparing a newsletter for the school ICT Club using a word‑processing package. The final document must meet the following specifications: - Title: centred, Times New Roman, 14 pt, bold. - Body text: justified, Times New Roman, 12 pt, 1.5 line spacing, first‑paragraph indent of 0.5 cm. - Insert a two‑column table titled “Upcoming Events” with three rows (Month, Event). The table must have a 0.5 pt border and alternating row shading (light grey for the even rows). - A footer that shows page numbers at the bottom‑right corner. - A header that contains the text “ICT Club – Newsletter – 2025” aligned left. - A table of contents that automatically lists all headings (Title as Heading 1, “Upcoming Events” as Heading 2). - Finally, the document must be saved as a PDF with all hyperlinks (if any) active. Answer the following:
Question Parts
(a)
Describe the sequence of actions required to set up the document style so that the title and body text satisfy the formatting requirements.
(b)
Explain how to create the “Upcoming Events” table with the required border thickness and alternating row shading.
(c)
List the steps required to export the completed document as a PDF while ensuring that any hyperlinks remain functional.
Detailed Essay Solution & Marking Scheme Available

Get the step-by-step mathematical proofs, key points required by examiners, and a comprehensive breakdown from our AI Tutor.

Reveal Answer
Question 4 View Details
A small business records its monthly sales (in units) for three products – Alpha, Beta and Gamma – for the twelve months of 2025. The data are entered in a spreadsheet as shown below (A1:G13). Column A lists the month names (Jan to Dec). Columns B, C and D contain the sales figures for Alpha, Beta and Gamma respectively. The manager asks you to: 1. Determine the total annual sales for each product and the overall total. 2. Find the average monthly sales for each product. 3. Produce a line chart that displays the three products’ monthly sales on the same axes. 4. Highlight any month in which a product’s sales exceed 5 000 units. 5. Project the sales for January 2026 for each product assuming a uniform 5 % increase over the December 2025 figures. Answer the following:
Question Parts
(a)
Write the formula (using appropriate cell references) that calculates the total annual sales for Product Alpha. Explain why you chose absolute or relative references in the formula.
(b)
Using the same sheet, give a single formula that can be copied across columns B, C and D to obtain the average monthly sales for each product. State the cell where the first result should appear.
(c)
Outline the steps required to create a line chart that plots the monthly sales of Alpha, Beta and Gamma on the same graph, ensuring the chart includes a legend, axis titles and data markers.
(d)
Explain how to apply conditional formatting so that any cell in the sales data range (B2:D13) that exceeds 5 000 units is highlighted in red.
Detailed Essay Solution & Marking Scheme Available

Get the step-by-step mathematical proofs, key points required by examiners, and a comprehensive breakdown from our AI Tutor.

Reveal Answer
Question 5 View Details
An online retail store maintains a relational database to record its customers, products, orders and the items contained in each order. The information required for each entity is listed below: Customers: CustomerID, FullName, Email, Phone, Address Products: ProductID, ProductName, Category, UnitPrice, UnitsInStock Orders: OrderID, CustomerID, OrderDate, TotalAmount OrderItems: OrderID, ProductID, Quantity, UnitPrice Using this information, answer the following questions.
Question Parts
(a)
Propose a set of relational tables for the above data. For each table give its name and clearly indicate the primary key.
(b)
State the highest normal form (1NF, 2NF, 3NF or BCNF) that each of the tables you proposed satisfies and give a brief justification.
(c)
Write an SQL query that lists the FullName of every customer who, in the last 30 days, has placed orders whose total amount exceeds ₦50,000.
(d)
The store wants to prevent overselling of products. Describe the logic of a BEFORE INSERT trigger (or stored procedure) on the OrderItems table that checks the UnitsInStock before an order item is recorded, and updates the stock if the insert is allowed. Include the key conditions that must be tested.
(e)
Identify two possible data anomalies that could arise from the proposed design and suggest a modification to eliminate each anomaly.
Detailed Essay Solution & Marking Scheme Available

Get the step-by-step mathematical proofs, key points required by examiners, and a comprehensive breakdown from our AI Tutor.

Reveal Answer

Master the Exam!

You've seen a preview, but there are thousands more questions plus AI tutor to break down complex solutions.

Unlock Full Access Available for Android & Windows
Help others prepare! Share this practice hub:
Chat with Support