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
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.
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 |
|
|
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.
(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.
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
(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.
(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:
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;
(ii) A medium of communication that transfer signals along a cable using light is known as
(iii)Which of the following is correct according to Microsoft Excel function?
(iv) Refer to the use of computer to defile records and steal money:
(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:
(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.
(vii) ________allows to recognize and add more effects to your digital footage
(viii) Which among the following is NOT an advantage of print media?
(ix) The program that allow hardware and software to work together and act as intermediary the user and the computer hardware is known as:
(x) The area in the CPU that holds the frequently accessed data and instructions
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 |
|
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
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;_____
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?______
iii. The best application program used to collect related file is known as __________
iv. Publishing a webpage means__________________
v. the name of this cell will be; __________
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?_______________
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?__________________
ix. ________________________ is a name used to identify a computer in a network
x. A collection of related web pages that you can access electronically is called?___
x. Assume you are using MS word, which windows feature will show you the name of the document and program.:___________________
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 |
|
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:
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)
(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
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);
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
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?
ii. The database object that enables you to view and print data from a database table in a chosen appearance is called
iii. The problem of eye strain which is caused by spending a lot of time on using computers can be minimized by
iv. Which program would you use in preparing application letter
v. Which keyboard keys are referred to as special purpose keys in a personal computer?
vi. Which printer would you suggest for printing school examination?
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?
viii. Which tag would you use to emphasize the heading of the article in the webpage?
ix. What is alternative name of utility program?
x. Which device would you use to connect seven computers so that they can share the same bandwidth?
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 |
|
|
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