Class 16 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

<Log On>

Discourse
Minimize Discourse

Midterm E`xam Review

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

Watermarks - demonstrate on practice word document on desktop

Dynamic Links

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: 16data, 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 - Open the folder called 09tigertutorial and then open the document called Resolution and file Size. Follow the directions in class.

In class- follow directions to start an original photocollage using your best pictures in the 13digital folder

---

Homework:

Complete the photocollage that you began in class. Upload a screen shot of the completed work to your blog and write one sentence describing the meaning of your composition.

•  FYI: PSE8 Windows Trial Version
•  FYI: PSE8 Mac Trial Version

<Log Off>