Categories
Writers Solution

Deal with complex professional issues systematically and creatively

Drawing upon current academic research, consider barriers to inclusion and critically analyse strategies for inclusion within English classrooms. You can focus on a specific diagnosis, or an area of need from the SEND Code of Practice (DfE and DoH, 2015).’

2500 words

Learning Outcomes

1.    Deal with complex professional issues systematically and creatively

2.    Use research to inform the development of practice

3.    Critically evaluate current research in the area of inclusion

4.    Demonstrate originality in the interpretation and application of knowledge and research in the area of inclusion

Suggested Structure

Introduction

·      State the aims of the essay and the main areas of discussion. Say which general issues you will be discussing and which area of need or diagnosis you are focusing on and introduce key issues in this area.

Explore some of the general issues around inclusive teaching in England

·      Outline one or two key issues with creating an inclusive environment which may impact on inclusive teaching, for example curriculum, assessment, use of teaching assistants etc. These should be generally about creating an inclusive environment (not specifically linked to your chosen area of need yet)

·      You need to critically reflect on how the theory impacts on practice – this means exploring some of the complexities of inclusive education, and outlining the mismatch that sometimes occurs between theory and practice

Discuss barriers to and strategies for inclusion.

·      Outline possible barriers to inclusion for the specific area of need or diagnosis you are discussing. What are specific issues that children/young people with this diagnosis/area of need can face in accessing the classroom/curriculum? Remember to link to literature and use tentative language. Avoid generalisations.

·      You need to link this to your previous section about general issues for inclusion in the classroom. Can you see any complexities?

·      You can focus on a specific age group if you like- early childhood, primary age, secondary age, further or higher education. You do not need to do this but you may need to narrow your discussion down if you have chosen a broad area of need.

·      You then need to discuss the strategies that could be used to create an inclusive environment with children with your chosen diagnosis/area of need in mind. You may want to consider some of the below.

–       Lesson objectives and aims

–       Use of staff

–       Grouping / room layout

–       Resources used

–       Activities

–       Assessment

–       Homework

–       Specific (named) support strategies / interventions (e.g. SCERTS, SPELL, Read Write Inc)

·      You will not be able to cover all aspects in sufficient detail, so if you do choose any of these then choose which ones you want to explore that relate closely to your area of need.

·      Remember that whichever strategies you discuss, you need to do this critically- this can mean considering strengths and potential benefits of the strategy, any weaknesses or complications, and the implications for pupils, teachers, or support staff. This is essential for achieving a passing grade.

·      Ensure your essay links the general issues, the specific barriers children with your chosen area of need or diagnosis may face, and then the strategies that could be used to support them in the classroom- these sections should lead on logically from each other.

Conclusion

·      You need to draw together all the threads of your assignment, making sure you do not bring in any new ideas. Summarise the key points of the essay.

Order from Academic Writers Bay
Categories
Writers Solution

a difficult decision and be complex enough to build a case and generate a lively discussion

Your paper should include: 

• Minimum 1 page

Topic: Your topic should represent a unique situation or a difficult decision and be complex enough to build a case and generate a lively discussion.

Briefly discuss an area of diversity covered in this course.

Points of Law: Identify key diversity legislation pertaining to this topic.

Best Practices: Briefly describe an example that demonstrates managing diversity in this area.

What questions do you have about this topic?

Write two (2) questions you would like to have answered in a discussion forum.

Provide two (2) references to support your research.

For more information on APA formatting, visit www. https://owl.purdue.edu/owl/research_and_citation/apa_style/apa_formatting_and_style_guide/general_format.html

GET THE COMPLETED ASSIGNMENT

ASSIGNMENT COMPLETED AT CapitalEssayWriting.com

MAKE YOUR ORDER AND GET THE COMPLETED ORDER

CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com on a difficult decision and be complex enough to build a case and generate a lively discussion

NO PLAGIARISM, Get impressive Grades in Your Academic Work

Categories
Writers Solution

Each young person has a complex history before entering care that manifests in different ways

SCENARIO: Each young person has a complex history before entering care that manifests in different ways. Below is a scenario regarding a Young Person aged 13 who has been in residential care for 2 weeks.

Georgia was in the primary care of her mother who had substance abuse issues and a string of violent boyfriends. Georgia was exposed to high levels of aggression and violence towards her mother and occasionally herself. Georgia and her siblings moved from one place to another with their mother, often couch surfing at the homes of her mother’s drug associates.

Georgia is quick to become angry and struggles to control her emotions or self-regulate once heightened. She is guarded with any affection, often threatens her carers and is hyper vigilant. Georgia has a history of self-harm, often leaves the placement for long periods of time requiring her frequent absences to be reported to SAPOL. When Georgia is escalated, she is known to damage her carer’s property, vehicles as well as the walls and furniture within the placement. Georgia is not able to have contact with her mother and siblings due to her dysregulation.

GET THE COMPLETED ASSIGNMENT

ASSIGNMENT COMPLETED AT CapitalEssayWriting.com

MAKE YOUR ORDER AND GET THE COMPLETED ORDER

CLICK HERE TO ORDER THIS PAPER AT CapitalEssayWriting.com on Each young person has a complex history before entering care that manifests in different ways

NO PLAGIARISM, Get impressive Grades in Your Academic Work

Categories
Writers Solution

Bahrain Duty free shop complex B.S.C.

Company choosed: Bahrain Duty free shop complex B.S.C.
Assignment report parts with explanation of each part content:
Part 1: Background of the company
(1 page) overview of the company: stating what is the company all about, when was it established, what is the core ability of the company, what are the key achievements and milestones for the past 10 years that makes this company unique from other organizations, the nature of the company, what is the nature of its operation, what it’s specialized in. also focus on key achievements and milestones of the organization.
Part 2: Board of directors and key management officials
(1 page): discuss who are the board of directors and chairman of the board of the company, who are the key officers, and also try to identify the members of the board, try to find on a research who are those individuals and brief experiences and stuff like that, also highlight who is their CEO (chief executive officer), key officials such as chief financial officer and operations manager or head of operations, and for human resource any major official that you can look in to in the company that you feel the core stones of the organization. Also provide an analysis of their BOD and management composition.
Part 3: Industry analysis
(2 pages): conduct industry analysis of where the company is part of. Use PEST analysis for example, depending on your convenience you can choose any framework so that you can analyse the nature of the industry (what are it’s potentials, what are the challenges, what are the threats). In the industry where the company belongs who are the major players? so try to provide a very good overview of the industry (where the company currently analysing).
Part 4: Analysis of the financial performance of the firm
(7 pages): conduct financial analysis of the company using vertical analysis ratio.
Focus on the key strengths? you can use a vertical analysis of course you use ratio analysis to the sect relevant financial information about the firm or the organization and after that to focus on the key strengths of organization what will be possible areas for improvements of their weaknesses. Put graphs also in case there’s a need to put, put also the financial statements or condense version of the financial statements.
So how to do financial analysis using financial ratio? Get the 2 year financial statement from for example income statement of Bahrain duty free company and do vertical analysis, if it’s financial statement look at the percentage at each of the values to net income (for example see the composition of net sales relative to net income, so you have the base of net sales and the rest will be the percentage of net sales for example net sales will be 100% in 2009 then you derive operating cost excluding depreciation and amortization…etc and mention the implications also.
If you make vertical analysis for balance sheet, your base should be total assets for the assets, and total liabilities and equity for liability and equity so divide each value with total value and you will see the changes in the compositions of your assets relative to the overall total assets. So try to extract relevant information and try to draw conclusions from your analysis using vertical analysis.
The other thing you should use to complement the vertical analysis is to do the ratio analysis. Financial ratio allows you to analyse the company in terms of it’s financial performance? there are different types of financial ratio such as liquidity ratio, activity ratio, debt ratio, profit ratio. The ratios are group according to what you can draw conclusions once you drive the values from them. Also use Dupoint system of analysis in the financial statement of the company.
To get the financial statements of the company from Bahrain bourse:
go to Bahrain bourse website ( www.bahrainbourse.com/dailysummary ). In the list you will see Bahrain duty free shop complex B.S.C. and click on it and you’ll see all their financial statements, corporate actions and overview also. Also you can go to Bahrain duty free complex website itself from google and you will have all the information of the company in the website available.
Part 5: Analysis of company value
(3 pages): Once you are done with your financial analysis in the previous section, now you can use the evaluation tool in order to assess the company’s fair value, you can use different models (you can use free cash flow evaluation model, you can use also the dividend discount model or you can use the two stage discount model or the PE models) whatever you think is necessary and whatever you think is the most appropriate use it as a way to value the company and compare them with the current market price so with base and current market price share? is the company over valued or ir is it undervalued? You have to provide an analysis on why such difference in the price and the fair value that you have computed, there’s always a mismatch and it will not always be the same and if you think your computation for fair value is correct will the price go down undervalue? If it’s overvalued will the price go up? And try to see what could be possible things that could happen if the future that will lead to price adjustment (for example if you find a company that is undervalued and you say that the fair market value is the same for example price is 15, it’s current price is 10 I believe it will go up, so try to provide reasons why you think the price of 15 has not been materialized? for example, you would say that based on their research they have ongoing project,
they have an ongoing construction; they have ongoing partnership and it’s not yet materialized so once it’s materialized the market will adjust it’s evaluation and it will go up from 10 to 15. So provide necessary explanations of why the fair market value is not the same with the market price. You can do them by looking on the information in Bahrain bourse of the duty free company projects.
Part6: Conclusion and overall observation
(2 pages): identify possible growth potentials of the company that you’re assessing (you can provide recommendations that you think the company has to do to improve also you can use your evaluation section and you can use the financial analysis section to comment in this area.
Make sure that your recommendations have base, you can’t just provide recommendations that are not packed up by the findings of the previous sections so try to be evidence-based in terms of your recommendations do not just get recommendations from the internet and putting it.

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • 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 Deliveryprimewritersbay.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
  • Confidential- It’s secure to place an order at primewritersbay.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 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. Bahrain Duty free shop complex B.S.C.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Bahrain Duty free shop complex B.S.C.

Company choosed: Bahrain Duty free shop complex B.S.C.
Assignment report parts with explanation of each part content:
Part 1: Background of the company
(1 page) overview of the company: stating what is the company all about, when was it established, what is the core ability of the company, what are the key achievements and milestones for the past 10 years that makes this company unique from other organizations, the nature of the company, what is the nature of its operation, what it’s specialized in. also focus on key achievements and milestones of the organization.
Part 2: Board of directors and key management officials
(1 page): discuss who are the board of directors and chairman of the board of the company, who are the key officers, and also try to identify the members of the board, try to find on a research who are those individuals and brief experiences and stuff like that, also highlight who is their CEO (chief executive officer), key officials such as chief financial officer and operations manager or head of operations, and for human resource any major official that you can look in to in the company that you feel the core stones of the organization. Also provide an analysis of their BOD and management composition.
Part 3: Industry analysis
(2 pages): conduct industry analysis of where the company is part of. Use PEST analysis for example, depending on your convenience you can choose any framework so that you can analyse the nature of the industry (what are it’s potentials, what are the challenges, what are the threats). In the industry where the company belongs who are the major players? so try to provide a very good overview of the industry (where the company currently analysing).
Part 4: Analysis of the financial performance of the firm
(7 pages): conduct financial analysis of the company using vertical analysis ratio.
Focus on the key strengths? you can use a vertical analysis of course you use ratio analysis to the sect relevant financial information about the firm or the organization and after that to focus on the key strengths of organization what will be possible areas for improvements of their weaknesses. Put graphs also in case there’s a need to put, put also the financial statements or condense version of the financial statements.
So how to do financial analysis using financial ratio? Get the 2 year financial statement from for example income statement of Bahrain duty free company and do vertical analysis, if it’s financial statement look at the percentage at each of the values to net income (for example see the composition of net sales relative to net income, so you have the base of net sales and the rest will be the percentage of net sales for example net sales will be 100% in 2009 then you derive operating cost excluding depreciation and amortization…etc and mention the implications also.
If you make vertical analysis for balance sheet, your base should be total assets for the assets, and total liabilities and equity for liability and equity so divide each value with total value and you will see the changes in the compositions of your assets relative to the overall total assets. So try to extract relevant information and try to draw conclusions from your analysis using vertical analysis.
The other thing you should use to complement the vertical analysis is to do the ratio analysis. Financial ratio allows you to analyse the company in terms of it’s financial performance? there are different types of financial ratio such as liquidity ratio, activity ratio, debt ratio, profit ratio. The ratios are group according to what you can draw conclusions once you drive the values from them. Also use Dupoint system of analysis in the financial statement of the company.
To get the financial statements of the company from Bahrain bourse:
go to Bahrain bourse website ( www.bahrainbourse.com/dailysummary ). In the list you will see Bahrain duty free shop complex B.S.C. and click on it and you’ll see all their financial statements, corporate actions and overview also. Also you can go to Bahrain duty free complex website itself from google and you will have all the information of the company in the website available.
Part 5: Analysis of company value
(3 pages): Once you are done with your financial analysis in the previous section, now you can use the evaluation tool in order to assess the company’s fair value, you can use different models (you can use free cash flow evaluation model, you can use also the dividend discount model or you can use the two stage discount model or the PE models) whatever you think is necessary and whatever you think is the most appropriate use it as a way to value the company and compare them with the current market price so with base and current market price share? is the company over valued or ir is it undervalued? You have to provide an analysis on why such difference in the price and the fair value that you have computed, there’s always a mismatch and it will not always be the same and if you think your computation for fair value is correct will the price go down undervalue? If it’s overvalued will the price go up? And try to see what could be possible things that could happen if the future that will lead to price adjustment (for example if you find a company that is undervalued and you say that the fair market value is the same for example price is 15, it’s current price is 10 I believe it will go up, so try to provide reasons why you think the price of 15 has not been materialized? for example, you would say that based on their research they have ongoing project,
they have an ongoing construction; they have ongoing partnership and it’s not yet materialized so once it’s materialized the market will adjust it’s evaluation and it will go up from 10 to 15. So provide necessary explanations of why the fair market value is not the same with the market price. You can do them by looking on the information in Bahrain bourse of the duty free company projects.
Part6: Conclusion and overall observation
(2 pages): identify possible growth potentials of the company that you’re assessing (you can provide recommendations that you think the company has to do to improve also you can use your evaluation section and you can use the financial analysis section to comment in this area.
Make sure that your recommendations have base, you can’t just provide recommendations that are not packed up by the findings of the previous sections so try to be evidence-based in terms of your recommendations do not just get recommendations from the internet and putting it

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • 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 Deliveryprimewritersbay.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
  • Confidential- It’s secure to place an order at primewritersbay.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 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. Bahrain Duty free shop complex B.S.C.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Explore news/current events to locate a business that has a complex problem which needs to be addressed.

There needs to be a paper and a power point presentation. You may choose a different business but i have this for now _Huawei Technologies  is the organization. 

Major Case Analysis

The write-up is limited to 12-15 double-spaced pages, not including a title page and exhibits (include as appendices). 

SELECTING AN ORGANIZATION – Huawei Technologies 

Explore news/current events to locate a business that has a complex problem which needs to be addressed. The problem may be related to any business topic (i.e. accounting, marketing, legal, etc.).

It is suggested that you select a recent problem of a public company, which will ensure that you will have access to the information necessary to complete your project.

As you select an organizational problem for your class project, it is important that you select an organization that is interesting, possibly useful to you in your career, industry, or interests. An organization or industry you are interested in should give you better access to information.

USE THE 9-STEP CASE ANALYSIS PROCESS AS A GUIDE:

  1. Skim the case to get an overview of the situation.
  2. Read the case thoroughly to digest the facts.
  3. Carefully Review information in exhibits.
  4. Decide what the strategic issues are.
  5. Begin your analysis with some number crunching.
  6. Apply the concepts of strategic analysis.
  7. Check out conflicting opinions
  8. Support your opinions with reasons and evidence.
  9. Develop recommendations and an action plan.

Your analysis and recommendations should be supported with high-quality evidence, including textbooks and peer-reviewed academic journal articles covering the appropriate topics that apply to your specific problem from the following list:

  1. Accounting
  2. Business Communications
  3. Business Ethics
  4. Business Finance
  5. Business Integration and Strategic Management
  6. Business Leadership
  7. Economics
  8. Global Dimensions of Business
  9. Information Management Systems
  10. Legal Environment of Business
  11. Management
  12. Marketing
  13. Quantitative Research Techniques/Statistics

Major Case Analysis Presentation

The recommended length of the presentation is 8-10 slides with audio commentary included. The presentation must be appropriate to college-level work, demonstrate critical analysis of the case, and be free of spelling and grammar errors.

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • 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 Deliveryprimewritersbay.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
  • Confidential- It’s secure to place an order at primewritersbay.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 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. Explore news/current events to locate a business that has a complex problem which needs to be addressed.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

utilised your developing or advanced assessment skills in a complex situation

Assessment details
Assessment task 1 Practice scenario
Task Description This assessment provides opportunity to reflect on your practice with your fellow students through an online discussion group before submitting your work for grading. This assessment piece involves three (3) components. You are required to reflect on a situation where you utilised your developing or advanced assessment skills in a complex situation. 1. Using the clinical reasoning cycle write a 8oo-word extended answer/summary which reflects a patient scenario from your practice where your health assessment skills were used or required. In your discussion focus on your use of specific health assessment skills highlighting the importance of each to the assessment process. Use the relevant literature to support your discussion. 2. Post your work into the discussion space on MyLO within three (3) days of the online discussion opening. This allows sufficient time for all group members to read, reflect and respond constructively. 3. Engage with a minimum of two (2) other students who have different examples to your own and respond constructively to their practice example in the discussion space in MyLO. Responses should be no more than 200 words each (+/-10%) and should be referenced appropriately. There is no maximum limit to how many response posts you can make, and you are encouraged to contribute across the discussion group to which you are allocated. 4.Draw upon your readings to suggest areas for further consideration around the assessment practice of your fellow student(s) whose work you have selected. Ensure respectful and insightful comments are provided. The aim is to generate discussion around health assessment. 5. Following the completion of the online discussion period, submit to the MyLO Assignment folder your 800-word extended answer/summary of your practice scenario with two (2) of your best discussion responses to other students, attached as appendices.
Assessment Criteria Measures Intended Learning Outcome:
Criterion 1 20% Posts own practice scenario into the discussion space in MyLO within three days of the online discussion commencing. Participates in the online activity and responds to the practice scenario of at least two other students with analytical comments. 1,2
Criterion 2 40% In the practice scenario, uses the clinical reasoning cycle. Demonstrates applied knowledge and understanding of appropriate health assessment skills related to the specific context examined, and the importance of each to the assessment process. 1,2
Criterion 3 20% Demonstrates awareness of the applied health assessment of two students, making insightful suggestions to extend their knowledge and skills. 1,2
Criterion 4 20% Demonstrates critical engagement in current and relevant evidence-based research. Writes clearly and succinctly in an appropriate academic style using UTAS Harvard referencing. Submits within the word count.
Task length 1200 words (total +/-10%) Practice scenario 8oo-words Appendix – Two (2) 200 words responses

GET SOLUTION FOR THIS ASSIGNMENT, Get Impressive Scores in Your Class

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • 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 Deliveryprimewritersbay.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
  • Confidential- It’s secure to place an order at primewritersbay.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 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. utilised your developing or advanced assessment skills in a complex situation

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.

ASSESSMENT 2 BRIEF
Subject Code and Title MIS602 Data Modelling and Database Design
Assessment Database Implementation
Individual/Group Individual
Length N/A
Learning Outcomes The Subject Learning Outcomes demonstrated by successful completion of the task below include:
b) Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.
Submission Due by 11:55pm AEST/AEDT Sunday end of Module 4.2
Weighting 35%
Total Marks 100 Marks
Task Summary
In this assessment, you are required to demonstrate your ability to understand the requirements for various data information requests from an existing database and develop appropriate SQL statements to satisfy those requirements.
Context
Being able to query a database is a fundamental skill that is required by all information systems professionals who work with relational databases. In this assessment, you will utilize the basic query skills that are typically used to extract information for analysis, reporting and data cleansing in a data management setting. Timely provisioning of key business information promotes effective communication and enhanced solution delivery.
Task Instructions

  1. Please read the attached MIS602_Assessment 2_Data Implementation_ Case study.
  2. Examine the relational model and ER diagram and derive the SQL queries to return the required information.
  3. Provide SQL statements and the query output for the following:
  4. List all the customers who live in any part of CAULFIELD. List only the Customer ID, full name, date of birth and suburb (5 marks)
  5. List all of the active staff. Show their Staff ID, full name and weekly salary assuming that they work a 38 hour week (3 marks)
  6. Which plan has the most expensive contract to break? (5 marks)
  7. Which brands of mobile phone does this company sell? List only the unique brand names (3 marks)
  8. Which customer is not able to purchase a phone? Use a query to explain why. Hint: Review the customer data (3 marks)
  9. How many of each phone plan have been sold? (5 marks)
  10. What is the average age of an Apple phone user? (8 marks)
  11. What are the first and most recent mobile phone purchases? (3 marks)
  12. i. For calls made in 2018 how many calls were made on the weekend? (5 marks) ii. For calls made in 2018 how many calls were made on each day of the weekend? (3 marks)
    MIS602_Assessment _2_Brief_Database Implementation_Module 4.2 Page 1 of 3
  13. Provide a listing of the utilization of each tower and its location i.e. how busy each tower is based on the number of connections. Put the busiest tower at the top of the list (3 marks)
  14. Did any users on the ‘Large’ plan exceed their monthly allowance during August 2018? (8 marks)
  15. The company is upgrading all their 3G towers from to 5G.
    i. How many towers will be upgraded? (1 mark)
    ii. what SQL will be needed to update the database to reflect the upgrades? (2 marks)
  16. i. List the full name, join date, resigned date of each staff member and name, join date and resigned date of their manager (3 marks) ii. What do you observe with the data? (2 marks)
  17. How much revenue was generated in 2017 by each plan from call charges. Format the output as currency i.e. $123.45 (8 marks)
  18. List the customers who made phone calls longer than 200 minutes (5 marks)
  19. Which customers have more than one mobile phone? List the customer name, suburb and state. Order by the customer name (8 marks)
  20. Are there any mobile phone plans that are currently unused? This can be obtained a number of ways. Demonstrate this by using the following two query types
    i. Nested subquery (3 marks)
    ii. Outer join (3 marks)
  21. List the oldest and the youngest customers in the postcodes 3000 and 3102. Show the customer full name age and suburb details (3 marks)
  22. i. Create a view that shows the popularity of each phone colour (1 mark) ii. Use this view in a query to determine the least popular phone colour (2 marks)
  23. The billing team is getting returned mail because of bad customer addresses. This is causing a loss in revenue.
    i. Review the customer data and find at least 3 issues (3 marks)
    ii. Provide the SQL statements to correct the data problems (2 marks)
    Total 100 marks
  24. The database used for this assignment is available in ‘MIS602_Assessment 2_Database SQL Files’ folder. Please download the files from this folder.
  25. All statements and first 10 lines of output need to be neatly presented. Please save all your SQL statements and output into a single word document and submit it via the Assessment link in the main navigation menu.
    Referencing
    It is essential that you use appropriate APA style for citing and referencing research. Please see more information on referencing here http://library.laureate.net.au/research_skills/referencing
    Submission Instructions
    Submit Assessment 2 via the Assessment link in the main navigation menu in MIS602 Database Modelling and Database Design. The Learning Facilitator will provide feedback via the Grade Centre in the LMS portal. Feedback can be viewed in My Grades.
    Academic Integrity Declaration
    I declare that except where I have referenced, the work I am submitting for this assessment task is my own work. I have read and am aware of Torrens University Australia Academic Integrity Policy and Procedure viewable online at http://www.torrens.edu.au/policies-and-forms
    I am aware that I need to keep a copy of all submitted material and their drafts, and I will do so accordingly.
    MIS602_Assessment 2_Brief_Database Implementation_Module 4.2 Page 2 of 3 Assessment Rubric Assessment Criteria Fail (Unacceptable) 0-49% Pass (Functional) 50-64% Credit (Proficient) 65-74% Distinction (Advanced) 75 -84% High Distinction (Exceptional) 85-100% ? Correct and complete queries ? Display only required information ? Demonstration of additional AQL knowledge 100% Queries are incorrectly answered with marks only sufficient to attain a F(ail). Queries correctly answered with sufficient marks to attain a (P)ass Queries correctly answered with sufficient marks to attain a (C)redit. Display only required information. Queries correctly answered with sufficient marks to attain a (D)istinction. Display only required information Display additional SQL knowledge such as column formatting, table alias, additional calculations etc Queries correctly answered with sufficient marks to attain a (HD) High Distinction. Display only required information. Display additional SQL knowledge. Well formatted queries. Results returned in a meaningful order. MIS602_Assessment 2_Brief_Data Implementation Module 4.1 Page 3 of 3

GET SOLUTION FOR THIS ASSIGNMENT

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

  • 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 Deliverycapitalessaywriting.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
  • Confidential- 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 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. Design solutions applying relational database techniques to complex problems and communicate these solutions to all stakeholders.

Get Professionally Written Papers From The Writing Experts 

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays
Categories
Writers Solution

Complex health care issues

The purpose of this assignment is for students to address complex health care issues that may or may not have a policy solution.
Directions

  • With regard to that statement do the following.
    • Write a position paper that addresses whether or not patients and families have a right to insist on receiving medical treatment that medical authorities agree is futile.
      • Provide evidence from a minimum of four references to support your position.
      • Provide a concise and thoughtful response to the question which considers, at a minimum, the following elements. Three to four pages 
        • Stakeholders
        • Government’s role and legislative substantiation.
        • Outcomes, both negative and positive.
        • Economic implications.
        • Quality of life issues.
        • Benefits to society.

SEE SOLUTION BELOW

CLICK HERE TO MAKE YOUR ORDER

TO BE RE-WRITTEN FROM THE SCRATCH

NO PLAGIARISM

Providing futile medical treatment

The ever-emerging new and innovative treatment options continue to offer hope to patients and their families that hitherto seemingly untreatable conditions may be treatable through more aggressive treatment and that there are improved end-of-care options. Knowledge of this by the patient through the ubiquitous information channels (e.g. Internet and mass media) has led to unprecedented patient sophistication, participation and expectation regarding their clinical situations. Because of this, patient’s autonomy, rights and medical ethics have become important issues. This is especially pronounced where the physician views further treatment as futile whereas the patient and their family are still expectant of a therapeutic solution (Willmott, White, Gallois, Parker, Graves, Winch, Callaway, Shepherdand Close, 2016). Such a situation raises clinical and ethical dilemmas.

Suffice to say there is no agreement on what constitutes “futile treatment” as there are often prognostic disagreements among physicians. The threshold for futility varies, with some physicians deeming 20% therapeutic benefit as futile while others consider it as futile when there is 0% benefit. Moreover some physicians want to try new treatments on the patient. Other physicians may fear admitting failure whereas others do not want to “abandon” the patient, having an emotional attachment. Hence there is confusion, controversy and debate as to what constitutes futile treatment(Howard and Pawlik, 2009).

Further, medical treatment futility is determined by the therapeutic goal. The goal could be to heal, to improve the quality of life or for end-of-life care. The patient and physician may not agree on the therapeutic goal, so this requires open communication and close collaboration between the two parties (Rubin and Bonomo, 2016). It is important tobe clear what the treatment aims to achieve so as to determine when the treatment is no longer useful.

Patient and the family hardly agree with the medical professionals about the futility of a treatment, with a tendency for families to want to prolong the treatment as a sign of care or love or as a compensation for their past neglect of their relative. In such situations, open communication from the start of the treatment between the two parties is important so as to set limits and to determine how to judge success or lack thereof. Treatment should be aimed at providing healthcare rather than impressing laypeople; be they the family, insurers or lawyers(Neville, Wiley, Yamamoto, Flitcraft, Anderson, Curtis and Wenger, 2015).Frank discussions and close collaboration between the parties also leads to suitable accommodations. Such accommodation may include prolonging the treatment to abate death of a pregnant woman until birth of a child or even supporting the patient to have good quality of life over Christmas period.

Moreover, if the family persists on pursuing treatment despite its futility, they may be encouraged to seek other opinions. As noted earlier, different physicians do not often agree on the futility of a treatment. Obstinate patient and family may be encouraged to pursue treatment with the physician(s) who feel the treatment is still beneficial.

When treatment is deemed futile, there is no professional obligation or government legislation requiring medical professionals to continue providing treatment(Willmott et al., 2016). Instead, the professionals are obliged to transition the patient to supportive care. Continuing to provide the futile treatment because a patient or the family insists…………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………………….. …………………………………………………………………………………………………………………………………………………………………………………………………………………………………. Complex health care issues  ….

NOTE THAT WHAT YOU HAVE JUST READ IS A SAMPLE PAPER ABOUT THE TOPIC. CLICK THE ORDER BUTTON TO ORDER YOUR OWN PAPER

Get Professionally Written Papers From The Writing Experts

Green Order Now Button PNG Image | Transparent PNG Free Download on SeekPNG Our Zero Plagiarism Policy | New Essays  

Categories
Writers Solution

Leadership and Management in Complex Systems research by Jager and van der Vegt (2005),

Chapter 13 – Our observations from the case study reading in the chapter material, Leadership and Management in Complex Systems research by Jager and van der Vegt (2005), is that leadership scholars seem to acknowledge the dynamic nature of leadership and have developed models and frameworks to organize and describe the factors that are important.  However, empirical research to test these models is scarce.  The authors have suggested several reasons for the lack of such research on dynamic leadership processes. 

Q1: Carefully identify at least four (4) reasons, and provide a brief narrative about each reason, an

d why the authors provided that reason?  what are those four reasons for the lack of research? provide a brief narrative for each reason to support your response

Chapter 13 – According to our chapter case study, agent-based gaming projects have been noted as requiring the interaction between many different actors with possible turbulences.  Following this research viewpoint, Jager et al. (2000), what are the functions of agent-based models in the simulated market?

Q2: What is the function of the agent-based model in the simulated market?

identify and name the function(s),  provide a short and succinct narrative of each