Create a vba application from start to finish

Assignment Help Computer Engineering

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

Reference no: EM132304087

Questions Cloud

How is society responding to this social problem : Compare current and historical data: Discuss ideas of social science experts about the social problem.

Discuss the given problem related to database auditing : Discuss in 500 words or more why Oracle 12c has introduced two new roles - AUDIT_ADMIN and AUDIT_VIEWER. Include a discussion of what database auditing is.

Different societies have different social structures : Different societies have different social structures. What is social structure? What components contribute to the macro-sociological perspective?

What happens when we try too hard to please others : How much of society and culture do you feel impact our development of self? What happens when we try too hard to please others? Do we lose self?

Create a vba application from start to finish : 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 function

Describe two important elements of data presented : Describe two important elements of data presented on the charts/graph and briefly interpret each data element;

Why does machine learning outperform quants : Why does machine learning outperform “quants” when it comes to hypotheses generation?

What forms of resistance do activists within these movements : Do you feel that the strategies used (occupation, disruption, etc.) are effective techniques for social change? Explain.

Formulate linear programming model : Formulate a linear Programming model for this problem. Solve this method by using graphical analysis.

User Account

All Pages