70.2K

Verified Solution

Link Copied!

Create a Sub procedure in Module with appropriate variables, or constants,and data types to calculate the total amount of tuition and fees that a student has to pay. Different academic programs charge course fees differently. The course fee table is available on the next page.

Any student taking 4 or more courses in a semester is considered a full-time student, otherwise the student is considered a part-time student. All full-time students must pay regular university fees, charged at $1,500 plus $300 for each course taken. Part-time students pay a reduced regular university fees, charged at $1,500 plus $150 for each course taken.

For local students:In addition to the regular university fees, a local student must pay a tuition based on the local student fee per course, as given in the course fee table below. A local student taking more than 7 courses must also pay an extra $1,000 of tuition per course in excess of 7.

For non-local students:In addition to the regular university fees, a non-local student must pay a tuition based on the non-local student fee per course, as given in the course fee table below. For any extra credits exceeding the 7 courses limit will be charged an additional $2,500 per course. Non-local students must take at least 4 courses per semester.

Your application should use input box functions (traditional input boxes) to prompt the user to input all mandatory information, including(1) full name, (2) gender:male or female, (3) academic program code, and (4) status:local or non-local.Then the user needs to enter the total number of courses he or she is taking.The application should incorporate appropriate data validation and error handling mechanisms to avoid input/execution error and display the fees results. It calculates the fees and displays students full name, faculty, academic program code and name, tuition fee, university fees, and the total fees(equals to the sum of the tuition fee and university fees)with appropriate currency format, icon, title and current date. If the response of the result message box is to retry, the application will show all the input boxes and repeat the process again. If the response is to cancel, the application ends.

Course Fee Table Academic Program Code Name Course Fee per Course Local Non-local Students Students $3,225 $3,600 $3,225 $3,750 $4,125 $4,125 $4,125 $4,750 $3,775 $3,775 $3,775 $3,775 $5,625 $5,625 $5,625 $5,625 $4,737 $5,750 Faculty of Arts (ART) ART01 Bachelor of Arts ARTO2 Bachelor of Media Communication ART03 Bachelor of Criminology ART04 Bachelor of Politics and Philosophy Faculty of Business And Economics (BEC) BECO1 Bachelor of Marketing BECO2 Bachelor of Accounting BECO3 Bachelor of Economics BEC04 Bachelor of Banking and Finance Faculty of Engineering (ENGR) ENG01 Bachelor of Engineering Faculty Of Information Technology (INTE) INT01 Bachelor of Information Technology INTO2 Bachelor of Computer Science INTO3 Bachelor of Business Information Systems INT04 Bachelor of Information Technology and Systems Faculty of Law (LAW) LAWO1 Bachelor of Laws Faculty of Science (SCI) SCIO1 Bachelor of Science SCIO2 Bachelor of Medical Bioscience SCIO3 Bachelor of Food Science SCI04 Bachelor of Applied Data Science $4,200 $4,200 $4,200 $5,350 $$5,350 $$5,350 $$5,350 $4,200 $4,875 $5,250 $4,437 $4,437 $4,437 $4,437 $5,437 $5,437 $5,437 $5,437 Course Fee Table Academic Program Code Name Course Fee per Course Local Non-local Students Students $3,225 $3,600 $3,225 $3,750 $4,125 $4,125 $4,125 $4,750 $3,775 $3,775 $3,775 $3,775 $5,625 $5,625 $5,625 $5,625 $4,737 $5,750 Faculty of Arts (ART) ART01 Bachelor of Arts ARTO2 Bachelor of Media Communication ART03 Bachelor of Criminology ART04 Bachelor of Politics and Philosophy Faculty of Business And Economics (BEC) BECO1 Bachelor of Marketing BECO2 Bachelor of Accounting BECO3 Bachelor of Economics BEC04 Bachelor of Banking and Finance Faculty of Engineering (ENGR) ENG01 Bachelor of Engineering Faculty Of Information Technology (INTE) INT01 Bachelor of Information Technology INTO2 Bachelor of Computer Science INTO3 Bachelor of Business Information Systems INT04 Bachelor of Information Technology and Systems Faculty of Law (LAW) LAWO1 Bachelor of Laws Faculty of Science (SCI) SCIO1 Bachelor of Science SCIO2 Bachelor of Medical Bioscience SCIO3 Bachelor of Food Science SCI04 Bachelor of Applied Data Science $4,200 $4,200 $4,200 $5,350 $$5,350 $$5,350 $$5,350 $4,200 $4,875 $5,250 $4,437 $4,437 $4,437 $4,437 $5,437 $5,437 $5,437 $5,437

Answer & Explanation Solved by verified expert

See Answer