# alg1 mp2 2012 Proportion Inequality Absolute Value Project

Document Sample

```					INTRODUCTION FUNCTIONS

Create the correct cell references to check voting eligibility
To solve this, you must use the =if( function
Inputs                                         Output
Bill                              Is he old enough to vote?

Create the correct cell references to see who is older
To solve this, you must an =if( function and the =abs( function
Inputs                                       Outputs
Colleen                                 Who is older?
Angie                                   How much older?

Create the correct cell references to calculate order price for Petsmart deal.
To solve this, you must us an =if(
Inputs                                           Output
Amt Purchased                           Order Cost

Create a list of everyone's name in one column without retypeing
To solve this, you must us the =concatenate( function
First         Middle        Last                          Full Name
Mark             B         Davis
Dan             T.       Thomas
Billy            B       Thornton
Thomas             M         Gillan
Jordan            p         Harris
Gerry            V       Mckendry
This project is 5% of your grade and is due on Wednesday 12/14
You will be given 3 days (2 this week & 1 next week) to work on this project.
The project is out of 10 points
Each correctly completed spreadsheet earns you that many points
Once you've completed 10 points you are done

Worksheet    Points                    Objective
Pro1         1      Test a proportion
Pro2         3      Solve a proprtion
Perc1         2      Find the original price
Perc2         3      Create a tip calculator
Ineql1        2      Test an inquality
Ineql2        3      Solve an inequality
Abs1         1      Find the absolute value of a number
Abs2         3      Find the solution to absolute value equation
Abs3         4      Find the solution to absolute value inequality
Create the correct cell references to test a proportion's equivalency
Inputs                                               Output
a                                 Is the proportion true?
b
c
d
Create the correct cell references to solve a proportion when given a, b & c
Inputs                             Output
a                                   d
b
c
Create the correct cell references to solve for the original cost
Inputs                                     Outputs
Markdown Price                                      Original
Markdown %
Create the correct cell references to solve for tip, bill and price per person
Inputs                                         Outputs
Bill Amount                                 Tip Amount
Tip %                                    Total Bill
People Eating                             Price Per Person
Create the correct cell references to test x in an inequality given y < mx + b
Inputs                                 Output
y         2               Is x a solution?
m         3
b         9
x
Create the correct cell references to solve for x in an inequality given y > mx + b
Inputs                               Output
y                                    x
m
b
Create the correct cell references to find the two answers to the equation abs(x) = b
Inputs                                  Output
b                                      x1
x2
Create the correct cell references to solve the equation abs(x + a) = b
Inputs                                 Output
a                                     x1
b                                     x2
Create the correct cell references to solve the inequality abs(x + a) > b
Inputs                                    Output
a                                        x1
b                                        x2
Is it a Union

Create the correct cell references to solve the inequality abs(x + a) < b
Inputs                                    Output
a                                        x1
b                                        x2
Is it a Union

```
DOCUMENT INFO
Shared By:
Categories:
Tags:
Stats:
 views: 3 posted: 12/17/2011 language: English pages: 11