Population health promotion involves the improvement of the quality of life of the community through the provision of primary, secondary and tertiary healthcare services. The community health nurse should, therefore, play a supervisory role of the community member to control and regulate their health behavior. The primary function of the nurse in the partnership with the community stakeholders is to guide and advise them on the healthy practice that can promote a healthy living of the community (Eldredge et al., 2015).
For example, the community health nurse may choose to push community stakeholders to support each household’s building of a toilet. In this approach, the nurse will be delivering primary care through community stakeholders who have the ability to stop the spread of illness within the community. In addition, the nurse can use the community’s stakeholders to set up a meeting where she can counsel and instruct the people on behaviors related to seeking health and engaging in health-promoting activities.
Evaluating local resources such as nonprofits and religious institutions is essential to increasing community involvement in health promotion.For instance, religious institutions are against some social acts that can encourage the spread of diseases like premarital sex. Appraising such values in such institutions helps to improve the community’s understanding and participation in disease prevention and health promotion.
Using 200-300 words APA format with references in support of the discussion
Explain the role of the community health nurse in partnership with community stakeholders for population health promotion. Explain why it is important to appraise community resources (nonprofit, spiritual/religious, etc.) as part of a community assessment and why these resources are important in population health promotion.
Imagine that you are a legislative consultant hired to assess the influence of stakeholders and interest groups on a health policy issue. Your supervisor has asked that you present your assessment findings to the senior leadership of your organization to inform their decisions on how best to approach their intended organization-wide position statement regarding this issue.
As a first step, you will select one of three health policy issues from the Project Two Health Policy Issue Scenarios document. As part of the background study, you will conduct preliminary research about the selected issue and analyze the impact of the selected issue on various stakeholders. This background study and assessment of the selected issue will serve as a foundation for your Project Two final presentation. In this Project Two Preparation assignment, you will essentially analyze the selected health policy issue and describe how it influences the decision-making process in healthcare.
Your research in this Project Preparation will be specific to the nonfinancial impact of the selected policy on various stakeholders. In your second Project Preparation for Project Two, which is due in Module Seven, you will explore the financial implications of the selected issues. Together, both of these Project Preparation assignments will prepare you for the Project Two submission due in Module Nine.
Prompt
Create a research report summarizing your assessment findings on your chosen health policy issue. This research report will serve as a support document in the Project Two final submission.
You must cite at least three sources to support your claims. You may cite no more than one source from the module resources; all other resources must come from your own research. In other words, you may cite no more than one resource from the Resources section of this module. For additional help completing this assignment, refer to the Shapiro Library Guide: Nursing – Graduate item in the Start Here module. You may also use the Online Writing Center, located in the Academic Support module.
Use this resource to help you complete this assignment: IHP 610 Project Two Health Policy Issue Scenarios
Specifically, you must address the following rubric criteria:
Introduction
Health Policy Issue: Describe your chosen health policy issue in a clear, concise manner. Consider the following guiding questions in your response:
Why did you choose this health policy issue for your Project Two work?
How might this health policy issue be explained to someone who has never heard of it before?
Key Stakeholders and Interest Groups: Identify three key stakeholders and/or interest groups impacted by your chosen issue. Consider the following guiding questions in your response:
Who are the stakeholders and/or interest groups that will be primarily affected by this issue, either positively or negatively?
How might vulnerable populations and underserved areas be affected by this issue?
Influence on Decision Making
Stakeholder Needs: Describe the nonfinancial needs of the identified three key stakeholders and/or interest groups with respect to your chosen issue. Consider the following guiding questions in your response:
How are the nonfinancial needs of the identified stakeholders and/or interest groups affected by the selected issue?
How does this issue impact vulnerable populations or underserved areas?
Health Policy Influence: Describe the kinds of nonfinancial influence that the three identified key stakeholders and/or interest groups can have on health policies. Consider the following guiding questions in your response:
Which three stakeholders and/or interest groups can have significant nonfinancial influence on the selected issue?
Which three stakeholders and/or interest groups have subtle or covert nonfinancial influence on the selected issue?
Benefits and Disadvantages: Describe how the identified three stakeholders and/or interest groups might benefit or be disadvantaged by your chosen issue. Do not include any financially related benefits and disadvantages. Consider the following guiding questions in your response:
Which of the identified stakeholders and/or interest groups benefit from this issue?
Which of the identified stakeholders and/or interest groups are disadvantaged by this issue?
How might those in vulnerable populations or underserved areas be benefited or disadvantaged by this issue, not including financial benefits or disadvantages?
Value Conflict Analysis: Describe the potential value conflicts between identified stakeholders and/or interest groups relating to your chosen issue. Consider the following guiding question in your response:
What nonfinancial value conflicts might the identified stakeholders have concerning this issue, and why?
What to Submit
Your submission should be a 2- to 3-page Word document. You must also include an APA-style title page. Use 12-point Times New Roman font, double spacing, and 1-inch margins. Sources should be cited according to APA style.
Imagine that you are a legislative consultant hired to assess the influence of stakeholders and interest groups on a health policy issue. Your supervisor has asked that you present your assessment findings to the senior leadership of your organization to inform their decisions on how best to approach their intended organization-wide position statement regarding this issue.
As a first step, you will select one of three health policy issues from the Project Two Health Policy Issue Scenarios document. As part of the background study, you will conduct preliminary research about the selected issue and analyze the impact of the selected issue on various stakeholders. This background study and assessment of the selected issue will serve as a foundation for your Project Two final presentation. In this Project Two Preparation assignment, you will essentially analyze the selected health policy issue and describe how it influences the decision-making process in healthcare.
Your research in this Project Preparation will be specific to the nonfinancial impact of the selected policy on various stakeholders. In your second Project Preparation for Project Two, which is due in Module Seven, you will explore the financial implications of the selected issues. Together, both of these Project Preparation assignments will prepare you for the Project Two submission due in Module Nine.
Prompt
Create a research report summarizing your assessment findings on your chosen health policy issue. This research report will serve as a support document in the Project Two final submission.
You must cite at least three sources to support your claims. You may cite no more than one source from the module resources; all other resources must come from your own research. In other words, you may cite no more than one resource from the Resources section of this module. For additional help completing this assignment, refer to the Shapiro Library Guide: Nursing – Graduate item in the Start Here module. You may also use the Online Writing Center, located in the Academic Support module.
Use this resource to help you complete this assignment: IHP 610 Project Two Health Policy Issue Scenarios
Specifically, you must address the following rubric criteria:
Introduction
Health Policy Issue: Describe your chosen health policy issue in a clear, concise manner. Consider the following guiding questions in your response:
Why did you choose this health policy issue for your Project Two work?
How might this health policy issue be explained to someone who has never heard of it before?
Key Stakeholders and Interest Groups: Identify three key stakeholders and/or interest groups impacted by your chosen issue. Consider the following guiding questions in your response:
Who are the stakeholders and/or interest groups that will be primarily affected by this issue, either positively or negatively?
How might vulnerable populations and underserved areas be affected by this issue?
Influence on Decision Making
Stakeholder Needs: Describe the nonfinancial needs of the identified three key stakeholders and/or interest groups with respect to your chosen issue. Consider the following guiding questions in your response:
How are the nonfinancial needs of the identified stakeholders and/or interest groups affected by the selected issue?
How does this issue impact vulnerable populations or underserved areas?
Health Policy Influence: Describe the kinds of nonfinancial influence that the three identified key stakeholders and/or interest groups can have on health policies. Consider the following guiding questions in your response:
Which three stakeholders and/or interest groups can have significant nonfinancial influence on the selected issue?
Which three stakeholders and/or interest groups have subtle or covert nonfinancial influence on the selected issue?
Benefits and Disadvantages: Describe how the identified three stakeholders and/or interest groups might benefit or be disadvantaged by your chosen issue. Do not include any financially related benefits and disadvantages. Consider the following guiding questions in your response:
Which of the identified stakeholders and/or interest groups benefit from this issue?
Which of the identified stakeholders and/or interest groups are disadvantaged by this issue?
How might those in vulnerable populations or underserved areas be benefited or disadvantaged by this issue, not including financial benefits or disadvantages?
Value Conflict Analysis: Describe the potential value conflicts between identified stakeholders and/or interest groups relating to your chosen issue. Consider the following guiding question in your response:
What nonfinancial value conflicts might the identified stakeholders have concerning this issue, and why?
What to Submit
Your submission should be a 2- to 3-page Word document. You must also include an APA-style title page. Use 12-point Times New Roman font, double spacing, and 1-inch margins. Sources should be cited according to APA style.
How could JetBlue have better communicated with its internal stakeholders across the country on Valentine’s Day and during the days that followed to enhance its image with customers?
Should the corporate communications team at JetBlue have arranged for CEO David Neeleman to appear on the national television news and talk show circuit following the crisis? What might be the potential benefits and risks to the company’s reputation?
Would you recommend a corporate advertising program for JetBlue?
If implemented, how would you market the JetBlue Airways Customer Bill of Rights to external and internal stakeholders? How would this affect JetBlue’s reputation?
CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com on JetBlue have better communicated with its internal stakeholders across the country on Valentine’s Day and during the days that followed to enhance its image with customers?
In this course, you have explored various concepts and principles related to public health, health law, health policy, finance, and risk management. You also learned how stakeholders and interest groups influence health policies and laws.
Now, it is time to reflect on how the key learnings from this course can be applied to your career. This assignment is a wonderful opportunity for you to review your own journey throughout this course. Specifically, think about how this course has helped shape your view on health policies and laws, as well as how stakeholders influence and are influenced by said health policies and laws.
Prompt
Create a journal to reflect on the knowledge and skills you have gained in this course and how these may apply to your career.
Specifically, you must address the following rubric criteria:
Course Knowledge: Describe your overall experience in this course, including new information learned. Consider the following questions in your response:
How has your perception of health policies and laws changed since beginning Module One?
How has your perception of stakeholders’ influence on health policies and laws changed since beginning Module One?
Career Growth: Describe how understanding health policies and laws can help further your career in healthcare. Consider the following questions in your response:
How will you apply the knowledge and skills learned in this course to your career or to future courses in this program?
Career Opportunities: Describe two potential career opportunities involving health policies and laws. Consider the following questions in your response:
How would these two career opportunities help you reach your personal goals?
Has your perception of your ideal healthcare job changed during this course? If so, how? If not, why not?
1. During communication, a common problem occurs when you encounter two stakeholders who have conflicting ideas about a software. That is, they have mutually contradictory requirements. Develop a process pattern that addresses this problem and suggest a practical approach to it.
Original and non-plagiarized custom papers. Our writers develop their writing from scratch unless you request them to rewrite, edit or proofread your paper.
Timely Delivery. capitalessaywriting.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction. Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Privacy and safety. It’s secure to place an order at capitalessaywriting.com We won’t reveal your private information to anyone else.
Writing services provided by experts. Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy our bonus services. You can make a free inquiry before placing and your order and paying this way, you know just how much you will pay. A verdict was rendered against three parent chaperones. How was the third parent included in the case?
Premium papers. We provide the highest quality papers in the writing industry. Our company only employs specialized professional writers who take pride in satisfying the needs of our huge client base by offering them premium writing services During communication, a common problem occurs when you encounter two stakeholders who have conflicting ideas about a software
Question: This question is about corporate social responsibility (CSR). in a well organized essay, provide the following.
1. Who are the stakeholders of a business?
2. Identify and briefly explain the three components of the triple bottom line framework and why corporate stakeholders are a consideration in tis theory. Describe an example of a company that utilizes this frame work.
3. Explain what is greenwashing.
4. Explain how you would determine if a company if engaged in greenwashing.
Cite sources appropriate in text of your essay and in full citation reference at the end. (APA7th)
Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Who are the stakeholders of a business?
The purpose of this assignment is to finalize an internal business proposal that outlines how you will implement the solution to the problem you have identified in your organization.
Throughout the course, you have completed most of the necessary research and assignments needed to generate the final business proposal. Refer to the “Business Proposal Project Summary” document, as needed. The key sections you will focus on creating are the Executive Summary and the Conclusion/Call to Action.
Using feedback from the assignments in Topics 5-7 (which i have attached), create your final business proposal document. Evidence of revision from instructor feedback will be assessed on the final business proposal, which should include each of the sections listed below.
Executive Summary (250 words) provides a short summary of the entire proposal so key stakeholders can see an overview of the proposal and understand it without reading the entire document.
Purpose Statement (100-250 words) provides clear statement of why the business proposal is being made.
Problem Statement (revised as needed from Topic 1 assignment feedback) including specific data (statistics and numbers) related to how the problem impacts the business. This part of the proposal should include the graph/chart/data you collected in Part 1 of the Topic 2 assignment.
Data and Research Findings (250-500 words) should include a summary of what you learned from conducting research related to what has already been done to address the organizational problem. This part of the proposal should include the graph/chart/data you collected in Part 2 of the Topic 2 assignment.
Proposed Solution (250-500 words) should include a summary of the top three problem solutions you considered to address the problem. In addition to including the graph/chart/data you collected in Part 3 of the Topic 2 assignment, this section should provide a succinct discussion of the pros and cons of implementing each of the top three solutions being considered to address the problem.
Stakeholder Analysis and Benefits (500 words, revised as needed from Topic 3 assignment feedback) summarizes all data and information related to the key stakeholders affected by the proposed problem solution along with a summary of benefits to be gained by stakeholders if the problem solution is implemented.
Change Management Plan (250-500 words) clearly articulates specific methods and strategies to be utilized to manage organizational changes associated with the selected solution implementation.
Implementation Methods (250-500 words) summarize specific strategies that will used to implement the problem solution, including time and costs associated with implementation of the solution.
Evaluating Success (250 words) summarize specific measures you will use to evaluate the success of the problem solution.
Conclusion/Call to Action (100 words) provides specific steps you would like key stakeholders and sponsors to take in the implementation of the proposed solution.
It is important to include specific data throughout the business proposal. Include statistics that support the problem statement that can be used to establish and track goals; relate to specifics of implementation, timing, and cost; and illustrate stakeholder benefits. The proposal is an internal document that will be read by stakeholders within the organization where the problem exists, so keep this in mind and focus on this audience as you write. Within the Word document, include subsection titles to organize content according to the categories listed above to provide easy reference points for the reader
Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. proposal so key stakeholders can see an overview of the proposal and understand it without reading the entire document
ASSESSMENT BRIEF Subject Code and Name ACCT6001 Accounting Information Systems Assessment Assessment 3 – Case Study – Excel Individual/Group Individual Learning Outcomes (d) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases (e) Communicate with IT professionals, stakeholders and user groups of information systems Weighting 25% Total Marks 100 marks Context: The spreadsheet is a powerful tool that has become entrenched in business processes worldwide. A working knowledge of Excel is a crucial skill for accountants. This assignment aims to assess the student’s ability to create spreadsheets. Students will be using raw data and summarising them in a user-friendly format to aid decision making. Students will need to recommend additional excel-based analysis that facilitates business decision making. Submission Instructions: Students need to submit their Excel Workbook which includes the analysis and recommendation sheet. The file should be provided in the following format: Student ID_ Student Name_ ACCT6001 Assessment 3.xlxs Example: 0009989t_Adam Smith_ACCT6001 Assessment 3.xlxs Eljay School A large Australian School has recently opened an online education division called Eljay. The school provides online education services to students from around the world. In an effort to improve the services offered to students, a job management system was developed to improve the responses provided to student queries. At the end of every week, a manager from the administration team archives an excel file that contains data about student queries for that week. The manager of the administration team believes that the data within this spreadsheet would be valuable for business decision making. However, employees within the team lack the technical knowledge to analyse and interpret this data. Subsequently, the manager is unsure how to utilise this data to gain insights on how to improve response times and outcomes for students. The administration team manager decided to hire you to assist in analysing and interpreting the data. The table below shows a data file that was archived containing information on student queries for one week. Table 1 Job Code Student ID Student Name Date Opened (d/mm/yyyy h:mm) Date Closed (d/mm/yyyy h:mm) Hours Charged Job Type Job Priority Job Status 0001 0009990t Charles Brody 01/08/2020 10:30:49 01/08/2020 12:30:49 2 IT Important Closed 0002 0001090t John Lucas 02/08/2020 15:23:26 02/08/2020 16:23:26 1 IT Normal Closed 0003 0009989t Adam Smith 02/08/2020 18:21:46 04/08/2020 16:20:23 1 Teaching Less Important Closed 0004 0001100t Maree Sarah 03/08/2020 09:36:21 05/08/2020 12:20:23 4 Teaching Normal Closed 0005 0009988t Eve Bonny 04/08/2020 12:24:20 6 Assessment Important Re Process 0006 0001120t Adelle Smith 04/08/2020 09:28:26 1 Assessment Less Important Open 0007 0009987t Jill Water 05/08/2020 11:30:33 3 Assessment Important In Process 0008 0001130t Jack Hill 06/08/2020 12:10:33 06/08/2020 14:30:33 2 Assessment Important Closed While only a small number of queries were received from students in the first week of the month, student queries are expected to go up over the remainder of the month. However, before getting actual data from the job management system in the coming weeks, Eljay school has asked you to explore the possible analyses that can be performed if using the current output. Eljay provided you with a document listing specific instructions on what you are expected to do in Excel. The instructions are listed below. Requirements (1) Open an Excel Workbook and name it as ‘Student ID_ Student Name_ ACCT6001 Assessment 3’ (i.e. 0009989t_Adam Smith_ACCT6001 Assessment 3). Create a worksheet labelled as ‘Job Data’. Make a table similar to the one above using hypothetical details for 50 students. The table should include the following columns: Job Code, Student ID, Student Name, Date Opened, Date Closed, Job Type, Job Priority, Job Status. In your hypothetical data, assume: a) all student queries were made by students located in Australia, b) at least 30 jobs that have a job status of “closed” c) at least one of each Job Status is included in the data set for each Job Type. For example, include at least: • “open”, “in process”, “re process”, and “closed” entries for “IT”, • “open”, “in process”, “re process”, and “closed” entries for “Teaching”, and • “open”, “in process”, “re process”, and “closed” entries for “Assessment” d) All queries are made between 01/08/2020 and 28/08/2020. e) Each student lodges a query in the job management system only once. So, each row of data contains information about a specific student. (2) In the ‘Job Data’ worksheet, add a column labelled as ‘Time taken to close job. This column should show the time spent resolving each job (e.g. student query). The values for this column should be reported using the “number” format and calculated using a: a) combination of the date opened and date closed columns. b) formula that only includes entries with a “Job Type” equal to “Closed”. (3) Create a new worksheet in your workbook and label it as ‘Job Duration’. In this worksheet: a) Report the descriptive statistics (i.e. mean, median, maximum, minimum) for both the “Time taken to close job” column added to the ‘Job Data’ worksheet and the “Hours Charged” column. A brief commentary on the results should be provided (between 50 and 100 words). b) Include another table in this worksheet showing for each week the: • Total number of jobs, • Total number of jobs “Closed”, • Total number of “Important” jobs “Open”, and • Average time taken to close “Important” jobs. The values for each week should be calculated using Excel formulas based on values from the ‘Job Data’ worksheet (e.g. the values in your table should change if values in the ‘Job data’ table change). The table may look like Table 2. Table 2 Week 1 Week 2 Week 3 Week 4 Job Count 8 13 9 15 Jobs Closed 5 6 7 12 “Important” Jobs “Open” 1 1 2 3 Average time taken to close “Important” jobs 1.5 1.8 2.6 3.9 The administration team believe that the problem with Key Performance Indicators focused on the number of jobs closed each week was that “important” jobs were not being prioritised. Do you find support for this belief? Use a chart(s) to report the results for correlation to support your answer. (4) Create a worksheet labelled as ‘Job Type’. Include a table in this worksheet showing the number of jobs for each week grouped by the three different job types. The values should be directly linked to the ‘Job Data’ worksheet. The table may look like Table 3. Table 3 Job Type Week 1 Week 2 Week 3 Week 4 Total Assessment 4 6 4 7 21 IT 2 3 2 3 10 Teaching 2 4 3 5 14 Total 8 13 9 15 45 (5) Create a worksheet and label it as ‘Pivot Tables and Charts’. Build tables and charts that show the average Job Duration by Job Type and Job Priority. Provide these by creating 2 pivot tables/charts (one for each Job Type and Job Priority). Place both of these tables and charts on the same worksheet. A sample for output of Job Duration by Job Type is shown in Figure 1. For each table/chart, comment on whether you think the school would be able to introduce a policy of no more than 2 working days (48 hours) to resolve students queries. Figure 1 (6) Of the employees directly responsible for resolving student queries, the school currently has 3 contract-employees working in the administration team, 2 in the teaching team, and 1 in the corporate services team. Contract employees from the administration team charge the school $60 per hour, teaching team employees charge $80 per hour and corporate services $110 per hour. The administration team manager, who receives a salary of $70,000 per annum, asked you about using data from the job management system to develop a monthly budget. The following information was gathered for you to use in developing this budget. 1. “Hours charged” for “Assessment” jobs are invoiced by the administration team 60% of the time and the remaining 40% of the “Hours charged” are invoiced by the teaching team. 2. All “Hours charged” for “IT” jobs are invoiced by corporate services team 3. The “Hours charged” to “Teaching” jobs are invoiced by the teaching team 90% of the time while the remaining 10% are invoiced by the administration team. Create a ‘Budget Summary Report’ worksheet. Include a table with a column for the Team, Estimated hours, and Total Costs. The values for the estimated hours charged column should be linked to the ‘Job Data’ worksheet. Use appropriate functions to fill out the remaining cells of the table. A sample table is shown in Table 5. Table 5 Team Estimated hours Cost (per hour) Total costs Administration 33 60 71,890.00 Corporate Services 48 110 5,280.00 Teaching 51 80 4,080.00 Generate a pie chart to show the distribution of expected costs across different teams. (7) Due to the recent economic crisis around the world, the school would like to cut costs and automate several processes. Given strong industry demand for using Artificial Intelligence (AI) tools to manage customer queries, you believe that a large number of student queries could be managed using an AI bot. However, to implement this technology at the school, a part-time employee will need to be employed along with a software-as-a-service (SAAS) subscription. The part-time employee will cost $35,000 per year. However, you expect that the budgeted costs (in requirement 6) will be significantly reduced. If the school purchases the AI bot, it will half the amount of time required by the administration manager to manage student queries, reducing this cost to $35,000 per year. The percentage of “Hours charged” will also decrease for all job types and only a small charge per “Closed” job will be incurred for the SAAS subscription (as shown in Table 6). Table 6 Team Reduction in “Hours charged” (%) Charge per “Closed” job Assessment 60% $1.20 IT 30% $2.20 Teaching 20% $1.60 If the School does not implement the AI bot tool, the number of jobs performed by employees will remain unchanged. Do you recommend the School purchases the AI bot? (8) Create a worksheet labelled as ‘Analysis and Recommendation’. This worksheet should contain the following three sections. a) Findings – Briefly summarise your findings based on the analysis performed in requirement 2 to requirement 7. b) Recommendation for additional analysis – In this section, you should comment on whether additional analyses can be performed using the types of data that the administration team manager currently receives from the job management system. You should provide one example of an additional analyses that can be performed using the given data and explain how to perform the analysis. Comment on how the additional analysis would help the administration team manager to make business decisions. c) Recommendation for additional data – Currently there is an option for the administration manager to get other types of data from the job management system. Provide one practical example of an additional type of data that should be collected about student queries (e.g. jobs). Suggest the type of analysis that can be done using the additional data. Comment on how the analysis on additional data would help the administration department improve business decision making. Learning Rubric: Assessment 1 Assessment Criteria Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% Formulae, formatting and cell references 20 % Formulae, formatting and cell reference are mostly incorrect and incomplete. Incorrect calculations and major mistakes in formulas are present. More than 50% of the formulae, formatting and cell references are correct. Several mistakes are present in calculations and formulas that have been used. Majority of the formulae, formatting and cell references are correct. There are minor discrepancies or mistakes in calculations and formulas used. Almost all formulae, formatting and cell references are correct. All calculations are correct and appropriate formulas have been used. All formulae, formatting and cell references are correct. All calculations are correct and appropriate formulas have been used. Tables, graphical presentation of data, Pivot Table 40 % Some tables, graphs, pivot tables are missing or created with wrong or incomplete data. Poor visual presentation of data. Some mistakes are present in creating tables, graphs and pivot tables. Some mistakes have been done in data used, but overall student has proven working knowledge of the Excel tools used. Visual presentation of data needs improvement in some cases. Tables, graphs and pivot tables have been created with minor mistakes. Visual presentation could be improved. There are minor mistakes in table creation, graphs and pivot table. Overall very good understanding of the Excel tools with professional presentation of data. Tables, graphs and pivot table have been created correctly with excellent presentation of data. The student has shown excellent understanding of the Excel tools used in the assessment. ACCT6001_Assessment Brief 3_Case Study – Excel Page 6 of 7 Analysis and Recommendation 40% Recommendations and analysis are not provided or very weak. Limited application/ recommendations based upon analysis. The student demonstrated the ability to analyse and summarise data for the purpose of decision making. Recommendations are valid, but could be improved. Well-developed analysis and with Excel application and recommendations linked to the analysis. Thoroughly developed and creative analysis and synthesis with application. Well developed recommendations linked to the analysis undertaken. Highly sophisticated and creative analysis. Excellent recommendations linked to the analysis undertaken.
Timely Delivery– primewritersbay.com believes in beating the deadlines that our customers have imposed because we understand how important it is.
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Communicate with IT professionals, stakeholders and user groups of information systems
ASSESSMENT BRIEF Subject Code and Name ACCT6001 Accounting Information Systems Assessment Assessment 3 – Case Study – Excel Individual/Group Individual Learning Outcomes (d) Apply technical knowledge and skills in creating information for the workplace using spreadsheets and relational databases (e) Communicate with IT professionals, stakeholders and user groups of information systems Weighting 25% Total Marks 100 marks Context: The spreadsheet is a powerful tool that has become entrenched in business processes worldwide. A working knowledge of Excel is a crucial skill for accountants. This assignment aims to assess the student’s ability to create spreadsheets. Students will be using raw data and summarising them in a user-friendly format to aid decision making. Students will need to recommend additional excel-based analysis that facilitates business decision making. Submission Instructions: Students need to submit their Excel Workbook which includes the analysis and recommendation sheet. The file should be provided in the following format: Student ID_ Student Name_ ACCT6001 Assessment 3.xlxs Example: 0009989t_Adam Smith_ACCT6001 Assessment 3.xlxs Eljay School A large Australian School has recently opened an online education division called Eljay. The school provides online education services to students from around the world. In an effort to improve the services offered to students, a job management system was developed to improve the responses provided to student queries. At the end of every week, a manager from the administration team archives an excel file that contains data about student queries for that week. The manager of the administration team believes that the data within this spreadsheet would be valuable for business decision making. However, employees within the team lack the technical knowledge to analyse and interpret this data. Subsequently, the manager is unsure how to utilise this data to gain insights on how to improve response times and outcomes for students. The administration team manager decided to hire you to assist in analysing and interpreting the data. The table below shows a data file that was archived containing information on student queries for one week. Table 1 Job Code Student ID Student Name Date Opened (d/mm/yyyy h:mm) Date Closed (d/mm/yyyy h:mm) Hours Charged Job Type Job Priority Job Status 0001 0009990t Charles Brody 01/08/2020 10:30:49 01/08/2020 12:30:49 2 IT Important Closed 0002 0001090t John Lucas 02/08/2020 15:23:26 02/08/2020 16:23:26 1 IT Normal Closed 0003 0009989t Adam Smith 02/08/2020 18:21:46 04/08/2020 16:20:23 1 Teaching Less Important Closed 0004 0001100t Maree Sarah 03/08/2020 09:36:21 05/08/2020 12:20:23 4 Teaching Normal Closed 0005 0009988t Eve Bonny 04/08/2020 12:24:20 6 Assessment Important Re Process 0006 0001120t Adelle Smith 04/08/2020 09:28:26 1 Assessment Less Important Open 0007 0009987t Jill Water 05/08/2020 11:30:33 3 Assessment Important In Process 0008 0001130t Jack Hill 06/08/2020 12:10:33 06/08/2020 14:30:33 2 Assessment Important Closed While only a small number of queries were received from students in the first week of the month, student queries are expected to go up over the remainder of the month. However, before getting actual data from the job management system in the coming weeks, Eljay school has asked you to explore the possible analyses that can be performed if using the current output. Eljay provided you with a document listing specific instructions on what you are expected to do in Excel. The instructions are listed below. Requirements (1) Open an Excel Workbook and name it as ‘Student ID_ Student Name_ ACCT6001 Assessment 3’ (i.e. 0009989t_Adam Smith_ACCT6001 Assessment 3). Create a worksheet labelled as ‘Job Data’. Make a table similar to the one above using hypothetical details for 50 students. The table should include the following columns: Job Code, Student ID, Student Name, Date Opened, Date Closed, Job Type, Job Priority, Job Status. In your hypothetical data, assume: a) all student queries were made by students located in Australia, b) at least 30 jobs that have a job status of “closed” c) at least one of each Job Status is included in the data set for each Job Type. For example, include at least: • “open”, “in process”, “re process”, and “closed” entries for “IT”, • “open”, “in process”, “re process”, and “closed” entries for “Teaching”, and • “open”, “in process”, “re process”, and “closed” entries for “Assessment” d) All queries are made between 01/08/2020 and 28/08/2020. e) Each student lodges a query in the job management system only once. So, each row of data contains information about a specific student. (2) In the ‘Job Data’ worksheet, add a column labelled as ‘Time taken to close job. This column should show the time spent resolving each job (e.g. student query). The values for this column should be reported using the “number” format and calculated using a: a) combination of the date opened and date closed columns. b) formula that only includes entries with a “Job Type” equal to “Closed”. (3) Create a new worksheet in your workbook and label it as ‘Job Duration’. In this worksheet: a) Report the descriptive statistics (i.e. mean, median, maximum, minimum) for both the “Time taken to close job” column added to the ‘Job Data’ worksheet and the “Hours Charged” column. A brief commentary on the results should be provided (between 50 and 100 words). b) Include another table in this worksheet showing for each week the: • Total number of jobs, • Total number of jobs “Closed”, • Total number of “Important” jobs “Open”, and • Average time taken to close “Important” jobs. The values for each week should be calculated using Excel formulas based on values from the ‘Job Data’ worksheet (e.g. the values in your table should change if values in the ‘Job data’ table change). The table may look like Table 2. Table 2 Week 1 Week 2 Week 3 Week 4 Job Count 8 13 9 15 Jobs Closed 5 6 7 12 “Important” Jobs “Open” 1 1 2 3 Average time taken to close “Important” jobs 1.5 1.8 2.6 3.9 The administration team believe that the problem with Key Performance Indicators focused on the number of jobs closed each week was that “important” jobs were not being prioritised. Do you find support for this belief? Use a chart(s) to report the results for correlation to support your answer. (4) Create a worksheet labelled as ‘Job Type’. Include a table in this worksheet showing the number of jobs for each week grouped by the three different job types. The values should be directly linked to the ‘Job Data’ worksheet. The table may look like Table 3. Table 3 Job Type Week 1 Week 2 Week 3 Week 4 Total Assessment 4 6 4 7 21 IT 2 3 2 3 10 Teaching 2 4 3 5 14 Total 8 13 9 15 45 (5) Create a worksheet and label it as ‘Pivot Tables and Charts’. Build tables and charts that show the average Job Duration by Job Type and Job Priority. Provide these by creating 2 pivot tables/charts (one for each Job Type and Job Priority). Place both of these tables and charts on the same worksheet. A sample for output of Job Duration by Job Type is shown in Figure 1. For each table/chart, comment on whether you think the school would be able to introduce a policy of no more than 2 working days (48 hours) to resolve students queries. Figure 1 (6) Of the employees directly responsible for resolving student queries, the school currently has 3 contract-employees working in the administration team, 2 in the teaching team, and 1 in the corporate services team. Contract employees from the administration team charge the school $60 per hour, teaching team employees charge $80 per hour and corporate services $110 per hour. The administration team manager, who receives a salary of $70,000 per annum, asked you about using data from the job management system to develop a monthly budget. The following information was gathered for you to use in developing this budget.
“Hours charged” for “Assessment” jobs are invoiced by the administration team 60% of the time and the remaining 40% of the “Hours charged” are invoiced by the teaching team.
All “Hours charged” for “IT” jobs are invoiced by corporate services team
The “Hours charged” to “Teaching” jobs are invoiced by the teaching team 90% of the time while the remaining 10% are invoiced by the administration team. Create a ‘Budget Summary Report’ worksheet. Include a table with a column for the Team, Estimated hours, and Total Costs. The values for the estimated hours charged column should be linked to the ‘Job Data’ worksheet. Use appropriate functions to fill out the remaining cells of the table. A sample table is shown in Table 5. Table 5 Team Estimated hours Cost (per hour) Total costs Administration 33 60 71,890.00 Corporate Services 48 110 5,280.00 Teaching 51 80 4,080.00 Generate a pie chart to show the distribution of expected costs across different teams. (7) Due to the recent economic crisis around the world, the school would like to cut costs and automate several processes. Given strong industry demand for using Artificial Intelligence (AI) tools to manage customer queries, you believe that a large number of student queries could be managed using an AI bot. However, to implement this technology at the school, a part-time employee will need to be employed along with a software-as-a-service (SAAS) subscription. The part-time employee will cost $35,000 per year. However, you expect that the budgeted costs (in requirement 6) will be significantly reduced. If the school purchases the AI bot, it will half the amount of time required by the administration manager to manage student queries, reducing this cost to $35,000 per year. The percentage of “Hours charged” will also decrease for all job types and only a small charge per “Closed” job will be incurred for the SAAS subscription (as shown in Table 6). Table 6 Team Reduction in “Hours charged” (%) Charge per “Closed” job Assessment 60% $1.20 IT 30% $2.20 Teaching 20% $1.60 If the School does not implement the AI bot tool, the number of jobs performed by employees will remain unchanged. Do you recommend the School purchases the AI bot? (8) Create a worksheet labelled as ‘Analysis and Recommendation’. This worksheet should contain the following three sections. a) Findings – Briefly summarise your findings based on the analysis performed in requirement 2 to requirement 7. b) Recommendation for additional analysis – In this section, you should comment on whether additional analyses can be performed using the types of data that the administration team manager currently receives from the job management system. You should provide one example of an additional analyses that can be performed using the given data and explain how to perform the analysis. Comment on how the additional analysis would help the administration team manager to make business decisions. c) Recommendation for additional data – Currently there is an option for the administration manager to get other types of data from the job management system. Provide one practical example of an additional type of data that should be collected about student queries (e.g. jobs). Suggest the type of analysis that can be done using the additional data. Comment on how the analysis on additional data would help the administration department improve business decision making. Learning Rubric: Assessment 1 Assessment Criteria Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% Formulae, formatting and cell references 20 % Formulae, formatting and cell reference are mostly incorrect and incomplete. Incorrect calculations and major mistakes in formulas are present. More than 50% of the formulae, formatting and cell references are correct. Several mistakes are present in calculations and formulas that have been used. Majority of the formulae, formatting and cell references are correct. There are minor discrepancies or mistakes in calculations and formulas used. Almost all formulae, formatting and cell references are correct. All calculations are correct and appropriate formulas have been used. All formulae, formatting and cell references are correct. All calculations are correct and appropriate formulas have been used. Tables, graphical presentation of data, Pivot Table 40 % Some tables, graphs, pivot tables are missing or created with wrong or incomplete data. Poor visual presentation of data. Some mistakes are present in creating tables, graphs and pivot tables. Some mistakes have been done in data used, but overall student has proven working knowledge of the Excel tools used. Visual presentation of data needs improvement in some cases. Tables, graphs and pivot tables have been created with minor mistakes. Visual presentation could be improved. There are minor mistakes in table creation, graphs and pivot table. Overall very good understanding of the Excel tools with professional presentation of data. Tables, graphs and pivot table have been created correctly with excellent presentation of data. The student has shown excellent understanding of the Excel tools used in the assessment. ACCT6001_Assessment Brief 3_Case Study – Excel Page 6 of 7 Analysis and Recommendation 40% Recommendations and analysis are not provided or very weak. Limited application/ recommendations based upon analysis. The student demonstrated the ability to analyse and summarise data for the purpose of decision making. Recommendations are valid, but could be improved. Well-developed analysis and with Excel application and recommendations linked to the analysis. Thoroughly developed and creative analysis and synthesis with application. Well developed recommendations linked to the analysis undertaken. Highly sophisticated and creative analysis. Excellent recommendations linked to the analysis undertaken. ACCT6001_Assessment Brief 3_Case Study – Excel Page 7 of 7
Customer satisfaction- Customer satisfaction. We have an outstanding customer care team that is always ready and willing to listen to you, collect your instructions and make sure that your custom writing needs are satisfied
Writing services provided by experts- Looking for expert essay writers, thesis and dissertation writers, personal statement writers, or writers to provide any other kind of custom writing service?
Enjoy Please Note-You have come to the most reliable academic writing site that will sort all assignments that that you could be having. We write essays, research papers, term papers, research proposals. Communicate with IT professionals, stakeholders and user groups of information systems
