The method of combining PowerPoint with Excel

In daily teaching activities, most of the teachers use PowerPoint to make courseware. PowerPoint because of simple operation, beautiful interface, no need for professional basis, has been a broad line of teachers love, but its shortcomings are also obvious, it is the lack of interactivity, dynamic. In fact, PowerPoint can be used to make interactive courseware, the following author to do a sinusoidal y=asinx as an example to do an introduction:

1. Run PowerPoint XP, insert a blank slide in the appropriate location of the courseware, click insert → object, and select Microsoft Excel worksheet. After clicking [OK], the menu bar and toolbar are automatically replaced with Excel format.

2. Click outside the object area, the menu bar, toolbars are automatically changed to PowerPoint format, click the object area, there are eight handles, then you can adjust the size, position. Double-click the object area to enter the table edit state, enter " -24" in cell C1, enter " -23" in D1, and enter "-22" in E1. Select them, move your mouse to the lower-right corner, and pull to the right after the small cross cursor until ay.

3. Enter "=c1 PI ()/12" in C2, and select it, drag right to Ay as before.

4. Enter "X=" in the B2, enter "y=" in the B3, right align. Enter 5 in the B5, and enter "=B5/10" in B4, because the next control format is at least 1, and the step is reduced to 0.1 after dividing by 10, making the change of the image curve smoother and more natural. In C3, enter "= $B $ SIN (C2)" and select it, drag right to Ay as before.

5. Select C2 to AY3 this area, click "Insert → chart", select "xy scatter chart → numerous points smooth line scatter plot".

6. Click "Next → next", enter "sine curve" in "chart title", enter X in the value (x) axis (A), enter Y in the value (Y) axis (V), and then click "Next → complete".

7. Click the menu "view → toolbar → form" To open the form tool bar. Click the scroll bar button in the Form toolbar when the chart area is selected, and then press the left mouse button in the chart area to drag a scroll bar. Next, right-click the scroll bar and select the Format Control command from the menu. When you enter "sheet1! $B $" in the "Cell link" column in the pop-up window, click OK to exit, and if you drag the scroll bar, the data in the B5 cell changes and the image changes.

8. At this point the chart is the default format, and there are many subkeys in the chart Drop-down menu for us to modify the chart format. The axis changes as you drag the slider, which does not well reflect the relationship between the function Y=sinx and the Y=asinx image, so you must set the following:

Set the scale of the axis: Select the Y axis, right-click, and execute the format Axis command in the pop-up menu. In the pop-up window, select the Tick label to set the minimum, maximum, and major units of the value (Y) axis scale to 4, 4, and 1.). If you drag the slider again, the axis will no longer change. To set the values for the horizontal coordinate, you can set the minimum, maximum, and major unit units to 7, 7, and 1, respectively.

Now we modify the plot area format.

9. Click a blank cell outside the plot area to save the file so that when you play the slide, the mouse moves to the slider when you move it to a hand, which can be pulled right and left.

Click the worksheet area and click on the menu "slide show → Custom Animation", in the right task pane, point to add effect → object action → open, select effect Options in Object 1, click timing → trigger, select start effect when clicking the following object, and then click OK.

10. Click on "Slide show → slide", "Change the Way" in the "click Mouse" before the tick removed. Now show a look at the effect, when the mouse moved to the worksheet area into a hand shape, click the left button, the worksheet is opened in Excel, the mouse moved to the slider to become a hand-shaped, you can operate.