General Instructions

Complete the Addressing Ethical Dilemmas Assignment by following the steps below.

Download the Week 6 Addressing Ethical Dilemmas PowerPoint templateLinks to an external site.. Use of this template is required. If the template is not used, a 10% deduction will be applied. See the rubric.Submit the presentation as a .ppt or .pptx file to the Week 6 Dropbox. PDF files are not allowed, as speaker notes are not visible.Follow current APA grammar, spelling, word usage, and punctuation rules consistent with formal, scholarly writing.Include speaker notes for all slides except the title and reference slides. Use the Notes Page view feature in PowerPoint to include speaker notes.Use at least 3 scholarly sources to substantiate the information presented.Correctly cite and reference information from scholarly sources.Abide by Chamberlain University’s academic integrity policy.

Include the following sections (detailed criteria listed below and in the grading rubric)

Title SlideInclude your name and session.Introduction (1 slide)Identify the purpose of the presentation.Advanced Nursing Role (1-2 slides)Explain three ways advanced practice nurses can contribute to the resolution of ethical dilemmas in healthcare.Provide an in-text citation from one scholarly source to support your writing.Description of an Ethical Dilemma (2-4 slides)Describe an ethical dilemma from the literature or your nursing practice. You may reuse the information you wrote for this week’s Collaboration Café.Identify the stakeholders.Describe how the situation impacts stakeholders.Ethical Analysis (2-4 slides)Analyze the ethical principles in the conflict.Discuss which provisions of the American Nurses Association Code of Ethics apply.Provide an in-text citation from one scholarly source to support your writing.Recommendations (1-3 slides)Provide at least three recommendations for resolving the ethical dilemma.Provide an in-text citation from one scholarly source to support your writing.Conclusion (1 slide)Summarize the key points of the presentation.ReferencesCreate references in APA format. You may use bullets. Hanging indents are not required.Use at least 3 scholarly sources.Ensure each reference has a matching citation.

Presentation

The slides are professional in appearance and tone.Slide information is succinct and presented with bulleted points.A minimum of 18-point font is used and appropriate for audience reading.The presentation has 8-15 slides (excluding title and reference slides).Title and Reference slides are included.

Instructions:
Research an employee relations case using the following website:  https://www.canlii.org/en/ab/

Identify the issues or problems that took place both short term and long term and how the issue or problem could of all been avoided by being proactive.Give a recommendation going forward as if you were the employee relations expert consulting to the company. Draw on what you have learned through the class and the text book if applicable.

Hot Tip: Remember to complete the executive summary last, as it is a summary of section II-VI and information will be repeated.

Required Sections and Guidelines

Executive Summary, 2 pointsIn 2-3 sentences, summarize the case and issue(s) at high level of the employer and key person (s) (hyperlink the case from CanLII as well)Briefly identify the major problems facing the employer and key person (s)Summarize the judgement and or the recommendation of the case.Statement of Problem, 2 pointsState the problems facing the employer/key person (min 1 – 3)TIP: Include a hyperlink to the page if availableCauses of Problem, 2 pointsIdentify and link the symptoms and root causes of the problems (How did we get here) (min 1 – 3)Differentiate short term from long term problemsConclude with the decision facing the Judge if any Decision Criteria, 2 pointsIdentify criteria, documentations and/or reference material used in the case.Criteria/References/Case Law (External) (min 1 – 3 each)Documentation/Policies/Reports (Internal) (min 1 – 3 each)TIP: If you are unable to find this data then reference some similar past cases and any internal material that the company should have in place. Recommended Solution and/or justification, 2 pointsIdentify the judgment, and penalty as a result. If there was no information of the case being resolved explain what you think could be a likely court order or what the company should do to prevent this to going to Alberta Employment Standards or to the courts?Judgment or potential judgement in your opinionFinancial penalties or your thoughts around what this could cost the company (May be more than financial cost) Reflection / Summary, 2 pointsIn a 5-7 sentence Summary: How could have the issue been avoided? What proactive measures could have been in placed to prevent this situation? What would you recommend to this organization as an employee relations consultant?

 

 

Research an employee relations case using the following website https://www.canlii.org/en/ab/ . Your task will be to identify the issues or problems that took place both short term and long term. Think also about how this could of all been avoided by being proactive. Give a recommendation going forward as if you were the employee relations expert consulting to the company. Draw on what you have learned through the class and the text book if applicable. Remember to complete the executive summary last, as it is a summary of section II-VI and information will be repeated.

 

Required Sections

Format For Written Case Analysis Guidelines

I. Executive Summary

 

 

(2 Points)

 

Complete last

In 2-3 sentences,
summarize the case and issue(s) at high level of the employer and key person
(s) (hyperlink the case so I can find it)

 

Answer:

 

Briefly identify the
major problems facing the
employer and key person (s)

 

Answer:

 

Summarize the
judgement and or the recommendation of the case.

 

Answer:

 

II. Statement of the Problem

 

(2 Points)

 

State the problems
facing the employer/key person

 

Answer (hyperlink to
page if available):

A

B

C

 

III. 
Causes of the Problem

 

(2 Points)

 

Identify and link
the symptoms and root causes of the problems (How did we get here)

 

Answer :

A

B

C

Differentiate short
term from long term problems

 

Answer:

Short Term:

Long Term:

 

Conclude with the
decision facing the Judge if any

 

 

IV. Decision Criteria

 

(2 Points)

 

Identify criteria,
documentations and/or reference material used in the case.

 

Criteria/References/Case
Law (External):

A

B

C

 

Documentation/Policies/Reports
(internal):

A

B

C

If you are unable to
find this data then reference some similar past cases and any internal
material that the company should have in place.

V. 
Recommended Solution, Justification

 

(2 Points)

 

Identify the
judgment, and penalty as a result. If there was no information of the case
being resolved explain what you think could be a likely court order or what
the company should do to prevent this to going to Alberta Employment
Standards or to the courts?

 

Judgment or
potential judgement in your opinion:

A

Financial penalties
or your thoughts around what this could cost the company (May be more than
financial cost)

 

 

VI. 
Reflection

 

(2 Points)

 

In a 5-7 sentence
Summary: How could have the issue been avoided? What proactive measures could
have been in placed to prevent this situation? What would you recommend to
this organization as an employee relations consultant?

 

 

Total

                / 12

 

Assessment Details and Submission Guidelines

Trimester: T22024
Unit Code: HI5016
Unit Title: International Trade and Enterprise
Assessment Type: Group Assignment
Due Date + Time: September 27, 2024; Time: 11:59 PM
Weight: 40%
Total Marks: Assignment (40 marks)

Submission Guidelines

All work must be submitted on Blackboard by the due date along with a completed Assignment Cover Page.The assignment must be in MS Word format unless otherwise specified.

Academic Integrity Information
Holmes Institute is committed to ensuring and upholding academic integrity. All assessments must comply with academic integrity guidelines. Please learn about academic integrity and consult your teachers with any questions. Violating academic integrity is serious and punishable by penalties that range from deduction of marks, failure of the assessment task or unit involved, suspension of course enrolment, or cancellation of course enrolment.

Penalties

All work must be submitted on Blackboard by the due date and time, along with a completed Assessment Cover Page. Late penalties apply.Your answers must be based on the Holmes Institute syllabus of this unit. Outside sources may not amount to more than 10% of any answer and must be correctly referenced in full. Over-reliance on outside sources will be penalized.Reference sources must be cited in the text of the report and listed appropriately at the end in a reference list using Holmes Institute Adapted Harvard Referencing. Penalties are associated with incorrect citation and referencing.

Group Assignment Guidelines and Specifications

Purpose:
Students are expected to demonstrate their knowledge and understanding of a chosen topic by applying international trade theories and concepts learned during Week 1 to Week 10. The in-depth analysis of the two countries in Part 1 and the chosen topic in Part 2 should be supported by data/statistics, figures, tables, and relevant literature as taught in class Holmes Institute, HI5016 Blackboard site.

Detailed Requirements of the Assignment:
You are a group of advisors working in the Department of Trade and Foreign Affairs in Australia. First, as advisors, you are required to write a report covering any one of the topics as a theoretical review, based on the past 5 to 10 years, in which you compare two countries of your choice. Second, this report should provide useful findings and recommendations for investment and trade for the Department of Trade and Foreign Affairs for appropriate strategic decision-making for Australia and multinational enterprises in the country. Third, the report should use a variety of resources, including the textbook, newspapers, industry reports, the ABS website, and other sources. Each group must choose two countries (not including Australia). Finally, your Management Board requires that your research should predominantly be based on International Trade and Enterprise theory and the application of the Holmes Institute syllabus.

Part 1: Country Analysis Literature Review
Choose any two countries from the list of countries listed in Annex 1.

Task:
Conduct a detailed analysis of each country’s resources, international trade, and foreign direct investment. Innovation in regard to a good research paper is very important.

Part 2: Theoretical Review
Choose any one of the four topics below and conduct an in-depth theoretical review.

Comparative Advantage

For each country, identify an industry(ies) or sector(s) of comparative advantage. You must use relevant data/statistics to support your analysis used in the identification.Explain the reasons/sources of the comparative advantage in each of the chosen countries.Suggest ways to improve the comparative advantage in each country.Reasons for the flow of trade and investment, the factors affecting the industry or industries.

Terms of Trade

For each country, analyze its terms-of-trade trend over the last 10 years using relevant facts/figures.Identify and analyze factors affecting the trend in the terms-of-trade for each of the chosen countries.Analyze how the terms-of-trade affect welfare in the chosen countries.

Export Subsidies in Agriculture, Wind/Solar Energy Industry

Choose either an agriculture or a wind/solar energy industry from any country listed in Annex 1 that currently provides export subsidies to the industries. Discuss positive and negative aspects of the export subsidies on the country’s economy.Evaluate the effects of the export subsidies on the country’s welfare using relevant supporting data/statistics and literature.

Pattern of Trade

Choose any two countries from the listed countries in Annex 1. For each country, describe its pattern of trade over the last 30 years using relevant data.Identify and analyze factors responsible for a changing trade pattern in the chosen countries.In your opinion, discuss if your findings conform with what the trade theories predict.Examine the effects of the pattern of trade on Australia.

Part 3: Analysis and Findings
Conduct in-depth findings and analysis of your research demonstrating your understanding of the theories and applications learned in HI5016. Examine the effects of your findings on Australia’s economy.

Student Assessment and Referencing Rules (Adapted Harvard Referencing Rules)
Holmes has implemented a revised Harvard approach to referencing. The following rules apply:

Reference sources in assignments are limited to sources which provide full-text access to the source’s content for lecturers and markers.The reference list must be located on a separate page at the end of the essay and titled: “References.”The reference list must include the details of all the in-text citations, arranged A-Z alphabetically by the author surname with each reference numbered (1 to 10, etc.) and each reference MUST include a hyperlink to the full text of the cited reference source.

For example:

Hawking, P., McCarthy, B. & Stein, A. 2004. Second Wave ERP Education, Journal of Information Systems Education, Fall, http://jise.org/Volume15/n3/JISEv15n3p327.pdf

BUSN1001 Business Reporting and Analysis Assignment Help

Upper word limit: 3,500 words (excluding tables and reference list)

 SELECTION OF GROUP MEMBERS:

 Please form a group of 3-4 students (4 is preferable). Group members do not need to be from the same tutorial. The final submission will be assessed on its merits irrespective of the number of members in a group. 

 There will be 60 assignment groups created with 4 pre-selected companies (each company is allocated to 15 different groups). Please choose a company from the list below, and then register your group to that particular company in “Assignment – Group Selection” on Wattle. Please note that:

Group selection is on a first-come first-serve basis. If the company your group would like to work on has been selected by other groups, then your group will have to choose another company.Please do not register on groups that already have group members (unless the existing group members agreed for you to join them). Otherwise, you may be removed from the group. Please register your team by 2pm on Monday September 16. Anyone not registered by this date may be randomly assigned to a group.To find group members, you may post on the Assignment Forum. Alternatively, we may allocate some time during Week 6’s tutorial (where possible) for you to chat with your classmates and find a group.

 The list of the pre-selected companies (and the link to their annual report) is below:

ASX codeCompany NameLink to 2021 Annual ReportSHLSonic Healthcare LimitedSHLTWETreasury Wine Estates LimitedTWEREHReece LimitedREHFLTFlight Centre Travel Group LimitedFLT

 

REQUIREMENTS: 

 Based on the annual report of the company allocated to your group, prepare a report that addresses the following requirements:

Using the information contained in the financial statements from the 2023 Annual Report provided, calculate the financial ratios for 2022 and 2023 for the company allocated. The financial ratios required are listed in the template available at the end of this document (on page 4). Complete the template provided and attach it as the first page of your assignment. (20 marks)Referring to the ratios calculated for Requirement 1, analyse for the company allocated the overall changes in profitability, asset efficiency, liquidity, and capital structure between 2022 and 2023. (80 marks) 

In your analyses, you should:

Identify possible internal factors (i.e., some strategic transformations in the way the company is being run) and/or external factors that may have caused the changes. These factors are normally disclosed by the company’s directors or managers in the first few pages of the annual report (before the financial statements), where they explain the company’s financial performance and position. Your analysis should relate and critically evaluate this information disclosed in the annual report, but you may want to search for other information beyond the annual report. Compare the company’s ratios to the ratios of a competitor in a similar industry and analyse the differences observed.

 

LENGTH AND FORMAT:

 

The upper word limit of the assignment is 3,500 words (excluding tables and reference list). The assignment should be word-processed and written using professional, business English. You must use Times New Roman, 12 point font size, double spacing. The assignment is expected to be properly researched and prepared. The assignment should include a reference list identifying the sources used.In preparing the assignment, emphasis should be placed on: Proper identification of issues, logical arguments and depth of analysis Coherent structure, systematic presentation and clarity of expression.

 

SUBMISSION:

 

The assignment must be submitted in a single file in PDF or Microsoft Word. The name of the submitted file should include the ASX code of the company allocated and the ANU student IDs of all the group members and, e.g. “MTS u1234567 u7654321 u4321765 u7654123.pdf”. Assignment must be submitted in “Assignment Submission” on Wattle. Only one group member needs to submit. A completed and signed group assignment cover sheet must be submitted in “Cover Sheet Submission” on Wattle. Only one group member needs to submit.

 

REFERENCING:

 

You are expected to consult and reference news reports, financial reports, books and website in writing your essay. You should provide appropriate referencing where you use or discuss ideas from other authors’ works. All sources (including websites) must be acknowledged in accordance with the principles of academic honesty and integrity to which the ANU subscribes. The originality score on Turnitin will be reviewed for unacceptable copying. If you copy material then you must include “quotation marks”. Use a consistent system of referencing throughout the assignment. The Harvard referencing system is a common referencing style used in accounting discipline. 

 

PLAGIARISM:

 

The College regards plagiarism as any appropriation of the ideas or expressions of another without relevant and appropriate acknowledgment. This includes unattributed appropriation of text or content and may extend to improper referencing. Plagiarism will not be tolerated in this course and all discovered instances would be pursued to the full extent allowable under the rules. Where students have doubts as to how to deal with or acknowledge source materials in the assignment, they should consult the lecturer or tutor. 

 

TEAMWORK RESPONSIBILITIES:

 

Group members are expected to share the group work equally and contribute to the assignment. The following are requirements to facilitate teamwork for this assignment:

 

Submit a Group Assignment Contract defining member roles/responsibilities, team procedures, etc. Only one group member needs to submit. Each member should retain a copy of the contract. There are no marks for doing this but failure to submit or below standard submissions will incur a penalty of 5 marks for the assignment. Please submit this by 16 September 2024, 2pm in “Contract Submission” on Wattle.Complete an online Peer Assessment of Teamwork Performance on Wattle. All group members need to complete. You will be asked to reflect on each team member’s contribution to both the team process and task using a peer assessment rubric. This will have a direct effect on each team member’s final assignment mark. There are no marks for doing this but failure to submit will incur a penalty of 1 mark for the assignment. Please complete this by 08 October 2024, 5pm.If a student does not contribute to the assignment, the assignment mark will be 0 for the student who did not contribute.

 

ASSESSMENT:

The marks for Requirement 1 will be awarded for correct calculation of the ratios identified in the template below. The marks for Requirement 2 will be awarded based on the depth and breadth of coverage, quality of the analysis, evaluation and interpretation, and the writing of the report, including its English expression. The use of formal, professional expression is expected. Anything less than meticulous exposition will be penalised. An indicative marking criteria for Requirement 2 is attached. The assignment will be graded out of a possible 100 marks and all members of the group will receive the same score. That assumes that all group members contribute equally to the assignment. If that is not the case, students should contact the course convenor at the first sign that group members are not contributing according to the expectation.

TECH8000 IT Capstone
Assessment 3 Help

Assessment 3 Information
Subject Code: TECH8000
Subject Name: IT Capstone
Assessment Title: Client Presentation: Artefact Model
Assessment Type: Individual Presentation
Word Count: 10 Minutes (+/-10%)
Weighting: 40%
Total Marks: 40
Submission: Via MyKBS
Due Date: Week 13

Your Task
This assessment is to be completed individually. In TECH8000 IT Capstone Assessment, you will design and deliver a recommended artefact model to the client in the form of a presentation.
Please note: You will be required to use the same organization for all assessments in this subject.

Assessment Description
This assessment is designed to assess your ability to present research findings related to a client’s IT problem.
It is recommended to attend Weeks 10 to 12 workshops as they will be dedicated to presentation guidelines.

This assessment aims to achieve the following subject learning outcomes:

LO2: Collaborate with colleagues in the completion of IT-based research activities.LO3: Recommend and critically analyze multi-disciplinary IT solutions.LO4: Defend research findings and solutions to a client.

Assessment Instructions

Students must conduct external research and include references to produce a well-referenced assessment. You should use at least ten (10) sources of information and reference these in accordance with the Kaplan Harvard Referencing Style. These may include websites, social media sites, industry reports, census data, journal articles, and newspaper articles. These references should be presented as in-text citations and in a referencing list at the end of your assessment (not included in the word limit). Wikipedia and other ‘popular’ sites are not to be used.You must submit your presentation in a recorded video format using Kaltura via MyKBS. You aren’t required to submit the presentation slides as your slides and your face will be present in the video recording.The presentation should include the following topics:Client Understanding: Familiarize yourself with the client’s IT-based requirements and organizational context, considering the client’s industry-specific challenges.Multi-disciplinary IT Solutions: Recommend multi-disciplinary IT solutions that critically analyze and address the client’s complex problems. Integrate advanced concepts, theories, and frameworks from different disciplines to develop innovative and effective solutions.Artefact Model Design: Design an artefact model (e.g., presentation slides, interactive prototype, visual demonstration) that effectively communicates the recommended model to the client. Ensure the artefact model is visually appealing, well-structured, and tailored to address the specific concerns of the client.Presentation Delivery: Prepare a compelling presentation based on the artefact model design to deliver to the client.Professionalism and Communication: Demonstrate professionalism, resilience, and effective communication skills throughout the assessment, especially when interacting with the client.Please refer to the assessment marking guide to assist you in completing all the assessment criteria.

Important Study Information
Academic Integrity and Conduct Policy
https://www.kbs.edu.au/admissions/forms-and-policies
KBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism, and other academic offenses under the Academic Integrity and Conduct Policy.
Please read the policy to learn the answers to these questions:

What is academic integrity and misconduct?What are the penalties for academic misconduct?How can I appeal my grade?

Late Submission of Assignments (within the Assessment Policy)
https://www.kbs.edu.au/admissions/forms-and-policies

Length Limits for Assessments
Penalties may be applied for assessment submissions that exceed prescribed limits.

Study Assistance
Students may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Further details can be accessed at:
https://elearning.kbs.edu.au/course/view.php?id=1481

Generative AI Traffic Lights
Please see the level of Generative AI that this assessment (Level 2) has been designed to accept:

Traffic Light:
Amount of Generative Artificial Intelligence (Generative AI) usage
Evidence Required

Level 1
Prohibited: No Generative AI allowed.
This assessment showcases your individual knowledge, skills, and/or personal experiences in the absence of Generative AI support.
The use of Generative AI is prohibited for this assessment and may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment.Level 2
Optional: You may use Generative AI for research and content generation that is appropriately referenced.
See assessment instructions for details.
This assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of your assessment and to produce content that enhances your assessment (e.g., images). You do not have to use it.
The use of Generative AI is optional for this assessment.
Your collaboration with Generative AI must be clearly referenced, just as you would reference any other resource type used. Click on the link below to learn how to reference Generative AI:
https://library.kaplan.edu.au/…/referencing-other…
In addition, you must include an appendix that documents your Generative AI collaboration, including all prompts and responses used for the assessment.
Unapproved use of Generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment.Level 3
Compulsory: You must use Generative AI to complete your assessment.
See assessment instructions for details.
This assessment fully integrates Generative AI, allowing you to harness the technology’s full potential in collaboration with your own expertise.
Always check your assessment instructions carefully as there may still be limitations on what constitutes acceptable use, and these may be specific to each assessment.
You will be taught how to use Generative AI and assessed on its use.
Your collaboration with Generative AI must be clearly referenced, just as you would reference any other resource type used. Click on the link below to learn how to reference Generative AI:
https://library.kaplan.edu.au/…/referencing-other…
In addition, you must include an appendix that documents your Generative AI collaboration, including all prompts and responses used for the assessment.
Unapproved use of Generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above

𝑴𝑩𝑨621 𝑯𝒆𝒂𝒍𝒕𝒉𝒄𝒂𝒓𝒆 𝑺𝒚𝒔𝒕𝒆𝒎𝒔 𝑨𝒔𝒔𝒊𝒈𝒏𝒎𝒆𝒏𝒕 3 𝑯𝒆𝒍𝒑Assessment 3 InformationSubject Code:MBA621Subject Name:Healthcare SystemsAssessment Title: Assessment Type:Length:Report Individual report1500 words (+/- 10% allowable range)Weighting:30%Total Marks: Submission: Due Date:Week 13Your TaskIndividually, develop a 1500-word report on how the use of digital health care technologies can help address some of the challenges with providing health care to rural and remote Australians.MBA621 Healthcare Systems Assignment 3 HelpAssessment DescriptionThe purpose of MBA621 Healthcare Systems Assignment 3 is to holistically consider the key learnings throughout the subject and evaluate how current and emerging trends in digital health care technologies are being used and can be used to assist with many of the challenges facing the Australian health care sector.Assessment InstructionsAustralia is the 6th largest country by land mass in the world yet has only a population of just over 26 million people, most of whom are in urban environments. Despite Australia’s policy of providing universal and equal access to health care to its people, it continues to struggle with equity when it comes to rural and remote regions, many of which are populated by Indigenous Australians.This assessment requires you to evaluate the role digital health care technologies, how they can help to address some of these gaps to the benefit of all stakeholders.Areas covered in your report should include: A Cover page An Executive summary A Table of Contents An overview of the current health care challenges in providing quality care and service provision for rural and remote Australians. A critical discussion on the current digital health care technologies available for rural and remote communities. Discuss the ethical issues related to the use of digital health care technologies for rural and remote regions, including those who identify as Indigenous Australians. Identify the key rural and remote stakeholders involved and the benefits they receive using digital health care technologies. A conclusion References.You are required to use at least 10 sources of information and reference these in accordance with the Kaplan Harvard Referencing Style. These may include websites, government publications, industry reports, census data, journal articles, and newspaper articles.The cover page, Executive Summary, Table of Contents, Reference List, tables, images , and graphs are excluded from the word count.MBA621 Healthcare Systems Assignment 1 HelpAssessment SubmissionThis file must be submitted as a ‘Word’ document to avoid any technical issues that may occur from incorrect file format upload. Uploaded files with a virus will not be considered as a legitimate submission. MyKBS will notify you if there is an issue with the submitted file. In this case, you must contact your MyKBS error message. You are also encouraged to submit your work well before the deadline to avoid any possible delay involving the Turnitin similarity report or any other technical difficulties.Late assignment submission penaltiesPenalties will be imposed on late assignment submissions in accordance with Kaplan Business School “late assignment submission penalties” policy.Number of daysPenalty1* — 9 days5% per day for eachcalendar day latededucted from the total marksavailable10–14 days50% deducted fromthe total marksavailable.After 14 daysAssignments that are submitted more than 14 calendar daysafter the due date will not be accepted, and the student will receive a mark of zero for the assignment(s).NoteNotwithstanding the above penaltyrules, assignments will also be given amark of zero if they are submitted after assignments have been returned to students*Assignments submitted at any stage within the first 24 hours after the deadline will be considered to be one day late and therefore subject to the associated penaltyFor more information, please read the full policy via https://www.kbs.edu.au/about-us/school-policiesImportant Study InformationAcademic Integrity PolicyKBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy.What is academic integrity and misconduct? What are the penalties for academic misconduct? What are the late penalties?How can I appeal my grade?Click here for answers to these questions: https://www.kbs.edu.au/about-us/school-policiesWord Limits for Written AssessmentsSubmissions that exceed the word limit by more than 10% will cease to be marked from the point at which that limit is exceeded.Study AssistanceStudents may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Click here for this information.Generative AI Traffic LightsPlease see the level of Generative AI that this assessment has been designed to accept:Traffic LightAmount of Generative Artificial Intelligence (GenerativeAI) usageEvidence RequiredThis assessment(✓)Level 1Prohibited:No GenerativeAI allowedThis assessment showcases your individual knowledge, skills and/or personal experiences in the absence of Generative AI support.The use of generative AI is prohibited for this assessment and may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for theassessment.Level 2Optional:You may use GenerativeAI for research and content generation that is appropriately referenced.See assessment instructions for detailsThis assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of your assessment and to produce content that enhances your assessment. I.e., images. You do not have to use it.The use of GenAI is optional for thisassessment.Your collaboration withGenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenAI. https://library.kaplan.edu.au/referencing- other-sources/referencing-other-sources- generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the sectionabove.(✓)Level 3Compulsory:You must use GenerativeAI to complete your assessmentSee assessment instruction for detailsThis assessment fully integrates Generative AI, allowing you to harnessthe technology’s full potential in collaboration with your own expertise.Always check your assessment instructions carefully as there may still be limitations on what constitutes acceptable use, and these may be specific to each assessment.You will be taught how to use generative AIand assessed on its use.Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenAI. https://library.kaplan.edu.au/referencing- other-sources/referencing-other-sources- generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially resultin penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.

𝑻𝑬𝑪𝑯1400 𝑫𝒂𝒕𝒂𝒃𝒂𝒔𝒆 𝑫𝒆𝒔𝒊𝒈𝒏 𝒂𝒏𝒅 𝑴𝒂𝒏𝒂𝒈𝒆𝒎𝒆𝒏𝒕 𝑨𝒔𝒔𝒆𝒔𝒔𝒎𝒆𝒏𝒕 3Assessment 3 InformationSubject Code:TECH1400Subject Name:Database Design and ManagementAssessment Title:SQL Demonstration and analysisAssessment Type:Coding task and Video presentationAssessment Length:10Minutes(+/-10%)Weighting:40 %Total Marks:40Submission:Via MyKBSDue Date:Week 13Your TaskTECH1400 Database Design and Management Assessment 3 evaluates your SQL querying proficiency and your ability to justify and explain query logic. You will receive a database schema, data, and a scenario. You can use Gen AI tools for specific tasks only. The assessment consists of a SQL query task (Part A) and a detailed video explanation (Part B).TECH1400 Database Design and Management Assessment 3 HelpAssessment DescriptionIn this assessment, you will use a case study provided as a supplementary document. Your task is to retrieve data on the given database using MySQL to find answers to the questions in the Assessment Instructions. The database contains thousands of rows of data, making it impractical to find answers manually.This assessment aims to achieve the following subject learning outcomes:LO1:Investigate the use of Relational Database Management Systems in organisations.LO2:Construct database models.LO4:Create queries to manage data using a database querylanguage.Assessment InstructionsPart A: SQL QueryingAs an individual, you must download the database and data files and load them into MySQL. Once loaded, you must develop queries for the following questions:Note: You should include a comment above each query, specifying which question you are answering. In addition, you can use Gen AI tools to answer Questions (1–10) only, and responses to the SQL queries should be restricted to only the clauses used in workshop materials.Question 1: Display the first names of all employees who work in the department located in Sydney in alphabetical order.Question 2: Show employees who have worked at the University the shortest amount of time. Question 3: Display the names of all employees whose age is a palindrome.Question 4: List the departments along with the number of employees in each department. Question 5: Find the average salary of employees in each department.Question 6: Find the names and salaries of employees who are older than 40 years.Question 7: Show the employee details and their department names for those employees who have a “Lecturer” title.Question 8: Display employees’ first and last names and work out the original salary for all employees and their new salary after their (10%) bonus is applied.Question 9: Add a new attribute called “EmployeeInitials” to the Employees table.Question 10: Write a query that populates “EmployeeInitials”, based off the existing stored names.Question 11: Write 250 words explaining the integrity of this database. Is it up to standard? If yes, explain why and how. If not, what is wrong with the database’s integrity?Include your SQL queries in a single .sql file and submit it to Turnitin.TECH1400 Database Design and Management Assignment 1 HelpPart B: Video ExplanationYou should record a video discussing the following: Justify each SQL query in detail, including the syntax, the purpose of the query, and theappropriate output. Ensure your video is clear and audible. Show your SQL queries and the database schema while you explain. Keep your explanation concise and focused within a 9-minute to 11-minute timeframe.Recording and Submission You can record the video presentation using Kaltura and submit the recording after reviewing. Click the below link to learn how to record using Kaltura: https://elearning.kbs.edu.au/mod/scorm/view.php?id=339347 Turn on your webcam so we can see you to assess your presentation skills. You MUST host your video recording file in Kaltura only using MyKBS portal (using any other video hosting platforms will NOT be considered for marking).Important Study InformationAcademic Integrity and Conduct Policyhttps://www.kbs.edu.au/admissions/forms-and-policiesKBS values academic integrity. All students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Academic Integrity and Conduct Policy.Please read the policy to learn the answers to these questions: What is academic integrity and misconduct? What are the penalties for academic misconduct? How can I appeal my grade?Late submission of assignments (within the Assessment Policy)https://www.kbs.edu.au/admissions/forms-and-policiesLength Limits for AssessmentsPenalties may be applied for assessment submissions that exceed prescribed limits.Study AssistanceStudents may seek study assistance from their local Academic Learning Advisor or refer to the resources on the MyKBS Academic Success Centre page. Further details can be accessed at https://elearning.kbs.edu.au/course/view.php?id=1481Generative AI Traffic LightsPlease see the level of Generative AI that this assessment has been designed to accept:Traffic LightAmount of Generative Artificial Intelligence (GenerativeAI) usageEvidence RequiredThis assessment(✓)Level 1Prohibited:No GenerativeAI allowedThis assessment showcases your individual knowledge, skills and/or personal experiences in the absence of Generative AI support.The use of generative AI is prohibited for this assessment and may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment.Level 2Optional:You may use GenerativeAI for research and content generation that is appropriately referenced.See assessment instructions for detailsThis assessment allows you to engage with Generative AI as a means of expanding your understanding, creativity, and idea generation in the research phase of yourassessment and to produce content that enhances your assessment. I.e., images. You do not have to use it.The use of GenAI is optional for thisassessment.Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenerativeAI.https://library.kaplan.edu.au/referencing-other-sources/referencing-other- sources-generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.✓Level 3Compulsory:You must use GenerativeAI to complete yourassessmentSee assessment instruction for detailsThis assessment fully integrates Generative AI, allowing you to harness the technology’sfull potential in collaboration with your own expertise.Always check your assessment instructions carefully as there may still be limitations on what constitutes acceptable use, and these may be specific to each assessment.You will be taught how to use generative AI and assessed on its use.Your collaboration with GenerativeAI must be clearly referenced just as you would reference any other resource type used.Click on the link below to learn how to reference GenerativeAI.https://library.kaplan.edu.au/referencing-other-sources/referencing-other- sources-generative-aiIn addition, you must include an appendix that documents your GenerativeAI collaboration including all prompts and responses used for the assessment.Unapproved use of generative AI as per assessment details during the content generation parts of your assessment may potentially result in penalties for academic misconduct, including but not limited to a mark of zero for the assessment. Ensure you follow the specific assessment instructions in the section above.

Assessment Details and Submission Guidelines

Trimester 

T2 2024

Course Name 

Master of Data Analytics (MDA)

Unit Code 

MDA621 

Unit Title 

Software Practice for Big Data Analytics

Assessment 

Type

Assignment 2 (Group Assessment)

Assessment  

Title

Perform Data Analytics on Real-World Problems Using Amazon Web Services.

Purpose of the  assessment  

(with ULO  

Mapping)

This assignment assesses the following Unit Learning Outcomes; students should be able to demonstrate their achievements in them. 

c. Select the tools in the chosen software stack to design and program the big data  analytics platform; 

d. Relate the concept and use of visualization to big data analytics; e. Develop and appraise big data platforms for predictive analytics in complex real world domains.

Weight 

25%

Total Marks 

100 Marks

Word limit 

700-1200 Words

Due Date 

29 Sep 2024, 23:59 – Week 11 Sunday

Submission  

Guidelines

GENERATIVE AI TOOLS MAY BE USED WITH PRIOR PERMISSION  Students are permitted to use advanced automated tools for this formative assessment only  for understanding, learning and research purposes. Using Gen AI tools to write  assignments for you, will be considered as Academic Misconduct, and it will be penalized. If  students are using any of the information from Gen AI, then you must cite or attribute the  use of the Gen AI in their assessment. 

Group Submit (only the group leader): 

• Name your final report “MDA621_T2_2024_Assigment2_GroupID.docx” • Results, including codes and commands, in a MS Word file. 

• A maximum 10-minute recorded video (mp4 format) with all members participating  in presenting your analytics solutions. It is recommended that the recorded video be  uploaded to YouTube, and then include the URL link towards the end of the final  report. Please do not upload video directly onto Moodle. 

Individual Submit (every student): 

• Complete the “Peer Evaluation” table by commenting on contributions and  participation by your team members. Please include your team member’s name in the  evaluation. 

• The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font  and 2.5 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report and listed appropriately at the  end in a reference list using either the IEEE or the APA referencing style.

Extension 

• If an extension of time to submit work is required, a Special Consideration Application  must be submitted directly on AMS. You must submit this application three working days prior to the due date of the assignment. Further information is available at

Academic  

Misconduct

Academic Misconduct is a serious offense. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and  procedure available at:.

For further information, please refer to the Academic Integrity Section  in your Unit Description.

Description 

In this group assignment, you will explore various aspects of big data analysis and manipulation  using the Hadoop ecosystem, specifically focusing on Pig Latin and Hive Query Language  (Hive QL). The primary objective of this assignment is to gain practical experience in processing  large-scale data sets and understanding the differences in data trends over time. You will be working  with two distinct data sets: patent data and sale data related to patent applications and sale transactions. 

For the first part of the assignment, you will use patent data from the United States (US) and abroad  to analyze the total patent applications applied and granted each year. This will involve executing  patent files, creating directories on a Hadoop cluster, and running the Pig Latin program to count the  total number of patent applications applied and granted yearly. This analysis will help you  understand the development of analytics reports on patent data over a decade. 

In the second part of the assignment, you will work with sales data using Hive QL commands. The  primary goal here is to analyze product sale transactions by performing various data operations such  as uploading files to HDFS, joining multiple data sets, grouping data, and performing calculations  such as listing customers, products and supplier details. You will also filter and display the expensive  products and the average price of all products.  

By the end of this assignment, you will have acquired hands-on experience in leveraging the Hadoop  ecosystem to analyze and manipulate large-scale data sets efficiently. This will serve as a foundation  for further exploration in the field of big data analysis and processing. 

Note: As a starting point, it is essential to apply the knowledge gained from previous lessons to  create a cluster on Amazon Web Services (AWS) and set it up properly to execute all required files. Including, setting up the EC2 and EMR cluster on AWS, SSH to connect to the cluster, and setting  up the File Transfer Protocol. These initial steps lay the foundation for successfully managing and  processing large-scale data sets using the Hadoop ecosystem on a cloud-based platform.

Your Tasks 

To complete Assignment 2, which comprises two main parts, your team will follow the steps outlined  in the two questions below to perform data processing and analysis tasks using the Hadoop  ecosystem, Pig Latin and Hive QL. The primary focus will be working with datasets related to patent data and sale data, allowing for hands-on experience in managing and processing large-scale  information efficiently. 

Part I: Download the US_patent.csv data from the Assignment 2 folder on Moodle. It is a comma separated value (CSV) file. The file includes a list of US patents applied and granted between  1965 and 2020. The column “Total Patent Applications” in the file presents the total applied  applications, and “Total Patent Grants” contains information about total granted applications.  

[40 Marks] 

For Part I, using Pig Latin commands and Tableau to perform the following tasks: 

1. Upload the files to HDFS. 

2. Create directories on the cluster and name the directory Patent.  

3. Load the file US_patent to the new directory. 

4. Write a Pig program to find the total number of patents applied each year. 

5. Write a Pig program to find the total number of patents granted each year. 

6. Observe and compare the applied rate and granted rate from 1965 and 2020. 

7. Using Tableau Software, visualize the results in a suitable manner. Choose the format that you find  most appropriate. 

8. In 350 words, summarize your understanding of the changing trends and accepted rates of patent applications.  

Part II: Download the saledata.zip data from Assignment 2 folder on Moodle. This file is  compressed, and once you unzip it, you will find five tab-delimited text formats files: 

[50 Marks] 

• customer (which contains information about customer ID, name and zip code) 

• product (which contains information about product ID, name, price, supplier ID and product  category) 

• product sales(which contain information about product id, corresponding sale transaction id and  no of items sold) 

• sales (which contain information about sale ID, customer ID, store ID and transaction year) • supplier (which contains information about supplier ID and supplier name) 

           For Part II, using Hive QL commands to perform the following operations: 

1. Upload the five files to HDFS 

2. Create a directory on the cluster and name the directory Sales.  

3. Create a database named sales_db and create tables where the above files can be loaded.  

4. Display the supplier id and supplier name for all suppliers. 

5. Display the customer’s name and customer zip for all customers. 

6. Display the product id, product name, product price, and supplier name for all products. 

7. Filter and display the product id, product name, and product price for products with a product  price of $500 or lower. 

8. Filter and display the customer’s name and sale year for sales involving a customer buying more  than two products. 

9. Filter the top product id and product name based on product price. 

10. Calculate the average price of all products. 

11. In 350 words, summarize your findings. 

Submission 

The group must submit the followings (only group leader submits on behalf of the whole group): • A final report should detail how your team has carried out each step of the data analytics process  explained above, any assumptions made in the analysis, any limitations in your models, and comparison  of your findings. The names of team members must be included on the cover page.  • Include all Python code required for processing data analysis. 

• A maximum 10-minute recorded video (.mp4 format) with all members participating in presenting  this group Assignment 2. You can use PowerPoint slides in your presentation.  Each student must additionally submit: 

• “Peer Evaluation” table by commenting on contributions and participation by your team members.  Please include your team member’s name in the evaluation.

Marking Criteria for the Assignment 2 

Sections 

Description of the section 

Marks

Part I 

• You will use US patent data from 1965 and 2020 to analyze the applied and  granted applications over the decade. You will use a Pig Latin program to count  the applications for each year. It will involve creating directories on a Hadoop  cluster and running the Pig Latin program. Finally, visualize the results using  Tableau Software. 

40

Part II 

• You will work with sales data using HiveQL commands. The primary goal here  is to analyze sale transactions by performing various data operations such as  uploading files to HDFS, joining two data sets, grouping data, and performing  calculations such as total sales and customer buying patterns. You will also filter  and display the top product with the highest price.

50

Video  

Presentation

• “Peer Evaluation” table by commenting on contributions and participation by  your team members. 

10

Total Marks 

100

Example Marking Rubric for Assignment

Grade  

Mark 

Part I: 

Part II: 

Video  

Presentation

HD 

80% 

+

D 

70%-9%

CR 

60%- 9%

P 

50%- 9%

Fail 

<50% 

Unsatisfactory 

Argument is  confused and  

disjointed 

Argument is  confused and  

disjointed 

None or poor  

presentation  

of results.

Excellent 

Very Good 

Good 

Satisfactory 

Detailed data  Analysis,  

Interpretation of Results in  

written final  

report.

Consistency  

logical and  

convincing

Mostly  

consistent  

logical and  

convincing

Adequate cohesion and conviction

Detailed data  Analysis,  

Interpretation of Results in  

written final  

report.

Consistency  

logical and  

convincing

Mostly  

consistent  

logical and  

convincing

Adequate cohesion and conviction

Excellent  

presentation of results.

Good  

presentation 

n of results.

Average  

presentation  

of results.

Acceptable  

presentation of  results.

      For More Assignment Samples:-

Assignment Question

For this assessment, research best practices related to a current health care problem. Your selected problem or issue will be utilized again in Assessment 4. To explore your chosen topic, you should use the first two steps of the Socratic Problem-Solving Approach to aid your critical thinking. Select one of the health care problems or issues presented in the Assessment 02 Supplement: Applying Research Skills [PDF] Download Assessment 02 Supplement: Applying Research Skills [PDF] resource. Write a brief overview of the selected health care problem or issue. In your overview: Summarize the health care problem or issue. Describe the professional relevance of this topic. Describe any professional experience you have with this topic. Identify peer-reviewed articles relevant to this health care issue or problem.

Conduct a search for scholarly or academic peer-reviewed literature related to the topic and describe the criteria you used to search for articles, including the names of the databases you used. You will select four current scholarly or academic peer-reviewed journal articles published during the past 3–5 years that relate to your topic. Refer to the NHS-FPX4000: Developing a Health Care Perspective Library Guide to help you locate appropriate references. Use keywords related to the health care problem or issue you are researching to select relevant articles. Assess the credibility and explain relevance of the information sources you find. Determine if the source is from an academic peer-reviewed journal. Determine if the publication is current. Determine if information in the academic peer-reviewed journal article is still relevant. Analyze academic peer-reviewed journal articles using the annotated bibliography organizational format. Provide a rationale for inclusion of each selected article. The purpose of an annotated bibliography is to document a list of references along with key information about each one. The detail about the reference is the annotation. Developing this annotated bibliography will create a foundation of knowledge about the selected topic. In your annotated bibliography: Identify the purpose of the article. Summarize the information. Provide rationale for inclusion of each article. Include the conclusions and findings of the article.

Write your annotated bibliography in a paragraph form. The annotated bibliography should be approximately 150 words (1–3 paragraphs) in length. List the full reference for the source in APA format (author, date, title, publisher, et cetera) and use APA format for the annotated bibliography. Make sure the references are listed in alphabetical order, are double-spaced, and use hanging indents. Summarize what you have learned while developing an annotated bibliography. Summarize what you learned from your research in a separate paragraph or two at the end of the paper. List the main points you learned from your research. Summarize the main contributions of the sources you chose and how they enhanced your knowledge about the topic. Provide a title page and reference page following APA style

Case Study 7 – United States Auto Industry Back on Top … of CEO Pay Textbook Chapter 10 Case Study 1 p. 414 During the financial crisis, many executives’ pay was stifled, reduced, or even withheld. Among the hardest hit was the U.S. auto industry. Shareholder groups, union leaders, political officials, and the general public all demanded change in the way auto industry executives were getting rich while their cars were getting poor. For example, Ford made some major cuts for its executives and its employees. This is why people were shocked to find out that for 2011 the CEO of Ford, Alan Mulally, was to receive $56.5 million in stock awards. Even today, it is one of the richest pay packages ever given to a top executive in the auto industry—and it is even after all the clamor over sky-high executive paychecks. Is it too much? That depends on who you ask. For most, it seems unreasonable that a boss would make more than 1,000 times the pay of the average worker. However, if you ask Ford workers who have seen Mulally steer Ford back from the edge of bankruptcy, they probably would not complain too much. If you asked Ford’s shareholders, it would be hard for them to overlook the fact that Ford shares have gone from $1.56 when Mulally first took over to $14 a share. If you ask Ford dealers, they may be too busy selling one of the strongest lineups of cars around to answer. Of course, no one really knows if Ford would have been sitting in such a good position regardless of Mulally. On one hand, there are plenty of factors, such as a national economic recovery, that led to Ford’s improvements that Mulally clearly could not have had a finger on. On the other hand, there are plenty of companies that would be willing to pay $50 million if they knew their company would rebound as Ford has under Mulally. Questions 1. Are CEOs and key corporate executives worth the large pay packages they receive? Explain. 2. Do you agree with Peter Drucker that corporate executives should receive compensation packages no larger than a certain percentage of the pay of hourly workers? Explain. 3. Will the Dodd–Frank Wall Street Reform and Consumer Protection Act giving shareholders the right to vote on executive pay influence the size of these packages in the future? Explain. Source: Adapted from Phil LeBeau, “Mulally and Bill Ford Collect $100 Million Pay Package,”