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

Introduction:

Objectives:

• Create changing dynamic links between Excel and other Office Applications
• Explore file sizes and understand resolution of digital photos

<Log On>

Discourse
Minimize Discourse

Note: Kosmix - new way to search Web

Midterm 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.

---

Homework:

1. Complete Power Point Presentation using dynamic links, save it in 16data (Most of this will have been done in class - 6)

2. Blog Update: Write a meaningful entry on your experience using Excel (10) - e. g., what you learned that you didn't know before, how you might use it in the future, why it is a useful application for some academic fields and businesses.
Here's what a former student sent via email about using Excel in a later class:

Ms. Belisle,
I just wanted to say hi and that I am taking Fundamentals of Information Systems and I am sooo glad we learned how to use excel...I finish the projects about 3x faster than anyone else!! Hope you have a great semester!

3. Download Photoshop Elements Free 30-Day Trial from the websites, below. Come to class on Thursday ready to report  any problems or concerns     

•  PSE6 Windows Trial Version
•  PSE6 Mac Trial Version

<Log Off>