Computer Studies Paper 2 Questions and Answers - Mokasa II Mock Examination 2021/2022

Share via Whatsapp

COMPUTER STUDIES
Paper 2
(PRACTICAL)

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

  1. The table below shows list of students admitted to MOKASA School under different sponsors.
    1. Open a database program and create a database named SPONSORSHIP. (1 mark)
    2.          
      1. Create three tables named Students, Sponsor and Amount received by each student in the database file created in (a) using the following field properties. (10 marks)

        Student_Table
        Field name Data types and properties
        Sch-Code Default value = 520
        AdmNo Text (Size = 4, Required = Yes )
        Student Name Text (Size = 12)
        Date of Birth Date and time (Size = 10)
        AmountId Text (Size = 4, Required = Yes )

        Sponsor_Table
        Field name  Data types and properties
        SponsorID Text (Size = 4, Required = Yes )
        Sponsor Name Text (Size = 16)

        Amount_Table
        Field name Data types and properties
        BankID Text (Size = 4, Required = Yes )
        BankName Text (Size = 10)
        Amount Per Student Number (Size = 8, Decimal Place = 2)
        Mode of payment Text (Size = 12)
      2. Create the relationship between the tables. (2 marks)
      3. Enforce referential integrity between the tables. (1 mark)
      4. Create the three forms StudentForm, SponsorForm and AmountForm. (3 marks)
      5. Enter the following data in their respective tables using the respective forms. (12 marks)

        Table 1: Sponsor_Table
        SponsorID  Sponsor Name 
        S1 Myles
        S2 Bishop
        S3 Myles

        Table 2: Student_Table
        Sch-Code  AdmNo SponsorID  StudName  BankID   DateOfBirth
         520  444  S1 Lilian Mwende  100   12/03/2000
         520 443  S3 Oscar Juma  200   23/01/1998
         520 445  S2 Chebara Omondi  100   11/07/2002
         520 442  S1 Bianca Godana  300   12/05/2005
         520 410  S3 Anorld Schawz  300   28/25/1999
         520  413  S2 King kalala 200   30/09/1998
         520  449  S1 Marx Otaigo 100   18/02/2005
        520 411 S3 Biggie Smalls 100   17/04/2001
        520 412 S2 Brianna Kawaswa 200   19/06/2004
        520 415 S2 Muinde Jake 100   22/03/2003

        Table 3: Amount_Table
        BankID  BankName  Amount Per Student  Mode of payment 
        100   COOP  550 000  EFT
        200 KCB 120 000  M - banking
         300  Sidian 420 000  Cheque
    3. Create a query to display the fields:
      1. AdmNo, Sponsor name, age and Students whose first name start with letter “B” and whose payment Bank is “COOP” Save query as B-query. (4 marks)
      2. StdName, Sponsor name, Mode of payment and Amount per student. Calculate the total amount received. Save query as AMount-query. (3 marks)
      3. StudName, Sponsor name, mode of payment and number of students whose age is above 15 and less than 18 years. Save query as Age-query. (3 marks)
    4. Create a bar chart to display students and their respective amount received. Save chart as S-chart. (2 marks)
    5. Create a report to display the fields as it appears in the figure below. (5 marks)
      Mokasa2compP2Q1e
    6. Print the following: (4 marks)
      1. the Student, Sponsor table and Amount table
      2. the forms
      3. two queries
      4. The chart
      5. the report
  2. The figure below shows the design of a wedding card. You are required to use a desktop publishing software to design the card as it appears. Save as PRE_WEDDING
    Mokasa2compP2Q2
    1. Create the publication with the following page settings and layout: (4 marks)
      1. Paper size : A4
      2. Landscape orientation
      3. Margins: 1.2cm all round
    2. Enter the text and other objects and perform formarting to appear like the design above. (34 marks)
    3. After completing the design, create a copy of the publication and save it As NEW_CARD and apply the following formatting operations:
      1. Set the text information starting with “To their pre-wedding…..” to te following font settings:
        • Font ype: Arial narrow (½ mark)
        • Size: 15pts (1 mark)
        • Line spacing: 1.2sp (1 mark)
        • Indent: Flush left (½ mark)
      2. Automatically insert a calender and position to fit slightly above the church. Mark the pre-wedding date with a red color. (3 marks)
      3. Apply these measurements to the rectangular object containing the heading title “Pre-Wedding Invitation” to 1.67cm height and 15.62 cm width. Add a glow effect (Accent 2. 18pt glow) to the rectangular object. (3 marks)
      4. Put a gradient effect on the text object containing Thanks and God Bless you“. (1 mark)
    4. Print both publications (2 marks)

Marking Scheme

QN Section/Activity Marks Max mark  Marks
awarded


1

  Creating database filename SPONSORSHIP 1 mark  1 mark  
b i
ii
iii
iv
v
Designing tables ( Correct fields and datatypes @1mk)
Creating relationships (Correct key fields, primary keys)
Enforcing referential integrity
Creating form @1mk
Data entry using forms @½mark for each field
2 marks
2 marks
1 mark
3 marks
12 marks
28 marks  
c   Generating queries   10 marks      
i  B-Query 1 mark
Correct criteria
Using appropriate filter
Correct query name
1 mark
1 mark
1 mark
ii Amount-query  
Correct criteria
Appropriate formula/ function for calculated Total Amount field
Correct query name
1 mark
1 mark
1 mark
iii Age-query  
Correct criteria
Appropriate formula/ function for calculated Age Field
Correct query name
1 mark
1 mark
1 mark
d Inserting bar chart
Well labelled parts (X,Y axis)
½ mark
1½ marks
2 marks  
e Creating report   5 marks  
Correct naming of report
Proper formatting, positioning the field objects(@ ½mark)
Title in the report, with underline
½ mark
3 mark
1½ mark
f Printing 4 marks 4 marks  
The student, sponsor table and amount table @½mark
the forms @½ mark
two queries @½ mark
The chart @1 mark
The report @1 mark
  TOTAL MARKS 50 MARKS


2

a Create the publication   4 marks  
Filename PRE_WEDDING
Correct settings
(i) Paper size - A4
(ii) LAndscape orientation
(iii) Margins: 1.2 cm all round @ ½ mark
1 mark

1 mark
1 mark
1 mark
b Designing text and other objects   36 marks  
Rectangular object, with title "Pre-Wedding Invitation"(@ 1mk)
Word art text @1mk
Dotted line
Typing body text and any other text in the design
2 calligraphy fonts used
Bolding of texts (@ ½ mark)
Underline in RSVP
Direction shape, text direct and filling color (@1mk)
Drawing of church, shapes used correctly (@1mk)
Inserting and designing outer border
Hyphenation in "DIRECTION" shape
5 marks
2 marks
1 mark
11 marks
2 marks
2 marks
1 mark
3 marks
5 marks
3 marks
1 mark
c   General queries   10 marks  
i B- Query  
Correct criteria
Using appropriate filter
Correct name
1 mark
1 mark
1 mark
ii Amount-query  
Correct criteria
Appropriate formula/ function for calculated Total Amount field
Correct query name
1 mark
1 mark
1 mark
iii Age-query  
Correct criteria
Appropriate formula/ function for calculated Age field
Correct query name
1 mark
1 mark
1 mark
d Inserting bar chart
Well labeled parts(X, Y axis)
½ mark
1½ marks
2 marks  
e Creating report   5 marks  
Correct naming of report
Proper formatting, positioning the field objects (@½mark)
Title in the report, with underline
½ mark
3 mark
1½ mark
f Printing 4 marks 4 marks  
The student, sponsor table and amount table (@½mark)
the forms (@½ mark)
two queries (@ ½ mark)
the chart (@1 mark)
the report (@ 1 mark)
  TOTAL MARKS 50 MARKS

Download Computer Studies Paper 2 Questions and Answers - Mokasa II Mock Examination 2021/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


Join our whatsapp group for latest updates
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