COMPUTER FORM FOUR REGIONAL EXAMS (MOCK, PRE-NATIONAL, etc.)

Student’s Assessment Number . . . . . . . . . . . . . . . . . . . . . . . .

THE PRESIDENT’S OFFICE – RALG TAHOSSA ROMBO DISTRICT EXAMINATION SYNDICATE
FORM FOUR MOCK EXAMINATION

036/1 INFORMATION AND COMPUTER STUDIES 1

TIME: 3:00 Hours August, 2024

Instructions

  1. This paper consists of sections A, B and C with a total of twelve (12) questions.
  2. Answer all questions in section A, B and one (1) question from section C.
  3. Cellular phones and any unauthorized materials are not allowed in the examination room.
  4. Write your Examination Number on every page of your answer booklet (s)
FOR ASSESSORS’ USE ONLY
QUESTION NUMBER SCORE ASSESSORS' INITIALS
1.    
2.    
3.    
4.    
5.    
6.    
7.    
8.    
9.    
10.    
11.

12.


TOTAL    
CHECKERS' INITIAL    

SECTION A: 16 MARKS

Answer all questions

i. The ability to recover and read deleted or damage files from a criminal’s computer is an example of a law enforcement specialist called:

  1. Programmer
  2. Crime fighter
  3. Computer technician
  4. Computer forensics

ii. Allocation of resources in a time depend manner to several program simultaneously called:

  1. Multi user
  2. Multi-tasking
  3. Time sharing
  4. None of above

iii. Verification of a login name and password is known as

  1. Configuration
  2. Accessibility
  3. Authentication
  4. Identification

iv. Which of the following is correct IP address?

  1. 192.168.111.111
  2. 192.168.1.1
  3. 192.168.900.1
  4. 192.900.168.1

v. The fraud which occurs when a fraudster uses a false or face identity to gain access to an electronic mail is called

  1. Clip on
  2. Roaming
  3. Hacking
  4. Subscription

vi. A software program that enables a user to locate and retrieve information on the www is known as

  1. Yahoo
  2. Search engine
  3. Browser
  4. Google

vii. A computer network media that supports large volume of data transfer is called:

  1. Fiber optical cable
    Twisted pair cable
  2. Coaxial cable
  3. Un twisted pair cable.

viii. Cham wants to enter Computer Studies test marks in a spreadsheet. Which of the following keys will make the data entry faster?

  1. Control keys
  2. Function keys
  3. Numeric keypad
  4. Character key

ix. Calculations, comparisons and logical operations in the CPU are performed by

  1. Calculation and logical unit
  2. Computer calculator
  3. Arithmetic and logical unit
  4. Arithmetic unit.

x. The following are devices used to feed data in a computer except

  1. Bar coder reader
  2. Tracker ball
  3. Touch pad
  4. Plotter

2. Match the following responsibilities in List A with their corresponding career opportunities in List B by writing the letter of the correct option beside the item number in your answer booklet

LIST A LIST B

i) A device which converts printed materials into electronic text without having to retype.

ii) A printer which has removable flower-like wheel consisting of spokes with embossed characters.

iii) A printer that is expensive to buy but cheap to run.

iv) Printers which are used in the point of sale terminals to print receipts and bar code.

v) A printer which is very expensive to run due to higher cost of replacing the cartridges.

  1. Daisy wheel
  2. Digital camera
  3. Dot matrix printer
  4. Inkjet printer
  5. Laser printer
  6. Photo printer
  7. Plotter
  8. Scanner
  9. Thermal printer

SECTION B (75 Marks)

Answer ALL questions in this section

3. Rearrange the following statement in a right way (5 marks)

A. Apply ALL
B. Select an animation effect from the list.
C. Click on the Animations tab in the navigation ribbon.
D. Select the text or object you need to animate
E. Click Add Animation.

4. a) What is DBMS? (1 marks)

b) Describe two advantages of using Electronic database. (2 marks)

c) Describe two disadvantages of using Electronic database. (2 marks)

5. a) What is computer security? (1 mark)

b) Mention four things to consider in the computer laboratory to ensure security your computer and information. (3 marks)

c) Explain any four health problem that computer user can face due to excessive use of computers and other ICT related devices and their precaution to avoid it. (6 marks)

6. The snapshot below shows the result of form three students at Mambo Yote Secondary School. Study it carefully and answer the questions that follow

Hint: (The grade is “A” if the average is >=75, “B” if the average is >=65 and “C” if the average is >=45).

  1. Write the name of the programme used to create the snapshot above (1 marks)
  2. Write the cell reference of the active cell (1 marks)
  3. Write the font size and font type used to create the snapshot above (1 marks)
  4. Which steps would you follow to align the heading in the worksheet vertically? (1 marks)
  5. Write the function used to calculate the average marks of “Kabula” (1 marks)
  6. Write the functions used to assign grade and position of “Zephania” (1 marks)

7. a) Every page has a unique web address called URL. Mention four domain and institution may use that domain. (2 marks)

b) Why do you think the content of the webpage needs to be written between the <body> and </body> tags? (2 marks)

c) Write the output of the following HTML codes. (5 marks)

8. a) Define the term multimedia and mention its five basic elements (2 marks)

b) Differentiate between

  1. Linear and Non-linear multimedia (2marks)
  2. Hypertext and Hypermedia (2marks)

c) Give four characteristics of a multimedia system (4marks)

9.a) You are asked to prepare a school identification card by using a computer; give other two hardware and software needed to complete your work. (2marks)

b) Explain four advantages of using Desktop Publishing (DTP) over word processor. (8 marks)

10. Suppose you were given an opportunity to speak to your fellow students on the motion which states that “computer causes more harm to the society than benefit”. Explain four points that you would use to support this motion. (10 marks)

11. Explain four factors that can affect the speed of internet connections. (10 marks)

SECTION C (10 Marks)

Answer one (1) question in this section

12. Elaborate four factors that can hinder effective communication. (10 marks)

13. Explain the five generations of computer based on the characteristics of each generation. (10marks)

FORM FOUR COMPUTER EXAM SERIES 217  

FORM FOUR COMPUTER EXAM SERIES 217  

THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

LINDI REGION

 FORM FOUR PRE NATIONAL EXAMINATION

036/1: INFORMATION AND COMPUTER STUDIES (ICS)

 (For Both School and Private Candidates)

Time: 3:00 Hours SEPTEMBER 2023

Instructions

  1. This paper consists of sections A, B and C with a total of eleven (11) questions.
  2. Answer all questions in sections A, B and ONLY TWO (2) questions in section C.
  3. Calculators, cellular phones and any unauthorized materials are not allowed in the examination room.
  4. Write your Examination Number on every page of your answer booklet(s).

SECTION A (16 MARKS)

Answer all questions in this section

1. For each of the following items (i) - (x), choose the correct answer from among the given alternatives and write its letter beside the item number in the answer booklet provided.

  1. The end product of the computer processing is known as
  1. News
  2. Data
  3. Program
  4. Information.
  5. Input
  1. A file system extension used by default when saving a new word document in MS word.
  1. .doc
  2. .docx
  3. .txt
  4. .xlsx
  5. .docc
  1. What does an advertisement with a combination of text, audio, pictures and some animations presents?
  1. Hyperlink presentation 
  2. Hypermedia presentation.
  3. Multimedia presentation. 
  4. Single media presentation.
  5. Interactivity presentation.
  1. Which method is best for protecting the computer against short circuiting?
  1. Providing standby generator.
  2. Providing fire extinguisher.
  3. Providing surge protector.
  4. Providing insulated cables.
  5. Providing air ventilation.
  1. The correct sequence of computer arranged in descending order according to their physical size and processing power is.
  1. Mainframe computer, minicomputer, supercomputer.
  2. Minicomputer, mainframe computer, supercomputer.
  3. Minicomputer, supercomputer, mainframe computer.
  4. Supercomputer, mainframe computer, minicomputer.
  5. Mainframe computer, supercomputer, minicomputer.
  1. Which object will you use to create a form in Microsoft access?
  1. Table and queries.
  2. Queries and design views.
  3. Table and reports.
  4. Queries and reports.
  5. Table and design views.
  1. What is the function of the following combination of keys is used to save the new Microsoft word document.
  1. Alt+ S
  2. Shift+S
  3. Ctrl+S
  4. Ctrl+ E
  5. Ctrl+Z
  1. Cell A4, A7, C4, C5 and C7 contain value 5, 5, 12, 2 and 6 respectively. Then in cell D a formula =C5*(A4+A7)-(C4/C7) is entered. What will be the value for cell D?
  1. 28
  2. 18
  3. 8
  4. 14
  5. 16
  1. Which of the following computer generation is characterized by Very Large Scale Integrated Circuit (VLSI)
  1. First generation
  2. Third generation
  3. Second generation.
  4. Fourth generation.
  5. Fifth generation
  1. Computer networks without a server are called
  1. Client-server
  2. Network server.
  3. Peer to peer
  4. Personal networks.
  5. None server networks

2. Match the items in LIST A with the most correct response in LIST B by writing the letter of the response beside item number in the answer sheet(s) provided.

LIST A:

LIST B

  1. Are programmable keys.
  2. A key used to move several spaces at a time.
  3. Acts as a shortcut to execute commands.
  4. Erase the character to the immediate left hand side of the cursor
  5. Erase the character to the immediate right hand side of the cursor
  6. Cancels a menu or dialog box.
  1. Shift key
  2. CAPS LOCK
  3. Delete key
  4. ENTER
  5. Page down
  6. Tab key
  7. Page Up
  8. Back space
  9. Space bar
  10. Function keys
  11. Escape
  12. Control key(Ctrl)

SECTION B: (54 Marks)

Answer all questions in this section

3. (a) What is information dissemination?  

(b)Information dissemination is very important in s society as it help to distribute information quickly. Write down four (4) advantages of information.

(c) Explain three (3) qualities of good information.

4. (a) Explain three importance of database system in daily life.

(b)One of the Government institutions has two different Departments. One department uses paper-based database while other use computerized database. Which department will work more efficient? Give three reasons for your answer.

(c) Distinguish between flat file database and relational database.

  1. (a) Why do we use domain name to open websites instead of their IP address?

(b) What are two (2) roles of HTML form on website?

(c)Write the HTML codes which will display the following output on a web browser.

C:UsersRSS COMPT LABDesktopchuuuu.PNG

6. (a) Using your spreadsheet knowledge, indicate the data type that will be assigned in the following entries.

(i)December 14, 2008

(ii) Total scores

(iii) $ 2,000

(iv) =Average (A3:E3)

(b) The spreadsheet below describes telephone usage for accessing the internet and costs. The cost need to be calculated. The minutes are multiplied by Tarrif 1 to obtain the sub-total.the VAT is based on the sub-total and the total is obtained by adding the sub-total to the VAT

C:UsersRSS COMPT LABDesktop789456123.PNG

(i) What formula was used to find the total time spent on the Internet?

(ii) What formula was used to find the average time spent on the Internet?

(iii) Using absolute referencing, what formula was used to find sub-total?

(iv) Using absolute referencing, what formula was used to find VAT?

7. (a) Define the term search engine.

(b) What is the difference between IP address and MAC address?

(c) Your head of school wishes to be connected to internet. He/she already has a Personal Computer, a printer, and access to Telephone line. However, he/she understand that a modem is needed. State why a modem is required to connect him/her to the internet

(d) (i) Suggest and explain any application area in which you would expect a supermarket retail manager to use the internet

(ii) A file in a Mingoyo secondary school website can be accessed via the following URL: http://www.MingoyoSec.ac.tz/results/form_4_results.pdf. Briefly explain the parts of this address.

  1. (a) Define the term network topology.

(b)Explain two (2) functions of the Network Interface Card (NIC).

(c) State and briefly describe the following types of physical network topologies.

(i) Mesh topology

(ii) Tree topology

(iii) Ring topology

(d)Briefly explain three (3) benefits of using Local Area Networks In any government institution in Tanzania.

SECTION C (30 Marks)

Answer ONLY TWO (2) Questions from this section

9. Why schools should include the use of Information and Communication Technology in teaching and learning process? Explain by giving five (5) reasons.

10. Explain five (5) devices that are used to protect a computer and other electrical equipment from the effects of power fluctuation.

11. Explain five (5) aids that can be used in electronic presentation.

FORM FOUR COMPUTER EXAM SERIES 184  

FORM FOUR COMPUTER EXAM SERIES 184  

THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION & LOCAL GOVERNMENT

KILIMANJARO FORM FOUR MOCK EXAMINATION

036/1 INFORMATION AND COMPUTER STUDIES 1

TIME 3 HOURS MAY 2023

INSTUCTIONS:

  1. This paper consists of section A, B and C with a total of Eleven (11) Questions
  2. Answer all questions in Section A, B and two (2) Questions from section C
  3. Your work should be clearly Shown
  4. Write your Examination Number on every page
  5. Mobile Phone are Not allowed in the examination room

SECTION A

1. For each of the following items (i) – (x) choose the most correct answer among the alternatives provided and write its letter beside the item number in the booklet provided.

(i) As far as database is connected, the field which prevents a user from making double entries in the database table is;

  1. Query
  2. Foreign key
  3. Security key
  4. Primary key
  5. Validation rule

(ii) A medium of communication that transfer signals along a cable using light is known as

  1. Twisted pair cable
  2. Coaxial cable
  3. Ethernet
  4. Unshielded twisted cable
  5. Optical fiber cable

(iii)Which of the following is correct according to Microsoft Excel function?

  1. = SUM (A1”. A2”. A3”)
  2. =SUM(A1,A2,A3)
  3. SUM (A1:A3)
  4. TOTAL (A1:A3)
  5. A1+A2+A3

(iv) Refer to the use of computer to defile records and steal money:

  1. Fraud
  2. Piracy
  3. Hacking
  4. Vandalism
  5. Cracking

(v) Most of modern computers are installed with the CMOS battery which held date and time among other functions, what are the other details which are held in the CMOS:

  1. Operating system
  2. Application software
  3. Basic Input/ Output system detail
  4. Anti- virus
  5. Database

(vi) The school administration experience irregular and frequent high -power in their computer laboratory. What advice would you give them so that they protect their computers.

  1. To install Voltage regulator
  2. To install UPS
  3. To install Firewall
  4. To install surge protector
  5. To have standby fire extinguisher

(vii) ________allows to recognize and add more effects to your digital footage

  1. Audio editing software
  2. Video editing software
  3. Paint program
  4. Animation
  5. Browser

(viii) Which among the following is NOT an advantage of print media?

  1. Are popular among consumers
  2. They are mostly trusted and have many readers
  3. They are ideal for discussing confidential information
  4. They can easily kept for future use
  5. They can easily be used to spread awareness of different matter`s and make advertisement.

(ix) The program that allow hardware and software to work together and act as intermediary the user and the computer hardware is known as:

  1. Application software
  2. Generic software
  3. Operating system
  4. System software
  5. Utility Software

(x) The area in the CPU that holds the frequently accessed data and instructions

  1. Random access memory
  2. Cache memory
  3. Read only memory
  4. Compact disk
  5. Memory Card

2. Match the item in LIST A with the correct item in LIST B as used in networking and communication by writing the letter of the most correct answer beside the item number in your booklet(s)

LIST A

LIST B

i. Transmission of data without physical path 

ii. It includes transmission of data by physical means 

iii. The means for receiving and sending data or information 

iv. The destination of the sent information

v. One of the means used to deliver messages to many people at once

vi. The channel in which information passes

  1. Receiver
  2. Unguided media
  3. Data
  4. Dissemination
  5. Medium
  6. Source
  7. Communication media
  8. Guided media
  9. Meetings

SECTION B (54 MARKS)

3. (a) Multimedia had begun a very long time ago. It is considered to combine texts, images, audio , video and audio visual graphics.

i) Give any four multimedia devices used now days ii) Briefly explain two areas where multimedia is useful iii) With examples Briefly describe interactive content

(b) Electronic learning is now days adapted in many institutions, give two positive aspects of it.

4. Carefully read the database table below and answer the questions that follows:

Employee_ details:

ID

SEX

FIRST NAME

LAST NAME

SALARY

SECTOR

AGE

VAT

I-0001

F

Amina

Mmanga

300,000

Education

26

I-0002

M

Kian

Mwanga

550,000

Education

37

I-0003

M

Allan

Barnaba

400,000

30

I-0004

F

Neema

Songambele

400,000

Health

32

I-0005

F

Princes

Lau

550,000

Agriculture

38

I-0006

F

Hamida

Hussein

350,000

Education

26


(a) What is the table name?

(b) How many records are there in the database (c) How many fields are in the database table.

(d) What kind of Data type is used in salary field ?

(e) Suggest the field that should be assigned the primary key and why?

(f) Write the criteria to be used in the sector filed to query employees who have no sector

(g) Write the criteria to query and insert a new filed of VAT , having calculated 18% of salary of each employee.

5. Mr Nguvu has recently bought a person computer but he is not familiar with some application software. As a knowledgeable computer user help with to;

i)Highlight four features which distinguish Desktop publishers software from word processing software

ii)Describe four tools of the tools of the toolbox used to design and manipulate publication.

iii) Describe Why word processor is more preferred than Manual type writer?

6. a) Mr kalmakenge is the customer of Mini commercial bank (RCM).The bank issues plastic cards and unique personal identification number (PIN) to customers so that they can get access to their accounts through a special machine called ATM

i) What do you understand by the term ATM? ii) Why do you think ATM is so important?

iii) Describe the main purpose of customers having a PIN

b) Write the output/display from html code below

<html>

<head>

<title> html code </title>

</head>

<body>

<table border="1">

<tr>

<td>

<form action="send" >

<H3 ALIGN="CENTER">KILIMANJARO REGIONAL COMMISSIONER'S OFFICE</H3>

<H4 ALIGN="CENTER">MOCK EXAMINATIONS FOR FORM IV</H4>

Choose the subject you like from the following list:<BR//>

<input type="radio" name="ICS" checked >ICS <BR/>

<input type="radio" name="KISW" >KISWAHILI <BR/>

<input type="submit" value="SEND" >

</form>

</td>

</tr>

</table>

</body>

</html>

7. a) Mr. Kishikwambi asked his students to propose the devices they could purchase that can be useful in establishment of computer network in the school. As a computer student , what are the five basic devices that you will tell Mr. Kishikwambi ? Let him know about their functions also.

b) A certain company would like to establish a network in their office. As expert explain to the manager with the aid of diagram two topologies that they can use.

8. a) computer hardware are categorized based on their operations, namely input, processing and output. Describe them briefly giving one example each.

b) Computers can be classified in different ways, but just give your classification based on the types of signals they use, and give some explanation.

SECTION C (30 MARKS)

Answer two (2) questions from this section

9. As a form four student taking ICS, you have visited the academic office and after observing the way they are keeping students file by using paper files, write your proposal to convince the school administration to shift from paper files to Electronic database. (4 points)

10. ICT facilitates communications from one place to another, where by it has increased the transfer speed and reduce the distance where the information or data is sent although there are some barriers of communication. Explain with example four (4) barriers of communication as far as ICT is concerned.

11. In the world today, education is growing so fast, internet has served a great services in E-learning, from your knowledge about internet and networking, explain with examples four (4) merits of E-learning.

FORM FOUR COMPUTER EXAM SERIES 177  

FORM FOUR COMPUTER EXAM SERIES 177  

THE UNITED REPUBLIC OF TANZANIA PRESIDENT’S OFFICE REGIONAL ADMINISTRATION AND LOCAL GOVERNMENT

 ZONAL FORM FOUR MOCK EXAMINATIONS 

(NJOMBE, MBEYA, SONGWE, RUKWA AND KATAVI REGIONS)

36/01 INFORMATION & COMPUTER STUDIES 1

TIME 3:00 HOURS YEAR: 2023

INSTRUCTIONS

  1. This paper consists of section A, B and C with a total of eleven (11) questions.
  2. Answer all questions in sections A and B and only TWO (2) questions from section C
  3. Section A carries sixteen (16) marks, section B fifty-four (54) marks, and section C carries thirty (30) marks.
  4. Cellular phones are not allowed in the examination room
  5. Write your Examination number on every page of your answer booklet(s)

SECTION A: (16 Marks)

Answer all questions in this section.

1. For each of the following items (i) - (x), choose the correct answer from the given alternatives and write the item in the answer booklet provided.

i. The origination of the message or information to be disseminated is called;_____

  1. Medium 
  2. Source 
  3. Feedback 
  4. Receiver E
  5. Channel [      ] 

ii. Cells A4, A7, C4, C5 and C7 contain values 5, 10, 8, 2 and 4 respectively. In cell D8 a formula

= C5 * (A4 + A7) – (C4 / C7) is entered what will be the result displayed?______

  1. 18 
  2. 14 
  3. 12 
  4. 16 
  5. 28  [      ] 

iii. The best application program used to collect related file is known as __________

  1. Access 
  2. Dogslide 
  3. Spreadsheet 
  4. Adobe maker 
  5. Power ISO [      ] 

iv. Publishing a webpage means__________________

  1. To transfer data from flash disk to a computer 
  2. To transfer web pages to web server
  3. To transfer power from system unit to monitor
  4. To transfer data from computer to internet explorer
  5. Transfer data to the desktop. [      ] 

v. image the name of this cell will be; __________

  1. Empty cell 
  2. A1 
  3. 1A 
  4. Active cell  [      ] 

vi. Your ICS teacher bought a new computer which was installed with windows 7 only. What other type of programs teachers my required to perform specific tasks like presentation, word processing and games?_______________

  1. Utility software 
  2. Operating system 
  3. Free software 
  4. Application software
  5. System software [ ]

viii. Headmistress enters data on html software, but when she run it, the table row fails to display on website, which code is necessary to be applied?__________________

  1. </tb> <tb> 
  2. <tr> </a> 
  3. <tr> </tb> 
  4. <tr> </tr> 
  5. <tb> </tb>   [      ] 

ix. ________________________ is a name used to identify a computer in a network

  1. MAC address 
  2. IP address 
  3. NIC 
  4. Protocol 
  5. URL  [      ]  

x. A collection of related web pages that you can access electronically is called?___

  1. Internet 
  2. Internet explorer 
  3. Websites 
  4. Electronic web page
  5. Google Chrome  [      ] 

x. Assume you are using MS word, which windows feature will show you the name of the document and program.:___________________

  1. Menu bar 
  2. Title bar 
  3. Ribbon 
  4. Tool bar 
  5. Status  [      ] 

2. March the following computer hardware in a LIST A with their corresponding use in LIST B by writing the correct letter of the correct option beside the item number in your answer booklet. (6 marks)

List A

List B

image

  1. It used as writing tools on computer 
  2. Convey signal into sounds.
  3. It used to control operation in video game.
  4. It control all operation in the computer.
  5. It control cursor movement
  6. It used to display text, pictures and video.
  7. It convey data into electronic digital format 
  8. It convey electronic data into physical data materials.

SECTION B: (54 marks)

Answer all questions in this section

3. (a). You are provided with five statements about printing handout from the saved presentation document on your computer. Rearrange the statements from the first to the last by writing i ts letter.

A. Type the number of copies and click print button. B. Choose print and select the printer.

C. Open the document. D. On print setting, choose handout of six.

E. Click file tab/office button from the menu bar(5 marks)

(b). Presentation is said to both an art and science. As a science there are principles that you need to observe to deliver a good presentation. And as an art there are principles you need to follow as part of presentation. Describe four steps of preparing a presentation. (4 marks)

4. (a). Computers are electronic devices used to process data and give out information according to the list of instructions. Explain five characteristics of computer which makes it differ from other electronic devices.(5 marks)

(b). VUMA club wish to prepare their materials in modern ways, as ICS student explain to them any four multimedia devices that they can used to prepare those materials. (4 marks)

5. Study carefully Figure below and then answer the questions that follows:

image

a. What topic has presented on figure above? (1 marks)

b. List one function for each following devices as they used on figure above:

i. Server ii. Firewall iii. Switch (3 marks)

c. Explain five advantages of using internet (5 marks)

6. (a). a) write html codes used to display the output below. (5 marks)

image

(b). Write the extensions of the following file as used in computer to identify the file types (4 marks)

i. A plain text ii. Data file created in MS Word

iii. Data file created in MS Excel iv. Data file created in MS PowerPoint

7. A company stores a stock list of spinets in a computer file. Several records are shown in the diagram

image

  1. Write down data type for LOCATION CODE field and SELL field. (1Mark) 
  2. Which field would be used as a key field?(1Mark) 
  3. Differentiate between Select query and Action query.(2Marks) 
  4. Draw a dynaset which will be displayed if the following search condition is entered when creating a query. (SELL ($) >300) and (colour = “B”) (2Marks)
  5. List any three advantages of database management system (3 marks)

8. (a). A computer malware is a malicious program written by people aiming to conduct unwanted operations such as damaging disks and deleting data. Mention four malware preventive measures (4 marks)

(b). Study the figure below carefully so as to answer the question that follows (i-v);

image

  1. Provide a name for an active cell (1 marks) 
  2. Write the function used in column G (1 marks) 
  3. Write the function used to get values in column H (1 marks) 
  4. How many rows do we have in a figure? (1 marks)
  5. What will happen in Column H if ICS values are changed? (1 marks)

SECTION C: 30 MARKS

Answer only two questions from this section.

9. Kazikazi attend one of computer course (desktop publisher), on the end of course the teacher asked him to explain the advantages and disadvantages of desktop publishing in school context. As ICS students, give three advantages and three disadvantages of desktop publishing? (15 marks)

10. Mr. Martin is normally using computer for many hours every day when he is at his office. What five health problems he will face(15 marks)

11. ICT plays great role in combating corruption. Explain six (6) contributions of ICT in eradicating corruption in Tanzania (15 marks)

FORM FOUR COMPUTER EXAM SERIES 175  

FORM FOUR COMPUTER EXAM SERIES 175  

THE UNITED REPUBLIC OF TANZANIA NATIONAL EXAMINATION COUNCIL OF TANZANIA

FORM IV MOCK EXAMINATION 2020 

DODOMA REGION

036/1 INFORMATION AND COMPUTER STUDIES 1

Time: 3HRS Wednesday, 12 August 2020 p.m.

Instructions

  1. This paper consists of sections A, B and C with a total of twelve (12) questions.
  2. Answer all Questions in sections A, B and one question in section C.
  3. Calculators, cellular phones and any unauthorized materials are not allowed in the examination room
  4. Write your Examination Number on every page of your answer booklet(s).

SECTION A (15 Marks)

Answer all question in this section

1. For each of the items (i)-(x) choose the correct answer from among the given alternatives and write its letter beside the item number in the space provided.

i. How can you classify the lap top and desktop computer?

  1. portable computers 
  2. supercomputer 
  3. microcomputer
  4. minicomputer

ii. The database object that enables you to view and print data from a database table in a chosen appearance is called

  1. a form 
  2. a query 
  3. a table 
  4. a report

iii. The problem of eye strain which is caused by spending a lot of time on using computers can be minimized by

  1. taking regular break and using antiglare screen
  2. using adjustable monitor stands and keyboards
  3. adopting a healthy sitting style
  4. using adjustable chairs and footrests

iv. Which program would you use in preparing application letter

  1. Microsoft excel 
  2. Microsoft word
  3. Microsoft power point 
  4. Microsoft access

v. Which keyboard keys are referred to as special purpose keys in a personal computer?

  1. F1, F2, F3 up to F12 
  2. A to Z, Tabs, Caps lock and 0-9
  3. Arrow keys, Tab and Home key 
  4. SHIFT, Ctrl, Alt and ESC

vi. Which printer would you suggest for printing school examination?

  1. Photo printers 
  2. Plotter printers
  3. Laser printers 
  4. Dot matrix printer

vii. Word processor supports enhancement of the documents appearance to make font type and font style more appealing. What action classifies this feature of a word processor?

  1. creating documents 
  2. editing documents
  3. formatting documents 
  4. decorating documents

viii. Which tag would you use to emphasize the heading of the article in the webpage?

  1. <head> </head> 
  2. <title> </title>
  3. <hr> </hr> 
  4. <th></th>

ix. What is alternative name of utility program?

  1. Operating program 
  2. Application program
  3. Software program 
  4. Interface program

x. Which device would you use to connect seven computers so that they can share the same bandwidth?

  1. Switch 
  2. Router 
  3. Hub 
  4. Modem

2. Match the following descriptions of text alignment used in Microsoft word in List A to their corresponding types of alignments in List B

LIST A

LIST B

  1. Form
  2. Reports
  3. Macros
  4. Queries
  5. Pages
  1. collection of rows and columns
  2. it is designed by wizard
  3. visual display that resemble ordinary form
  4. used to generate summary
  5. used to automate some operation
  6. Used to analyse or request for specific records from a database
  7. used to create web-based database
  8. Collection of related field

SECTION B, (75 Marks)

Answer all question in this section

3 Arrange the following in terms of Computer generation (10marks)

i. The computer used Transistors replaced

ii. Used in intelligent robot

iii. The computer used vacuum tubes for circuitry and magnetic drums for memory

iv. Integrated circuit

v. Used in virtual reality a multimedia stimulator

4 a) Explain how to search for information on the web using a search engine (2.5 marks)

b). differentiate between the following terms (4.5 marks)

i. hackers and crackers

ii. security and privacy

iii. internet and intranet

c). Outline types of malicious software that can negatively affect a computer system (3mark)

5 a). Computer users complained for the frequently headaches and fatigue after using the computers in the computer room. State three reasons that could cause these conditions. (3marks)

b). Explain why modern computers are referred to as electronic devices (3marks)

6 (i) What is database management system (DBMS) (2 marks)

(ii) Differentiate between Query and form as used in database (2 marks)

(iii) An electronic database depends on database management system. Why do you think database management system (DBMS) is important software in developing electronic database? (3 points) (6 marks)

7 a) Describe three parts of E-mail (3 marks)

b). Explain how you would send an e-mail that include photos of your birthday to the three friends, one Ludewa and the other in Nairobi and Kigali (4 marks)

c). Explain how you can use instant messenger to chat with colleagues located anywhere in the world (3 marks)

9 a).Mr. Mtweve works up one day only to find his computer dead. Suggest three causes of failure and how to avoid the problem in future (6 marks)

b). Some devices have a combination of input and output functionality. State four such devices (2marks)

c). Explain four data types in worksheet (2 marks)

10 a) What do you understand by the term desktop publisher? (2 marks)

b) Give four examples of desktop publishing software available in the market today (4 marks)

c) Explain four reasons why desktop publishing is more preferred than a word processor? (4marks

SECTION C, (10 Marks)

Answer one (1) Question from this section

11. The ICS teacher wanted to connect his computer to the network for ease downloading teaching and learning materials. Explain four (4) factors that affect network connection.

12. The introduction of computers to the society reveals many benefits. Explain four advantages acquired by developing countries such as Tanzania. (10marks)

FORM FOUR COMPUTER EXAM SERIES 176  

FORM FOUR COMPUTER EXAM SERIES 176  

Download Learning
Hub App

For Call,Sms&WhatsApp: 255769929722 / 255754805256