Thursday, September 5, 2013

September 5

Permanent Links—

View all deadlines at the AGEC 4213 Calendar.

View grades as I am recording them (by your class ID number) here.

Announcements—

The Fall 2013 Career Fair is Tuesday, Sept 24, 12:30-5:00 PM.

Go ahead and add the "Data Analysis" toolbox. File, Options, Add-Ins, Analysis Toolpak, Go

Homework 3 is due at the beginning of class on September 12. This homework requires you to learn about a very complex topic and communicate it clearly. That is not easy, and I do not expect perfect answers. Just try your best.

The deadline for the Creative Project: upload presentation to YouTube by 3:30 PM on November 5.

Today's Class—

Courtney Acton will begin class.

Ask for volunteers to begin next week's class.

Talk about former student Caitlin Harris and the importance of good graphs.

Open your saved spreadsheet from last class.

Finish this worksheet by polishing our histogram. If you were not in class on Tuesday or lost your spreadsheet, use this one.

Then we will begin this worksheet which uses these data.

Tuesday, September 3, 2013

September 3

Permanent Links—

View all deadlines at the AGEC 4213 Calendar.

View grades as I am recording them (by your class ID number) here.

Announcements—

Homework 2 is a medium homework, counting twice as much as a short homework, and is due September 5 at the beginning of class.

The deadline for the Creative Project: upload presentation to YouTube by 3:30 PM on November 5.

Today's Class—

For now on I will ask for volunteers to begin the next class at the beginning of the current class.

All this week we will be learning how to manage and manipulate data, using important Excel function like IF and AND statements, creating attractive charts, and creating historical simulations. These exercises are designed to reinforce basic Excel tools that people use daily at work, and to refine our understanding of histograms and simulations.

First we will complete this worksheet which uses these data.

If we have time we will then begin this worksheet which uses these data.