2 - Tang Hin



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)

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.)

(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)

................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download