To enter Your Data, use the anonymous or non-anonymous form.
These data represent reports by candidates of their academic job offers in Information Systems for the academic year 1998-1999. A new survey will begin for the next academic year in September 1998.
The final results are now available in Excel 4 format, including some analysis. Further analysis is available at www.pitt.edu/~galletta/1998anal.html. The data in HTML, sorted by submission number, are below.
# | Salary | Summer Support |
Moving Support |
Course Load |
Position | Campus type |
Country | Accepted? |
1 | 70,000 | 1000 | 10 | associate | urban | won't accept | ||
2 | 35,000 | 0 | 1500 | 8 | associate | suburban | might accept | |
3 | 45,000 | 6 | Asst | urban | Have accepted | |||
4 | 65,000 | 4000 | 6 | switched Asst | urban | Have accepted | ||
5 | 70,000 | 6,000 | 5 | Asst | suburban | might accept | ||
6 | 75,000 | 16,667 | 3500 | 4 | Asst | suburban | USA | might accept |
7 | 64,000 | 7,111 | 0 | 5 | Asst | urban | USA | Have accepted |
8 | 75,000 | 17,000 | 3,500 | 4 | Asst | urban | USA | might accept |
9 | 65,000 | 3,000 | 3,000 | 6 | Asst | suburban | USA | Have accepted |
10 | 62,000 | 0 | 0 | 6 | Asst | suburban | USA | won't accept |
11 | 61,500 | 6,000 | 5,000 | 5 | Asst | suburban | USA | won't accept |
12 | 64,000 | 6,000 | 3,200 | 5 | Asst | suburban | USA | might accept |
13 | 69,000 | 12,420 | 5 | Asst | suburban | USA | Have accepted | |
14 | 60,000 | 0 | 0 | 5 | Asst | urban | USA | might accept |
15 | 72,000 | 12,960 | 1,500 | 5 | Asst | suburban | USA | won't accept |
16 | 63,000 | 12,600 | 4,200 | 5 | associate | suburban | Canada | Have accepted |
17 | 72,000 | 12,960 | 5,000 | 5 | switched Asst | suburban | USA | won't accept |
18 | 76000 | 9,500 | 3,500 | 5 | Asst | suburban | USA | won't accept |
19 | 68000 | 13,600 | 2,000 | 6 | Asst | suburban | USA | won't accept |
20 | 65000 | 7,875 | 3,000 | 6 | Asst | urban | USA | Have accepted |
21 | 74,000 | 13,000 | 2,500 | 4 | Asst | suburban | USA | Have accepted |
22 | 70,000 | 15,000 | 4 | Asst | urban | USA | Have accepted | |
23 | 70,000 | 6,300 | 0 | 4 | switched Asst | suburban | USA | might accept |
24 | 45,000 | 2,000 | 4 | switched Asst | urban | Canada | unspecified | |
25 | 62,000 | 6 | Asst | suburban | USA | Have accepted | ||
26 | 81,000 | 18,000 | 500 | 3 | Asst | urban | USA | might accept |
27 | 72,000 | 6,000 | 3,000 | 4 | Asst | unspecified | USA | might accept |
28 | 76,000 | 19,000 | 5,000 | 2-3 | Asst | urban | NOT North America | won't accept |
29 | 75000 | 16667 | 8333 | 4 | Asst | suburban | USA | won't accept |
30 | 63000 | 4000 | 35000 | 5 | Asst | urban | USA | might accept |
31 | 67000 | 0 | 1000 | 4 | Asst | suburban | USA | won't accept |
32 | 70000 | 15000 | Actual Expenses | 4 | Asst | urban | USA | won't accept |
33 | 60,000 | 12,000 | 0 | 6 | Asst | urban | USA | might accept |
34 | 65,000 | 7,222 | 1,000 | 5 | Asst | urban | USA | Have accepted |
35 | 65,000 | 13,000 | NA | 6 | Asst | urban | USA | Have accepted |
36 | 78,000 | 16,000 | 5,000 | 4 | switched Asst | suburban | USA | won't accept |
37 | 80,000 | 16,000 | 4,500 | 4 | switched Asst | suburban | USA | Have accepted |
38 | 76,000 | 15,200 | 3,000 | 4 | switched Asst | urban | USA | won't accept |
39 | 85,000 | 17,000 | 5,000 | 4 | switched Asst | suburban | USA | Have accepted |
40 | 62,000 | 0 | 0 | 6 | Asst | suburban | USA | won't accept |
41 | 50,000 | 0 | 2,000 | 6.5 | Asst | suburban | USA | won't accept |
42 | 65,000 | 0 | 5,000 | 4 | Asst | urban | USA | won't accept |
43 | 84,000 | 18,667 | all costs | 4 | switched Asst | suburban | USA | Have accepted |
44 | 77,000 | 17,111 | all costs | 4 | switched Asst | suburban | USA | won't accept |
45 | 82,000 | 16,400 | 4,000 | 4 | switched Asst | suburban | USA | might accept |
46 | 63,000 | 0 | 2,000 | 6 | Asst | suburban | USA | won't accept |
47 | 65,000 | 7,200 | 4,0000 | 3/3 | Asst | suburban | USA | won't accept |
48 | 65,000 | 0 | 4,000 | 2/3 | Asst | urban | USA | won't accept |
49 | 65,000 | 0 | 1,000 | 5 | Asst | suburban | USA | might accept |
50 | 68,000 | 5,000 | 5,000 | 2/3 | Asst | urban | USA | Have accepted |
51 | 84,000 | 7,000 | 9,000 | 5 | associate | urban | USA | won't accept |
52 | 85,000 | 0 | 0 | Asst | urban | USA | Have accepted | |
53 | 75,500 | 16,000 | 250 | 4 | Asst | urban | USA | won't accept |
54 | 75,000 | 16,667 | 3,000 | 4 | Asst | urban | USA | Have accepted |
55 | 65,000 | 0 | 2,000 | 6 | switched Asst | suburban | USA | Have accepted |
56 | 63,000 | 0 | 2,000 | 6 | switched Asst | suburban | USA | Have accepted |
57 | 71,000 | 16,000 | 9,000 | 3.5 | Asst | urban | USA | won't accept |
58 | 79,000 | 10,000 | 4 | Asst | suburban | USA | won't accept | |
59 | 80,000 | 18,000 | 3,500 | 3 | Asst | urban | USA | Have accepted |
60 | 85,000 | 19,000 | 5,000 | 3 | Asst | urban | won't accept | |
61 | 76,000 | 10,000 | 2 | Asst | suburban | Not USA | won't accept | |
62 | 70,000 | 8,000 | 3,000 | 4 | Asst | suburban | USA | might accept |
63 | 72,000 | 8,000 | Actual | 4 | Asst | suburban | USA | might accept |
64 | 61,000 | 5,400 | 0 | 6 | Asst | suburban | USA | Have accepted |
65 | 63,000 | 4,000 | 2,500 | 5 | Asst | urban | USA | won't accept |
66 | 70,000 | 8,000 | 3,000 | 4 | Asst | suburban | USA | Have accepted |
67 | 63,000 | 9,500 | ? | 4 | Asst | urban | USA | won't accept |
68 | 68,000 | 6,800 | 1,000 | 6 | Asst | suburban | USA | Have accepted |
69 | 84,000 | 18,667 | 6,000 | 3 | switched Asst | urban | USA | Have accepted |
70 | 66,000 | 13,200 | 6,600 | 4 | Asst | suburban | USA | Have accepted |
71 | 75,000 | 15,000 | 5,000 | 4 | Asst | suburban | USA | Have accepted |
72 | 65,000 | 6,000 | 3,500 | 5 | Asst | suburban | USA | won't accept |
73 | 68,000 | 5,000 | 3,000 | 5 | Asst | urban | USA | won't accept |
74 | 68,000 | 2,500 | 2,000 | 6 | Asst | suburban | USA | won't accept |
75 | 70,000 | 15,556 | 4,000 | 4 | Asst | suburban | USA | Have accepted |
76 | 65,000 | 8,000 | 3,000 | 5 | Asst | urban | USA | Have accepted |
77 | 72,000 | 3,000 | 2,000 | 3 | associate | suburban | USA | won't accept |
78 | 68,000 | 0 | 6 | switched Asst | suburban | USA | won't accept | |
79 | 67,000 | 6,000x3 | 3,000 | 6 | Asst | urban | USA | won't accept |
80 | 60,000 | 0 | 1,500 | 4 | Asst | urban | Canada | might accept |
81 | 68,000 | 6,500 | 2,000 | 4 | Asst | urban | US | Have accepted |
82 | 72,000 | 16,000 | 4,000 | 4 | Asst | urban | USA | Have accepted |
83 | 65,000 | 0 | 4,000 | 4 | Asst | suburban | USA | won't accept |
84 | 62,000 | 15,500 | 0 | 5 | Asst | urban | USA | Have accepted |
85 | 65,000 | 4,000 | 2,500 | 5 | Asst | urban | USA | Have accepted |
86 | 65,000 | 0 | actual cost | 6 | Asst | suburban | USA | Have accepted |
87 | 65,000 | 4,000 | 2,000 | 6 | Asst | urban | US | Have accepted |
88 | 64,000 | 8,000 | 7,100 | 4.5 | switched Asst | hard to tell | USA | won't accept |
89 | 65,000 | 0 | 3,000 | 9 | switched Asst | urban | USA | won't accept |
90 | 70,000 | 10,000 | 4,000 | 6 | switched Asst | urban | USA | Have accepted |
91 | 74,000 | 16,000 | 4,000 | 4 | Asst | suburban | usa | Have accepted |
92 | 65,000 | 5,000 | 3,000 | 6 | switched Asst | urban | USA | won't accept |
93 | 85,000 | 10,000 | 5,000 | 5 | associate | urban | US | won't accept |
94 | 73,000 | 8,000 | 2,500 | 4 | switched Asst | urban | USA | Have accepted |
95 | 60,000 | 6,000 | 1,500 | 6 | switched Asst | suburban | USA | won't accept |
96 | 72,000 | 0 | 3,000 | 4 | Visitor | suburban | USA | Have accepted |
97 | 72,000 | 14,000 | 3,000 | 3.75 | switched Asst | urban | USA | won't accept |
98 | 65,000 | 5,000 | 3,000 | 5 | switched Asst | suburban | USA | Have accepted |
99 | 60,000 | 1,000 | 6 | switched Asst | suburban | USA | won't accept | |
100 | 67000 | 10000 | 4500 | 6 | switched Asst | suburban | USA | Have accepted |
101 | 78,500 | 5,000 | 3,000 | 6 | associate | suburban | U.S.A. | won't accept |
102 | 90,000 | 20,000 | 10,000 | 4 | switched Asst | suburban | USA | Have accepted |
103 | 55,000 | 6,000 | 0 | 24 | Asst | suburban | USA | Have accepted |
104 | 65,000 | 0 | 2,000 | 6 | switched Asst | suburban | USA | Have accepted |
105 | 52,000 | 0 | 0 | 6 | Asst | suburban | USA | Have accepted |
106 | 85,000 | 5,000 | 3,000 | 4 | associate | urban | USA | won't accept |
107 | 69,000 | 7500 | 4 | switched Asst | suburban | USA | Have accepted | |
108 | 59,000 | 6,600 | 3,000 | 6 | Asst | suburban | USA | won't accept |
109 | 71,000 | 12,000 | 5,000 | 5 | Asst | suburban | USA | Have accepted |
Click and drag all of the cells, copy to the clipboard, then paste into a spreadsheet package. This works perfectly with Excel 97 (with Internet Explorer 4.01); but does not work well Netscape* or when using Lotus1-2-3 version 97 (even when parsing columns). You can then analyze the data by sorting by fields of interest, removing rows, computing averages, etc. One very practical approach for department heads to argue for parity is to focus only on schools with teaching loads similar to yours.
*Note: Thanks are in order for Mary Brabston and Vance Cooney. Mary helped me learn about the incompatibility between Netscape and Excel for the procedure outlined above. Vance Cooney of Xavier offers a remedy: "Since I use Netscape exclusively, I saved it as a text file then opened the saved file in Word and did some global replaces to clean it up for import. Once in a database program like Access or FileMaker Pro its cake to select by rank and/or load etc. to slice and dice the data."
The object of interest is offers, which might contain duplicates. If this concerns you, sort by the "accepted" field before using the data, then concentrate on "Have accepted" in your analysis; these will be unique records. Also, there is not a time period associated with teaching load or summer support, and it is too late to add this field (sorry, Varun Grover)! Finally, after the site was up for 10 hours (5 submissions between midnight and 8 AM EST), an excellent suggestion by Rita Walczuch caused me to bite the bullet and add the "country" field. The odd results in the first 3 offers are nearly impossible to interpret without it. Subsequent suggestions probably need to wait for future years, given the impracticality of converting the data.