Class 11
Notes are in progress and are subject to change

<log on>

Discourse

Minimize Discourse

Class 11Outline:

Understand and identify Excel operations

Spreadsheets, continued - copy 11worksheets from Class to Groups

Aquarium assignment - line graph tutorial video

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

 

Homework:

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

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 18th 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

 

 

 

<log off>