city guilds model questions vol1 2020 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 2020 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 computer technician is given the following five binary numbers that represent the size of five files in kilobytes (KB): 101101, 1100101, 11100, 1001110, 1010111. The technician must determine whether the five files can be stored together on a USB flash drive that has a capacity of 2 MB.
Question Parts
(a)
Convert each binary number to its decimal equivalent (in KB).
(b)
Find the total size of the five files in kilobytes.
(c)
Express the total size in megabytes, correct to two decimal places (1 MB = 1024 KB).
(d)
State whether the five files will fit on the 2 MB flash drive and, if they do, calculate the remaining free space in megabytes (to two decimal places).
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
Four processes P1, P2, P3 and P4 arrive at a computer system with the following arrival times and CPU‑burst times (all times in milliseconds): - P1: arrival 0 ms, burst 10 ms - P2: arrival 2 ms, burst 4 ms - P3: arrival 4 ms, burst 6 ms - P4: arrival 6 ms, burst 8 ms Using a Round‑Robin scheduling algorithm with a time‑quantum of 4 ms, answer the questions below.
Question Parts
(a)
Draw the Gantt chart showing the order of execution of the processes.
(b)
Calculate the average waiting time of the four processes (to one decimal place).
(c)
Calculate the average turnaround time of the four processes (to one decimal place).
(d)
Which process completes first and why?
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 small enterprise is preparing a two‑column product catalogue using a word‑processing package. The catalogue must contain 12 products. For each product the following information is supplied: product name, a short description, unit price (in Naira) and the quantity in stock. The candidate is required to complete the tasks below.
Question Parts
(a)
Set the page layout to A4 size, 2 cm margins on all sides, two columns, and 1.5 line spacing throughout the document.
(b)
Create a heading style called “ProductTitle” (bold, 14 pt, navy colour) and apply it to every product name. Ensure the style appears in the style gallery and that a Table of Contents can be generated automatically from these headings.
(c)
Insert a table that lists for each product: Product Name, Unit Price, Stock Quantity, and Total Value (Unit Price × Stock Quantity). Use a formula for the Total Value column. After entering the data, sort the table in descending order of Total Value.
(d)
Insert a picture placeholder for each product (12 pictures in total). Each picture file is 120 KB. After completing the document, export it to PDF. If each page of text occupies on average 5 KB, calculate the expected size of the final PDF file (round to the nearest kilobyte).
(e)
Summarise, in one sentence, two advantages of exporting the catalogue as a PDF rather than as a .docx file.
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 secondary school records the scores of six students in three examinations. The data are given below. | Student | Exam 1 | Exam 2 | Exam 3 | |---------|--------|--------|--------| | Ada | 68 | 74 | 81 | | Bayo | 55 | 62 | 58 | | Chidi | 82 | 79 | 85 | | Damilola| 47 | 51 | 44 | | Efe | 73 | 70 | 68 | | Fatima | 39 | 45 | 41 | Using a spreadsheet application, answer the following tasks.
Question Parts
(a)
Enter the data exactly as shown into a worksheet, ensuring that the header row is bold.
(b)
In column E, calculate the average score for each student, rounding to the nearest whole number. State the average for each student.
(c)
Using the IF function, assign a grade in column F based on the average: - A for ≥ 75 - B for 60 – 74 - C for 45 – 59 - D for < 45 State each student’s grade.
(d)
Create a column G that displays “Pass” for grades A, B or C and “Fail” for D. Then compute the overall pass percentage for the class (rounded to one decimal place).
(e)
Generate a vertical bar chart of the average scores (column E). Identify which student performed best and state the chart’s title and axis labels that you would use.
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
A small e‑commerce company wants to store information about its customers, the products it sells, the orders placed and the items contained in each order. The following details are required: - Each customer has a unique CustomerID, name, email and contact number. - Each product has a unique ProductID, product name, category and unit price. - An order is identified by a unique OrderID, is placed by a single customer on a specific order date, and may contain one or more items. - Each order item records the OrderID, ProductID, quantity ordered and the unit price at the time of the order. Using this description, answer the following: (a) List all functional dependencies that can be inferred from the description. (b) Convert the information into relational tables that are in Third Normal Form (3NF). For each table give the table name, its attributes, the primary key and any foreign keys. (c) Write an SQL query that lists the names of customers who placed orders between 1 October 2023 and 31 December 2023 and whose total order value in that period exceeds ₦500 000. The list should be ordered from highest to lowest total spend. (d) The OrderItems table will store the fields OrderID (INT, 4 bytes), ProductID (INT, 4 bytes), Quantity (INT, 4 bytes) and UnitPrice (DECIMAL(10,2), 8 bytes). If the table contains 12 500 rows, calculate the total storage required for this table in megabytes (MB), ignoring any storage overhead.
Question Parts
(a)
List all functional dependencies that can be inferred from the description.
(b)
Convert the information into relational tables that are in Third Normal Form (3NF). For each table give the table name, its attributes, the primary key and any foreign keys.
(c)
Write an SQL query that lists the names of customers who placed orders between 1 October 2023 and 31 December 2023 and whose total order value in that period exceeds ₦500 000. Order the list from highest to lowest total spend.
(d)
Calculate the total storage required for the OrderItems table (12 500 rows) in megabytes (MB), ignoring any storage overhead.
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