Computer Studies Paper 2 Questions - Maranda High Pre Mock Exams 2023

INSTRUCTIONS TO CANDIDATES  

• Indicate your name and index number at the right hand corner of each printout
• Write your name and index number on the CD/removable storage medium provided  
• Write the name and version of the software used for each question attempted in the answer sheet  provided
• Answer all the questions, All questions carry equal marks  
• Passwords should not be used while saving in the CD/removable storage Medium  
• Marked printout of the answers on the sheet  
• Hand in all the printouts and the CD/removable storage medium used  

QUESTION ONE (50 MARKS)  

The following table contains details of Baharini Girls School  

REQUIRED 

1. Create a database file that can be used to store the above data. Name the file Baharini school  database. (2mks) 
2. Create Three tables, student details, Accounts table and dormitory table (11mks) 
3. Format the following fields as follows:
   1. House number to maximum of 3 characters.(1mrk) 
   2. Date of birth as medium date (1mrk) 
   3. Fees pad and fees balance in Ksh. In two decimal points (2mrks) 
   4. House name of data type look up typed.(1mrk)  
4. Create a relationship between the three tables (3mks) 
5. Using appropriate forms, Enter the information given into the three tables (15mks) 
6. Create a query for all students housed in Chui with their adm no and fee balance save as Chui  query (3mks) 
7. Design a “current age query” to display name, Fee paid and current ages of all the student  (5mks) 
8. Create a query Lastborn to display adm no of all the students who were born after 1999 and  have paid more than 20,000. (4mks) 
9. Create a report “Hefty Balances” showing students with fees balances and calculate total  balance (3mks) 
10. Print, The Last born query, Hefty balance report (2mks) 

QUESTION 2  

Enter the following as it is onto worksheet and save it as the budget. (10mks)  

1. Rename sheet 1 as Budget (1mks)  
2. Insert a row above column labels and type the title as: “Aihao business budget.” In uppercase colour  red and double underline in blue. (3mks)  
3. Enter cell B12 and C12, VAT and 18% respectively (1mk) 
4. Rename cell C3 to C10 as Quantity and D3 to D10 as Price. (1mk) 
5. Calculate ;  
   Using name referencing calculate the amount for each item (amount = quantity *price) (2mks) 
   1. Total quantity, price and amount using formulae (3mrks)  
   2. Display the comment “Thank for shopping” for amount above 500, “Almost in a draw” for  amount between 250 and 499, otherwise “Buy More” (4mks)  
6. Rank the items with the most costly ranked as the last (4mks)  
7. Format all currency values on the worksheet to two decimal places aligned right of cell and in pounds  (£) (2mks)  
8. Copy the information on Budget worksheet to worksheet 3. Rename the sheet as copied (2mks)
   1. Save the workbook as Budget2 (1mk)  
9. Change respective quantities of items as follows (1mk)  
   1. Sony 2HD floppy 18  
   2.  200pg A4 books 12
10. Insert column TAX after cost rank, calculate the tax for every item, given that the tax is vat  percentage for only those items whose amount is greater than 600.(3mks) 
11. Merge row 1 to cover only the content of the sheet, Thick box boarder of color yellow and inside  double line of color green.(4mks)  
12. Create a line chart of item description, to compare the amount and tax for every item. Move the chart  in its own sheet named graph, the legend at the bottom, give the chart an appropriate title. (6mks) 
13. Print the chart and Copied Sheet. (2mks)