TSST

YEAR  7 COMPUTING

OBJECTIVE QUESTIONS

Date: …………………………………………………..

                                                                                                                   Exercise 1                                        

1.     This electronic device was used with second-generation computers.

a.     Integrated circuits

b.     Vacuum tubes

c.      Diodes

d.     Transistors

2.     Which of the following generation of computers used vacuum tubes?

a.     First generation

b.     Second generation

c.      Third generation

d.     Fourth generation

3.     In which year was third generation used?

a.     1945

b.     1956

c.      1975

d.     1995

4.     Base, emitter and collector are features of____________

a.     Integrated circuits

b.     Transistors

c.      Diodes

d.     Vacuum tubes

5.     In which year was third generation computers used?

a.     1956

b.     1971

c.      1964

d.     1945

6.     The third generation computers used____________

a.     Vacuum tubes

b.     Transistors

c.      Integrated circuits

d.     Diodes

7.     High level languages were used in ______________

a.     First generation computers.

b.     Second generation computers

c.      Third generation computers

d.     Fourth generation computers

8.     Which of the following is a disadvantage of wireless keyboard and mouse?

a.     Use of batteries

b.     Portability

c.      Lack of cluster on desk

d.     Convenient

9.     Which of the following devices uses photocell to write on computer monitors?

a.     Wireless mouse

b.     Wireless keyboards

c.      Light pen

d.     Touch screens

10.                        Hard disk drive store stores data through the use of____

a.     Laser

b.     Flash memory

c.      Heat

d.     Magnetic pattern

 

 

                             Date: …………………………………………..

                                                                                                                    Exercise 2 

1.     The application of scientific knowledge to create to create tools for solving problems is known as____

a.     Scientific method

b.     Applied science

c.      Technology

d.     Machinery

2.     Which of the following tools is used to learn mathematics?

a.     MS word

b.     Scratch

c.      Virtual museum

d.     Spreadsheet

3.     Which of the following technology can be used as an encyclopedia?

a.     MS word

b.     Spreadsheet

c.      Presentation software

d.     Scrabbles

4.     This technology is used for creating graphs and data analysis.

a.     MS word

b.     Scratch

c.      Virtual museum

d.     Spreadsheet

5.     Historical and scientific documents exhibited via the internet is an example of ____

a.     Scratch

b.     Spreadsheet

c.      Presentation

d.     Virtual museum

6.     PowerPoint is an example of ___

a.     Spreadsheet

b.     Presentation software

c.      Virtual museum

d.     Word processing

7.     One of the following can be used to write computer games and programs.

a.     Scrabble

b.     Scratch

c.      PowerPoint

d.     MS word

8.     One of the following software is used for creating presentations.

a.     Scrabble

b.     MS word

c.      Scratch

d.     PowerPoint

9.     Which of the following is a word game?

a.     Scrabble

b.     Scratch

c.      PowerPoint   

d.     MS word

10.                        All the following are importance of playing scrabble except___

a.     Learning mathematics

b.     Improve vocabulary

c.      Improve creativity

d.     Learning programming

 

 

 

 

 

                                      Date: ………………………………

                                                                                                Exercise 3

1.     Health problems associated with the long term use of computers is known as____

a.     Regulatory requirements

b.     Computer related disorders

c.      Public health

d.     Computer health

2.     Which one of the following is not a health problem associated with the long term use of computers?

a.     Eye irritation

b.     Back ache

c.      Fever

d.     Fatigue

3.     Exposer to heat from laptops can cause__

a.     Head ache

b.     Skin burns

c.      Fever

d.     Tress

4.     RSI stands for___

a.     Resistance strain illness

b.     Repetitive skull injury

c.      Resistance stomach illness

d.     Repetitive strain injury

5.     All the following are causes of RSI except___

a.     Poor keyboard design

b.     Look at the monitor for long period

c.      Wrong height of workstation chair

d.     Using mouse for long period

6.     Using adjustable chair prevents___

a.     Eye strain

b.     Back pain

c.      Eye irritation

d.     Tooth ache

7.     Which of the following is not symptom of eye strain?

a.     Headache

b.     Nausea

c.      Neck pain

d.     Double vision

8.     Sitting for long period of time without breaks cause__

a.     Repetitive strain injury

b.     Deep vein thrombosis

c.      Headaches

d.     Nausea

9.     Brain cell damage is caused by prolong use of ___

a.     Television

b.     Mobile phones

c.      Keyboard

d.     Mouse

10.                        Watching violent movies cause___

a.     Headaches

b.     Eye strain

c.      Behavior disorder

d.     obesity

 

 

 

 

 

Date: …………………………………………..

  (WORD PROCESSING)                                             EXCERSISE 4

1.     Which of the following software is a word processing software?

a.     MS PowerPoint

b.     MS windows

c.      MS excel

d.     MS word

2.     Commands for editing and formatting text are found on __

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

3.     The page colour and page border commands are found on_

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

4.     Which of the following tabs allows users to add tables and illustrations to word documents?

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

5.     Page properties such page orientation and size are found on__

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

6.     Which of the following mouse skills is used to select a single word in MS word?

a.     Click

b.     Double clicking

c.      Triple clicking

d.     Right clicking

7.     Which of the following software is a word processing software?

a.     MS PowerPoint

b.     MS windows

c.      MS Excel

d.     MS Word

8.     Commands for editing and formatting text are found on__

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

9.     Which of the following tabs allows users to add tables and illustrations to word document?

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

10.            Page properties such as page orientation and size are found on __

a.     Home tab

b.     Insert tab

c.      Design tab

d.     Layout tab

 

 

 

 

 

Date: …………………………………..

EXERCISE 5 (PRESENTATION)   

  

1.     Which of the following tools is a presentation package?

a.     MS word

b.     MS Excel

c.      MS windows

d.     MS PowerPoint

2.     The pages in a presentation software are called__

a.     Document

b.     Flame

c.      Slide

d.     Graphic

3.     Predefined set of colour and fonts that provide unified look for a presentation is known as__

a.     Slides

b.     Theme

c.      Ribbon

d.     Tabs

4.     This feature provide content for specific purpose in MS PowerPoint.

a.     Home tab

b.     Insert tab

c.      Transitions tab

d.     Review tab

5.     Selecting ignore once when using the proofing option will___

a.     Overlook all instances of the spelling error

b.     Overlook the current instance of the spelling error

c.      Add the new word to the dictionary

d.     Delete the spelling error

6.     Proofing and language settings are found on ______ in MS PowerPoint.

a.     Home tab

b.     Insert tab

c.      Transitions tab

d.     Review tab

7.     Which of the following tools is used to get synonyms for words in PowerPoint?

a.     Proofing

b.     Thesaurus

c.      Design

d.     Template

8.     Which of the following tabs contain options for starting a presentation?

a.     Review

b.     Home

c.      Design

d.     Slide show

9.     To apply theme to a slide show, we use____tab.

a.     Review

b.     Home

c.      Design

d.     Slide show

10.                        The language settings is found on which of the following tabs?

a.     Review

b.     Home

c.      Design

d.     Slide show

 

 

 

Date: …………………………………………..

EXERCISE 6

(INTRODUCTION TO ELECTRONIC SPREADSHEET)

1.     Google sheets, Lotus and MS Excel are examples of ____

a.     Presentation packages

b.     Word processors

c.      Graphic software

d.     Spreadsheets

2.     All the following are uses of spreadsheet software except___

a.     Calculations

b.     Data entry

c.      Presentations

d.     Plotting graphs

3.     In MS excel, rows are identified by____

a.     Alphabets

b.     Numbers

c.      Symbols

d.     Tabs

4.     In MS excel, columns are identified by____

a.     Alphabets

b.     Numbers

c.      Symbols

d.     Tabs

5.     The intersection of a column and a row where data is inserted is known as___

a.     Formula

b.     Function

c.      Cell

d.     Data

6.     A selected cell is also known as___

a.     Workbook

b.     Worksheet

c.      Slide

d.     Active cell

7.     Which of the following allow users to edit entered data?

a.     Name box

b.     Formula

c.      Tabs

d.     Layout

8.     Which of the following number formats should be used for data “GHC 500”?

a.     Date

b.     Time

c.      Number

d.     Currency

9.     Which of the following number formats should be used for the data “24-Dec-20”?

a.     Date

b.     Time

c.      Number

d.     Currency

10.                        This number format displays data exactly as it was typed.

a.     Number

b.     General

c.      Accounting

d.     scientific

 

 

 

 

Date: …………………………………………..

EXERCISE 7 (COMPUTER NETWORK)

1.     which network topology requires a central controller or hub?

a.     Star

b.     Mesh

c.      Ring

d.     Bus

2.     Data communication system spanning states, countries, or the whole world is_____

a.     LAN

b.     WAN

c.      MAN

d.     PAN

3.     Data communication system within a building or campus is___

a.     LAN

b.     MAN

c.      WAN

d.     PAN

4.     The physical or logical arrangement of network is____

a.     Topology

b.     Routing

c.      Networking

d.     Control

5.     The computer on a network that is used as a central repository of data and programs is called___

a.     Router

b.     Client

c.      Hub

d.     Server

6.     Computers on a network that access resources from a remote computer is called___

a.     Router

b.     Client

c.      Hub

d.     Server

7.     This networking devices connects multiple computers to a single network.

a.     Router

b.     Client

c.      Hub

d.     Server

8.     Which of the following networking devices perform traffic direction function on the internet?

a.     Router

b.     Client

c.      Hub

d.     Server

9.     Which of the following networking devices is necessary for internet connection?

a.     Switch

b.     Hub

c.      Router

d.     Topology

10.                        This is the type of computer network where all the nodes are connected to a central device.

a.     Mesh

b.     Bus

c.      Ring

d.     Star

 

 

 

 

 

 

 

 

 

 

 

 

Date: …………………………………………..

EXERCISE 8 (INTERNET AND SOCIAL MEDIA)

1.     Social media sites include all the following except___

a.     Google+

b.     Facebook

c.      Tumblr

d.     Microsoft

2.     Customers can hear of new products on___

a.     Facebook only

b.     Twitter only

c.      Whatsapp only

d.     All above

3.     An internet base sites to connect friends, families etc can be termed as____

a.     Friendship

b.     Families

c.      Connections

d.     Social networking site

4.     All the listed below are examples of social media sites except___

a.     Facebook

b.     Google chrome

c.      Whatsapp

d.     Instagram

5.     All the listed below are advantages of social media sites except ___

a.     Online business

b.     Social networking

c.      Posting bad pictures

d.     Learning

6.     An example of microblogging site include___

a.     Alibaba

b.     Amazon

c.      Twitter

d.     myjoyonline

7.     which of the following fields in an email will you use to send hidden copies to people?

a.     To:

b.     CC:

c.      BCC:

d.     Subject

8.     The title of an email is typed in which of the following fields?

a.     To:

b.     CC:

c.      BCC:

d.     Subject

9.     The method of sending mail digitally or electronically is termed as____

a.     X-mail

b.     Y-mail

c.      E-mail

d.     G-mail

10.                        What is the meaning of CC feature in email sending?

a.     Cut copy

b.     Cost copy

c.      Carbon copy

d.     Copy cat

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

Date: …………………………………………..

EXERCISE 9 (INFORMATION SECURITY)

1.     The state of being free from danger or out of hand of criminals is termed as____

a.     Out of danger

b.     Danger free

c.      Security

d.     Free

2.     ____is an assignable legal right of an individual to be an originator of product for a fixed number of years.

a.     Infringements

b.     Copyright

c.      Piracy

d.     License

3.     The measure designed to protect against unauthorized disclosure of information is___

a.     Confidentiality

b.     Availability

c.      Integrity

d.     Authority

4.     _____is the exclusive and assignable legal right, given to the originator for a fixed number of years, to print, publish, perform, film, or record literary, artistic, or musical material is called___

a.     Patent

b.     Copyright

c.      Trademark

d.     Piracy

5.     Downloading videos online without any legal right is___

a.     Patent

b.     Copyright

c.      Trademark

d.     Piracy

6.     Software that are offered free of charge is called____

a.     Charge free

b.     Freeware

c.      Software free

d.     Piracy

7.     The use of originator’s work as if it is one’s product is termed as__

a.     Patent

b.     Copyright infringement

c.      Plagiarism

d.     Stealing

8.     The act of breaking the law is____

a.     Patent

b.     Infringement

c.      Plagiarism

d.     Stealing

9.     The act of copying a product of originator without permission is termed____

a.     Patent

b.     Copyright infringement

c.      Plagiarism

d.     Stealing

10.                        Things that are free to use without seeking permission are__

a.     Trademark

b.     Public domain

c.      Copywritten

d.     Patented

 

 

 

Date: …………………………………………..

EXERCISE 10 (WEB TECHNOLOGIES)

1.     ___ is a learning experience that is enhanced through utilizing computers and / or the internet both outside and inside facilities of the educational organization.

a.     Classroom learning

b.     Social learning

c.      Outside class learning

d.     Virtual learning

2.     The part of the internet that contains websites is the___

a.     Internet core

b.     World wide web

c.      Network

d.     Computer connections

3.     One advantage of web learning includes ___

a.     It is slow

b.     It enhances learning

c.      It adds skills of scamming

d.     It is expensive

4.     Which of the following below is an example of open learning website?

a.     Facebook

b.     Amazon

c.      Alibaba

d.     Courser

5.     Techniques for evaluating websites that checks all information on the sites are correct is___

a.     Functionality

b.     Accuracy

c.      Current

d.     Content

6.     Which of the techniques in evaluating websites check that the website is working properly?

a.     Functionality

b.     Accuracy

c.      Current

d.     Content

7.     Information on the internet that does not cover important aspects of the topic lacks___

a.     Currency

b.     Coverage

c.      Objectivity

d.     Authority

8.     When authors or editors of information online fail tom identify themselves, the information lacks____

a.     Currency

b.     Coverage

c.      Objectivity

d.     Authority

9.     If the date a webpage was published is missing, the information on that webpage lacks___

a.     Currency

b.     Coverage

c.      Objectivity

d.     Authority

10.            Which of the following VLEs can you learn coding and programming?

a.     Khan academy

b.     Code academy

c.      Courser

d.     Facebook

 

Date: …………………………………………..

EXERCISE 11 (INTRODUCTION TO PROGRAMMING)

1.     _____ is the process of creating a set of instruction that tells the computer how to perform a task.

a.     Constant

b.     String

c.      Programming

d.     Boolean

2.     “hello” is an example of which type of data?

a.     Date

b.     String

c.      Boolean

d.     Date

3.     A program terminating without any information is termed as___

a.     Abend

b.     Compilation

c.      Code

d.     Bug

4.     Which of the following is the rule and protocol for developing a software?

a.     API

b.     Variables

c.      Constant

d.     Declaration

5.     Select the data type that represent a whole number.

a.     Floats

b.     Date

c.      Integer

d.     Double

6.     _____ is a data type that can store up to 64 bits.

a.     Double

b.     Floats

c.      Integer

d.     Date

7.     Constants value changes in computer programming?

a.     True

b.     False

8.     Which of the following consists of one or more characters which includes letters, numbers and other characters?

a.     Double

b.     Floats

c.      Integer

d.     String

9.     A task that is performed in the background without the users of a software awareness is termed _____

a.     Front-end

b.     Back-end

c.      Compilation

d.     Program

10.                        People who write programs are called____

a.     Teachers

b.     Programmers

c.      Engineers

d.     Operators

 

 

 

 

 

Date: …………………………………………..

EXERCISE 12 (INTRODUCTION TO ALGORITHM)

1.     Step by step way of solving a problem in programming is termed as____

a.     Abstraction

b.     Decomposition

c.      Algorithm

d.     Iteration

2.     _____is searching for an element in a list until desired element is found.

a.     Abstraction

b.     Linear search

c.      Algorithm

d.     Selection

3.     When a programmer hides details from the user it is termed as___

a.     Abstraction

b.     Decomposition

c.      Algorithm

d.     Iteration

4.     Any program instruction that repeats same statement is known as….

a.     Abstraction

b.     Decomposition

c.      Algorithm

d.     Iteration

5.     ________is the breakdown of codes into smaller part for easy understanding.

a.     Abstraction

b.     Linear search

c.      Algorithm

d.     Decomposition

6.     What are the three algorithm construct?

a.     Sequence, selection, repetition

b.     Input, process, output

c.      Input/output, decision, terminator

d.     Loop, input/output, process

 

Dim mynumber As Integer

              Munumber = 5

                If mynumber  > 0 Then

            MagBox “The condition evaluates to true.”

End

 

7.     The code above is an example of ___

a.     Abstraction

b.     Decomposition

c.      Algorithm

d.     Iteration

8.     When the condition is checked and it is true, the code within all then program will be executed_____

a.     While loop

b.     Repeated loop

c.      If condition

d.     Else

9.     Which of the methods below helps reduce duplication of codes?

a.     Abstraction

b.     Decomposition

c.      Algorithm

d.     Iteration

10.                        Arrangement of student position in orderly manner represent__

a.     Selection

b.     Iteration

c.      Decomposition

d.     Abstraction

 

 

Date: …………………………………………..

EXERCISE 13 (ROBOTICS)

1.     ____is a machine, programmable by a computer, capable of carrying out complex tasks automatically.

a.     Laptop

b.     Programmer

c.      Robot

d.     Intelligence

2.     How many types of robots do we have in design?

a.     1

b.     2

c.      3

d.     4

3.     An industrial robotic arm is an example of___

a.     Moving robots

b.     Fixed robot

c.      Programmable robot

d.     Controlled robot

4.     A humanoid robot is an example of ____

a.     Moving robot

b.     Fixed robot

c.      Programmable robots

d.     Controlled robot

5.     One of the reasons for using robots in schools is to ____

a.     Replace teachers

b.     Learn for students

c.      Teach algorithm

d.     Prevent exams failure

6.     Using robots for packaging is an application in___

a.     Education

b.     Industry

c.      Military

d.     Health

7.     Using drones to deliver blood samples to remote clinics is an application of robots in___

a.     Education

b.     Industry

c.      Military

d.     Health

8.     Which one of the following is the reason for using robots?

a.     To replace human workers

b.     To consume more electricity

c.      To do things they are not designed for

d.     To work in a hazardous environment

9.     Which of the following is a demerit of using robots?

a.     They are efficient

b.     They are costly

c.      They are safe

d.     They perform repetitive tasks

10.                        When students use robots to learn, they develop interest to learn___

a.     STEM

b.     Reading

c.      Speaking

d.     Writing

 

 

Date: …………………………………………..

EXERCISE 14 (ARTIFICIAL INTELLIGENCE)

1.     The situation whereby machines become smart and be able to solve tasks intelligently like humans is____

a.     Machine intelligence

b.     Natural intelligence

c.      Artificial intelligence

d.     Virtual reality

2.     Technology that depicts real world is___

a.     Mixed reality

b.     Augmented reality

c.      Artificial neural network

d.     Virtual reality

3.     What technology does e-mail service providers use to detect spam and deletes them?

a.     Mixed reality

b.     Augmented reality

c.      Artificial neural network

d.     Virtual reality

4.     The use of two technologies such as augmented reality and virtual reality can be____

a.     Mixed reality

b.     Augmented reality

c.      Artificial neural network

d.     Virtual reality

5.     Applications that are able to learn from data are examples of ___

a.     Machine learning

b.     Artificial neural network

c.      Artificial intelligence

d.     Virtual reality

6.     Computer systems that are designed to simulate how human brain analyzes and process information is known as___

a.     Machine learning

b.     Artificial neural network

c.      Artificial intelligence

d.     Virtual reality

7.     The use of digital visual elements to enhance the real physical world is known as___

a.     Augmented reality

b.     Virtual reality

c.      Artificial intelligence

d.     Artificial neural network

8.     All the following are application of machine learning except___

a.     Speech recognition

b.     Image recognition

c.      Handwriting recognition

d.     Simulation of human brain

9.     The application of game principles in order to solve real world problems is known as___

a.     Entertainment

b.     Gaming

c.      Gameplay

d.     Gamification

10.                        Which of the following technologies is used by smart self-driving cars?

a.     Machine learning

b.     Neural network

c.      Artificial intelligence

d.     All the above




THEORY QUESTIONS

1.      What is a first generation computer?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

2.      State five features of the first generation computers.

i.                    ……………………………………………………………………………………

ii.                  ………………………………………………………………………………......

iii.                ……………………………………………………………………………………

iv.                ……………………………………………………………………………………

v.                  ……………………………………………………………………………………

 

3.      What is a vacuum tube?

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………...

 

4.      What is a second generation computer?

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

5.      State five features of the second generation computers.

i.                    …………………………………………………………………………

ii.                  …………………………………………………………………………

iii.                …………………………………………………………………………

iv.                …………………………………………………………………………

 

6.      What is a transistor?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

7.      Mention three uses of a transistor.

i.                    …………………………………………………………………………………..

ii.                  ……………………………………………………………………………………

iii.                ……………………………………………………………………………………

 

8.      What is a third generation computer?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

9.      List three features of the third generation computers.

i.                    …………………………………………………………………………………..

ii.                  ……………………………………………………………………………………

iii.                ……………………………………………………………………………………

 

10. Write three differences between first generation and second generation computers.

FIRST GENERATION

SECOND GENERATION

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

11. Write three differences between third generation and fourth generation computers.

THIRD GENERATION

FOURTH  GENERATION

 

 

 

 

 

 

 

 

 

12. Write three differences between first generation and second generation computers.

FOURTH GENERATION

FIFTH GENERATION

 

 

 

 

 

 

 

 

 

13. Identify two input devices that convert hard-copy pictures or images into a digital format.

a.      ………………………………………………………..

b.      ………………………………………………………...

14. State two input devices that are used for playing gaming programs.

a.      ………………………………………………………….

b.      ………………………………………………………….

 

15. Briefly explain the purpose of input devices.

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

 

16. Draw three input devices and state their functions.

17. What is a hard disk drive (HDD) ?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

18. Differentiate between internal and external hard disk drives

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

19. Briefly explain how data is stored on a hard disk drive.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

20. What is disk caching?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

 

 

21. Explain how disk caching works in a hard disk drive.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

22. What is a start screen?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

23. Explain the difference between the start screen and the start menu.

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

 

24. Outline the steps you will use to switch between the start screen and the start menu.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

25. What is a file suffix?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

26. In the table below, identify the type of file using the suffix and the meaning.

Suffix

File

Meaning

.jpeg

image

Joint photographic experts group

.doc

 

 

.xls

 

 

.avi

 

 

.wmv

 

 

.pptx

 

 

.bmp

 

 

.iff

 

 

.gif

 

 

.txt

 

 

 

 

 

 

 

 

 

 

TECHNOLOGY IN THE COMMUNITY

 

 

1.      What is technology?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

2.      List five technology tools for learning.

i.                    …………………………………………………………………….

ii.                  …………………………………………………………………….

iii.                ……………………………………………………………………

iv.                …………………………………………………………………..

v.                  ……………………………………………………………………

3.      What is a spreadsheet?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

4.      List four ways by which spreadsheet software is used to learn.

i.                    …………………………………………………………………………………

ii.                  ………………………………………………………………………………..

iii.                ………………………………………………………………………………..

iv.                ………………………………………………………………………………..

v.                  ………………………………………………………………………………..

5.      What is Encarta software?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

6.      Explain how Encarta software is used to learn.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

7.      What is a virtual museum?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

8.      Mention two examples.

i.                    ……………………………………………………….

ii.                  ………………………………………………………

9.      Mention two things that can be learned from virtual museum.

i.                    …………………………………………………………….

ii.                  …………………………………………………………..

10. What is a scrabble?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

11. Explain scrabble as a learning tool.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

12. What is presentation software?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

13. State five importance of presentation software.

i.                    ……………………………………………………………………………………

ii.                  ……………………………………………………………………………………

iii.                ……………………………………………………………………………………

iv.                ………………………………………………………………………………….

v.                  …………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

HEALTH AND SAFETY IN USING ICT TOOLS

1.      Explain the term computer-related disorder.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

2.      State five examples of potential computer-related disorders.

i.                    ………………………………………………………………………………

ii.                  ……………………………………………………………………………..

iii.                ………………………………………………………………………………

iv.                ……………………………………………………………………………..

v.                  ……………………………………………………………………………..

3.      Explain the term RSI.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

4.      Mention five symptoms of RSI.

i.                    ……………………………………………………………………………………

ii.                  ……………………………………………………………………………………

iii.                …………………………………………………………………………………..

iv.                ……………………………………………………………………………………

v.                  ……………………………………………………………………………………

5.      State two ways of preventing RSI.

i.                    ……………………………………………………………………………………

ii.                  …………………………………………………………………………………..

6.      What is eye strain?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

7.      State four symptoms of eye strain.

i.                    ………………………………………………………………………………

ii.                  ……………………………………………………………………………..

iii.                ……………………………………………………………………………..

iv.                ……………………………………………………………………………..

8.      Mention three ways of preventing eye strain.

i.                    ……………………………………………………………………………..

ii.                  ……………………………………………………………………………..

iii.                ……………………………………………………………………………...

9.      Briefly explain the term DVT.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

10. Mention three symptoms of DVT.

i.                    …………………………………………………………………………………

ii.                  …………………………………………………………………………………

iii.                ………………………………………………………………………………….

11. Explain three ways of preventing DVT.

i.                    ………………………………………………………………………………..

ii.                  ……………………………………………………………………………….

iii.                ………………………………………………………………………………..

12. State three current regulatory requirements for the following.

a.      Monitor

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

b.      Keyboard

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

c.       Chair

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

d.      Work environment

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

e.      Software

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

f.        Workstation

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

13. Explain three ways of preventing computer related diseases

i.                    ………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………

 

ii.                  …………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

iii.                ………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

INTRODUCTION TO WORD PROCESSING

1.      What is a ribbon in MS word application?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

2.      State all the tabs in the MS Word ribbon.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

3.      Mention three tools in the following tabs.

a.      Home

i.                    …………………………………………….

ii.                  …………………………………………….

iii.                …………………………………………….

b.      Insert

i.                    …………………………………………….

ii.                  …………………………………………….

iii.                ……………………………………........

c.       Design

i.                    ……………………………………………….

ii.                  ………………………………………………

iii.                ………………………………………………

d.      Page layout

i.                    ……………………………………………….

ii.                  ………………………………………………

iii.                ……………………………………………….

e.      References

i.                    ………………………………………………

ii.                  ………………………………………………

iii.                ……………………………………………….

f.        Mailings

i.                    ………………………………………………..

ii.                  …………………………………………………

iii.                ………………………………………………..

g.      Review

a.      ………………………………………………………

b.      ………………………………………………………

c.       ……………………………………………………..

h.      View

a.      ……………………………………………………….

b.      …………………………………………………………

c.       ………………………………………………………..

4.      Mention three ways of selecting text in MS word.

a.      …………………………………………………………………………………….

b.      …………………………………………………………………………………….

c.       ……………………………………………………………………………………

5.      Explain how you will delete text by using the following keys.

a.      Backspace

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

b.      Delete

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

6.      Explain two ways of moving text in MS word.

a.      ……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

 

b.      ………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

7.      Explain the overtype option in MS word.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

8.      Explain the insert option in MS word.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

9.      Differentiate between overtype and insert options in MS word.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

10. Explain the functions of the following commands.

a.      Redo

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

b.      Redo

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

11. Differentiate between undo and redo.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

12. Explain the uses of Find and Replace commands in MS word

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

13. State the function of the following options in the spell-checking pane.

i.        Ignore once.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

ii.      Ignore all

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

iii.    Add

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

iv.    Change

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

v.      Change all

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

14. What is a thesaurus in an MS word document?

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

15. Mention three functions of the thesaurus in an MS word document.

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

 

INTRODUCTION TO PRESENTATION

1.      What is a presentation software package?

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

2.      Mention four features of presentation software package.

a.      …………………………………………………………………………

b.      ………………………………………………………………………..

c.       ………………………………………………………………………..

d.      ………………………………………………………………………..

 

3.      Explain the functions of the following slides in MS PowerPoint.

a.      Title bar

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

b.      Ribbon

………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

c.       Home tab

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

……………………………………………………………………………………

 

d.      Design tab

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

e.      Insert tab

…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

4.      What is a template?

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

5.      List four features of a template

a.      ……………………………………………………………………………

b.      …………………………………………………………………………..

c.       ………………………………………………………………………….

d.      ………………………………………………………………………….

 

 

 

INTRODUCTION TO ELECTRONIC SPREADSHEET

1.      What is a spreadsheet?

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………..

 

2.      Explain the following features of the spreadsheet.

a.      Row

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

b.      Column

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

c.       Cell

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

d.      Formula

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

e.      Name box

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

f.        Formula bar

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

3.      Explain the function of a number format in excel.

……………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………

 

 

 

 




JHS 2 COMPUTING

DATE:………………………………………………………………………..

KNOWLEDGE BASED ASSESSMENT

EXERCISE 1

1.     Fifth generation of computers used____

a.     Artificial intelligence

b.     Vacuum tube

c.      Transistors

2.     The use of the behavior of sub-atomic particles for computer processing is known as____

3.     Using multiple processors simultaneously to execute the same task is called_____

a.     Artificial intelligence

b.     Quantum computing

c.      Parallel processing

d.     Integrated circuit

4.     Which of the following is an impact printer?

a.     Dot matrix printer

b.     Inkjet printer

c.      Laserjet printer

d.     Thermal printer

5.     One of the following hard disks has a non-moving part.

a.     Hard disk drives

b.     Solid state drives

c.      Hybrid drives

d.     Optical disk drives

6.     The term used to describe data that are scattered throughout a hard drive platter is known as____

a.     Flash memory

b.     Solid state

c.      Fragmentation

d.     File compression

7.     The process of reorganizing data on a hard drive by continuously putting pieces of data is called___

a.     Formatting

b.     Partitioning

c.       Defragmentation

d.     Ile compression

8.     The process of making computer files tale less space on the computer is known as___

a.     Formatting

b.     Partitioning

c.      Defragmentation

d.     File compression

9.     Which of the following files can be compressed using a lossy compression algorithm?

a.     Document

b.     MP3 file

c.      Program files

d.     Pictures

10.                        The compression algorithm that discards less important information about a file is known as___

a.     Lossy compression

b.     Lossless compression

c.      Compact compression

d.     Zip compression

 

 

 

 

EXERCISE 2 (ADAPTIVE AND ASSITIVE TECHNOLOGY)

1.     Technologies that are used by individuals with disabilities to perform functions that might be difficult or impossible are called__

a.     Adaptive technologies

b.     Assistive technologies

c.      Digital technologies

d.     Disability technologies

2.     Special version of already existing technologies that enable persons with disability to use them is known as___

a.     Adaptive technologies

b.     Assistive technologies

c.      Digital technologies

d.     Disability technologies

3.     Which of the following assistive technologies is for people with vision impairment?

a.     Audiobooks

b.     Hearing loop

c.      Tablets

d.     Task timer

4.     Picture boards and social skill videos are assistive technologies used by people with___

a.     Vision impairment

b.     Hearing impairment

c.      Autism

d.     Physical disability

5.     Mobility aid such as wheelchairs are likely to be used by people with___

a.     Vision impairment

b.     Hearing impairment

c.      Autism

d.     Physical disability

 

6.     Brailed books and JAWS screen reader are used by people with

a.     Vision impairment

b.     Hearing impairment

c.      Autism

d.     Physical disability

7.     Sound amplifier and personal amplifier are used by people with__

a.     Vision impairment

b.     Hearing impairment

c.      Autism

d.     Physical disability

8.     Keyboard modifications and large print books are examples of___

a.     Assistive technologies

b.     Adaptive technologies

c.      Technology for people with hearing impairment

d.     Technology for physically challenged people

9.     Which of the following is not an example of a portable computer?

a.     Tablet

b.     Laptop computer

c.      Desktop computer

d.     Smartphones

10.                        Computer-based technology that facilitates the sharing of ideas, thoughts and information through a virtual network community is known as___

a.     Social media

b.     Networking

c.      Cyberspace

d.     E-commerce

 

EXERCISE 3 (HEALTH AND SAFETY IN USING ICT TOOLS)

1.     The healthy relationship between people and their work environment I known as____

a.     Safety

b.     Ethics

c.      Ergonomics

d.     Security

2.     Prolonged work and overuse of computers causes injuries to all the following parts of the body except____

a.     Arms

b.     Neck

c.      Back

d.     Hair

3.     Which of the following is the correct posture for the feet when using a workstation?

a.     Your feet should be hanging

b.     Your feet should be crossed

c.      Your feet should be on the table

d.     Your feet should be flat on the floor

4.     Which of the following is the correct distance between the eye and the computer screen?

a.     5-10 cm

b.     11-20 cm

c.      20-30 cm

d.     40-70 cm

5.     For correct sitting posture, the top of the computer screen should be_____

a.     Below the eye level

b.     Above the eye level

c.      Close to the eye level

d.     At eye level

6.     When using a workstation, your shoulders should be____

a.     Relaxed

b.     Tilted forward

c.      Tilted backwards

d.     Hanging

7.     To avoid leg injury, your legs should be bent at ____

a.     90 to 110 degrees

b.     60 t0 70 degrees

c.      180 degrees

d.     270 degrees

8.     A suitable chair for a workstation should be ___

a.     Adjustable with back support

b.     Adjustable without back support

c.      Fixed with no back support

d.     Very large and comfortable without back support

9.     How many minutes should you take a break when using a workstation?

a.     20 minutes

b.     30 minutes

c.      40 minutes

d.     50 minutes

10.                        All the following are arm stretches except__

a.     Shoulder shrug

b.     Triceps stretches

c.      Overhead reach

d.     Upper body stretch

 

 

EXERCISE 4 (INTRODUCTION TO WORD PROCESSING)

1.     A grid of cells arranged in rows and columns is known as ___

a.     Table

b.     Forms

c.      Girds

d.     Pictures

2.     Which of the following tabs will you use to add a table to your work?

a.     Home tab

b.     Design tab

c.      Layout tab

d.     Insert tab

3.     Which of the following tools is used to insert table rows and columns?

a.     Grids

b.     Smart art

c.      Illustrations

d.     Header

4.     Clickable text or graphic in a document is known as____

a.     Hyperlink

b.     Text alignment

c.      Header

d.     Footer

5.     Combining several table cells into a single cell ism called___

a.     Merging

b.     Shading

c.      Splitting

d.     Drawing

6.     In which of the following table tools can you find the formula command?

a.     Layout

b.     Design

c.      Home

d.     Insert

7.     The formula =SUM(ABOVE) in tables will___

a.     Add numbers in all rows

b.     Add the numbers in the column above the selected cell

c.      Add all numbers to the table

d.     Add numbers to the left of the selected cell

8.     Which of the following is used to reference an entire column in a table formula?

a.     Rn

b.     Cn

c.      Above

d.     Below

9.     Which of the following shortcut keys is used to update fields in a table formula?

a.     Ctrl + u

b.     Ctrl + x

c.      F8

d.     F9

10.            A special marker that ends the current page and starts a new page is called___

a.     Header

b.     Footer

c.      Page break

d.     Page number

 

 

 

 

 

 

 

EXERCISE 5 (INTRODUCTION TO PRESENTATION)

1.     Which of the following tabs in PowerPoint is used to insert pictures?

a.     Home

b.     Deign

c.      Insert

d.     Animations

2.     Which of the following keyboard keys is used to remove an image from a slide?

a.     Backspace

b.     Delete

c.      ALT

d.     Esc

3.     A snapshot of an area on your computer screen is known as__

a.     Capture

b.     Screenshot

c.      Animation

d.     Transition

4.     Which of the following screenshot option is used to insert the image of the open application?

a.     Screen clipping

b.     Available windows

c.      Picture

d.     Format

5.     Which of the following  will you use to add shapes to your slide?

a.     Home

b.     Insert

c.      Design

d.     Layout

6.     Which of the following tabs will you use to add shapes to your slide?

a.     Home

b.     Insert

c.      Design

d.     Layout

7.     Which of the following tools can you use to create designer-quality diagrams?

a.     SmartArt

b.     Smart Shape

c.      Smart draw

d.     Smart images

8.     When your select an inserted shape and start typing, what will happen?

a.     The shape is deleted

b.     The text will replace the image

c.      The text will be inserted in the shape

d.     Nothing will happen

9.     Which of the following tools is used to combine different shapes to form new ones.

a.     Edit

b.     Merge

c.      Shift

d.     Shape

10.                        Which of the following options erases shapes except for the parts that overlap?

a.     Union

b.     Combine

c.      Intersect

d.     Subtract

 

 

EXERCISE 6 (INTRODUCTION TO DESKTOP PUBLISHING)

1.     Books, brochures and greeting cards are best created with__

a.     Word processing

b.     Spreadsheet

c.      Database

d.     Desktop Publishing (DTP)

2.     Pick the odd one out of the following software.

a.     Adobe PageMaker

b.     MS publisher

c.      Adobe InDesign

d.     MS word

3.     The term WYSIWYG means

a.     Printed pages look exactly like what is on the screen.

b.     Printed pages are different from what is on the screen.

c.      Printed pages are smaller than what is on the screen.

d.     Printed pages are larger than what is on the screen.

4.     The default ribbon in Publisher is the ___

a.     Page design

b.     Home

c.      Insert

d.     Review

5.     Options like shape, calendars, borders and hyperlinks are found on the………..tab.

a.     Page design

b.     Home

c.      Insert

d.     Review

6.     Which of the following tabs allows users to change the page orientation, margin and size of their publication?

a.     Page design

b.     Home

c.      Insert

d.     Review

7.     Which of the following tabs is used for checking wrong spellings and grammar in MS publisher?

a.     Page design

b.     Home

c.      Insert

d.     Review

8.     Which of the following tabs is used for basic image editing?

a.     Page design

b.     Drawing tools

c.      Insert

d.     Home

9.     Which of the following tabs is used to insert and edit shapes in MS publisher?

a.     Pictures tools

b.     Insert

c.      Home

d.     Drawing tools

10.                        The pictures icon is located in which of the following tabs?

a.     Review

b.     Drawing

c.      Insert

d.     Home

 

 

 

EXERCISE 7 (INTRODUCTION TO ELECTRONIC SPREADSHEET)

1.     All the following can be contained in a formula except___

a.     Cell reference

b.     Values

c.      Mathematical operator

d.     Alphabets

2.     Which of the following is the correct way to insert the sum function?

a.     =SUM(A2:A_10)

b.     =SUM(A:2:A-10)

c.      =SUM(A2:A10)

d.     SUM(A2:A10)

3.     Which of the following functions is used to find the largest numerical value in a range of cells?

a.     AVERAGE

b.     SUM

c.      MAX

d.     MIN

4.     Which of the following functions is used to find the smallest numerical value in a range of cells?

a.     AVERAGE

b.     SUM

c.      MAX

d.     MIN

5.     Which of the following functions is used to count cells containing only numbers?

a.     COUNT

b.     COUNTA

c.      COUNTBLANK

d.     COUNTIF

6.     Which of the following functions is used to count any kind of data?

a.     COUNT

b.     COUNTA

c.      COUNTBLANK

d.     COUNTIF

7.     Which of the following functions is used to count empty cells in a cell range?

a.     COUNT

b.     COUNTA

c.      COUNTBLANK

d.     COUNTIF

8.     Which of the following functions is used to count the number of cells that meet a criterion?

a.     COUNT

b.     COUNTA

c.      COUNTBLANK

d.     COUNTIF

 

9.     The function =COUNTIF(A1:A10, “>20”) will….

a.     Count the number of cells containing 20.

b.     Count the number of cells with values more than 20.

c.      Count the number of cells with values less than 20.

d.     Count the number of cells with a value not equal to 20.

10.                        The function =COUNTIF(B7:B12, “<>12”) will….

a.     Count the number of cells containing 12.

b.     Count the number of cells with values more than 12.

c.      Count the number of cells with values less than 12.

d.     Count the number of cells with a value not equal to 12.

 

 

 

 

 

EXERCISE 8 (COMPUTER NETWORKS)

1.     The acronym OSI stands for…..in a computer network.

a.     Organization for standard education

b.     Open system interconnection

c.      System interconnection

d.     Open system interworking

2.     How many layers are there in OSI reference module in networking?

a.     6

b.     6

c.      7

d.     8

3.     Who developed standards for the OSI reference module?

a.     ANSI – American National Standards Institute

b.     ISO – International Standards Organization

c.      IEEE – Institute of Electrical and Electronics Engineers.

d.     ACM – Association for Computing Machinery

4.     Choose the correct layer numbers and names of the OSI model below.

a.     Layer 7 – Application layer and layer 6 – presentation layer

b.     Layer 5 – Session layer and layer 4 – Transport layer

c.      Presentation layer

d.     Data link layer

5.     In an OSI model, the lowest layer is the ……..layer.

a.     Application layer

b.     Physical layer

c.      Presentation layer

d.     Data link layer

6.     Internet model has ……..layers

a.     1

b.     2

c.      3

d.     4

7.     ……………..helps two or more computers to communicate in a network.

a.     Communication protocol

b.     Cables

c.      Keyboard

d.     Layers

8.     The mechanism for transferring data in a network is called…

a.     Transmitter

b.     Transmission mode

c.      Transistor system

d.     Transition

9.     There are ………….main types of communication protocols.

a.     1

b.     2

c.      3

d.     4

10.                        Classes of internet address are….

a.     Two

b.     Three

c.      Four

d.     Five

 

EXERCISE 9 (INTERNET AND SOCIAL MEDIA)

1.     Social media sites used for uploading photos is termed as…..

a.     Photosharing

b.     Photoshoot

c.      Photobuzz

d.     Microsoft

2.     A website used for uploading videos is called….

a.     Facebook

b.     Video sharing

c.      Whatsapp sharing

d.     Video sharing

3.     All the listed below are examples of sites used for sharing video except…

a.     Facebook live

b.     Vimeo

c.      Youtube

d.     Instagram

4.     All the listed below are advantages of photosharing sites except…

a.     Advertising fashion pictures

b.     Post nice pictures

c.      Posting bad pictures

d.     Photofrienship

5.     Emails are slower than paper-based mail.

a.     True

b.     False

6.     An example of sites for sharing photos includes……..

a.     Snapchat

b.     Instagram

c.      Vimeo

d.     Pinterest

7.     Which of the following is a web-based mail book that is used to store email and contact information about one frequently emailed?

a.     Electronic mail

b.     Web book

c.      Address book

d.     Digital book

8.     What is the first step to attaching a file to an email?

a.     Log out

b.     Log in

c.      Click the attached file symbol

d.     Cut and paste file

9.     The method of sending mail digitally or electronically is termed as….

a.     X-mail

b.     Y-mail

c.      E-mail

d.     G-mail

10.                        One use of address book is…..

a.     Cut copy

b.     Cost cut

c.      Carbon copy

d.     Look up acts

 

 

 

 

EXERCISE 10 (INFORMATION SECURITY)

 

 

                                                                          

INPUT DEVICES

Comments

Popular posts from this blog

Holiday Assignment