city guilds model questions vol1 2022 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 2022 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 stores signed integers using two's complement representation. You are required to determine the smallest word length that can represent the decimal integer –156, write its two's complement binary form using that word length, and state the range of integers that can be represented with the same word length.
Question Parts
(a)
Find the minimum number of bits (n) required so that –156 can be represented in two's complement.
(b)
Write the 9‑bit two's complement representation of –156.
(c)
State the complete range of integers that can be stored with the word length found in part (a).
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 computer uses Round Robin CPU scheduling with a time quantum of 4 ms. At time 0 three processes arrive as follows: • P1 – CPU burst 10 ms • P2 – CPU burst 6 ms • P3 – CPU burst 8 ms No other processes arrive later.
Question Parts
(a)
Draw the Gantt chart showing the order of execution for the first 20 ms.
(b)
Determine the waiting time for each process (P1, P2 and P3) until its completion.
(c)
Calculate the average waiting time for the three processes.
(d)
State which process finishes first and at what time.
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
You are given a computer with a standard word‑processing package installed. Using the software, you are required to produce a report that meets the following specifications: 1. Create a title page that contains the report title centred, the author's name right‑aligned, and the date centred below the title. 2. Apply a consistent heading style to three main sections (Introduction, Findings, Conclusion) so that they appear in the document’s Table of Contents. 3. Insert a photograph (provided on a USB drive) into the Findings section, set the picture width to 12 cm, and apply text wrapping so that the surrounding paragraph text flows around the image on both sides. 4. Use the mail‑merge feature to generate personalised letters to five recipients whose names and addresses are listed in a supplied Excel file. Each letter must begin with the recipient’s name and address, followed by the body of the report. 5. Save the final document in both DOCX and PDF formats. Explain, in clear step‑by‑step form, how you would accomplish each of the above tasks, and indicate any precautions you would take to avoid common errors.
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 retail shop records its monthly sales (in thousands of Naira) for the year as shown in the table below. The manager wants you to use a spreadsheet to analyse the data and help plan for the next year. | Month | Sales (₦ 000) | |-------|--------------| | Jan | 120 | | Feb | 150 | | Mar | 130 | | Apr | 160 | | May | 140 | | Jun | 155 | | Jul | 165 | | Aug | 170 | | Sep | 158 | | Oct | 162 | | Nov | 168 | | Dec | | Tasks: (a) Enter the data and write a formula to compute the total sales for the year (including the blank December cell). (b) In column C, calculate the commission for each month using the following tiered rates: up to 150 000 ₦ → 5 %; 150 001 ₦ to 160 000 ₦ → 7 %; above 160 000 ₦ → 10 %. (c) Apply conditional formatting to highlight any month where sales are below the average sales of the months with data (i.e., Jan–Nov). (d) Using Goal Seek, determine the sales figure required for December to achieve an annual total sales target of 2 000 000 ₦. Provide the formulas used, the resulting commission values for the months with data, the months highlighted by conditional formatting, and the required December sales figure.
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, orders and products in a relational database. The data collected during the first month of operation are shown in the table below. Table 1: Sample transaction data | CustomerID | CustomerName | CustomerPhone | OrderID | OrderDate | ProductID | ProductName | Quantity | UnitPrice | |------------|--------------|---------------|---------|------------|-----------|-------------|----------|-----------| | C001 | Alice | 0801111111 | O1001 | 2022-01-05 | P01 | Widget | 2 | 1500 | | C001 | Alice | 0801111111 | O1002 | 2022-01-12 | P02 | Gizmo | 1 | 2500 | | C002 | Bayo | 0802222222 | O1003 | 2022-01-08 | P01 | Widget | 1 | 1500 | | C003 | Chidi | 0803333333 | O1004 | 2022-01-15 | P03 | Doohickey | 3 | 500 | | C002 | Bayo | 0802222222 | O1005 | 2022-01-20 | P02 | Gizmo | 2 | 2500 | | C001 | Alice | 0801111111 | O1006 | 2022-01-25 | P03 | Doohickey | 1 | 500 | Using the information above, answer the following questions.
Question Parts
(a)
Identify all non‑trivial functional dependencies that hold in the relation represented by Table 1.
(b)
Based on the functional dependencies you identified, decompose the original relation into a set of tables that are in Third Normal Form (3NF). List each resulting table with its attributes.
(c)
Write the SQL statements required to create each of the 3NF tables you listed in part (b). Include primary‑key definitions and appropriate foreign‑key constraints.
(d)
Write an SQL query that returns the names of customers who have ordered more than one distinct product, together with the number of distinct products ordered by each such customer.
(e)
The database will be used to generate a monthly sales report. Identify two possible sources of error that could affect the accuracy of the report and suggest a practical method to minimise each error.
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