U8. Software Integration for Teaching and Learning. Presented by: Law Hing Man (13 Dec 2001). 8.1Overview of Software Integration. Applications developed by integrating various software commonly available.
U8. Software Integration for Teaching and Learning
Presented by: Law Hing Man
(13 Dec 2001)
Word – Main document
The document that contains the contents that are the same for all merged documents.
Excel – Data source file
The spreadsheet that contains the contents that are different for all merged documents.
Use Word to create the following document.
Use Excel to create the following spreadsheet.
Step3.1:In Word, open the main document.
Step3.2:Choose Tools, Mail Merge.
Step3.3:Choose Create, Form Letters
Step3.4:Choose Active Window.
Step3.5:Choose Get Data, Open Data Source
Step3.6:Select the Excel file.
Step3.7:Edit the main document.
Step3.8:Fill in the fields with the help of <Insert Merge Field> button in the button bar.
Step4.1:Choose Tools, Mail Merge.
Design a report card using mail merge. The data file is marks.xls. The first card should be like this:
Eg.Copy an Excel spreadsheet to a Word document without OLE.
Change / Not ?
CHAN TAI MAN
CHOI CHI MING
CHAN SIU MING
LEE TAI KEUNG
LAM TIN KWONG
CHEUNG LAI HEUNG
Copy an Excel bar chart to a PowerPoint without OLE. The chart is based on the file marks.xls.
Set animation effects for the bars.
Eg.Copy an Excel spreadsheet to a Word document with OLE.
Change / Not ?
Repeat exercise 2 by with OLE.
Change the marks in spreadsheet and note if there are any changes in Powerpoint.
Eg.Invoke an Excel spreadsheet from a PowerPoint presentation.
Click here to choose the file.
*To edit a hyperlink, repeat the above steps.
*Use relative path as far as possible.
Setup two hyperlinks in PowerPoint. One links to the Word document main.doc and the other links to the Excel spreadsheet data.xls.