Day nine
Download
1 / 13

Day Nine - PowerPoint PPT Presentation


  • 281 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 l.jpg
Day Nine

  • Complete the budget spreadsheet

  • Calculator pie chart

  • Enrollment (more charts)

Day nine charts plus more charts


A monthly budget l.jpg
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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg

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 l.jpg
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