Description:

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

1. Find the sample spreadsheet named "using Excel." Here is how to find the spreadsheet. Go to the Psyc 220 home page on the website. Click on Demonstrations and Activities. When you get to that page, click on Using Excel. Be sure to follow the suggestions at the top of the page.

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

3. On a second page, create and print ONE chart using some of the instructions on the first sheet of the spreadsheet.

4. Please hand-write on the chart some information about what you did, or any special explanations you would like. Optional: you also may include a cover page that explains what you did and/or any problems you had (and, maybe, how you solved them!).

5. Before submitting your work, be sure the TOP page has written on it the standard course heading.

EXTRA CREDIT options announced in class 9/9/04:

Extra Credit Number 1. For a small amount of extra credit: Use one or more Functions on a set of data as shown in class, and print out at least one or more sheets showing the data and the function. Be sure to clearly label this sheet as Extra Credit Number 1. For example, you might select two sets of numbers and do a t-test on whether there is a significant difference between them. You may print on your sheet or hand-write on it the following information:
- the set or sets of data you used (you can just put a circle around them and label them Set A, Set B, etc., or you can give them names - your choice, but I must be able to understand what you did).
- the function or functions you used.
- Note that for this extra credit, it is ok if you worked with someone else in class who showed you how to do this. If you did that, it would be nice to give that person credit.

Extra Credit Number 2. For an additional small amount of extra credit: work with one other person in the class to show them how to do Extra Credit Number 1. To get credit for this, submit a single sheet of paper with a brief statement describing what you did, with whom, where and when, and how it turned out. Be sure to clearly label this sheet as Extra Credit Number 2.

PLEASE STAPLE ALL of the material for Homework #3 AND any extra credit into a SINGLE packet for submission.

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

NOTE: The Excel spreadsheet you will get is complex because it includes lots of different information. 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.

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.

revised 9/13/04