Wednesday, December 22, 2010

Personal Family Budget Final Changes


Please make the following changes to your Personal Monthly Budget and attach it to an email to Mr. S.  Label the budget as follows:  "(Your LAST Name) Final Budget"

1.       Add your grocery bill for the month
2.       Add $150 to your budget for a Car Repair and Oil Change.
3.       Add Health Insurance, Car Insurance to your budget.
4.       If you did not add a vehicle to your initial budget, you need to find a car and insurance.
5.       Get a pet:  dog, cat, fish, snake, whatever….but budget for vet and care products
6.       You are taking a class at a local college….add $1200 for tuition and $125 for books.
7.       You went to the movies with your niece/nephew/child/etc…..add enough to cover popcorn and tickets.
8.       You took first prize in a writing contest….add $100.
9.       Add $50 per month for cell phone service
10.   Find a bicycle for fun and add the cost to your budget
11.   You went to the movies with a friend….add the cost.
12.   You won the lottery……$150…scratch off..add to your budget
13.   Your mom’s birthday is coming up…get her a gift….add it
14.   You utility bills are 10% higher than you budgeted for…..add it

Finally, include at least 3 paragraphs in the body of your email on what you learned while keeping a budget and how this project might help you in the future.

Thursday, December 16, 2010

Grocery Day

Hello Everyone,

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 when you are finished as actual costs.

https://shop.acmemarkets.com/store/?market=10002

Additional Items to buy:

Laundry Detergent, Soap, Shampoo, Deodorant, a Mop, All-Purpose Cleaner, Light Bulbs, Dish Soap, Soda (ie. Coca Cola, Pepsi, etc.),  Tylenol, Band-Aids, Cold Medicine, and a Bucket.


Good Luck,
Mr. S

Monday, December 13, 2010

Personal Family Budget

Good Morning,

Please go to the link below and familiarize yourself with the document:

https://spreadsheets.google.com/ccc?key=0ArXPDlbP92xbdENrVFJ2VXZ0VHZSdnpQUWZCaVkzMmc&hl=en

Download the document to Excel and Save It.  Each Day you will have to save changes and email it to yourself.  You can avoid emailing it by saving to a flash drive.  THERE IS NO GUARANTEE THAT YOUR COPY WILL STAY ON THE SYSTEM YOU ARE WORKING ON HERE IN CLASS.  Final budgets will be due Friday at the end of class.

On the first page you will notice, it is a template for a family budget.  Today you will be entering your basic startup information.  You have a job in the Philadelphia Area.  The job cards are being distributed.  You must enter your information, find housing near your job, work out transportation, utilities and other information.  Over the next few days you will get changes to your plan and have to adjust your budget to reflect the changes.  Final budgets will be graded.  Please complete the changes and email the final budgets to me on time (Friday). 

Grading is as follows:     Initial Budget Setup =   30 points
                                     Changes Completed =  30 points
                                     Final Presentation =      40 points

Final Presentations 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.

Good Luck!!

MR. S

Friday, December 10, 2010

MS Excel Quiz

Please download the following quiz.  Once it is opened, press FILE and Download it as an Excel File on your system and then email it to me when you are done.  Good Luck!
Mr. S

https://spreadsheets.google.com/ccc?key=0ArXPDlbP92xbdGxCWGVjalBoelJoZWttRUxLZnlCUXc&hl=en

Tuesday, December 7, 2010

TECHNOLOGY SURVEY

Please Take The Following Technology Survey As Your DO NOW Activity Today!

SEE THE BOTTOM OF THIS BLOG!!

Monday, December 6, 2010

MS EXCEL PAYROLL AND STATS WEEK

Good Morning All:

Chilly beginning to another week that will bring us closer to the holiday break.  Today we are working on
Timecards and Payroll Spreadsheets.  Please open the following spreadsheets and instructions and begin creating the appropriate documents.  Once they are opened and saved on your systems, you can follow the instructions to finish the project and email the finished forms to me.  Good Luck!!  Mr. S

https://spreadsheets.google.com/ccc?key=0ArXPDlbP92xbdGRGdFJOdGZsaFgxaGhDd1hPSVU4M0E&hl=en

https://docs.google.com/document/d/1jjqj8dYMg5kOulyTSr5VIAS47PLxTzXCjshF8l4BPK8/edit?hl=en

Wednesday, December 1, 2010

MS EXCEL Introduction Week!!

Welcome back from the Holiday weekend!!

Hopefully you had a restful time and we can get started on our MS Excel Introductions.  Please use the following links to access the spreadsheets we are using this week:

BUDGET SHEET
https://docs.google.com/leaf?id=0B7XPDlbP92xbNDUxNzk3MWMtMjJmMi00YzgzLTlkYmItMjViZmZmZTk3Y2Qw&hl=en



THEATRE SHEET
https://docs.google.com/leaf?id=0B7XPDlbP92xbZDhlNjJhMGMtNzg4Zi00Y2Q0LTkxOTgtY2ZjNjAzZGEwNjE4&hl=en

We will work slowly and methodically this week before we ramp up to Payroll, Statistics, and our Personal Monthly Budgets.  Finally we will end with an investing lesson and we will work with an online portfolio program.  Enjoy!!

Mr. S