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 Admission 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
- Create a folder on the desktop called MAVUNO COMPANY LIMITED. (50 marks)
- Using spreads sheet program enter the following data and Save the file as mavuno payroll inside the folder created above.(10 marks)
- Insert printable borders(2 marks)
- Arrange the department from A to Z (2 marks)
- Rename sheet one as original.(1 mark)
- Copy original sheet to sheet two and rename it as payroll, calculate the following ;(12 marks)
- Basic pay
- Gross pay
- Tax deductions
- Nssf contributions
- Allowances
- Net pay
Nb: Use the formula below
BASIC PAY =HOURS WORKED *HOURLY RATE
ALLOWANCE ARE ALLOCATED AS 10% 0F BASIC PAY
Gross pay =BASIC PAY + ALLOWANCE
TAX DEDUCTION is calculates as 20% of the GROSS PAY
NET PAY=GROSS PAY-DEDUCTIONS
- Copy names and basic pay to sheet three rename sheet three as chart.(2 marks)
- Create column chart using employee’s names, basic pay and allowances.(3 marks)
- Set the chart title as payroll at the top 2022(2 marks)
- Insert legend at the bottom(1 mark)
- Add data labels at the top(1 mark)
- Format chart border as; solid line, solid color-red, transparency-50%.(3 marks)
- Copy pno, name,gender,department and netpay from payroll sheet to calculate the following ;
(2 marks)- Calculate the subtotals of each department and grand total, save the sheet as subtotals (4 marks)
- Freeze the header(1 mark)
- Print the following; (4 marks)
- Original worksheet
- Payroll worksheet
- Chart worksheet
- Subtotals worksheet
Question 2
Design a publication to appear exactly as shown in the next page using the following instructions. (20marks)
-
- Launch the DPT package and set measurements to centimeters and the margins 2cm all round
- Paper size A4 portrait.
- Save your work as “Modern computers” (2marks)
- The heading “Introduction to computers The Basics” to have the following styles. (5marks)
- Centered across the page
- Font face
- Font size: 18
- Background Texture: Granite
- Format the drop cap in the first line as it appears
- The heading “Hardware” in the publication to have the styles. (5marks)
- Font face: Arial Narrow
- Font size: 16
- Text weight: Bold
- Character spacing: 180%
- Alignment: Centered
- The text under the heading “Hardware” to be in two columns and having the following styles. (3marks)
- Font size: 12
- Dashed outline on the first column
- First character of the first column to be dropped by 4 lines as shown.
- Insert the banner bearing the text auxiliary as it appears. (3marks)
-
- Enter the text below the banner in three columns as shown (4marks)
- Insert lines between the three columns (3marks)
- Type and format the text below the three columns exactly as it appears (3marks)
- Print the publication.
MARKING SCHEME
Q1. (50 marks)
NO | CRITERIA |
(i) | Entering correct figures(4 marks) Merge and centre heading (2 marks) Wrap text heading (2 marks) Align top and centre heading (2 marks) |
(ii) | Printable borders inserted (2 marks) |
(iii) | Sorting A-Z (2 marks) |
(iv) | Renaming sheet(1 mark) |
(v) |
Correct formulas and figures each 2 marks total(12 marks)
|
(vi) |
Copy + rename 2 marks)
|
(vii) |
Copy content (2 marks) |
(viii) |
Printing (each 1mark)
|
Question 2 (50 MKS)
-
- Correct software @ 2mks
- Measurements to centimeters @ 2mks
- Setting correct margins @ 2mks
- Setting A4 portrait paper @ 2mks
- All round borders as it appears @ 1mk
- Dotted background @ 1mk
- Inserting computer images in correct size and positions @2mks
Typing - First paragraph “many people…” @ 1mk
- Section “computer hardware…” column @ 1mk
- Use of bullets @ 1mk
- Typing second column @2mks
- Use of underline and italics @ 1mk
- Typing and rotating “floppy disk…” @ 2mks
- Saving with correct name @2mks
With any other name @ 1mk - Formatting heading and drop capping 1mk per style×5=5mks
- Heading “Hardware” formatting @ 1mk per format×5=5mks
- Text under “Hardware” formatting @ 1mk per format×3=3mks
- Correct banner 2mks
Correct text formatting @ 1mk -
- Entering the text 2mks
- 3 columns 1mk
- Drop cap 1mk
- Inserting lines between @3mks
- Typing the text below as it appears @3mks
- Printing @ 2mks
Download Computer Studies Paper 2 Questions and Answers - Chogoria Murugi Zone Pre Mock Exams 2023.
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