CIS 2110 Homework Assignment #3 Problem Statement, I/O Design and Walk-throughs Last modified: September 6, 2017 Learning Objectives: To demonstrate the student's level of competence in: The first two steps in problem solving, the Problem Statement and I/O Design Walk-throughs (Humanual and Program Level) Assignment: Consider the following Problem: Dr. Abel Moreno, CIS Department Chair, requires a report to display the Term, and for that term the Faculty Id Number, Number of Sections Taught, and the Number of Students Taught by each faculty member in the CIS Department. After the data for all faculty has been shown a summary must display the overall Total number of Sections Taught, Total Number of Students Taught, and Average Number of Students Taught per Faculty in the department (total students divided by total faculty) for that term. Additionally, the report must display the Faculty Id Number for the faculty member with that highest number of students. It must also display the Number of Students Taught for that faculty member. In the event of multiple instances of the highest only the first instance need be reported. The department is willing to input the Term (which is input once) and for that term the Faculty Id Number, Number of Sections Taught, and the Number of Students Taught (in that order) for each faculty member in the CIS Department. The -1 value for faculty id number indicates the end of faculty entries. A subset of data for the semester is given below for you to test your models. For the problem described above: Formulate the Statement of this Problem Develop the I/O Design for this Problem Using the data from HW03 Test Data Develop a Humanual Level Walk-through for this Problem (Humanual Level Walk-throughs have ONLY the "Input & Output" fields) Develop a Program Level Walk-through for this Problem (Program Level Walk-throughs have the "Input, Output & Working Storage" fields) Note: It is recommended that you review appropriate parts of the example project that appears at the end of Chapter 3 in the textbook prior to commencing work on this assignment. Submission Instructions: The problem statement and I/O Design should be completed using a word processor such as Word. The walkthroughs should be completed using a spreadsheet application such as Excel. TEST DATA 1 A B C D E 2 TERM FACULTY ID SECTIONS STUDENTS 3 4 FALL 2017 111 4 105 5 222 4 125 6 333 3 90 7 444 4 125 8 555 4 110 9 -1