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

Introduction:

<Log On>

Discourse
Minimize Discourse

Discourse Q & A - Questions about Excel so far

Minimize Discourse

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

Quiz 2

When finished with quiz, update personal Grades spreadsheet.

Spreadsheets (in class):

• Open your personal grades file.
  • Make a place (insert new column) for comments on your assignments
  • Enter new grades
  • Create a formula for the average
     
• Running Balance
• Commission
• 3GPA
• Horse Racing
• Ice Cream

Use Snagit to make Excel Tab Captures

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 11balance 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 11balance 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 11balance and titled income_statement. (6 pts. for correct information, formatting, and formulas)
        Data to be entered from P. 234:

Reading:Text: Chapter 7 - Creating Charts
 

<Log Off>