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
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
Step by Step Solution
There are 3 Steps involved in it
Step: 1
See step-by-step solutions with expert insights and AI powered tools for academic success
Step: 2
Step: 3
Ace Your Homework with AI
Get the answers you need in no time with our AI-driven, step-by-step assistance
Get Started