Open menu

Computer Studies Paper 2 Questions and Answers - Asumbi Girls Mock Examinations 2022

Share via Whatsapp

« Previous Topic
Computer Studies Paper 1 Questions and Answers - Asumbi Girls Mock Examinations 2022

Next Topic »
French Paper 1 Questions and Answers - Asumbi Girls Mock Examinations 2022

Download PDF for future reference Get on Whatsapp for 50/-
INSTRUCTIONS TO CANDIDATES:
  • Type your name and index number at the top right hand corner of each printout.
  • Write your name and index number on the CD.
  • Write the name and version of the software used for each question in the answer sheet.
  • Passwords should not be used while saving in the 
  • Answer all questions. All questions carry equal marks.
  • Hand in all the printouts and the CD.

QUESTION 1:  SPREADSHEETS 

  1. The following are the KCSE results for a certain school in Nyeri. Enter the data as it is in Excel and answer the question that follows.
                                                                            KIMAKANIA  HIGH SCHOOL NYERI
    NAME Eng Kis Mat Bio Phy Chem Hist Art Comp Bst Ave. point mark Overall grade  Rank
    THIRU B+ B A B− A B B− A−          
    KIPTOO A− B+ A A− A A− A−     A      
    COLLINS B+ B A B+ A B B            
    RONALD B+ A A A−  A  B+  B+    A        
    FREDRICK A A A B  A  A−  A−    B+        
    NJEGE B+ B+ A  A−  A  B+  B+     A        
    MUARINE A B A  A  A  A−  A−       B−      
    KIBET B A− A  A  A  A  A       A      
    WAFULA B B A  B+  A  B−  B−       A      
    NDIRANGU B+ A− A  B  A  B  B       A      
    OTIENO B+ C A  A−  A  A−  A−       A      
    MATU B A− A  B+  A  B+  B+    A        
    KIBUTHA B B A− B+  A−  B+  B+     A        
    KIRURI A B+ A  A A  A−  A−     A        
    AMING'A B A A  A−  A  A−  A−       C+      
    JACKSON B+ C+ A  B+ A  A  A     B−        
    MUMBI A− A− A− B+  B+  B+  B+     A        
    KIGUTA B+ A A  A  A  A−  A−     A        
    MWANGI B A− A−  B+  A−  A−  A−   A−          
    WAMUCIE B+ B A  A−  A  A−  A−   A          
    MBUGUA B+ B− A  B  A−  B−  B−   A          
    OGEGA B− A− A−  B−  B+  B  B   C          
    HENRY A− A− A  A A  A  A     D+        
    ABDI A B+ A  B+  A  A  A     A        
    JAMES B+ C− A−  B+  A  A  A       B+      
    1. Save your work as Matokeo_Mufti. [15 Marks]
    2. Perform the following calculation for these columns and write down the formulas you used in the spaces provided below each question:
      1. Use a formula to get the average point mark in the table above given that,     [3 Marks]
              Average Point Mark = Average of ( sum of point of all subjects)
         GRADE   POINTS
         A                12
         A−              11
        B+               10
        B                   9
        B−                 8
        C+                7
        C                  6
        C−                5
        D+                4
        D                  3
        D−                2
        E                  1                    
      2. Determine each student's rank using the Ave. Point Mark.    [3 Marks]
      3. Use a formula to evaluate the Overall grade using the Ave. Point Mark, given that:    [3 Marks]
         GRADE      MARKS
         A                 90-100
        A−                81-89
        B+                71-80
        B                  61-70
        B−                51-60
        C+                41-50
        C                   36-40
        C−                 31-35
        D+                 25-30
        D                   20-24
        D−                 16-19
        E                    Below 15
    3. Add in the following table in the same sheet: [5 Marks]
         A   A−  B+  B   B−  C+  C   C−  D+  Number of students  Max Grade Number  Min Grade Number  Average Mark  Average Grade  Rank   %Above pass Mark
       ENG                                 
       KIS                                
       MAT                                
       BIO                                
       PHY                                
       CHEM                                 
       HIST                                
       ART                                
       BST                                
       COMP                                 
                                       
       Overall Grade                                
    4. Calculate the following:
      (NB// Write the formulas used in the space provided below each question)
      1. 'Number of students' per grade for each subject, e.g. 10 students got an A   in History.    [3 Marks]
      2. 'Number of students' column with the number of students who do the specific subject.     [1 mark]
      3. 'Max Grade Number' (=the grade with the highest number of students in that subject.)   [1 mark]
      4. 'Min Grade Number' (= the grade with the lowest number of students in that subject.)     [1 mark]
      5. ‘A subject's Average Mark' = Sum of values for each grade divided by total number of students in that subject (Use the Grade-Value conversion table given in Qn, 2a)(i)    [2 Marks]
      6. Average Grade of the Average Mark using the conversion table in Qn. 2 b(ii) above.     [2 marks]
      7. Rank of each subject as per its average mark use the conversion table Qn, 2a)(i) &(iii) [4 Marks]
      8. A subject's '% Above pass mark' = Percentage of students who had B- or above in that subject. [4 Marks]
    5. Plot a bar graph of the Subjects against their Average Mark [4 Marks]
    6. Put a footnote with your name and index number in the same sheet and print your work.      [2 Marks]
    7. Print the work book [2 Marks]

QUESTION 2: DATABASES

  1. 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]
                                                                                                      CLASS  LIST
       CLASS NO  FIRST NAME  SURNAME
       1  JACOB  MAUNDA
       2  JAMES  MAMBO
       3  MIKE  OGEKE
       4  KEVIN  MALEWA
       5  ALI  ABDI
       6  PHARELL  OGEGA
       7  RICHARD   MOKAYA
       8  DENNIS  KIBET
       9  JOHN  OTIENO
       10  WILSON  KOBIA
       11  JOHN  MATASIA
       12  MOHAMED  ALI
       13  JANET  WAMBUI
       14  GERALD  KOECH
       15  ANDREW  NGUGI
       16  MICHAEL  GICHANGA
       17  PETER  NG'ANG'A
       18  CHRIS  SONKO
       19  BENSUDA  OWINO
       20  FRANCO  WAFULA
       21  KILLY  WAGAIYU
       22  TONY  WAIGANJO

                                                                               FAMLY DETAILS
       FAMILY ID  PARENTS NAME  ADDRESS  CITY  CLASS NO
       1  PROF & DR MAUNDA  89722  KISUMU  8
       2  DR & MAMBO  55554  NAIROBI  21
       3  MR & MRS OGEKE  6935  NYAMIRA  5
       4  MR & MRS MALEWA  54897  NAIROBI  1
       5  MR & MRS ABDI  12548  WAJIR  2
       6  MR & MRS OGEGA  548  NAKURU  3
       7  MR & MRS MOKAYA  1254  KISUMU  4
       8  MR & MRS KIBET  5778  NAIROBI  6
       9  MR & MRS OTIENO  3124  KISUMU  9
       10  MR & MRS KOBIA  5546  NAIROBI  10
       11  MR & MRS MATASIA  44977  NAKURU  11
       12  MR & MRS MOHAMED  96587  NAIROBI  12
       13  DR & MRS WAMBUI  4684  GARISSA  13
       14  DR & MRS KOECH  44687  NAIROBI  14
       15  MR & MRS NGUGI  99978  THIKA  16
       16  MR & MRS NG'ANG'A  222  NAIROBI  17
       17  MR & MRS GICHANGA  65  SIAYA  19
       18  MR & MRS SONKO  650  BARINGO  20
       19  MR & MRS OWINO  987  NAIROBI  22
       20  MR JONES WAFULA  1  KISII  18
       21  MRS KILLY  5541  KISUMU  7
       22  DR & MRS TONY  88754  NAIROBI  15

                                                                                     PLEDGE CONTRIBUTIONS
       PLEDGE ID  AMOUNT PLEDGED  AMOUNT RECEIVED  FAMILY ID
       1  10000  8000  1
       2  25600  25600  22
       3  7800  6000  2
       4  23690  0  3
       5  6587  2300  4
       6  3690  3560  7
       7  5000  500  21
       8  2478  1000  19
       9  0  0  20
       10  35697  0  15
       11  2569  2569  12
       12  200000  20000  10
       13  2560  2500  8
       14  4500  4500  18
       15  8090  7500  14
       16  9600  8560  5
       17  1500  1350  6
       18  7800  7800  9
       19  12000  9850  14
       20  1500  1356  12
       21  6540  6540  11
       22  1350  1200  13

                                                                              WALKER FROM CONTRIBUTIONS
       WALK ID  WALKER NAME   AMOUNT PROMISED  AMOUNT PAID  CLASS NO
       1  GIKONGE   5000  3000  1
       2  MORAA   2580  0  10
       3  KERUBO   500  6000  16
       4  JAMES   20  15  6
       5  NJUKI   5980  2300  14
       6  SABINA   6300  3560  7
       7  JOHN   100  100  22
       8  KALVIN   689  0  18
       9  KOECH   8595  700  15
       10  OTIENO   3695  300  5
       11  ABDI   10000  10000  17
       12  JACK   15698  68  20
       13  EDWARD   12350  500  19
       14  MUTITO   7050  5000  8
       15  MWAMBORA   20000  6958  4
       16  NJAMBI   1900  1200  3
       17  KIPKEMOI   2300  2100  2
       18  COLLINS   5640   4560  9
       19  KARURI  1230  985  21
       20  NYANCHAMA   456  400  12
       21  OGEGA   780  700  13
       22  CHEBII   5640  5600  11

      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 ReceivedQ 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

 NO  AREA  MAX MARKS  MARKS AWARDED
 1  QUESTION ONE: SPREADSHEETS    
 1a)  Save work book as MATOKEO_MUFTI  2  
   Creating borders, column &row headers correctly  5  
   Typing data correctly as it appears in the worksheet  8  
 b i)  Average point mark  3  
 ii)  Rank using the Ave. point mark  3  
 iii)  Overall grade using Ave. point Mark  3   
 c (i)  No. of students per grade  3  
 ii)  No. of students taling specific subject  1  
 iii)  Max grade number  1   
 iv)  Min grade number  1  
 v)  A subject Average mark  2  
 vi)  Average grade of the Average Mark  2  
 vii)  Rank of each subject as per its average mark  4  
 vii)  % Above pass mark (>B−minus)  4  
 d   Bar graph (Correct bar graph Subject vs Average mark)  4  
 e  Footnote (name and index no)  2  
 f  Printing the workbook  2  
   TOTAL  50  

 

 NO  AREA   MAX MARKS   MARKS AWARDED 
 2  QUESTION TWO: DATABASES    
 a i)  Correct desing of 4 tables; Class list, Pleadge....@ 1 mark  4  
 iii)  Saving the database exactly as : Machango_01 { award 2 or 1 }  2  
 b)  Entering data into Mchango_01    
 
  •  Correct data types & designs in the tables @ 2
  • Correct data entry
   8
  3		  
 i)  A query called Promised_Mchango    
 
  •  Correct name; wrong name = 0
  • Correct fields
  • Correct computation
   1
  2
  2		  
 ii)  A query called ReceivedQ    
 
  •  Correct name; wrong name = 0
  • Correct fields
  • Correct computation
   1
  2
  3		  
   A report called Pledged_Received    
 
  •  Correct name; wrong name = 0
  1  
 
  •  Correct fields
  3  
 iii)  A query called Balance    
 
  • Correct name; wrong name = 0
  • Correct fields
  • Correct computation
   1
  2
  3		  
   A report called Bal_report    
 
  •  Correct name; wrong name = 0
  • Correct fields
  1
 3		  
 iv)  4 reports: Award each correct report @ 1 mark (1 *4 = 4)  4  
 v)  4 forms: Award each correct Forms @ 1 mark ( 1* 4 = 4)  4  
   TOTAL  50  
Join our whatsapp group for latest updates

Download Computer Studies Paper 2 Questions and Answers - Asumbi Girls Mock Examinations 2022.


Tap Here to Download for 50/-


Why download?

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

Read 959 times Last modified on Thursday, 29 September 2022 10:13

« Previous Topic
Computer Studies Paper 1 Questions and Answers - Asumbi Girls Mock Examinations 2022

Next Topic »
French Paper 1 Questions and Answers - Asumbi Girls Mock Examinations 2022

Print PDF for future reference
Published in Asumbi Girls High School Mock Exam 2022 Questions and Answers
back to top
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?