city guilds model questions vol1 2019 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 2019 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 laboratory is being set up with the following specifications:
- Each workstation uses a 16‑bit address bus and an 8‑bit data bus.
- Main memory installed is 48 KB of RAM.
- A ROM of 8 KB stores the BIOS.
- The lab manager wants to connect a set of identical external storage devices, each requiring a unique address range of 4 KB.
Answer the questions that follow.
Question Parts
(a)
Determine the minimum number of address lines required to address the combined memory (RAM + ROM) fully.
(b)
If the address bus is limited to 16 bits, calculate the maximum number of 4 KB external storage devices that can be mapped without overlapping the existing RAM and ROM address spaces.
(c)
Propose a simple addressing scheme for the maximum number of devices found in part (b). State the starting and ending hexadecimal addresses for the first and the last device.
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.
Question 2
View Details
A single‑CPU system is running three processes (P1, P2, P3). The processes arrive and have the following CPU‑burst times:
| Process | Arrival Time (ms) | Burst Time (ms) |
|---------|-------------------|-----------------|
| P1 | 0 | 6 |
| P2 | 2 | 8 |
| P3 | 4 | 4 |
The CPU uses a non‑preemptive Shortest Job First (SJF) scheduling algorithm.
In addition, the system has two resource types (A and B). At a particular snapshot the allocation and maximum‑demand matrices are:
Allocation:
| | A | B |
|-------|---|---|
| P1 | 1 | 0 |
| P2 | 0 | 1 |
| P3 | 1 | 1 |
Maximum demand:
| | A | B |
|-------|---|---|
| P1 | 2 | 1 |
| P2 | 1 | 2 |
| P3 | 2 | 2 |
Available resources: A = 1, B = 0.
Answer the following questions.
Question Parts
(a)
Draw the Gantt chart for the schedule and state the completion time of each process.
(b)
Calculate the average waiting time and the average turnaround time for the three processes.
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.
Question 3
View Details
You have been given a plain‑text file (employees.txt) that contains the following 10 employee records, each separated by a line break and the fields separated by commas:
```
Ada Okoro,Manager,Finance,750000
Bola Adeyemi,Accountant,Finance,420000
Chinedu Nwankwo,Supervisor,Operations,380000
Dora Mensah,Clerk,Administration,210000
Emeka Obi,Technician,Operations,340000
Femi Oladipo,Analyst,Research,460000
Grace Uche,Assistant,HR,250000
Hassan Yusuf,Engineer,Maintenance,590000
Ijeoma Eze,Officer,Security,300000
James Kalu,Director,Executive,1200000
```
Using a word‑processing application, you are required to produce a formatted employee directory with the following specifications:
* Import the data into a table with appropriate column headings (Name, Position, Department, Salary).
* Apply the built‑in "Heading 1" style to the table header row and ensure the header repeats on every page.
* Adjust column widths so that all data are visible without truncation.
* Insert a calculated field that shows the **total salary expense** and another that shows the **average salary** for the ten employees. Place these two results directly below the table.
* Protect the final document so that the table and the calculated fields cannot be edited accidentally, but allow the user to add comments at the end of the document.
Answer the following:
a) List, in order, the steps you would take to import the data, format the table and insert the calculated fields.
b) Compute the total salary expense and the average salary for the ten employees and show the numerical results you would obtain.
c) Describe two different methods of protecting the document and state which method you would choose if the document is to be printed and distributed to senior management.
Question Parts
(a)
List, in order, the steps you would take to import the data, format the table and insert the calculated fields.
(b)
Compute the total salary expense and the average salary for the ten employees and show the numerical results you would obtain.
(c)
Describe two different methods of protecting the document and state which method you would choose if the document is to be printed and distributed to senior management.
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.
Question 4
View Details
A small retail shop records its daily sales (in Naira) for three products – A, B and C – over a seven‑day period. The data are entered in a spreadsheet as shown below (the first column is the day of the week):
| Day | Product A | Product B | Product C |
|-----|-----------|-----------|-----------|
| Mon | 12,500 | 9,800 | 4,200 |
| Tue | 13,400 | 10,500 | 4,750 |
| Wed | 11,900 | 9,300 | 5,100 |
| Thu | 14,200 | 11,600 | 4,950 |
| Fri | 15,800 | 12,300 | 5,400 |
| Sat | 18,600 | 13,900 | 6,250 |
| Sun | 16,700 | 12,800 | 5,800 |
Using spreadsheet functions, complete the following tasks:
a) Write the formula that will calculate the total weekly sales for each product and the overall total sales for the week. State the cell reference where each total should be placed.
b) Determine which product achieved the highest average daily sales and show the formula you used to obtain the average.
c) Create a column chart that compares the daily sales of the three products. Outline the steps required to insert the chart and to modify its title to “Weekly Sales Comparison” and label the horizontal axis as “Day” and the vertical axis as “Sales (₦)”.
d) Identify one possible source of error that could arise when entering the sales figures and suggest a spreadsheet feature that can be used to minimise this error.
Question Parts
(a)
Write the formula that will calculate the total weekly sales for each product and the overall total sales for the week. State the cell reference where each total should be placed.
(b)
Determine which product achieved the highest average daily sales and show the formula you used to obtain the average.
(c)
Create a column chart that compares the daily sales of the three products. Outline the steps required to insert the chart and to modify its title to “Weekly Sales Comparison” and label the horizontal axis as “Day” and the vertical axis as “Sales (₦)”.
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.
Question 5
View Details
A small retail store maintains a relational database to record its sales activities. The following tables and sample data are stored in the system.
Customers
| customer_id | name | phone | address |
|------------|-----------|-------------|-----------------------|
| C001 | Alice | 0801111111 | 12 Lagos St |
| C002 | Bayo | 0802222222 | 45 Abuja Rd |
| C003 | Chidinma | 0803333333 | 78 Port Harcourt Ave |
Suppliers
| supplier_id | name | contact_email |
|------------|---------------|--------------------|
| S01 | Alpha Supplies| alpha@sup.com |
| S02 | Beta Traders | beta@sup.com |
Products
| product_id | name | unit_price (₦) | supplier_id |
|-----------|------------|----------------|------------|
| P100 | Notebook | 500 | S01 |
| P101 | Pen | 100 | S01 |
| P102 | Calculator | 2500 | S02 |
Orders
| order_id | order_date | customer_id |
|----------|------------|-------------|
| O500 | 2023-03-05 | C001 |
| O501 | 2023-03-15 | C002 |
| O502 | 2023-04-02 | C001 |
OrderItems
| order_id | product_id | quantity |
|----------|------------|----------|
| O500 | P100 | 2 |
| O500 | P101 | 5 |
| O501 | P102 | 1 |
| O501 | P100 | 1 |
| O502 | P101 | 3 |
Based on the above information, answer the following:
Question Parts
(a)
State the functional dependencies for each of the five relations (Customers, Suppliers, Products, Orders, OrderItems). For each relation, indicate the highest normal form (1NF, 2NF, 3NF) it satisfies and justify your answer.
(b)
Write an SQL query that lists the order_id and the number of distinct products purchased in that order for every order where the customer bought more than two different products in a single order. The result should be ordered by order_id ascending.
(c)
Using the sample data provided, calculate the total revenue (in Naira) generated by all orders placed in March 2023. Show the intermediate calculations for each order item used in the total.
(d)
If the attribute contact_email of a supplier were stored in the Products table instead of the Suppliers table, describe one type of data anomaly that could arise and suggest a design change to eliminate the problem.
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.
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