How does the problem statement for BTS resemble what Gersick indicates about a systems deep structure (Reading 6; see also Chapter 3 Hayes)?

Case Study Change Management
Paper, Order, or Assignment Requirements

Task required: Based on less than perfect information supplied about the BTS problem statement, you are required to act as an external change consultant to assist the Board to address the issues and challenges:

1. Develop at least six (6) realistic assumptions that you can add to the issues and problems expressed. These might typically be related to management, change processes, managerial information systems, technology, competitors, Customers and so on. Use at least two (2) sentences to describe each assumption (150-200 words).
2. In reference to the classic article by Larry Greiner (Reading 10), explain what is happening between growth and change in BTS. Compare this with what Malhotra and Hinings indicate about continuity and change (Reading 9) (500-600 words).
3. How does the problem statement for BTS resemble what Gersick indicates about a systems deep structure (Reading 6; see also Chapter 3 Hayes)? What consistencies exist between the facts in BTS and the descriptions of deep structure by Gersick (500-600 words)?
4. In reference to the article by Dailey and Browning (Reading 4; see also Module 1), explain how and why narratives and storytelling was useful to the company (300 words).
5. Refer to Chapter 6 of Hayes (2014) under the heading ‘Collaborative Modes of Intervening’. Discuss which modes might change agents in BTS use and why? Who are the change agents in BTS if change occurs? (300 words)
6. Given the Typology of Organisational Change (see Hayes, Chapter 3), which typology may best describe the approach that BTS might adopt and why? (300-400 words).
Please Note: Use a minimum of 12 references (including the one’s listed above) to support your answers

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Describe the role of information systems

Paper, Order, or Assignment Requirements

Social media analytics

Answer the following questions

What are social media analytics? should discuss key elements of the information systems framework for social media analytics and describe at least two current applications or services providing social media analytics.

What are the benefits to consumers and business?

What risks and issues are associated with use (including privacy concerns)?

Give examples of future applications for this information technology.

System and Operations Management

Specialism Topic :
Select one from the following two Options and write 600 word summary topic.

Option: Describe the role of information systems in careers in one of the following areas : Accounting/finance, Human resources, marketing and operations management, and explain how careers in information systems have been affected by new technologies and outsourcing.
Option : Explain the role of human resource management in operations : the discussion should look at the strategic importance of managing people in operations settings . you can use chapter 9, entitled people : jobs and organisation from slack et al.(2014) Operations management the 7th edition as a starting points.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Explain each of the key internal factors that impact the business.

Connective Processes
Paper, Order, or Assignment Requirements

For your first assignment, you will select a healthcare-based organization for review and compose a report. In a 4-6 page paper, be sure to include the following sections:

Introduction

Be sure to include basic information about the organization. This may include location, size, mission, values, etc. You will be examining and discussing the internal and external factors that impact this particular organization.

Body

Explain each of the key internal factors that impact the business. Internal factors could be:

•Finance

•Human resource management

•Research and development

•Production

•Service delivery

•Marketing

•Procurement

•Information technology services

•Sales

•Customer service call centers

•Management information systems

•Logistics

•Fundraising

Investigate how factors outside the organization could affect their operations. Be sure to discuss the impact on the business activities, strategy, internal structures, functional activities and stakeholders. External factors may include:

Political
•Economic
•Social
•Technological

Conclusion

How does the structure relate to the particular sector (private/public/voluntary) that the organization is in?

Evaluate how well the organizational structure works (does it work well or could it be improved?).

Your completed exercise should follow the conventions of Standard American English (correct grammar, punctuation, etc.). Your writing should be well ordered, logical and unified, as well as original and insightful. Your work should display superior content, organization, style, and mechanics.

NOTE: Be sure to cite sources in APA format throughout your paper, especially when drawing conclusions and making recommendations, to support your ideas.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Capstone Project

Computer science
Paper, Order, or Assignment Requirements

This paper requires A GANTT CHART I have completed PART 1, I need Part 2, Part 3, Part 4 and the final project. Please read the instructions carefully. I have 8 weeks to complete the final project. If you have questions. EMAIL ME. If this paper is completed correctly I would like to pay the writer extra. I want an A+ in this course.

Capstone Project Overview
The purpose of this project is for students to apply project management techniques to create integrative information technology solutions that include databases, systems analysis, security, networking, computer infrastructure, human computer interaction, and Web design. Deliverables one (1) through four (4) focus on preparing students toward the final capstone project. The project contents are as follows:
1. Project Deliverable 1: Project Plan Inception. In this deliverable, you will create a project introduction that includes background information of the company, the type of business in which the company is involved, and a description of the integrative information systems that the company should have to support the business. You will also be asked to create a Gantt chart or project plan to record tasks, subtasks, resources and identify the schedule of the project. Additionally the plan will outline the planning, analysis, design, and implementation phases of your project.
Submission Requirements
o Project Introduction (MS Word)
o Gantt Chart / Project Plan (MS Project / Open Project)
2. Project Deliverable 2: Business Requirements. In this deliverable, you will create an original business requirements document for the project plan using the template provided. You will be asked to describe the detailed project including the scope, possible risks, constraints, and assumptions, integration with other systems and infrastructure, and relevant terms that will be used throughout project. You will also need to update the Gantt chart or project plan.
Submission Requirements
o Business Requirements Document (MS Word)
o Revised Gantt Chart / Project Plan (MS Project / Open Project)
3. Project Deliverable 3: Database and Programming Design. In this deliverable, you will create a database schema that supports the company’s business and processes, explain and support the database schema, create database tables, normalize the database tables, create an Entity-Relationship (E-R) Diagram and create a Data Flow Diagram (DFD). You will also be asked to create sample queries that will support the organizational reporting needs, and screen layouts that illustrate the interface that organizational users will utilize. You will need to update the Gantt chart or project plan.
Submission Requirements
o Design Document (MS Word)
o Revised Gantt Chart / Project Plan (MS Project / Open Project)
4. Project Deliverable 4: Infrastructure and Security. In this deliverable, you will design a logical and physical topographical layout of the network, illustrate the possible placement of servers, explain rationale for the logical and physical topographical layout of the planned network, create and describe the comprehensive security policy for the organization, and update the Gantt chart or project plan.
Submission Requirements
o Infrastructure Document (MS Word)
o Revised Gantt Chart / Project Plan (MS Project / Open Project)
5. Final Project: Project Plan. In the final project, you will provide a high-level technical overview of the project. You will also create a comprehensive PowerPoint presentation for the executive team and the venture capital group. The PowerPoint presentation along with the executive summary will convince the group that your solution is optimal.
Submission Requirements
o Written Project Plan (MS Word)
o Revised Gantt Chart / Project Plan (MS Project / Open Project)
o Project Plan PowerPoint Presentation (MS PowerPoint)

Project Deliverable 2: Business Requirements
Due Week 4 and worth 150 points

This assignment consists of two (2) sections: a business requirements document and a Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

Procuring quality business requirements is an important step toward the design of quality information systems. Completion of a quality requirements document allows user needs and expectations to be captured so that infrastructure and information systems can be designed properly. Using the requirements document provided in the course shell, you are to speculate on the needs of the company. You must consider current and future requirements; however, assumptions should be realistic and carefully considered.

Section 1: Business Requirements Document
1. Write an eight to ten (8-10) page original business requirements document for the project plan using the template provided. Note: The template can be found in the Student Center of the online course shell.
a. Describe the project including the following:
i. Describe the scope and analyze how to control the scope.
ii. Identify possible risks, constraints, and assumptions.
iii. Describe the integration with other systems and infrastructure. Note: Database and interface design, security, and networking should be considered.
iv. Define relevant terms that will be used throughout project.
b. Use at least two (2) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.

Section 2: Revised Gantt Chart / Project Plan
Use Microsoft Project or an open source alternative, such as Open Project, to:
2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 1: Project Plan Inception, with all the project tasks.

The specific course learning outcomes associated with this assignment are:
• Apply integrative information technology solutions with project management tools to solve business problems.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

Project Deliverable 3: Database and Programming Design
Due Week 6 and worth 150 points

This assignment consists of two (2) sections: a design document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

One (1) of the main functions of any business is to transform data into information. The use of relational databases has gained recognition as a standard for organizations and business transactions. A quality database design makes the flow of data seamless. The database schema is the foundation of the relational database. The schema defines the tables, fields, relationships, views, indexes, and other elements. The schema should be created by envisioning the business, processes, and workflow of the company.

Section 1: Design Document
1. Write a five to ten (5-10) page design document in which you:
a. Create a database schema that supports the company’s business and processes.
b. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
c. Create database tables with appropriate field-naming conventions. Then, identify primary keys and foreign keys, and explain how referential integrity will be achieved.
d. Normalize the database tables to third normal form (3NF).
e. Create an Entity-Relationship (E-R) Diagram through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
f. Explain your rationale behind the design of your E-R Diagram.
g. Create a Data Flow Diagram (DFD) through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
h. Explain your rationale behind the design of your DFD.
i. Create at least two (2) sample queries that will support the organizational reporting needs.
j. Create at least two (2) screen layouts that illustrate the interface that organizational users will utilize.

Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.

Section 2: Revised Gantt Chart / Project Plan
Use Microsoft Project or an open source alternative, such as Open Project, to:
2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 2: Business Requirements, with all the project tasks.

The specific course learning outcomes associated with this assignment are:
• Describe the various integrative functions and processes within the information systems area, including databases, systems analysis, security, networking, computer infrastructure, human computer interaction, and Web design.
• Demonstrate the ability to evaluate organizational issues with integrative technological solutions.
• Apply integrative information technology solutions with project management tools to solve business problems.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

Project Deliverable 4: Infrastructure and Security
Due Week 8 and worth 150 points

This assignment consists of two (2) sections: an infrastructure document and a revised Gantt chart or project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

The last section of the project plan will present the infrastructure in accordance with the parameters set forth at the outset of the project. The network solution that is chosen should support the conceived information system and allow for scalability. The network infrastructure will support organizational operations; therefore, a pictorial view of workstations, servers, routers, bridges, gateways, and access points should be used. In addition, access paths for Internet access should be depicted. A narrative should be included to explain all the nodes of the network and the rationale for the design. Lastly, using the Confidentiality, Integrity and Availability (CIA) Triangle, define the organizational security policy. CIA is a widely used benchmark for evaluation of information systems security.

Section 1: Infrastructure Document
1. Write a five to ten (5-10) page infrastructure document in which you:
a. Design a logical and physical topographical layout of the planned network through the use of graphical tools in Microsoft Word or Visio, or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length.
b. Illustrate the possible placement of servers including access paths to the Internet and firewalls. Note: Facility limitations, workstations, printers, routers, switches, bridges and access points should be considered in the illustration.
c. Explain the rationale for the logical and physical topographical layout of the planned network.
d. Create a comprehensive security policy for the company that will:
i. Protect the company infrastructure and assets by applying the principals of CIA. Note: CIA is a widely used benchmark for evaluation of information systems security, focusing on the three core goals of confidentiality, integrity and availability of information.
ii. Address ethical aspects related to employee behavior, contractors, password usage, and access to networked resources and information.

Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio or Dia as an appendix of the infrastructure document. All references to these diagrams must be included in the body of the infrastructure document.

Section 2: Revised Gantt Chart / Project Plan
Use Microsoft Project or an open source alternative, such as Open Project, to:
2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 3: Database and Programming Design, with all the project tasks.

The specific course learning outcomes associated with this assignment are:
• Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
• Evaluate the issues and challenges associated with information technology integration.
• Evaluate the ethical concerns that information technology solve or present in a global context.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

Final Project: Project Plan
Due Week 10 and worth 300 points

This assignment consists of three (3) sections: a written project plan, a revised Gantt chart or project plan, and a project plan PowerPoint presentation. You must submit the three (3) sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment for which it is written. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

While taking all business and project parameters into consideration, make quality assumptions to support the following requirements.

Section 1: Written Project Plan
You are now in the final stage of the project plan development. All previous documentation will be combined into one (1) document that will serve as the statement of work for the project. Your goal is to have the project approved by the executive team and the venture capital group. The project plan is very detailed which is appropriate to accomplish the monumental task of implementation. However, the executive team is only interested in a ten (10) minute summation. Therefore, you also must create a compelling executive summary that is supported by your detail that convinces the executive group that your solution is optimal.
1. Write an eight to ten (8-10) page executive summary in which you provide a high-level technical overview of your project where you address the following:
a. Describe the scope of the project and control measures.
b. Describe the goals and objectives of the project.
c. Give a detailed, realistically estimated cost analysis of the entire project.
d. Relate the value of the project plan solution to the competitive advantage that information technology will afford your organization.
e. Provide all aspects of the information technology implementation into the project plan.
f. Use at least five (5) quality resources in this assignment. Note: Wikipedia and similar Websites do not qualify as quality resources.

Your assignment must follow these formatting requirements:
• Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
• Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
• Include charts or diagrams created in MS Visio and MS Project as appendix of the Word document. Make reference of these files in the body of the Word document.

Section 2: Revised Gantt Chart / Project Plan
Use Microsoft Project or an open source alternative, such as Open Project, to:
2. Update the Gantt chart or project plan (summary and detail) template, from Project Deliverable 4: Infrastructure and Security, with all the project tasks.

Section 3: Project Plan PowerPoint Presentation
Additional to your detailed executive summary you must present your findings to the executive team and the venture capital group that, along with the executive summary, will convince the group that your solution is optimal.
3. Create a ten to fifteen (10-15) slide PowerPoint presentation in which you:
a. Illustrate the concepts from your written report in Section 1 of this assignment.
b. Create bulleted speaking notes for your presentation to the executive board in the Notes section of the PowerPoint. Note: You may create or assume any fictitious names, data, or scenarios that have not been established in this assignment for a realistic flow of communication.
c. Use a professional technically written style to graphically convey the information.

The specific course learning outcomes associated with this assignment are:
• Demonstrate an understanding of existing and emerging information technologies and strategic impact on organizational operations.
• Evaluate the issues and challenges associated with information technology integration.
• Summarize the competitive advantage that information technology affords to organizations.
• Use technology and information resources to research issues in information technology.
• Write clearly and concisely about strategic issues and practices in the information technology domain using proper writing mechanics and technical style conventions.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Choose a world event that occurred sometime between September 1, 2015 and February 8, 2016

Paris Attacks November 2015 – How We Know What We Know
Paper, Order, or Assignment Requirements

Choose a world event that occurred sometime between September 1, 2015 and February 8, 2016, and create a 1,000-word wiki that explains, from a critical and global perspective, how the trajectory of this event was shaped by various information systems. Your goal is to evaluate the authenticity and credibility of information reported about this world event, so the essay should demonstrate your understanding of the diverse and complex nature of information, bringing order to, and maximizing the value of, the information for the audience it reaches. True to the title of this course, your essay will help you come full circle, in that you must explain how we know what we know about this world event. Thus, your essay should state a thesis, and your paper should analyze, how the event was covered or how information about the event was manipulated or suppressed. Finally, your essay should address what all that means on a global level.

Your writing should CRITICALLY examine HOW WE KNOW WHAT WE KNOW about your event. You need to challenge assumptions and expand the bounds of debate. Dont just give a recap of the event. As voracious readers, we already KNOW what happened. Think instead of how the public got the information and how it might have been influenced manipulated, suppressed, etc. Look at all the different players and facets involved in the event. Media, business, government, and the public from countries around the world may have been affected. Be careful of sweeping generalizations such as, the media only want sensational stories, or, the government always lies. Back up your claims with facts and expert opinions that are cited.

The concepts covered in the course should be the building blocks of your essay. Descriptions of events do not constitute analysis, which is the application of learned concepts to create new ways of looking at the world. How does the rhetorical triangle apply in your analysis? Whos keeping secrets? Whos penetrating secrets? Whos manipulating information? How is information created, harvested, conveyed, and used?

For the first purpose, you should select an international event and do a thorough-going read of articles related to that event. Imagine that you are tearing apart an engine, piece by piece, examining every part for wear, tear and defective workmanship. Remember, information usually is a collection of a lot of moving parts. Challenge assumptions, expand the bounds of debate and make sure your analysis is beneficial to global society.

For the second purpose, how do the readings/web explorations this semester frame your examination of the event? What role, if any, did secrecy, revelation, intellectual property, freedom of information or suppression play in this event? Review readings and lecture notes to focus your thinking. Was there an example of how lies protect secrets or how secrets protect lies? Or, perhaps, how was rhetoric used to shape and convey the event? Use every lens youve been provided this semester to examine the event and select those that bring it into focus.

If you do that, youll be in great shape to tackle the third purpose, which is to determine how a person, movement or technology influenced this event. How did one or more of those alter the global culture? How do any (or all) of those bring desirable or undesirable change?

You should have a minimum of 5 sources, one of which is scholarly. Use MLA for your citation format, but dont worry about indentations or margins
———-
Added on 23.04.2016 00:40
Final essay due May 3 at class time

The purpose of this assignment is three-fold:
1. To give you the opportunity to use the critical perspective to analyze a recent world event.
2. To give you the opportunity to use much of what youve learned this semester.
3. To help you better understand how people, movements or technology alter global cultures.

Choose a world event that occurred sometime between September 1, 2015 and February 8, 2016, and create a 1,000-word wiki that explains, from a critical and global perspective, how the trajectory of this event was shaped by various information systems. Your goal is to evaluate the authenticity and credibility of information reported about this world event, so the essay should demonstrate your understanding of the diverse and complex nature of information, bringing order to, and maximizing the value of, the information for the audience it reaches. True to the title of this course, your essay will help you come full circle, in that you must explain how we know what we know about this world event. Thus, your essay should state a thesis, and your paper should analyze, how the event was covered or how information about the event was manipulated or suppressed. Finally, your essay should address what all that means on a global level.

Your writing should CRITICALLY examine HOW WE KNOW WHAT WE KNOW about your event. You need to challenge assumptions and expand the bounds of debate. Dont just give a recap of the event. As voracious readers, we already KNOW what happened. Think instead of how the public got the information and how it might have been influenced manipulated, suppressed, etc. Look at all the different players and facets involved in the event. Media, business, government, and the public from countries around the world may have been affected. Be careful of sweeping generalizations such as, the media only want sensational stories, or, the government always lies. Back up your claims with facts and expert opinions that are cited.

The concepts covered in the course should be the building blocks of your essay. Descriptions of events do not constitute analysis, which is the application of learned concepts to create new ways of looking at the world. How does the rhetorical triangle apply in your analysis? Whos keeping secrets? Whos penetrating secrets? Whos manipulating information? How is information created, harvested, conveyed, and used?

For the first purpose, you should select an international event and do a thorough-going read of articles related to that event. Imagine that you are tearing apart an engine, piece by piece, examining every part for wear, tear and defective workmanship. Remember, information usually is a collection of a lot of moving parts. Challenge assumptions, expand the bounds of debate and make sure your analysis is beneficial to global society.

For the second purpose, how do the readings/web explorations this semester frame your examination of the event? What role, if any, did secrecy, revelation, intellectual property, freedom of information or suppression play in this event? Review readings and lecture notes to focus your thinking. Was there an example of how lies protect secrets or how secrets protect lies? Or, perhaps, how was rhetoric used to shape and convey the event? Use every lens youve been provided this semester to examine the event and select those that bring it into focus.

If you do that, youll be in great shape to tackle the third purpose, which is to determine how a person, movement or technology influenced this event. How did one or more of those alter the global culture? How do any (or all) of those bring desirable or undesirable change?

You should have a minimum of 5 sources, one of which is scholarly. Use MLA for your citation format, but dont worry about indentations or margins

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Paris Attacks November 2015 – How We Know What We Know

Paris Attacks November 2015 – How We Know What We Know
Paper, Order, or Assignment Requirements

Choose a world event that occurred sometime between September 1, 2015 and February 8, 2016, and create a 1,000-word wiki that explains, from a critical and global perspective, how the trajectory of this event was shaped by various information systems. Your goal is to evaluate the authenticity and credibility of information reported about this world event, so the essay should demonstrate your understanding of the diverse and complex nature of information, bringing order to, and maximizing the value of, the information for the audience it reaches. True to the title of this course, your essay will help you come full circle, in that you must explain how we know what we know about this world event. Thus, your essay should state a thesis, and your paper should analyze, how the event was covered or how information about the event was manipulated or suppressed. Finally, your essay should address what all that means on a global level.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Database and Data Warehousing Design

Database and Data Warehousing Design
Paper, Order, or Assignment Requirements

Database and Data Warehousing Design

This assignment consists of two (2) sections: a design document and a revised project plan. You must submit both sections as separate files for the completion of this assignment. Label each file name according to the section of the assignment it is written for. Additionally, you may create and / or assume all necessary assumptions needed for the completion of this assignment.

One of the main functions of any business is to be able to use data to leverage a strategic competitive advantage. This feat hinges upon a company’s ability to transform data into quality information. The use of relational databases is a necessity for contemporary organizations; however, data warehousing has become a strategic priority due to the enormous amounts of data that must be analyzed along with the varying sources from which data comes. Since you are now the CIO of a data-collection company which gathers data by using Web analytics and operational systems, you must design a solution overview that incorporates data warehousing. The executive team needs to be clear about what data warehousing can provide the company.

Section 1: Design Document
1.Write a four to six (4) page design document in which you:
◦Support the need for data warehousing within your company and elaborate on the best practices that the company will adhere to.
◦Create a schema that supports the company’s business and processes. Explain and support the database schema with relevant arguments that support the rationale for the structure. Note: The minimum requirement for the schema should entail the tables, fields, relationships, views, and indexes.
◦Create an Entity-Relationship (E-R) Diagram relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix. Explain your rationale behind the design of your E-R Diagram.
◦Create a Data Flow Diagram (DFD) relating the tables of your database schema through the use of graphical tools in Microsoft Visio or an open source alternative such as Dia. Note: The graphically depicted solution is not included in the required page length but must be included in the design document appendix.
◦Illustrate the flow of data including both inputs and outputs for the use of a data warehouse. The diagram must map data between source systems, data warehouses and specified data marts. The diagram should map data between source systems, data warehouses, and specified data marts. Note: The graphically depicted solution is not included in the required page length.
Your assignment must follow these formatting requirements:
•Be typed, double spaced, using Times New Roman font (size 12), with one-inch margins on all sides; citations and references must follow APA or school-specific format. Check with your professor for any additional instructions.
•Include a cover page containing the title of the assignment, the student’s name, the professor’s name, the course title, and the date. The cover page and the reference page are not included in the required assignment page length.
•Include charts or diagrams created in MS Visio or Dia as an appendix of the design document. All references to these diagrams must be included in the body of the design document.
Section 2: Revised Project Plan

Use Microsoft Project to:
2.Update the project plan from Project Deliverable 2: Business Requirements, with three to five (3-5) new project tasks each consisting of five to ten (5-10) sub-tasks.
The specific course learning outcomes associated with this assignment are:
•Summarize how information systems represent a key source of competitive advantage for organizations.
•Develop information systems-related activities to maximize the business value within and outside the organization.
•Use technology and information resources to research issues in information systems.
•Write clearly and concisely about strategic issues and practices in the information systems domain using proper writing mechanics and technical style conventions.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

How would you handle this issue on the MHS operating budget for next year?

Budgeting
Paper , Order, or Assignment Requirements

Budget assumptions for this exercise include both inpatient and outpatient revenue and expense. Assumptions are as follows:493494
As to the initial budget:• The budget anticipated 30,000 inpatient days this year at an average of $650 revenue per day. • Inpatient expenses were budgeted at $600 per patient day. • The budget anticipated 10,000 outpatient visits this year at an average of $400 revenue per visit. • Outpatient expenses were budgeted at $380 per visit.
As to the actual results:• Assume that only 27,000, or 90%, of the inpatient days are going to actually be achieved for the year. • The average revenue of $650 per day will be achieved for these 270,000 inpatient days. • The outpatient visits will actually amount to 110%, or 11,000 for the year. • The average revenue of $400 per visit will be achieved for these 11,000 visits. • Further assume that, due to the heroic efforts of the Chief Financial Officer, the actual inpatient expenses will amount to $11,600,000 and the actual outpatient expenses will amount to $4,000,000.

Required
1. Set up three worksheets that follow the format of those in Example 15A. However, in each of your worksheets make two lines for revenue; label one as Revenue—Inpatient and the other Revenue—Outpatient. Add a Revenue Subtotal line. Likewise, make two lines for expense; label one as Expense—Inpatient and the other Expense—Outpatient. Add an Expense Subtotal line. 2. Using the new assumptions, complete the first worksheet for “As Budgeted.” 3. Using the new assumptions, complete the second worksheet for “Actual.” 4. Using the new assumptions, complete the third worksheet for “Static Budget Variance.”

Assignment Exercise 15–1: Budgeting

Select an organization: either from the Case Studies in Chapters 27–28 or from one of the Mini-Case Studies in Chapters 29–31.

Required
1. Using the organization selected, create a budget for the next fiscal year. Set out the details of all assumptions you needed in order to build this budget. 2. Use the “Checklist for Building a Budget” (Exhibit 15–2) and critique your own budget.

Assignment Exercise 15–2: Budgeting

Find an existing budget from a published source. Detail should be extensive enough to present a challenge.494495

Required
1. Using the existing budget, create a new budget for the next fiscal year. Set out the details of all the assumptions you needed in order to build this budget. 2. Use the “Checklist for Building a Budget” (Exhibit 15–2) and critique your own effort. 3. Use the “Checklist for Reviewing a Budget” (Exhibit 15–3) and critique the existing budget.

Assignment Exercise 15–3: Transactions Outside the Operating Budget

Review Figure 15–2 and the accompanying text.
Metropolis Health System (MHS) has received a wellness grant from the charitable arm of an area electronics company. The grant will run for 24 months, beginning at the first of the next fiscal year. Two therapists and two registered nurses will each be spending half of their time working on the wellness grant. All four individuals are full-time employees of MHS. The electronics company has only recently begun to operate the charitable organization that awarded the grant. While they have gained all the legal approvals necessary, they have not yet provided the manuals and instructions for grant transactions that MHS usually receives when grants are awarded. Consequently, guidance about separate accounting is not yet forthcoming from the grantor.

Required

How would you handle this issue on the MHS operating budget for next year?

Assignment Exercise 15–4: Identified Versus Allocated Costs in Budgeting

Review Figure 15–3 and the accompanying text.
Metropolis Health System is preparing for a significant upgrade in both hardware and software for its information systems. As part of the project, the Chief of Information Operations (CIO) has indicated that the Information Systems (IS) department can change the format of the MHS operating budgets and related reports before the operating budget is constructed for the coming fiscal year. The Chief Financial Officer (CFO) has long wanted to modify what costs are identified and what costs are allocated (along with the method of allocation). This is a golden opportunity to do so. To gain ammunition for the change, the CFO is preparing to conduct a survey. The survey will obtain a variety of suggestions for potential changes in allocation methods for the new operating budget report formats. You have been selected as one of the employees who will be surveyed.

Required

You may choose your role for this assignment, as follows:
Refer to the “MHS Executive-Level Organization Chart” (Figure 28–2 in the MHS Case Study). (1) Either (a) choose any type of patient service that would be under the 495496direction of the Senior Vice President of Service Delivery Operations or (b) choose any other function shown on the organization chart. (Your function could be a whole department or a division or unit of that department. For example, you might choose Community Outreach or Human Resources Operations or the Emergency department, etc.) (2) Make up your own organization chart for other employee levels within the function you have chosen. (3) Now make up another chart that indicates the operating budget costs you think would be mostly identifiable for the department or unit or division you have chosen and what other operating budget costs you think would be mostly allocated to it. (You may use Figure 15–3 as a rough guide, but do not let it limit your imagination.

Example 16A: Description of Capital Expenditure Proposals Scoring System

Worthwhile Hospital has a total capital expenditure budget for next year of five million dollars. Of this amount, three million is already committed as spending for capital assets that have already been acquired and are in place. The remaining two million dollars is available for new assets and for new projects or programs.
Worthwhile Hospital typically divides the available capital expenditure funds into monies available for inpatient purposes and monies available for outpatient purposes. This year the split is proposed to be 50-50.
The hospital’s CFO is also proposing that a scoring system be used to evaluate this year’s proposals. She has set up a scoring system that allows a maximum of five points. Thus the low is a score of one point and the high is a score of five points.
In addition to the points earned by a funding proposal, the CFO will allow one “bonus point” for upgrading existing equipment and one “bonus point” for funding expansion of existing programs.

Practice Exercise 16–I: Capital Expenditure Proposals

Jody Smith, the director who supervises the Intensive Care Units, wants to secure as much of the one million dollars available for inpatient purposes as is possible for the ICU. At the same time Ted Jones, the director who supervises the Surgery Unit, also wants to secure as much of the one million dollars available for inpatient purposes as is possible for his Surgery Unit.
Given the CFO’s new scoring system, how should Jody go about choosing exactly what to request?496497

Assignment Exercise 16–1: Capital Expenditure Proposals

Ted Jones, the Surgery Unit Director, is about to choose his strategy for creating a capital expenditure funding proposal for the coming year. Ted’s unit needs more room. The Surgery Unit is running at over 90% capacity. In addition, a prominent cardiology surgeon on staff at the hospital wants to create a new cardiac surgery program that would require extensive funding for more space and for new state-of-the-art equipment. The surgeon has been campaigning with the hospital board members.

Required

What should Ted decide to ask for? How should he go about crafting a strategy to justify his request, given the hospital’s new scoring system?

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"

Analytical Capstone Project

Analytical Capstone Project
Paper , Order, or Assignment Requirements

Accounting Information Systems
Assignment: Analytics Project

Overview
Students are expected to apply relevant concepts and tools to complete a data analytics project. You will work as part of the analytics (smaller) team formed during the second week of class. Only one submission per team is required for each project.

Required Tasks
You will be using Computer Assisted Audit Techniques (CAATs) to evaluate travel expenses for Tampa Electronics in an attempt to find potential fraud, policy violations, or other anomalies based on the data available. To report your findings, you will create an executive summary and detailed report to hand to management.

The case refers to the possibility of using Microsoft Excel. You are welcome to use whatever tool you wish when completing the case, but I suggest Microsoft Excel. It is the tool I will use for in-class examples, so if you decide to use something else you would need to learn it on your own. Excel is the only tool I will officially support in office hours or in class.

1. Read the Tampa Electronics Case that is posted. It provides background on the company, the audit task, and guidance on what steps should be taken in the audit. There is an accompanying file, also loaded that contains the data that you will be performing fraud and compliance tests on.

2. Your will need to perform and report the results of all of the final list of tests that we generate. This list will be posted.

3. For the project deliverables, you will generate an executive summary for Mr. Yorke, CFO of Tampa Electronics (section 1 of the report), create a structured summary of the tests and findings (section 2), and end the report with a more detailed description of the findings and the data analysis procedures you undertook (section 3). These sections are described in more detail next:

Section 1. Executive Summary
The executive summary is your first impressive and should be written with particular care. It should be something you would be proud to hand to your boss’s boss’s boss with your name on it. When grading, I will be most critical of the writing in this section. For this project, the executive summary should include:
1. Introduce your group and thank management for the opportunity.
2. Explain what you were asked to do (briefly describe the analytics project).
3. Explain the basics of how you did the project (where you got the data, what tools/techniques you used to complete the project).
4. Provide a brief description of what you believe to be the most concerning results of your testing (what you think the executives should be most concerned about).
5. End the executive summary by describing what is in the rest of the report (where they can go in the report to see a summary and more details about the findings and your procedures).

Section 2. Test Results Summary
In section two of the report create a summary table of the tests you performed and the results:
Test # Title of the Test Summary of Test Results
40 Testing that assignment instructions are followed 3 instruction violations found
• Bert did not include all of the required elements in the executive summary
• Ernie did not produce the summary of findings exactly as described
• Super Grover 2.0 did not describe what the findings likely mean and was inconsistent in the level of detail provided on how the test was performed.
41 Testing how many awesome students there are in my class 44 students in this class (the entire population) are awesome

The table you create should have three columns:
1. The first column should contain a test number (1, 2, 3, etc).
2. The second column should include a short descriptive title of the test you conducted.
3. The third column should be a summary of the findings for that test. If there are five or fewer findings in a particular test, include a list of the findings within the table (ie names, dates). if there are more than five results, please just put the total number of findings.
a. Hint: Be specific, do not give results in generalities. Every answer should be quantified with a specific number included.
b. The accuracy of your findings will be determined by a review of this section of the report. You must have a clear and correct answer here to get points for a particular test.

Section 3. Testing Details
Section three of your report should be a detailed description of the steps you took to perform each test and a listing of the findings:
1. Begin each test description with the corresponding test number that you used in the summary table you created in section 2.
2. Next, give a concise summary of the findings for that test (ie we found 5 employees that took a total of 20 trips where….).
3. Next, briefly discuss what you think the findings mean (do you think this is a strong indicator of fraud, or could there be plausible alternative explanations)?
4. Next, create a description of the steps to took to perform each test. The description should be detailed enough to replicate, but can assume an advanced knowledge of excel procedures. You can leverage the examples used in class as a rough guide for how detailed to make the procedure descriptions. You may do this in a narrative (paragraph) or bullet-point format – whichever you believe to be most effective.
5. Finally, present the (nicely formatted) raw findings and/or some graphical depiction of the findings. If your raw findings consist of a list of more than 20 findings, please only include the first 20 in your report and state the number that were omitted from the report.

Evaluation
Your grade will be based on completion of all required steps, the accuracy and completeness of the findings, and the quality of the write up. You must do all required tests as agreed to by the class. A component of the project involves intensive writing. You will probably not need to use outside sources in your write-up, but if you do – you must follow appropriate citation practices. As always, academic honesty and integrity will be monitored and enforced. You are instructed to perform all work and the writeup within your individual group and should not share any part of your project with any other group. All members of a group are responsible for the work product that is turned in, do not compromise on the integrity of your work as it can affect more people than just you.

 

"Looking for a Similar Assignment? Get Expert Help at an Amazing Discount!"