Chapter 1 Basic Computer Concepts

typoweheeΗλεκτρονική - Συσκευές

8 Νοε 2013 (πριν από 3 χρόνια και 9 μήνες)

82 εμφανίσεις

1

Chapter
1

Basic Computer Concepts


Part I
-

Multiple Choice Questions

1.

Which of the following is NOT a hardware component of a computer system?


A.

Central Processing Unit


B.

Operating system


C.

Output device


D.

Memory


2.

Which of the following is FA
LSE?

A.

Main memory is a hardware component of a computer system.


B.

Central Processing Unit functions as the “brain” of a computer.


C.

Computer software is the instructions that tell the computer what to do.


D.

A program is raw facts that tell a computer
how to perform a task.


3.

Which of the following is a program?


A.

Memory


B.

Keyboard


C.

Central Processing Unit


D.

Operating system


4.

Which of the following is/are the advantage(s) of mainframe computers over microcomputers?


I.

Mainframe computers
have higher storage capacity.


II.


Processing speed of mainframe computers are faster than that of microcomputers.


III.

Mainframe computers are less expensive than microcomputers.


A.

I

only


B.

I

and
II


C.

II

and
III


D.

I
,
II

and
III


5.

Which of the
following is TRUE?


A.

Computer software can be classified into system software and operating software.


B.

Hardware refers to the instructions that make a computer work.


C.

Computers accept input, process instructions and produce output.


D.

Data is a se
t of instructions that tells a computer to perform a specific task.



2

Part II
-

Questions

Level 1

1.

(a)

What are the five physical components of a computer system?




Input device, central processing unit, output device, main memory and backing store.


(b
)

Which component of a computer system displays the processing results?



Output device



2.


(a)

What are the differences between computer hardware and software?



Hardware is the physical components of a computer system. Software is a set of instructions

that tells the computer what to do.


(b)

Give one example of application software and one of system software.



Application software : Microsoft Office 97



System software : Windows NT



3
.


(a)

Write down the difference between a program and data.



A p
rogram is a set of instructions for a computer to perform a specific task. Data is raw facts
about somebody or something.


(b)

State the relation between a program and data.



Data is raw facts while programs are instructions. A computer accepts data as it
s input and
processes the data according to programs. The data will be transformed into information if
the program is successfully executed.



Level 2

4.

Compare the differences between mainframe computers, minicomputers and microcomputers in
terms of storage

capacity, processing speed and cost in the following table.


Mainframe computer

Minicomputer

Microcomputer

Storage capacity

Largest

Large

Small

Processing speed

Highest

High

Relatively low

Cost

Highest

High

Low


5.

Choose the most appropriate type of
computer to be used in the following situations. Explain your
choice.


(a)

An office clerk in a secondary school has to prepare invitation letters for all the parents.




Microcomputer. It is because it is appropriate for handling office work and less expe
nsive.



(b)

A company has to handle daily transactions of 100 supermarkets.



Minicomputer. It is because it can handle heavy volumes of transactions.


(
c
)

The school library has to install a database so that students can check the status of each book
in
the library.

3



Microcomputer. It is because its capacity is good enough to handle the database in a school
library.


(
d
)

A university has to provide network services for over 10,000 students.



Mainframe computers. It is because over ten thousand students
may use the system at the
same time, a powerful computer is thus required.


5.

When Mr
.

Chan checked the computer system at school, he found out several problems. First, one
of the CPUs did not function. Second, two input devices had broken down. Third, one o
utput
device was damaged. What would happen if these problems are not solved?


If the CPU is not replaced, data and instructions will not be processed. If the input devices are not
repaired, data and instructions will not be able to accept. If the output d
evice is not repaired,
processing results will not be displayed.


Part III
-

Case Study

Jack wanted to buy a computer for personal use; therefore he went to a computer store and sought the
salesman’s advice. Here is the conversation between Jack and the sa
lesman.

Jack:

I want to buy a computer for personal use. Which type of computers should I buy?

Salesman:

Well, I don’t think you need the big ones. The personal computers are good enough.

Jack:

Can I use the personal computer to do my homework, draw pictur
es and check my
monthly expenses?

Salesman:

Of course. Just buying the machine is not enough. You should also buy the programs.


1.

What did the salesman mean when he said “the big ones”?


Mainframe computer or minicomputer


2.

What is the proper name of p
ersonal computers?


Microcomputer



3.

When the salesman told Jack to buy the machine and programs, he referred to two computer
components. What are they?


Hardware and software


4.

Why must Jack buy the programs?


Since a program is a set of instructions
for a computer to perform a specific task, and Jack need to
use the computer to do homework, draw pictures and check his monthly expenses, so he needs
programs.



4

Chapter
2

Usage of Computers in Our Society


Part I
-

Multiple Choice Questions

1.

An embedd
ed system


A.

can be programmed by users.


B.

suggests solutions and makes recommendations to users.


C.

is used in speech and handwriting recognition.


D.

can be used in home appliances.


2.

Robot is most suitable for

B.

fashion design.


B.

assembling cars.


C.

writing.


D.

producing movies.


3.

The transfer of data electronically from one place to another is


A.

teleconference.


B.

expert system.


C.

telecommunications.


D.

telemarketing.


4.

Which of the following statements is/are the advantage(s) of using

multimedia presentation?


I.

It allows users to respond interactively.


II.


It is clear and easy to understand.


III.

It is attractive and interesting.


A.

I

only


B.

I

and
II


C.

II

and
III


D.

I
,
II

and
III


5.

Which of the following statements is fals
e?


A.

Computer assisted learning benefits students only.


B.

Artificial intelligence makes computer systems behave intelligently like humans.


C.

Expert systems is a computer program that makes decisions or solves problem in a specific
field.


D.

Robots c
an be used to do mechanical or repetitive jobs.



5

Part II
-

Questions

Level 1

1.

(a)

What is an embedded system?




An embedded system is a built
-
in computer system for controlling a piece of equipment or
machinery.


(b)

List three machines or devices that

have embedded systems.



Camera, video cassette recorder and photocopier.



(
c
)

Give one advantage and one disadvantage of using embedded systems.



Advantage: It makes machine smarter and more user
-
friendly.




Disadvantage: It is difficult to modify t
he embedded system after the product is finished.



2.


(a)

What is the major difference between robotics and expert systems in terms of their
functions?



Robotics studies the use of computers in controlling robots to do mechanical or repetitive
jobs. Exp
ert systems can make decisions or solve problems in a specific field.


(b)

Name two real life applications of robotics and expert systems.


Robotics:

(i)

To handle explosive bombs.



(ii)

To paint and polish automobiles.


Expert systems:

(i)

To detect engi
ne problem.





(ii)

To search for oil.



3
.


What are the advantages of using computer assisted learning?


Students can use computer assisted learning to review what they have learned in class.
Furthermore, they can use it to evaluate their progress.


Lev
el 2

4.

Hong Kong International Airport has installed a computerized system to monitor the traffic in the
air.


(a)

Identify two functions of the air
-
traffic control system.


i.

To control the ascent and descent of air
-
flights.


ii.

To avoid flight collisions

in the air.


(b)

What equipment is required for the monitoring and control system?



A computer system


5
.


“Multimedia integrates all kinds of information.” Do you agree with this statement? Explain why.


Yes. It is because multimedia is the combination
of text, sound, graphics, images, animation, and
video.



6
.

(a)

Artificial intelligence attempts to simulate human intelligence. Do you think it can replace
6

human intelligence? Explain your answer.


No, artificial intelligence cannot replace human intelli
gence. It is because human beings
have feelings and creativity


(b)

List three applications of artificial intelligence.


Voice recognition


Handwriting recognition



Financial investment plan


Part III
-

Case Study

In the summer vacation, ABC School studen
ts had a chance to visit an automobile manufacturer in
Shenzhen.

The assembly lines were automated, and the production activities could be seen on screen. The
system would alert the supervisor whenever a problem occurred. According to the company
superviso
r, the company was conducting a joint project with a US company. Automobiles would be
produced with built
-
in maps. The map could help drivers find out the shortest way to the destination.
Since it was a new attempt, frequent communications between the two
parties were required.
Fortunately, the computers of the two companies were linked. They could easily exchange
information. Sometimes, they would even have face
-
to
-
face discussion despite their geographical
distance.

1.

In the automated assembly lines, whi
ch equipment should be used to do the screwing?


Robots


2.

How can you tell that the company had installed a monitoring and control system?


In the company, the system could show all the production activities on screen and could alert the
supervisor whene
ver a problem occurred.


3.

Can you explain how the company used the embedded system in its products?


The company had built
-
in maps installed in automobles. These maps could help drivers find out
the shortest way to the destination.


4.

What type of compu
ting technology was used by the company in exchanging information?


Telecommunications



7

Chapter
3

Electronic Data Processing


Part I
-

Multiple Choice Questions

1.

Which of the following is NOT an example of electronic data processing?


A.

Reserve an air
line ticket


B.

Design a picture


C.

Create a mailing list of customers


D.

Prepare payslips of employees


2.

Which of the following statements about data is incorrect?

C.

Data is a collection of raw facts.


B.

Data can be in the form of text, picture and voi
ce.


C.

Data is a collection of files.


D.

Data is the raw materials to produce useful information.


3.

Which of the following systems is used to calculate employee salary?


A.

Mailing system


B.

Payroll system


C.

Point
-
of
-
sale system


D.

Ticketing system


4.

Which of the following is/are example(s) of electronic fund transfer system?


I.

Easy pay system


II.


Ticketing system


III.

Payment by phone


A.

I

only


B.

I

and
II


C.

I

and
III


D.

I
,
II

and
III


5.

Which of the following about point
-
of
-
sale syste
m is true?


A.

I
t is used to transfer money from one account to another.


B.

It is designed for booking tickets.


C.

It is often used in banks.


D.

It is a computerized transaction processing system that records sales transactions.



8

Part II
-

Questions

Le
vel 1

1.

(a)

What is the difference between data and information?




Data is a collection of raw facts. Information is processed data.


(b)

Why is it necessary to convert data into information?



Since data is a collection of raw facts only, it is not orga
nized or structured. To make data
meaningful and useful to users, it is necessary to convert data into information.



2.


(a)

Give three applications of electronic data processing.



Payroll system, point
-
of
-
sale system and mailing list system


(b)

Is it t
rue that using ticketing system to reserve a seat is more accurate than human processing?
Why?


Yes, it is because information of the system is updated immediately, so the same seat will not
be reserved again by other agents.


3
.


(a)

Explain why the point
-
of
-
sale system is useful in retailing business.



It helps the business analyze the sales patterns, stock levels and pricing strategies.


(b)

Name two functions of payroll system.



Payroll data is processed periodically and payslips are printed.


Level 2

5.

A retailer plans to change from manual processing to electronic data processing.

(a)

Give two reasons to justify the change.


The retailer has expanded and the volume of data is increased. Therefore, it is more efficient
to use electronic data processing. In
addition, the company requires more accurate data in
order to maintain its competence.



(b)

Which new system will be required at the check
-
out counter?



Point
-
of
-
sale system


5
.


UA7 runs several cinemas in different regions of Hong Kong. In the past, th
e audience had to visit
the cinema and purchased tickets in person. The management now considers to use electronic data
processing in order to provide better services for the audience.


(a)

Suggest a system that can improve the purchase and ordering proced
ures of UA7.



Ticketing system


(b)

Explain why the system in part
(a)

is used.



Large quantity of data transaction and accurate data is required.


(c)

What are the benefits to the audience of using the system mentioned in part
(a)
.


i.

The audience does

not need to purchase tickets in person.



ii.

The audience can check the availability of seats in different cinemas.

9

Part III
-

Case Study

The Student Union recruits members at the beginning of the school term. Committee members will
visit every class to
distribute and collect membership application forms. The application forms will
be divided into two groups: existing members and new members. The data of new members will be
entered into the computer system. The application forms of existing members will b
e checked for any
change of information. These changes will be entered into the computer system. After the data is
entered, the membership file will be updated. A new member list will be printed.

1.

What is the purpose of collecting application forms?


To
collect data


2.

Why is it necessary to divide the application forms into two groups?


It can avoid entering the same data of existing members into the computer.


3.

If the Student Union wants to send invitation letters to new members, what type of informa
tion
should be created from the membership file?


Mailing labels


4.

Some committee members argue that it is NOT necessary to use the computer system to process
the data. If you were the chairperson, how would you convince them?


The data volume is great.
It would be inefficient to handle the data manually. In addition, it is very
important to maintain accurate membership information.



10

Chapter
4

Input and Output Devices


Part I
-

Multiple Choice Questions

1.

Which of the following is NOT an input device f
or a computer system?


A.

Digitizer


B.

Scanner


C.

Printer


D.

Touch screen


2.

Which of the following output devices is suitable for producing posters?

D.

Liquid crystal display monitor


B.

Graph plotter


C.

Graphics display terminal


D.

Dot
-
matrix printer


3.

Bar code readers are commonly used in


A.

public transportation.


B.

hospitals
.


C.

restaurants.


D.

supermarkets.


4.

Which of the following input devices are suitable for providing services via the Automatic Teller
Machine (ATM)?


I.

Graphic tablet


II.


Touch
-
screen device

III.

Magnetic strip card reader


IV.

Point
-
of
-
sale terminal


A.

I

and

II


B.

II

and
III


C.

II
,

III

and
IV


D.

I
,

II
,
III

and
IV


5.

A scanner can be used to capture the following items except


A.

graphics.


B.

photos.


C.

sound.


D.

ha
ndwriting.



11

Part II
-

Questions

Level 1

1.

(a)

Give two differences between a keyboard and a mouse.


i.

A mouse can directly control the movement of a pointer but a keyboard cannot.

ii.

A mouse is suitable for drawing graphics whereas a keyboard is suitable for
entering
numbers and characters into the computer system.


(b)

State two similarities between a Visual Display Unit (VDU) and a printer.

i.

Both are output devices.

ii.

Both can display information to users.


(c)

List two differences between a Visual Display U
nit (VDU) and a printer.




i.

A VDU displays a soft copy while a printer displays a hard copy.



ii.

A VDU is faster than a printer in displaying output.


2.

State the input and/or output device(s) which should be used in the following situations.



(a)

The
cashier counter in a supermarket.



Input devices
-

Point
-
of
-
sale terminal and bar code reader


(b)

The design of an architectural floor plan for an airport.


Input device
-

A graphics tablet


Output device
-

A graph plotter



(c)

The MTR turnstiles.


Inpu
t device
-

Smart card reader


3
.


What are the advantages of using the sound/speech output device in electronic dictionaries?


Users can listen to the correct pronunciation and make the learning process more interesting.


Level 2

6.

The school secretary needs

to prepare a letter to the students’ parents.

(b)

What are the possible input devices that can be used by the secretary?


A keyboard, a digitizer or a voice input device



(b)

Give a reason for the choices in part
(a)
.


A keyboard works like a typewriter, and

it is suitable for preparing text document.


A digitizer is appropriate for entering Chinese character.



A voice input device allows a user to create a text document by speaking to a microphone.


5
.


A hospital plans to install some inquiry terminals in

the main lobbies so that the public can find
out the hospital services by themselves.


(a)

What are the most appropriate input and output devices for these inquiry terminals?


Input device
-

Touch screen



Output device
-

Visual display unit

12


(b)

What are

the advantages of using the input and output devices in part
(a)
?



A touch screen is an ideal input device for the public. It is because the user can search the
information by touching the screen with a finger. A visual display unit is used because it ca
n
display information at high speed.


(c)

What are the limitations of the devices suggested in part
(a)
?


A touch screen is not suitable for the blind. A visual display unit cannot produce a hard copy.



6
.


The Computer Club has entered the “Keep Hong Kon
g Clean” poster design competition.


(a)

Which input and output devices would be used by the Computer Club?


A graphics tablet, a scanner, a mouse, a keyboard, a digitizer, a visual display unit and a
printer





(b)

The Computer Club wants to include a ph
oto in the poster. Which input device should be
used?



A scanner, a digital camera or a digital video camera


(c)

The Computer Club now wants to add some cartoons into the poster. Which input device
should be used?



A graphics tablet


(d)

What are the ad
vantages of using the input device in part
(c)
?



A graphics tablet is a drawing and painting tool. A user can use it to create and modify
drawings easily.


Part III
-

Case Study

CCC is a local publisher that publishes textbooks for secondary schools. In g
eneral, a textbook is
produced in the following way:

The textbook author gives the publisher the typescript. Then the editor of the publisher reads and
modifies the text. The artist works on the page layout and adds photos and pictures such as cartoons
and

graphics into the text. Finally, a revised hard copy will be printed.

Recently, CCC plans to produce some interactive compact disks for teaching and learning. The first
CD will teach students English pronunciation. Furthermore, popular melodies will be us
ed as
background music. It is hoped that the CD will be useful to both teachers and students.

1.

Which input devices can help the artist who is not good at entering Chinese characters?


Voice input device or digitizer


2.

What are the input devices that th
e artist needs in order to add photos and pictures in the
document?


Scanner, graphics tablet, digital camera or digital video camera



3.

Name two output devices that should be used to produce the textbook? Explain your answer.

13


Monitor and printer. To ma
ke modifications on the soft copy, the editor and artist needs to view
the file on screen. A printer is required when a hard copy is printed.


4.

What type of input and output devices must be used for the production of compact disks that teach
English pron
unciation? Explain why.


Voice input device and sound/speech output device. Voice input device records correct English
pronunciation while sound/speech output device plays the English pronunciation.



14

Chapter
5

Main Memory and Backing Storage


Part I
-

Mu
ltiple Choice Questions

1.

Which of the following media is not used for storage?


A.

CD
-
ROM


B.

Cartridge tape


C.

Hard disk


D.

Scanner


2.

Each memory location in the main memory

E.

must store the same type of data.


B.

has a unique memory address.


C.

prov
ides permanent storage for data.


D.

is a path that is made up of electric wires.


3.

Backing storage is used because


A.

it can store a large amount of data.


B.

it provides faster speed.


C.

data stored in it cannot be changed.


D.

it is smaller in size.


4.

Which of the following expressions is correct?


A.

1 megabyte < 1 terabyte < 1 kilobyte < 1 gigabyte


B.

1 terabyte < 1 gigabyte < 1 megabyte < 1 kilobyte


C.

1 kilobyte < 1 megabyte < 1 gigabyte < 1 terabyte


D.

1 gigabyte < 1 kilobyte < 1 terabyte
< 1 megabyte


5.

Which of the following statements is/are correct?


I.

RAM is nonvolatile.


II.


RAM is used for temporary storage.

IV.

RAM is located inside a computer.


A.

I

only


B.

I

and
II


C.

II

and
III


D.

I
,

II

and
III




15

Part II
-

Questions

Level 1

1.

(a)

List three limitations of the main memory.


iii.

There is not enough space to hold all data and programs.

iv.

When the computer is turned off, all data and programs stored in RAM will be lost.

v.

It is relatively expensive.


(b)

What are the differences between R
AM and ROM?

i.

RAM stores temporary data and instructions while ROM stores permanent data and
instructions.

iii.

Users can read data from RAM or write into it. However, users can read data from ROM
but cannot write into it.

iv.

RAM is volatile while ROM is nonvolat
ile.


2.

(a)

What are the advantages of using CD
-
ROM?

i.

It can store a large volume of data.

ii.

Data stored in CD
-
ROM will not be easily erased.

iii.

The cost is relatively low.


(b)

What are the disadvantages of using CD
-
ROM?


CD
-
ROM stores read
-
only da
ta. Data stored on CD
-
ROM cannot be updated or modified.


3.

Compare CD
-
RW to DVD in terms of the following aspects:


(a)

storage capacity


CD
-
RW stores less data than DVD.


(b)

access method


Both use the direct access method.


Level 2

7.

Working on his computer, T
om comes across the following problems. How could Tom solve these
problems?

(c)

His computer is always out of memory although there is a lot of space on the hard disk.


Tom needs to increase the storage capacity of RAM.



(b)

Tom wants to copy a compressed fil
e for his friend, the compressed file is about 1 megabyte.


Tom could use a floppy disk to store the file for his friend.


5
.


Jack, a computer assistant, needs to back up the School Administration and Management data
every day.


(a)

Why is it necessary t
o back up the data every day?


Data can be recovered if the data is lost accidentally.


(b)

Which storage medium should be used to back up a large amount of data?

16



Magnetic tapes


(c)

List one advantage and one disadvantage of using the storage media in
(
b)
?



Advantage (any one)



i.

Magnetic tapes can store a large amount of data.



ii.

Less expensive



Disadvantage (any one)



i.

The access time is slow since magnetic tapes adopt the sequential access method.



ii.

To access a file, the computer need t
o read all the preceding files.



6
.


Hong Kong Film Production Limited has produced a movie and plans to distribute the movie to
different countries. Therefore, it is necessary to store the movie on a storage medium. The
company has several options: magne
tic tapes, compact disks, hard disks and digital video disks.


(a)

Suggest the most appropriate storage medium. Give reasons.


DVD. DVD has very large storage capacity. A double
-
sided DVD can store 17 gigabytes of
data.


(b)

Give three real life applicatio
ns that use compact disks and digital video disks.



i.

Multimedia encyclopedia



ii.

Computer games

iii.

Movies


Part III
-

Case Study

Jack is a computer laboratory assistant. Every day, he needs to handle many computer
-
related
problems. When he was working in

the laboratory one afternoon, a student came up with a problem.

Student:

Jack, I created a file this morning, but it is lost now.

Jack:

Have you checked your own floppy disk and the hard disk?

Student:

Yes, I have. But it is not there.

Jack:

What did you
do before you logged out?

Student:

I did not follow the normal log out procedures. I just turned off the computer.

Jack:

Did you do one important thing before you turned off the computer?

Student:

Oh, no! I forgot to do it.

1.

If the student really lost th
e file, what would be the most probable reason?


The student forgot to save his file before turned off the computer.


2.

When the student turned off the computer, what would happen to the programs and data stored in
the RAM? Why?


When student turned off t
he computer, all the data and programs stored in the RAM would be lost.
It is because RAM is volatile and is used for temporary storage.


3.

The computer teacher asked Jack to prepare some storage devices and media, as the students
17

would need to save some
multimedia assignments. What should Jack prepare?


CD
-
R and CD
-
R drive. It is because multimedia presentations require large memory size, and
each CD
-
R can store 650 megabytes of data.


4.

Jack needs to back up all the programs and data for the school offi
ce everyday. Which storage
media should Jack use? Why?


Magnetic tapes. It is because magnetic tapes are not expensive, and each tape can store a large
amount of data.



18

Chapter
6

Computer Communication and Networking


Part I
-

Multiple Choice Questions

1
.

The advantage(s) of using network include(s)


I.

sharing computing resources.


II.


efficient communications.

III.

sharing data.

IV.

reducing cost.


A.

I

and
II


B.

I
,

II

and
III


C.

II
,

III

and
IV


D.

I
,

II
,

III

and
IV


2.

The following network is a



F.

wid
e area network.


B.

bus network.


C.

star network.


D.

ring network.


3.

A LAN is


A.

a

geographical network.


B.

a network that connects computers and peripheral devices within the same building.


C.

a device connected to a network.


D.

a large centralize
d computer.


4.

The typical hardware requirements for a network include


A.

telephone lines, modems and communications software.


B.

printers, terminals and computers.


C.

terminals, modems, telephone lines and cables.


D.

e
-
mail, modems and computers.


5.

Which of the following is not a network topology?


I.

RAM is nonvolatile.

19


II.


RAM is used for temporary storage.

V.

RAM is located inside a computer.


A.

Ring network

G.

Bus network

C.

Line network


D.

Star network




20

Part II
-

Questions

Level 1

1.

(a)

What a
re the advantages of networking?


vi.

Sharing data and information

vii.

Sharing computing resources

viii.

Efficient communications


(b)

Name three computer network topologies.

Star network, bus network and ring network


2.

(a)

What are the differences between LAN and WA
N?



A LAN connects a group of computers and peripherals within a relatively small area. A
WAN is a communications network that connects widely dispersed geographic areas.


(b)

Give two examples for LAN and WAN respectively.



LAN
-

The school library and
the computer laboratory in school



WAN
-

Hong Kong Telecom and Hong Kong Education Department


4.

In a computer network, computers are connected by some hardware.


(b)

What will be the hardware requirements if it is a local area network?


Telephone lines, coaxia
l cables and modems


(b)

What will be the hardware requirements if it is a wide area network?


Optical fibres, microwaves and satellites


(
c
)

What is the function of a modem?


A modem can convert data from digital signals into analog signals and vice versa
.


Level 2

8.

ABC company has a medium
-
sized office in a commercial building. To computerize the
administrative work, the company wants to build a computer network to connect all stand
-
alone
computers.

(d)

Why is a computer network better than stand
-
alone compute
rs?


If the computers are connected to a network, network users can communicate efficiently.
They can exchange data and information between computers. Furthermore, computer
resources can be shared.



(b)

Which type of network should be used?


Local area ne
twork


(
c
)

Which topology will be more appropriate if the company needs a stable and reliable
network?


Bus network


5
.


The Hong Kong Computer Society plans to organize a computer exhibition in the Hong Kong
21

Convention and Exhibition Centre. Over 300 com
puter manufacturers and suppliers will be
invited. In addition, famous scholars will deliver speeches in the exhibition.


(a)

What will be the most efficient way to send out the invitations to the computer manufacturers
and suppliers around the world?


Ele
ctronic mail


(b)

Can you suggest a method by which famous scholars can deliver speeches at the exhibition
without coming to Hong Kong?



Teleconferencing enables scholars to deliver speeches in the exhibition without coming to
Hong Kong.



6
.


Company A a
nd Company B have their own company networks. However, these two networks
cannot communicate with each other. Why?


The two networks do not use the same set of communication protocol.


Part III
-

Case Study

ABC Trader is a medium
-
sized trading company. Th
e company is going to use information
technology to streamline its operations. First, customers could place orders on the Internet. Second,
most of the company files could be accessed by the company employees. Third, business
correspondence and memorandum
would be prepared electronically. It is expected that these
measures can reduce one
-
third of the processing time on customer orders.

1.

A customer has bought a new computer with a built
-
in modem. But the customer could not place
an order through the Intern
et. Why?


The customer may not have an Internet account.


2.

What would be the most efficient processing for business correspondence and memorandum?


Electronic mail



3.

How can the company manager access the company computers at home? What device is
requ
ired?


The company manager can access the company computers at home through telephone line. A
modem is always required when data is transmitted over telephone lines.


4.

ABC Trader hires 10 employees who share the same office. The employees used to save
in
formation on stand
-
alone computers. How could the employees share information efficiently
and effectively? List the advantages of your recommendations.


The company should set up a local area network that the employees can share information
efficiently and

effectively. As a result, the employees can share valuable resources such as
company files and information, some hardware and software.


22

Chapter
7

Files and Databases


Part I
-

Multiple Choice Questions

1.

Which of the following gives the correct order o
f data hierarchy from the bottom to the top?


A.

File, record, field, character


B.

Field, file, character, record


C.

Record, character, file, field


D.

Character, field, record, file


3.

A database management system

H.

refers to the procedures used to acquire,

access and maintain data.


B.

is a software that allows users to create and maintain a database.


C.

is a person who manages the database.


D.

is the procedures used to keep data up
-
to
-
date.


3.

Sequential files are suitable for


I.

ATM system


II.


Month
ly billing system

III.

Payroll system

IV.

Library inquiry system.


A.

I

and
II


B.

II

and
III


C.

II
,

III

and
IV


D.

I
,

II
,

III

and
IV


4.

Which of the following is not the Structured Query Language command?


A.

SELECT


B.

UPDATE


C.

CREATE


D.

ACCESS


5.

Which of the following is NOT a means of file protection and security?


A.

Backup files

I.

Encrypted data

J.

Write
-
protected disks or tapes

D.

High performance computer




23

Part II
-

Questions

Level 1

1.

(a)

What is the main difference between a direct access fil
e and a sequential file?




In a direct access file, the location of a particular record is usually determined by the data
value of its key field. In a sequential file, records are stored physically one after another.


(b)

Give two advantages of using dire
ct access files rather than sequential files.



i.

Files can be updated easily.



ii.

It is possible to store a record in its original location after amendment.


2.

(a)

State the difference between master files and transaction files.



A master file stores

relatively permanent information. A transaction file stores relatively
transient data.


(b)

The student file stores personal particulars of students. The enrollment file stores personal
particulars of new students. Explain why it is necessary to merge the
se two files to create a
new file.



When the student file and the enrollment file is merged, data in the enrollment file will be
updated to the master file. As a result, the student file will include up
-
to
-
date student
information.


3.

(a)

What is the fun
ction of a database?



A database collects, classifies, stores and displays data systematically. It integrates
interrelated data.


(b)

Give three reasons to support the statement “Databases are better than traditional files in file
organization”.



i.

Data

redundancy is reduced.



ii.

Data integrity can be maintained.



iii.

Data can be shared between users.


Level 2

9.

Name the file operation in the following situations.

(e)

Mary opens her homework file that she created last week.


Retrieving



(b)

Jack enters
the singer’s name to find out his favorite CD.


Searching



(
c
)

The data operator changes a customer’s address because the customer has moved recently.


Updating


(
d
)

The data operator changes the customer address because the flat number is incorrect.


Am
ending


24

5
.


HKLine is a company that provides Internet services. Customers can use the Internet services to
send e
-
mail and transfer files. In addition, customers can read daily news on their computers.
However, each customer must key in two sets of data b
efore accessing the company services.


(a)

What are these two sets of data?


User’s account number and password


(b)

Why is it necessary for each customer to key in these two sets of data?



The company needs the user’s account number and password in order

to identify the
authorized user.


(c)

A customer wants to send a confidential file by e
-
mail. Suggest a method to prevent the file
from unauthorized reading.



The customer can encrypt the file data before sending it by e
-
mail.


6.

The telephone billing syst
em bills its customers at the end of each month. The master file stores
customer name, customer address and customer telephone number.


(a)

Can the company use the customer name to identify a specific customer? Explain.



No, it is because some customers
may have the same name.


(b)

Name ONE or more data which should be included in order to identify a specific customer.



Customer account number


(c)

The transaction file stores the telephone expenses of each month. Which data should be
included in the tran
saction file?



Customer account number, monthly expense, amount due


Part III
-

Case Study

The Central Library has set up a multimedia center where citizens can enjoy CDs and VCDs. To
borrow a VCD, the citizen needs to tell the librarian the name of the m
ovie, the director or the
actor/actress. But the fastest way to search a movie is to enter the ISBN for that movie.

1.

What are the advantages and disadvantages to search VCDs by the name of actor/actress?


Advantage:

Citizens can easily tell the libraria
n the name of the actor or actress.


Disadvantage:

An actor or actress may act in more than one movie. If the movie is searched by the
name of the actor or actress, a list of movies will be returned to the user. As a result,
the searching process is prolo
nged.


2.

The library database can store the complete names of the movie and the actor/actress regardless
of the actual data size. Can you explain the reason?


The database consists of variable
-
length records. In a variable length record, the number of fi
elds
or the field size varies according to the actual data.



3.

Why is it that the fastest way to search a movie is to enter the ISBN?


ISBN is the key field of the database. A key field is a field that identify a record uniquely.

25


4.

The library is going

to set up a computerized inquiry system so that citizens can search the movies
by themselves. Which type of access method is preferred? Why?


Direct Access. Direct access is appropriate for public inquiry because of two major advantages:
First, it is fast

to access a record because it needs to search the record only one time. Second, it is
flexible since the computer can access a record without affecting other records.



26

Chapter
8

Data Management


Part I
-

Multiple Choice Questions

1.

Which of the followi
ng methods can be used to detect the error:



LEE HOI MING is mistyped as LEE HO1 MING


A.

Presence check


B.

Reasonable check


C.

Range check


D.

Type check


2.

Which of the following applications is/are example(s) of using check digits?


I.

Telephone num
ber


II.

Hong Kong identity card number


III.

Bank account number


IV.

Student seat number


A.

I and II


B.

II

and
III


C.

II
,
III
and
IV


D.

I
,
II
,
III

and
IV


3.

Data verification is used to


A.

ensure the accuracy of data.


B.

detect input errors.


C.

prevent data omission.


D.

make sure the input data is within the correct range.


4.

Which of the following is not a data validation method?


A.

Error check


B.

Check digit


C.

Control total


D.

Type check


5.

By using weighted modulo 11 check method, find

the check digit of 246.


A.

1


B.

3


C.

5


D.

7



27


28

Part II
-

Questions

Level 1

1.

(a)

Explain why it is important to maintain data accuracy and completeness.




It is because incorrect data input will give rise to incorrect output. The incorrect output m
ay
lead to incorrect decisions.


(b)

List three possible factors that cause data errors.



Careless mistakes, human faults and computer program problems


2.

(a)

What is the difference between data verification and data validation?



Data verification is th
e process of checking whether data has been correctly transcribed.
Data validation is the process of checking whether the data input meets the predefined
criteria.


(b)

Name two methods of data verification.



Double entry and parallel entry


3.

(a)

Name t
hree methods, other than presence check, to validate data.



Range check, type check and check digit


(b)

What is the purpose of presence check?



It prevents data omission.


Level 2

4.

The design of the SFC Bank credit card is shown below:






(a)

Suggest
a validation method used to check the name field. Briefly explain your answer.
Type
check. It is because the name field should include alphabets only.



(b)

Which validation method should be used to check the date field? Why?



Range check. It is because t
he day should be between 1 and 31 while the month should be
between 1 and 12.


(
c
)

The accuracy of an account number is very important. How can the bank ensure that the
account numbers are entered correctly?



The bank should add a check digit to each acc
ount number. If any number is entered
incorrectly, the account number will be rejected.


5.

ABC school has decided to add a check digit (rightmost digit) to the student number. The
algorithm to calculate the check digit is given below:

29



Step 1:
From left to
right, multiply the

1st digit by 9,




2nd digit by 8,




3rd digit by 7,




4th digit by 6,




5th digit by 5,




6th digit by 4,




7th digit by 3,




8th digit by 2.



Step 2:
Add up the products.



Step 3:
Divide the sum by 11 and find the remainder.



Step 4:
Subtract the remainder from 11 to get the check digit.


(a)

Work out the check digit for the student number 34102895.




(b)

A check digit is assigned to the student number as 123456789. Check whether the last digit is
a valid check digit.

30




The la
st digit of the student number is a valid check digit.


6.

Being the database administrator in a company, you need to ensure that data on the source
documents is correctly and completely entered into the computer system.


(a)

If you have two data operators in

your team, how can you verify the data input is correct?



The same batch of source documents should be entered independently by two operators. The
computer system will print out an error report if two identical records are different. Then
check the error

report and make necessary corrections.


(b)

The sales manager sends you application forms in batches. What will be your best evidence
to prove that the complete data of all the application forms has been entered?



The control total report which includes
record count will be the best evidence. If the record
count is equal to the number of application forms received, it means that all the customer
application forms are entered.


Part III
-

Case Study

An election office is preparing for the coming Legislativ
e Council Election. Personal data from
eligible voters must first be collected. The data is then entered into the computer system. The
computer then prints a letter to each individual registered voter informing him/her regional
constituency.

The election o
fficer has found out some problems.

1.

Some fields in the forms are not entered. Try to state a data validation method that can detect this
problem.


Presence check


31

2.

In the date
-
of
-
birth field, 31/06/1973 is entered. Try to state a data validation metho
d that can
detect this problem.


Range check



3.

“0” is misread as “6” and “n” is misinterpreted as “u”. State a method that can detect this error.


Double entry or parallel entry


4.

Some registration forms are not processed. State a method that can dete
ct this problem.


Control total



32

Chapter
9

Representation of Data


Part I
-

Multiple Choice Questions

1.

Which of the following is a hexadecimal number?


A.

2001HCF


B.

B4C5D6E


C.

37CS20E


D.

ANSWER


2.

The decimal number of 110101
2

is


A.

106.


B.

58.


C.

53.


D.

28.


3.

Which type of error occurred when
7
22

is written as 3.142?


A.

Truncation error


B.

Overflow error


C.

Rounding error


D.

Underflow error


4.

The problem of sign
-
and
-
magnitude representation is that


A.

it requires s
imple circuitry for performing arithmetic.


B.

the magnitude and the sign of a number are represented separately.


C.

it cannot be used to represent a floating point number.


D.

zero can be represented in two different ways.


5.

The range of a 9
-
bit fixed
point representation in two’s complement is

A.


256 to 255.


B.


256 to 256.


C.


255 to 255.


D.


255 to 256.




33

Part II
-

Questions

Level 1

1.

(a)

Convert 15
10

to a binary number.





(b)

Convert ABC
16

to a binary number.



(c)

Convert 567
8

to a hexadecimal numb
er.




2.

Compute the following arithmetical expressions with the 8
-
bit two’s complement representation.


(a)

12 + 21




(b)

33


40




(
c
)


52


28





34

3.

(a)

Express the following integers in sign
-
and
-
magnitude representation and two’s complement
representa
tion using 6
-
bit pattern.

Integer

Sign
-
and
-
magnitude
representation

Two’s complement
representation

21

010101

010101




1㄰111

㄰㄰〱

(b)

Write down the bit pattern of the string “ASC”.





A : 1000001



S : 1010011



C : 1000011


Level 2

7.

Rewrite the foll
owing numbers in bit
-
patterns.

(a)

1999
10




(b)

246
8






(
c
)

AB
16





8.

A register in the computer uses 7
-
bit to represent integers.

35



(a)

Write down the following integers in the sign
-
and
-
magnitude representation.

(i)

61
10






(ii)


29
10






(c)

What is the large
st integer that can be represented in the register?


+ 63
10

(c)

What is the smallest integer that can be represented in the register?



64
10


Part III
-

Case Study

Below is a tic
-
tac
-
toe gameboard, and each number represents a unique position on the board.

1

2

3

4

5

6

7

8

9

Rules of the game are as follows:

I.

There are only two players in this game.

II.

The one who gets three X’s or O’s in any single row, column or diagonal is the winner.

III.

Each move is represented in a 4
-
bit binary number.

IV.

The f
inal results will be displayed in 6 bits.


(i)

Bit 0 to bit 3 represent each move.



1 = 0001



2 = 0010



3 = 0011



4 = 0100

36



5 = 0101



6 = 0110



7 = 0111



8 = 1000



9 = 1001


(ii)

Bit 4 and bit 5 are used to represent the possible results:



00 = t
he result is unknown



01 = the first player wins the game



10 = the second player wins the game



11 = the result is a tie

Bit 5

Bit 4

Bit 3

Bit 2

Bit 1

Bit 0








1.

Why are four bits required to represent all the possible moves on the gameboard?


T
here are nine possible moves on the board. If three bits are used, only eight possible moves can
be represented (2
3

= 8). Therefore, four bits are required (2
4

= 16).


2.

David and Amy are playing the game. David moves first, and their moves are as follows:


David

Amy

First Move

0011

1001

Second Move

0101

0111

Third Move

0010


(a)

It is Amy’s move now. Suggest the move that will enable Amy to win the gam.

1000

(b)

Write down the final results in 6 bits.


101000


3.

David and Amy take the following moves:

David

Amy

0
101

0110

0011

0111


(a)

Suggest the move(s) that David should take to win the game.

0001 or 0010


(b)

Write down the move(s) that David should take to get a tie.

1000 or 1001


37

Chapter
10

Operating Modes


Part I
-

Multiple Choice Questions

1.

Which of th
e following are the advantages of batch processing?


I.

The computer resources can be utilized more efficiently.


II.


It can reduce operation costs.

III.

It provides updated information.


A.

I

and
II


B.

I

and
III


C.

II

and
III


D.

I
,

II
,

and
III



2.

Wh
ich of the following is true about real
-
time processing?


A.

Users cannot get the latest information.


B.

It can be an on
-
line or off
-
line system.


C.

Users can get instant response from the computer system.


D.

It provides a high degree of security.


3.

M
ulti
-
tasking


A.

allows users to run multiple operating systems at the same time.


B.

allows users to access several applications at the same time.


C.

reduces the computer throughput.


D.

allows several users to run the same programs at the same time.


4.

Which of the following is a real life example of batch processing?


A.

Marking HKCEE examination papers


B.

Processing ATM fund transfer


C.

Playing computer games


D.

Booking tennis courts


5.

“Users communicate with the computer system directly and cont
inually. They can modify data
and receive feedback from the system for guidance and verification.” This describes the


A.

batch processing.


B.

interactive processing.


C.

multi
-
user processing.


D.

off
-
line processing.




38

Part II
-

Questions

Level 1

1.

(
a)

Write down three features of on
-
line processing.



i.

The input/output devices are controlled by the computer system.



ii.

The input/output devices are physically connected to the computer system.



iii.

Data can be directly entered into the computer s
ystem.

(d)

Under what conditions should on
-
line and off
-
line processing be used?



On
-
line processing should be used when updated information and fast response from the
computer system are required. Off
-
line processing should be used when data is collected in
groups before data input.


2.

(a)

What is the difference between real
-
time processing and batch processing?



In real
-
time processing, data is processed as soon as it is entered into the computer system.
The system always reflects the most updated data. Ba
tch processing cannot reflect the most
updated data. It is because data is accumulated in batches before it is processed by the
computer system.

(b)

Give two advantages of using real
-
time processing over batch processing.



i.

There is no time lag between
data collection and data processing.


ii.

The user can always get the fastest and most updated information from the computer
system.




3.

(a)

What is the characteristic of using multi
-
tasking in data processing?



A computer system can work on more than o
ne task at one time.

(c)

“Interactive processing requires a certain extent of user participation. Therefore, interactive
processing must be operated by the multi
-
user mode.” Is this statement correct? Give
reasons.



No, the interactive processing can serve on
e user at a time.


Level 2

9.

Below is a list of data processing procedures:


i.

The master file is updated.


ii.

The data is entered into the computer system.


iii.

The application forms are filled in by students.


iv.

The application forms are collected by
class teachers.


v.

New membership lists and cards are printed.


vi.

The application forms are classified and compiled into batches.

(b)

Write down the correct order of the above procedures.


iii


楶i


癩v


楩i





v


(b)

Name the operating mode that should
be used to process the above procedures. Briefly
39

explain your answer.



Batch processing. It is because the application forms have to be collected and classified
before they can be entered into the computer system. Most likely, the application forms are
ha
ndled in batches over a period of time. Therefore, batch processing should be used.


10.

State the most appropriate operating mode for each of the following situations:

(b)

Peace Cinema provides advance booking service on the Internet. To order movie tickets,
cus
tomers need to select the film, seat, date and time.

Interactive processing

(d)

Multiple users access the homepage of the Hong Kong Government at the same time.


Multi
-
user system


(c)

Heathplus Hospital has installed a computer system that monitors the patien
t’s health
conditions during a surgical operation.


Real
-
time processing


6.

The MTR maintains computer records for train arrivals and departures.


(a)

Describe the most suitable operating mode to process these records.



Real
-
time processing. It is becaus
e the company needs the most updated information in order
to monitor the traffic.


(b)

Would you suggest using batch processing? Explain why.



No, it is because batch processing cannot reflect the latest information to its users, and the
whole file must b
e updated even if only one change is required. If batch processing is used,
current traffic data will not be available. As a result, the company cannot give immediate
response when train accidents and delays occur.


Part III
-

Case Study

Hong Kong Freight
is an airfreight company which handles 4 000 tons of cargoes each day. The
company takes customer orders by phone. After an order is confirmed, the information will be
updated to the freight
-
scheduling system. The company bills the customers after the carg
oes are
delivered.

1.

Which processing method should be used for taking orders? Why?


Real
-
time processing should be used since the company needs to know the latest information
before taking an order.


4.

Which processing method should be used for handling cu
stomer bills? What are the advantages of
this method?


Batch processing. First, billing data can be checked before it is entered into the computer system.
Second, large amount of transactions can be processed when the computer system is not so busy.
Third,

the operation cost for batch processing is less expensive than real
-
time processing.

40


5.

If the company needs to check the customer’s record before accepting an order, which operating
mode should be used? Explain.

Multi
-
tasking. Multi
-
tasking means that a co
mputer system can work on more than one task at one
time. It is the appropriate operating mode because the company needs to check customer’s records
and take orders simultaneously.


4.

Hong Kong Freight requires that order
-
taking employees should be able t
o access the
freight
-
schedule system simultaneously. Suggest an appropriate operating mode in order to
achieve this company objective.


Multi
-
user processing. In multi
-
user processing, different users can access the same computer
system simultaneously.


41

Chapter
11

Operating a Microcomputer System


Part I
-

Multiple Choice Questions

1.

Which of the following is used to organize and group computer files?


A.

Path


B.

Menu


C.

Directory


D.

Window



2.

Which of the following is not a file operation?


A.

Savi
ng files


B.

Classifying files


C.

Removing files


D.

Retrieving files


3.

The file Exercise1 is stored in the Homework directory. Homework directory is in a directory
named Physics of drive C. Which is the correct path to locate the file Exercise1?


A.

Ph
ysics
\
C:
\
Homework
\
Exercise1


B.

Homework
\
Exercise1
\
C:
\
Physics


C.

C:
\
Exercise1
\
Homework
\
Physics


D.

C:
\
Physics
\
Homework
\
Exercise1


4.

Which of the following is not a Chinese input method?


A.

Tsang
-
jei input method


B.

Stroke number input method


C.

Handwr
iting input method


D.

User
-
friendly input method


5.

Which of the following describes the above diagram?




A.

File system


B.

Pull
-
down menu


C.

A window

42


D.

Cascading menu


43

Part II
-

Questions

Level 1

1.

(a)

What is the function of the filing system in a
computer?



Computer files can be stored systematically.

(e)

Briefly describe the information that a user can find in a directory.



File location, file type, file size and file amendment date


2.

(a)

In the Window environment, the user may click either an ico
n or select a menu option to
access a command. What is the difference between an icon and a menu?



A menu is a list of options in text format while an icon is a graphical symbol.

(b)

Name the file operations of the following situations:


(i)

Write data to a c
ompact disk.




Saving files


(ii)

Remove a file from a floppy disk.




Deleting files


(iii)
Duplicate all records in directory A to directory C.




Copying files


(iv)

Locate and read a file from the hard disk.




Loading files




3.

(a)

Name the most us
er
-
friendly Chinese character input method.



Handwriting input method

(d)

To enter a Chinese character, a user has two methods:


Method 1: Use a pen
-
like stylus and a pen tablet.


Method 2: Use a keyboard to enter codes.


(i)

Give one advantage of method 1 ov
er method 2.




Method 1 is very convenient to users who do not know Chinese input methods.


(ii)

Give one advantage of method 2 over method 1.



Method 2 can get Chinese characters directly and quickly because it does not have to
analyze the handwriting b
efore getting codes.


Level 2

4.

(a)

Draw the structure of the following filing system.



(i)

The root directory is drive D.



(ii)

Three sub
-
directories exist in the root directory. The sub
-
directories are Home, School
and Game.



(iii)
There are two sub
-
directories, CS and Chinese, in School directory.



(iv)

Directory Game stores two files:

QuakeII

and
Cyberx
.



(v)

Directory CS contains two files:
Hw1

and

Hw2
.

44



(vi)

Directory Chinese also contains two files:
Hw3

and
Hw4
.





(b)

Write down the path to

get the following files:



(i)

The file
Hw1




D:
\
School
\
CS
\
Hw1



(ii)

The file

Cyberx




D:
\
Game
\
Cyberx


5.

Describe the steps to perform the following tasks in the Window environment.


(a)

Use the icon to open a file in the hard disk.



Step 1: Select t
he correct directory where the file locates.



Step 2: Double click the icon of the file to open it.


(b)

Use the menu to print the current file.



Step 1: Click the File menu from the menu bar.



Step 2: Select Print from the pull down menu.



Step 3: Sel
ect the printing option in the dialog box.



Step 4: Click the OK button to print.


6.

The following table shows the Chinese character codes for some Chinese character components:

Chinese Character Code

Chinese Character Component

A



B



C



D



E



F



G





(a)

With reference to the above table, suggest the most possible Chinese characters which
matches the following codes.

(i)

AB




45

(ii)

CCC








(iii)
FG








(iv)

DGG







(b)

Write down the number of strokes for the following

Chinese characters.



(i)






9



(ii)






17



(iii)





8


Part III
-

Case Study

Tommy has installed his first personal computer, and he can run an application by clicking a graphical
symbol. He will use his computer to create some artwork and to do
his assignments such as English,
Chinese and Computer Studies. He will also use the computer to create some artwork.

1.

How should Tommy create his computer file system so that he can easily find an assignment on
specific subjects?


Tommy should create a d
irectory for his assignment. In the directory, he should create a
sub
-
directory for each subject.


6.

Tommy has to create some artwork for his text assignments. How can Tommy view both his
assignment file and the artwork file at the same time?


Tommy can open

two windows on the screen, one for the assignment and one for the artwork.


7.

What is the correct computer term for graphical symbols in a computer? What are the advantages
of using graphical symbols?

Icon. Icons are easy to understand and provide quick acc
ess to programs or files.


4.

Name three methods that Tommy can use to input Chinese characters.


Tsang
-
jei input method, handwriting input method, and stroke number input method


46

Chapter
12

Word Processor and Spreadsheet


Part I
-

Multiple Choice Questi
ons

1.

A word processor is not suitable for


A.

creating letters, memos, reports and contracts.


B.

checking the grammar and spelling of a document.


C.

generating tables.


D.

compiling programs.


2.

How many cells are there in the range K2:N7 in a spreads
heet?


A.

24


B.

18


C.

15


D.

10


3.

Which of the following chart cannot be created in a spreadsheet?


A.

Column chart


B.

Volume chart


C.

Radar chart



D.

3
-
D pie chart


4.

The formula



=SUM(C2:C4, D5:D8)


is stored in cell E1. What will be the formula

in cell E2 if the contents in cell E1 is copied to E2?


A.

=SUM(C2:C4, D5:D8)


B.

=SUM(D2:D4, E5:E8)


C.

=SUM(C3:C5, D6:D9)


D.

=SUM(D3:D5, E6:E9)


5.

Which of the following is/are formatting feature(s) in word

processing?


I.

Page break


II.

Margins


III
.

Underline


IV.

Search


A.

I

only


B.

I

and
II


C.

I
,
II

and
III


D.

II
,
III

and
IV

47

P
art II
-

Questions

Level 1

1.


(a)

What are the advantages of using a word processor over a typewriter?



Users can easily create, edit and format a document. In addition
, users can save documents
for future use without typing again.


(b)

Write down three types of document that can be prepared by a word processor.



Letters, newsletters and reports


2.


(a)

List three different ways of aligning a paragraph.



Align left, a
lign right and center


(b)

List five editing features of a word processor.



Insert, delete, cut, copy and paste


3.


(a)

What is the difference between absolute address and relative address?



Absolute address refers to the cell address in a formula that
does not change when the
formula is copied to another cell. It has the form $C$R. Relative address refers to the cell
address in a formula that will be adjusted automatically when the formula is copied from one
cell to another. It has the form CR.


(b)

Und
er what situation(s) should absolute address used?



If someone wants to copy a formula but does not want to change the cell address in it, one
should use the absolute address in the formula.


Level 2



4.

The figure shows the cover of a computer dictionar
y created by Microsoft Word.






(a)

Name the possible format features used on the cover.



The possible format features used on the cover are:



i.

underline (the company name)



ii.

bold (the title)



iii.

center (the title and subtitle)



iv.

align ri
ght (the author name)

48


(b)

State the commands that can move the author name from the lower right hand corner to the
cent
er

just below

A

Comprehensive Tool for School

.



Cut and paste


5.

The following is a worksheet that records the revenue of a student
bookstore.


A

B

C

D

E

F

1

Student Bookstore






2

Income Statement






3


Quarter 1

Quarter 2

Quarter 3

Quarter 4

Total

4

Sales

13000

14000

30000

15000


5

Cost

10000

11000

20000

12000


6

Profit

3000

3000

10000

3000


7








(a)