Computer Studies Paper 2 Questions and Answers - Londiani Joint Mock Exams 2022

Share via Whatsapp

INSTRUCTIONS TO CANDIDATE

  • Type your name and index number at the top right hand corner of each printout.
  • Write your name and index number on the CD-R or CD-RW provided.
  • Write the name and version of the software used for each question attempted in the answer sheet.
  • Answer ALL the questions.
  • All questions carry equal marks.
  • All answers must be saved on the CD
  • Hand in the prints and the CD

QUESTIONS

Question 1
The EAGLE Company is a supplier of the removable storage devices for the Londiani Joint Centers. The following is an extract of sales from the company.
Figure 1

 

A

B

C

D

E

F

G

H

I

 

CENTERS

JAN

FEB

MARCH

APRIL

MAY

JUNE

JULY

AUG

1

LONDIANI GIRLS

43

38

16

33

43

26

32

36

2

CHEPSEON COMPLEX

19

30.5

23

11

40

25

33

28

3

LONDIANI BOYS

14

26.8

22.5

7.3

26

31

16

24

4

KAPCHEPLANGA SECONDARY

16

19

29

33

41

21

17

15

5

SACRED HILL GIRLS

18

34

17

41.2

36

41

18.5

16

6

LONDIANI TOWNSHIP

22

25

28

36

24

36

19

18

  1. Create a workbook to store the above data and save it as EAGLE SUPPLIERS. (10 mks)
  2. Insert a blank row at the top of the worksheet and type the heading “EAGLE SUPPLIERS 2022”, merge and center across the data (3 mks)
  3.  Rename the worksheet as SUPPLIES (1 mk)
  4.                        
    1. Copy supplies sheet into sheet 2 and save it as SUPPLIES TWO. (2 mks)
    2.  Add a column and give headings: SEP. (4 mks)
    3. Given that the sales of January were 5% above month of SEP in all the centers, using absolute cell referencing, calculate the monthly sales of SEP in all the centers. (6mks)
    4.  Compute the average supplies for each center. (3mks)
    5. Format average sales to two decimal places. (2 mks)
  5. Insert a heading Performance after average, and rank the averages in descending order (3 mks)
  6. Assign remarks as follows using appropriate function: (4 mks)

    Average

    Remarks

    less than  20,

    Low

    Up to  25

    Medium

    Above 30

    High

  7. Format all numeric values to 2 decimals places. (2mks)
  8. Format the data headings as follows:
    1. Bold and align to center (2mks)
    2. Data headings orientation of 36˚ (1mk)
  9. Create a pie chart showing centers and average sales . (4 mks)
  10. Print SUPPLIES, SUPPLIES TWO, and PIECHART. (3mks)

QUESTION 2

  1. Using a DTP program, design the publication using the sample given in the next page as your reference and save it as Polite Notice. (29mks)
    In your design take into account the following
    The size of the publication should be A4, portrait orientation. (1mk)
  2. The page margins should be set all-round at 0.6” (Left, Right, Top and Bottom) (2mks)
  3. Format the header to 45pts font size; add a double outline border of 3pts. In weight (2mks)
  4. The text inside the star object should be reverse text, Bold and 20pts. (3mks)
  5. The numbered and bulleted lists should be formatted to 18pts with paragraph spacing of 1.5 (2mks)
  6. Format the arrow lines pointing to the circle outlining the numbered and bulleted lists, and the circle to 2pts in weight with the text inside the circle formatted to 18pts. (3mks)
  7. The vertical text “Remember to abide ……” should be formatted to font size 20pts and underlined with thick dots. (2mk)
  8.                      
    1. Format the line above the “All the Best …. “ text to 4.5pts in weight. (2mks)
    2. Format the text “All the Best …. “ to font size 22pts centered and interlaced. (2mks)
  9. Print the publication. (2mk)

gallardo adada

MARKING SCHEME

QUESTION 1

  1. Creating a workbook and correctly labeling and saving as it appears. (award 10 mks )
  2.                        
    1. Inserting  a  blank row at the top  (1 mk) ,
    2. correct heading  “EAGLE SUPPLIERS 2021”, (1 mk) 
    3. merge and center   (1 mk) 
  3. Renaming  the worksheet as SUPPLIES      (1 mk)
  4.                  
    1. Copying  supplies sheet into sheet 2 and saving it as SUPPLIES TWO    (2 mks)
    2. Adding a column (1 mk) and giving a heading: SEP(1 mk)
    3. Using absolute cell referencing, and calculating the monthly sales of SEP in all the centers. (8mks)
    4. Computing the average supplies for each center. (@0.5*6=3 mks) 
    5.  Formatting  average sales to two decimal places.  (2 mks) 
  5. Inserting  a heading Performance after average (1 mk)  ranking the averages in descending order (2 mks) 
  6. Correctly using the function  IF  to assign remarks (4 mks)
  7. Formatting  all numeric values to 2 decimals places(2 mks)   
  8. Formatting the data headings as follows:
    1. Bold and align to center   (2mks)
    2. Data headings orientation of 36˚ (1mk)
  9. Creating  a pie chart showing centers and average sales correctly label (4 mks)
  10. Print SUPPLIES, SUPPLIES TWO, and PIECHART (@1*3=3 mks)
QUESTION 2
  1. Using the correct DTP program, designing the publication using the sample given and correctly saving. (2mks)
    • Correct title, bold and underline (2mks)
    • Correctly inserting star object with texts inside and shading (5mks)
    • Correct numbering , bulleting and bolding  . (4mks)
    • Correctly inserting dotted circle with text inside and gray background (6 mks)
    • Inserting emoji    (2mks) 
    • Vertical text underline with dotted line (2mks) 
    • Formatting correctly the last sentence, i.e: italizing, applying case, bolding.(3mks)
    • Formatting the page border correctly.(2mks)
      (29mks)
      In your design take into account the following
      Correct size  A4,  and portrait orientation. (0.5*2=1 mk)
  2. correct page margin at 0.6” (inches) or 15.24mm – (Left, Right, Top and Bottom) (0.5*4=2 mks)
  3. Formatting the header to 45pts font size; adding a double outline border of 3pts In weight (1*2=2 mks)
  4.   The text inside the star object should be reverse text inside the star 1mk , Bold 1mk and 20pts. 1mk
  5. The numbered and bulleted lists should be formatted to 18pts with paragraph spacing of 1.5 pts. (2mk)
  6. Format the arrow lines pointing to the circle outlining the numbered and bulleted lists, and the circle to 2pts in weight with the text inside the circle formatted to 18pts. (2mks)
  7. Formatting vertical text “Remember to abide ……”to font size 20pts and underlining with thick dots. (1mk)
  8.                            
    1. Formatting  the line above the “All the Best …. “ text to 4.5pts in weight.(2 mks)
    2. Formatting the text “All the Best …. “ to font size 22pts centered and interlaced. (2mks)
  9. Printing the publication. (1mk)

Download Computer Studies Paper 2 Questions and Answers - Londiani Joint Mock Exams 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


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?