city guilds model questions vol1 2021 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 2021 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 micro‑controller development board is equipped with a 16‑bit address bus and an 8‑bit data bus. The system uses byte addressing (each address refers to one byte). You are to allocate memory for two data structures: - A character array of 2 048 bytes. - A lookup table of 4 096 bytes. Both structures must be placed in the same memory space without overlapping. The array is to be placed at the lowest available address and the lookup table immediately after the array. Using this information, answer the following:
Question Parts
(a)
State the starting and ending hexadecimal addresses of the character array.
(b)
State the starting and ending hexadecimal addresses of the lookup table.
(c)
What is the highest memory address used by the two structures combined?
(d)
Given that the address bus is 16‑bit, determine the minimum number of address‑line bits that could be permanently tied to 0 (i.e., not used) while still being able to address both structures without overlap.
(e)
Sketch a simple memory‑map diagram (describe it in words) showing the two structures and the unused address range.
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
In a laboratory computer‑systems class you are given the following set of processes that arrive at time 0 ms: | Process | Burst time (ms) | |---------|-----------------| | P1 | 10 | | P2 | 4 | | P3 | 6 | | P4 | 8 | The scheduler uses a Round‑Robin algorithm. Answer the questions below.
Question Parts
(a)
Using a time quantum of 4 ms, draw the Gantt chart showing the order in which the CPU executes the processes until all have completed.
(b)
Calculate the average waiting time of the four processes under this quantum.
(c)
Calculate the average turnaround time of the four processes under this quantum.
(d)
If the time quantum is increased to 8 ms, briefly explain how the average waiting time and the number of context switches would be affected, without performing full calculations.
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 required to produce a short report on the population growth of three Nigerian cities using a word‑processor. The data to be presented are: | City | Population 2020 (in 000) | Population 2021 (in 000) | |---------------|--------------------------|--------------------------| | Lagos | 14,862 | 15,388 | | Kano | 3,626 | 3,770 | | Port Harcourt | 1,117 | 1,210 | The report must be formatted professionally and saved as a PDF.
Question Parts
(a)
Insert a table containing the data above. Add a new column titled “% Increase” that shows the percentage increase from 2020 to 2021 for each city, rounded to one decimal place.
(b)
Apply a heading style to the title “Population Growth Report 2022” and ensure the title appears automatically in the document header on every page.
(c)
Insert a page break after the table. Add a footer that reads “Confidential – Page X of Y”, where X is the current page number and Y is the total number of pages. Explain how the automatic page numbering is set up.
(d)
Save the completed document as a PDF ensuring the table fits within the page margins. List the steps required to export to PDF with the correct layout.
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 the monthly sales (in Naira) of three products over the first six months of the year as shown below: | Month | Product A | Product B | Product C | |-------|-----------|-----------|-----------| | Jan | 12,500 | 9,300 | 4,200 | | Feb | 13,800 | 10,150 | 4,750 | | Mar | 15,200 | 11,400 | 5,300 | | Apr | 14,600 | 10,900 | 5,050 | | May | 16,050 | 12,300 | 5,800 | | Jun | 17,400 | 13,250 | 6,150 | Using a spreadsheet application, the student must analyse the data and present the findings.
Question Parts
(a)
Create a summary table that shows the total sales for each product over the six‑month period. State the formulas used.
(b)
Identify the month with the highest combined sales of all three products. Use a single formula (do not calculate manually) and give the month name as the answer.
(c)
Add three new columns that show, for each month, the percentage contribution of each product to that month’s total sales. Round each percentage to the nearest whole number.
(d)
Insert a line chart that compares the monthly sales trends of the three products. Briefly describe how to set the data range, assign series, label the axes and add a legend.
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
XYZ Retail Ltd. operates an online store. All sales transactions are recorded in a single table called **SALES** with the attributes listed below. The table stores one row for each product sold in a transaction (i.e., a line‑item). **Attributes**: TransactionID, CustomerName, CustomerAddress, CustomerPhone, ProductCode, ProductDescription, UnitPrice, Quantity, TransactionDate, SalesPersonID, SalesPersonName, SalesPersonRegion. **Sample records**: | TransactionID | CustomerName | CustomerAddress | CustomerPhone | ProductCode | ProductDescription | UnitPrice (₦) | Quantity | TransactionDate | SalesPersonID | SalesPersonName | SalesPersonRegion | |---------------|--------------|-----------------|---------------|------------|--------------------|---------------|----------|-----------------|--------------|----------------|-------------------| | 1001 | Ada Okoro | 12 Lagos St | 0801111111 | P01 | USB Cable | 500 | 2 | 2023‑03‑05 | S01 | Emeka | North | | 1001 | Ada Okoro | 12 Lagos St | 0801111111 | P02 | Mouse | 1500 | 1 | 2023‑03‑05 | S01 | Emeka | North | | 1002 | Bola Ade | 34 Abuja Ave | 0802222222 | P01 | USB Cable | 500 | 3 | 2023‑03‑12 | S02 | Chidi | South | | 1003 | Ada Okoro | 12 Lagos St | 0801111111 | P03 | Keyboard | 2500 | 1 | 2023‑04‑02 | S01 | Emeka | North | Using the information above, answer the following:
Question Parts
(a)
Identify all functional dependencies that hold in the **SALES** table (based on the business rules implied by the attributes). Then decompose the table into a set of tables that are in Third Normal Form (3NF). For each resulting table list its attributes, primary key and any foreign keys.
(b)
Write an SQL statement that lists the total sales amount (UnitPrice × Quantity) for each product (ProductCode) for the month of March 2023. The result should show **ProductCode**, **ProductDescription**, and **TotalSales**, ordered by **TotalSales** in descending order.
(c)
Using the sample records given above, calculate the **TotalSales** for each product for March 2023 as would be returned by the query in part (b). Present the result as a table with the three columns required.
(d)
Discuss two possible data‑integrity problems that could arise in the original un‑normalised **SALES** table and propose appropriate integrity constraints or design changes to prevent them.
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