U8 software integration for teaching and learning
Sponsored Links
This presentation is the property of its rightful owner.
1 / 28

U8. Software Integration for Teaching and Learning PowerPoint PPT Presentation


  • 63 Views
  • Uploaded on
  • Presentation posted in: General

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.

Download Presentation

U8. Software Integration for Teaching and Learning

An Image/Link below is provided (as is) to download presentation

Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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.

  • Integrating software for developing applications taking strengths of individual software system.


8.2Software for Integration

  • Word specializes in text editing and layout.

  • Excel specializes in numbers, calculations and charts.

  • PowerPoint specializes in creating presentation.

  • Access specializes in database management.


8.3Methods for Software Integration

8.3.1Mail Merge

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.


Step 1: Main document

Use Word to create the following document.


Step 2: Data source file

Use Excel to create the following spreadsheet.


Step 3: Fill in the fields

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.


Step 4 : Merge

Step4.1:Choose Tools, Mail Merge.

Step4.2:Choose Merge


Step4.3:Choose Merge

  • [The merged document will be a new document.]


Exercise 1

Design a report card using mail merge. The data file is marks.xls. The first card should be like this:


8.3.2Data sharing using OLE

  • OLE – Object Linking and Embedding

  • With OLE, applications can share data dynamically.

  • OLE is used with Copy and Paste.


Copy and Paste without OLE

Eg.Copy an Excel spreadsheet to a Word document without OLE.

  • In Excel spreadsheet, highlight the range and click Copy.


  • In Word, click Paste.

  • Change the Excel spreadsheet and note the change in Word.

    Change / Not ?


100

90

80

Chin

70

60

50

Eng

40

30

Math

20

10

0

LO CHO

LI PING

YAN LAM

LAI MING

CHAN TAI MAN

CHOI CHI MING

CHAN SIU MING

LEE TAI KEUNG

LAM TIN KWONG

CHEUNG LAI HEUNG

Exercise 2

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.


Copy and Paste with OLE

Eg.Copy an Excel spreadsheet to a Word document with OLE.

  • In Excel spreadsheet, highlight the range and click Copy.

  • In Word, click Edit, Paste special…


  • Select Paste link:

  • Change the Excel spreadsheet and note the change in Word.

    Change / Not ?


Exercise 3

Repeat exercise 2 by with OLE.

Change the marks in spreadsheet and note if there are any changes in Powerpoint.


8.3.3 Integration by using hyperlink

Eg.Invoke an Excel spreadsheet from a PowerPoint presentation.

  • In PowerPoint, type the text (e.g. Link to marks)that you use to setup the link.

  • Highlight the text.


  • Choose Insert, Hyperlink…


Click here to choose the file.

  • Choose the Excel spreadsheet.


  • Choose OK.

  • Slide show the presentation and click the link to see the effect.

    REMARKS:

    *To edit a hyperlink, repeat the above steps.

    *Use relative path as far as possible.


Exercise 4

Setup two hyperlinks in PowerPoint. One links to the Word document main.doc and the other links to the Excel spreadsheet data.xls.


8.3.4 Integration by using macros

  • Use the supplied macro to produce an educational integrated applications.

  • The macro is developed by CDI. You may download by the following link.

    http://cd.ed.gov.hk/it/Chi/cindex3.htm

  • Change the content of the question bank and see the effect. (Password : cdi2001)


It has the following features:

  • An application developed in presentation software to deliver test questions to learners;

  • Contents of test questions will be retrieved from a data table in a word-processed document;

  • Performance of learners will be collected by a spreadsheet application; and

  • Analyzed results from the spreadsheet application will be used as feedback to learner in the presentation application.


  • Login