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

The 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.

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.


professional writing services near me

Provide analysis of one additional area that you identify.


I got the data from the following websites:




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)
*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.
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.
Excellent work. Very grateful. Thank you. Will use again.
Customer 454227, April 4th, 2020
Art (Fine arts, Performing arts)
very professional and well done.
Customer 462485, May 9th, 2022
English 101
I don’t have any comment it’s very good
Customer 454499, June 17th, 2020
Always check word count when proofreading.
Customer 452441, April 6th, 2022
Customer 463813, March 10th, 2023
Business and administrative studies
Customer 456823, April 2nd, 2022
Human Resources Management (HRM)
It's great. I recommend the writer.
Customer 454223, April 9th, 2020
Excellent work.
Customer 463001, June 12th, 2022
Business and administrative studies
Good work.
Customer 463053, June 20th, 2022
poor service
Customer 453627, January 24th, 2020
Business Studies
Customer 453413, April 16th, 2020
Customer 453413, February 27th, 2020
Customer reviews in total
Current satisfaction rate
3 pages
Average paper length
Customers referred by a friend
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