.. index:: Tbl1_SIRS_data ============== Tbl1_SIRS_data ============== .. default-role:: doc :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=""``