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

<Log On>

Introduction:

Objectives:

• 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

Discourse
Minimize Discourse

Short Quiz on Thursday - hands-on Excel, 16 points

Q & A - Questions about Excel so far - homework review

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

Evaluation - Benjamin Harris (click below)

Don't forget your library survey time!

RefWorks link from Ms. McCollum:

http://www.blockwerks.com/trinity/cs1300/mov/refworks4/refwork4.html

Spreadsheets (in class):

• 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 10balance 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 10balance 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 10balance 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>