Documents
Resources
Learning Center
Upload
Plans & pricing Sign in
Sign Out
Your Federal Quarterly Tax Payments are due April 15th Get Help Now >>

alg1 mp2 2012 Proportion Inequality Absolute Value Project

VIEWS: 11 PAGES: 11

									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

								
To top