9 Integrated Use of a Software Suite
ICT Focus
Object Linking and Embedding (OLE) technology is used.
It can minimize the file size of the web contents so as to reduce the downloading
time.
Concept Map
1. A
2. D
3. B
4. C
Concept Checker
1. T
2. F
3. F
4. T
5. F
Multiple Choice Questions
1. B
2. B
3. C
4. B
5. C
6. B
7. A
8. B
9. A
10. D
Short Questions
1. (a) BMP / JPG / PNG / WMF / TIF (any two × 1)
(b) • Save the image file in the format that Microsoft PowerPoint can read
such as BMP and JPG. (1)
• Insert the image as an object by OLE technology. (1)
© Pearson Education Asia Limited 2009 NSS ICT Compulsory Textbook Answers
2. (a) Microsoft Word / Microsoft Excel / Microsoft Access / Visual FoxPro (any
three × 1)
(b) Microsoft Excel (1)
(c) • Open the text file in Microsoft Excel. In the import stage, divide each
text string into two columns so that the students’ names and addresses
are stored as text in the two columns respectively. (1)
• Save the spreadsheet as Microsoft Excel file format for mail merge. (1)
3. (a) Web browser, word processor, image editing software, spreadsheet, web
authoring software and presentation software (each one × 1)
(b) • Information collection from the Web using web browser (0.5)
• Text editing using word processor (0.5)
• Image editing using image editing software (0.5)
• Data manipulation using spreadsheet (0.5)
• Group presentation using presentation software (0.5)
• Web page design using web authoring software (0.5)
(The flowchart should contain the above six steps.)
4. (a) •The destination file size is smaller when using object linking. (1)
• If the object in the source file is updated, the object in the destination file
is updated as well. It is not necessary to update both objects. (1)
(b) Example of object linking: A PowerPoint presentation contains a vector
graphics created by CorelDraw. (1)
Example of object embedding: A web page embeds a Flash animation. (1)
5. (a) No, the Word file can locate the source object even when the word file itself
is moved to another location. (1)
(b) Yes, the word file cannot locate the source object any longer when the
object is moved to other location. (1)
(c) Yes, the word file cannot locate the source object any longer when the name
of the object file has been changed. (1)
Long Questions
1. (a) Word processor (1) and database software (1)
(b) Database software. (1) It can be used to store and organize the records of the
mobile phone service plan, transactions, phone inventory and scanned
images. (3) (Note that Microsoft Excel is not accepted since it is unable to
organize scanned images efficiently.)
© Pearson Education Asia Limited 2009 NSS ICT Compulsory Textbook Answers
(c) Web browser (1) and web authoring software (1)
(d) It does not work. (1) It is because web page does not support object linking.
(1) Moreover, the object link is broken (1) when the web page is uploaded
to the web server. (1)
2. (a) Spreadsheet (e.g. Microsoft Excel), (1) and an image editor (e.g.
PhotoImpact, for editing scanned company logo and any digital images) (1)
(b) (i) The text file is firstly imported into a spreadsheet (1) with which the
names, positions and mobile phone numbers are stored in separate
columns. (1) The designer should also scan and edit the company logo
(and company name if necessary) with an image editor such as
Photoshop or PhotoImpact. (1) Finally, he can print out the card using
a colour inkjet printer. (1)
(ii) Mail merge of the name list in the spreadsheet. (2)
(c) Advantage:
• More flexible in design
• More features of graphical tools for designing the name cards
(any one × 2)
Disadvantage:
• The mail merge function cannot be used.
• The designer has to take much longer time to input the information of
card holders one by one manually.
(any one × 2)
© Pearson Education Asia Limited 2009 NSS ICT Compulsory Textbook Answers
