Week 4

• independent and dependent variables
• more linear functions
• slope and y-intercept
• point-slope form of a linear equation
• unit analysis
• Calculating with spreadsheets. This week we will be continuing working with Excel. The spreadsheet we will be working with today includes a variety of features:
  • performing repitious calculations through the use of formulas
  • graphing
  • cell formatting
  • slider bars to dynamically change cell values
• integer arithmetic

Due at the beginning of class - Homework from week 3:
Record the price of 3 of the different gasolines sold at one station close to where you live. (Generally this will be 87 octane, 89 octane, and 92 octane.) You will create a graph that represents each of the three prices of gasoline for different amounts of gasoline purchased. Create these 3 graphs on the same coordinate axes. Be sure to include the following:

1. Either use graph paper or a graphing program such as the Graphit activity or Excel.
2. The horizontal axis should be labeled and represent the number of gallons of gas.
3. The vertical axis should be labeled and represent the amount in dollars spend for the corresponding gallons of gas purchased.

1. Calculate the slope for each line.
2. What is the equation for each line?
3. What does the slope represent for each line?

• Lab Handout, Week 4
• Slope and Speed Spreadsheet
• Slope Slider
• Arithmetic Quiz
• Tips on using Excel to implement the features named above
• Excel Tutorial: A more indepth explanation of how to implement a variety of Excel features
• Mid-term Assignment: Self-Assessment writing assignment
• Rubric used to grade the mid-term

• Notecard:
  • Write a real-world problem that involves multiplying a number between 0 and 1 and a whole number. Solve this problem.
  • Vote, what should we learn next? probability, statistics, compound interest, multiplying and dividing by powers of 10 and scientific notation.
• Review, what have we learned so far?
• Lab 4, week 4

• Mid-term: Self-Assessment Due 6th week of class, April 16.
• Come up with your own example of a linear function in a real world context. Answer the following:
  1. Describe the situation.
  2. What are the independent and dependent variables?
  3. List five points on your function in a table.
  4. Using graph paper, graph those five data points.
  5. What does the slope represent in your function
  6. What does the y-intercept represent in your function?