Computer Studies P2 Questions and Answers - Wisdom Pre-Mock Form 4 Exams 2021/2022

Share via Whatsapp

Instructions to candidates

  1. Write 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.
  10. Candidates should check the question paper to ascertain that all the pages are printed as indicated and that no questions are missing.


QUESTIONS

QUESTION 1

  1. Use DTP software to design the following business card using the following layout specifications:
    1. Paper size A4 portrait. (2 marks)
    2. Set the margins to 0.5 inches all round. (2 marks)
    3. Divide the page into TWO columns (2 marks)
    4. The border should occupy the first column (2 marks)
  2. Prepare the publication as exactly as it appears and save it as Business card. (10 marks)
    1 mjgayugda
  3. Insert your full name above the heading “ZENITH LEADERSHIP…” and centre it across(5 marks)
  4. Create the logo to occupy between 0.8” to 1.80” left and 0.70” to 1.85” from top. (5 marks)
  5. The title should occupy between 1.70” to 7.50” across and 0.75” to 1.45” from top. Font Arial black with italics and fill effect pattern of dark horizontal. (5 marks)
  6. The words “ZENITH LEADERSHIP” should occupy 2.50” to 5.70” across and 1.50” to 2.00” from top. Font Book antique size 26, bold and centered. (4 marks)
  7. The rest of the text is in font Bodoni MT size 12. (2 marks)
    1.  Align all the text as shown. (2 marks)
    2. Group the publication as one. (2 marks)
    3. Fit FOUR copies of the design into a single page. (2 marks)
  8. Include a page header with your index number. (2 marks)
  9. Save as Updated Business card. (1 mark)
  10. Print the publication Business card and Updated Business Card. (2 marks)

Question 2
The table below shows records extracted from Motors Sales Company Database. Create a database and name it MOTOR SALES. (1 mark)
2 jagfgdyat

  1. Using the data above, create a table that will hold Car details and another table to hold Customer details. Name them TABLECAR and TABLECUSTOMER respectively and set appropriate primary keys(4 marks)
  2. Enforce referential integrity between two tables. (2 marks)
  3. Create different input forms for each table. Name them FORMCAR and FORMCUSTOMER. Use them to enter data into the tables. (12marks)
  4. Display a report only showing the details of the Customers who have cleared paying for the Car. Name the report REPORTCLEARED. Add “CLEARED CUSTOMERS’’ as the title of the report. (7 marks)
  5. Using the two tables create an outlined report showing the customer details, the total amount paid by each customer and the total amount received by the company. Name the report SUMMARY and the title as “OVERALL CUSTOMERS REPORT.’’ (8 marks)
  6. Create a query to display the Car details with balances of less than 300,000. Name the query as BALQUERY. (4marks)
  7. Create a report showing the Car type, the total sales for each car type and the grand total. Name the report as REPORTGRAND. (6 marks)
  8. Using landscape orientation, print REPORTCLEARED, SUMMARY and REPORTGRAND with footers bearing your lastname and index number at the center of the page. (6 marks)


MARKING SCHEME

Question 1

No

Item

Marks

a i)

A4
Portrait paper

1mk

1mk

   ii)

Margins 0.5

2mks

   iii)

2 Columns

2mks

   iv)

Border

2mks

b

Card

  • Logo image (not strictly globe map)
  • Word Art around the image
  • Service beyond the ordinary text & border
  • Zenith leadership…text (exact format otherwise deny 0.5mks for each)
  • Other text

2mks

2mks

2mks

2mks

2mks

c

Full name

  • Position
  • Full
  • Centred

2mks

2mks

1mk

d

Logo with correct dimensions (not strictly the globe map)

5mks

e          

Title with correct dimensions

5mks

f

Zenith leadership Solutions

  • Dimension across
  • Dimension from top
  • Bold
  • Centre

1mk

1mk

1mk

1mk

g

Bodoni MT Font 12

  • Text alignment
  • Grouping publication
  • Fitting into 4 pages

2mks

2mks

2mks

2mks

h

Page header (All items present, otherwise 2mks if any missing)

2mks

i

Saving with correct name

1mk

j

Printing (@1mk)

2mks

Total

50 Marks

Question 2

Item

Marks

Database with correct name

1mk

TABLECAR and TABLECUSTOMER

@ 2mk = 4mks

Referential integrity

2mks

FORMCAR and FORMCUSTOMER

@ 6mks = 12mks

REPORTCLEARED report. Penalise 1 mark for each missing item.

7mks

SUMMARY report

  • Outlined report
  • All fields
  • Total amount paid
  • Correct title

2mks

2mks

2mks

2mks

BALQUERY

  • Correct name
  • Correct balance calculation

1mk

3mks

REPORTGRAND

  •  All fields specified
  • Grand total
  • Correct name

2mks

3mks

1mk

Printing the 3 reports each in landscape
Bearing last name and index

3mks

@1mk  = 3mks

Total marks

50 Marks

Join our whatsapp group for latest updates

Download Computer Studies P2 Questions and Answers - Wisdom Pre-Mock Form 4 Exams 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


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