Mathematics Cookies

2. Mathematics Cookies 2010 Term 2 SabbaticalHwa Chong Institution

3. What you will be doing in this course…

4. Outline of course

5. End Product

6. End Product

7. 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

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

9. What you will learn

10. Why Excel?

11. What can be done with Excel?

12. Do-It-Together Lab demonstration 1

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

14. 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?

15. 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)

16. 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.

17. 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?

18. 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?

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

20. 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?

21. My Sample

22. 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

23. 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

24. 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”.

25. 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.

26. 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?

27. 10am-11am Break time!

28. Lab Demonstration 2

29. 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

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

31. 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”)

32. 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

33. Reflections End of Day 1