Proficiency Scale for Spreadsheets in 7th grade
Formatting
Creating formulas and using math
Calculating complete columns or rows
Creating new data from or based on results from calculations
Making decisions based on data results.
On a collaborative spreadsheet, write your name and your favorite plate.
Make a copy when told, and start finding ingredients to each plate on the list. (Some, not many).
A good way is to ADD A SHEET for each plate and list the ingredients on the sheet.
Find photos for those plates.
Using conditional formatting, highlight in red if the ingredients contain sugar and green if the ingredients contain vegetables.
Restaurants where that food can be ordered. (You can list one, two or three. Then find their websites and telephone number).
Provide name, zip code and favorite city to travel to on the collaborative spreadsheet.
Make a copy of the sheet and start building data on those 3 pieces of key information.
Find one fun fact for each of the cities.
Find the website for the city (if any).
Find one picture for the city.
Find the link on Google map to the city and then add a screenshot of the map on the spreadsheet.
Create a graph that shows the travel distance. (First, get the distance to travel using Google maps and then create the graph using the obtained data).
Decide where to go on Spring Break using gas prices, distances and sleep breaks to make decisions.
Make a list of the cities in the Continental USA that you dream to drive to for your break. (20%)
Use Google maps to determine the distance to travel in MILES to each of the cities.(20%)
Given that your car does 21 miles per gallon of gas and that the cost of the gallon of gas is $4.30, determine the cost to drive to each city.(20%)
If you drive more than 10 hours, add a flat cost for stopping at a hotel for sleep and food of $200.(20%). Average speed is 60 miles/hour.
After determining the budget for the drive, use conditional formatting to determine the cities you can afford to drive to, the cities that you cannot drive to and the cities that you can think about. (Conditions, GREEN, RED and YELLOW).(20%)
Using conditional formatting, do the following:
Select the entire spreadsheet
Move the columns to resize the cells into perfect squares
Using conditional formatting, create a rule for every color of choice.
On the spreadsheet, color each cell by entering the letter/number that corresponds to the color.
Before you start, use one row to label your conditions to use as example. Example, R for red, B for blue and so on.
Meet spreadsheets:
Write your name on a shared sheet. Make a copy. Use the copy to sort, grade, color and so on.
Field trip with spreadsheets
Decide where to go on Spring Break using gas prices, distances and sleep breaks to make decisions.
Make a list of the cities in the Continental USA that you dream to drive to for your break. (20%)
Use Google maps to determine the distance to travel in MILES to each of the cities.(20%)
Given that your car does 25 miles per gallon of gas and that the cost of the gallon of gas is $4.00, determine the cost to drive to each city.(20%)
If you drive more than 10 hours, add a flat cost for stopping at a hotel for sleep and food of $100.(20%)
After determining the budget for the drive, use conditional formatting to determine the cities you can afford to drive to, the cities that you cannot drive to and the cities that you can think about. (Conditions, GREEN, RED and YELLOW).(20%)
Make a calendar for November.
Class project (November assignment):
EXCEL ASSIGNMENT: This will be your project for November
Details:
Decide on the subject of choice. (You pick a subject).
Use one spreadsheet on Google to make use of the data for that subject that you choose.
You need to have:
A graph on its own sheet (25%)
A formula (25%)
Conditional formatting (25%)
A live Graph posted on your portfolio (25%)
On your portfolio, create a page and name it November Spreadsheet Assignment.
a. Add the spreadsheet and the live graph on there.
b. Add a brief explanation about what your sheet is all about.