INSTRUCTIONS TO CANDIDATES
- Type your name and admission number at the top right hand corner of each printout
- Sign and write the date of the examination below the name and index number on each printout
- Write your name and index number on the compact disks
- Write the name and version of the software used for each question attempted in the answer sheet
- Passwords should not be used while saving in the compact disks
- Answer all the questions
- All questions carry equal marks
- All answers must be saved in your compact disks
- Make a printout of the answers on the answer sheets provided
- Hand in all the printouts and the compact disks.
QUESTIONS
- The table below shows records kept by Agriculture teacher in Makonge Secondary School on issuing of farm tools to young farmers club members.
- Open a database program and create a database named Y-Farmers. (1 mark)
-
- Create three tables named Class, Students and Items in the database file created in (a) using the following details. (13 marks)
Field name Data types and properties Student_Id Text (Size = 4, Required = Yes ) Student Names Text (Size = 25) Gender Text (size = 2) Class Text (size = 2)
Field name Data types and properties Tool_Id Text (Size = 4, Required = Yes ) Tool Name Text (Size = 15) Number issued Number
Field name Data types and properties Issuing_Id AutoNumber (Size = 2, Required = Yes ) Student_Id Text (Size = 4) Tool_Id Text (Size = 4) Date issued Date and time (Format medium date) Returned (Boolean Yes/No)
- Create three tables named Class, Students and Items in the database file created in (a) using the following details. (13 marks)
- Create the relationship between the three tables. (2 marks)
- Enforce referential integrity between the tables. (1 mark)
- Create data entry form for each table. Save the forms as StudentsForm, ToolsForm and IssuingForm. (3 marks)
- Enter the following data into the database using the respective forms. (12 marks)
Student_Id Student Names Gender Class 900 Silah Rokito F 4W 230 Sarah Martin M 4R 450 Tedd Mwilu F 2S 600 Brian Kibet M 3N
Tool_Id Tool Name Number issued 320 Jembe 22 321 Panga 15 322 Slasher 12 323 Rake 8
Issuing_Id Student_Id Tool_Id Date issued Returned 1 900 320 07/03/2019 Yes 2 600 321 09/04/2019 No 3 230 322 27/04/2019 No 4 900 320 17/04/2019 Yes 5 230 322 07/05/2019 Yes 6 450 321 25/05/2019 No 7 600 323 30/06/2019 Yes 8 230 322 13/07/2019 No 9 450 321 18/07/2019 No 10 600 323 07/04/2019 Yes - Modify the issuing table so as to capture the cost of each tool as shown below.(2 marks)
Tool_Id Tool Cost 320 600 321 450 322 520 323 320 -
- Create a query named T_Query to display the student name, gender, class, tools name and number of tools issued per student and cost. Compute cost of all the tools issued to students. (4 marks)
- Create a query named NR_Query to display the student name, class, tools name, and number of tools issued, date issued and not returned. (4 marks)
-
- Create a report named Y-Report to display students as it appears in figure below. (3 marks)
- Group the records per tool name and compute cost of all the tools issued.(2 marks)
- Create a report named Y-Report to display students as it appears in figure below. (3 marks)
- Generate a bar graph named Tool_Chart to display tool name and the number issued.
- Printout each of the following: (3 marks)
- The three tables
- The two queries
- Report for the first three students.
- The figure below shows the design of a wedding card. It comprises of the back and the front page.
- Open a Desktop Publishing program and make the following page settings.(4 marks)
- Orientation : Landscape
- Units : centimeters
- Paper size : A4
- Margins : 2 cm all round
- Create the weeding card as it appears in Figure 2. Save the design as W_Card.(45 marks)
- Open a Desktop Publishing program and make the following page settings.(4 marks)
Download Computer Studies Paper 2 Questions - Kassu Joint Mock Examination 2021.
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