city guilds model questions vol1 2023 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 2023 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 school computer lab is being prepared for a new semester. The lab will contain three computers, each requiring the installation of the following software packages: - Office Suite: 250 MB - Antivirus: 120 MB - Educational Game: 340 MB Each package needs an additional 5 % of its total size for installation overhead, and each computer will also store a student‑data folder of 80 MB. The lab technician will use a single 2 GB USB flash drive to transfer all installation files and data to the three computers.
Question Parts
(a)
Calculate the total amount of data (in megabytes) that must be copied onto the USB drive for all three computers, including overhead and student‑data folders.
(b)
Determine whether the 2 GB USB drive has sufficient capacity. If it does not, state the minimum capacity (in whole gigabytes, rounded up) required.
(c)
The technician intends to format the USB drive with the FAT32 file system. Explain one limitation of FAT32 that could affect storing the installation files and suggest an alternative file system that overcomes this limitation.
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–P4) arrive simultaneously at time 0 in a single‑CPU system. Their CPU burst times are: - P1 = 10 ms - P2 = 4 ms - P3 = 6 ms - P4 = 8 ms The scheduler uses Round Robin with a time quantum of 4 ms. A context‑switch overhead of 1 ms is incurred after every quantum, even after a process finishes its last quantum.
Question Parts
(a)
Describe the order in which the processes execute, including the 1 ms context‑switch intervals (you may present the order as a Gantt‑chart description).
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 business owner is preparing a product catalogue using a word processor. The catalogue must contain a title page, a formatted table of products, an automatically generated table of contents and be saved as a PDF file.
Question Parts
(a)
Describe the exact steps required to create the title page so that the text "ABC Enterprises Product Catalogue" appears centred, in bold, using the font Times New Roman, size 24 pt, with a line spacing of 1.5.
(b)
Insert a table with five products using the following data. Apply a table style that shows grid lines and a light‑grey shading for the header row. Then, for each product, calculate the stock value (Unit Price × Quantity in Stock) using a table formula and display the overall total stock value at the bottom of the table. Product data: | Code | Description | Unit Price (₦) | Quantity | |------|-------------|----------------|----------| | P101 | Wooden Chair | 12,500 | 24 | | P102 | Steel Table | 45,000 | 10 | | P103 | Plastic Lamp | 8,750 | 30 | | P104 | Leather Sofa | 120,000| 5 | | P105 | Glass Cabinet| 85,000 | 7 |
(c)
Explain how to generate a Table of Contents that automatically lists each product code as a heading, assuming each product code is formatted with the built‑in "Heading 2" style.
(d)
The final document contains 12 pages. If each page of the PDF occupies approximately 120 KB, estimate the file size of the exported PDF (in MB, rounded to one decimal place).
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 is analysing the performance of its Form 2 students in three subjects using a spreadsheet program.
Question Parts
(a)
Enter the following data into a worksheet (rows 2‑9, columns A‑D). Column A: Student name; Column B: Mathematics score; Column C: English score; Column D: Science score. | Student | Math | English | Science | |---------|------|---------|---------| | Ada | 78 | 85 | 69 | | Bode | 64 | 58 | 71 | | Chidi | 92 | 88 | 95 | | Damilola| 55 | 62 | 48 | | Emeka | 81 | 77 | 84 | | Fatima | 70 | 73 | 67 | | Grace | 88 | 91 | 90 | | Hassan | 47 | 54 | 50 |
(b)
In column E, calculate each student's total score (sum of the three subjects) and in column F, calculate the average score (to one decimal place). State the formulas used for the first student (row 2).
(c)
Using an appropriate function, determine the class rank for each student based on total score (higher total = better rank). Show the formula placed in column G for the first student.
(d)
Create a column chart that displays the average score for each subject (Mathematics, English, Science). List the steps required to produce the chart from the data entered.
(e)
Apply conditional formatting to highlight any individual subject score below 50 in red text. Outline the procedure.
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 e‑commerce start‑up, ShopEase, intends to develop a relational database to record its product catalogue, customer details, order processing and payments. The initial un‑normalised record that the system currently stores for each transaction is shown below: OrderID | OrderDate | CustomerName | CustomerEmail | CustomerPhone | ProductID | ProductName | ProductCategory | UnitPrice | Quantity | PaymentMethod | PaymentDate | PaymentAmount --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- | --- (Example row) 1023 | 2023‑09‑15 | Ada Okafor | ada.ok@shop.com | 0803123456 | P045 | "Wireless Mouse" | "Accessories" | 2500.00 | 2 | "Card" | 2023‑09‑15 | 5000.00 Based on this information, answer the following questions.
Question Parts
(a)
List all functional dependencies that can be inferred from the un‑normalised record. Using these dependencies, propose a set of relational tables (including table names) that would store the same information without redundancy. For each table, specify its attributes and identify the primary key.
(b)
Show, step‑by‑step, how the proposed design is normalised to the Third Normal Form (3NF). Indicate any tables that need to be split and give the final set of tables with their primary and foreign keys.
(c)
Write an SQL statement that lists the names and email addresses of customers who, in the month of September 2023, placed orders containing more than three distinct products. The result should be ordered alphabetically by customer name.
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