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

U8. Software Integration for Teaching and Learning PowerPoint PPT Presentation


  • 54 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

U8. Software Integration for Teaching and Learning

Presented by: Law Hing Man

(13 Dec 2001)


8 1 overview of software integration

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 2 software for integration

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 3 methods for software integration

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

Step 1: Main document

Use Word to create the following document.


Step 2 data source file

Step 2: Data source file

Use Excel to create the following spreadsheet.


Step 3 fill in the fields

Step 3: Fill in the fields

Step3.1:In Word, open the main document.

Step3.2:Choose Tools, Mail Merge.


U8 software integration for teaching and learning

Step3.3:Choose Create, Form Letters


U8 software integration for teaching and learning

Step3.4:Choose Active Window.

Step3.5:Choose Get Data, Open Data Source


U8 software integration for teaching and learning

Step3.6:Select the Excel file.


U8 software integration for teaching and learning

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

Step 4 : Merge

Step4.1:Choose Tools, Mail Merge.

Step4.2:Choose Merge


U8 software integration for teaching and learning

Step4.3:Choose Merge

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


Exercise 1

Exercise 1

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


8 3 2 data sharing using ole

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

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.


U8 software integration for teaching and learning

  • In Word, click Paste.

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

    Change / Not ?


Exercise 2

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

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…


U8 software integration for teaching and learning

  • Select Paste link:

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

    Change / Not ?


Exercise 3

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

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.


U8 software integration for teaching and learning

  • Choose Insert, Hyperlink…


U8 software integration for teaching and learning

Click here to choose the file.

  • Choose the Excel spreadsheet.


U8 software integration for teaching and learning

  • 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

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

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

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