Scribd Logo
Upload

Welcome to Scribd!

  • 125 views

    Budget Lesson Plan

    Uploaded by

    api-252840751

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd

    Budget Lesson Plan

    Uploaded by

    api-252840751
    125 views2 pages

    Original Title

    budget lesson plan

    Copyright

    © © All Rights Reserved

    Available Formats

    DOCX, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    125 views2 pages

    Budget Lesson Plan

    Uploaded by

    api-252840751

    Copyright:

    © All Rights Reserved
    Download as DOCX, PDF, TXT or read online from Scribd
    Download as docx, pdf, or txt
    of 2

    Computer Application: Budget Lesson Plan

    Teacher name Subject Grade Level Time duration Materials needed


    Describe what you are going to need to have ready at hand for the lesson

    Robin Pelt Computer Applications 9-12 Five 90 minute class periods *Internet *Microsoft Excel C/T 9-12.10 Draw conclusions from research and relate these findings to real-world situationsinvestigating further, if necessary. A. Use digital research to support written and oral presentations. Apply research derived from digital resources to original work, as appropriate.

    Lesson Objective
    The objective of the lesson is what students will be able to do as they leave your class. For this objective, use the Standards of Learning (SOL) to say what you want to focus on. You can find the SOLs at http://www.doe.virginia.gov/testing/ look on the right of the screen for the subjects and go from there.

    Purpose of the lesson This


    connects with the lesson objective, but in this section of your lesson plan you will describe what you want students to be able to do in your own words. Be specific in this section. Why do the students need to learn it? What will they be able to do at the end of the lesson to show that learning has taken place?

    TLW use internet resources to help plan a monthly budget.

    Activity Describe what the learning


    activity will be. Include: -Exactly what the teacher and students will be doing each step of the way. For example, at first, will the teacher be modeling something, or describing what they are doing. -Explain if the teacher be asking questions, holding a discussion? -Explain if the students will be working independently, in pairs, groups etc.

    *The teacher is modeling the steps on the projector. *Use the Occupational Outlook Handbook (www.bls.gov/oco ) online to do a search for a career of interest. Find the annual median pay. *Use online resources to search for an apartment. (www.apartmentguide.com) *Use online resources to search for a vehicle. (www.autotrader.com ) *Use the car payment calculator to estimate the monthly payment. (http://www.carmax.com/enus/car-payment-estimatescalculator/default.html ) *Use the car insurance calculator (http://money.msn.com/autoinsurance/auto-insurance-quotes.aspx ) to estimate insurance. *The students will open Excel and create an budget by inserting the following information in the cells: 1. Cell A1: Budget 2. Cell A3: Income 3. Cell A5: Rent

    Assessment How will you as the


    teacher check to see if the learning objectives have been met. The assessment must match the lesson objectives and the purpose of the lesson.

    4. Cell A6: Car 5. Cell A7: Insurance 6. Cell A8: Utilities 7. Cell A9: Food 8. Cell A10: Gas 9. Cell A11: Phone 10. Cell A12: Lunch 11. Cell A13: Misc. 12. Cell A14: Expenses 13. Cell A16: Savings 14. Cell B3: Enter the amount of your monthly net income 15. Cell B5: Enter the amount of your rent 16. Cell B6: Enter the amount of your monthly car payment 17. Cell B7: Enter the amount of your car insurance 18. Cell B8: Enter 200 19. Cell B9: Enter 300 20. Cell B10: Enter 120 21. Cell B11: Enter 150 22. Cell B12: Enter 120 23. Cell B13: Enter 200 24. Cell B14: Have the students determine the formula needed to calculate total expenses (answer: =SUM(B5..B14) ) 25. Cell B16: Have the students determine the formula needed to calculate the savings (answer: =SUM(B14,-B3) 26. Click on the letter B at the top of the column. 27. In the home tab, clock on format and then format cells 28. Click on currency 29. Make sure you have two decimal places and the dollar sign selected. Click ok *If the student does not have a minimum of $200.00 in savings, they must go back and find a car and/or apartment that cost less money. TLW accurately enter all information in the cells. TLW also budget so that they have a savings of $200.00 per month.

    You might also like