Computer Studies Paper 2 Questions and Answers - Form 4 End Term 2 Exams 2023

1. Create a workbook and enter the details as above and save it as XYZ – det in your media.
   Rename worksheet as XYZ – 1  (15 Marks)
2.  
   1. Copy contents of XYZ – 1 to XYZ – 2 format as follows ( 2 Marks)
      Labels – FONT ARIAL CYR, COLOUR WHITE, Background colour, Black,BFONT SIZE 14 and justified.
   2. Format values as follows – Font 13, centered, colour black (1½ Marks)
   3. Format cell as follows: - Row height 4.3, line border 2.5 pts (21/2 Mark)
3.  
   1. Copy content XYZ – 2 to XYZ – 3 and complete the Gross profit, reserve, commission and Net profit.
      Net profit = Gross Profit – (Reserve + Commission)  (16 Marks)
      Format the values to 2 decimal – places and currency format.
4. Represent the sales of promoters in a Bar chart and rename chart sheet as XYZ Bar (10Marks)
5. Print XYZ – 2, XYZ – 3, XYZ – bar (3 Marks)

QUESTION 2: DATABASES

Ogeke is the manager of a college’s ICT department. He has been told to use Database Management System (DBMS) to update records for a fundraising data. Perform the following operations just like Ogeke would:

1.  
   1. Create a relational database with four table; Class List, Family Details, Pledge Contributions and Walk Form Contributions. [4 Marks]
   2. Class List contains the following fields; Class no, first Name, surname. Family Details contains Family Id, Parents Name, Address, City and Class no. Pledge Contributions contains Pledge Id, family Id, Amount Pledged and Amount received. Walk Form contribution contains Walk Id, Class no, Walker Name, Amount Promised and Amount Paid.
   3. Save your database as Mchango_01 [2 Marks]
2. Input the following Data into Mchango_01 [11 Marks]
   
   
   1. Create a query that contains the Parents Name and the students' first name who have 'Promised' more than 7000. Save the query as Promised_Mchango. [5 Marks]
   2. Make a query and from it produce a report that list the student name and parents names of families who's Amount Pledged is equal to Amount Received and greater than 0. Save the query as Received Q and the Report as Pledged_Received. [10 Marks]
   3. Make a query from it to produce a report that calculates the difference between pledge and amount received from each family. Save the query as Balance and the Report as Bal_report.   [10 Marks]
   4. Create 4 Reports that can be used to display the 4 tables separately in the database.  Save them as PC, WFC, Class_list and Family_Details respectively print these reports [4 Marks]
   5. Create four forms of each table above and save them as respective table names. [4 marks]

MARKING SCHEME