Develop an app that provide support for decision making

Assignment Help Management Information Sys
Reference no: EM131338902

Excel Project Description

Project overview

Develop a Microsoft Excel application that provides support for decision making. The application must be useful to someone, which means it needs to help someone analyze data and make appropriate decisions based on the data. Don't waste your time creating something that has no purpose.

Demonstrate your ability to use Excel by integrating as many features of Excel as feasible. The project must be easy to understand and have a professional appearance. Use comments or provide instructions to help someone use the application.

Examples and ideas

· Make a tool for a landlord. Pretend you are a landlord or make it for a real one: Keep track of current renters, when people will be leaving, how many rooms you need to fill, repairs, cost for repairs, history of repairs, utility trends, who is on which payment schedule, or anything else you think is useful to a landlord.

· Create something that helps you or others choose what car to buy. You could include data about recalls, TSBs, complaints from other owners, 0-60 times, horsepower, costs such as insurance, depreciation, repairs, gas, etc. Show that one car is a better than another given certain criteria such as 4 door full-sized between x-y price range.

· Create a financial portfolio analyzer. Using real data from real securities, show comparative performance measures over time. In addition to analyzing the stock or bond performance, you might include a sheet for the business performance.

· Create a decision support system for a small business startup. This could include several what-if scenarios. Include an analysis of capital financing options.

· Create a decision support system for buying a house. Include variables such as commuting distance, property tax rates (use real data), mortgage payments at varying principal amounts and interest rates, proximity to shopping and other services, schools, etc.

Choose something that uses some sort of data. This way it will be easier to use charts and graphs and use formulas such as statistical analysis or nested-if statements. You can create your own data, make it up or get it from the Internet. Keep in mind that you should be able to show that your project accomplishes something even if it is for your own personal satisfaction.

At the end of each chapter is a set of "Practice Exercises." Many of them suggest applications to solve real business problems that can be developed in Excel. Use these suggestions to help you brainstorm ideas for your own project.

Minimum requirements for Excel features

· IF-statements

· Multiple sheets

· Simple formulas (e.g., sum, avg, pmt, fv, stdev, median) - use cell reference where appropriate, including absolute references and references to other sheets

· At least two charts or graphs

· Attractive appearance - remove background grid, add a watermark, use color, or whatever is appropriate

Advanced functionality (at least 3 of the following - any combination)

· Complex formulas (e.g., nested-ifs-ands-ors, V- and H-lookups, IS functions)

· Data Table (NOT excel table)

· Sort function

· Pivot table

· Scenario tools

· Macros or VBA

External data requirement

· Bring in some data via an SQL query, Web query, or XML data import

Other requirements

· Title page/Introduction/Summary sheet that may include navigation instructions, tasks involved, project title, your names, sources of data, research involved, etc.

· Conclusion sheet or a sheet that explains what was accomplished. (Use this sheet to tell me where (sheet and cell location) you met the requirements.)

This project will demonstrate skill and proficiency in Excel. You should make it something you would be proud to show to a potential employer in a job interview.

Reference no: EM131338902

Questions Cloud

Peasants in central and south america : What efforts have been made and by whom to promote alternative crops to peasants in Central and South America?
Determine the type of polynomial function : Determine the type of polynomial function that could be used to represent the data in the scatter plot.
Industrial organization class : Outline and briefly explain the major elements of the standard used to evaluate industrial performance from the perspective of societal welfare.
What equal and annual end of year amount must you save : What equal, annual, end-of-year amount must you save for each of the next 30 years to meet these goals, if all savings earn a 13 percent annual rate of return?
Develop an app that provide support for decision making : Develop a Microsoft Excel application that provides support for decision making. The application must be useful to someone, which means it needs to help someone analyze data and make appropriate decisions based on the data. Don't waste your time ..
Analysis of competitors and customers : Define the type of market in which your selected product will compete, along with an analysis of competitors and customers. Analyze any comparative advantages and international trade opportunities.
What is its average distance from the sun : If it takes Mars 687 days to orbit the sun, what is its average distance from the sun?
Calculate the level of velocity for year : Calculate the level of velocity for each year.  At what rate is velocity growing? Why does Bank Capital Exist? Why did brokered deposits during the S&L crisis cause interest rates to rise?
How much must you accumulate by the time you reach age 45 : If you expect your investments to earn 12 percent per year over the next 15 years and 10 percent per year thereafter, how much must you accumulate by the time you reach age 45?

Reviews

Write a Review

 

Management Information Sys Questions & Answers

  Essay about google and the future of computing

2500 word essay about Google and the future of computing. Research Google and discover at least 5 technologies they have developed (or are currently developing), other than the search and advertising features

  Prepare an executive summary document to board of directors

You will need to prepare an executive summary document (1 page maximum) to the board of directors

  Evaluate relative risks involved at each stage of a systems

Evaluate the relative risks involved at each stage of a systems development project (or within the different activities of a rapid applications development project) and suggest techniques that can be used to control these risks.

  What is an erp application system

You will perform a Web search to watch the video about "ERP Design and Architecture" on YouTube, and then answer the following question-What is an ERP application system

  Employee retentionhow might i apply information technology

employee retentionhow might i apply information technology systems and improvement solutions to employee retention in

  Company''s standards in relation to technology

technology usage policies - Being considered an ethical company by consumers can help a company to increase its market share. How can a company's standards in relation to technology help them to be seen as ethical?

  How can one prevent unauthorized computer access

As a safety measure, how can one prevent unauthorized computer access?

  Impact of technology on customers in regard

Prepare a paper about the impact of technology on customers in regard - How the company introduced the new product to customers

  How computer hardware and application impact it professional

Consider how computer hardware, operating systems and applications impact the IT professional. Provide your thoughts about how the computing environment contributes to an individual's success or failure on the job.

  Develop test plan training plan and maintenance methodology

Develop test plan, training plan, and maintenance methodology for SanGrafix, a video game design company. Each test and maintenance methodology should include a method for testing applications, operating systems, network connectivity, speed, load ..

  Information systems proposal with five types of information

information systems proposal with five types of information systems that would work well for a new small nostalgic

  Development of problem statementin this discussion you look

development of problem statementin this discussion you look at problem statements and the importance of identifying the

Free Assignment Quote

Assured A++ Grade

Get guaranteed satisfaction & time on delivery in every assignment order you paid with us! We ensure premium quality solution document along with free turntin report!

All rights reserved! Copyrights ©2019-2020 ExpertsMind IT Educational Pvt Ltd