Computer Studies Paper 2 Questions and Answers - Bunamfan Post Mock 2021 Exams

Share via Whatsapp

Instructions to candidates

  1. Type your name and Index number at the right hand corner of each print out.
  2. Write your name and Index number on the CD provided.
  3. Write the name and version of the software used for each question attempted in the answer sheet
  4. Answer all the questions
  5. Passwords should not be used while saving in the CD provided.
  6. All answers must be saved in your CD provided.
  7. Arrange your printouts and staple them together
  8. Hand in all the printouts and the CD used
  9. This paper consists of 4 printed pages.


QUESTIONS

QUESTION 1: WORD PROCESSING

  1.                        
    1. Open your word processing application and type the following letter on a new blank page (include the dashed line). Save the letter as Course Letter. (15mks)
      1 sf
    2. Open a new blank document and create the table below. Save the file as Course Participant Data. (12mks)
      2we
    3. Using the Course Letter as a form letter and the Course Participants Data as the data source merge the two documents and insert the merged fields Title, First_Name, Surname, Address and City fields above Dear Participant in the letter, as shown below. (12mks)
      3re
    4. Save the mail merge document as Course2021. (2mks)
    5. Prepare envelopes for the participants. Save them as Participant envelopes (7mks)
    6. Print the letter and envelope for Mrs. Mary Collins (2mks)

QUESTION 2: DATABASE
The following records were provided by a Uchumi Bora Supermarket . Study the table and answer the questions that follow. The products having the ProductID starting with value 1 are premium products, others starting with 2 are ordinary products.

ProductID

SalesID

Product Description

Package Quantity

Sales Date

Sales Rate

Sales Quantity(Kgs)

1001

1

Cassava Flour

1Kg

12/08/2020

340

25

2002

2

Wheat Flour

2Kg

14/08/2020

32

45

2003

3

Millet Flour

1Kg

23/08/2020

63

50

2004

4

Maize Flour

2Kg

27/08/2020

50

47

1001

5

Cassava Flour

1Kg

02/09/2020

340

20

1005

6

Amaranth Flour

1/2Kg

09/09/2020

34

30

2003

7

Millet Flour

1Kg

11/09/2020

63

23

1006

8

Moringa Flour

1/2Kg

17/09/2020

78

45

  1. Create a database file named “Uchumi Bora Products”. (2mks)
  2. Split and design the above table into “Products” and “Sales” tables to record products items and sales made respectfully. Set the SalesID to Auto Number. (7mks)
  3. Add appropriate key fields and create a relationship between the two tables. (2mks)
  4. Create the following forms: (6mks)
    1. Columnar Products form named “ProductsForm”, having the title “Product Entry Form”.
    2. Columnar Sales form named “SalesForm”, having the title “Sales Details Entry Form”.
  5. Using the forms in (d) above post the products and sales details to their respectful tables. (8mks)
  6. Create the following queries.
    1. A query named Sales Query that computes sales amount as a product of Sales Quantity and Sales Rate (5mks)
    2. A query named Premium Query to generate a list of premium products, having the fields; Product ID, Product Description, Package Quantity. Order the list in ascending order of ProdID. (6mks)
    3. A query name Date Query to generate sales made between 23/08/2020 and 09/09/2020, having the fields ProductID, Product Description, SalesID, Sales Date and Sales Quantity. (4mks)
  7. Generate the following reports.
    1. Sales report named Sales Report, having the fields ProductID, Product Description, Package Quantity, SalesID, SalesDate, SalesRate and SalesQuantity, grouped by ProductID. (3mks)
    2. A report named VAT Report displaying ProductID, SalesQuantity, SalesRate and SalesAmount from (f) (i); add field named “VAT 16%” and compute VAT as 16% of the SalesAmount. (4mks)
  8.                
    1. Print the tables, Products and Sales (1mk)
    2. Print the queries, Sales Query and Premium Query (1mk)
    3. Print the reports, Sales Report and VAT Report (1mk)


MARKING SCHEME

QUESTION 1: WORD PROCESSING

ITME NO

ITEM/ ACTIVITY

MARKS

1a)

Correct saving name: (other names  award  0 mark)

1mk

 

Dashed line (any other line deny 1/2mk)

1mk

 

Address (full text – otherwise deny the mark)

Bold

Underline

1mk

1mk

1mk

 

RE:…. Text

Bold

Underline

1mk

1mk

1mk

 

Content

  • Accurate & Complete (penalize 1/2mks for each error)
  • Bold & Underline (@1mk)

5mks

2mks

b

  • Correct titles @1mk x 6
  • Correct record @1/2mk x7
  • Correct case 1/2mk (Deny the 0.5mk if any incorrect)
  • Correct saving name (Course Participant Data)

6mks

3.5mks

0.5mk

2mks

c

  • Inserting merging fields@ 1mk x12
  • Inserting at correct location @1mk x12

6mks

6mks

d

Saving the merged file

2mks

e

Envelopes 1mk x7

7mks

f

Printing

  • Letter
  • Envelope

1mk

1mk

Total

50 Marks

QUESTION 2: DATABASE

ITEM

MARKS

Database name

2mks

Splitting @1mk  for correct table

7mks

Primary key

Relationships

1mk

1mk

Forms

  • Products From
  • Sales Form

3mks

3mks

Data entry @correct record 1mk x8

8mks

Sales query

  • Required fields
  • Calculation
  • Saving name

2mks

2mks

1mk

Premium query

  • Required fields
  • Correct Criteria
  • Sort
  • Saving name

2mks

2mks

1mk

1mk

Date query

  • Required fields
  • Criteria
  • Saving name

1mk

2mks

1mk

Sales report

  • Required fields
  • Grouping
  • Saving name

1mk

1mk

1mk

VAT Report

  • Required fields
  • VAT 16% field
  • Calculation
  • Saving name

1mk

1mk

1mk

1mk

Printing

  • Tables @0.5mk
  • Queries @0.5mk
  • Reports @0.5mk

1mk

1mk

1mk

Total

50mks


Download Computer Studies Paper 2 Questions and Answers - Bunamfan Post Mock 2021 Exams.


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