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

INSTRUCTION TO CANDIDATES    

• This paper consists TWO sections.
• Answer ALL questions in section A.
• Answer Question 16 and any other THREE Questions from Section B

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.
   1. Hardware (1mark)
   2. 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.
    1. Return key(1mark)
    2. Delete(1mark)
11. Describe the following features of Database management software.
    1. Macro (1mark)
    2. 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.
    1. Eating in a computer laboratory (1mark)
    2. Smoking in the computer laboratory (1mark)

SECTION B (60 MARKS)

ANSWER ALL THE QUESTION IN THIS SECTION

16.  
    1. Describe three components of a spreadsheet (3marks)
    2. Describe three components of a function (3marks)
    3. A School keeps a spreadsheet of examination results in four subjects. Part of the spreadsheet is shown below.
       

       	A	B	C	D	E	F	G	H	I
       1	Name	Class	Math	Science	IT	English	Average	Position	Remark
       2	Peruza	11C	87	72	64	61	71	1
       3	Kegg	11A	82	69	57	52	65	2
       4	Kolacz	11A	73	51	73	51	62	3
       5	Khan	11C	44	21	50	85	50	4
       6	Dyos	11B	41	54	70	31	49	5
       7	Lenski	11B	17	41	40	34	33	6
       8	Allen	11A	33	24	19	44	30	7
       9	Mean score	-	53.86	47.43	53.29	51.14	51.43
       10	Highest	87	Lowest	17			#######

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

          Average	Remark
          66 - 100	Excellent
          46 - 65	Good
          36 - 45	Average
          0 - 35	Fail

       4. 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.  
    1. List two items found in Ms-word formatting toolbar (2marks)
    2. With an aid of a diagram explain the difference between merging cells and splitting cells (3marks)
    3. 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.
       1. Toggle case (1mark)
       2. Sentence case (1mark)
       3. Upper case (1mark)
    4. 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)
    5. Describe four proofreading tools supported by Ms-words(4marks)
18.  
    1. State the difference between Fill and stroke as applied in DTP (2marks)
    2. Give three purposes of desktop publishing software(3marks)
    3. Describe two types of desktop publishing software (2marks)
    4. Describe the following terms as used in DTP.
       1. Pasteboard (1mark)
       2. Printable area(1mark)
       3. Ruler(1mark)
    5. Describe the following features with respect to DTP.
       1. Wrapping text(1mark)
       2. Drop cap(1mark)
    6. State the function of the following toolbox items as used in Adobe Page Maker
       1. Text tool (1mark)
       2. Cropping tool(1mark)
       3. Zoom tool(1mark)
19.  
    1. Describe the following database models.
       1. Relational l Model (1mark)
       2. Networked model (1mark)
       3. Object oriented (1mark)
    2. A database was set up to record the test results for a class of students. Part of the database is as shown below.
       

       Name	ID	Math	English	Science	History	Geography
       Paul Smith	0017	70	55	65	62	59
       Ravi Gupta	0009	29	34	38	41	44
       Chin Hwee	0010	43	47	50	45	52
       John Jones	0013	37	67	21	28	35
       Diana Abur	0001	88	92	95	89	78
       Rose Achieng	0016	21	13	11	27	15

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

MARKING SCHEME

1. State three differences between impact printers and non-Impact printer
   

   Impact printer	Non- impact printer
   Noisy	Silent
   Slow	Fast
   Low quality	High quality
   Production of multiple copies possible	Production of multiple copies impossible

   (Award 1 mark each max 3)
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.
   Video =0.5 x 700= 350 …………………… ½ mark
   Audio = 0.125 x 700=87.5 ………………… ½ mark
   Total = 437.7 …………………… 1mark
   Remaining spaces (700-437.5) = 262.5MB ………… 1mark
3. Describe four ways in which ICT can be used to improve health care provision.
   • Telemedicine platform for sending reminders to the patients.
   • Passing information from one place to another using WhatsApp’s, internet, email etc.
   • For control life support machines like ICU using computer-based systems
   • Performing research through the internet to check on the best practices.
   • Use of electronic displays to perform advertisement hence create aware to the patients.
   • Computer based systems support MRI, CITI scan and Ultrasounds.
   • Laser surgery       (Award 1 mark each max 3)
4. Mention three factors to consider when choosing an ISP for internet connectivity.
   • Cost
   • Speed
   • Reliability of the ISP
   • Type of connection
   • Availability
   • Agility and flexibility      (Award 1 mark each max 3)
5. Describe the term portability as used in the following context.
   1. Hardware
      • In hardware portability is the ease of carrying a hardware component or computer from one place to another with ease
   2. Software
      • In software portability is the ease of copying or installing a program from one computer to another
        (Award 1 mark each max 2)
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.
   • Install antivirus and update regularly.
   • Scan removable storage devices before use.
   • Scan email attachments for virus before opening them.
   • Browse smart.     (Award 1 mark each max 3)
7. Using relevant examples distinguish between a formula and function.
   • Formula is a mathematical expression that creates a relationship between cells to return a new value like = B1+b2+c3
   • Functions are inbuilt formula that the user can quickly use instead of having to create a new each time a calculation has to be carried out like =sum(c2:c7)
     Note each correct example ½.
     (Award 1 mark each max 2)
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 to get the connection.
   • Internet Service Provider
   • Transmission media
   • Modem
   • Internet software
   • Communication node (Computer)       (Award 1 mark each max 3)
9. What is a master page in Desktop publishing (2marks)?
   • Master page is a special page in DTP used to design the general layout that needs to be applied in all pages of the publications.(Award 2 marks max 2)
10. State the function of the following keys.
    1. Return key.
       • Used to the computer instruction to perform a particular task.
       • Used to move cursor the beginning of the next line.
    2. Delete
       • Used to erase characters from left to right.     (Award 1 mark each max 2)
11. Describe the following features of Database management software.
    1. Macro (1mark)
       • Is a feature provided by DBMS to enable users automate frequently performed tasks.
    2. Table (1mark)
       • Is a database structure that is used to hold related records in a tabular form (row and columns)
         (Award 1 mark each max 2)
12. State three factors to consider when choosing a monitor.
    • Cost
    • Power consumption
    • Screen resolution
    • Screen size
    • Range of capabilities (additional features)
    • Monitor type      (Award 1 mark each max 3)
13. Milenga Special School received grants from the National government to purchase computers to be used in the departments and the Head teachers’ office, as a computer student the head teacher 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.
    • Processor architecture and speed
    • Memory capacity
    • Portability
    • Multimedia capabilities
    • Cost
    • Compatibility
    • Upgradeability         (Award 1 mark each max 4)
14. Describe three functions of an operating system.
    • Error handling the operating system perform error check on both the hardware and software and suggest the solutions to the problem.
    • Memory management the operating system divides memory into blocks and decide on what to be placed in memory at any given time.
    • Interrupt handling the operating system study the cause of the interrupt then transfer control to the most appropriate program.
    • Job scheduling the operating system give each task a fraction of the processor time then it will supervise how these tasks are processed one by one.
    • Security operating system have several mechanisms of protecting data and programs such as password, backup etc.
      (Award 1 mark each max 3)
15. Describe the effects of the following actions in a computer lab.
    1. Eating in a computer laboratory
       • Avoiding carrying foodstuff in the computer lab since solid food particles may fall on the moving parts of the computer and damage it while liquid may cause rusting to the metallic parts of the computer.
    2. Smoking
       • Smoke and dust contain elements that can damage the computer.         (Award 1 mark each max 2)
16.  
    1. Describe three components of a spreadsheet.
       • Worksheets refer to work area where data is entered it is made up of row and column.
       • Database is a collection of related data elements organized to provide consistent and controlled accessed.
       • Graph is a pictorial representation of the base data on a worksheet.     (Award 1 mark each max 3)
    2. Describe three components of a function.
       • Equal signs mark the beginning of a function.
       • Function names describe the activity to be performed.
       • Argument the values to be acted upon       (Award 1 mark each max 3)
    3. A School keeps a spreadsheet of examination results in four subjects. Part of the spreadsheet is shown below.
       1. What formula has been used to?
          1. Calculate the mean score for Math.
             = average(c2:c8) or =(c2+c3+c4+c5+c6+c7+c8)
                                                                  7
          2. Assign Lenski position 6 out of 7.
             = rank(g7, $g$2:$g$8, 0)
          3. Get student with the highest marks in Math and Science.
             = max(c2:d8)
       2. Show how cell G10 can be represented in R1C1 style (1mark)
          = R10C10        (Award 1 mark each max 4)
       3. Write a function that will display Excellent, Good, Average and Fail in the remark column based on the average score.
          • =IF(G2>=66, “Excellent”, IF(G2>=46,”Good”, IF(G2>=36,”Average”,”Fail”)))
          • Award 1 mark for correct function name
          • Award 2 marks for correct bracket to bracket
       4. 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.
          • Go to data validation feature.
          • Then set the minimum value to zero and maximum to hundred.                      (Award 1 mark each max 2)
17.  
    1. List two items found in Ms-word formatting toolbar (2marks
       • Bolding
       • Italicing
       • Underline
       • Superscript
       • Subscript
       • Font color
       • Decrease and increase font size.       (Award 1 mark each max 2)
    2. With an aid of a diagram explain the difference between merging cells and splitting cells (3marks)
       
       • Merging cells refer to combining more than one in a table.
         
       • Splitting refers to subdividing a cell into more cells.
         
         Note award ½ for correct diagram max 1.      (Award 1 mark each max 2)
    3. 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.
       1. Toggle case
          • kANGA hIGH sCHOOL
       2. Sentence case
          • Kanga high school
       3. Upper case
          • KANGA HIGH SCHOOL         (Award 1 mark each max 3)
    4. 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.
       • Reduce the font size.
       • Reduce the size of the graphics.
       • Reduce line and character spacing.
       • Adjust the page margin accordingly.                                (Award 1 mark each max 3)
    5. Describe four proofreading tools supported by Ms-words.
       • Spelling and grammar checkers is a tool that helps the user to correct spelling error and incorrect grammar structure.
       • Thesaurus finds synonyms and antonyms.
       • Autocomplete completes a word when the user typed the first few characters of the word.
       • Autocorrect detects wrongly spelled or capitalized words and replace them with correct word.
       • Undo it reverses the last command that was issued to revert back to the previous state.
       • Redo it does the last undone action.                         (Award 1 mark each max 4)
18.  
    1. State the difference between Fill and stroke as applied in DTP.
       • Fill refer to applying patter like shading.
         
       • Stroke is a line style.
         
         Consider diagrams also at 1 mark each max 2.
         (Award 1 mark each max 2)
    2. Give three purposes of desktop publishing software.
       • Graphic design
       • Page layout design
       • Printing                 (Award 1 mark each max 3)
    3. Describe two types of desktop publishing software.
       • Graphic based DTP are specifically developed to edit and format graphical objects like pictures.
       • Layout based DTP are meant to create different page layout designs for text and pictures.   
            (Award 1 mark each max 2)
    4. Describe the following terms as used in DTP.
       1. Pasteboard
          • A large blank area where text and graphical objects are organized before arranging the neatly on the printable area.
       2. Printable area
          • It is the area that looks like a page surrounded by margins on the pasteboard.
       3. Ruler
          • help in positioning text and graphics accurately within the publication.              (Award 1 mark each max 3)
    5. Describe the following features with respect to DTP.
       1. Wrapping text
          • A feature that allows line of texts to be place around an image.
       2. Drop cap.
          • Drop cap refers to a feature that makes the first character in a line to be bigger and drops down to occupy the spaces in the next line.    (Award 1 mark each max 2)
    6. State the function of the following toolbox items as used in Adobe Page Maker
       1. Text tool
          • Type, select and edit text.
       2. Cropping tool
          • Trim imported graphic.
       3. Zoom tool.
          • Magnify or reduce an area of the page.           (Award 1 mark each max 3)
19.  
    1. Describe the following database models.
       1. Relational l Model
          • In this model related data items are stored in a structure called relation or table and relationships can be created between tables such that a record from one table relates to another table
       2. Networked model
          • In network model data elements are linked using different pathways to express a relationship between them creating a network like structure
       3. Object oriented.
          • Look at records as objects that are independent and relates with each other object in the database.
            (Award 1 mark each max 3)
    2. A database was set up to record the test results for a class of students. Part of the database is as shown below.
       1. Give the number of fields that are in the table above (2marks)
          • 7       (Award 2 marks max 2)
       2. How many records are in the above table?
          • 6      (Award 2marks max 2)
       3. Choose the most appropriate key field for the table and give a reason for your choice (2marks)
          • Key field ID it is unique and therefore cannot be shared.      (Award 2 marks max 2)
       4. Choose the data type for Name, ID, and Math
          • Name-Text
          • ID –Text
          • Math –Number     (Award 1 mark each max 3
       5. Suggest how the marks columns should be validated.
          • Type >=0 and =< 100      (Award 1 mark max 1)
       6. Write an expression that can be used to calculate the total at the query grid.
          • Total: [Math]+[English]+[Science]+[History]+[Geography]
            Note the spelling and brackets must include to score full marks.    (Award 2-mark max 2)
20.  
    1. Describe two functions of a file extension.
       • Used for searching files within a storage location.
       • Used to describe the content of a file.     (Award 1 mark each max 2)
    2. Explain the following terms as used in computing.
       1. Hanging
          • Refer to nonresponsive behavior of a computer especially after a command has been issued.
       2. Virus
          • A computer program created by malicious programs to disrupt the normal function of the computer.
       3. Troubleshooting
          • refer to the process of diagnosing and fixing hardware and software related problems. 
             (Award 1 mark each max 3)
    3. Identify four resources that are under operating system control.
       • Processor
       • Memory
       • Input output devices
       • Secondary storages devices                             (Award 1 mark each max 4)
    4. Why must operating system be installed in the computer before installing any other software?
       • It is the main program responsible for managing and controlling computer resources.        (Award 2marks max 2)
    5. Give four reasons that may cause computer malfunction.
       • Hardware malfunction
       • Malware
       • Improper installation
       • Missing system files
       • Incomparability between hardware and software                     
         (Award 1 mark each max 4)