Class 16

Class 16 Notes

(notes are in progress and are subject to change)

Introduction:

Discourse
Minimize Discourse

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

Intro to Photoshop Elements, Continued - Corrections files

How to Download the Trial Version of PSE6

Homework:

1. Complete Power Point Presentation using dynamic links, save it in 16data (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 is an example via email from a former student;

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. Text: Chapters 12 & 13 (499-564) Creating Presentations