Weekly Menu & Grocery Shopping 2014

Hello Everyone,

Objective:  To plan a weekly meal menu and shop for items on the list.  To identify prices and differences in quality of different items.  To be able to accurately create a personal menu, shopping list, and translate your purchases into an online budget form for evaluation.

Steps:
1.  Complete Weekly Menu Form - Get it Approved.
2.  Complete Grocery List Based on Menu Choices - Get it Approved.
3.  Shop online for items on Grocery List and compare quality and prices.
4.  Total your Grocery Spending and Enter All Items on Shopping List in Budget Online (PMB)
5.  Share your menu and list with class during final presentations.

Please use the handout to plan your menu for a week.  I would like you to plan at least 2 dinners for 2 and a family dinner (6 people or more) for the weekend sometime.  It can be breakfast, lunch, or dinner, but include anything you would normally serve.  Once your menu is complete, make a grocery list.  In addition to groceries, there is a list of other items (BELOW) that you will need to keep at your home.  Detergent, soap, etc.  You may also include any items you might actually use regularly to your shopping list.  Finally, go to the website below and price everything you will need.  You may need to make substitutions, but you will get a good general idea of prices for your weekly shopping trip.  You will enter these figures on your monthly budget (remember that this sheet and shopping list is only for one week) when you are finished as actual costs.

Here are a couple of places to shop.  You may also look for other online grocery stores, pharmacy's or other providers.  They must list individual item pricing and you need to figure out delivery if you do not have one of the stores local to your new apartment.  (Example:  You can price things at Target.com, but you must figure out shipping costs if you do not have a Target store locally.  You must also figure out how to get your purchases home if you do not have a car.)

https://www.freshdirect.com/index.jsp

http://www.amazon.com/

Additional Items to Buy:

Laundry Detergent, Soap, Shampoo, Deodorant, a Mop,  a Broom, All-Purpose Cleaner, Light Bulbs, Dish Soap, 3 2-Liter Bottles of Soda (ie. Coca Cola, Pepsi, etc.), Band-Aids, Cold Medicine, and a Bucket, Tylenol or Advil, Batteries and a Flashlight, a Basic Tool Set, a Wiffle Ball Bat Set, and M&M's.

YOU MUST ADD EVERY ITEM ON YOUR SHOPPING LIST TO THE PERSONAL SHOPPING LIST PAGE OF YOUR DATA SHEET ON THE FAMILY MONTHLY BUDGET.  MAKE SURE YOU CREATE AREA FOR YOUR GROCERY SHOPPING FROM THE SHOPPING LIST YOU COMPLETED FOR YOUR MOVING DAY!

SEE EXAMPLE BELOW:

If you need copies of the forms in MS Excel or Printable, click the form below and download or print a copy:


Weekly Menu PDF (Printable):
https://docs.google.com/file/d/0BzY9jTFcLEUWdW9scGRJQTBYRWs/edit?usp=sharing

Weekly Menu MS Excel:
https://docs.google.com/file/d/0BzY9jTFcLEUWWTRGSkNyR2U1UlU/edit?usp=sharing

Grocery List PDF (Printable):
https://docs.google.com/file/d/0BzY9jTFcLEUWNHpwazhVaV9DSDg/edit?usp=sharing


Grocery List MS Excel:

https://docs.google.com/file/d/0BzY9jTFcLEUWaVlFZ2xGc296MnM/edit?usp=sharing

Good Luck,
Mr. S

Personal Budget Moving Day Activities 2014

Today you will work out your Moving Plan and fill out your Checkbook.
Here is a copy of my BUDGET SPREADSHEET as and Example:  https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdFFBcjAzRUZscm1CV0dhTzVjSlFQRlE&usp=sharing

You must use a COPY of the following document https://docs.google.com/document/d/1A-Tdt6ZC6PaCwx3YhqH-T5vZp6s7Jzry8i8LFhAVzL4/edit?usp=sharing and share it with me for credit.

YOU WILL USE THE PURCHASE SHEET TO SHOW ALL OF YOUR ITEMS BOUGHT.  Include all items purchased, where you bought them, and how much they were.  This includes travel expenses, airfare, insurance, household goods, furniture, and anything else you need to buy.

Your opening balance in your checkbook should be $134.50.  Your Parents, Uncle, Grandma, etc. is giving you a one-time grant for $2500 to help you get started.  It is your graduation present.  You need to complete the budget sheet (handout in class) and let me know all the things you are buying to get yourself started.  Follow these directions:

1.  First, you need to list where you went to college.
2.  Second, you need to list the address and city you are moving too.
3.  Explain how you are getting to your new city and what you are taking with you

•  You must find a flight, train, bus, etc. (Travelocity.com, Greyhound.com, etc.)  copy and paste your itinerary.
• What are you taking with you?  List any items you are taking with you.  EVERYTHING.  And have a plan to move it.  You are only allowed to have so much on a plane or bus.
• If you buy a car you need a quote for insurance (Geico.com) and budget for gas and maintenance.

You must now furnish your new apartment.  Find local stores (Wall-Mart, Ikea, Craigslist.org) to find the following items and budget for them:

1. Transportation:  Bike, Car(Insurance, Gas, Maintenance Apply), Transpass (Local Bus/Train)
2. Furniture:  Bed, Couch, Table & Chairs, Lamps, Desk, TV, Stereo, Computer, etc.
3. Household Goods:  Dishes, Pots&Pans, Silverware, Towels, Sheets&Blankets, Pillows, Plants, etc.

You will fill out the worksheet completely and use it to fill out the Checkbook on your BUDGET Sheet.  When you have filled out the budget, make sure you have SHARED it with me for credit.

I hope you are having fun with this assignment and learning how to keep a budget while you are discovering how much things really cost.

Keep up the good work!!

- Mr. S

Memorial Day 2014 Rememberance

All:

Next Tuesday we will continue work on our Personal Monthly Budget Project.  Today please follow the directions below.  After our viewing of the video in class, you will write in your journals.

Watch the following Memorial Day Tribute Video:
https://www.youtube.com/watch?v=UmCbiibZvX0

Please read the following post and write a short reflection (2-3 Paragraphs) in your Weebly.com journal.

"3rd Herd" Prior To MFO Deployment (Ft. Lewis, WA)

As you know, I am a Veteran of the US Army.  This weekend is for you to relax and enjoy a well-deserved rest.  While we celebrate our Veteran's on another day, please bear in mind the following excerpt from About.com:

"Many people confuse Memorial Day and Veterans Day. Memorial Day is a day for remembering and honoring military personnel who died in the service of their country, particularly those who died in battle or as a result of wounds sustained in battle. While those who died are also remembered on Veterans Day, Veterans Day is the day set aside to thank and honor ALL those who served honorably in the military - in wartime or peacetime."

Use the following links to find out more about this special weekend and why you should be thankful for the sacrifices made on your behalf.  We are not a perfect nation, but the blood of a few has been given so we can enjoy the freedoms we have.  Always Remember!
http://usmilitary.about.com/od/theorderlyroom/a/memorialday.htm
http://www.usmemorialday.org/backgrnd.html

MEDAL OF HONOR PROJECT:
Please go to the following link (http://www.history.army.mil/moh/).  You will be able to choose the period in history you would like to know more about.  I would like you to pick one Medal of Honor winner from history.  Look through them carefully.  Once you have identified one Medal of Honor citation to work with, you will be required to post it to our Google Document that is Shared ( https://docs.google.com/presentation/d/1lzv6J9whcPRm-g_A-Jp1uOtw_GlVObaFBJl9w3cULAM/edit?usp=sharing )

I would like you to add a slide to this presentation.  Make sure you find a picture of the person you found, a link to that person's citation page, and a thoughtful reason why you picked them.  I will publish this document for everyone to see so make sure your name and class period is on it as well. 

Make sure you spend some time over the weekend remembering those who gave all for you to live in a country that is free and has opportunity that is found no where else!

Thanks for your time and effort with this project!

- Mr. S

Personal Monthly Budget - Project Startup Day 2014

Personal Monthly Budget Startup Day!

Here is the Google Spreadsheet we will use for this project.  Make sure you open the document, MAKE A COPY, and NAME it (Your Last Name) CS Period (?) Budget 2014
https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdGJ1U1FKSXZBNzI2d2JoNnlMOVBsdGc&usp=sharing

On the first page you will notice it is a template for a family budget.  Today you will be entering your basic start-up information.  You have a job somewhere other than the Philadelphia Area based on your research on Career Day (Click Here).  You must enter your personal information, Job Title and list the address you work at.  Your next task is to fill in your address (apartment).  Over the next few days you will find out about utilities, services, groceries, and other costs to get changes to your plan and you will have to adjust your budget to reflect the changes.  Final budgets will be gradable. PLEASE SHARE your BUDGET with me so we can keep working on them each day.  Eventually you will be graded on the following basis:

Grading is as follows:     (1500 points Total)
     Personal Finance Worksheet Completion (100 points)
     Career Day Google Doc Complete (100 points)
     Google MAP Day Completion (200 points)
     Initial Budget Setup Day (100 points)
          Initialize and Accurately Place All Initial Information and Data Sheet
          Costs associated with the move to new location
               (Furniture, Travel, Housewares, Electronics, etc)
     Moving Day (StartUp) Worksheet (100 points)
     Stock Market Game Day Activities (100 points)
          Setting up and Starting To Invest
     Services & Utilites Day (Google Map) (100 points)
          Create a Google Map with Work & Home Address
          Add Points on the Map for Local Points of Interest
               Doctors, Grocery, Mall/Shopping, Entertainment, Restaurant
               Garage (Auto), Public Transportation, Route to Work (Method)
     Insurance & Investment Day Changes  -  (100 points)
          Renter's Insurance, Auto Insurance, Life Insurance, Health Insurance
          Stock Market Game Withdrawals
     Meal Plan & Grocery Shopping  -  (100 points)
          Weekly Meal Plan to include 2 "Date" nights and Sunday Family Dinner
          Cleaning Supplies, Housewares, Expendables, Etc.
          Online Grocery Order Submission.
     Final Changes & Submission of Budget (Email)  -  (300 points)
          Random Final Changes and Email to Instructor for Credit.
     Final Presentation (200 points Total)
          Powerpoint  - 100 points
          Presentation  - 100 points

Final Presentations of your completed BUDGET will need to include explanations to the class of where you live, what you spent money on, and how you saved and can tell the difference between expenses and discretionary income.


Keep up the good work!!

- Mr. S

Good Luck!!

MR. S 

Personal Monthly Budget - Google Map Day

Here is a link to your responses for the CAREER DAY Search Sheet:

https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdFlEMDVCUGhnQTc5RjU0QWIxWmo1ZUE&usp=sharing

Today you will be creating a GOOGLE MAP of your new home and work area.  Please sign-in to GMAIL and then follow Google site to Google Maps.  Below is a link to a sample map that I created for myself.  It assumes that my first job out of college was teaching here.  I located our school, a local apartment, and I saved the route I take to work (use Get Directions and save the result to your map).  I also included most of the information that you will have to find for yourself.  See my example at the following link:

http://goo.gl/maps/aCRTS

Once you have looked at my map, your assignment today is to CREATE your own GOOGLE MAP that includes the following items:

Work, Home, Directions (Route) from Home to Work

You must also include the following:

GROCERY
POLICE STATION
SHOPPING MALL/CENTER
LAUNDRY/DRY CLEANER
COFFEE SHOP
PUBLIC TRANSPORTATION (Closest Bus or Train)
CLOSEST MAJOR AIRPORT (In case you need to fly home to Philly)
HOSPITAL
DOCTOR'S OFFICE
DENTIST'S OFFICE
CHURCH/PLACE OF WORSHIP (Optional)
THREE (3) DIFFERENT RESTAURANTS
TWO (2) FUN THINGS TO DO

Please add me (hscribnercaa@gmail.com) as a COLLABORATOR and email me the link to your map.  In the Email with the link, you need to identify the following items by listing the Company and Customer Service Phone Number for each service in your new city:

PHONE COMPANY
CABLE COMPANY
NATURAL GAS COMPANY
ELECTRIC COMPANY
TRASH PICKUP COMPANY
WATER SERVICE
SEWER SERVICE
POLICE DEPARTMENT
FIRE DEPARTMENT
AMBULANCE COMPANY


This exercise will give you an idea of what types of things you need to look for if you move to another city someday to take a job or start college.  Even if you share an apartment/house with others, you should know this information.  Good Luck!!


- Mr. S

AfterCollege.com (FMB) Start Day

FAMILY MONTHLY BUDGET STARTING POINT:
Today you will build on the research you completed Monday.  You are responsible for not only finding a college and major you are interested in, but finding your first job after college.  YOU MAY NOT FIND A JOB IN PHILADELPHIA OR THE REGIONAL AREA.  You must find an "ENTRY-LEVEL" job outside the Philadelphia Area (Philadelphia, Montgomery, Bucks, Delaware, and Chester, Camden, Burlington, and Gloucester Counties are off limits).

Use the College and Major you chose on Monday and go to the following website https://www.aftercollege.com/.  Look on the right side of the opening page and you will see a box that says "Get Started Today".  Select a College you are interested attending (SCHOOL).  Enter a (MAJOR) you are likely to study.  Set the (GRADUATION DATE) for MAY of 2013 and click EXPLORE NOW.


If you chose professional training that did not require college, you must use Monster.com, Careerbuilder, Craigslist, or other employment search sites to find your first job away from the Philadelphia area.  You will have to search in a part of the country that interests you, and you still need to identify how you were trained to work in your chosen field.  Ask me if you have any questions about this.  If you joined the Military, ask me to help you identify a base to live near so you can complete the budget that way.

You may have to SIGN IN (Create A Free Account).  Use your class GMAIL to sign up, and select a password you can remember.

Now you must choose a job that you are interested in.  Once you find the job you must research where you will be working.  Look up the company that is hiring for that position and where the office is.  You will need to find an actual, accurate address to use.  You must also copy the Job Title and Job Description for use later.

Everyone in class will start with $36,000/year in base pay.  This will be your NET pay after taxes and deductions so you can spend that money on living expenses and anything else you need to buy to survive.  We will discuss your purchases in more depth next week.  For now, once you know what you are doing for a living and where you are working, you are now ready to find an apartment.  You need to find a place to live near where you work, or someplace that will not cost a fortune to commute from.  Everyone must live outside the Philadelphia Area.  You may not live with family, but if you and someone from Crossroads have chosen the same place to work in (Same City or Area), you may share an apartment or living arrangement.  This will help your overall budget.  You must still keep separate budgets, but you can share the costs.  Depending on where you live, you will have to decide how much to spend on transportation for work.  You may use Craigslist or other Real Estate and Apartment Finder websites to find places to live.

Once you have found all the information above and written it down on paper or a Word/Google Doc to save, please fill out and submit the following form completely (The more accurate and complete your answers are, the easier it will be to do additional tasks for your budget):

https://docs.google.com/forms/d/1p7xEGjupnxhzFprOUWFTwsKDHD43kPXer55wIKe9-0A/viewform

I was going to assign cities for you to find jobs in, but this is more realistic.  If you take this project seriously, you will be surprised as what you will learn about how much things cost and how keeping an accurate budget will save you money, time, and aggravation.  Previous students who complete this project correctly have enjoyed it and learned a lot about their future.  I hope you have fun working on it too.  You will present to the class your final budgets, so be careful and accurate.

Good Luck!

- Mr. S

Personal Finance and MONEYSKILL Program (300 points)

Here is the link to the presentation Personal Finance 101 from class:
https://drive.google.com/file/d/0BzY9jTFcLEUWV0N4NlltejB5Tkk/edit?usp=sharing
Use this link to help you complete your class handout.  If you need another copy of the worksheet, you can click the following link and print it in the back of class, on your own time:
https://drive.google.com/file/d/0BzY9jTFcLEUWRGh1TVI4djA4YlE/edit?usp=sharing

MONEYSKILL.ORG
Please click the link below and log into the MoneySkill.org website:
MONEYSKILL.ORG (CLICK HERE)


Your Username the first letter of your first name and your last name. (Example: hscribner)
Your Password is your Student Number.

You have until June 6th to complete all 12 units online.  There will be a certificate of completion for this and it is a graded event!  You must complete this starting today in class, and use your time at home, or free time in school to work on it.  It is considered a HOMEWORK Assignment.  Every student must complete the program for credit.  Good Luck!

- Mr. S

Personal Monthly Budget 2014 College & Major Day

Today you will create a Journal Entry (Weebly Journal) after reading the following article:

https://bigfuture.collegeboard.org/explore-careers/college-majors/the-college-major-what-it-is-and-how-to-choose-one

Please describe what major you are interested in and why you chose it at this point in your life.  I realize college is a few years away, and I am sure your interests might change between now and when you are going to go to school, but you will use the information you develop today to research future careers tomorrow.  Eventually, you will be responsible for choosing a College, Career, and your first Job after college to complete the PERSONAL MONTHLY BUDGET PROJECT (PMB) over the next few weeks!

After your Journal Entry is complete, please go to CollegeBoard.Org and create an account. (CLICK HERE).  You will use this site to research your College and Major and use the information tomorrow to decide what your first career might be.  You must complete the COLLEGE SEARCH and MAJOR AND CAREER SEARCH sections of the CollegeBoard.Org website prior to completing the survey below.

When you have completed today's research, please add the name of your college and the major you have chosen to the Google Spreadsheet by answering the following questions on this link: 

https://docs.google.com/forms/d/1a1yKllyW3DBgE_-H6U3P2dLHR_n-PKDvP6ZDcKNFviM/viewform?usp=send_form


Tomorrow we will discuss Financial Literacy and Financial Planning.  Later this week you will see a list of entry-level positions that people could choose based on a variety of decisions.  You will be entering your college and major and choosing a career with this site.  Your choices will determine where you will live and what career you will start with.  We will also be discussing financial planning and investing later this week.

When you have completed the Journal Entry and the College & Major Survey above, you are free to finish your Yearbook Pages that are due by the end of today!

Good Luck!

Mr. S

Sesame Street Payroll Project (400 pts)

Today we will walk through creating a TIMECARD and POSTING IT to PAYROLL SHEETS on GOOGLE DRIVE.  You will be required to follow along in class.  At the appropriate time you will complete the work on your own over the next two days and show Mr. S in class. When complete, you should know how to enter data on a form, manipulate the form to complete basic functions and how to automate the form by copying functions and formulas to additional cells.

Start by reviewing the following sheet of instructions either online or use the copy at your desk:

Payroll Project WORD Worksheet:
https://drive.google.com/file/d/0BzY9jTFcLEUWUkhYSk5TT0NjMFk/edit?usp=sharing

Second, choose one character from Sesame Street to create a TIMECARD for.  Make sure that you evenly space out the character's hours evenly over the work week as if they had worked for a real company you operate.  Use the following link to download a blank form and adjust the figures to be accurate for your character:

GOOGLE SPREADSHEET BLANK TIMESHEET LINK:
(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)
https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdDUyajRIY1gxLXpwSE5ZeXRLMEdmTUE&usp=sharing

MS EXCEL PAYROLL TIMESHEET LINK:
https://docs.google.com/file/d/0BzY9jTFcLEUWYVMxdnZpLVQtbmc/edit?usp=sharing

Finally,  Use the form below (Make a Copy to add it to your Google Drive) to create a PAYROLL SHEET for the whole company of characters.  We will work on this in class.  Pay attention and follow along and you will be able to complete the work with little effort.  When complete, simply share your work with Mr. S for comments/grading.


Payroll Project Google Spreadsheet (Blank):
(Do Not Forget To "Make A Copy" To Add To Your Google Drive BEFORE CHANGING!)
https://docs.google.com/spreadsheet/ccc?key=0AjY9jTFcLEUWdEVWLTlSTFR3bVp1RmV2d0h1YWtXZVE&usp=sharing

See examples of blank and finished payroll sheets below.  Numbers in the active worksheet must be formulas, not just numbers entered alone.  The worksheet must be "automated" for credit.  Good Luck.

- Mr. S