Homework #3
Title: Using Excel: first try
Date assigned: Tue 9/9/03
Date due: Thu 9/11/03 or Tue 9/16/03
Minimum pages: 2
Maximum pages: 3

Description:

I announced this assignment in class on Tuesday, but I recognize that we did not have much time to talk about it. If you can't do it by Thursday, it will be ok to turn it in next week. However, if you can try to do it before Thursday, that would be good, because it will make it easier for you to understand my further discussion of how to use Excel on Thursday.

For this, our first attempt to use Excel, the assignment is very simple:

1. Find the sample spreadsheet named "using Excel."

2. Print out one copy of one page (use Print Preview) of this spreadsheet.

3. Create and print ONE chart using some of the instructions on the first sheet of the spreadsheet.

4. If you wish, you may hand-write on the chart some information about what you did, or any special explanations you would like. You also may include a cover page that explains what you did and/or any problems you had (and, maybe, how you solved them!). Before submitting your work, be sure the TOP page has written on it the standard course heading.

-------------------

Here is how to find the spreadsheet. I have posted to the website an expanded version of the spreadsheet that was presented in class yesterday. It contains (a) the charts I used to illustrate how you can present misleading data by adjusting the axis on a chart; (b) instructions for creating a chart in Excel; and (c) instructions for using a function in Excel. (If you looked at this chart on Tuesday, I expanded it considerably on Wednesday afternoon.) To get to the chart, go to the Psyc 220 home page, click on Demonstrations and Activities, and click on Using Excel.

NOTE: for the purposes of the present assignment, you can completely ignore all the material on using a function in Excel. For now we are only working on creating a chart in Excel. We will talk about using a function in Excel in the near future.

If you have trouble with this assignment, you will get credit if you report what you tried to do and what happened. I will want you to give some details about what you tried to do and how you tried to do it, so we can work together to solve any problems that you had.

 

 

dw9/10/03