Class 13

Class 13 Notes

(notes are in progress and are subject to change)

Introduction:

Objectives (Review):

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 (checkbook)
- Adjustable percentage
Be able to produce a simple graph from Excel spreadsheet data

<log on>

Discourse

Minimize Discourse

Spreadsheets, continued - copy 13worksheets from Class to Groups

Ice Cream - charts and graphics
If Sales - IF Function
Checkbook - Running Balance/Logo Design (graphics, Word review)
Design a logo for your checkbook
Amortization - Advanced functions

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

Graphical Formats Chart

What are TIFs, GIFs, and JPEGs?
TIF or TIFF (Tag Image File Format)	GIF (Graphics Interchange Format)	JPEG (Joint Photographic Experts Group)
TIFF files are commonly used to incorporate images into documents for desktop publishing. Tiffs are convenient because they may be viewed by numerous image viewing applications. Tiffs are uncompressed images that contain more computer information than gifs or jpegs and therefore usually reproduce better for print than gif files.	Gifs are usually better for reproducing logos or drawings.GIF files support a maximum of 256 colors, which makes them practical for almost all graphics except photographs. The GIF format supports transparency and is compressed. Gifs can be animated.	Jpegs are usually better for reproducing photographs. The JPEG format, with its support for 16.7 million colors, is primarily intended for photographic images, particularly for use on the web since the files are compressed and download quickly. Jpegs cannot be animated
Millions of Colors	256 Colors	Millions of Colors
300 dpi	72 dpi	72 dpi

Formats and File Sizes

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? (8)

What are TIFs, GIFs, and JPEGs?