fbpx

VBA (Visual Basic For Applications) Assignments | Online Homework Help

he goal of this assignment is to give you a chance to create a VBA application from start to finish. You will have data and a brief description of the functionality. Details on how you are going to implement this are very limited. With the exception of some “must haves” listed below, you have to make all of the design and coding decisions.

Don't use plagiarized sources. Get Your Assignment on
VBA (Visual Basic For Applications) Assignments | Online Homework Help
Just from $13/Page
Order Now

 

The Problem

It seems like almost daily the news has some story of teacher strikes and teacher salary is often cited as being part of the problem. School data is available on the web for Colorado and is compiled by the Colorado Department of Education (CDE).

For this “Final Exam” I would like you to take the role of data analyst for the CDE. While you may have Tableau, Power BI, and/or pivot table skills, you have been asked to create a prototype VBA application for policymakers. This prototype won’t use all of the data or answer all possible question. You are asked to focus on teacher salary. The point of this prototype is to show off your skills with just a limited analysis.

professional writing services near me

Your users would be school superintendents, legislators, or other interested parties, e.g., workers in the Governor’s office, the press, or “think tank” organizations. You should not assume that this group of users is very proficient with Excel or other analytic software. The following functionality is requested:

Summary information: Teacher salary by district.

Teacher salary by “Setting.”

Teacher salary by Charter/NonCharter.

Provide output that enables the user to answer this question: Are teacher salary and graduation rates related? You should probably at least separate this by Elementary, Middle, and High School, but might what other categorizing variables (moderators). Note: You don’t give the answer, but you give the user a way to answer the question themselves.

Provide analysis of one additional area that you identify.

 

I got the data from the following websites:

 

https://www.cde.state.co.us/cdereval/gradratecurrent

(https://www.cde.state.co.us/cdereval/gradratecurrent)

https://www.cde.state.co.us/cdereval        (https://www.cde.state.co.us/cdereval)

https://www.cde.state.co.us/schoolview        (https://www.cde.state.co.us/schoolview)

 

Here are the spreadsheets that I used and should be enough to earn an A-level score. You may not even need all of these worksheets.

 

2017-18 Average Salaries for Teachers Updated with Charter Status.xlsx  2017-18 graduation rates, school-level, race & gender.xlsx

2017-18 Teachers by Gender and Race Updated.xlsx

school building codes-en-us.xlsx  Note: this is 2019 data. You might have to reconcile this list of schools with the previous files.

You should not do pre-processing of data by hand, your code should do this. (Pre-processing would be things like moving columns into one “Data” sheet, deleting missing data, sorting or other categorizations, etc. (The exception to this is Tables and Graphs.) Find a way to deal with “missing data” and make this transparent in the output. You may put full worksheets in one workbook. You should build your code so that extra rows can be added. You can assume that the columns will not change.

Things that you need to include:

 

Use at least one array

Code is modularized into several subs Pass variables between subs as needed.

Error prevention, error capture, and/or error checking with re-dos for the user

At least one user form and provide the user choices, e.g., give me salaries of rural high schools

While some query results can be displayed with message boxes, you have to provide at least one table and one graph with navigation. You can (should) design your table(s) and graph(s) by hand and then just populate them with VBA.

I will be testing your code with different data. It will have the same numeric scope as the given data. (I won’t use data that is in the 100s if the given data is in the 1000s.)

Please review some of the applications in the second part of the book to understand the scope of what I am looking for. Starting on an explanation sheet is good. Provide navigation so that the user can get to the sheets needed. You can hide and unhide sheets as needed. Be sure to review the rubric.

Calculate the price
Make an order in advance and get the best price
Pages (550 words)
$0.00
*Price with a welcome 15% discount applied.
Pro tip: If you want to save more money and pay the lowest price, you need to set a more extended deadline.
We know how difficult it is to be a student these days. That's why our prices are one of the most affordable on the market, and there are no hidden fees.

Instead, we offer bonuses, discounts, and free services to make your experience outstanding.
How it works
Receive a 100% original paper that will pass Turnitin from a top essay writing service
step 1
Upload your instructions
Fill out the order form and provide paper details. You can even attach screenshots or add additional instructions later. If something is not clear or missing, the writer will contact you for clarification.
Pro service tips
How to get the most out of your experience with Homework Writing Services
One writer throughout the entire course
If you like the writer, you can hire them again. Just copy & paste their ID on the order form ("Preferred Writer's ID" field). This way, your vocabulary will be uniform, and the writer will be aware of your needs.
The same paper from different writers
You can order essay or any other work from two different writers to choose the best one or give another version to a friend. This can be done through the add-on "Same paper from another writer."
Copy of sources used by the writer
Our college essay writers work with ScienceDirect and other databases. They can send you articles or materials used in PDF or through screenshots. Just tick the "Copy of sources" field on the order form.
Testimonials
See why 20k+ students have chosen us as their sole writing assistance provider
Check out the latest reviews and opinions submitted by real customers worldwide and make an informed decision.
Military
good job
Customer 456821, January 5th, 2022
Medicine
Great job.
Customer 463301, November 14th, 2022
Medical terminology
Thank you so much
Customer 454783, April 15th, 2022
Military
Good work.
Customer 456821, June 20th, 2022
Military
good job
Customer 456821, April 4th, 2022
Film & Theater studies
Acquire Grammarly Premium and ensure that your papers are thoroughly checked.
Customer 462759, March 28th, 2022
Business
Good work!
Customer 463469, October 29th, 2022
Military
good job
Customer 456821, March 28th, 2022
Medicine
Always confirm foreign names using Google.
Customer 458101, April 3rd, 2022
Military
very good job
Customer 456821, August 3rd, 2022
Professions and Applied Sciences
GOOD application.
Customer 462457, April 13th, 2022
Human Resources Management (HRM)
Excellent!
Customer 462613, April 10th, 2022
11,595
Customer reviews in total
96%
Current satisfaction rate
3 pages
Average paper length
37%
Customers referred by a friend
OUR GIFT TO YOU
15% OFF your first order
Use a coupon FIRST15 and enjoy expert help with any task at the most affordable price.
Claim my 15% OFF Order in Chat