Computer Studies Paper 2 Questions and Answers - Lanjet Joint Mock Exams 2020

INSTRUCTIONS TO CANDIDATES

• Type your name and index number on the top right corner
• Write your name and index number on the Re-Writable CD provided
• Passwords should not be used
• Answer all the questions
• All questions carry equal marks (50 Marks)
• Answers MUST be saved in the Re-Writable CD provided.
• Make a print out on the answer sheets given
• Hand in all the printouts and the Re-Writable CD

QUESTION 1

1. Open a Spreadsheet Workbook and Save it as Mzalendo Traders. (10 Mks)
   
2. Copy all the data above to sheet 2 and sheet 3 of your workbook (2 Mks)
3. Rename sheet 1 to “original“; sheet 2 to “filters“ and sheet 3 to “subtotals“ (3 Mks)
4. Find the profit or loss given that the profit is selling price less the buying price.
5. Find the V.A.T given that it is 15% of the profit. (3 Marks)
6. Using formulas on “original”, calculate in the appropriate cells, the amounts spent on buying all the items and the money obtained from the sales (2 Mks)
7. Include a column named comment and use the IF function to fill it with either the word “Profit”, “Flat” or “Loss” depending on whether the item fetched a profit, was sold at the same rate (as buying) or a loss was incurred. (5 mks)
8. On Original sheet, insert a header (Your name and index Number) and footer ( Page number) (4 Marks)
9. On the “Filters” sheet, filter the data so that only those items of category A that fetched profits are displayed (3 Mks)
10. In original, format the buying price, selling price, VAT and the profit into currency KSH. (4 Marks)
11. In original sheet, insert a column chart to compare between buying price, and the selling price and give it the title “MZALENDO” at the top. (8 Marks)
12. Copy the chart into sheet 4 and rename the sheet as Chart. (3 Marks)
13. Print the Original sheet, Filter sheet and the column chart. (3 Marks)

QUESTION 2
Use the following information to answer the questions that follows:

1.       
   1. Create a database called ADMISSIONS and within it prepare a table called students containing the above information. (12mks)
   2. Set an appropriate primary key and data types for the table above (4mks)
2. Get the age of each student given that Age = Adm Date – Date of Birth. (4 Marks)
3. In your table under the field of fee balance sort your data in ascending order and save as sortable. (4mks)
4. Create a query from your table and carry out the following:
   
   1. Set a criteria to show students with a fee balance less than 8,500/= (6mks)
   2. Set a criteria to show students names starting with letter S. (6mks)
5. Create a form called records that shows all fields from the above table. (6mks)
6. Create a tabular report from the student’s table (8mks)
7. Print the students table, fee balance less than 8500 query, and student’s table report. (4 Marks)

MARKING SCHEME

QUESTION 1: WORD PROCESSING

QUESTION 2
SPREADSHEET

1. Saving the work book with the correct name (1mk)
   
   • Using a different name ( ½ mk)
   • Using default name book n, no mark)
2. All data entered correctly (20mks)
   
   • Every wrong entry (½mk)
   • More than 6 wrong entries (-8mks)
3. Renaming the sheet to “Term one result” (1mk)
   
   • Default name sheet n, no mark
4. Correct totals and formula (2mks)
   
   1. Correct Averages and formula (2mks)
   2. Manual calculations no mark
      
      • Correct use of IF function to attain 3 conditions (1x3=3mks)
5. Correct formula and ranking (3mks)
6.    
   1. Correct use of the “count if” function (1x2=2mks)
   2. Sorting list by the class position in ascending order (2mks)
7.    
   • Sorting list by class position in descending order (1mk)
   • No sorting, no mark
8.    
   1. Copying to a new work sheet and renaming the new worksheet (2mks)    
   2. Filtering the “lower group” to:
      
      • Display students form “E” class
      • Student with average less than 50 (4mks)
      • The filter shows all students from “E” class
      • The filter shows all students with average less than 50 (2mks)
9.      
   1. The chart is:
      
      • a bar graph
      • shows 3 cats
      • shows names of students
      • title is TERM ONE COMPUTER RESULTS (3mks)
      • missing a point (-½ mk)
   2. Legend placed at the bottom of chart (1mk)
   3. Saving chart on a new sheet and renaming the sheet graphical analysis
      
      • Saving chart as an object on the worksheet ( ½mk)
10. Printing:
    
    1. The lower group from “E” class (1mk)
    2. The chart (1mk)
    3. Term one result sheet (1mk)