Day nine
Download
1 / 13

Day Nine - PowerPoint PPT Presentation

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

loader
I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.
capcha

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.


- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -

Presentation Transcript


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

    • 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


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


A Spread Sheet


A Bar Graph


A Line Graph


The last one — that pie chart


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.


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


Press [GRAPH] which is F5

Choose menu item 4 < Charts…>

Categories:A1:A6 [ENTER]

Series:B1:B6 [ENTER]

NumberPercent (make sure you have Number

highlighted)

Title: BUDGET [ENTER]

DRAW [ENTER]

Press [TRACE] to see what each category represents


Pie Charts, Bar Graphs, and all that Jazz!


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


ad
  • Login