tbl1_survey_responses¶
- Description
Data table containing all survey responses from Teaching Availability and Preferences survey and each instructors’ response answers
- Source
Data originally comes from Qualtrics, where surveys are created
- Footnote
Future: associate people with tbl1_People table instead of only having netid here Also, this table has an annoying design where the course fields have prefixes like “BS001” for “basic skills” course 001 and “Calc291” for calculus course 291. This program would be improved if we instead had the field names just be full course number like: 01640135. We could add a CourseID field to this table to related the question to the tbl1_Courses table
Columns¶
ID int(11) NOT NULL AUTO_INCREMENT
- Options
display="true", null="true", search="false", type=""
the_semester varchar(50) DEFAULT NULL
- Description
Fall, Spring or Summer
- Options
display="true", null="true", search="false", type=""
the_year smallint(6) DEFAULT NULL
- Description
Semester Year
- Options
display="true", null="true", search="false", type=""
selected tinyint(1) DEFAULT 0
- Description
Corresponds to checkbox to the left of each instructor response. TRUE if checked.
- Options
display="true", null="true", search="false", type=""
first_name varchar(255) DEFAULT NULL
- Description
Instructor First Name
- Options
display="true", null="true", search="false", type=""
last_name varchar(255) DEFAULT NULL
- Description
Instructor Last Name
- Options
display="true", null="true", search="false", type=""
response_date datetime DEFAULT NULL
- Description
Resonse Date
- Options
display="true", null="true", search="false", type=""
netid varchar(255) DEFAULT NULL
- Description
instructor’s netid
- Options
display="true", null="true", search="false", type=""
email varchar(255) DEFAULT NULL
- Description
instructor’s email
- Options
display="true", null="true", search="false", type=""
Role varchar(255) DEFAULT NULL
- Description
Person’s Role: Faculty, Annual, PTL or Graduate Student
- Options
display="true", null="true", search="false", type=""
load smallint(6) DEFAULT NULL
- Description
self-reported teaching load from survey question
- Footnote
at time of writing this, we are embarking on a survey rewrite where we will already have the instructors’ load at time of survey and tell them instead of having them self-report
- Options
display="true", null="true", search="false", type=""
GradCourse bit(1) DEFAULT NULL
- Description
corresponds to “Do you plan on teaching a graduate course” question
- Options
display="true", null="true", search="false", type=""
Assignment bit(1) DEFAULT NULL
- Description
corresponds to “Do you expect a teaching assignment this semester?” question
- Options
display="true", null="true", search="false", type=""
NumCourses smallint(6) DEFAULT NULL
- Description
Corresponds to “How many courses do you want to teach this semester?” question
- Options
display="true", null="true", search="false", type=""
PTLRecWrk bit(1) DEFAULT NULL
- Description
Corresponds to PTL question “Lecturing assignments may not always be available. Would you like to be considered for Recitation/Workshop assignments as well?”
- Options
display="true", null="true", search="false", type=""
HeadTA bit(1) DEFAULT NULL
- Description
Corresponds to “Would you like to be considered for Head TA?” question
- Options
display="true", null="true", search="false", type=""
ppMH1 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Monday/Thursday Period 1
- Footnote
1=Preferred, 2=OK, 3=Possible but inconvenient, 4=impossible. Same for all period or period-pair preference fields
- Options
display="true", null="true", search="false", type=""
ppTF1 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Tuesday/Friday Period 1
- Options
display="true", null="true", search="false", type=""
ppMH2 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Monday/Thursday Period 2
- Options
display="true", null="true", search="false", type=""
ppTF2 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Tuesday/Friday Period 2
- Options
display="true", null="true", search="false", type=""
ppW2F5 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Wed P2/Friday P5
- Options
display="true", null="true", search="false", type=""
ppMH3 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Monday/Thursday Period 3
- Options
display="true", null="true", search="false", type=""
ppTF3 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Tuesday/Friday Period 3
- Options
display="true", null="true", search="false", type=""
ppW3F4 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for period pair Wed Period 3 / Friday Period 4
- Options
display="true", null="true", search="false", type=""
ppMW4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppMW5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppMW6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppMW7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppMW8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppMW9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
ppTH9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
PPCampus varchar(255) DEFAULT NULL
- Description
Preferred campus when asked the period-pair question
- Options
display="true", null="true", search="false", type=""
PPOther varchar(255) DEFAULT NULL
- Description
Other comments about availability when asked the period-pair question
- Options
display="true", null="true", search="false", type=""
perM1 smallint(6) DEFAULT NULL
- Description
Ranking of availability preference for Monday Period 1
- Footnote
1=Preferred, 2=OK, 3=Possible but inconvenient, 4=impossible. Same for all period or period preference fields
- Options
display="true", null="true", search="false", type=""
perM2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perM9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT1 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perT9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW1 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perW9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH1 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perH9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF1 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF3 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF5 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF7 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perF9 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
perCampus varchar(255) DEFAULT NULL
- Description
Preferred campus when asked period question
- Options
display="true", null="true", search="false", type=""
PerOther varchar(255) DEFAULT NULL
- Description
other notes when asked the period question
- Options
display="true", null="true", search="false", type=""
BS001 smallint(6) DEFAULT NULL
- Description
Survey answer for course 001
- Footnote
Response values for this and all other course fields: 1=Strong Preference, 2=I have no problems with teaching this course, 3=I would rather not teach this course, but can do so if necessary 4=This course is not appropriate for me, please do not assign it.
- Options
display="true", null="true", search="false", type=""
BS023 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS025 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS026 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS111 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS112 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS115 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
BS123 smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
10X103 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X104 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X105 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X106 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X107 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X108 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X109 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
10X110 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc135 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc135_Star smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc136 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc138 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc151 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc151H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc152 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc152H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc191 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc191_Star smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc192 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc192_Star smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc196 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc251 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc251H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc291 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Calc291_Star smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL244 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL250 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL250C smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL252 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL285 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL292 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
LL292_Star smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL300 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL300H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL311 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL311H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL312 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL321 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL325 int(11) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL336 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL338 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL348 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL350 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL350H smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL351 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL354 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL355 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL356 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL357 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL361 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL373 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL403 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL411 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL412 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL421 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL423 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL424 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL428 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL432 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL435 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL436 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL437 smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
UL441 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL442 smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
UL451 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL452 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL453 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL454 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL461 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL468 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL477 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL478 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL481 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL485 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL486 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL487 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL492 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL493 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
UL495 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
R_CompDaily smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
R_CompWeek smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
R_MinCrsPrep smallint(6) DEFAULT NULL
- Options
type="", null="true", search="false", display="true"
ULOther varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummerTch smallint(6) DEFAULT NULL
- Description
This corresponds with the “Do you want a summer teaching assignment” question
- Options
display="true", null="true", search="false", type=""
Summer_B bit(1) DEFAULT NULL
- Description
This and subsequent Summer_X fields represent the availability questions for each series of summer dates when we might offer courses.
- Footnote
values 1-4 with 1 being best availability
- Options
display="true", null="true", search="false", type=""
Summer_C bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Summer_E bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Summer_F bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Summer_H bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
Summer_T bit(1) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM8 smallint(6) DEFAULT NULL
- Description
availability for Summer Monday period 8
- Options
display="true", null="true", search="false", type=""
SummTimesT8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF8 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM10 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesT10 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW10 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH10 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF10 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM12 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesT12 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW12 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH12 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF12 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesT2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF2 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesT4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF4 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesM6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesT6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesW6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesH6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummTimesF6 smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummOther varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SumHowMany smallint(6) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummOther2 varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
SummCampus varchar(255) DEFAULT NULL
- Options
display="true", null="true", search="false", type=""
last_change timestamp NOT NULL DEFAULT current_timestamp() ON UPDATE current_timestamp()
- Options
display="true", null="true", search="false", type=""