Tuesday 7 February 2012

PowerPoint and the combination of Excel production methods

In the daily teaching activities, teachers often use PowerPoint produce courseware. PowerPoint for the operation is simple, interface aesthetics, no professional basis, obtained the general a teacher's love, its disadvantages is obvious, and that is the lack of interactive and dynamic works. In fact, use PowerPoint can make interactive courseware, below the author to do sine curve Y = ASinX as an example to do a is introduced:



1. Run PowerPoint XP, insert a proper place in the courseware blank slides, click "insert-object", choose the "Microsoft Excel work table". Click [sure] after, menu bar, tool bar to be automatic into Excel format.



2. In the object regions outside the click, menu bar, tool bar to be automatic with PowerPoint format, this time the click object regions, appear eight control points, then you can adjust the size, location. Then double-click the object regions into form edit state, in the cell C1 type "24 ", D1 type "23 ", E1 type "22 ". Select them, take the mouse pointer to the bottom right hand corner, to appear small cross after the cursor to the right to pull, until AY.



3. In C2 type "= C1 PI () / 12", and select it, like the previous to the right as drag AY.



4. In the B2 type "X =", in the B3 type "Y", the right alignment. In the B5 input 5, in B4 type "= B5/10", this is because of the steps behind control format is at least 1, divided by 10 to its long after step down to 0.1, making the change of image curve more smooth, natural. In the C3 type "= $B $4 SIN (C2)", and select it, like the previous to the right as drag AY.



5. Selected to AY3 this area C2, click "insert to chart", select "XY scatterplot chart countless stronghold and smooth line scatterplot chart".



6. Click on the "next to the next step", "in the chart title" type "sine curve", "in the numerical (X) axis (A)" input X, in "numerical (Y) axis (V) input Y, finally click on the" next to finish ".



7. Click the menu "view-toolbars to form", "form" article tools will be open. In the chart area is selected under the prerequisite of the click "form" tools of the article [the scroll bar] button, and then in the chart area press the mouse left key pulled out a "scroll bar". The next right click scroll bars, in the menu, select "Settings control format" the order, in the popup window "cell link" column type "sheet1! $$5 B", click [sure] out and if drag scroll bars, B5 data in the cell will change, the image would change accordingly.



8. At this point in the chart is the default format, in "chart" drop-down menu has many items for us to modify chart format. Drag the slider and coordinate transformation also follow change, this can not very well reflect function Y = Sinx and Y = ASinx the relationship between the images, so must do the following Settings:



Setting an scale: selected the y axis, click on the button, implementation of the popup menu "coordinate transformation format" the order, the pop-up window in the choice in the "scale" label, will "numerical (y) axis calibration" the "minimum value", "maximum", "main scale unit" were set to "4 "and" 4 "and" 1 ". If this time to drag the slider, coordinate transformation is no longer a change. Similarly set the value of the abscissa denotes, can become its "minimum value", "maximum", "main scale unit" were set to "7", "7" and "1".



Now we drawing area to modify the format.



9. In a drawing at the outside of the blank cells, save file, so that behind play slides, the mouse pointer to the slider will become the hand form, can be directly or so pulling.



Click on the work table area, click on the menu "slide show-from the definition animation", on the right task pane midpoint "add effect-object to open action," in "object 1" select "effect option", and click "timing-trigger", select "click on the following object start effect", and finally click [sure].



10. Click "slide show-slide switch", "in way of" in "click the mouse" in front of the ticker removed. Now playing to once see effect, when the mouse pointer to work table areas into hand form, order the left key, work table, then in Excel opened, the mouse moves to slide block into hand form, can operate.