Get premium membership and access revision papers with marking schemes, video lessons and live classes.

Form 2 Computer Studies Paper 1 End of Term 3 Examination 2022

Class: Form 2

Subject: Computer Studies

Level: High School

Exam Category: Form 2 End Term 3 Exams

Document Type: Pdf

Views: 919 Downloads: 20

Exam Summary

TERM 3 END YEAR EXAM - 2022 COMPUTER STUDIES 451/1 (THEORY)
FORM TWO PAPER 1 TIME 2 Hrs.
NAME……………………………………………………ADM NO……………………………
SCHOOL:…………………..SIGN: ………………………. DATE:…………………………..
INSTRUCTION TO CANDIDATES
 Write your Name and Index number in spaces provided above.
 This paper consists TWO sections.
 Answer ALL questions in section A.
 Answer Question 16 and any other THREE Questions from Section B
 All answers MUST be written in the spaces provided on this question paper.

SECTION A (40MARKS) ANSWER ALL THE QUESTION IN THIS SECTION
1. State three differences between impact printers and non-Impact printer(3marks)
_________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
2. Peter used a compact disk recordable to save his work. ½ of the disk was used to store video files while ¼ of the remainder was to save audio file. Note that CD-recordable is 700MB. Calculate the remaining space in bytes (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
3. Describe four ways in which ICT can be used to improve health care provision (4Marks)
________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
4. Mention three factors to consider when choosing an ISP for internet connectivity (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
5. Describe the term portability as used in the following context.
(i) Hardware(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Software(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
6. John is a first-year student at JKUAT. He is expected to login his student portal to access online assignments. Mention three ways in which he would prevent virus from infecting his computer (3marks)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
7. Using relevant examples distinguish between a formula and function (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
8. Musato high school wanted to setup a network connectivity to be used in school. Mention three internet connectivity requirement that the school must have in order to get the connection (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
9. What is a master page in Desktop publishing (2marks)?
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
10. State the function of the following keys.
(i) Return key(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Delete(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
11. Describe the following features of Database management software.
(i) Macro (1mark)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(ii) Table (1mark)
_________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________________________________________________
12. State three factors to consider when choosing a monitor (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
13. Milenga Special School received grants from the National government to purchase computers to be used in the departments and the Headteachers’ office, as a computer student the headteacher approached you to guide him on the hardware and software considerations to execute the project. Mention four hardware related factors that you need to consider for the project to be implemented successful (4marks)
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
14. Describe three functions of an operating system(3marks)
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
15. Describe the effects of the following actions in a computer lab.
(a) Eating in a computer laboratory (1mark)
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(b) Smoking in the computer laboratory (1mark)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

SECTION B (60 MARKS)
ANSWER ALL THE QUESTION I THIS SECTION
16. (i)Describe three components of a spreadsheet (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(ii)Describe three components of a function (3marks) ____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(ii)A School keeps a spreadsheet of examination results in four subjects. Part of the spreadsheet is shown below.

(a) What formula has been used to:
(i) Calculate the mean score for Math (1mark)
_____________________________________________________________________________________
(ii) Assign Lenski position 6 out of 7(1mark)
_____________________________________________________________________________________
(iii)Get student with the highest marks in Math and Science(1mark)
_____________________________________________________________________________________
(b) Show how cell G10 can be represented in R1C1 style (1mark)
_________________________________________________________________________________________
(c) Write a function that will display Excellent, Good, Average and Fail in the remark column based on the average score (3marks)

(d) State the validation check that should be carried out on data entered in cell C2 to F8 to ensure values over 100 are not input (2marks)
_____________________________________________________________________________________
17.
(a) List two items found in Ms-word formatting toolbar (2marks)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(b) With an aid of a diagram explain the difference between merging cells and splitting cells (3marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(c) Mark Jacob typed Kanga High School in a Ms-Word workspace. State how the line of text will appear if he applies the following change case option.
(i) Toggle case(1mark)
________________________________________________________________________________________
(ii) Sentence case(1mark)
________________________________________________________________________________________
(iii) Upper case (1mark)
________________________________________________________________________________________
(d) James was preparing a document which contains lines of text and graphic. When he typed the last sentence, the whole sentence was pushed to the next page making the document to have two pages. Mention fours ways that can be applied to this document to make it fits with a page(3marks)
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(e) Describe four proofreading tools supported by Ms-words(4marks)
_____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
18.
(a) State the difference between Fill and stroke as applied in DTP (2marks)
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(b) Give three purposes of desktop publishing software(3marks)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
____________________________________________________________________________________________________________________________________________________________________________
(c) Describe two types of desktop publishing software(2marks)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(d) Describe the following terms as used in DTP.
(i) Pasteboard(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Printable area(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(iii)Ruler(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(e) Describe the following features with respect to DTP.
(i) Wrapping text(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Drop cap(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(f) State the function of the following toolbox items as used in Adobe Page Maker
(i) Text tool(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Cropping tool(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(iii)Zoom tool(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
19.
(i) Describe the following database models.
(a) Relational l Model(1mark)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(b) Networked model(1mark)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(c) Object oriented (1mark)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(ii) A database was set up to record the test results for a class of students. Part of the database is as shown below.

(a) Give the number of fields that are in the table above (2marks)
_________________________________________________________________________________________
(b) How many records are in the above table (2marks)?
_________________________________________________________________________________________
(c) Choose the most appropriate key field for the table and give a reason for your choice (2marks)
__________________________________________________________________________________________________________________________________________________________________________________
(d) Choose the data type for Name, ID, and Math(3marks)
___________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(e) Suggest how the marks columns should be validated (1mark)
_________________________________________________________________________________________
(f) Write an expression that can be used to calculate the total at the query grid (2marks)
__________________________________________________________________________________________________________________________________________________________________________________
20.
(a) Describe two functions of a file extension (2marks)
__________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(b) Explain the following terms as used in computing.
(i) Hanging(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(ii) Virus (1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(iii)Troubleshooting(1mark)
__________________________________________________________________________________________________________________________________________________________________________________
(c) Identify four resources that are under operating system control (4marks)
______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(d) Why must operating system be installed in the computer before installing any other software (2marks)
____________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________
(e) Give four reasons that may cause computer malfunction (4marks)
_______________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________________

More Examination Papers