day nine l.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
Day Nine PowerPoint Presentation
Download Presentation
Day Nine

Loading in 2 Seconds...

play fullscreen
1 / 13

Day Nine - PowerPoint PPT Presentation


  • 295 Views
  • Uploaded on

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

PowerPoint Slideshow about 'Day Nine' - Audrey


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
Day Nine
  • Complete the budget spreadsheet
  • Calculator pie chart
  • Enrollment (more charts)

Day nine charts plus more charts

a monthly budget
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
slide4

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
slide9

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.

slide10

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

slide11

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

pie charts and bar graphs computer and calculator
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