End Semester Final Exams University S Qa Office Prepares Conducts Course Lecture Evaluatio Q26140269
At the end of Semester, and before the final exams, theUniversity’s QA Office prepares and conducts ‘Course and LectureEvaluation’ activity. Student answers each Survey question bymarking letters A,B,C,D and E on the main Survey Form. Uponcompletion of student evaluation, all answered forms for eachcourse are collected and placed in separate envelop. After that,student answers are processes using OMR (Optical Mark Reader)Scanner and results of each Course is saved in a separate textfiles. As we could see, a student answers data are divided into 5sections as following: – Section 0: Internal Code (should not beanalyzed) – Section 1: Lecturer evaluation (16 questions ->Question 1 to 16 ) – Section 2: Course Design Evaluation ( 6questions -> Question 17 to 22) – Section 3: Assistant No 1Evaluation ( 6 question -> Question 23 to 28) – Section 4:Assistant No 2 Evaluation ( 6 question -> Question 29 to 34) –This section should be used only if there are two assistantsassigned to a specific course
NOTES: – The First 10 characters (4 numbers and 6 blank spaces)represent the internal code which should not be considered in thisdata analyses. – Each raw in the test files represent answers givenby one specific student. – Each test file characters from 11thposition to the end of raw represent student answers to a specificquestion (Section 1, Section 2, Section 3 and Section 4). 3. UsingC++ or Java, develop an console application which willautomatically read and analyze all test data files (one by one) anddo the calculation as following: a. Each student’s answer presentedby letters A,B,C,D and E should have its equivalent numerical valueas following A=4, B=3, C=2, D=1 and E=0 b. Your application shouldcreate a folder on the hard drive named ‘survey_calc’ which will beused for exporting analyzed course data. c. For each given testdata file e.g. ‘Course1.txt’ add appropriate programming code tocreate CSV file with structure as following:Student1,AnswerToQuestion1,AnswerToQuestion2, …,AnswerToQuestion34Student2,AnswerToQuestion1,AnswerToQuestion2, …,AnswerToQuestion34… Studentn,AnswerToQuestion1,AnswerToQuestion2,…,AnswerToQuestion34 as presented on the following picture NOTES: The first 10 characters of the input files are not relevant forthis analysis and should be ignored and should not be the part ofexported CSV files. If there is no student answer for specificquestion a blank space character should be used. Data should beexported to an CSV files and placed into previously created foldernamed ‘survey_calc’ . CSV filename should be similar to theinitial test data file name but with extension .CSV e.g.“Course1_calc.csv’ d. For each Course your application shouldcalculate average value of student’s answers for each question.Final results for all 10 Courses should be exported in file named‘Survey_Average_Calc.csv’ and saved in ‘survey_calc’ folder andshould be in the form as following:CourseName,NoOfStudents,Q1,Q2,…, Q34CourseName,NoOfStudents,Q1,Q2,…, Q34 …CourseName,NoOfStudents,Q1,Q2,…, Q34 Where NoOfStudents is thenumber of students that participate this survey.