Google Sheets Formula Assignment

BACKGROUND: Students have reviewed videos and other learning materials regarding the creation of simple tables and charts in Google Sheets.

RESOURCES: HERE IS A QUICK VIDEO ON HOW TO USE GOOGLE FORMULAS. YOU ARE EXPECTED TO WATCH THIS AND UNDERSTAND ALL TECHNIQUES INVOLVED!:

DIRECTIONS: Create a new GOOGLE SHEET in your COMPTECH FOLDER, name it FORMULAS.

CLICK the + sign in the lower left corner of Google Sheets to create a NEW SHEET for each problem below.

PROBLEM 1. Create a simple TABLE that shows the EXACT DATA below, showing the square footage of the following rooms in a house. Use the proper FORMULAS to calculate the SQUARE FOOTAGE OF EACH ROOM and the TOTAL SQUARE FOOTAGE of all rooms combined.

ROOMS LENGTH in FEET WIDTH in FEET SQUARE FOOTAGE (=length*width)
Living Room 20 25  
Dining Room 17 20  
Kitchen 12 15  
Master Bedroom 15 22  
Bathroom 6 10  
Total Square Feet=  

PROBLEM 2. In your Language Arts class, you have received the following grades for this semester:

Assignment Grade Total Points Possible
Quiz 1 8 10
Quiz 2 6 10
Quiz 3 10 10
Paper 155 200
Project 85 100
Test 146 150
Extra Credit 6 0
Totals    

Percentage Grade ----------------->(=GRADE divided by TOTAL POINTS POSSIBLE)

PUT IN PERCENT FORMAT by click the PERCENT BUTTON at the top of the screen!

  

Recreate the table in Google Sheets that shows THIS EXACT DATA (Honestly, I don't care about your REAL grades here!). Use FORMULAS to calculate your TOTAL POINTS EARNED and TOTAL POINTS POSSIBLE. Figure out your percentage grade, using the formula =TOTAL POINTS EARNED/TOTAL POINTS POSSIBLE.

 

PROBLEM 3. Pretend you are an upperclassman. Because YOU can drive, you are heading to the local fast food place and the gas station for a bunch of your friends to pick up some stuff to get them through a long school day. Here is a table of the stuff your friends want. What is the total bill for all of this stuff?

FRIEND WANTS HOW MANY HOW MUCH DOES EACH COST? TOTAL
DYLAN GOLDEN SRIRACHA DORITOS 2 $3.50  
STEVE JUNEBERRY RED BULL 3 $3.00  
TRICIA NERDS GUMMY CLUSTERS 2 $2.75  
BONNIE AIRHEADS 4 $1.25  
TAYLOR JACK LINKS BEEF JERKY 3 $2.25  
GRAND TOTAL:  

 

PROBLEM 4. You are thinking of getting a subscription to a Professional AI Model, to "help you" with your schoolwork. Below is a table of the possible prices for the different services you have researched. WHICH WILL BE THE LEAST EXPENSIVE PER DAY that you could sign up for?

AI COMPANY PRICE PRICE PER YEAR (12 months in a year/ 52 weeks in a year) PRICE PER DAY (there are 365 days in a year!) BEST DAILY PRICE? (highlight the best price by changing the CELL COLOR to PINK)
Open AI/ ChatGPT $372.45 per year      
Claude/ Anthropic $29.95 per month      
Gemini $6.97 per week      
Microsoft CoPilot $175.95 for 6 months      

SUBMISSION: Your sheets should all be created and named as outlined above. The file should be in your COMPTECH folder for grading. This will be a 20 point assignment and is due on the day assigned.