Post a total of 3 substantive responses over 2 separate days for full participation. This includes your initial post and 2 replies to classmates or your faculty member.
Due Thursday
Respond to the following in a minimum of 175 words:
Discuss the differences between the systems development life cycle (SDLC) and the security life cycle.
Include in your discussion both management and non-management IT security positions that perform security life cycle steps and briefly describe their role.
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. Discuss the differences between the systems development life cycle (SDLC) and the security life cycle
Scheduling and Staffing Competency Collaborate in healthcare delivery systems settings for improved patient outcomes. Scenario You are making a staffing assignment knowing that you are short-staffed. You have five registered nurses (RNs), two licensed practical nurses (LPNs), and two nursing assistants. Those nine employees need to provide a 12-hour shift of services to 30 clients with a high acuity required to a ratio of nurse to client at 1:3. Client acuity level
Six acuity level 1
Eight acuity level 2
Nine acuity level 3
Seven acuity level 4
You will use the acuity-based staffing model to develop the staffing assignment based on the needs of the clients. You will use the created template.
NUR2832_Staffing
Instructions As you create this assignment, include the following in an email to your manager to justify your short-staffing plan:
Complete the staffing assignment based on the acuity level.
Defend how you would direct the staff to their assigned roles for this shift and provide a rationale for the staffing assignment.
Describe how you would communicate with each level of care provider to assure the best outcomes possible.
Address how you would ensure client equity in the delivery of services.
Provide stated ideas with professional language and attribution for credible sources with correct APA citation, spelling, and grammar.
Resources For assistance completing this assignment, review the article titled Patient Acuity Model. Submit your completed assignment by following the directions linked below. Please check the
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. An Introduction to Organisation Development
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. prospective payment systems for outpatient, home health, physician and non-physician practitioners, and ambulatory surgical settings
Differentiate between the prospective payment systems for outpatient, home health, physician and non-physician practitioners, and ambulatory surgical settings. In your response ensure that you compare and contrast payment systems for each of the categories listed.
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. physician and non-physician practitioners, and ambulatory surgical settings
1. There are 12 general categories of threat to an organization’s people, information, and systems. Explain at least six of the general categories of threat, and provide an example of each of the six chosen categories.Your response must be a minimum of 100 words in length.
2. Outline the different types of data ownership and their respective responsibilities. Which is more important to know? Explain.Your response must be a minimum of 100 words in length
3. Briefly describe the Structured Query Language (SQL) injection attack on a relational database. Why is it important to recognize the injection? Explain.Your response must be a minimum of 100 words in length.
4. Briefly describe the Structured Query Language (SQL) injection attack on a relational database. Why is it important to recognize the injection? Explain.Your response must be a minimum of 100 words in length
5. Computer systems are subjected to many different threats and attacks. Which do you believe will cause more damage: threats or attacks? Why?
Your response must be 250 words in length or more.
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. Threat to an organization’s people, information, and systems
What does busy waiting mean and why is this not required in Operating Systems? Explain a solution that uses busy waiting.What does busy waiting mean and why is this not required in Operating Systems? Explain a solution that uses busy waiting.What does busy waiting mean and why is this not required in Operating Systems? Explain a solution that uses busy waiting.What does busy waiting mean and why is
Imagine this scenario: As a requirement of the Smallville contract, Gail Industries must conduct an IS review, specifically for a transaction processing system (TPS) to determine whether the systems meet and continue to meet the organization’s objectives.
Review the Gail Industries Case Study for information that will assist you with this assignment.
Prepare a 4- to 5-page IS review in which you provide:
-An evaluation of current systems operations and maintenance practices
-A determination of whether the level of service from internal and external service providers is defined and managed
-Recommendations for improvements
Cite references to support your assignment.
Format your citations according to APA guidelines.
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. What does busy waiting mean and why is this not required in Operating Systems?
Compose a 250 words assignment on database systems management. Needs to be plagiarism free!
There will be new clients who will want to book the hotels in the future (Connolly, & Begg, 2005).The most common data types that are common in the database are the date because there are various date values that will need to be added to the database. There will also be string values. This will be with values like the address of the client, the names, and the destination or career. Another common data types that will be stored in the database is the integer which will be used to store currency values.
There will be a need to store the fees that will be paid by the clients (Prescott, & McFadden, 2007). There will be various reports that will be run on the database. These reports include the number of clients in the hotel I one month or the number of passengers who travelled to a particular country. There could be also a report on the number of patients who were discharged in a certain period (Rud, 2009). There will be integrity constraints. This is because there will be various forms of currencies which will be entered.
The values could be in one currency like the USD to avoid mix up of values. Sometimes the dollars that have been added could not be the actual currency. Some clients could have money in other currencies which are not supported by the system. The database helps the organization gain a competitive advantage as data mining will help understand the trends of the clients. They will act according to their reports. They will understand what the clients want and what is frequented by these clients.
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. database systems management
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
Subject Code and Name CMP1042 Information Systems Assessment Number 1 Assessment Title Visual Presentation Assessment Type Individual Presentation Length or Duration 500 words +/- 10% Subject Learning Outcomes SLO 1 Weighting 20% Assessment Purpose In any organisation, information systems with specific purposes are available to employees at various levels of seniority and responsibility. For example, senior managers might use an Executive Support System (ESS) to formulate strategy and monitor progress towards its implementation. This assessment asks the student to populate a hierarchy of information systems and to describe these individual systems and their relationships to each other. Students are also asked to describe how the functioning of these systems might be improved by the implementation of an Enterprise Resource Planning (ERP) system. Assessment Task / Item Submit a set of six (6 ) presentation slides and associated slide notes, that describe a set of four (4) information systems and their inter-dependencies, as described in ’Instructions’ below. This is an individual assessment. CRICOS: 02155J / HE PROVIDER: Assessment Instructions Using presentation software, like Microsoft PowerPoint, Prezi or similar, you must create a visual presentation of six (6) slides that addresses each of the tasks below. Each slide should include images or diagrams explaining the information being discussed. The slide notes for the set of six (6) slides should total 500 words. Both the slide images and the slide notes are to be submitted as completion of this assessment.
On one (1) slide, create a hierarchy of information systems diagram based on ‘Figure 1’ below, using the following systems: a) MIS b) DSS c) TPS d) ESS In your diagram, specify which system goes in which section of the diagram, and explain why in your notes.
Using four (4) slides (one per system), describe the inputs, outputs and purpose of each of these systems, and their relationship to other systems in the hierarchy.
On one (1) slide, create summarise the possible benefits of replacing some/all/any of these systems with an Enterprise Resource Planning (ERP) system. Submission All work must be submitted by the due date via the Learning Management System, in the assignments section appropriate to this brief. Please ensure the above mentioned submission date and/or time are adhered to, or penalties may apply. When submitting your work, please save your files using the naming convention below. [Student_ID][Surname][First Name][SubjectCode][Assessment_#] E.g.: 1234_Singh_Visha_PRG1002_Assessment_01 For more information on late submission, please see the Assessment Policy. Academic Integrity The integrity of the assessment process is fundamental for ensuring appropriate evaluation at AIT. All work submitted should be your own, and where additional resources are used, they must be referenced according to the Harvard style. Additionally, TurnItIn is available in the LMS to test plagiarism in your writing. For more information on academic integrity, please see the Academic Integrity and Academic Integrity Penalties Policies. CRICOS: 02155J / HE PROVIDER:
Appeals Fair application of the assessment rubric, rules and guidelines should be administered for each assessment. If you feel an evaluation requires further consideration, you may be entitled to an appeal. For more information on your right to an appeal, please see the Assessment Appeals Procedure and Policy. Policies For access to the policies mentioned above and related to education at AIT, please see the footer of the AIT website, and follow the link named Education Policies and Procedures. Website: https://www.ait.edu.au CRICOS: 02155J / HE PROVIDER: Assessment Rubric Task Descriptor (F) Fail (P) Pass (C) Credit (D) Distinction (HD) High Distinction Describe the inputs, outputs and purpose of each information system (ESS, MIS, DSS, TPS) 35% Description of inputs, outputs and purpose of each system missing or incorrect; Fewer than 2 correct examples provided for both inputs and outputs; No examples provided for each system; Figure 1 incorrectly populated Description of inputs, outputs and purpose of each system provided, with some significant errors; 2 correct examples provided for both inputs and outputs, but without clear imagery; Examples provided for each system, though not all are correct; Figure 1 correctly populated Purpose and description of inputs, outputs and each system provided, with some minor errors; 2 correct examples provided for both inputs and outputs, supported by clear imagery and labels; Correct examples provided for each system; Figure 1 correctly populated Clear description provided of inputs, outputs and purpose of each system, with few errors’ 3 correct examples provided for both inputs and outputs, supported by clear imagery and labels’ 2 correct examples provided for each system; Figure 1 correctly populated Complete, concise and accurate description provided of inputs, outputs and purpose of each system, with no errors; 4 correct examples provided for both inputs and outputs, supported by clear imagery and labels; 2 correct examples provided for each system, supported by clear imagery and labels; Figure 1 correctly populated Describe the relationships between the four systems (ESS, MIS, DSS, TPS) 25% Description of the relationships between the systems and the data exchanged and/or shared missing or incorrect Description of the relationships between the systems included; Information about the data exchanged and/or shared unclear or not completely accurate Clear description of the relationships between the systems included, and supported by evidence; Information about the data exchanged and/or shared provided and supported by examples, but with minor errors Near complete description of the relationships between the systems included, and supported by relevant evidence and simple imagery; Information about the data exchanged and/or shared provided and supported by relevant academic resources, examples and with minimal errors Complete, succinct and accurate description of the relationships between the systems included, and supported by relevant evidence and clear, engaging imagery and labels; Information about the data exchanged and/or shared provided and supported by relevant academic resources, and accurate examples without error Summarise the possible benefits of replacing some/all/any of the four systems (ESS, MIS, DSS, TPS) with an Enterprise Resource Planning (ERP) system. Description of an ERP system not included Organisational benefits of replacing some/all/any of the Description of and ERP system unclear Organisational benefits of replacing some/all/any of the four systems with Basic description provided of an ERP system, with some inaccuracy; Organisational benefits of replacing some of Clear description and example of an ERP system provided; Organisational benefits of replacing all four Accurate, concise description of an ERP system provided, supported by a relevant example and explanation of CRICOS: 02155J / HE PROVIDER:
20% four systems with an ERP not included an ERP system included, but unclear or insufficiently explained the four systems with an ERP system clearly discussed systems with an ERP system clearly discussed and supported by examples why example been selected; Organisational benefits of replacing all four systems with an ERP system clearly discussed and supported examples and relevant academic evidence Quality of information presented 10% Information is unclear, inconsistent or inaccurate; Document missing a lot of key information Information, arguments and evidence are presented in a way that is not always clear and logical, with minimum information provided; Some inconsistency or ambiguity in the writing Information, arguments and evidence are reasonably well presented, with some information a little ambiguous, but all key elements and pages included Information, arguments and evidence are very well presented, logical, clear and well supported by evidence Almost all information is written clearly and concisely All information is written very clearly and concisely, and is logical, persuasive, and well supported by evidence, demonstrating a clear flow of ideas and argument; Engages and sustains audience’s interest in the topic, and uses diverse, relevant imagery Correct citation of key resources and evidence 10%. Demonstrates inconsistent use of good quality, credible and relevant resources to support and develop ideas Demonstrates use of some resources to support and develop ideas, but these are not relevant, current or cited correctly Demonstrates use of resources to support and develop ideas, with a few errors in the citations Demonstrates use of credible, current and relevant resources to support and develop arguments and statements, with most citations correct Demonstrates use of high-quality, credible current and relevant resources to support and develop arguments and position statements with no errors in the citation
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. information systems with specific purposes are available to employees at various levels of seniority and responsibility. For example, senior managers might use an Executive Support System (ESS) to formulate strategy