UNIVERSITY OF CAMBRIDGE INTERNATIONAL EXAMINATIONS
General Certificate of Education Ordinary Level
COMPUTER STUDIES 7010/01
Paper 1
July 2004
2 hours 30 minutes
Candidates answer on the Question Paper.
No Additional Materials are required.
Sekolah Menegah Sayyidina Hasan
O Level Qualifying examination 2004
(b) Wireless Application Protocol (WAP)
[2]
(c) Interpreter [2]
(d) Internet Service Provider [2]
(e) Web Host [2]
(f) Operating System [2]
Describe one benefit and one disadvantage of the use of EFT
Benefit ..
.
Disadvantage
[2]3 (a) Describe two Office Automation (OA) applications.
Example one.
Example two.
.
...[2]Describe two benefits of Office Automation.
Benefit one. .
.. .
Benefit two.
.[2]
For your item named in (a), describe the input,
processing and output.
Input
.
Processing
.
.
Output
.
.
.
...[3]
A supermarket uses point of sale (POS) terminals. Barcodes, (universal product codes) are read by a scanner.
List three things that are included in a UPC.
UPC item 1
.
.
UPC item 2
..
..
UPC item 3
..
..
[3]
Explain how the beginning and the end of a barcode is
identified?
.
...[1]
Barcodes have a check digit. What is the purpose of the
check digit?
.
...[1]
Why is the price NOT included on a UPC?
..
.
...[1]
| A | B | C | D | E | F | G | |
|
1 |
Employee Wages | ||||||
|
2 |
|||||||
|
3 |
Deductions |
12% |
|||||
|
4 |
|||||||
|
5 |
|
Hourly rate |
Hours worked |
Gross Pay |
Deductions |
Nett Pay |
Employee status |
|
6 |
Fadillah |
$3.50 |
15 |
$52.50 |
$6.30 |
$46.20 |
Part time |
|
7 |
Nabilah |
$5.00 |
45 |
$225.00 |
$27.00 |
$198.00 |
Full time |
|
8 |
Azeeatul |
$4.65 |
23 |
$106.95 |
$12.83 |
$94.12 |
Full time |
|
9 |
fitri |
$5.00 |
18 |
$90.00 |
$10.80 |
$79.20 |
Part time |
|
10 |
|||||||
|
11 |
Totals |
$474.45 |
$56.93 |
$417.52 |
|
Transactions |
||||
|
Sale No |
UPC |
Quantity |
Date |
Cashier number |
|
1 |
010 - 34323232 |
1 |
16/7/04 |
3 |
|
2 |
032-453334343 |
3 |
16/7/04 |
3 |
|
3 |
072- 23232212 |
2 |
17/7/04 |
4 |
|
Products |
|||
|
UPC |
Product Description |
Price |
Quantity on hand |
| 000-123456-02 | Walls Ice Cream |
$3.50 |
50 |
| 010 - 34323232 | Box 2B Pencil |
$3.20 |
12 |
| 099 - 34343323 | Plastic eraser |
$0.40 |
50 |
| 044-343232232 | Biro Ball Point Pen |
$1.20 |
35 |
| 043 - 34234232 | Loaf Brown Bread |
$0.90 |
10 |
| 032-453334343 | Packet Beef Sausage |
$2.20 |
12 |
| 072- 23232212 | Baked Beans |
$0.70 |
40 |
Write down the name of the primary key of the Products table
.
...[1]How many records are there in the Transactions table
.
...[1]How many fields are there in the Products table
.
...[1]Which column in the Transactions table is a foreign key
.
...[1]What is the Product Description of the item sold by cashier 4
.
...[1]Describe how the price of an item is changed.
.
...[2]Describe how a new item can be added to the database.
.
...[2]Describe how the Products table is updated when a purchase is made by a customer
.
...[2]Describe how you would create a view that lists all the product descriptions sold by one sales person.
.
...[1]
Using pseudo code, or otherwise, write an algorithm that will input twenty test scores and then print out 5 things: (i) highest score (ii) lowest score (iii) average (iv) number who passed (v) number who failed.
.
.
.
.
.
.
.
.
.
.
.
.
.
.
[10]
Read this algorithm..
termNumber = 3
lastTerm = 1
currentTerm = 1
display lastTerm
display currentTerm
DO WHILE termNumber < 6
newTerm = currentTerm + lastTerm
lastTerm = currentTerm
currentTerm = newTerm
display currentTerm
termNumber = termNumber + 1
END DO
a. Describe two features of a network operating system that
are different from those found on a PC operating system.
Feature one
.
Feature two.
..
..
...[2]
c. The network uses a mixture of hubs, wireless access points
and switches. Describe the main feature of each of these devices
Hub
.
.
.
switch
.
.
.
Wireless Access Point
..
.
..
..
...[6]
d. Describe how printer sharing works and what a print
spooler is.
Printer sharing
.
..
.
Print Spooler
.
..
.
[2]
The manager of a manufacturing company wants to install a computer system to organize the stock in the warehouse and to keep files on the suppliers, the customer accounts the employees and the ingredients for the paint. A systems analyst has been asked to do a feasibility study of the existing manual systems.
e. The system analyst chooses to use three methods to get
information about the system when doing the fact finding phase of
the system development phase. Describe three methods he could use.
Method one
.
..
.
Method two
.
..
.
Method three
.
..
.
[3]
f. After fact finding the system analyst will prepare a
feasibility report. Who is the report written for and what is the
purpose of this report.
Report received by :
.
..
.
[2]
Purpose of the feasibility report
.
..
.
[2]
g. Testing is carried out throughout the system development life
cycle. Describe two tests carried out to make sure there are no
errors in the software.
Software test one
.
..
.
Software test one
.
..
.
The End