Reference no: EM132304087
Assignment: 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.
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:
1. Summary information:
• Teacher salary by district.
• Teacher salary by "Setting."
• Teacher salary by Charter/NonCharter.
2. 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.
3. Provide analysis of one additional area that you identify.
Information related to above question is enclosed below:
Attachment:- VBA.rar