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

Class 16 Outline:

• REVIEW MIDTERM EXAM PARTS 1&2
• Create changing dynamic links between Excel and other Office Applications using an analysis of midterm exam grades
• Explore file sizes and understand resolution of digital photos
• Work on a thoughtful photocollage using your own photographs
• Linking Information from Excel to PowerPoint
• Photoshop Elements 30 Day Free Trial - this does not apply

<Log On>

Discourse
Minimize Discourse

Midterm Exam Review

Copy 15data from Class folder to your shared folder in Groups

Analyze midterm grades on spreadsheet
Linking Data Between Office Applications -
(Excel and PowerPoint)

1. compute the total points  

2. compute grade and format as % with 2 decimal places

3. sort the grades from highest to lowest

4. compute the mean, mode, and standard deviation for parts and total  - (the practical value of understanding the standard deviation of a set of values is in appreciating how much variation there is away from the "average" (mean)).

5. compute the median grade for parts and total

6. make a frequency table using intervals of 5 points (already done)

7. make a column chart of the frequency table

8. insert rows at top of sheet for title, name, computer #, class time 

9. make a PowerPoint presentation linking data (save in: 15data, file name:data) - open and close slide to make sure links work

You should see this notice (right) if the data is properly linked. Put the Excel worksheet and the Power Point presentation in the same folder to insure the linked data can be found.

• 1st title slide -
• 2nd statistics slide with mean, median, mode, stnd dev
• 3rd freq table slide-
• 4th chart slide-
• 5th ending slide with conclusion - how did students do on hands-on vs. written, for example

In Class- PSE Content and Special Effects

Painting color onto black and white

Postcard Introduction - DC Pics

Homework:

Part One: Find Photoshop Elements 8 for Windows Essential Training in Lynda.com

http://www.lynda.com/Photoshop-Elements-8-tutorials/for-windows-essential-training/53706-2.html

Work through each of these videos using the exercise files in the Class folder you will need to be familiar with these techniques.

Optional - download the latest TRIAL version of Photoshop elements from adobe.com - you will need to have access to this software for the remainder of the semester. It is free for 30 days.

Part Two: Collect at least five photographs for your Hometown Postcard project. Save them in the correct folder inside 15data. Make sure the resolution of each is compatible or can be adjusted.

GUIDELINES preview for Hometown Postcard

-The dimensions should be be five inches tall and seven inches wide resolution 72ppi for use on web or in  presentations
-The background may be transparent or solid.
-You may choose what photographs to use - most cities and towns have a web-based site with pictures and information about their community. Since this is a homework assignment and will not be published to the web, copying from the Internet is acceptable for practice. Don't forget about the Stock Exchange. Save all photos that you use in a separate folder.
-You will use at least three photographs and each one should be placed on a separate layer during the design process.
-Include at least two text layers in your graphic.

Show that you know how to use the following techniques:

opacity
move tool
enhancement
resize
feather
crop
brightness
contrast
hue
saturation
gradient

 

<Log Off>