Computer Studies Paper 2 Questions and Answers - Mathioya Mock Exams 2022

Questions

Instructions to candidates

• Indicate you name and index number at the top right hand corner of each printout.
• Write your name and index number on the CD/Removable 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.
• Passwords should not be used while saving in the CD/Removable provided.
• All answers must be saved in your CD/Removable provided.
• Make a printout of the answers on the answer sheet.
• Arrange your printouts and staple them together.
• Hand in all the printouts and the CD/Removable used.
• Candidates should answer the questions in English.

1. The following is a worksheet extracted from Mathioya Youth Group Vendors. They have come together to do a business of selling computer accessories.
   

   MATHIOYA YOUTH GROUP VENDORS NET PROFIT ANALYSIS
   Vendor Name	Cost	Sales	Gross Profit	Expenditure	Reserves	Net Profit	Remarks
   Susan Muthoni	7 000	13 500		1 450
   Dennis Ikahu	4 000	7 000		1 500
   Judith Nekesa	2 000	9 800		800
   Peter Kiondo	3 000	6 500		800
   Alice Ruguru	1 000	3 000		700
   Salome Maina	4 000	5 500		500
   Joseph Opiyo	6 500	8 000		400
   Sonia Wambui	5 550	8 885		550
   Mary Watiri	2 500	8 850		700
   Leah Wanjeri	5 000	9 360		540
   Joy Maelo	7 000	10 350		450
   Mohammed Dida	9  000	12 000		1 800
   Kevin Nyutu	8 500	10 950		1 250
   Michael Karanja	1 100	5 700		1 500
   Hilda Njeri	3 500	8 000		1 150

   Additional information
   1. Gross profit = Sales – Cost
   2. Reserves is 10% of Gross Profit.
   3. Net profit = Gross profit – (Expenditure + Reserves)
      1. Create a workbook and enter the details as above. Rename the worksheet as Partner’s Vendor hence save your file as Youth Group. (18 marks)
      2. Keep the title of the centered across the table and format it to be bold, font size 16 and Rockwell font. (2 marks)
      3. Apply a text direction of 45° to all column labels in the table above. (2 marks)
      4. Format the figures in sale column to 2 decimal places. (1 mark)
      5. Using Data Validation tool apply a rule to the cells under Vendor names label as follows: (3 marks)
         Settings: Allow text whose length is larger than five.
         Input Message: With a title, “Vendor Name” and a message “Kindly enter a vendor name in this cell”.
         Error Alert: Title, “Invalid Input” and a message “The name you entered is too short for this cell. Please try again”. With a style Stop.
      6. Use appropriate formulae/function to calculate:
         1. Gross profit for each member. (2 marks)
         2. Reserves for each member. (2 marks)
         3. Net profit for each member. (2 marks)
      7. Use “IF function” and net profit to analyse the vendors, taking the following remarks: (4 marks)
         1. If net profit > = 5000, then “V.Good vendor”
         2. If net profit > 2500 to 4999, then “Good vendor”.
         3. If net profit < = 2500, then “Dormant vendor”.
      8. Type the labels Sales Above 5000 and Total Expenditure above 500 in cells A21 and A22 respectively. (1 mark)
      9. Using appropriate functions work out the Number of Sales exceeding 5000 and then Total Expenditure exceeding 500 into cells C21 and C22 respectively. (2 marks)
      10. Insert a new column between Expenditure and reserves and label it as Expenditure Rank. Use the new column to find the expenditure position using an appropriate function. The vendor with the least expenditure should be given Position 1 while the one with highest should be given the last position. (4 marks)
      11. Use names of the vendor and cost to insert line graph, the title of the graph to be Productive Analysis, format it and place it in a separate sheet. (5 marks)
      12. Print the Partner’s Vendor and Productive Analysis chart. (2 marks)
2.    
   1. Use a DTP software to design the following publication as it is with the following settings:
      1. paper size = A4
      2. orientation = Landscape
      3. page margins = 0.5 inches all around
      4. Guides = 3 equal column guides
      5. File name = DotNetGen (5 marks)
   2. Create the three textboxes containing the story. Link the textboxes so as to have the text Autoflowing to the next textbox once the previous one gets filled up. (5 marks)
   3. Design the publication as it appears on the following page on the page you have created and fit all the items within the page. (31 marks)
   4. Disable automatic hyphenation from the story in the textboxes. (3 marks)
   5. Insert your name and admission number as header, then your class and page number as footer. (4 marks)
   6. Print the publication. (2 marks)

Confidential

The information contained in this document is to enable the headteacher of the school and the teacher in charge of Computer Studies (451/2) to make adequate preparation for this year’s examination.

1. Each candidate is provided with a computer which has:
   • a new blank CD-RW (i.e. compact disk re-writable)
   • a DVD writing drive
   • The following software installed:
     1. DTP - MS publisher or PageMaker
     2. Word processor - MS Word
     3. Spreadsheet - MS Excel
     4. Database - MS Access
2. Enough computers and fast printers. Two shifts of candidates are recommended.
3. Provide IBM compatible computers
4. Computer teacher should disable the network and computer related examination in the beginning of each session.

Marking Scheme

1.      
   1. Create a workbook and enter the details as above. Rename the worksheet as Partner’s Vendor hence save your file as Youth Group.
      18mks
      
      • Entering all data into a worksheet
      • Correctness/accuracy in entry of data
      • Application of borders to the table
      • Bolding the header row and title
      • Typing title in two lines/rows (i.e. not as one continuous line)
      • Renaming the worksheet as Partner’s Vendor
      • Correctly saved file as Youth Group
   2. Keep the title of the centered across the table and format it to be bold, font size 16 and Rockwell font.
      • Merging and cantering the title across the table
      • Bolding, Font size and Font
   3. Apply a text direction of 45° to all column labels in the table above.
      At least 4 Correctly rotated labels @ ½
   4. Format the figures in sale column to 2 decimal places.
      Correct format of decimals in sales values to 2 d.p.
   5. Using Data Validation tool apply a rule to the cells under Vendor names label as follows:
      
      Settings: Allow text whose length is larger than five.
      Input Message: With a title, “Vendor Name” and a message “Kindly enter a vendor name in this cell”.
      Error Alert: Title, “Invalid Input” and a message “The name you entered is too short for this cell. Please try again”. With a style Stop.
   6. Use appropriate formulae/function to calculate:
      1. Gross profit for each member.
      2. Reserves for each member
      3. Net profit for each member.
   7. Use “IF function” and net profit to analyse the vendors, taking the following remarks:
      1. Attempt to use IF function
      2. Use of IF Function correctly as follows
         =IF(G4>=5000,"V.Good vendor",IF(G4>=2500,"Good vendor","Dormant vendor"))
      3. Copying the formula to all cells
   8. Type the labels Sales Above 5000 and Total Expenditure above 500 in cells A21 and A22 respectively. (1 mark)
   9. Using appropriate functions work out the Number of Sales exceeding 5000 and then Total Expenditure exceeding 500 into cells C21 and C22 respectively.
      • =COUNTIF(C4:C18, “>5000”)
      • =SUMIF(E4:E18, “>500”)
   10. Insert a new column between Expenditure and reserves and label it as Expenditure Rank. Use the new column to find the expenditure position using an appropriate function. The vendor with the least expenditure should be given Position 1 while the one with highest should be given the last position.
       • Inserting Column
       • Attempt to insert RANK function
       • Using RANK function correctly i.e. =RANK(E4,$E$4:$E$18,1)
       • Copying the formula
   11. Use names of the vendor and cost to insert line graph, the title of the graph to be Productive Analysis, format it and place it in a separate sheet.
       
       
       • Line Chart
       • Correct Series
       • X-Axis Labels
       • Title
       • Y-Values
   12. Print the Partner’s Vendor and Productive Analysis chart.
2.   
   1. Use a DTP software to design the following publication as it is with the following settings:
      • paper size = A4
      • orientation = Landscape
      • page margins = 0.5 inches all around
      • Guides = 3 equal column guides
      • File name = DotNetGen
   2. Create the three textboxes containing the story. Link the textboxes so as to have the text Autoflowing to the next textbox once the previous one gets filled up.
      • Drawing/inserting three textboxes into respective columns @ 1mk
      • Creating Links between the boxes @ 1mk
   3. Design the publication as it appears on the following page on the page you have created and fit all the items within the page.
      Attempt to use correct fonts
      Heading in the shape:
      • Enlarged font size
      • White Font colour
      • Correct shape
      • Shape fill colour
        
        Text Below heading: By Timothy Williamson…
      • Italics
      • Right aligned
        
        Text In Columns
      • Completeness
      • Alignment (Justify)
      • Bolding (any four @ ½)
      • Italicizing (any four @ ½)
      • Paragraph spacing
      • Drop cap
      • Vertical text (19th Century computers)
      • White font colour
      • Large font
      • Vertical direction
        
        Circular Logo
      • Word art
      • Drawing
      • Arrangement
        
        Box at Bottom right Corner
      • Compound border
      • Inserting Symbol
      • Facebook logo
      • Text alignment (center)
   4. Disable automatic hyphenation from the story in the textboxes.
      • Removal of hyphens in each text box @ 1mk
   5. Insert your name and admission number as header, then your class and page number as footer.
      • Attempt to insert header
      • Correct Header
      • Attempt to insert footer
      • Correct Footer
   6. Print the publication.