Class 12

Class 11 Notes are in progress and are subject to change

<log on>

Discourse

Minimize Discourse

Class 11Outline:

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 understand a complex custom graph from Excel spreadsheet data
Introduction to Photoshop Elements
Understand Homework

Spreadsheets, continued - copy 11worksheets from Class to Groups

IF Function
Absolute, relative cell review
Charts

Aquarium assignment - line graph tutorial video

Aquarium Chart
Tigercard Balance
Commission Review
Hotel Occupancy
If Sales

Graphical Formats Chart

What you absolutely, positively need to know about image file formats
- and also know why you need to know it.

Use EPS and TIFF for print publishing. Use GIF, PNG, and JPG for online publishing.

TIFFs (and EPS)

JPEGs

GIFs

TIFF (Tagged Image File Format) is the most widely supported graphics file format for printing.
Although TIFF is not suitable for viewing in Web browsers, it has other strengths: it is a highly flexible format which is supported by numerous image processing applications.
Figures for publication should be submitted in high-resolution TIFF format.
They are generally LARGE files.
Minimum requirement for publication is generally 300 ppi.

If you want to know more about TIFFs

JPEGs are usually better for reproducing photographs.
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.
When you save an image as a JPEG file, not all of the information in the original image is preserved. This is because if it were, the file size would be very large. JPEG removes some of the information to keep the file size small.
Even though the files are compressed, they can still support
JPEGs cannot be animated.
They are small to medium files, generally 72 ppi.

If you want to know more about JPEG

GIFs (either "jiff" or "giff") are usually better for reproducing clean-lined simple designs with strong flat colors such as 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.
If you are using original artwork that has only a few colors, like logos, bullets or clip art, GIFs works better.
They can be animated, made with transparent backgrounds, and interlaced.
They are generally SMALL files.

If you want to know more about GIFs

Photoshop Elements: How to get it cheap or free

"Pics that Lie" Tool - Cloning

Open the Corrections file in the InClass folder and follow the directions in class

Homework:

Part One: Excel blog entry - make an entry about your experience with Excel.

What have you learned that you didn't know before?
What will be helpful to you in future classes? In your "real life?"
What do you like/dislike about the program?
One good paragraph should be adequate.

Part Two: ArtStor is another wonderful resource that is available to you because you are a student at Trinity.

www.artstor.org/

ASSIGNMENT: Designing a spreadsheet to use as an images database

You are designing a spreadsheet to collect and organize artworks from ArtStor for a team presentation about the controversial concept of “beauty.” Your job is to collect SIX suitable visual works to illustrate the concept.

Go to ArtStor and create an account if you do not have one and log in.

Search for and download your images to the Homework folder in 12worksheets. When you download the images, there will also be an html datafile that accompanies it. Hint: searching on the word “beauty” will give you a lot of general results. You might want to limit yourself to a certain genre, such as photographs, a certain era, such as the 18^th century, or a certain country/culture, such as Japan.

When you have collected and downloaded your images, design a spreadsheet to organize them. It should include a small thumbnail of the work itself. It should also contain the following categories:

· Title of work

· Creator’s name, if known

· Date

· Material used

· Source URL (this can be found in the File properties tab):

You may take a screenshot to use as the thumbnail. Save the Excel spreadsheet/database in the ARTSTOR folder, and then save it as a template, as well. You will be creating it from scratch and can use any design that you think is effective. See one idea below ( you do not have to follow this example -)

$Description: C:\Users\jbelisle\AppData\Local\Temp\SNAGHTML6309e32.PNG$

What you absolutely, positively need to know about image file formats - and also know why you need to know it.

What you absolutely, positively need to know about image file formats
- and also know why you need to know it.