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

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

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)

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)

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)