Computer Studies Paper 2 Questions and Answers - Mumias West Pre Mocks 2022

• Indicate your name and index number at the top right corner of each printout.
• Write your name and index number on the CD / Removable storage medium provided
• Write the name and version of software used for each question attempted in the answer sheet provided.
• Answer all the questions
• All questions carry equal marks
• Passwords should not be used while saving in the CD/Removable storage medium.
• All answers must be saved in your CD/Removable storage medium used.
• Make a printout of the answers on the answer sheet.
• Arrange your printouts and tie / staple them together. 
• Hand in all the printouts and the CD/Removable storage medium used
• Candidates should answer the questions in English

QUESTION ONE 

1. Type the document  below as it appears using a word processing package and save it as Article (30 mks)
   
2. Format the headings, bold, font type Times New Roman, size 14, double underline and Centre alignment (4mks)
3. Put a header and footer. The footer should read “News letter you can rely on” while header should read “:Vision update” (2mks)
4. Insert page numbers N of M on the footer and should be at the right bottom of the document. (2mks)
5. Search for the word computer throughout the Article and replace with “PC” (2mks)
6. Spell check the document (1 mk)
7. Change the first paragraph to double line spacing (2mks)
8. Apply a character space expanded, 30 points to the headline computer. (2mks)
9. Insert a caption for the graphic in the article and name it computer. Place the caption below the graphic (2mks)
10. Save the entire document as Article 1 (1 mk)
11. Print the document Article 1 and Article (2mks)

QUESTION TWO

The following data was extracted from the IEBC registration book. Use it to answer the questions given. 

1. Enter the data shown below in a spreadsheet and save it as Election 2022 (10 mks)
   
2. Rename the sheet as Registration (1 mk)
3. Copy the work into sheet 2 and rename it as Registration1 (1 mk)
4. Sort the worksheet in ascending order of their county (1 mk)
5. Get the totals of voters 2nd registration for each county (3 mks)
6. Copy details on registration sheet and paste it in sheet three. Rename it as registration2 (1 mk)
7. Given that the 1^ST Registration was less than the 2^nd Registration in all constituency by 12%:
   1. Enter the label % increment in cell A20 and the value 12 in B20. (1 mk)
   2. Insert a column between constituency name and 2^nd registration and label it first registration. Use absolute cell reference to calculate the 1^st Registration. (4 mks)
   3. Get the totals for the 1^st Registration and the 2^nd Registration in cell F4. Copy the   formula to the rest of the cells.
      (2 mks)
   4. Some voters transferred from their stations to new stations. Using the total registered column and the voters transferred column. Calculate the new values in cell G4. Copy the formula down to other cells. (3 mks)
8. Using the total registered column, determine
   1. The lowest registered voters in cell G21   (2 mks)
   2. The average number for all registered voters in all constituencies in cell H19 (Use updated registration column)
      (2 mks)
9. Create a column graph on a new sheet. Name it votes. That compares the constituency name against 1^st Registration and 2^nd Registration. Label the following (7 mks)
   • Chart title VOTER REGISTRATION 2022
   • X – Axis:  constituency name
   • Y – Axis:  Registered voters
   • Legend Right
10. Print registration and votes (graphs) sheets (2 mks)

MARKING SCHEME

QUESTION ONE 

1.  
   1. Typing 12 mks
   2. Underlining headings 2mks
   3. Drop cap 2 mks
   4. Column 2 mks
      line 1 mk
   5. Diagram 2 mks
   6. Square wrapping 2 mks
   7. Table
      • Text direction 1 mk
      • Correct shading 2 mks
      • All text at the right position 3 mks
   8. Correct saving 1 mk
2. Format the headings, bold, font type Times New Roman, size 14, double underline and Centre alignment (4mks)
3. The footer  “News letter you can rely on” header  “:Vision update” (2mks)
4. Insert page numbers N of M on the footer at the right bottom of the document. (2mks)
5. Search Article and replace with “PC” (2mks)
6. Spell check the document (1 mk)
7. Change the first paragraph to double line spacing (2mks)
8. Apply a character space expanded, 30 points to the headline computer. (2mks)
9. Insert a caption for the graphic in the article and name it computer. Place the caption below the graphic (2mks)
10. Save the entire document as Article 1 (1 mk)
11. Print the document Article 1 and Article (2mks)

QUESTION TWO

1. Enter the data shown below in a spreadsheet and save it as Election 2022 (10 mks)
2. Rename Registration (1 mk)
3. Copy and rename it as Registration1 (1 mk)
4. Sort in ascending order of their county (1 mk)
5. total number of voters for each county (3 mks)
   
6. Copy &Renaming  registration 2 (1 mk)
7. Given that the 1^st Registration was above the 2^nd Registration in all constituency:
   1. Enter the label % increment in cell A20 and the value 12 in B20. (1 mk)
   2. Insert a column
   3. absolute cell =(E4-($B$20*E4/100)) (4 mks)
   4. =SUM(D4:E4) (2 mks)
   5. =G4-F4 (3 mks)
8. Using the total registered column, determine
   1. =MIN(G4:G18) (2 mks)
   2. The average =AVERAGE(H4:H18) (2 mks)
      
9. Create a column graph on a new sheet. Name it votes. That compares the constituency name against 1^st Registration and 2^nd Registration. Label the following (7 mks)
   • Chart title VOTER REGISTRATION 2022
   • Y – Axis constituency name
   • X – Axis Registered voters
   • Legend Right 
     
10. Print registration and votes (graphs) sheets (2 mks)