lemsGoogle Sheets Formula Assignment
BACKGROUND: Students have reviewed videos and other learning materials regarding the creation of simple tables and charts in Google Sheets.
RESOURCES: Please review the video tutorial below and other learning material at the following page to prepare for this assignment:
DIRECTIONS: Create a new GOOGLE SHEET in your FRESHMAN_TECH FOLDER, name it FORMULAS. CLICK the + sign in the lower left corner of Google Sheets to create a NEW SHEET for each problem.
1. Create a simple TABLE just like the one below that shows 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.
2. In your Language Arts class, you have received the following grades for this semester:
Recreate the table in Google Sheets that shows this data. Use FORMULAS to calculate your TOTAL POINTS EARNED and TOTAL POINTS POSSIBLE. Figure out your percentage grade for last semester, using the formula =TOTAL POINTS EARNED/TOTAL POINTS POSSIBLE.
3. Using Google Sheets formulas, figure out the answers to the following math problems. PLEASE WRITE OUT THE "MATH PROBLEMS" (just like you would do for a word problem in Math class) IN A SHEETS CELL, THEN USE THE PROPER FORMULA TO CALCULATE THE ANSWER IN THE NEXT CELL TO THE RIGHT. (for example):
SUBMISSION: Your charts all be created and named as outlined above. The file should be in your FRESHMAN_TECH folder for grading.