Timeline

• Thursday 5/17/07 – Research
  • Homework: Draw initial designs and bring in materials
• Wednesday 5/23/07 – Propellers/Fans started
• Friday 5/25/07 – Propellers/Fans complete
• Wednesday 5/30/07 – Initial wiring complete
• Friday 6/1/07 – Body complete (I need to see hovercrafts assembled)
• Tuesday 6/5/07 – Problem solving
• Thursday 6/7/07 – All hovercrafts are complete
• Monday 6/11/07 – Hovercrafts will be tested, lab notebooks are due, and typed paper are due
  

• Problem 1
• Problem 2
• Problem 3
• Problem 4
• Problem 5
• Problem 6
• Problem 7
• Problem 8
• Problem 9
• Problem 10
• Problem 11
• Problem 12
• Problem 13
• Problem 14
• Problem 15
• Problem 16
• Problem 17
• Problem 18
• Problem 19
• Problem 20
• Problem 21
• Problem 22
• Problem 23
• Problem 24
• Problem 25
• Problem 26

Animations with Mathematica

• Make an animated gif file using Mathematica
  • It must be original
  • Be creative
• Email to evans@scienceandmathacademy.com
  • filename: “yourname.gif”
  • Subject line of email: “Your name  - Animation”

Objective: Make an interactive graphing utility through the use of VBA programming in Excel.

Directions:

• Inputs
  • An arbitrary function (examples: “5*x + 3”, “4*sin(x)”, “5*x^2+3*x+4”)
  • xmin
  • xmax
  • ymin (If a number is entered it should use the number, if it is blank Excel should automatically adjust this.)
  • ymax (If a number is entered it should use the number, if it is blank Excel should automatically adjust this.)
• Output
  • Graph the function using an xyscatterplot
  • The graph must update if any changes are made to any of the inputs
• Other things to include
  • Make a comment in the macro that you are the author.
  • In a cell in the spreadsheet, write a short description of what the spreadsheet does and that you are the author.
• Email
  • The file must to be named grapherYourlastname.xls (no spaces)
  • The subject must be “Grapher Yourlastname”
  • Email it to evans@scienceandmathacademy.com
  • Mr. Evans must receive the Excel file before class starts on November 16, 2006.
  • You should cc yourself a copy
• Extra features
  • Make the number of points that are graphed an input.
  • Make the type of graph an option (line-connected xyscatterplot or curve-connected xyscatterplot)
  • If an equation is entered incorrectly a warning is given.

Grading Rubric

• Correctly emailed it to Mr. Evans and used the correct subject name and file name. (Note: If you do not follow the email instructions, Mr. Evans may not receive your assignment or will not see it when downloading it from my email.) 2 points
• When you enter the function the y values of the function are calculated. 15 points
• The xmin and xmax automatically adjust the x-axis properly. 5 points
• The ymin and ymax automatically adjust the y-axis properly. 10 points
• Appropriate use of comments are used in the code. 3 points
• Overall functioning of the project. 5 points

Excel: Goal Seek and Macros

• Create a spreadsheet that will solve a cubic.
• Things we will use…
• …name
• …goal seek
• …macro
• Save the file as lastnameGoal.xls (do NOT include any spaces!!)
• Email the file to evans@scienceandmathacademy.com.
• Make the subject Your Name - Goal

Excel: 3D-Topographic Map

• Download a topographic map from topozone.com
  • Put a table(grid) over the topo map in Word and find the elevation for the center of each square.
  • Grids must be square. Minimum of 30 columns.
  • Take the data from Word and make a 3D surface plot of it in Excel.
• Things to have in Excel…
  • 3D Surface Plot
  • Heading of for the location of the map
  • The topo map needs to be in the excel file (below the 3D model)
• Email to evans@scienceandmathacademy.com
  • Subject: Last Name – Topo
  • Excel Filename: lastnameTopo.xls (no spaces)

Objective:
Design and engineer a bridge using 1/8 inch x 1/8 inch balsa wood to hold as much mass as possible over a 31 cm span.

Design:
•           You will draw the design of you bridge on a piece of graph paper.
•           Each square on the graph paper grid represents 1 cm in the actual bridge.
•           You must draw a side profile and a drawing from the top of the bridge.

Construction:
•           The overall width of the bridge may not exceed 11.4 cm.
•           The overall length of the bridge may not exceed 40 cm.
•           The span will be set at be exactly 31 cm.
•           The bridge shall allow a 5.2 cm wide by 15.4 cm long by 2.0 cm thick board to pass through it over the roadbed. In the center there must be a 1.6 cm hole to allow the bolt from the testing apparatus to come through.
•           The bridge shall have no structures below the abutments that support the bridge.
•           The bridge shall be constructed entirely of the 10 1/8-inch x 1/8-inch balsa wood strips provided to you.
•           You will be provided 1 ounce of glue that you may use.
•           Wood joints may be notched if desired.

Testing:
•           Mr. Evans’ will test your bridges in a consistent manner to determine which bridge holds the most.
•           The mass will be placed at the center.

Resources:
•           Use the web for research on bridge designs.
•           On site: http://www.jhu.edu/virtlab/bridge/truss.htm you can design a truss bridge and it will show what type of forces the bridge will undergo.