Session+7

* rubric for total project - composed of section 1 and 2 for weeks 1 and 2) * skills checklist so that each student knows what skills are expected to be demonstrated  * organize a list of links/sources (i.e. census data) that can be used to get actual costs. Students should not just copy the teacher's data and make their spreadsheet look like the sample. Instead, the spreadsheet should be seen as a tool that solves problems.
 * || Kevin & Amy - please submit (missing as of 1/10)

__Week 1__ Day 1
 * Moodle Journal EntryDiscussion - What is a budget? Why are they used?
 * Discussion - How is a spreadsheet different than a word processing program? What are the benefits of using a digital budget? What products are on the market to help with budgeting? How can you protect the information in a digital budget?
 * Launch Numbers and determine the general expenses that a person would have. Enter that data in Column A.
 * Discuss what information goes in column B and C.
 * Changing column width
 * Homework - talk to parents about high low values

Day 2---Go over homework SHOW students how to sort/reorganize columns Talk about income—go through how to calculate gross pay, net pay Give students an amount to budget Have students develop a January budget using the predetermined income In cell A1, put January Budget, B1 put Amount Give students 10 expenses—Rent, Electric, Car Payment, Car Insurance, Gas, Groceries, Cable TV, Internet, Cell Phone, Clothes Have students sort column in ascending order Tell students we need to add entertainment, savings, vacation. Have students look for apartments, cars using public opinion, herald mail HOMEWORK—Journal---apartment and car

Day 3—Go over homework Have students fill in part of budget for January using $1200 for the income. Explain the difference between fixed and variable expenses. SHOW students how to format cell for $ amount with 2 decimal places. SHOW students how to put sum formula in for total expenses changing cell references from the quick formula. SHOW students how to calculate savings by subtracting total expenses from income using cell references Go to moodle---Car Payment calculator If students have to find a new apartment and/or different car, give 10 minutes to find new apartment.

Give students actual expenses for January January Cable TV $65 Direct TV $40 Car Insurance $600 Due in July Car Payment Cell Phone $60 or Comcast Triple Play for $100 which would mean no cell phone Clothes Electric 100 Entertainment Gas $3.00 gallon Truck 15 MPG SUV 20 MPG Car 25 MPG 1,000 miles Groceries 125 Internet $40 Miscellaneous Rent Vacation

Day 4
 * January and February budget
 * help students to predict expenses and complete new sheets
 * Insert actual data
 * Insert formulas to determine year to date expenses
 * Analyse data to determine most expensive category and what they could do if they needed to cut spending

Day 5
 * March and April
 * add additional sheets
 * format cells for currency, decimal points, text, etc.
 * generate charts and analyze the data
 * Format cells according to data needs
 * Review the rubric to make sure that they have met the criteria for the grade they wish to earn

Extension:


 * Extension - show future months and add in new expenses (medical, etc)
 * Research - cost of living in certain areas
 * Focus - current salary earnings in regards to education level

__Week 2__ Day 1 - continue to add data into the spreadsheet for May and June
 * add totals as appropriate
 * create charts and interpret data, complete "what if scenarios"
 * hourly wage increases by 3%, decreases by 1%
 * cost of utilities increases

Day2 -and Day 3 Essential Question - What vacation can 2 people take based on the spreadsheet created in Week 1? Justify your choice(s) by creating a spreadsheet from scratch that includes:


 * appropriate expense categories
 * appropriate cell formatting
 * <span style="margin-bottom: 0px; margin-left: 0px; margin-right: 0px; margin-top: 0.5em; padding-bottom: 0px; padding-left: 3em; padding-right: 0px; padding-top: 0px;">appropriate totals


 * individuals or pairs collect real-data (consult librarian to get resources)
 * they determine what they can afford to spend and need to justify that amount in a written explanation or with charts
 * students should conduct research to determine appropriate percentage of earnings to put toward vacations and/or savings
 * cite sources: URL and data sources for the values used in the spreadsheet

Day 4 > Day 5 ||
 * finalize the spreadsheet(s) and include images and text that display a clear meaning
 * multiple sheets as needed with cell references
 * Upload final assignment to instructor's moodle
 * Compare to Numbers template
 * Reflect on what you did
 * students pairs should conference with other groups to determine if the vacation plan is appropriate and can be accomplished
 * student pairs should be able to manipulate their data to reflect different scenarios posed by the teacher ( 1 day was added to the vacation, 1 person was added to the vacation, food expenses increased, etc.)