Computer Studies Paper 2 Questions and Answers - Bungoma Diocese Mock Exams 2021/2022

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:

1.  
   1. Create a database named Hotel Details to store the above data. (4mks)
   2. Split the data into two tables. The tables should be named: “Payment table” and “Personal details”. (12mks)
   3. For each of the tables, chose the most appropriate key field. (4mks)
   4. Insert input mask for the phone number field such that the numbers are displayed as 0722-345-671. (2mks)
   5. Create one to many relationship. (4mks)
2.  
   1. 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)
   2. Use the screens created to enter the records in the table above into the appropriate tables. (8mks)
3. Create a query to extract all customers whose names end with letter “a”. Save the query as “END WITH”. (4mks)
4. 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)
5. 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.

1. Enter the data shown above into a spreadsheet and save it as Bama. (16 marks)
2. The word commputer system has been entered incorrectly. Update the information in the spreadsheet. (3 marks)
3. Format all numeric values to 2 decimal places and use comma separators. (4 marks)
4. 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)
5. Using BamaSales find subtotals for each supplier. (6 marks)
6. Using BamaSales’ subtotals for each supplier create a labeled bar graph on a separate worksheet. Save the chart as Supplier. (8 marks)
7. Print Bama, BamaSales, Supplier. (3 marks)

MARKING SCHEME

 Question 1 - Database

Question 2 - Spreadsheet