Ed 602 - Assignment 2

In the assignment for lesson 1, you provided the following data about yourself.
  1. Name
  2. Student Number
  3. Gender
  4. Major for graduate program
  5. The name of your major advisor
  6. The distance from your home to Moorhead, Minnesota (answer to the nearest whole mile)
  7. Favorite color
  8. Size of the town (population) in which you attended high school
  9. Number of siblings
  10. Name of the last book you read (or are reading) which is not a required text for a class
  11. Title of the last movie you saw

In the table below is selected data for 31 Ed 602 students.

Data for Ed 602 Students
Number Sex Major Advisor Distance to Moorhead Favorite Color City Size Number of Siblings
1 F Spec Educ Beare 2 green 900 3
2 M Spec Educ Svobodny 4 blue 450 4
3 M Spec Educ Svobodny 5 red 50000 3
4 F Social Work Burke 2 blue 7000 2
5 F Nursing Vellenga 6 green 150000 2
6 F Spec Educ Mostert 5 blue 2000 3
7 F Counseling Patrick 4 blue 350 2
8 F Counseling Packwood 90 red 2700 1
9 M Ed Admin Van Berkum 80 red 400 3
10 F Reading Wasson 4 red 27000 3
11 F Counseling Patrick 1 blue 1200 2
12 F Counseling Patrick 6 purple 1200 2
13 F Spec Educ Mostert 5 blue 30000 1
14 F Counseling Packwood 5 black 90000 1
15 M Counseling Packwood 35 blue 325 2
16 M Ed Admin Van Berkum 1 blue 12000 2
17 F Spec Educ Beare 15 blue 300 2
18 F Reading Smedman 6 blue 400 5
19 F Music Ed Rothlisberger 30 blue 200 3
20 F Counseling Patrick 8 blue 2500 3
21 F Counseling Patrick 5 black 10000 2
22 M Counseling Packwood 8 blue 8000 4
23 F Counseling Packwood 4 red 75000 1
24 F Counseling Packwood 101 blue 35000 2
25 F Counseling Packwood 4 purple 8000 4
26 M Elem Ed Walker 10 purple 76000 2
27 F Counseling Packwood 5 purple 10000 2
28 M Ed Admin Van Berkum 100 green 500 4
29 M School Psy Potter 65 black 40000 2
30 F Nursing Vellenga 8 blue 600 0
31 F Nursing Vellenga 8 blue 47000 0

Your task for Assignment 2 is to put this data into a spreadsheet. It would be advisable to use the Microsoft Excel spreadsheet program as that program has data analysis tools built into the program which you can use to do all statistical calculations required for Ed 602.

Create a spreadsheet with eight columns, one for each of the variables in the table. Leave room at the top of your spreadsheet for your name, the assignment you are doing, and the name of the data that is in the spreadsheet (e.g. Data for Ed 602 Students). Also use a row or two for the column headings (e.g. Number, Sex, Major, etc.). Then enter all of the data in the next 31 rows of the spreadsheet.

Save the spreadsheet to a disk file so that you will have it available for use in future assignments. Send electronic mail to your instructor at wassonj@teleport.com and include the spreadsheet file as an attachment. Most email programs allow you to attach other files to sent messages.

Return to Ed 602 Lesson 2

Return to Ed 602 Home Page