INSTRUCTIONS TO CANDIDATES
- Answer all questions.
- All questions carry equal marks.
- Hand in all the printouts and the soft copy of your work on CD.
Question One
The table below shows data obtained from a hotel room booking database. Use it to answer the questions that follow:
Cust ID | Name | Phone number | Room No. | Date of payment | Receipt No. | Amount Paid |
001 | Mercy Kirwa | 0722345671 | 126 | 23/4/2020 | 12345R1 | 7800 |
002 | Stephen Rose | 0733123456 | 347 | 2/4/2020 | 78653R2 | 4500 |
003 | Jotham Mune | 0791256435 | 56 | 05/08/2020 | 12364R1 | 5200 |
004 | Kitanui John | 0782345678 | 78 | 03/05/2020 | 12465R5 | 5678 |
005 | Felix Kimon | 0712678905 | 12 | 01/11/2020 | 12766R3 | 6790 |
006 | Victor Orwa | 0711347890 | 234 | 10/07/2020 | 12067R4 | 5489 |
001 | Mercy Kirwa | 0722345671 | 126 | 23/4/2020 | 12345R1 | 7800 |
005 | Felix Kimon | 0712678905 | 12 | 01/11/2020 | 12766R3 | 6790 |
004 | Kitanui John | 0782345678 | 78 | 03/05/2020 | 12465R5 | 5678 |
006 | Victor Orwa | 0711347890 | 234 | 10/07/2020 | 12067R4 | 5489 |
-
- Create a database named Hotel Details to store the above data. (4mks)
- Split the data into two tables. The tables should be named: “Payment table” and “Personal details”. (12mks)
- For each of the tables, chose the most appropriate key field. (4mks)
- Insert input mask for the phone number field such that the numbers are displayed as 0722-345-671. (2mks)
- Create one to many relationship. (4mks)
-
- Create a data input screen for each table for inputting the data in the table above. Ensure that the name and title of the screen are appropriate. (4mks)
- Use the screens created to enter the records in the table above into the appropriate tables. (8mks)
- Create a query to extract all customers whose names end with letter “a”. Save the query as “END WITH”. (4mks)
- Generate a tabular grouped report showing the total and average of the payments in the payment table. Grouping should be done on the customer’s name (5mks)
- Print the two tables and the report. (3mks)
Question Two
Bama School ordered Computer accessories and the following suppliers provided the following as illustrated below.
A | B | C | D | E | |
1 | FName | ONames | Itemsold | Amount | Date |
2 | Peter | Okada | Mouse | 200 | 12/2/2008 |
3 | James | Mukanda | System Unit | 5000 | 12/3/2008 |
4 | John | Kinyanjui | Keyboard | 200 | 12/4/2008 |
5 | Peter | Okada | CD writer | 2000 | 12/5/2008 |
6 | James | Mukanda | Computer System | 2000 | 12/6/2008 |
7 | John | Kinyanjui | Mouse | 200 | 12/7/2008 |
8 | Freddrick | Okiring' | Mouse | 200 | 12/8/2008 |
9 | John | Kinyanjui | System Unit | 2500 | 12/9/2008 |
10 | Peter | Okada | Keyboard | 200 | 12/10/2008 |
11 | James | Mukanda | CD writer | 3000 | 12/11/2008 |
12 | John | Kinyanjui | Computer System | 5400 | 12/12/2008 |
13 | Freddrick | Okiring' | Mouse | 200 | 12/13/2008 |
14 | Peter | Okada | System Unit | 3000 | 12/14/2008 |
15 | James | Mukanda | Keyboard | 200 | 12/15/2008 |
16 | John | Kinyanjui | CD writer | 2500 | 12/16/2008 |
17 | Freddrick | Okiring' | Computer System | 6000 | 12/17/2008 |
- Enter the data shown above into a spreadsheet and save it as Bama. (16 marks)
- The word commputer system has been entered incorrectly. Update the information in the spreadsheet. (3 marks)
- Format all numeric values to 2 decimal places and use comma separators. (4 marks)
- Copy the content of Bama to a new sheet and rename the sheet as BamaSales. Enter a label in Cell F1 as New Amount. In cell F2 enter a formula to calculate the new amount if the amount went up by a value in cell B18. Copy the formula to the rest of the sheet.(10 marks)
- Using BamaSales find subtotals for each supplier. (6 marks)
- Using BamaSales’ subtotals for each supplier create a labeled bar graph on a separate worksheet. Save the chart as Supplier. (8 marks)
- Print Bama, BamaSales, Supplier. (3 marks)
MARKING SCHEME
Question 1 - Database
Question | Maximum Marks | |
a. i | Database Creation | 2 |
Correctly Named | 2 | |
ii | Tables - Payment Table | 2 |
Personal Details | 2 | |
Table Correctly Split | 2 | |
Correct fields | 4 | |
Correct data types | 2 | |
iii | Primary key - correct | 4 |
iv | Input masks for phone number | 2 |
v | One to many relationship | 4 |
b. i | Two Forms for the two tables | 4 |
ii | Data Entry | 8 |
c. | Correct Query Saved | 2 |
Query properly executed | 2 | |
d. | Tabular Report | 3 |
Grouping | 2 | |
e. | Printing - three files | 3 |
Total | 50 |
Question 2 - Spreadsheet
Question | Maximum Mark | |
a. | Data Entry | 16 |
b. | Updating of the information "computer system" in the spreadsheet. | 3 |
c. | Format all numeric values to 2 decimal places Use comma separators |
2 2 |
d. | Copying data and renaming Enter New Amount Calculate New Amount Copy formula |
2 2 5 1 |
e. | Find subtotals | 6 |
f. | Create a labelled bar graph Save chart on separate sheet |
6 2 |
h. | Printing ( Each 1 mark) | 3 |
Total | 50 |
Download Computer Studies Paper 2 Questions and Answers - Bungoma Diocese Mock Exams 2021/2022.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students