INSTRUCTIONS TO CANDIDATES
- Type your name and index 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
Question 1
- Using Desktop Publishing application program, design the following publication. Name the file as HEALTHY_SCHOOL (19mks)
- Prepare the page layout out as follows:
- Custom paper size: Width = 11.6”, Height = 8.268 (2mks)
- Set the margins to 0.787” all round (2mks)
- Divide the page into TWO equal horizontal parts using a ruler guide. (2mks)
- The border of the design should start from the set margins (2mks)
NB: After designing one part of the divided page, TWO copies of the publication should fit into one page in landscape as set up above.
- Create a logo as shown to measure height 1.213” and width 1.118” (3mks)
-
- The main title text (near the logo) should be of Candara, Font size 26, Bold and Right aligned (4mks)
- Set-up the rectangular object with the main heading to a background color of Accent 1 (1mk)
- The text on the lower part of the publication should to be formatted as follows: (3mks)
- Color: Custom color combination (Red=51, Green=4, blue=252)
- Alignment: Left
- Font: Size 10
- Format all other text to times new roman font type and font size 12 (2mks)
- Apply a style to the line below the text in columns and a thickness of 4.5” in weight (1mk)
- Enforce hyphenations to the text in columns (1mk)
- The star object with text “Reach every group” should be a 24-point star. Format the text inside to font type calibri (2mks)
- Make the designs to fit one page (1mk)
- Group all objects in the two designs as one. (2mks)
- Insert a footer using your name index number, aligned to the center (2mks)
- Print the publication. (1mk)
Question 2
The information in the table below was obtained from the books of Safiri Transport Company.
CAR | MODEL | REG No | YEAR OF MANUFACTURE | DRIVER | ID No | EMPLOYMENT No | TRIPS MADE | DESTINATION | ALLOWANCE PER TRIP | DAILY PAY RATE |
TOYOTA | PICKUP | KAG 725 H | 1996 | JOHN | 122834 | DI223 | 5 | NAIROBI | 1250 | 1500 |
ISUZU | SALOON | KCB 725 D | 2010 | MARY | 153458 | DI9853 | 3 | KERICHO | 3400 | 1500 |
MAZDA | S/WAGON | KBC 763 L | 2006 | BETTY | 986732 | DO4587 | 15 | KISUMU | 4300 | 1500 |
IVECO | TRUCK | KAG 625 H | 1987 | KYLE | 985443 | DO6592 | 20 | KERICHO | 3400 | 1500 |
TATA | TRUCK | KZG 725 | 2011 | PETER | 758849 | DI4010 | 25 | KERICHO | 3400 | 1500 |
JAC | TRUCK | KAA 740 | 1992 | JERRY | 985873 | DO9203 | 40 | NAIROBI | 1250 | 1500 |
NISSAN | S/WAGON | KAG 552 M | 1990 | PAUL | 857330 | DO8345 | 2 | MUHORONI | 4100 | 1500 |
MAZDA | SALOON | KCB 678 J | 2010 | SETH | 764943 | DI9352 | 15 | MOMBASA | 8000 | 1500 |
MITSUBISHI | TRUCK | KCC 345 F | 2006 | KATE | 934472 | DI8754 | 2 | KERICHO | 3400 | 1500 |
TOYOTA | S/WAGON | KCA 892 U | 1987 | CALEB | 109456 | DI6557 | 1 | MUHORONI | 4100 | 1500 |
TOYOTA | S/WAGON | KAP 544 R | 2011 | TIM | 678842 | DO7395 | 1 | KISUMU | 4300 | 1500 |
ISUZU | S/WAGON | KAP 711 R | 1992 | PATRICK | 764484 | DO5764 | 7 | NAIROBI | 1250 | 1500 |
BENZ | SALOON | KBN 877 C | 1991 | BRIAN | 769973 | DI2343 | 3 | KISUMU | 4300 | 1500 |
- Using a database management application split the information in the above table into two tables namely vehicle and drivers respectively and save the database as Safiri Transport Company (15 Marks)
- Create a relationship between the two tables (2 Marks)
- Create an appropriate form that would be used to enter new records in the driver’s table and save it as form driver (7 Marks)
- Create a query that will display a list of all the drivers who made more than 5 trips to kericho, include all the necessary details. Save it as kericho. (5 Marks)
- Create a query with a calculated field named total allowance to display the total allowance earned by each driver, include all the necessary details. Save it as allowance (5 Marks)
- Using both tables, create a query that would be used to complete each driver’s earnings and save it as pay roll. (3marks)
- Using the payroll query in (f) design a report for Safari Transport Company that would used to calculate total allowance and monthly pay for each driver, assuming that each driver works for 25 days in a month. (7marks)
- Print vehicle, driver, form driver, kericho, allowance and payroll (6 Marks)
MARKING SCHEME
-
- Correct filename “HEALTHY_SCHOOL” 1mk
Fully typed text
Bulleting @ ½mk x 4
Bolding
Numbering
Underlining @½mk x 2
Punctuation
Inserting drop cap (1mk), dropped 3 lines (1mk)
Line between text in columns and graphics in the middle, 4.5’ weight (1mk)
Outline border for the design (1mk)
Correct insertion and placement of graphics in the middle - PAGE LAYOUT
- Correct custom paper size , landscape orientation ( Width = 11.6”, Height = 8.268) @1mk
- Margins (Top, Bottom, Right, Left) @½mk x 4
- Dividing page into two parts with ruler guide – 1 part@1mk
- Fitting design into the set margins – correct placement in relation to the set margins.
- HEALTHCARE LOGO
- Correct placement 1mk
- Measurement: Height 1.213” (1mk) and Width 1.118” (1mk)
- MAIN TITLE TEXT & OBJECT
-
- Upper case ½mk
- Font type – Candara 1mk
- Font size – 26 1mk
- Text aligned to right ½mk
- Object background color – Accent 1(1mk)
-
- TEXT ON THE LOWER PART
- Font color – Custom color combination (Red=51, Green=4, blue=252) @ 1mk, incorrect combination = ½mk
- Aligned to left 1mk
- Font size – 10pts 1mk
- FORMATTING TEXT IN COLUMNS
- Font type – Times new roman 1mk
- Font size – 12pts
- LINE STYLE
- thickness of 4.5” in weight
- Hyphenation (any)
- STAR
- 24 sided star 1mk
- Background color - Black ½mk
- Text inside- font type Calibri ½mk
- Fitting TWO copies of the design into one page
- Correct positioning 1mk
- If not correct award ½mk
- All objects in the design grouped as one (1mk),
- If not grouped 0mk
- FOOTER
- Name 1mk, Index number 1mk
- Correct alignment to center 1mk
- Printing 1
TOTAL MARKS = 50 MARKS
- Correct filename “HEALTHY_SCHOOL” 1mk
-
- Creating database named Safiri Transport Company
Creating and naming the table vehicle
Creating and naming the table drivers
Vehicle table
Creating and naming the table vehicle
Correct field data types
Driver table
Creating and naming the table drivers
Creating and naming field
Primary keys
Vehicle table
Driver table - Two relationships(correct fields)
- Creating forms (Forms with all fields)
Vehicle table
Driver table - Creating query name Kericho
Display drivers details (list of all the drivers who made more than 5 trips to kericho) - Creating query name Allowance
Display driver’s details and total allowance earned by each driver. - Creating query name Pay roll
Compute each driver’s earnings - Creating a report
Total allowance
Monthly pay for each driver - Printing :
Tables:- Vehicle
- Driver
Form - Drivers
Report - Allowance
- Payroll
- Creating database named Safiri Transport Company
Join our whatsapp group for latest updates
Tap Here to Download for 50/-
Get on WhatsApp for 50/-
Download Computer Studies Paper 2 Questions and Answers - Kapsabet Mock 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