Tbl1_SIRS_data

Description

This table imports and saves a summarized version of Instructor Rating values from SIRS surveys that are sent to us from CTAAR office. This data is importable and viewable from the Solutions Database SIRS Summary report category.

Relation

relates to tbl1_People on Tbl1_SIRS_Data.PersonID = tbl1_People.PersonID relates to tbl1_Courses on Tbl1_SIRS_Data.CourseID = tbl1_Courses.CourseID

Footnote

Values in this table are saved in analogous tbl1_Instructors_ClassesTaught fields after user saves

Columns

ID int(11) NOT NULL

Options

display="true", null="true", search="false", type=""

the_semester varchar(255) 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=""

Instructor varchar(255) DEFAULT NULL

Description

Instructor Name last, first

Options

display="true", null="true", search="false", type=""

PersonID int(11) DEFAULT NULL

Description

id of instructor

Relation

relates to PersionID field in tbl1_People table

Options

display="true", null="true", search="false", type=""

Term varchar(255) DEFAULT NULL

Description

Semester and Year together, for example “Fall 2018”

Footnote

do we need this?

Options

display="true", null="true", search="false", type=""

CourseNumber varchar(255) DEFAULT NULL

Description

Full course number in a format like this: 01:640:135:62

Options

display="true", null="true", search="false", type=""

CourseName varchar(255) DEFAULT NULL

Description

Course Name

Options

display="true", null="true", search="false", type=""

Index varchar(255) DEFAULT NULL

Description

5-digit index number

Options

display="true", null="true", search="false", type=""

Section varchar(15) DEFAULT NULL

Description

Section Number

Options

display="true", null="true", search="false", type=""

Enrollment smallint(6) DEFAULT NULL

Description

Section Enrollment

Options

display="true", null="true", search="false", type=""

Responses smallint(6) DEFAULT NULL

Description

Number of survey responses that were submitted

Options

display="true", null="true", search="false", type=""

Q9_Response_1 smallint(6) DEFAULT NULL

Description

Number of students who responded with 1 to question 9

Footnote

This and the following fields refer to question 9, which is “overall effectiveness of instructor”

Options

display="true", null="true", search="false", type=""

Q9_Response_2 smallint(6) DEFAULT NULL

Description

Number of students who responded with 2 to question 9

Options

display="true", null="true", search="false", type=""

Q9_Response_3 smallint(6) DEFAULT NULL

Description

Number of students who responded with 3 to question 9

Options

display="true", null="true", search="false", type=""

Q9_Response_4 smallint(6) DEFAULT NULL

Description

Number of students who responded with 4 to question 9

Options

display="true", null="true", search="false", type=""

Q9_Response_5 smallint(6) DEFAULT NULL

Description

Number of students who responded with 5 to question 9

Options

display="true", null="true", search="false", type=""

Q9_Response_none smallint(6) DEFAULT NULL

Description

Number of students who did not answer question 9

Options

display="true", null="true", search="false", type=""

Sec_Weighted_Mean float DEFAULT NULL

Description

Section weighted mean

Options

display="true", null="true", search="false", type=""

Course_Weighted_Mean float DEFAULT NULL

Description

Course Weighted Mean

Options

display="true", null="true", search="false", type=""

Level_Weighted_Mean float DEFAULT NULL

Description

Level Weighted Mean

Options

display="true", null="true", search="false", type=""

Dept_Weighted_Mean float DEFAULT NULL

Description

Department Weighted Mean

Options

display="true", null="true", search="false", type=""

observer_comments text DEFAULT NULL

Description

Comments taken from observer observations

Footnote

This field is not used in Solutions database. A small utility program called observer_reports.accdb is used by UG Office staff to view data in this field. The reason this was added was as a way to import the data that had originally been entered with Wufoo forms in a way that UGVC can view the reports in a nice format. It was agreed upon with Dept Chair to keep this outside of the standard Solutions Database application for time being. This field will likely also be expanded to hold data from observer reports moving forward, which is now done via chronoform submissions.

Options

display="true", null="true", search="false", type=""

CourseID int(11) DEFAULT NULL

Description

ID of course

Relation

relates to CourseID field in tbl1_Courses table

Options

display="true", null="true", search="false", type=""

comments mediumtext DEFAULT NULL

Description

A concatenated list of all student comments for this section

Options

display="true", null="true", search="false", type=""

comments_html mediumtext DEFAULT NULL

Description

Comments with HTML formatting left in

Footnote

Do we use this anywhere? Maybe in the SIRS report?

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=""