Chapter 13 Exercises

Return to main page

Chapter 13 Exercises

Chapter 1 2 3 4 5 6 7 8 9 10 11 12 13 14

Principles of MIS

© 2008 by Jerry Post

Using salary surveys and local advertisements, find typical salaries for various MIS jobs in your area.

Interview a worker at a large company (perhaps a friend or relative) and ask them to evaluate the MIS department. Comment on the degree of centralization. Does the organization use chargeback to pay for MIS services?

Make a list of symptoms you expect to see in a company that is “too decentralized.” That is, company users are free to choose any hardware and software, and databases are maintained by each department. Data is shared through reports that are printed in each department and forwarded to other departments on paper. There is no central MIS staff and no CIO. Treat it as a company that started small using personal computers and grew but did not come up with a centralized information system approach.

As a manager in a small company, you do not have an in-house MIS development team. You need a special data-analysis program created that will run as a browser-based service on your Web site to help other managers analyze sales data. The mathematical analysis is fairly complex, but you have formulas for all of the calculations. Find a company or person that could handle the development for you.

Find data on the number of computer science and MIS majors at your school for the past few years and identify any trends. How might these trends affect the job market?

Obtain a sample of at least 50 job ads for programmers. For example, randomly sample ads from Dice or Monster. Summarize the programming languages and skills in demand. Identify the types of companies hiring workers. In particular, are they general business organizations, or are they MIS development specialists?

Using the various salary surveys, compare salaries for small versus large businesses in your area. Briefly explain the differences. If possible, talk with employees at small and large businesses to see how the jobs might differ.

Technology Toolbox

8. Assuming that you work as a manager, create a set of mailbox folders to handle your expected mail. Create the rules that will move incoming mail to the appropriate folder.

9. Assuming that you are in charge of a sales division for a large company, create an e-mail rule to handle messages from customers. You have a couple of key clients that you have known for years, and they have a pattern of sending messages. For example, they send personal messages a few times a year, they send questions about price changes monthly, and once in a while they send complaints about late deliveries or quality concerns. Sometimes they send a new order directly to you, which you have to forward to the sales staff.

10. Create a project management analysis for starting a new company. Identify the major tasks and their dependencies. If possible, create the project in Microsoft Project (you can get a free demonstration copy). If it is not available, at least draw a Gantt chart by hand.

11. Create the Gantt chart for the development exercise using Microsoft Project. Assign resources at 100 percent as indicated and use resource leveling to determine the time it will take to complete the project.

	Name	Duration	Depends on	Resources
1	Feasibility Statement	5 days
2	Get hardware list and costs	1 day		Analyst
3	Count forms and reports	1 day		Analyst
4	Estimate development time	1 day		Analyst
5	Get benefits from user	1 day		Analyst
6	Create statement	1 day	2, 3, 4, 5	Analyst
7	Management Approval	1 day	1
8	Analysis	17 days	7
9	Interview users	7 days		Analyst
10	Evaluate competition	3 days		Analyst
11	Search for existing software	3 days		Analyst
12	Evaluate options	4 days	9, 10, 11	Analyst
13	Management Approval	1 day	8
14	Design	15 days	13
15	Design and create database	2 days		Analyst
16	Build forms	8 days	15	Programmer
17	Create reports	4 days	15	Programmer
18	Design application	3 days		Programmer
19	User approval	1 day	14
20	Management approval	1 day	19
21	Implementation	10 days	20
22	Purchase hardware	2 days		Analyst
23	Transfer data	3 days	22	Programmer
24	Integration test	4 days	23	Programmer
25	Train users	1 day		Trainer
26	Write procedures	1 day		Analyst
27	Transfer operations	1 day	24	Analyst,Programmer
28	Review	1 day		Analyst,Programmer

12. Using the data in the previous exercise, explore ways to complete the project earlier. Note that you can consider hiring more people, but there is a limit—adding more people to the project means you have to add more managers and increase some of the development times to compensate for the additional overhead.

Teamwork

Interview computer users and managers in a local firm (or your university) and determine the degree of decentralization in their information system organization. Talk to several users and see whether their perceptions agree. Are they receiving all of the advantages of centralization and decentralization? If not, how could the system be modified to gain these benefits without significantly increasing the drawbacks? Be sure to analyze hardware, software, data, and personnel.

Have each person select one country and find the average cost for programmers. Identify technology and telecommunication capabilities available. Identify social and cultural factors (such as education) that could affect programming abilities. Combine the data from each person and identify a nation in which you would want to establish an offshore outsourcing facility.

Have each person research a separate case in the textbook and identify the degree of MIS centralization within the organization. Compare the results along with the sizes of the organizations. Identify any patterns.

Assume that you want to install a new wireless network for a company with 300 employees in one location. Find at least three companies that could handle the installation and configuration.

Survey at least 10 workers (possibly friends or family) and find out when (or if) their company has switched to Microsoft Office 2007. Did everyone in the company switch at the same time? Who made the decision to switch? Were there any problems?

Write a plan for moving a midsize service company to an intranet and mobile-commerce-based information system, where as many applications as possible will run through browsers and data will be accessible from anywhere in the company. What technologies will you use? What functions will you centralize or decentralize? How will you provide adequate security?

Rolling Thunder Database

Describe the organization of the existing information system. What changes would enable the system to run better? If the company doubles in size in three years, what organizational changes do you recommend for the information system?

How should the company handle typical information system tasks such as backing up data, creating employee accounts, maintaining hardware, selecting new hardware and software, and so on?

The company wants to move the entire application to a Web-based system to support both internal operations and allow customers to place orders online. Find a company that can develop the software. Find a company that can host the application. If possible, estimate the costs.

Assume users are complaining about lack of support from the MIS department. How can you improve MIS responsiveness? How can you do it without substantially raising costs?