1 / 33

Mathematics Cookies

Mathematics Cookies. 2010 Term 2 Sabbatical Hwa Chong Institution. What you will be doing in this course…. Outline of course. End Product. End Product. A few pointers…. Thumbdrives cannot be used in the computer lab

ferris
Download Presentation

Mathematics Cookies

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. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Mathematics Cookies 2010 Term 2 SabbaticalHwa Chong Institution

  2. What you will be doing in this course…

  3. Outline of course

  4. End Product

  5. End Product

  6. A few pointers… • Thumbdrives cannot be used in the computer lab • Please save your work and upload it in the Internet (e.g. your email, Google Docs or Acrobat.com) • GeoGebra (you may need to use it later) has a new free web version at http://www.geogebra.org/webstart/geogebra.html

  7. MS Excel 2010 Term 2 Sabbatical – Mathematics Cookies Hwa Chong Institution

  8. What you will learn

  9. Why Excel?

  10. What can be done with Excel?

  11. Do-It-Together Lab demonstration 1

  12. Lab Demonstration 1 Think about how to go about doing this excel applet… What components does it have?

  13. Step 1 • Set up the display and resize cells • Think: • How to prevent cells from being selected after typing the plus sign “+”? • How to resize cells quickly and effectively?

  14. Step 2 • Create a scrollbar for the values m and c • View> Toolbars > Forms> Scrollbar • Draw under m and c (i.e. cells B1 and D1)

  15. Step 3 • Set values and link the scrollbars to the cells • Scrollbar [Right-click] > Format Control > Control • Set Min=0, Max=10 and Increment=1 • Cell link to cell you right-clicked so that the value will appear in the cell. Do the same for the other scrollbar.

  16. Step 4a • Set up table of values • Set range of x from -10 to 10 • Think: • Is there a faster method to set the x values?

  17. Step 4b • For the values of y, it should be y=mx+c • For cell B6, it will be $B$1*A6 + $E$1 • ($B$1 is m, A6 in this case is x and c is E1) • Think: • What is the difference between naming “$B$1” and “B1”? • Is there a faster method to set the y values?

  18. Step 5 • Draw the graph using Chart Wizard • Insert> Chart > XY Scatter>2ndSubtype > Next > Select Data Range > Next > Finish

  19. Questions to Ponder… • Think of these questions when you improve on it for lab exercise 1… • The y-axis range keeps changing when you scroll the m values. How can I fix that? • Improve the design of the applet. • Remove the gridlines. • Hide the range of x and y values. • How can I set negative values for m and c? • How to add in rectangles with text which will appear only on hovering the mouse above?

  20. My Sample

  21. Overview: • Set up display • Create a scrollbar for the values m and c: View > Toolbars > Forms > Scrollbar (For Excel 2007: Developer > Insert) • Set values and link the scrollbars to the cells: Scrollbar [Right-click] > Format Control > Control • Set up table of values: • X: Set range of x from -10 to 10 • Y (=mx+c): e.g. Cell B6: $B$1*A6 + $E$1 • Draw the graph: Insert > Chart > XY Scatter > 2nd Subtype > Next > Select Data Range > Next > Finish(For Excel 2007: Insert > Scatter > 2nd Subtype > Next > Select Data Range > Next > Finish) • Text: How does the graph of the function y = Ax + B compare with the graph of the function y = x as we change the values of the variables A and B? Improve on your Excel Applet: 8.30am – 10am Lab Exercise 1

  22. Step 1 - Tips • Prevent cells from being selected after typing the plus sign “+” • Press “Enter” after typing into the cell • Resize cells quickly and effectively • Double click between the typed cell column and the one to the right when you see the resize cursor

  23. Step 4a - Tips • Is there a faster method to set the x values? • Instead of keying into individual cells, you can key in “-10”, “-9”, “-8” and drag the “+” autofill cursor when hovered over the bottom-right corner of the cell. • Excel will auto fill the cells according to the pattern. • Stop dragging once you reach “10”.

  24. Step 4b - Tips • What is the difference between naming “$B$1” and “B1”? • If you name the cell as (e.g.) “=B1”, it may autofill “=B2”, “=B3” and so on. • Typing “$B$1” will not change its value when auto-filling.

  25. AOT • Fix x & y axis: Right click on axis > Range • Insert new x=y line: Format Chart > New Series • Set negative values for m & c • Additional: Rectangles with text which will appear only on hovering the mouse above: comments • How to change colour of scrollbar?

  26. 10am-11am Break time!

  27. Lab Demonstration 2

  28. What is this applet? • Allows user to solve simultaneous equations • Requirements: • User can input values for A, B, C, D, E and F. (Scrollbars not needed) • Applet can display the types of lines (parallel, intersecting, same line etc…) • If intersecting lines, applet can display the point of intersection

  29. Questions to Ponder: How to input the formulas for types of lines and points of intersection?

  30. Questions to Ponder: How to input the formulas for types of lines and points of intersection? Use the IF loop: =IF (A = B, “value if true”, “value if false”)

  31. Overview: • Set up display • Ax+By1=C • Dx+Ey2=F • Set x values (-20 to 20) • Set y values • y1=C/B-Ax/B • y2=F/E-Dx/E • Determine intersecting, parallel or same lines • Test for parallel lines: • A=D • Test for same lines: • y1=y2 • If not parallel lines, they are intersecting lines. • Calculate intersecting point • Solve the 2 SLE for x & y • Point’s coordinates are x & y values (think about how to do) Do it yourself! Lab Exercise 2

  32. Reflections End of Day 1

More Related