Computer Studies Paper 2 Questions and Answers with Confidential - Form 4 End Term 2 2021

Share via Whatsapp

INSTRUCTIONS TO CANDIDATES

  1. Indicate your name and index number at the right hand corner of each printout
  2. Write your name and index number on the CD/removable storage medium provided
  3. Write the name and version of the software used for each question attempted in the answer sheet provided
  4. Answer all the questions
  5. All questions carry equal marks
  6. Passwords should not be used while saving in the CD/removable storage Medium
  7. Marked printout of the answers on the sheet
  8. Arrange your printouts and staple them together
  9. Hand in all the printouts and the CD/removable storage medium used
  10. All the work should be saved at the desktop of your computer in a folder named with our name and index number. All the work in your folder should be burned to the CD/WR provided


QUESTIONS

  1. The following table contains details of Baharini Girls school (50MARKS)

    ADMNO  Stud 
    name 
    DOB  KCPE 
    MARKS 
    RECEIPT 
    NO 
    Fees 
    Paid(kshs)
    Fees 
    Bal(kshs) 
    House 
    No 
    House 
    Name
    House 
    Capacity
     1001 Alice K 7/4/1999 380 101 20000 5000 H20 simba 200
     1050 Lilly O 2/3/2002 350 894 18000 7000 S08 chui 150
     1202 Mary 8/10/2000 400 500 23000 2000 P30 Kifaru 180
     1025 Juliet 4/4/2000 358 258 25000 0 H20 simba 200
     1200 Joan 5/1/2001 398  259 15000 10000 SO8 chui 150
     1278 Milly 3/4/1998 402 200 15000 10000 H20 simba 200
     1201 Linet 2/7/1998 356 205 20000 5000 P30 Kifaru 180
     1203 Lisper 9/5/2001 403 209 25000 0 S08 chui 150
    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, one for student details, Accounts table and dormitory table (11 mks)
    3. Create a relationship between the three tables (3mks)
    4. Using appropriate forms, Enter the information given into the three tables (15mks)
    5. Create a query for “ all students housed in Chui” (3mks)
    6. Design a “current age query” to display current ages of all the students (5mks)
    7. Create a report “Hefty Balances” showing students with fees balances of more than 10000kshs (3mks)
    8. Create a report to show all students admitted in the school (3mks)
    9. Print,The three tables,Hefty balances report and all students housed in Chui report (5mks) (50MARKS)
  2. QUESTION 2
    Use a spreadsheet to manipulate data in the table below.

    Adm No  Name  Stream  Comp  Art  Bus  Eng  Mat  Student mean Rank
    C001 BARASA  H 56  45  36  56  26    
    C002 Wangila  K 58  57  90  54  23    
    C003 Wafula  H 48  56  54  45  25    
    C004 Wanjala  K 78  95  78  46  24    
    C005 Kerubo  H 49  86  68  35  52    
    C006 Akinyi  K 56  45  25  63  54    
    C007 Odhiambo  H 75  78  45  65  56    
    C008 Okunyuku K 89 69 65 53 51    
    C009 Nekesa H 69 58 45 54 52    
    C0010 Simiyu H 85 46 78 52 53    
      TOTAL                
      TOTAL FOR H              
      TOTAL FOR K              

    1. Enter the data in all bordered worksheet and auto fit all column. Save the workbook as mark 1 (15mks)
    2. Find the total marks for each subject (3mks)
    3. Find total for each subject per stream using a function (5mks)
    4. Find mean mark for each student using a function (5mks)
    5. Rank mean student in descending order using the mean (5mks)
    6. Create a well labeled column chart on a different sheet to show the mean mark of every student. Save the workbook as mark 2. (7mks)
    7. Using mark1, use subtotals to find the average mark for each subject per stream. Save the workbook as mark 3 (7mks)
    8. Print mark 1,mark 2 and the chart (3mks)


MARKING SCHEME

  1.              
    1. Database created(2mks)
    2. Created tables(11 mks)
    3. Created relationships(3mks)
    4. appropriate forms, information entered(15mks)
    5. Query created(3mks)
    6. Correct Current ages featuring(5mks)
    7. Correct report(3mks)
    8. Correct Report(3mks)
    9. printing(3mks)
      TOTAL 50MARKS
  2.                  
    1. Correct data entered in appropriate workbook and worksheets(15mks)
    2. Correct total marks for each student(3mks)
    3. total for each subject per stream using a function(5mks)
    4. mean mark for each student using a function5mks
    5. Rank mean student in descending order using the mean(5mks)
    6. column chart7mks
    7. Average in the right workbook(7mks)
    8. Printing(3mks)
      TOTAL50MARKS


 CONFIDENTIAL

INSTRUCTIONS TO SCHOOLS
The information contained in this document is to enable the head teacher of the school and the teacher in charge of computer studies (451/2) to make adequate preparation for this year’s examination.
Each school offering Computer Studies (451/2) should ensure that:

  1. Each candidate is provided with a computer which has:
    • The following software installed:-
      1. DTP – publisher
      2. Word Processor – Ms Word
      3. Spread sheet – Ms Excel
      4. Database – Ms Access
    • A DVD writing drive and a new blank CD-RW (i.e. compact disk re-writable)
  2. Enough computers and fast printers. Not more than two shifts.
  3. Computer teacher should disable the network and computer related examination in the beginning of each session.
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers with Confidential - Form 4 End Term 2 2021.


Tap Here to Download for 50/-




Why download?

  • ✔ To read offline at any time.
  • ✔ To Print at your convenience
  • ✔ Share Easily with Friends / Students


Get on WhatsApp Download as PDF
.
Subscribe now

access all the content at an affordable rate
or
Buy any individual paper or notes as a pdf via MPESA
and get it sent to you via WhatsApp

 

What does our community say about us?

Join our community on:

  • easyelimu app
  • Telegram
  • facebook page
  • twitter page
  • Pinterest