Class 9 Notes (notes are in progress and are subject to change)

<Log On>

Discourse
Minimize Discourse

Copy 9balance folder from Class folder to your Groups (shared) folder.

Class 9 Outline

• Understand and identify Excel operations
  • formulas
  • labels
  • functions
• Know when to use absolute and relative cell references and be able to create them in the Excel formula window
  • Running balance
  • Adjustable percentage
• Be able to produce a simple graph from Excel spreadsheet data
• Homework - spreadsheets from text

Q & A - Questions about Excel so far - homework review - Quiz next Thurs on Excel

Spreadsheets (in class):

• Guesstimates
• KRTUfundraiser
• Freeze
• Running Balance
• Commission
• 3GPA
• Horse Racing
• Ice Cream

Homework:

******Reminder: When the textbook asks you to print out a worksheet, you do not need to do that if the assignment is saved in the correctly-named file inside the correct folder.

Complete Exercise 4 on p. 230 of the textbook. A file has been created for you in 9balance and titled metric_conversions. (6 pts. for correct information, formatting, and formulas - use the measurement equivalents given in the instructions to make your conversion chart.)
        Data to be entered from P. 230:

Complete Exercise 7 on p. 233 of the textbook. A file has been created for you in 9balance and titled personal_finances. (6 pts. for correct information, formatting, and formulas - follow information in example in text and use running balance activity from class to remember how to do the formula)
        Data to be entered from P. 233:

Complete Exercise 8 on p. 234 of the textbook. A file has been created for you in 9balance and titled income_statement. (6 pts. for correct information, formatting, and formulas)
        Data to be entered from P. 234:

Reading Chapter 7 in text - Creating Charts
 

<Log Off>