1 / 199

Mathematics Cookies

Mathematics Cookies. 2010 Term 3 Sabbatical Hwa Chong Institution. What you will be doing in this course…. Outline of course More detailed schedule at sabbatical website. End Product. Theme for this sabbatical. Festivals & Cultures around the World. End Product (Website) Link is broken.

tallys
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 2010Term 3 SabbaticalHwa Chong Institution

  2. What you will be doing in this course…

  3. Outline of courseMore detailed schedule at sabbatical website

  4. End Product

  5. Theme for this sabbatical Festivals & Cultures around the World

  6. End Product (Website)Link is broken.

  7. End Product (PowerPoint)

  8. WikiSpaces website • Sabbatical Website Link: http://hsmathcookies.wiki.hci.edu.sg/ • Please take 15 minutes to form into your groups and create a WikiSpaces site. • Take this time to know each other as well  • Include details of your groupmates (Name, Class and Register No.) • Invite us (see sabbatical website) • This site will serve as your presentation tool this Friday • It also serves as the submission site for your documents • Therefore, it is important that you add us as viewers

  9. WikiSpaces website • In each page, upload your files (for individual exercises all must submit) and give a brief description of the exercise’s requirements. • Name your files as: • [Group No.]_[Name]_[Class & Register No.]_[Name of work according to the names on left] • Invite us as viewers: • weexianbin@yahoo.com.sg • hoekang@gmail.com • Create the following pages: • Excel Individual Exercise 1 • Excel Individual Exercise 2 • Excel Group Project 1 • Excel Group Project 2 • GC Individual Exercise 1 • No need to submit files • GC Individual Exercise 2 • GC Group Exercise 1 • GC Group Exercise 2 • GC Group Project Design • Reflections

  10. MS Excel More than just spreadsheets

  11. What you will learn

  12. Why Excel?

  13. Do-It-Together Lab demonstration 1

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

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

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

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

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

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

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

  21. 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? • Create another line y=x for comparison with the first line • How can I set negative values for m and c? • Improve the design of the applet. • Remove the gridlines. • Hide the range of x and y values. • How to add in rectangles with text which will appear only on hovering the mouse above?

  22. Name your files in this format: [Group No.]_[Name]_[Class & Register No.]_Excel Individual Exercise 1 Improve on your Excel Applet Excel individual Exercise 1

  23. 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 Excel individual Exercise 1

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

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

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

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

  28. Break time!

  29. Before we start Exercise 2 Ex. 1 Submission & Presentation Rubrics

  30. Lab Demonstration 2

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

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

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

  34. 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 • (Press F4 to change cell name to dollar sign) • You will need 2 tables (2 equations) Do it yourself! Excel individual Exercise 2

  35. Determine intersecting, parallel or same lines • Calculate intersecting point • Solve the 2 SLE for x & y • Point’s coordinates are x & y values (remember to specify no. of sol. for parallel & same lines) • If you are done, think about how to test for perpendicular lines (will not go through though) Do it yourself! Excel individual Exercise 2

  36. Name your files in this format: [Group No.]_[Name]_[Class & Register No.]_Excel Individual Exercise 2 Do it yourself! Excel individual Exercise 2

  37. Determine intersecting, parallel or same lines • Test for parallel lines: A=D • Test for same lines: c1=c2 • If not parallel lines, they are intersecting lines. • Calculate intersecting point • Solve the 2 SLE for x & y • X=(FB-CE)/(DB-AE) or vice versa • Y=(C-Ax)/B • Point’s coordinates are x & y values (remember to specify no. of sol. for parallel & same lines) • If you are done, think about how to test for perpendicular lines (will not go through though) Do it yourself! Excel individual Exercise 2

  38. Do it yourself! Excel individual Exercise 2

  39. Let m1 & m2 be gradients and c1 & c2 be y-intercepts of their respective lines =IF(AND(m1=m2,c1=c2),“Same Lines”, IF(m1=m2,”Parallel Lines”,IF (m1*m2=-1, “Perpendicular Lines”, “Intersecting Lines”)) Do it yourself! Excel individual Exercise 2

  40. Reflections End of Day 1

  41. Group Applet Project Design Day 2

  42. What’s in store • (Re)visiting Excel tricks & shortcuts • Group Projects 1 & 2 • GeoGebra • All have submitted Individual Ex. 2. Thanks for your coorperation.

  43. Recap • Create a scrollbar • View > Toolbars > Forms > Scrollbar • For Excel 2007 & 2010: Start Logo > Options > Customise > Developer > Controls > Insert (Excel 2007 & 2010 forms are Developer Forms, not the toolbar control forms) • Set values and link scrollbars to cells • Right-click on scrollbar > Format Control > Control • Draw a graph • Insert > Chart > XY Scatter > [Choose options] • For Excel 2010: Insert > [Choose Graph] (Then edit the graph by right-clicking on components)

  44. Recap • Autofill • Drag the plus-sign cursor at the bottom-right corner of the cell • Resize columns and rows of worksheet • Double-click on the double-arrowed line cursor between 2 rows or columns • Comments • Insert > Comment • For Excel 2007 & 2010: Review > New Comment

  45. Recap • The IF Statement • =IF (argument, “statement if true”, “statement if false”) • IF Loop (red part is if 1st argument is true): • =IF(1st argument, IF(2nd argument, “statement if 2nd argument is true”, “statement if 2nd argument is false”), “statement if 1st argument is false) • Change cell name to dollar-sign cell name by pressing [F4]

  46. Extras: excel shortcuts • Delete any unnecessary blank worksheets • Merge rows & columns • For Excel 2007 & 2010: Home > Alignment > Merge & Center • View full screen • View > Full Screen (no keyboard shortcut) • Split Excel workbook view into two (works in Word also) • Grab the rectangle on the top-right corner between the formula bar & column labels, on top of the scroll bar on the right • Drag it down to see 2 views • Can be used, e.g. to keep the first row (header) always intact on top • Superscript/subscript: Right click on text > Format Cells > Effects

  47. Extras: excel shortcuts • Lock workbooks, worksheets & cells • Lock cells • Right click on cell > Format Cell • For Excel 2007 & 2010: Home > Cells > Format > Format Cell (or Lock Cell) • Protect sheets • Right-click on sheet tab > Protect Sheet • For Excel 2007 & 2010: Review > Changes > Protect Sheet • Protect entire Excel workbook • For Excel 2007 & 2010: Review > Changes > Protect Workbook • Remember to unlock cells to be typed in & scrollbars to be used by user

  48. Extras: excel shortcuts • Conditional Formatting • Format > Conditional Formatting • For Excel 2007 & 2010: Home > Style > Conditional Formatting • Limited functionality in Excel 2003 • Self-Study: (A new function) • You will only know in Group Project 2

  49. Group Work 1 • Create an excel applet about… Linear Law

  50. Linear Law • Expressing the y-axis & x-axis such that you get a linear graph, which is easier to interpret • i.e. such that • instead of y = mx + c, it is Y = mX + c; • the y axis is Y, which can contain x and/or y; • the X axis can also contain x and/or y; • m is the gradient and c is the y intercept, and m and c CANNOT contain variables x or y.

More Related