IN VISUAL BASIC

Problem Statement

You are to create a project for a census bureau to obtain and analyze household income survey data within the Cincinnati area (including Northern Ky).

Must Include:

a. modular program using User Defined Functions and Procedures

b.Arrays and Parallel Arrays

c.String Manipulation techniques

Data Collected:

Home identification code (4 alphanumeric characters) required

Program should generate it using a random number generator (there is a function for this.

Date of the survey required (use datetime picker control), must be a valid date

County and State (1 input only) they reside in - required

Hamilton, Oh

Butler, Oh

Clermont, Oh

Warren, Oh

Campbell, Ky

Boone, Ky

Kenton, Ky

Number in Household required, must be numeric, must be greater than 0

The household yearly income required, must be numeric, must be greater than 0.

Events:

There should be 5 buttons on the screen:

1.Submit: This event will validate all data and save the data to the necessary arrays for processing.

2.Exit: This event will exit the application

3.Total Households Surveyed: This event will process the arrays and display the total households surveyed by state and then by county in a Message box (see below for example).

4.Average Household Income: This event will process the arrays and display the average household income by state and then by county in a Message box (see below for example).

5.Percentage Below Poverty: This event will process the arrays and display the Percentage Below Poverty for each state and their counties in a Message Box. Poverty is based on the table below.

Instructions:

1)Create a well designed modular program based on design techniques taught.

2)Use good naming conventions on all objects, variables, procedures, functions, etc.

3)Make sure all functions and procedures are called down.

4)Option Strict and Option Explicit must be on

5)All survey data from the GUI must be saved to parallel arrays (a total of 5) upon submission of each census. No calculations should be done until the following buttons are clicks.

6)When the user clicks the button Total Households Surveyed, do the necessary array processing and display in a Message box the Total Households Surveyed by State and by county for all that were surveyed (see below for example).

7)When the user clicks the button Average Household Income, do the necessary array processing and display in a Message box the Average Household Income by State and by county for all that were surveyed (see below for example).

8)When the user clicks the button Percentage Below Poverty, do the necessary array processing and display in a Message box the Percentage Below Poverty by State and by county for all that were surveyed (see below for example).

Average Household Income

Ohio: $30,000

Hamilton: $40,000

Butler: $20,000

Clermont: $30,000

Warren: $30,000

Kentucky: $35,000

Boone: $40,000

Campbell: $30,000

Kenton: $35,000

Basis of Poverty:

Household of 1 and less than $12,000

Household of 2 and less than $18,000

Household of 3 and less than $25,000

Household of 4 and less than $30,000

Household of 5 or more and less than $40,000