JOMC 172.002

Spring 2005

Schedule of readings and projects (download Excel file: schedule172Spring05.xls)
Syllabus (download Word file: syllabus172Spring05.doc)

Tuesday, April 26

Project 5 (final - due May 3)

P5sunmaid2005.ppt - Background and assignment.
P5FruitProdSum.doc - MRI Product Summary for Dried Fruit
P5MRIdata.xls - MRI Usage data for Raisins, Dried Fruit, and Breakfast/Granola/Fruit Bars & Snacks
P5AdultsWithChildren.xls - MRI media usage for adults with children under the age of 18

Thursday, April 21

Buying Exercise data (download .xls)

Tuesday, April 12

Blank Flowchart (download .xls)

Thursday, March 31

By request: the analysis of Project 1 (Smokey) presented in class (download .ppt)

Tuesday, March 22

PowerPoint from Class: Improving Media Objectives (download .ppt)
Project 4

Assignment (download .doc)
Data (download .xls)
Media Cost Data (download .xls)
Reach Tables (download .xls)

Thursday, March 10

Project 3 (due March 29) download .ppt

Wednesday, March 9

Frost Media Objectives (download .ppt)

Thursday, March 3

Project 2 (due March 10)

Download assignment (.doc file)
Download data (.xls file)

Tuesday, February 22

Project 1 (due March 1)

Download assignment (.ppt deck from class)
Download data (.xls file)

Thursday, February 17

Data file for assignment due Tuesday, Feb. 22 (download Excel file)

Tuesday, February 15

Homework for Thursday, Feb. 17 (download Excel file)

Tuesday, February 8

For Thursday, read "Understanding & Using MRI" in addition to textbook reading assignment (download Word document). Pay special attention to the "Illustrative Summary Table" and the "Illustrative Detail Table."

Tuesday, February 1

Homework assignment for Tuesday, February 8

(download Word document)
(download Excel document)

Excel & PowerPoint tutorials are listed at the bottom of this page.

Thursday, January 27

Homework answers (download PowerPoint deck)
Here's a copy of last year's first exam (download Word document)

For Tuesday, January 18

Download presentation deck (PowerPoint file): SamplePlanDeck.ppt)

Here are a few sites that provide tutorials for using Microsoft Excel and PowerPoint. They should be helpful if you aren't very experienced with the programs, or if you're just a bit rusty with it.

Excel

PowerPoint