Class 12 Notes are in progress and are subject to change

<log on>

Discourse

Minimize Discourse

Class 12 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
  • Loan Amortization
• Be able to understand a complex custom graph from Excel spreadsheet data
• Introduction to Photoshop Elements
• Understand Homework

Review if requested

Excel Quiz

Spreadsheets, continued - copy 12worksheets from Class to Groups

• Hotel Occupancy
• If Sales - IF Function
• Checkbook Setup
• Chart Practice
• Design a logo for your spreadsheet

http://www.logomaker.com/       

Intro to Photoshop Elements - Making a Simple Logo

Downloading Photoshop Elements - note: expires in 30 days, may want to wait

Graphical Formats Chart

What format is this graphic? How do you know??

Homework:

Part 1:
Spreadsheets from Textbook:

• Exercise 12, p. 237: Mileage Log - Templates and Absolute cell reference review

• Exercise 13, p. 238: Chicago Travel Expenses - Templates and getting info from Internet

• Exercise 15, pp. 241-2 - Sales Analysis - conditional formatting

Part 2: It is important to carefully evaluate the reliability of electronic web and print media, especially in an academic setting. Go to the website maintained by CNet called Pictures that Lie:

http://news.com.com/2300-1026_3-6033210-1.html

Look at the photos and read the comments on the right. Choose one of the photos to analyze in detail.

Make an entry in your blog discussing:

• What picture you chose and why
• Where did the picture originate?
• How was it manipulated?
• Why was it manipulated?
• Was the manipulation harmful? Why or why not?
• Upload a screen shot or insert a copy of the picture that you chose with your entry (10)

<log off>