Object Linking and Embedding (OLE) Technology Is Used

9Integrated 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

Concept Checker

Multiple Choice Questions

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)

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. Inthe import stage, divide each text stringinto two columns so that the students’names and addresses are stored as textin the two columns respectively. (1)

•Save the spreadsheet as Microsoft Excelfile 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 sourceobject even when the word file itself ismoved 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 theobject 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 inventoryand scanned images. (3) (Note that Microsoft Excel is not accepted since it is unable to organize scanned images efficiently.)

(c)Web browser (1) and web authoring software (1)

(d)It does not work. (1) It isbecause web page does not support object linking. (1) Moreover, the object link is broken (1) when the web page is uploaded to theweb server. (1)

2.(a)Spreadsheet (e.g. Microsoft Excel), (1) and an image editor (e.g. PhotoImpact, for editing scanned company logo and any digitalimages) (1)

(b)(i)The text file is firstly imported into a spreadsheet (1)with which the names, positions and mobile phonenumbers are stored in separate columns. (1) Thedesigner should also scan and edit the company logo(and company name if necessary) with an image editorsuch as Photoshop or PhotoImpact. (1) Finally, he canprint out the card using a colour inkjet printer. (1)

(ii)Mail merge of the namelist 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)