Code using Visual Basic

Fields that make up each record in the Courses.txt" file will be: Course-Section Instructor (First Last) Room Number (Fully online courses list the room as 'Online) Course Capacity Socially Distance Room Capacity Current Enrollment Instruction Method O B - Blended Course (Blended Section): Online + 16% to 84% face-to-face O WE - Web-Enhanced Course (Face-to-Face Section): At least 85% instruction face-to-face. Does not include cohort model attendance. WH - Web-Hybrid Course (Web Hybrid Section): Web Enhanced but with cohort model attendance. 0 - Online Course (Fully Online Section): At least 85% online and, generally, with no scheduled class times. O WR - Web-Enhanced Remote Course (Remote Section): At least 85% instruction delivered remotely through web-conferencing (Zoom) but only at the time listed in the schedule. O NW - No Web Component Course: No Web Activities Examples records: CIS115-101, Paul Overstreet 1308,34,17,22,WH CIS115-501, David Cobb,1306,30,15,20,WH ISC285-101, Melissa Smith, 2121,60,30,28, WE CIS300-801, Melissa Smith Online 30,30,32,0 CIS324-101,Ocllo Robinson,3304.30,15,27,B CIS321-101, Rhonda Lucas 3304.30,15,26,B The "Courses.txt" file should be create and stored in the projects bin Debug folder. It should contain the 6 sample records shown here along with 4 additional records that you create for a total of 10 records. This project will have one Class level array variable; courses. All other variables must be local. Load Event: At Load time, populate the courses array and display the records in an output listbox. The records ARE NOT to be divided into fields at this time. Display the records just as they appear in the array. This displaying of records is primarily for grading purposes it will let me make sure the records were created in a proper csv format and that the array was populated correctly. Available Courses Report Button Click Event: This event must use a LINQ to generate a list of all courses that are currently being offered (records in the file). The query should be created within the button click event and the query output should include separate fields (multiple field output): Course-Section Instructor Room Number Instruction Method The query results should place the records in Course-Section Ascending order. Once the query has been generated, the output listbox should be cleared and a meaningful header displayed followed by a blank line. After this blank line, each record in the query results should displayed in a well formatted fashion Selected Instruction Method Report Button Click Event: This event must use a LINQ to list all section that will be taught using a specified Instruction Method. The user will enter an Instruction Method via an inputbox and a query will be used to search for all courses that will be taught using that method. The output display should begin with a meaningful header. If sections of the course are located the following fields should be selected and displayed: - Course-Section Instructor - Course Capacity Current Enrollment If no courses are located that match the given Instruction Method, the user should receive a message in the listbox letting them know Be sure to clear the listbox before displaying either version of the output. Seat Shortage Report Button Click Event: This event must use a LINQ to determine which classes currently do not have enough seats to hold the number of students who have enrolled using the Socially Distance Room Capacity. Insure that Online Only courses will not be included in this list even if their Enrollment is greater than their Socially Distance Capacity. The following fields should be selected and displayed: Course-Section Room Number Socially Distance Room Capacity Current Enrollment Seat Shortage Value (the number of students who are enrolled over the Socially Distance Room Capacity) The query results should be placed in Descending Seat Shortage amount and Course-Section Ascending. Before displaying output to the listbox, be sure to clear the listbox. A meaningful header should be displayed followed by a blank line. For each item in the query results, all five fields should be displayed in a well formatted fashion. After all individual items have been displayed the total count showing the number of classes that will experience a seat shortage should be displayed too with meaningful text describing what the figure is showing. Fields that make up each record in the Courses.txt" file will be: Course-Section Instructor (First Last) Room Number (Fully online courses list the room as 'Online) Course Capacity Socially Distance Room Capacity Current Enrollment Instruction Method O B - Blended Course (Blended Section): Online + 16% to 84% face-to-face O WE - Web-Enhanced Course (Face-to-Face Section): At least 85% instruction face-to-face. Does not include cohort model attendance. WH - Web-Hybrid Course (Web Hybrid Section): Web Enhanced but with cohort model attendance. 0 - Online Course (Fully Online Section): At least 85% online and, generally, with no scheduled class times. O WR - Web-Enhanced Remote Course (Remote Section): At least 85% instruction delivered remotely through web-conferencing (Zoom) but only at the time listed in the schedule. O NW - No Web Component Course: No Web Activities Examples records: CIS115-101, Paul Overstreet 1308,34,17,22,WH CIS115-501, David Cobb,1306,30,15,20,WH ISC285-101, Melissa Smith, 2121,60,30,28, WE CIS300-801, Melissa Smith Online 30,30,32,0 CIS324-101,Ocllo Robinson,3304.30,15,27,B CIS321-101, Rhonda Lucas 3304.30,15,26,B The "Courses.txt" file should be create and stored in the projects bin Debug folder. It should contain the 6 sample records shown here along with 4 additional records that you create for a total of 10 records. This project will have one Class level array variable; courses. All other variables must be local. Load Event: At Load time, populate the courses array and display the records in an output listbox. The records ARE NOT to be divided into fields at this time. Display the records just as they appear in the array. This displaying of records is primarily for grading purposes it will let me make sure the records were created in a proper csv format and that the array was populated correctly. Available Courses Report Button Click Event: This event must use a LINQ to generate a list of all courses that are currently being offered (records in the file). The query should be created within the button click event and the query output should include separate fields (multiple field output): Course-Section Instructor Room Number Instruction Method The query results should place the records in Course-Section Ascending order. Once the query has been generated, the output listbox should be cleared and a meaningful header displayed followed by a blank line. After this blank line, each record in the query results should displayed in a well formatted fashion Selected Instruction Method Report Button Click Event: This event must use a LINQ to list all section that will be taught using a specified Instruction Method. The user will enter an Instruction Method via an inputbox and a query will be used to search for all courses that will be taught using that method. The output display should begin with a meaningful header. If sections of the course are located the following fields should be selected and displayed: - Course-Section Instructor - Course Capacity Current Enrollment If no courses are located that match the given Instruction Method, the user should receive a message in the listbox letting them know Be sure to clear the listbox before displaying either version of the output. Seat Shortage Report Button Click Event: This event must use a LINQ to determine which classes currently do not have enough seats to hold the number of students who have enrolled using the Socially Distance Room Capacity. Insure that Online Only courses will not be included in this list even if their Enrollment is greater than their Socially Distance Capacity. The following fields should be selected and displayed: Course-Section Room Number Socially Distance Room Capacity Current Enrollment Seat Shortage Value (the number of students who are enrolled over the Socially Distance Room Capacity) The query results should be placed in Descending Seat Shortage amount and Course-Section Ascending. Before displaying output to the listbox, be sure to clear the listbox. A meaningful header should be displayed followed by a blank line. For each item in the query results, all five fields should be displayed in a well formatted fashion. After all individual items have been displayed the total count showing the number of classes that will experience a seat shortage should be displayed too with meaningful text describing what the figure is showing