Instructions to candidates
- Write your name and Index number at the right hand corner of each print out.
- Write your name and Index number on the CD provided.
- Write the name and version of the software used for each question attempted in the answer sheet
- Answer all the questions
- Passwords should not be used while saving in the CD provided.
- All answers must be saved in your CD provided.
- Arrange your printouts and staple them together
- Hand in all the printouts and the CD used
- This paper consists of 4 printed pages.
- 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
- Use DTP software to design the following business card using the following layout specifications:
- Paper size A4 portrait. (2 marks)
- Set the margins to 0.5 inches all round. (2 marks)
- Divide the page into TWO columns (2 marks)
- The border should occupy the first column (2 marks)
- Prepare the publication as exactly as it appears and save it as Business card. (10 marks)
- Insert your full name above the heading “ZENITH LEADERSHIP…” and centre it across(5 marks)
- Create the logo to occupy between 0.8” to 1.80” left and 0.70” to 1.85” from top. (5 marks)
- 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)
- 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)
- The rest of the text is in font Bodoni MT size 12. (2 marks)
- Align all the text as shown. (2 marks)
- Group the publication as one. (2 marks)
- Fit FOUR copies of the design into a single page. (2 marks)
- Include a page header with your index number. (2 marks)
- Save as Updated Business card. (1 mark)
- 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)
- 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)
- Enforce referential integrity between two tables. (2 marks)
- Create different input forms for each table. Name them FORMCAR and FORMCUSTOMER. Use them to enter data into the tables. (12marks)
- 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)
- 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)
- Create a query to display the Car details with balances of less than 300,000. Name the query as BALQUERY. (4marks)
- 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)
- 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 |
1mk 1mk |
ii) |
Margins 0.5 |
2mks |
iii) |
2 Columns |
2mks |
iv) |
Border |
2mks |
b |
Card
|
2mks 2mks 2mks 2mks 2mks |
c |
Full name
|
2mks 2mks 1mk |
d |
Logo with correct dimensions (not strictly the globe map) |
5mks |
e |
Title with correct dimensions |
5mks |
f |
Zenith leadership Solutions
|
1mk 1mk 1mk 1mk |
g |
Bodoni MT Font 12
|
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
|
2mks 2mks 2mks 2mks |
BALQUERY
|
1mk 3mks |
REPORTGRAND
|
2mks 3mks 1mk |
Printing the 3 reports each in landscape |
3mks @1mk = 3mks |
Total marks |
50 Marks |
Download Computer Studies P2 Questions and Answers - Wisdom Pre-Mock Form 4 Exams 2021/2022.
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Why download?
- ✔ To read offline at any time.
- ✔ To Print at your convenience
- ✔ Share Easily with Friends / Students