November 30th-December 3rd

posted Nov 30, 2018, 7:17 AM by Mike Costello   [ updated Dec 3, 2018, 7:33 AM ]
LT: Students will learn and understand how to use the google sheets formulas to add, subtract and multiply. 
                        *Formulas Addition,              Subtraction,                Multiplication
                            =SUM(Cell:Cell)            =Budget-Total cell            =Cell1*Cell2

Typing Web - 20 min

-Advanced Lessons!!!


FINISH BBQ Grocery List Assignment.

Happy birthday! You are turning 15 and your parents said you can have a birthday BBQ this Saturday, but you can only spend $150 to feed everyone.

Your assignment is to buy food, soda, snacks, candy, plastic plates/cups/utensils, a birthday cake and candles for your BBQ!

Walmart Grocery - Use Zip Code 97233

*CANNOT spend more than $150.00
*Must be able to feed at least 15 people
    -Burgers are usually 1/4 pound, so if you buy 1 pound of hamburger, you can feed 4 people
*Must tell me how much of each item you are buying
*Must buy at least 10 items
*5 pictures
*Format as Currency 
*Graph Select Item cells (CTRL) Select Item Total cells
*Formula (Item total: =cell*cell) (Total: =sum(cells))
*Header/Title
*Column Headers
*Capitalize

 Item     Amount Cost Total 
Pound of Hamburger 
 5    
 $3.99  
     
     
     

I will teach you a new formula next class to figure out total cost when buying multiple items

Need Help? (BBQ Help Video)
Need Help? (With SOUND!)
*Like and Subscribe

Due Next Class
Finished? Turn in BBQ HERE
Comments