Midterms will not be returned today, but answer questions students may have.

Folder for today: 15data

There are two folders in the homework folder. We will go over in class what you need to do to complete the assignments.

Advanced Spread folder

Directions are on files.

Stats and PowerPoint folder

Analyze midterm grades from previous semester 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 slide - conclusions

In Class: Watch Guided Tour of PowerPoint 2007

Homework:

1. Complete Homework in 15data

2. Blog Update: First study the links from the home page about PowerPoint. Make a thoughtful blog entry telling what you think makes an effective PowerPoint presentations. Tell how your instructors have used PowerPoint. How effective have the presentations been? Explain.

3. Text: Chapters 12 & 13 (499-564) Creating Presentations