Sekolah Menengah Sayyidina Hasan
Computer Studies
Time: 2 hours
Instructions to candidates
Do not open this exam until you are asked to do so.
This booklet contains THREE sections. Answer ALL questions in Section A, Section B and Section C Part One. In Section C Part Two answer TWO questions only.
You are given five minutes to read all the questions
Information to candidates
The number of marks is given in brackets [ ] at the end of section or each question or part of the question. The total number of marks for this paper is 100
Marks
| Section A | |
| Section B | |
| Section C Part One | |
| Section C Part Two | |
| Total |
SECTION A
Choose the BEST ANSWER, then write its letter (A,B,C, or D) in the answer box
1) A field is …
a) An item of data
b) A row in a database table
c) A place to grow vegetables
d) A column in a database table
2) An operating system is …
a) Hardware
b) A set of instructions
c) A peripheral
d) A central processing unit
3) Which of the following is an output device?
a) scanner
b) track ball
c) monitor
d) Keyboard
4) An I/O device…
a) Sends data to the central processing unit
b) Receives data from the central processing unit
c) Both A and B above
d) Neither A or B
5) What can a CD-RW disk be used for?
a) Input only
b) Output only
c) Input and Output
d) None of the above
6) Which of the following is application software?
a) Paint.
b) Microsoft Access
c) Both A and B
d) Neither A or B
7) What hardware might be used for main storage in a computer system.
a) Floppy disk
b) Printer
c) Random access memory chips
d) Magnetic tape
8) We can use formulas when interacting with a …
a) Spreadsheet software
b) Word processing software
c) Graphics software
d) Presentation software
9) What is CAD used for
a) Computer assisted design
b) Computer Application data
c) Controlling Analog Data
d) All of the above
10) Which is not a function of a database
a) Performing a query
b) Defining table structure
c) Creating an index file
d) Spell check
[10]
Total marks |
SECTION B
Answer ALL questions in this section. Each question is 2 marks.
1) What is the difference between a LAN and a WAN
__________________________________________________________________
__________________________________________________________________
2) What type of software is Visual Basic and what is it used for?
__________________________________________________________________
__________________________________________________________________
3) Write down the names of two types of memory.
i) _____________________________________________________________
ii) _____________________________________________________________
4) What are two types of printer?
i) _____________________________________________________________
ii) _____________________________________________________________
5) What do the following two acronyms stand for
i) UPC ____________________________________________________
ii) ISBN ____________________________________________________
6) Give two uses of microcomputers in Brunei
i) _____________________________________________________________
ii) _____________________________________________________________
7) Give two examples of the use of mainframe computers in Brunei
i) _____________________________________________________________
ii) _____________________________________________________________
8) What are two reasons for choosing to use a LAN instead of standalone computers?
i) _____________________________________________________________
ii) _____________________________________________________________
9) What are two reasons for choosing to use a dot matrix printer
i) _____________________________________________________________
ii) _____________________________________________________________
10) Write down two examples of special purpose (embedded) computers
i) _____________________________________________________________
ii) _____________________________________________________________
11) Name two parts you can find inside a system unit?
i) _____________________________________________________________
ii) _____________________________________________________________
12) What are two examples of multi-user computing in Brunei
i) _____________________________________________________________
ii) _____________________________________________________________
13) Name two pieces of hardware required to use E-mail
i) _____________________________________________________________
ii) _____________________________________________________________
14) What is a URL and what is it used for.
i) _____________________________________________________________
ii) _____________________________________________________________
15) Give two reasons why word processing is popular for creating documents
i) _____________________________________________________________
ii) _____________________________________________________________
[30]
| Total marks |
SECTION C PART ONE
Answer ALL questions in this section. Each question is worth 8 marks.
1) In the near future most people in Brunei will make use of eftpos.
a) What does eftpos stand for? [1]
____________________________________________________________
____________________________________________________________
b) What do you need to have so that you can use eftpos? [1]
____________________________________________________________
____________________________________________________________
____________________________________________________________
c) What are two advantages for the customer of using eftpos? [2]
____________________________________________________________
____________________________________________________________
____________________________________________________________
____________________________________________________________
d) What are two advantages for the business that has eftpos facilities? [2]
_________________________________________________________
____________________________________________________________
e) What is the difference between an credit card and a debit card? [2]
____________________________________________________________
____________________________________________________________
2) Our school has just connected its computers to the Internet using E-speed.
a) To connect to the Internet we must first go through an ISP. Describe what an ISP is. Describe two services that an ISP provides. [3]
i) _____________________________________________________________
ii) _____________________________________________________________
iii) _____________________________________________________________
b) We have computers in many different areas of the school that can communicate together. What type of network do we have inside the school? What type of network does our school connect to when it connects to the ISP? [1]
i) _____________________________________________________________
ii) _____________________________________________________________
c) Describe the function of a modem? [1]
_____________________________________________________________
_____________________________________________________________
d) What is the purpose of a hub? [1]
_____________________________________________________________
_____________________________________________________________
e) What can we do to make sure that people do not access your computer from other parts of a network? [1]
_____________________________________________________________
_____________________________________________________________
f) How is ADSL different to normal dial up network access? [1]
_____________________________________________________________
_____________________________________________________________
3) You decide to use your computer to model your finances. You set up the following information.
A | B | C | D | E | F | G | |
1 | January | Expenses | Income | Total | |||
2 | School books | $50 | |||||
3 | Food | $20 | |||||
4 | CD | $10 | |||||
5 | Jerrudong Park | $12 | |||||
6 | $92 | ||||||
7 | Pocket money | $80 | |||||
8 | Holiday work | $30 | |||||
9 | School money | $100 | |||||
10 | $210 | ||||||
11 | Balance | $118 |
What software package have you used? [1]
_____________________________________________________________________
Write down the address of a cell that contains a label. [1]
_____________________________________________________________________
Write down the address of a cell that contains a number. [1]
_____________________________________________________________________
Write down the formula that goes in cell B11. [2]
_____________________________________________________________________
Write down the name of a function that you could use in D6. [2]
_____________________________________________________________________
How much money are you able to save for the month of January? [1]
_____________________________________________________________________
4) Answer the following questions about hardware.
a) Describe two ways that we can input data without using a keyboard. Name the device you would use in each case. (hint: ocr, eftpos, isbn, upc) [4]
i) _____________________________________________________________
_____________________________________________________________
ii) _____________________________________________________________
_____________________________________________________________
b) What does it mean if an advertisement says "Intel Pentium 4 processor at 2.20GHz"? [2]
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
c) What is the difference between a VCD and a DVD? [2]
_________________________________________________________________
_________________________________________________________________
_________________________________________________________________
5) You have decided to set up a two database tables with the following information
| IC | Name |
| 564432 | Ahmad Jafni |
| 829007 | Atiquah |
| 872432 | Hj Nasrul |
| Number plate | Owner IC | Make | Model |
| KB1243 | 829007 | Mitsubishi | Verada |
| DB7652 | 564432 | Ford | Mondeo |
| DB9872 | 873432 | Mitsubishi | Lancer |
What is the name of the person who has IC number 564432? [1]
__________________________________________________________________
What is the name of the person who drives the car with number plate KB1243 [1]
__________________________________________________________________
Suriani has IC number 786534. She has a Mitsubishi Magna with Number plate XY9732. Add lines to the database tables above to record Suriani’s information.[4]
What would you use for the key field for the first table? [1]
_________________________________________________________________
Why would it be wrong to use "Make" as the key field for the second table? [1]
__________________________________________________________________
[40]
Total marks |
SECTION C PART TWO
Choose any TWO questions and write the answers on the attached ruled sheets.
There are three sizes of computer. Write down what defines each size and describe some applications they are used for in Brunei.
Describe how you can protect information on a computer against natural disasters, hackers, viruses and normal equipment failure.
Computer viruses are a problem. Describe what a virus is and the methods that can be used to prevent a computer from getting infected
What are some of the social implications of information technology?
Describe the steps you would take to solve a computer problem which involves creating a computer program.
