H.K.T.A. Tang Hin Memorial Secondary School

basicgratisMechanics

Nov 5, 2013 (3 years and 7 months ago)

109 views


H.K.T.A. Tang Hin Memorial Secondary School

S.4 Information and Communication Technology

Chapter 5


Revision Exercise


Name: _
Ching

Chung Man Suan
_______


Class: __
4E
____ (
19

)


Grade: _________


A.

Multiple Choice Questions

1

2

3

4

5

6

A

B

D

C

B

B







7

8

9

10



D

D

D

B




B.

Short Questions

1.

(a)

Database program is developed to automate the workflow of toy sample testing
and store the sample information into the database.

(b)

A

financial monthly report can be created by a word
processor

or a spreadsheet
instead of the printed document. The electronic document can be stored in a
secondary storage device.

(c)

T
he advantage of using office automation are increasing productivity, b
etter data
management, having better communication and reducing company expenses.

T
he advantage of the office automation solution for part (a)(i) and (a)(ii)

is better
data management.


2.

(a)

H
e could use word processor, spreadsheet, database software,
presentation software
and communication software.

(b)

Word processor: Microsoft Word

Spreadsheet: Microsoft Excel

Database software: Microsoft Access

Presentation software: Microsoft PowerPoint

Communication software: Microsoft Outlook


3.

(a)
(i)

W
eb cam
and microphone.

(a)(ii)

M
onitor and speakers.

(a)(iii)

R
outer and
Hub

(b)
(i)

C
ommunication software and MSN

(
b
)
(ii)

D
igitized printed
document

with OCR.
E
.g.: OmniPage


4.


D
ata application: it includes editing documents,
producing

reports and documents and
modifying digital images.

D
ata storage: office records, documents and various kinds of multimedia materials
such as scanned forms, voice mails and videos recorded during video conferencing
devices can be used to store the data su
ch as hard disk

Data Exchange: I t can be carried out through electronic communication channels such
as e
-
mail, voice mail and fax.

Data management: the primary objective of office
automation

is to manage data from
all aspects of a business including inven
tory records, financial plans.


5.

(a)

Data
exchange

(b)

R
educing company expenses

and inform all the employee quickly.



C.

Long Questions

1.

(a)

H
e should set up a monitoring server that has monitoring software and communication
software installed. When the
monitoring software detects any errors or problem us of
any server, it would forward the problem to the administrator.

(b)

T
he advantage of using office automation :

Better Communication

with a computer network, many digital communication
channels such
as e
-
mail. These powerful communication channels can complement
traditional communication methods and they are more effective for transferring digital
files and easier to work.

R
educing company expenses
-
the operating cost of office automation software is l
ow.
I
t
also saves
office

space by storing document digitally.

(c)

M
onitoring software.
I
t monitors a network for threats from the outside, a network
monitoring system monitors the network for problems caused by overloaded or
crashed servers, network conne
ctions or other devices.

C
ommunication software and telephone line. It monitors managing address books,
appointment calendars and e
-
mail.


2.

(a)

D
atabase software and spreadsheet.

(b)

D
atabase software.
T
he data in database software is stored in the form
of records with
a specific structure. Database software provides tools and functions for efficient data
access and generating reports.so it can record and print the sales receipts, produce
daily and monthly sales reports and keep track of the inventory sta
tus.

(c)

I
mage editing software and video editin
g soft
ware.

(d)

C
omputer A: keyboard, mouse, printer, hard disk

C
omputer B: keyboard, mouse, hard disk, scanner, a photo printer, DVD writer.

Software: communication software

H
ardware:
network interface
card, router/switch, broadband modem.