Monthly Archives: May 2016

Medical Coding ICD-10



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

 

 

1. This 60-year-old patient was admitted with emphysematous nodules.  A thoracoscopic wedge resection was performed in the left lung to remove the lung nodules.  A resection was done in the upper and lower lobes.  Which of the following answers is correct? (Points : 2)

J98.4, 32666, 32667
J43.9, 32666
J98.4, 32505
J43.9, 32666, 32667

Question 2. 2. A neonatal patient is brought to the operating room for repair of complete transposition of the great arteries under cardiopulmonary bypass. The infant is in critical condition and may not survive. Assign the correct diagnosis codes and CPT codes to report the administration of anesthesia, including physical status, Level I and II modifiers, and qualifying conditions for this procedure. (Points : 2)

Q20.3, 00562–AA–23, 99100
Q20.1, 00561–AD–P5, 99140
Q20.3, 00561–AA–P5
Q20.3, 00563–AA–P5, 99100, 99140

Question 3. 3. A 69-year-old patient was hit by a car, causing intra-thoracic trauma and hemorrhage.  The patient was taken directly from the Emergency Department to the operative suite where the chest was opened and hemorrhage was controlled, but the patient’s heart stopped.  Open heart massage was performed but the patient expired before the patient could be admitted.  Assign the appropriate CPT code(s) and any required modifier(s) to report this service. (Points : 2)

32110-CA
32110, 32160
32160-CA
32110-CA, 32160-CA

Question 4. 4. A non-Medicare patient with carcinoma of the oral cavity and lower lip is receiving daily intramuscular injections of the interferon alfa-2a (3 million units) in the outpatient cancer center.  Which of the following will be reported for this service?  The payer does accept HCPCS Level II codes for drugs. (Points : 2)

Z51.12, I49.8, 96401, J9213
C14.8, 96372, J9213
C06.9, C00.2, 96372
Z51.12, 96549

Question 5. 5. An elderly patient has an abscess formation around a pacemaker pocket on his chest wall that requires that the device be removed and the pocket reformed in another location.  Which of the following code sets is appropriate for this outpatient surgical service?  (Points : 2)

T82.7XXA, L02.219, 33222
L02.219, 33222
T82.7XXA, 33223
T82.857A, L02.219, 33999

Question 6. 6. Assign the appropriate ICD-10-CM diagnosis code for aspiration pneumonia due to inhalation of food. (Points : 2)

J15.9
J69.0
J18.9
J69.1

Question 7. 7. A hospital-based pediatric clinic is treating a newborn with talipes equinovarus by manipulation and short leg casting. Which of the following code sets is reported for a visit where the condition is evaluated with a -problem-focused history and examination and parents’ questions are answered, followed by foot and ankle manipulation and replacement of the plaster cast? (Points : 2)

Q66.6, 29450
M21.549, 29405
Q66.0, 29405
Q66.0, 99212–25, 29450

Question 8. 8. A 32-year old female has recently had surgery for melanoma of the right lower leg, Clark level IV>  She had no other signs of metastasis or adenopathy.  Under general anesthesia, a sentinel node biopsy of the deep axillary nodes was performed with a gamma counter probe.  An injection of isosulfan blue dye was performed and the nodes followed carefully to the single-bright-blue node.  This node was excised and sent for frozen section, which proved to be negative for melanoma.  Before the procedure, the radiologist performed a lymphoscintigraphy.  Which of the following code sets would the surgeon report. (Points : 2)

C44.691, 38525
C4A.71, 38525, 38792
C4A.71, 38525, 38792–51, 78195
C43.9, 38525, 38790–51

Question 9. 9. What code(s) is/are assigned for a patient receiving home care after a kidney transplant? (Points : 2)

Z48.29
Z48.298, Z94.0
N18.6
Z94.0

Question 10. 10. What would be the appropriate ICD-10-CM code for lumbar stenosis? (Points : 2)

M48.00
M48.06
M48.07
M48.26

Question 11. 11. Dr. Smith sent a patient to observation care at the local hospital following his visit to the nursing facility.  The patient was admitted for observation to rule out stoke due to a change in mental status.  The next morning, Dr. Smith left town, and his partner, Dr., Johnson, admitted the patient to inpatient care because of sudden worsening symptoms.  The patient expired later the same day.  Assuming documentation guidelines were met, how would E/M services for these two physician be coded? (Points : 5)

Dr. Smith: 99315; 99219; Dr. Johnson:  99236
Dr. Smith: 99219; Dr. Johnson:  99217, 99236
Dr. Smith: 99219; Dr. Johnson:  99236
Dr. Smith: 99315; 99222; Dr. Johnson:  99238

Question 12. 12. The following documentation is from the health record of a 3-year-old child.Parents bring their 3-year-old boy, who was born with hydrocephalus, to the pediatric neurology clinic at Unive3rsity Hospital to have the child evaluated by the pediatric neurologist and have his VP shunt lengthened to accommodate a growth spurt.  Their pediatrician requested a consultation to evaluate the shunt and replace the peritoneal catheter if needed.  Outpatient surgery had been previously scheduled tentatively pending this evaluation for the afternoon.

The catheter used in the shunt was removed and replaced in the outpatient surgery suite following a follow-up consultation, which included a detailed interim history, a detailed examination, and medical decision making of moderate complexity.  Findings documented in the consultation include “Assessment: Shunt valve malfunction requiring replacement”.  The VP shunt valve was replaced along with a new peritoneal catheter in a longer length.

Which of the following code sets will be reported for this service? (Points : 5)

Z45.41, 62230
T8503XA, Q03.9, 62230
Q03.9, Z45.41, 62225
Q03.9, 62230

Question 13. 13.This 21-month old male presents to the Emergency Department with nausea and vomiting since 10 pm last night, at least 8 times, which is nonbloody but bilious.  Temp of 39.8 since last night.  He has a history of Tetralogy of Fallot, s/p repair 2 months ago.  He has known immunodeficiency, laryngomalacia, and a gastrostomy tube.  After examination, working differential diagnoses are acute gastroenteritis, bacteremia, or possible septicemia.  Symptoms similar to episode about 1 month ago that was determined to be bacteremia with G-tube site infection.  The patient is treated with Zofran 2 mg IV, followed by Ceftriaxone 600 mg IV.  The patient is discharged after resolution of vomiting and fever.  Diagnosis listed as acute gastroenteritis.

Assign the correct ICD-10-CM codes for the facility services provided today.

(Points : 5)

D84.9, K52.9, Q31.5, Z87.74, Z93.1
D84.9, K52.9, Q31.5, Z98.89, Z93.1
D84.9, K52.9, Q33.5, Z84.74, Z98.89, Z93.1
D84.9, K52.9, Q31.5, Z84.74, Z98.89

Question 14. 14. A 48-year-old man came in to the emergency department complaining of vomiting material resembling coffee grounds several times within the past hour.  He has abdominal pain and has been unable to eat for the past 24 hours.  He is dizzy and lightheaded.  Two stools today have been black and tarry.  While in the emergency department, he vomited bright-red blood and some material resembling coffee grounds.  A nasogastric tube was inserted by the ED physician and attached to suction.  An abdominal exam showed a fluid wave consistent with ascites.  CBC and clotting studies were drawn.  A detailed history and physical exam with high-complexity medical decision making were documented.  A GI consultant was called and the patient was taken to the Endoscopy for further evaluation of upper GI bleeding.  Diagnosis:  Hematemesis, rule out esophageal varices; blood loss anemia, acute; ascites.Which of the follow is the correct diagnosis and CPT procedure assignment for the independent ED physician? (Points : 5)

K92.0, D62, R18.8, 99285, 43752

K92.0, R10.9, R42, 99284-25, 91105

R18.0, K92.0, D50.0, 99284, 43752

K92.0, D62, R18.8, 99284-25, 43752

Question 15. 15. The following documentation is from the health record of a 39-year-old female patient.This 39-year-old female was diagnosed with breast cancer 2 years ago.  At that time she had a mastectomy performed, with no evidence of metastases to the lymph nodes.  About 8 months ago, metastases were found in her liver.  The patient was given chemotherapy.  She has been losing weight and developing increased fatigue.  Patient was referred to hospice care program, with a life expectancy of 4 to 6 months.  Progressive weight loss due to loss of appetite led to cachexia and program of home intravenous hyperalimentation.  Progressive, unrelenting abdominal pain led to chronic use of analgesics.  Patient is awake, alert, and desires to spend more time with family.  Progressive weakness and dropping hemoglobin led to the decision to transfuse the patient every 2 weeks with 2 units of packed cells.  Patient is stable and more comfortable on this regimen.

What are the correct diagnosis codes assigned in this case? (Points : 5)

D63.0, D64.81, C78.7, Z85.3, T45.1X5

D64.9, C78.7, Z85.3, T45.1X5

D63.0, C78.7, Z85.3, T45.1X5

D64.9, C78.7, Z85.3

Question 16. 16. The patient is a four-year-old male with acute lymphocytic leukemia who has had a fever for the last 24 hours.  It has been nine days since his last chemotherapy, which was his first.  A comprehensive history is documented.  On examination, the skin over his Hickman site is extremely red and starting to break down.  No other abnormal findings are noted in the comprehensive exam.  Labs show that the patient is not neuropenic.  The physician lists the diagnoses as :  ALL not in remission, infected Hickman.  The patient is given 770 mg of Ceptz over 10 minutes through a new peripheral IV site and admitted for continued treatment.  Medical decision making is moderate.What code set is reported for the services of the emergency physician? (Points : 5)

C91.00, T827XXA, R50.9, 99284-25, 96374
T80218A, Y83.8, 99284
C91.00, T8579XA, R50.81, 99285
C91.00, T80219A, 99285-25, 96374



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

ITECH5402- Enterprise Systems



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Team assignment – Semester 1, 2016
TEAM ASSIGNMENT CONSISTS OF TEAM REPORT AND TEAM PRESENTATION
Weighting: 25% (15% for the report and 10% for the presentation)
TEAM REPORT
REQUIRED
Form a team of between 2 – 3 members. Write a team report of about 3000 words on one of the following research topics. The report must include at least one case study to reflect the topic of discussion.
• Domain-based ES, such as ES in finance, supply chain, accounting, healthcare, customer-relationship management, knowledge management, and outsourcing
• ES implementations, which include Cloud ES, ERP II and Business Process Modelling Tools
• ES in business intelligence and analytics, which include ES role in big data, mobile ES, ES-facilitated social networking interaction
• ES integration within and across organizational boundaries
Each team is expected to present their report findings to as part of the “Team Report Presentation” assessment task during week 10.
You are reminded to read the “Plagiarism” section of the course description. Your essay should be a synthesis of ideas from a variety of sources expressed in your own words.
All reports must use the APA referencing style.
University Referencing/Citation Style Guide:
The University has published a style guide to help students correctly reference and cite information they use in assignments (American Psychological Association (APA) citation style,
http://www.ballarat.edu.au/aasp/student/learning_support/generalguide/print/ch06s04.shtml or Australian citation style
Reports are to be presented in hard copy in size 12 Arial Font and double spaced. Your report should include a list of references used in the essay and a bibliography of the wider reading you have done to familiarize yourself on the topic.
Report Submission: Hard-copy to tutors/lecturers assignment box in week 11. Double-sided printing for the hard-copy is encouraged in order to save paper. Declaration should be done to declare how much (percentage) each of the team has contributed to the report.
A passing grade will be awarded to assignments adequately addressing all assessment criteria. Higher grades require better quality and more effort. For example, a minimum is set on the wider reading required. A student reading vastly more than this minimum will be better prepared to discuss the issues in depth and consequently their report is likely to be of a higher quality. So before submitting, please read through the assessment criteria very carefully.

Team Report
Weighting: 15% for Team Report
Student IDs:
Assessment Criteria:
Score Very Good Good Satisfactory Unsatisfactory (0)
Presentation /Layout
/1 mark Information is well organized, well written, and proper grammar and punctuation are used throughout. Correct layout used. Information is organized, well written, with proper grammar and punctuation. Correct layout used. Information is somewhat organized, proper grammar and punctuation mostly used. Correct layout used.
Information is somewhat organized, but proper grammar and punctuation not always used. Some elements of layout incorrect.
Structure
/1 mark Structure guidelines enhanced Structure guidelines followed exactly Structure guidelines mostly followed. Some elements of structure omitted
Introduction
/1 mark Introduces the topic of the report in an extremely engaging manner which arouses the reader’s interest. Gives a detailed general background and indicates the overall -plan- of the paper. Introduces the topic of the report in an engaging manner which arouses the reader’s interest.
Gives some general background and indicates the overall -plan- of the paper. Satisfactorily introduces the topic of the report.
Gives a general background.
Indicates the overall -plan- of the paper. Introduces the topic of the report, but omits a general background of the topic and/or the overall -plan- of the paper.
Discussion of topics
/7 marks All topics discussed in depth. Displays deep analysis of issues with no irrelevant info. Consistently detailed discussion. Displays sound understanding with some analysis of issues and no irrelevant information Most topics are adequately discussed.
Displays some understanding and analysis of issues. Inadequate discussion of issues Little/no demonstrated understanding or analysis of most issues and/or some irrelevant information.
Case Study
/2 marks Case study clearly reflects at least one of the points discussed and the lessons learned Case study clearly reflects the topic discussed, but lessons are not well abstracted Case study is relevant but does not clearly reflect the point of discussion Case study is irrelevant to the topic of discussion
Conclusion
/1 mark An interesting, well written summary of the main points.
An excellent final comment on the subject, based on the information provided. A good summary of the main points.
A good final comment on the subject, based on the information provided. Satisfactory summary of the main points.
A final comment on the subject, but introduced new material. Poor/no summary of the main points.
A poor final comment on the subject and/or new material introduced.
Referencing
/2 marks Correct referencing (APA). All quoted material in quotes and acknowledged. All paraphrased material acknowledged. Correctly set out reference list. Mostly correct referencing (APA). All quoted material in quotes &acknowledged. All paraphrased material acknowledged.
Mostly correct setting out reference list. Mostly correct referencing (APA ) Some problems with quoted material and paraphrased material
Some problems with the reference list. Not all material correctly acknowledged.
Some problems with the reference list.
SubTotal-1

/15 marks

Team Report Presentation
Weighting: 10% for Team Presentation
Students are expected to create and present a 10-15 minute overview of the findings from their Team Report.
Student IDs:
Assessment Criteria:
Criteria Marks
Introduction
/1
Content
/4
Conclusion
/1
Presentation Style eg clarity, engagement
/2
Team participation /1
Timing (10-15 minutes)
/1
SubTotal-2 /10
General Comments:
Team assignment Total = SubTotal-1 + SubTotal-2.

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Assignment 2 Decision Support System (DSS)



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Assignment 2
Decision Support System (DSS)
Description Marks out of Wtg(%) Due date
ASSIGNMENT 2 100.00 25.00 25th May 2016
This assignment must be your own work. It is acceptable to discuss course content with others to improve your understanding and clarify requirements, but solutions to assignment questions must be done on your own. You must not copy from anyone, including tutors and fellow students, nor allow others to copy your work. All Assignments will be checked using collusion monitoring tools to ensure that each assignment is the original work of the submitting student. Assignments that do not adhere to this requirement will be deemed as being the result of collusion or plagiarism. This may lead to severe academic penalties as outlined in USQ Policy Library: Academic Integrity Policy and Procedure. It is your own responsibility to ensure the integrity of your work. Refer to the USQ Policy Library for more details:
• Academic Integrity Policy
• Academic Integrity Procedure
In completing this assignment, you are expected to use available resources such as the practical activities in the study modules, the Course Study Desk – especially the Discussion Forums (click the Study Desk link on UConnect – http://uconnect.usq.edu.au ), as well as exploring and experimenting on your own.
Applicable course objective:
• demonstrate problem-solving skills by identifying and resolving issues relating to information systems and their components, and proficiently utilise different types of information systems software (especially gaining proficiency in utilising databases, spreadsheets, and presentation applications).
• demonstrate written communication skills by understanding basic information, communication and technology (ICT) terminology for effective communication and applying it within a business environment.
Applicable graduate qualities and skills gained from this assessment instrument:
• Problem Solving (Skill U2)
• Written & Oral Communication (Skill U4)
This assignment is quite complex, and exposes you to many different components in Microsoft Excel 2007/2010/2013, some or all of which might be very unfamiliar to you. The assignment description provides some explanation of how to use these components, but you are also expected to use available resources such as Online Help, the Beskeen et al text, the Practical Skills sections at the end of each Module in the Study Materials, the SAM online tutorial activities and the course discussion forums, as well as exploring and experimenting on your own.
Preamble
Dr Dorothy “Dodo” Little was extremely impressed with our computing firm’s – Kinkajou Technologies – development of the All Creatures Great and Small’s Database Management System (DBMS) utilising Microsoft Access 2007/2010/2013 (Assignment 1). The business has contracted our firm to assist in setting up more of the business’s various computer-based information systems.
The next computer-based information system that the business is interested in is a Decision Support System (DSS) utilising Microsoft Excel 2007/2010/2013. The DSS will be used to analyse sales trends for the business to determine future courses of action for the business.
Dr Dorothy “Dodo” Little would like the information in the Database Management System (DBMS) (Assignment 1) imported into Microsoft Excel 2007/2010/2013 so that the information can be summarised as a report and some future analysis of sales trends performed. The suppliers used by the business, source items from either Netherlands (NL) or Cayman Islands (KY). They allow the business to select from either of these two regions on an ad hoc basic depending on the most favourable exchange rate at the time.
Dr Dorothy “Dodo” Little has noted that a number of the business’s competitors are providing a discount to customers who place large orders. The business would like to see what affect adopting a similar policy would have on the business. The business has also noted a growing number of online businesses are starting to provide free freight delivery as a way of encouraging more online business; the business would like to run a number of scenarios based on potential Mark-up and Freight options to ascertain the best combination for the business if they were to adopt this policy too.
All phases in this project must be developed with professionalism and user-friendliness in mind.

karledwards.com/poster-gallery/, Karl Edwards Studios.
Decision Support System Design
Mrs Hyacinth Macaw, your manager, has set up the following tasks for you to complete for this phase of the project:
1. Create a Spreadsheet and import the four (4) Access 2007/2010/2013 Tables into four (4) Worksheets
2. Data Validation Check
3. Create an Index Worksheet
4. Create a Data Input Worksheet Template for later use
5. Create a Calculations Worksheet Template for later use
6. Create Name Ranges for the Customers, Items, and Suppliers data
7. Create a Report Worksheet and set up the column headings
8. Modify the Report Worksheet by Cell Referencing all the Orders Table data
9. Modify the Report Worksheet by using VLOOKUP to get Customer, Item and Supplier data
10. Modify the Data Input Worksheet to include extra data needed for tasks 11 to 15
11. Modify the Report Worksheet by using a Nested IF to calculate Cost Price (AU)
12. Modify the Report Worksheet by using a Nested IF to calculate Selling Price
13. Modify the Report Worksheet by using a Nested IF to calculate Freight Cost
14. Modify the Report Worksheet by using a AND / IF to calculate Item Discount
15. Modify the Report Worksheet by using simple formulas to find Purchases and Sales, and Modify the Report Worksheet by using a formula to calculate the Order Discount
16. Modify the Data Input Worksheet to include extra data needed for tasks 18 to 22
17. Modify the Calculations Worksheet by using simple formulas
18. Modify the Data Input Worksheet by Cell Referencing all the Calculations data
19. Create eight (8) Scenarios on the Data Input Worksheet
20. Create a Scenario Summary of the eight (8) Scenarios
21. Create an Documentation Worksheet
22. Create an Analytical Essay to describe the findings made using the Spreadsheet
Task 1: Create and Import
Open a single new Excel 2007/2010/2013 spreadsheet and name the file – ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number]’ (eg. genrichr_0050051005_CIS5100_assign2.xlsx).
Import the following four (4) database tables from your Assignment 1 Microsoft Access 2007/2010/2013 Database File and into Microsoft Excel 2007/2010/2013 (tblCustomers, tblItems, tblSuppliers, tblOrders). The easiest and quickest way to import data from Access 2007/2010/2013 into Excel 2007/2010/2013 is by using the “Import From Access” Wizard. The following steps will assist you with this process:
1) Select the first unused tab at the bottom of the Spreadsheet, right click on it and rename it “CustomersTable”.

2) Put a heading at the top of the worksheet in cell A1 called “Customers Table”.
3) Go to the Data Icon Ribbon (see below)

4) Click on the From Access option in the Get External Data icon area.
5) In the Get External Data – From Access wizard popup, browse to find your Assignment 1 Access Database file and select the – then click Open.
6) In the Select Table wizard popup, select tblCustomers – click OK.
7) In the Import Data wizard popup, select Table and Existing Worksheet $A$3 as the location to Import the place to put the data.
8) Left click anywhere on the imported data in worksheet then go to the Design Icon Ribbon and select Convert to Range then click OK.
9) Check that the data has correctly been imported correctly into this worksheet.
10) Modify the layout of the data to a professional level of presentation, making sure that the headings are in English (Customer ID not CustID).
Use bold, italics, font size, font colours, shading, lines and borders.
Repeat the above 10 steps for the rest of the Access Database tables naming each worksheet as follows:
Database Table Worksheet Name Worksheet Title (Cell A1)
tblItems ItemsTable Items Table
tblSuppliers SuppliersTable Suppliers Table
tblOrders OrdersTable Orders Table
Task 2: Data Validation Check
Check the imported data in the CustomersTable, ItemsTable, SuppliersTable and OrdersTable to ensure that:
1. The column headings are displayed correctly
2. The content of each column displays in a format that appears valid for that type of data (apply appropriate formatting if required).
3. The content of each column contains complete and accurate data values (eg. Phone numbers are not truncated).
4. The content of each column contains reasonable data values for the use of this business.
If you discover that the data imported in any of your 4 table worksheets contains missing or inaccurate values, please contact the CIS5100 course team immediately. You will be issued with a new copy of the Assignment 1 Access 2007/2010/2013 Database file (containing the 4 Database Tables) to restart Task 1.
Task 3: Index Worksheet
Add a worksheet labelled Index before the four tables from Task 1. Put a heading at the top of the worksheet in cell A1 called Index Worksheet. Ensure that it contains all the recommended data for this worksheet listed in Appendix 7 of the Study Materials – Spreadsheet design considerations.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 4: Data Input Worksheet Template
Add a worksheet labelled DataInput after the Index worksheet from Task 2 (but before the four tables from Task 1) that conforms to Appendix 7 of the Study Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Data Input Worksheet and then input the following template in the exact cells shown below onto this worksheet:
A B C D
3 Changing Cells:
4 Recommended MarkUp Type [Insert Markup Type here]
5 Recommended Freight Type [Insert Freight Type here]
6 Store Recommended MarkUp % [Insert Standard MarkUp % here]
7 Recommended Exchange Rate Type [Insert Exchange Rate Type here]
8 Exchange Rate (NL to AU) [Insert NL to AU Exchange Rate here]
9 Exchange Rate (KY to AU) [Insert KY to AU Exchange Rate here]
10
11 Quarterly Income:
12 Total Sales [Insert Cell Reference here]
13
14 Quarterly Fixed Expenses:
15 Bank Charges [Insert Bank Charges Expense here]
16 Electricity Expenses [Insert Electricity Expense here]
17 Freight Inwards Expenses [Insert Freight Inwards Expense here]
18 Internet Expenses [Insert Internet Expense here]
19 Telephone Expenses [Insert Telephone Expense here]
20 Wages Expenses [Insert Wages Expense here]
21
22 Total Quarterly Fixed Expenses [Insert Cell Reference here]
23
24 Quarterly Variable Expenses:
25 Total Purchases Expenses [Insert Cell Reference here]
26 Total Freight Outwards Expenses [Insert Cell Reference here]
27
28 Total Quarterly Variable Expenses [Insert Cell Reference here]
29
30 Total Profit: [Insert Cell Reference here]
31 Total Discount for Orders: [Insert Cell Reference here]
32 No. Orders Discount Applied: [Insert Cell Reference here]
* This template will be modified with correct number, formula and function in tasks 10 onwards.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 5: Calculations Worksheet Template
Add a worksheet labelled Calculations after the DataInput worksheet from Task 4 (but before the four tables from Task 1) that conforms to Appendix 7 of the Study Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Calculations Worksheet and then input the following template in the exact cells shown below onto this worksheet:
A B C D
3 Quarterly Income
4 Total Sales: [Insert Formula here]
5
6 Quarterly Expenses
7 Total Quarterly Fixed Expenses: [Insert Formula here]
8
9 Total Quarterly Variable Expenses
10 Total Purchases Expenses [Insert Formula here]
11 Total Freight Outwards Expenses [Insert Formula here]
12
13 Total Quarterly Variable Expenses: [Insert Formula here]
14
15 Total Profit: [Insert Formula here]
16 Total Discount for Orders: [Insert Formula here]
17 No. Orders Discount Applied: [Insert Formula here]
* This template will be modified with correct number, formula and function in tasks 10 onwards.
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 6: Name Ranges
On the CustomersTable, ItemsTable and SuppliersTable worksheets set the following Cell Range Names:
• Cust – on all the data (not headings) in the CustomersTable worksheet
• Itms – on all the data (not headings) in the ItemsTable worksheet
• Supp – on all the data (not headings) in the SuppliersTable worksheet
Note: You must only create the three name ranges listed in this task, any other name ranges used may result in loss of marks.

Task 7: Report Worksheet Headings
Add a worksheet labelled Report after the Calculations worksheet from Task 5 (but before the four tables from Task 1) that conforms to Appendix 7 of the Study Materials – Spreadsheet design considerations. Put a heading at the top of the worksheet in cell A1 called Report Worksheet and then type the following column headings, starting in cell A3:
• Customer ID, Title, Family Name, Given Names, Address, City, State, Postcode, Distance (km), Item ID, Type, Description, Colour, Size, Freight Weight (Kg), Supplier ID, Supplier Name, Supplier Recommended Markup (%), Order Date, Order Qty, Cost Price (NL), Cost Price (KY), Cost Price (AU), Selling Price, Purchases, Item Discount, Sales, Freight Cost, Order Discount.
Modify the Report worksheets to a professional level of presentation, making sure that the headings are in English (Customer ID not CustID). Use bold, italics, font size, font colours, shading, lines and borders.
Task 8: Report Worksheet Cell Reference
On the Report worksheet, Use the Cell References formula, to obtain all 1000 rows of data from the OrdersTable worksheet for the following:
• Customer ID, Item ID, Order Date, Order Qty.
(For example, type =OrdersTable!A4 to reference data in cell A4 of the OrdersTable worksheet.)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Modify the Summary worksheets to a professional level of presentation, making sure that the data is formatted correctly.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column.
Task 9: Report Worksheet VLOOKUP
On the Report worksheet use the VLOOKUP function with the Cell Range Names (Task 2), obtain all 1000 rows of data from the CustomersTable, ItemsTable and SuppliersTable worksheets for the following:
• Customers Worksheet:
o Title, Family Name, Given Names, Address, City, State, Postcode, Freight Distance (Km)
• Items Worksheet:
o Type, Description, Colour, Size, Freight Weight (Kg), Supplier ID, Cost Price (NL),
Cost Price (KY)
• Suppliers Worksheet:
o Supplier Name, Recommended Markup (%)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
See the Beskeen Excel Unit H and the Videos provided in the Course Content section for more details on creating VLOOKUP functions
Task 10: Modify Data Input Worksheet
On the DataInput worksheet perform the following:
• type Store into the cell containing the phrase: [Insert Markup Type here],
• type 112.5% into the cell containing the phrase: [Insert Standard MarkUp here],
• type NL into the cell containing the phrase: [Insert Exchange Rate Type here],
• type 1.528538 into the cell containing the phrase: [Insert NL to AU Exchange Rate here],
• type 1.700735 into the cell containing the phrase: [Insert KY to AU Exchange Rate here].
Task 11: Report Worksheet Cost Price (AU) Nested IF
On the Report worksheet:
1. Develop an IF function using the new Recommended Exchange Rate Type value (from the DataInput worksheet to calculate the Cost Price (AU) (in the Cost Price (AU) column) using the following criteria:
• If the Exchange Rate Type is NL then the Cost Price (AU) is calculated by multiplying the Cost Price (NL) by the Exchange Rate (NL to AU) cell on the DataInput worksheet.
Hint:
Cost Price (NL) x Exchange Rate (NL to AU)
• If the Exchange Rate Type is KY then the Cost Price (AU) is calculated by multiplying the Cost Price (KY) by the Exchange Rate (KY to AU) cell on the DataInput worksheet.
Hint:
Cost Price (KY) x Exchange Rate (KY to AU)
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Cost Price (AU) IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type KY into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) have changed.
• On the DataInput worksheet, type GIGO into the Exchange Rate Type cell.
• Go to the Report worksheet and observe whether the Cost Price (AU) now displays an error message.
Task 12: Report Worksheet Selling Price Nested IF
On the Report worksheet:
1. Develop an IF function using the new Recommended MarkUp Type value (from the DataInput worksheet) to calculate the Selling Price (in the Selling Price column) using the following criteria:
• If the MarkUp Type is Store then the Selling Price is calculated by increasing Cost Price by the Store’s Recommended MarkUp % from the DataInput worksheet
Hint:
Cost Price (AU) + Cost Price (AU) x Store Recommended MarkUp
• If the MarkUp Type is Supplier then the Selling Price is calculated by increasing Cost Price by the Supplier’s Recommended MarkUp
Hint:
Cost Price (AU) + Cost Price (AU) x Supplier Recommended MarkUp
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Selling Price IF function, perform the following two tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type Supplier into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices have changed.
• On the DataInput worksheet, type GIGO into the MarkUp Type cell.
• Go to the Report worksheet and observe whether the Selling Prices now displays an error message.
Task 13: Report Worksheet Freight Cost Nested IF
1. On the DataInput worksheet, type James Herriot Freight into the cell containing the phrase: [Insert Freight Type here].
2. On the Report worksheet develop an IF function using the new Recommended Freight Type value (from the DataInput worksheet to calculate the Freight Cost (in the Freight Cost column) using the following criteria:
• If the Freight Type is James Herriot Freight then the Freight Cost is calculated a quarter of a cent ($0.0025) per kilometre (Distance) and a seventy-five cents ($0.75) per kilogram of the item’s freight weight per item ordered (Order Qty).
Hint:
($0.0025 x Distance + $0.75 x Item Weight) x OrderQty
• If the Freight Type is Siegfried Farnon Transport then the Freight Cost is calculated at a dollar and fifty cents ($1.50) for the first kilograms (1.00 kg) and then at fifty cents ($0.50) per kilogram of the item’s freight weight over one kilograms (1.00 kg) per item ordered (Order Qty).
Hint:
($1.50 + IF(Item Weight 1.00 kg, (Item Weight – 1.00kg) x $0.50, 0)) x OrderQty
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
3. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF function and error checking (Beskeen Excel Unit E) to avoid incorrect results due to typing mistakes.

Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these Nested IF functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
4. Test the IF function: Once you have completed the Freight Cost IF function, perform the following three tests on it to ensure that it is working correctly:
• On the DataInput worksheet, type Siegfried Farnon Transport into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs have changed.
• On the DataInput worksheet, type GIGO into the Freight Type cell.
• Go to the Report worksheet and observe whether the Freight Costs now displays an error message.
Task 14: Report Worksheet IF / AND: Item Discount
1. On the Report worksheet develop an IF / AND function to calculate the amount of Item Discount given to an individual item on an order (in the Item Discount column) using the following criteria:
• If the OrderQty is greater than or equal to five (5) of the same item in any single order AND the Selling Price for that item is greater than $50.00, then the Item Discount is calculated at 7.5% of the Selling Price for that item, otherwise the Item Discount is zero.
Hint:
=IF (AND (OrderQty = 5, Selling Price $50), Selling Price x 7.5%, 0)
2. Ensure that you include rounding (to 2 decimal places – Beskeen Excel Unit B) into each calculation in your IF / AND function.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
Also do not include any unit measures such as $, kg or km in the IF function as this will result in a #VALUE error message. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
You must remove any reference to the prefix Report! from these IF / AND functions to reduce complexity and redundancy of code.
See the Beskeen Excel Unit E and the Videos provided in the Course Content section for more details on creating IF functions
3. Test the IF function: Once you have completed the Item Discount IF / AND function and filled it down the column, review the values to ensure that it is working correctly in the following situations:
• OrderQty is less than five (5) and Selling Price is less than or equal to $50, should result in $0.00 Item Discount.
• OrderQty is less than five (5) and Selling Price is greater than $50, should result in $0.00 Item Discount.
• OrderQty is greater than or equal to five (5) and Selling Price is less than or equal to $50, should result in $0.00 Item Discount.
• OrderQty is greater than or equal to five (5) and Selling Price is greater than $50, should result in an Item Discount.
Task 15: Report Worksheet Purchases, Sales and Order Discount Formulas
On the Report worksheet calculate the following three simple formulas:
1. Purchases by multiplying Order Qty with Cost Price (AU).
2. Sales by multiplying Order Qty by the difference of Selling Price less the Item Discount amount.
Hint:
=(Selling Price – Item Discount) x Order Qty
3. Order Discount by multiplying Order Qty with Item Discount.
Note: All formulas must be designed to be typed once at the top of each column and copied down to the remaining cells in the column – Beskeen Excel Unit B.
You must remove any reference to the prefix Report! from these formulae to reduce complexity and redundancy of code. Brackets must only be used as indicated in the hints given above, any incorrect or extraneous usage of brackets may result in loss of marks.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Task 16: Modify Data Input Worksheet
On the DataInput worksheet:
1. Replace the phrase “[Insert Bank Charges Expenses here]” in cell D15 with $2,830.46
2. Replace the phrase “[Insert Electricity Expenses here]” in cell D16 with $4,694.57
3. Replace the phrase “ [Insert Freight Inwards Expense here] ” in cell D17 with $80,721.94
4. Replace the phrase “ [Insert Internet Expense here] ” in cell D18 with $3,503.57
5. Replace the phrase “[Insert Telephone Expenses here]” in cell D19 with $4,882.58
6. Replace the phrase “[Insert Wages Expenses here]” in cell D20 with $44,148.76
Task 17: Calculations Worksheet Formulas
On the Calculations worksheet calculate the following four simple formula:
1. Replace the phrase in D4 “[Insert Formula here]” with a function to calculate the Total Sales by adding all the Sales in the Sales column on the Reports worksheet.
2. Replace the phrase in D7 “[Insert Formula here]” with a function to calculate the Total Quarterly Fixed Expenses by adding all the Quarterly Fixed Expenses on the DataInput worksheet.
3. Replace the phrase in D10 “[Insert Formula here]” with a function to calculate the Total Purchases by adding all the Purchases in the Purchases column on the Reports worksheet.
4. Replace the phrase in D11 “[Insert Formula here]” with a function to calculate the Total Freight by adding all the Freight Costs in the Freight Cost column on the Reports worksheet.
5. Replace the phrase in D13 “[Insert Formula here]” with a formula to calculate the Total Quarterly Variable Expenses by adding all the Quarterly Variable Expenses on the Calculations worksheet.
6. Replace the phrase in D15 “[Insert Formula here]” with a formula to calculate the Total Profit by subtracting the Total Quarterly Fixed and Total Quarterly Variable Expenses from the Total Sales on the Calculations worksheet.
7. Replace the phrase in D16 “[Insert Formula here]” with a function to calculate the Total Discount for Orders by using the SUMIF() function to add up all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.
8. Replace the phrase in D17 “[Insert Formula here]” with a function to calculate the Number of Orders where a Discount was Applied by using the COUNTIF() function to count all cells with an Order Discount greater than 0 in the Order Discount column on the Reports worksheet.
Hint: For details on SUMIF and COUNTIF usage see Beskeen Unit E.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Task 18: Data Input Cell References
On the DataInput worksheet:
1. Replace the phrase “[Insert Cell Reference Here]” in cell D12 with a cell reference to the Total Sales amount on the Calculations worksheet.
2. Replace the phrase “[Insert Cell Reference Here]” in cell D22 with a cell reference to the Total Quarterly Fixed Expenses amount on the Calculations worksheet.
3. Replace the phrase “[Insert Cell Reference Here]” in cell D25 with a cell reference to the Total Purchases Expenses amount on the Calculations worksheet.
4. Replace the phrase “[Insert Cell Reference Here]” in cell D26 with a cell reference to the Total Freight Outwards Expenses amount on the Calculations worksheet.
5. Replace the phrase “[Insert Cell Reference Here]” in cell D28 with a cell reference to the Total Quarterly Variable Expenses amount on the Calculations worksheet.
6. Replace the phrase “[Insert Cell Reference Here]” in cell D30 with a cell reference to the Total Profit amount on the Calculations worksheet.
7. Replace the phrase “[Insert Cell Reference Here]” in cell D31 with a cell reference to the Total Discount for Orders amount on the Calculations worksheet.
8. Replace the phrase “[Insert Cell Reference Here]” in cell D32 with a cell reference to the No. Orders Discount Applied amount on the Calculations worksheet.
Note: Ensure that you only use cell referencing for the Totals data.
Do not post formulas to the StudyDesk Forums; it may result in academic misconduct.
Modify the CustomerTable, ItemTable, OrdersTable, SuppliersTable, DataInput, Calculations and Report worksheets to a professional level of presentation, making sure that the data is formatted correctly. Use bold, italics, font size, font colours, shading, lines and borders.
Task 19: Scenarios
Using the Scenario Manager in Excel create and check the following eight (8) Scenarios using the Changing Cells of D4, D5 and D7 on the DataInput worksheet:
Scenario Markup Type Freight Type Exchange Rate Type
1 Store James Herriot Freight NL
2 Store James Herriot Freight KY
3 Store Siegfried Farnon Transport NL
4 Store Siegfried Farnon Transport KY
5 Supplier James Herriot Freight NL
6 Supplier James Herriot Freight KY
7 Supplier Siegfried Farnon Transport NL
8 Supplier Siegfried Farnon Transport KY
Note: Ensure you have a suitable scenario name for each scenario, eg. Scenario 1, Scenario 2 …
See the Beskeen Excel Unit K and the Videos provided in the Course Content section for more details on creating Scenarios.
Task 20: Scenario Summary
Using the Scenario Manager in Excel create a Scenario Summary worksheet from the DataInput worksheet based on the eight (8) Scenarios from Task 20 and focusing on the Result cells D12, D22, D25, D26, D28, D30, D31 and D32 on the DataInput worksheet.
Place the Scenario Summary worksheet between the Calculations and Report worksheets.
Note: Format your Scenario Summary worksheet to look professional as follows:
• Modify the heading of the Scenario Summary
• Remove the Current Value and Notes
• Label the Changing Cells and Results Cells
See the Beskeen Excel Unit K and the Videos provided in the Course Content section for more details on creating Scenarios.
Task 21: Documentation Worksheet
Add a Documentation worksheet after the four tables from Task 1. Put a heading at the top of the worksheet in cell A1 called Documentation. Ensure that contains all the recommended information for this worksheet listed in Appendix 7 of the Study Materials – Spreadsheet design considerations.
The Documentation Worksheet must demonstrate the following:
• A statement outlining the purpose of the Spreadsheet:
Purpose should outline why the Spreadsheet was created including – discussion about the Markup Type, Exchange Rate and Freight Type.
• A statement about the protection level that should be used on each Worksheet.
Protection should look at all 10 Worksheets and outline whether each sheet should contain protection and why.
DO NOT actually apply protection to your Spreadsheet – this will result in it being unable to be marked.
• A statement about how the user can access and use the Worksheets.
User Notes should provide a step by step guide for a new user to use the Spreadsheet from changing the values on the DataInput Worksheet to observing the outcome of these changes on both DataInput and Report Worksheets.
• A statement about what calculations have been used in the development of this Spreadsheet.
Calculations Notes should provide a brief description of each calculation found on the Calculations and Report Worksheets (does not need to discuss individual Cell References and VLOOKUPs – these can be discussed generally as a single calculation type).
Modify the layout of the data to a professional level of presentation. Use bold, italics, font size, font colours, shading, lines and borders.
Task 22: Analytical Essay
Mrs Hyacinth Macaw has asked you to develop an analytical essay (between 750 and 1000 words in length) to the client, Dr Dorothy “Dodo” Little outlining the major issues that the Decision Support System’s results have highlighted. Create a Word 2007/2010/2013 Document and name it ‘[lastname] [initial] _ [student number] _ [course code] _ [assignment number’
(eg. genrichr_0050051005_CIS5100_assign2.docx).
Essays have a particular structure – An introduction, a body (where you write your answer in a number of paragraphs, usually one for each idea or topic) and a conclusion. The conclusion is where you sum up your ‘argument’. Essays normally do not have headings.
The information at the following URL may be useful:
http://www.usq.edu.au/learningcentre/assignment-skills/writing-assignments/essay-writing
The body of your essay should consider the following issues:
• Define what a Decision Support System is.
• Explain why a Decision Support System is the appropriate tool for this project.
• From the results of the Decision Support System results discuss the following (keeping in mind the information provided in the preamble on page 2):
1. Which Mark-up Type would be most appropriate for the business? Why?
2. How would the choice of the Mark-up Type impact on the customer’s decision to purchase from the company? Why?
3. What would be the impact on the business’s profit if the plan to provide a discount to large orders was implemented? Why?
4. Which Recommended Freight Type would be most appropriate for the business? Why?
5. What would be the impact that the different Recommended Freight Types would have on the business’s profit if the cost was transferred to the business instead of the customer (as discussed in the preamble)? Why?
6. Which country would be most appropriate for the business to import from at the moment? Why?
7. What issues could cause the business to rethink its choice of country of import? Why?
The essay should be using a proportional font (eg. Arial, Times New Roman etc.), with a font size of 11 or 12, and be laid out using 1 ½ line spacing.
Note: It is expected that you will use the Baltzan et al and Beskeen et al textbooks to answer the topics Mrs Hyacinth Macaw has given you for the essay, as well as reputable online sources of information. You need to include a brief Bibliography formatted using the Harvard AGPS style on a separate page (see the following USQ website for referencing help: http://www.usq.edu.au/library/referencing/harvard-agps-referencing-guide.
Submission Guidelines
Attach the Excel 2007/2010/2013 & Word 2007/2010/2013 files using the naming convention below, to your online assignment submission in the Assignment 1 area on the CIS5100 StudyDesk before midnight Australian Eastern Standard Time (AEST) on the day the assignment is due.
1. [lastname] [initial] _ [student number] _ [course code] _ assign2.xlsx (eg. genrichr_0050051005_CIS5100_assign2.xlsx).
2. [lastname] [initial] _ [student number] _ [course code] _ assign2.docx (eg. genrichr_0050051005_CIS5100_assign2.docx).
Note: Simply changing the file extension to .xlsx or .docx on an Excel 2003 or Word 2003 file will not result in a suitable submission. If the assignment files cannot be opened by the marker, it may be treated as late until a suitable replacement is received.
Upon completion of the submission process, check your uConnect email account for an automatically generated confirmation email (if you do not have an email account, print out the Submission Complete screen before exiting the Submission System). You must check that the file name and file size are listed correctly, if there is a problem with either, please email the course leader immediately.
If you have difficulties submitting through the StudyDesk Assignments submission tool, please review the Student Instructions document listed also on the CIS5100 StudyDesk. As a last resort only, email the course leader for instructions on an alternative course of action.
Please note that:
• The following is the USQ Assessment – Assignment (Late Submission) and Compassionate and Compelling Circumstances procedure that relate to Extensions and Late Assignments. They can be found under the following links:
? Assessment – Assignment (Late Submission) Procedure: http://policy.usq.edu.au/documents.php?id=14749PL#4.2_Assignments
? Assessment of Compassionate and Compelling Circumstances Procedures: http://policy.usq.edu.au/documents.php?id=131150PL
• Students seeking extensions for any Assignment work must provide appropriate documentation to support their request before the due date of the assignment (see points 4.3 and 4.4 in the Assessment of Compassionate and Compelling Circumstances Procedures above to see what is considered as Compassionate and Compelling reason for an extension and the level of documentation that will be needed).
• An Assignment submitted after the due date without an approved extension of time will be penalised. The penalty for late submission is a reduction by five percent (5%) of the maximum Mark applicable for the Assignment, for each University Business Day or part Business Day that the Assignment is late. An Assignment submitted more than ten (10) University Business Days after the due date will have a Mark of zero recorded for that Assignment.
? The StudyDesk Assignments submission toolwill accept late assignments up until 23:55pm on the 10th University Business Day after the due date.

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

You are a first year RN and you have been working in the medical ward for the past four months.



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

1. You are a first year RN and you have been working in the medical ward for the past four months. Your friend David from University has also started on the ward about eight weeks ago. It is time for your meal break and you had negotiated with the shift coordinator to have your meal break at the same time as your friend David. When you go to collect your friend (for a meal break) you notice that he is giving an Intravenous medication to a patient but from your experience of administering this medication you know that it requires further dilution prior to being administered intravenously. David has administered half of the medication already as you approach him. You explain to David that he needs to stop administering the drug and why. David tells you he has checked the medication with an RN and she was happy so continues administering the medication. The patient asks David if he knows what he is doing and he says yes. You check with another RN and discover that you were indeed right.
Instructions
Section 1: Student is required to describe all aspects of the critical incident including what should have happened/correct procedure.
Section2: Analyse what may have caused this situation to occur – identify all the players in the situation and their role. This requires the student to have critical awareness of all of the information and bring it together (synthesise) in a way that demonstrates the depth of the understanding about the incident without being too wordy
Section 3: Describe how you are to respond to the incident. Describe the action you must take
The essay will need to have a minimum of 10 recent (5 years or less) peer reviewed articles or credible (government/lead organisation) websites. You should use the literature to support your ideas and response to the critical incident. Please ensure that you follow the school of Nursing & Midwifery referencing style.
Please identify in the introduction which option/scenario you have chosen. The entire essay must be no longer than 3000 words including in text references and tables(but not the reference list).



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

HI5001 Accounting for Business Decisions (T1, 2016)



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Melbourne
Group Assignment (100 points 30% of Final Mark)
The assignment aims to develop an understanding of financial statements structure and their use in decision-making. The task is to choose a publicly listed company (see list on page 4) from the Australian Stock Exchange (ASX), analyse the latest financial statements and come up with a conclusion with supporting data or information whether to invest in the company or not.
In order to avoid duplication of companies being examined, groups are required to inform the lecturer the selected company before commencing.
This group project encompasses several learning objectives, each of which comprises a part of the students’ task. However, it is well encouraged to include any additional information that students may think will be useful in conducting financial statements analysis of the selected company.
General Rules & Requirements:
The Business Report should be prepared by a group with a maximum of three (3). Reports must be confined to a maximum of 3,000 words. As a minimum the report should have the following:
A. Title page
B. Executive Summary
C. Table of Contents
D. Introduction
E. Body
F. Conclusion
G. Reference List
H. Appendix
Font type should be Arial (size 11), paragraph spacing should be 1.5.
Note:
Any additional material from external sources that you “copy & paste” into your report should be appropriately referenced and is NOT included in the word limit.
Financial Statement Analysis
Part 1
Provide an executive summary which will include overview of subject matter, methods of analysis, findings and recommendations.
Part 2
Use the latest annual report. The group will need to review the major sections of this report in order to be familiar with the content of each of the financial statements and appropriate footnotes.
Review the balance sheet of the company and indicate the total amount of the following:
a) Current assets
b) Non-current assets
c) Current liabilities
d) Non-current liabilities
e) Stockholder’s equity
Compare the above figures with the previous year and compute the percentage increase or decrease and comment on the comparative financial condition of the company.
Part 3
Review the income statement and indicate the following:
a) Total (operating) revenues
b) Cost of Goods Sold (if relevant)
c) Total expenses (before income taxes)
d) Any non-operating (or extraordinary) gains and losses
e) Earnings per common share
Compare the above figures with the previous year and compute the percentage increase or decrease and comment on the comparative financial operation of the company.
Part 4
Review the statement of cash flows for the most recent year and indicate the following:
a) Net cash inflow (outflow) from operating activities
b) Net cash inflow (outflow) from financing activities
c) Net cash inflow (outflow) from investing activities
d) Net increase (decrease) in cash during the year
Analyse the Cash Flow Statements for the last 2 years and comment on the cash position of the company.
Part 5
Review the stockholders’ equity section in your chosen company’s most recent yearend balance sheet and compare that with the previous year-end balance sheet. Compare percentage increase or decrease.
List the stockholders’ equity account balances and number of outstanding shares from these two balance sheets and compute the increase or decrease for each during this past year.
Note:
To complete the submission process, upload onto Safeassign SelfCheck Link, Final Submission Link and finally the hardcopy in the box located in the library. Make sure that the group member who submitted the softcopies should indicate the name and student number. Please do not upload more than one copy. In case your percentage matching is unacceptable, send an email to the lecturer requesting that the submission be deleted from the Safeassign.
Due Date: Friday, 27 May, 2016.
A-CAP RESOURCES LIMITED ACB
Energy
A1 CONSOLIDATED GOLD LIMITED AYC
Materials
ABILENE OIL AND GAS LIMITED ABL
Energy
ABM RESOURCES NL ABU
Materials
ACACIA COAL LIMITED AJC
Energy
ACADEMIES AUSTRALASIA GROUP LIMITED AKG
Consumer Services
ACCENT RESOURCES NL ACS
Materials
ACRUX LIMITED ACR
Pharmaceuticals & Biotechnology
ACTINOGEN MEDICAL LIMITED ACW
Pharmaceuticals & Biotechnology
ACTIVEX LIMITED AIV
Materials
ADAIRS LIMITED ADH
Retailing
ADAVALE RESOURCES LIMITED ADD
Energy
ADCORP AUSTRALIA LIMITED AAU
Media
ADELAIDE BRIGHTON LIMITED ABC
Materials
ADELAIDE RESOURCES LIMITED ADN
Materials
ADG GLOBAL SUPPLY LIMITED. ADQ
Capital Goods
ADHERIUM LIMITED ADR
Health Care Equipment & Services
ADITYA BIRLA MINERALS LIMITED ABY
Materials
ADMEDUS LTD AHZ
Health Care Equipment & Services
ADMIRALTY RESOURCES NL. ADY
Materials
ADVANCED BRAKING TECHNOLOGY LTD ABV
Automobiles & Components
ADX ENERGY LTD ADX
Energy
AEON METALS LIMITED. AML
Materials
AERIS ENVIRONMENTAL LTD AEI
Commercial Services & Supplies
AERIS RESOURCES LIMITED AIS
Materials
AFRICAN ENERGY RESOURCES LIMITED AFR
Energy
AFT PHARMACEUTICALS LIMITED AFP
Pharmaceuticals & Biotechnology
AGENIX LIMITED AGX
Pharmaceuticals & Biotechnology
AGL ENERGY LIMITED. AGL
Utilities
AGRIMIN LIMITED AMN
Materials
AGUIA RESOURCES LIMITED AGR
Materials
AHALIFE HOLDINGS LIMITED AHL
Retailing
AINSWORTH GAME TECHNOLOGY LIMITED AGI
Consumer Services
AIRXPANDERS, INC. AXP
Health Care Equipment & Services
ALACER GOLD CORP. AQG
Materials
ALARA RESOURCES LIMITED AUQ
Materials
ALCHEMIA LIMITED ACL
Pharmaceuticals & Biotechnology
ALCHEMY RESOURCES LIMITED ALY
Materials
ALCIDION GROUP LIMITED ALC
Health Care Equipment & Services
ALCOA INC. AAI
Materials
ALEXIUM INTERNATIONAL GROUP LIMITED AJX
Materials
ALGAE.TEC LIMITED AEB
Energy
ALICANTO MINERALS LIMITED AQI
Materials
ALICE QUEEN LIMITED AQX
Energy
ALKANE RESOURCES LIMITED ALK
Materials
ALLEGIANCE COAL LIMITED AHQ
Energy
ALLEGRA ORTHOPAEDICS LIMITED AMT
Health Care Equipment & Services
ALLIANCE RESOURCES LIMITED AGS
Materials
ALLIGATOR ENERGY LIMITED AGE
Energy
ALLOY RESOURCES LIMITED AYR
Materials
ALT RESOURCES LIMITED ARS
Materials
ALTECH CHEMICALS LTD ATC
Materials
ALTONA MINING LIMITED AOH
Materials
ALTURA MINING LIMITED AJM
Materials
ALUMINA LIMITED AWC
Materials
AMA GROUP LIMITED AMA
Retailing
AMAYSIM AUSTRALIA LIMITED AYS
Telecommunication Services
AMBERTECH LIMITED AMO
Technology Hardware & Equipment
AMBITION GROUP LIMITED AMB
Commercial Services & Supplies
AMCOR LIMITED AMC
Materials
AMERICAN PATRIOT OIL & GAS LIMITED AOW
Energy
AMEX RESOURCES LIMITED AXZ
Materials
AMP LIMITED AMP
Insurance
ANAECO LIMITED ANQ
Commercial Services & Supplies
ANALYTICA LIMITED ALT
Health Care Equipment & Services
ANATARA LIFESCIENCES LTD ANR
Pharmaceuticals & Biotechnology
ANCHOR RESOURCES LIMITED AHR
Materials
ANEKA TAMBANG (PERSERO) TBK (PT) ATM
Materials
ANGLO AUSTRALIAN RESOURCES NL AAR
Materials
ANGLOGOLD ASHANTI LIMITED AGG
Materials
ANOVA METALS LIMITED AWV
Materials
ANSELL LIMITED ANN
Health Care Equipment & Services
ANSON RESOURCES LIMITED ASN
Materials
ANTARES ENERGY LIMITED AZZ
Energy
ANTARES MINING LIMITED AWW
Materials
ANTARIA LIMITED ANO
Materials
ANTEO DIAGNOSTICS LIMITED ADO
Pharmaceuticals & Biotechnology
ANTILLES OIL AND GAS NL AVD
Energy
ANTIPA MINERALS LIMITED AZY
Materials
ANTISENSE THERAPEUTICS LIMITED ANP
Pharmaceuticals & Biotechnology
AP EAGERS LIMITED APE
Retailing
APA GROUP APA
Utilities
APAC COAL LIMITED AAL
Energy
APHRODITE GOLD LIMITED AQQ
Materials
APIAM ANIMAL HEALTH LIMITED AHX
Retailing
APN NEWS & MEDIA LIMITED APN
Media
APN OUTDOOR GROUP LIMITED APO
Media
APOLLO CONSOLIDATED LIMITED AOP
Materials
APOLLO MINERALS LIMITED AON
Materials
AQUAINT CAPITAL HOLDINGS LIMITED AQU
Consumer Services
AQUARIUS PLATINUM LIMITED AQP
Materials
AQUIS ENTERTAINMENT LIMITED AQS
Consumer Services
ARAFURA RESOURCES LIMITED ARU
Materials
ARB CORPORATION LIMITED. ARB
Automobiles & Components
ARC EXPLORATION LIMITED ARX
Materials
ARCHER EXPLORATION LIMITED AXE
Materials
ARDENT LEISURE GROUP AAD
Consumer Services
ARDENT RESOURCES LTD AWO
Materials
ARDIDEN LTD ADV
Materials
ARGENT MINERALS LIMITED ARD
Materials
ARGO EXPLORATION LIMITED AXT
Materials
ARGONAUT RESOURCES NL ARE
Materials
ARGOSY MINERALS LIMITED AGY
Materials
ARIADNE AUSTRALIA LIMITED ARA
Commercial Services & Supplies
ARISTOCRAT LEISURE LIMITED ALL
Consumer Services
ARK MINES LIMITED AHK
Materials
ARMOUR ENERGY LIMITED AJQ
Energy
AROWANA INTERNATIONAL LIMITED AWN
Commercial Services & Supplies
ARRIUM LIMITED ARI
Materials
ARROWHEAD RESOURCES LIMITED AR1
Materials
ARTEMIS RESOURCES LIMITED ARV
Materials
ARUMA RESOURCES LIMITED AAJ
Materials
ARUNTA RESOURCES LIMITED AJR
Materials
ASALEO CARE LIMITED AHY
Household & Personal Products
ASAPLUS RESOURCES LIMITED AJY
Materials
ASCIANO LIMITED AIO
Transportation
ASG GROUP LIMITED ASZ
Software & Services
ASHLEY SERVICES GROUP LIMITED ASH
Commercial Services & Supplies
ASIA PACIFIC DATA CENTRE GROUP AJD
Real Estate
ASIA PACIFIC DIGITAL LIMITED DIG
Media
ASIAN AMERICAN MEDICAL GROUP LIMITED AJJ
Health Care Equipment & Services
ASPERMONT LIMITED. ASP
Media
ASPIRE MINING LIMITED AKM
Materials
ASSEMBLEBAY LIMITED ASY
Energy
ASTIVITA LIMITED AIR
Capital Goods
ASTRO RESOURCES NL ARO
Materials
ASTRON CORPORATION LIMITED ATR
Materials
ATC ALLOYS LTD ATA
Materials
ATCOR MEDICAL HOLDINGS LIMITED ACG
Health Care Equipment & Services
ATHENA RESOURCES LIMITED AHN
Materials
ATLANTIC LIMITED ATI
Materials
ATLAS IRON LIMITED AGO
Materials
ATLAS PEARLS AND PERFUMES LTD ATP
Consumer Durables & Apparel
ATRUM COAL NL ATU
Materials
ATTILA RESOURCES LIMITED AYA
Materials
AUB GROUP LIMITED AUB
Insurance
AUCKLAND INTERNATIONAL AIRPORT LIMITED AIA
Transportation
AUDALIA RESOURCES LIMITED ACP
Materials
AUDIO PIXELS HOLDINGS LIMITED AKP
Consumer Durables & Apparel
AUGUR RESOURCES LIMITED AUK
Materials
AURA ENERGY LIMITED AEE
Energy
AURELIA METALS LIMITED AMI
Materials
AUROCH MINERALS NL AOU
Materials
AURORA MINERALS LIMITED ARM
Materials
AUS ASIA MINERALS LIMITED AQJ
Energy
AUS TIN MINING LTD ANW
Materials
AUSDRILL LIMITED ASL
Capital Goods
AUSENCO LIMITED AAX
Capital Goods
AUSGOLD LIMITED AUC
Materials
AUSMON RESOURCES LIMITED AOA
Materials
AUSNET SERVICES LIMITED AST
Utilities
AUSQUEST LIMITED AQD
Materials
AUSROC METALS LTD ARK
Materials
AUSTAL LIMITED ASB
Capital Goods
AUSTEX OIL LIMITED AOK
Energy
AUSTIN ENGINEERING LIMITED ANG
Capital Goods
AUSTIN EXPLORATION LIMITED AKK
Energy
AUSTOCK GROUP LIMITED ACK
Insurance
AUSTPAC RESOURCES NL APG
Materials
AUSTRAL GOLD LIMITED AGD
Materials
AUSTRALASIAN RESOURCES LIMITED ARH
Materials
AUSTRALIA NEW AGRIBUSINESS & CHEMICAL GROUP LTD ANB
Materials
AUSTRALIA UNITED MINING LIMITED AYM
Materials
AUSTRALIAN AGRICULTURAL COMPANY LIMITED. AAC
Food, Beverage & Tobacco
AUSTRALIAN AGRICULTURAL PROJECTS LIMITED AAP
Food & Staples Retailing
AUSTRALIAN BAUXITE LIMITED. ABX
Materials
AUSTRALIAN CAREERS NETWORK LIMITED ACO
Consumer Services
AUSTRALIAN DAIRY FARMS GROUP AHF
Food, Beverage & Tobacco
AUSTRALIAN MINES LIMITED AUZ
Materials
AUSTRALIAN NATURAL PROTEINS LIMITED AYB
Food, Beverage & Tobacco
AUSTRALIAN PACIFIC COAL LIMITED AQC
Materials
AUSTRALIAN PHARMACEUTICAL INDUSTRIES LIMITED API
Health Care Equipment & Services
AUSTRALIAN RENEWABLE FUELS LIMITED ARW
Energy
AUSTRALIAN VANADIUM LIMITED AVL
Materials
AUSTRALIAN VINTAGE LTD AVG
Food, Beverage & Tobacco
AUSTRALIAN WHISKY HOLDINGS LIMITED AWY
Food, Beverage & Tobacco
AUTOMOTIVE HOLDINGS GROUP LIMITED. AHG
Retailing
AVALON MINERALS LIMITED AVI
Materials
AVANCO RESOURCES LIMITED AVB
Materials
AVENIRA LIMITED AEV
Materials
AVEXA LIMITED AVX
Pharmaceuticals & Biotechnology
AVITA MEDICAL LTD AVH
Pharmaceuticals & Biotechnology
AVZ MINERALS LIMITED AVZ
Materials
AWE LIMITED AWE
Energy
AXIOM MINING LIMITED AVQ
Materials
AZONTO PETROLEUM LTD APY
Energy
AZUMAH RESOURCES LIMITED AZM
Materials
AZURE HEALTHCARE LIMITED AZV
Health Care Equipment & Services

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Santos shelves debt raising in oil price rout



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service
December 4, 2014Tweaking the money tap: Having postponed a debt raising, Santos will review its spending plans for next year.
Energy producer Santos has been forced to postpone a €500 million ($733 million) hybrid debt raising in Europe and will slash capital and
operating expenditure following a slump in oil prices below $US70 a barrel.
Chief financial officer Andrew Seaton said the company had decided to defer any hybrid issue until market conditions improve, noting the oil market had experienced volatility following the decision by the Organisation of Petroleum Exporting Countries not to cut output at a meeting in Vienna late last week.
Mr Seaton said Santos holds a -robust- funding position with $2 billion in available liquidity, but will review its spending plans for 2015. Santos already has outstanding hybrid capital securities in the European markets. But the yields on the securities have come under pressure after the company flagged plans to issue more securities as oil prices plunged.
The yield on the securities has spiked by an enormous 40 per cent in two trading sessions to almost 5 per cent from 3.5 per cent at the start of the month.
While the outright yield may appear to suggest a low cost of funds, the costs associated with converting the funds into Australian dollars and hedging the currency risk would have pushed the overall costs higher.
Santos could also be under pressure to protect its BBB+ Standard & Poor’s credit rating which is on negative outlook to reflect the
–commissioning risk of the company’s two LNG projects- .
….The lower oil prices, if they persist, would eat into a forecast jump in Santos’s cashflows from its two, big-ticket LNG projects, a venture in Papua New Guinea that started production earlier this year and the $US18.5 billion ($21.5 billion) GLNG project in Queensland set to
begin exports in the second half of 2015.
An earlier estimate by Santos that operating cash flows would double from 2013 to 2016 assumed oil prices of $US100 a barrel.
But consensus estimates for crude prices have been pared back, to $US90 a barrel, reducing the expected lift in Santos’s cash flows to
65 per cent by 2016.
Brent crude prices are currently much lower than that, at about $US69.
Source: http://www.smh.com.au/business/mining-and-resources/santos-shelves-debt-raising-in-oil-price-rout-20141204-
11zwxy.html#ixzz3ocFAswZA
a) Analyse Santos’ short term liquidity based on 2013 and 2014 financial figures. (5 marks)
b) What is a convertible bond and why is it a hybrid security? (3 marks)
c) In 2014 is Santos financing using predominantly long-term or short-term debt? Are they using predominantly direct or indirect debt financing? Why? What currency are they predominantly borrowing in? Refer to Source 1. (5 marks)
d) Analyse the asset management, debt management, profitability and market expectations for Santos in 2014 as compared to 2013. (Hint: Use financial and market data in your ratio calculations and make sure to interpret and analyse the output) (14 marks)
e) According to the Sources above what has happened to the yields on Santos hybrid securities (convertible bonds) in 2014-15? Why has this happened? How would it affect the price of its existing bonds today? (3 marks)

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

A health agency is taking a survey regarding the evaluation of all the hospitals in Melbourne to find out the statistical calculation and analyze the attributes of the data



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

ECO502 Decision Making Semester 1, 2016
Assessment 3
Problem Solving Task 2
Maximum marks: 50
Due date: 0900 Tuesday May 31, 2016 (week 13)
This assessment relates to problem solving task 2 – solving a set of given problems through the application of statistical and other decision making techniques.
Please answer all three questions.
Background
A health agency is taking a survey regarding the evaluation of all the hospitals in Melbourne to find out the statistical calculation and analyze the attributes of the data. The agency needs a report that can analyze the number of admissions, type of control and type of service and other factors. They focus on the service provided by each hospital whether it is for non-government, non-federal, for profit, federal government and so on.
For analytical purposes a random sample of 60 data is generated out of 300 population data and the statistical summary of the sample data is tabulated in Table 1.
Table 1 Statistical Summary
Variable Mean Median Standard deviation Minimum Maximum Range P value Count
Admissions 6959.00 4636.50 6995.56 441.00 37375.00 2668.50 0.168 60
Your overall task is to investigate the effect of various variables on the number of admissions in Melbourne hospitals using various descriptive analyses which is extremely helpful to formulate a conclusion.
To assist with your investigation, you are required to answer questions 1 and 2 below.
Question 1 [15 marks]
a) For a series of random samples of 60, are the mean values of these random samples normally distributed? Explain
[3 marks]
b) Calculate the standard error of the mean and explain the meaning of this value.
[2 marks]
c) Determine the 95% confidence interval and explain its meaning in the context of the overall problem.
[4 marks]
d) What is the probability that a sample of 60 hospitals selected at random in the Melbourne area will have a mean greater than 7000.00 admissions?
[4 marks]
e) If the admissions times were more variable, what effect would this have on the confidence interval?
[2 marks]
Question 2 [10 marks]
Assume that the average admission for all hospitals in Melbourne is 7500. Conduct a statistical hypothesis test to determine if the admission of hospitals in Melbourne is significantly different from the average admission 6959. Mention any assumptions and include relevant hypotheses and report the results and conclusion in the conventional manner.
a) Write down both the null and alternative hypotheses
[1 marks]
b) Carry out the t test and report the p-value, and the test statistic
[4 marks]
c) Write an appropriate conclusion in the context of the problem.
[2 marks]
Based on your answers to questions 1 and 2 please write a report of the effect of various variables on the number of admissions in Melbourne hospitals
[3 marks]
Question 3 [25 marks]
Most of the time houses prices depend on the local market conditions. In addition one of the factors is the number of bedrooms (as bedrooms increase prices increases). Recently Come Real Estate Agency has conducted a survey and selected a random sample of 211 for July 2015 sale in Melbourne and the data analyzed is summarized as follows.
SUMMARY OUTPUT
Regression Statistics
Multiple R 0.817326539
R Square 0.668022671
Adjusted R Square 0.66615763
Standard Error 115.8071494
Observations 180
ANOVA
df SS MS F Significance F
Regression 1 4803674 4803674 358.1811918 1.74254E-44
Residual 178 2387211 13411.3
Total 179 7190885
Coefficients Standard Error t Stat P-value Lower 95% Upper 95% Lower 95.0% Upper
95.0%
Intercept -137.8814237 25.56878832 -5.39257 2.18686E-07 -188.3383819 -87.4244654 -188.3383819 –
87.424465
Bedrooms 178.6267021 9.438326385 18.92568 1.74254E-44 160.0012892 197.252115 160.0012892 197.25212
House Price
Mean 317.6166667
Standard Error 14.93923611
Median 271.8
Mode 230.5
Standard Deviation 200.4308849
Sample Variance 40172.53961
Kurtosis 9.869866365
Skewness 2.287541039
Range 1544.3
a) Write down the regression equation.
[2 mark]
b) State the R-squared value and the standard error and explain what they mean with respect to the data.
[4 marks]
c) Write down the value of the gradient of the regression line and explain what it means for this data.
[3 marks]
d) Are the values for the constant and the gradient (slope) significant (i.e. significantly different from zero) in this case? Justify your answer.
[3 marks]
e) Conduct a hypothesis test on the slope coefficient to test whether there is a linear relationship between number of bedrooms and prices of the houses. Include the null and alternative hypotheses; key test results and an appropriate conclusion.
[5 marks]
f) Does the linear regression provide a good model? Give statistical reasons based on the scatterplot, p-values, the standard error and coefficient of determination.
[5 marks]
g) If you were developing a model to predict the prices of the houses on the number of bedrooms, what other factors would you like to be able to include?
[3 marks]

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

RealWorld Case Study of EAD: Scenarios Building for as-is and to-be architectures Each group will be randomly assigned a specific enterprise architecture in one



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Assignment 2 of ISIT903/403
RealWorld Case Study of EAD: Scenarios Building for as-is and to-be architectures
Each group will be randomly assigned a specific enterprise architecture in one organization unit.
First Part: On-Site Observation, Interviews, As-Is EAD
The team will probably conduct:
a. On-site observations in order to analyse the current Enterprise Architecture (EA).
This will help you to understand the firm’s dynamic and the business environment. Thereafter, you need to map the selected business process (as-is) using the ANSI or the EPC scheme. Finally, you need to validate the final process with your key informants in the organization unit.
b. Interviews
Semi-structured interviews with peoples involved in the chosen EA. All data gathered during these interviews needs to be recorded in an Excel or Word file and reviewed by your key informants in order to facilitate the design of the existing EA.
This part should also include observations: weaknesses and strengths of as-is EA and any business process mapping.
Second Part: Scenarios Building, To-Be EAD
The main goal here is to develop a target EA. The target EA should define a vision of future business operations and supporting technology. Here a key consideration is the determination of how far into the future the proposed EA will be implemented. This target EA (the to-be EA) should describe the desired capability and structure of the enterprise business process, information needs, and IT infrastructure at some point in the future. The target EA may include alternatives and options.
The target EA should:
•Reflect the EA team’s judgment about the future uses and characteristics of information within the enterprise
•Reflect the organization’s business requirements review, focusing on the opportunities to automate aspects of work and/or the access to information needed to perform work
•Incorporate technology forecasts
•Specify the needed level of interoperability needed between the data sources and the users of the data
•Identify the IT needed to support the enterprise’s technical objectives.
•Reflect budgetary and territorial concerns.
The output of assessment 2: Each group will have to submit a research report presenting the current EA (the as-is EA) and the future EA (the to-be EA) and your observations in terms of weaknesses and strengths, the justifications of that choice of target EA, and any other comments.
The research report should be Word document between 5500-6000 words in length, 1.5 lines spacing, regular Time New Roman, size 12 and you are required to follow Harvard citation standard.



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

. Investigate skills frameworks and develop an awareness of industry certifications relevant to IT professionals.



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

ITECH7402
Professional IT Culture
Faculty of Science and Technology
Group Oral Presentation Term 1, 2016
Topic
Career planning with special attention to skills frameworks and certification.
Assessment weight
15% (30 marks)
Learning Outcomes
This assessment task relates to the following learning outcomes and values stated in the course description:
• K5. Investigate skills frameworks and develop an awareness of industry certifications relevant to IT professionals.
• S1. Demonstrate a comprehensive understanding of the cognitive and practical approaches required to manage IT professionals in collaborative, global work environments.
• S2. Utilise professional presentation and communication approaches in a range of IT workplace settings.
• V1. Appreciate the changing business and technological paradigm in which IT professionals operate.
• V2. Appreciate the global nature of the IT industry.
Group composition
This task requires students to work in groups. The group size should be 3 except where the class size requires one or two groups to be of size 4. Group composition is to be confirmed by the tutor who has the final say.
Task
Each group member should choose ONE of the questions following and research it. The group should allocate different questions for each member. Each group should research on at least one question on skills frameworks and one question on certification. One of the tasks of each group is to integrate the research done by all of its members and to present the result in an oral presentation of 15-minute duration (excluding question time) with each group member contributing roughly equal amount of time. The tutor may vary this duration for an oversized or undersized group. The content of the presentation should be based on research evidence rather than personal opinion. It should assume that the audience is familiar with all course materials and therefore the presentations should skip such materials. Although the focus is on the IT workplace, generic business resources should also prove useful.

CRICOS Provider No. 00103D Page 1 of 4

ITECH7402
Professional IT Culture
Faculty of Science & Technology
Research questions
1) What advice is available for a new graduate who has been granted an interview regarding an IT position to be filled?
2) What contribution can the SFIA framework make to the implementation of a career plan by an IT professional?
3) Why is a university degree unlikely to be a sufficient certification over the lifetime of an IT professional?
4) Research the advice available in the area of professional networking. (Give some attention to networks that are global in scope.)
Report
The activity of the group should be described in a group report that is to be submitted with the presentation file. The contents of the report should include (not necessarily in the order given here):
• A list of responsibilities of each group member
• A record of each group meeting showing who was present and major decisions taken
• Research summaries of about 500 words, one from each member, containing the response to the question chosen and including appropriate citations (these summaries are expected to be useful in designing the slides to be presented)
• A group conclusion drawing together the research summaries
• Sequence of content in the presentation
• Details of slide template(s)
• Details of collaborative writing/ slide design between group members and/or feedback given to individuals
• A list of special features of the presentation e.g. the inclusion of significant visual items in the slides that provide more detailed information and lead to additional stimulation for the audience, a special focus in the delivery that shows flair
• A single, integrated reference list of all resources used by the group; each member should provide references that include at least one book, one journal and one website article; referencing should use the APA standard as in the university’s General guide to referencing.
CRICOS Provider No. 00103D Page 2 of 4

ITECH7402
Professional IT Culture
Faculty of Science & Technology
Submission
One member of the group should submit the report and presentation file (zipped) in the Assessment section of Moodle.
Refer to the Course Description for information regarding late assignments, extensions, special consideration, and plagiarism. Note that all academic regulations can be accessed via the university’s website especially statutes 5.3 and 6.1, url: http://federation.edu.au/staff/governance/legal/feduni-legislation/feduni-statutes-and-regulations

CRICOS Provider No. 00103D Page 3 of 4

ITECH7402
Professional IT Culture
Faculty of Science & Technology
Group Oral Presentation – Marking Guide – Term 1, 2016
Name ID Question researched Indiv Group Total Total
(18) (12) (30) (15.0)
1
2
3
4
A single mark only should be given for each of the 7 criteria, as shown by the maximum marks. Elements specified within each criterion should not be given a separate mark. Only outstanding work gets full marks. Work that is just satisfactory gets half marks only.
Assessment Criteria (Individual mark)
Max 1 2 3 4
Content of Good summary of research related to topic
presentation file Information is accurate, relevant
Provides information at an appropriate level to
maximise audience understanding 6
Presentation Simple language used, good presence
skills Content given orally exceeds that on the slides
Main points emphasised
Engaged whole audience with enthusiasm
6
Good voice (clarity, variety), good eye-contact
Individual writing Research relevant to the topic
Research applied appropriately
6
Well-written research summary
Total
18
Assessment Criteria (Group mark)
Max Group
Preparation of Good sequence of content
presentation Good slide design
4
Consistent style and structure of slides
Collaboration Evidence of mutual support
3
Workload shared equitably
Managing Presentation Keeping to time
2
Managing questions and audience interest
Group Report All required elements included
Well written conclusion
3
Referencing accurate (APA standard)
Total
12
CRICOS Provider No. 00103D Page 4 of 4

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

Research proposal 3



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service

 

Due date: See your Study Desk
Value: 40%
Structure: Research paper
Objectives
The course objectives met by this assignment include:
• Course specifications are available online from the USQ website http://www.usq.edu.au/course/specification/ . Always check the website for the latest version.
Overview
This assignment continuous the story of the two organisations you had selected in the first assignment (preliminary work) and uses the basis of the second assignment (research paper 1) and the third assignment (research paper 2).
In this fourth assignment (research paper 3) you now need to address how these two organisations’ network infrastructure can be impacted by the new era of Big Data.
Structure of research paper
The reading of the journal papers for your assignment, the Essay, has already provided you with good understanding on how a paper is written. When you write your research paper, you will be addressing it to the specific situation of your organisation. However, imagine that you would want to publish it in a journal so that other organisations can also think about your guidelines.
Organise your research paper in the following way:
• Title (you are required to provide your paper’s title)
• Your name and student number
• Abstract (about 100 words)
• Introduction
• Body context (you could divide into several sub-sections if required)
• Conclusion
• References.
The word-count limit for the introduction, body and conclusion of this paper is set at about 2,000 words. Use five (5) or more resources for your citing and referencing in Harvard style. Make sure to provide the name of the organisation as well as the URL, values, vision, and mission statement.
Please note that all assessment items in this course must adhere to the correct Harvard citing and referencing. For this purpose links have been provided to you on the study desk. However, you can consult the library web site for further details and clarifications.
Submission requirements
Submit your assignment via your study desk. Please note that the link will be visible to you only when the assignment is due. Do not email the essay to the course leader. If you are unable to upload, notify the course leader of the issue so that it may be resolved so that you can upload the assessment.
Marking criteria for research paper 2
Student name: ___________________________ Student number: ____________________
Marks
Structured development of research paper
Logical flow leading the reader from start to finish on a clear path of addressing the assignment requirements; clear identification and description of new network adoptions and management recommendations for Big Data.
Excellent meets all the requires for this objective 16-20
Good work – minor issue 11-15
Requires more work 5-10
Very poor effort 0-4
Comment:
/30
Depth of research/ critical reflection
Reason to support findings: critical evaluation and analysis of big data to be adopted by these two organisations; consideration regards need to upgrade some existing technologies to allow integration of new ones; consideration of changes in processing, employee skills, and management improvements which are required by big data.
Excellent meets all the requires for this objective 16-20
Good work – minor issue 11-15
Requires more work 5-10
Very poor effort 0-4
Comment:
/30
Understanding of key ideas and concepts
Understood the course material; able to identify key ideas and concept within a real life scenario; able to explain an issue with the use of key ideas and concepts related to big data; able to relate own experience to course material and issue by introducing own perspective
Excellent meets all the requires for this objective 16-20
Good work – minor issue 11-15
Requires more work 5-10
Very poor effort 0-4
Comment:
/30
Evidence of support
Citing and referencing: Correct format of in text Harvard citing; correct format of Harvard reference list; used more than five (5) sources (book, journal article, report, news article on the internet) in addition to the course text book.
Excellent meets all the requires for this objective 16-20
Good work – minor issue 11-15
Requires more work 5-10
Very poor effort 0-4
Comment:
/10
Total /100
General Comments:

 



Click here to order this paper @Superbwriters.com. The Ultimate Custom Paper Writing Service