Computer Studies Paper 2 Questions and Answers - Form 3 End Term 3 Exams 2023

Instruction to Candidates

• The Paper has two questions.
• Answer all the questions.
• Write your name and on the CD.
• Write the name and version of software used in each question on the answer sheet.
• Password should not be used on CD.
• All answer must be saved on the CD.
• Hand in all the printouts and the CD.

QUESTION ONE (50 MARKS)

1. Using an appropriate word processing, type the following passage and save it in as: Data (10mks)
   Data security and control
   External threats
   1. Fire. Floods, earthquakes, and other natural disasters, these are the potential threats hut are not the most common external problems,
   2. Theft of equipment- theft of pc’s laser printers and even memory chips after a Break into a building are quite common.
   3. Espionage (intelligence) - information in the wrong hands can do a lot of damage. Example access to a payroll or accounting information is restricted so such information should be shielded from external and internal spies.
      Internal threats
      Internal threat would include.
      1. hacking
      2. Fraud
      3. Hardware failure
      4. Corruption of databases
         Viruses load and run without the user requesting them to run and cause considerable damage e.g.
         1. Modifying another program
         2. Hiding inside other programs with an aim of spreading to another machine
         3. Destroying data and programs.
            It is a computer code which usually designed to carry out two tasks:
            1. To replicate itself’ from one computer s stem to another.
            2. To locate itself’ within a computer system in such a way as to make it possible for it to amend or destroy programs and data files, by interfering with the normal processes of the operating system.
               Questions
               1. Copy the document to the next page. (2mks)
               2. Format the headings as follows: (6mks)
                  

                  	Front Size	Font type	Underline	bold
                  Data security and control	14	Times New Roman	Yes	Yes
                  External threats	14	Monotype Corsiva	None	Yes
                  Internal threats	14	Default	Yes	No

               3. Change the numbering to bullets; as follows: (2mks)
                  

                  Headings	Bullet
                  i) External threats   (ii) Internal Threats	>
                  	.

               4. Strike through the word internal threats (2mks)
2.  
   1. Insert the ANY clipart at the bottom center of the document. (3mks)
   2. Create word art as indicated by the symbol. (2mks)
                                             
   3. Using auto shape, design a logo as indicated by the symbol. (2mks)
                                            
3. Save the document as security (2mks)
4.  
   1. Copy the original document (data security) to the next page(2mks)
   2. Drop cap the first letter of the document (D) to cover two lines (1mk)
   3. Spell check the whole document. (2mks
   4. Double space and italics the first paragraph (3mks)
   5. Insert a header ‘computer threat’ to appear in every page (2mks)
   6. Number the pages using the format I,ii,iii..... at the center of the page.     (3mks)
5. Save the document as COMPUTER THREAT (2mks)
6. Print the document
   1. Data security (1mk)
   2. Security (1mk)
   3. Computer threat (1mk)

QUESTION TWO:

The table below shows an extract of the Form Three Performance in the three exams of the term. Using spreadsheet package create a workbook and save as: Class Performance MERIT. (12mks)

1. In column F calculate the average performance of all the students. (2mks)
2. In row 12, find the lowest score in every exam. (3mks)
3. In cells B15, B16 and B17 insert the values 0.25, 0.35 and 0.4 respectively. (3mks)
4. Rename the cells B15, B16 and B17 as EX1, EX2 and EX3 respectively. (3mks)\
5. Insert a column between 3rd exam and average and name as score. (2mks)
6. Using absolute cell reference Calculate the score for Rebeca as Sum of 25% of 1st Exam, 35% of 2nd Exam, and 40% of 3rdExam. (3mks)
7. Copy the formula upwards to calculate the score for all the students. (3mks)
   1. Create a pie chart showing the students admission number and the average on the same sheet. (5mks)
   2. Have the chart title as 'Performance Merit’ (1mk)
   3. Put the legend to the left of the chart. (1mk)
8. Copy the admission number, 1^st Exam, and 2^nd Exam to sheet 2. (2mks)
9. Create a column called points to award the students points based on the average of the two exams as follows: (4mks)
   

   Average	Points
   >80	12
   >60	8
   >40	6
   >0	2

10. Calculate the total points scored by all the students. (2mks)
11. Calculate the number of students who have 70 and above in Exam 2. (2mks)
12. Print sheet 1. (2mks)

                                                                                           MARKING SCHEME