1 / 13

Day Nine

Day Nine Complete the budget spreadsheet Calculator pie chart Enrollment (more charts) Day nine charts plus more charts A Monthly Budget $36,000 annual salary Take home pay (?) Monthly expenses Food $400 Rent $700 Car payment $250 Electric + gas $250 Insurance $200

Audrey
Download Presentation

Day Nine

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript


  1. Day Nine • Complete the budget spreadsheet • Calculator pie chart • Enrollment (more charts) Day nine charts plus more charts

  2. A Monthly Budget • $36,000 annual salary • Take home pay (?) • Monthly expenses • Food $400 • Rent $700 • Car payment $250 • Electric + gas $250 • Insurance $200 • Savings + entertainment $200 • Extra (what ever is left!) • Monthly take home and expenses • Total monthly take home pay and dollar expenses • Expenses as a percentage of monthly take home

  3. The Task • Build a spreadsheet • Construct a bar graph • Take home • expenses • Construct a linear graph • Construct a pie chart • Expenses as a percentage of take home

  4. A Spread Sheet

  5. A Bar Graph

  6. A Line Graph

  7. The last one — that pie chart

  8. Pie Chart for Budget on the Calculator Press [APPS] on calculator Use the arrows to find <CelSheet> and press [ENTER] press [ENTER] again to take you to the help screen.

  9. Press [GRAPH] which is F5 Choose menu item 3 and type BUDGET [ENTER] [ENTER] (one enter saves the name and the other takes you to the cell sheet) In Column A enter the names of the categories: Food, Rent, Car, Ele. and gas, Ins., Sav. and Ent. You will need to press [ALPHA] [+] to access the quotation marks to put around names. In Column B enter the amount for each

  10. Press [GRAPH] which is F5 Choose menu item 4 < Charts…> Categories: A1:A6 [ENTER] Series: B1:B6 [ENTER] Number Percent (make sure you have Number highlighted) Title: BUDGET [ENTER] DRAW [ENTER] Press [TRACE] to see what each category represents

  11. Pie Charts, Bar Graphs, and all that Jazz!

  12. Pie Charts and Bar Graphs: Computer and Calculator • K1 Group: the spreadsheet and charts are by K1omputer • C2 Group: the spreadsheet and charts are by C2alculator using [stat1] (lists) • C3 Group: the spreadsheet and charts are by C3alculator using [apps] <CelSheet> • Presentations: by K1, C2 , andC3

More Related