Assignment 0 Hello Spreadsheets

Assignment 0: Hello Google Sheets!

Graded Assignments will count towards your final grade in the course. Each assignment is graded pass-fail. While Assignment 0 is more of a tutorial for the learners to get you used to submitting Google Sheets for grading, they need a passing grade on each assignment to complete the course. Each assignment builds on concepts introduced over multiple lessons, so we would them to begin reviewing the assignment and working on the different tasks as soon as the assignment becomes available in Canvas.

Their first assignment is mostly an exercise in following instructions. We’ll ask them to modify an existing Google Sheet so that, when updated, will return a specific value within the given cell.

Rubric and Requirements

1. Sign in to their associated Google account.
2. Adjust data and formulas within the provided Google Sheet.
3. Submit assignment link for grading.

Car Info

1. Learner has added a new insurance rate within the Car Info tab
   • Updated monthly cost based on new insurance rates

Grocery Info

1. Learner adjusted tax rates for the 2024 year
   • Updated monthly grocery estimates based on new rates of inflation
   • Bonus step of providing a new budget for the 2024 year

Overview

1. Learner calculated monthly and yearly estimates using a formula to pull in data from separate tabs
   • Has calculated for a combined total specific to each category