Microsoft Excel Assignment #6 - Calculating Your Yearly Budget

Good Morning!  Today we will be working on creating a spreadsheet like the one above.  It will help you calculate what a yearly budget might look like if you choose to live here in the bay area!  While shocking to see the cost of living, it is also important to prepare for future success!

For your blog today, please post your final project similar to what I posted above.  While you also answered these questions on the spreadsheet itself, I want you to take a second to respond to them here on your blog also.  Start your blog by talking about the assignment, the skills you learned with Excel and what the goal/purpose of the assignment was in relation to preparing for future academic, career and life success.

Then, please respond to the following questions:

1. At $14/hr, how much money in debt are you at the end of the year?
2. What is the rate of pay required to end up with approximately 0 total savings at the end of the year?
3. What is the required rate of pay so that you end up with $500 in savings at the end of the year?
4. Something would happen if you got a roommate and shared the cost of rent evenly between you both.  Explain how that would affect your expenses and savings.
5. Besides increasing your rate of pay, what else could you do to increase your total income per year?
6. What rate of pay must you achieve in order for you to save $40,000 per year given all of your expenses?
7. Write a formula in cell A31 that will multiply this new rate of pay (cell H21) by 2080 (how many hours someone works in one year).
8. Which, if any, of the column heading numbers do you believe are wrong - is rent to high?  Do you believe you could save on entertainment expenses?  Discuss where you see room for saving or areas where costs may be higher in relation to the lifestyle you want to lead.
9. Let’s assume that you will not be a professional athlete, a successful musician, a supermodel, or that you simply will marry an extremely rich person.  Let’s also assume that like most Americans you will have to get a real job to survive in this world.  Based on the answer that you got for question 7 above, what level of education must you obtain in order to earn that much money by the time you are approximately 35 years old?  Take a look at the chart below.

Please take the time to respond to each of the questions thoughtfully and thoroughly (complete sentences). Remember, you need to explain to your audience what you learned so complete sentences are incredibly helpful. Also keep in mind we are talking about your future so a little extra time invested now may go a long way in the future!

Microsoft Excel Assignment #5 - Calculating Your GPA

Good Morning and congratulations on completing your 5th MS Excel Tutorial.  Today you had the opportunity to set up a table using formulas that will easily calculate your GPA for you.  That is a handy tool to have as grades fluctuate constantly and it is important for you (as you consider what future academic options you have) to maintain that 3.0 GPA.  This blog post is simple as you already answered the questions on your excel document but I would like you to repost them here.  The questions you need to address are as follows:

• Do you plan to attend college after high school?
• What is the lowest GPA you can have to be eligible for the Cal State University system?
• What is the lowest GPA you can have to be eligible for the UC system?
• How does your GPA for this quarter to date compare to these minimum requirements?
• Given the information you just discovered about your GPA, are you on track to accomplish your goal for after high school or here's a simpler question - are you on track to be eligible for our 3.0 3rd quarter incentive trip?

Thanks for your response and hard work!!  

SF State Reflection

 

Good Morning and Happy Tuesday!  What an amazing experience yesterday - to be able to get off our High School campus and have the opportunity to visit a college/university just 30 minutes from home.  This morning, it would be a shame not to take a moment to reflect on this experience.  Below are a series of questions I hope you will take the time to think about and reflect on to personally benefit yourself.  Take your time - this is due at the end of the period:

• Introduce the activity you were involved in yesterday - what did you physically do?  Include the name of college visited and day/date visited
• What was your overall impression, or feeling, about this college?
• Can you imagine yourself attending this college, or one like it? Why or why not?
• What did you like best about this college?
• What did you like least?
• What were some important details you learned from being on the trip yesterday?
• What would you like to know more about?
• How will your visit yesterday affect your future plans? Will you apply to this college (or one like it)? Why or why not?
• How has the college visit affected your decision about going to college and ideas about what you need or want from a post-secondary education?
• What is your interest level in getting a 4 year college degree on a scale of 1 to 5 (1= not interested; 5 = absolutely will get that degree).  Did yesterday's trip affect your commitment level to this?
• What do you personally need to do (be specific) to go to a college like the one you visited yesterday?

Although it seems like a different topic, please finish your post today by discussing the class scheduled you plan to sign up for next year.  While most of you will be in Academy English, US History, MultiMedia and Chemistry, what courses do you also plan to enroll in and how will those help you with ensuring you are eligible to attend the 4 year university of your choice?  What can you do to ensure you are getting the best grades possible?

Thanks for your thorough and thoughtful response!!  I look forward to reviewing it!