Answered step by step
Verified Expert Solution
Link Copied!

Question

1 Approved Answer

Develop a simple application for calculating students tuition fees. Save your work regularly. Create a Sub procedure in Module with appropriate variables, or constants, and

Develop a simple application for calculating students tuition fees.

Save your work regularly.

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.

For local students:

Any student taking 12 or more credits is considered a full-time student, otherwise the student is a part-time student. A full-time local student taking 12 to 21 credits (inclusively) pays a regular tuition of $21,050 per semester. A student taking more than 21 credits has to pay an extra $2,670 of tuition for each credit in excess of 21. A part-time student who takes 8 credits or less, pays half of the regular tuition, otherwise, regular tuition.

For non-local students:

A non-local student pays $60,000 per semester for taking 12 to 21 credits (inclusive). For any extra credits exceeding the 21 credits limit will be charged $4,030 per credit. Non-local students must take at least 12 credits per semester.

All local and non-local students, whether full-time or part-time, must also pay university fees. The total of these fees is given by a flat amount of $400 plus $50 for each credit taken.

Your program should use input boxes functions (traditional input boxes) to ask the student to input the (1) full name, (2) gender: M for male and F for female, and (3) status for local or non-local. Then the student needs to enter the total number of credits he or she is taking. The program should incorporate appropriate data validation mechanism to avoid input error and execution error. It calculates the fees and displays students full name, the 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 date in the form as shown in the following figures.

image text in transcribed

You may check your work with these numbers:

Total number of Credits

Status

Total Tuition

Total Fees

Total Balance

6

Local

$10525

$700

$11225

12

Local

$21,050

$1,000

$22,050

24

Local

$29,060

$1,600

$30,660

15

Non-local

$60,000

$1,150

$61,150

24

Non-local

$72,090

$1,600

$73,690

Tuition & Fees Calculator as at 1/16/2018 Based on your inputs local student and 18 credits: Your tuition fee is $21,050.00 Your university fees is $1,300.00 Your Total fees is $22,350.00 OK Tuition & Fees Calculator as at 1/16/2018 Based on your inputs local student and 18 credits: Your tuition fee is $21,050.00 Your university fees is $1,300.00 Your Total fees is $22,350.00 OK

Step by Step Solution

There are 3 Steps involved in it

Step: 1

blur-text-image

Get Instant Access to Expert-Tailored Solutions

See step-by-step solutions with expert insights and AI powered tools for academic success

Step: 2

blur-text-image_2

Step: 3

blur-text-image_3

Ace Your Homework with AI

Get the answers you need in no time with our AI-driven, step-by-step assistance

Get Started

Recommended Textbook for

Larry Ellison Database Genius Of Oracle

Authors: Craig Peters

1st Edition

0766019748, 978-0766019744

More Books

Students also viewed these Databases questions

Question

3. How would this philosophy fit in your organization?

Answered: 1 week ago

Question

How would you assess the value of an approach like this?

Answered: 1 week ago