coursework代写Discuss how Porter’s Five Force model mi
论文题目:Discuss how Porterrsquo;s Five Force model might contribute to a SWOT analysis. ?论文语言:英语论文 English论文专业:business and financial management字数:不超2500学
2023-03-18
BN105InformationTechnology for Users in Organisations代写
Prepared by Dr Sai Lakkaraju Moderated by: Dr Jahan Hassan July 2017 Assessment Details and Submission Guidelines Trimester 2017.2 Unit Code BN105 – BN105D Unit Title Information Technology for Users in Organisations Assessment Type Individual Assignment Assessment Title Microsoft Excel
BN105InformationTechnology for Users in Organisations代写 Purpose of the assessment (with ULO Mapping) • Describe the Information and Communications Technology (ICT) infrastructure employed by Organisations. • Appreciate the importance of individual and organisational stakeholders in the specification and development of ICT systems. Weight 15% Total Marks 25 Word limit 200 for Letter Due Date Week 8 Submission Guidelines • All work must be submitted on Moodle by the due date. • The assignment must be in MS Word format, 1.5 spacing, 11-pt Calibri (Body) font and 2.5 cm margins on all four sides of your page with appropriate section headings. • Reference sources must be cited in the text of the report, and listed appropriately at the end in a reference list using IEEE referencing style. Extension • If an extension of time to submit work is required, a Special Consideration Application must be submitted directly to the School's Administration Officer, in Melbourne on Level 6 or in Sydney on Level 7. You must submit this application three working days prior to the due date of the assignment. Further information is available at: http://www.mit.edu.au/about-mit/institute-publications/policies- procedures-and-guidelines/specialhttp://www.mit.edu.au/about- mit/institute-publications/policies-procedures-and-guidelines/special- considerationdefermentconsiderationdeferment Academic Misconduct • Academic Misconduct is a serious offence. Depending on the seriousness of the case, penalties can vary from a written warning or zero marks to exclusion from the course or rescinding the degree. Students should make themselves familiar with the full policy and procedure available at: http://www.mit.edu.au/about- mit/institute-publications/policies- procedures-and-guidelines/Plagiarism- Academic-Misconduct-Policy- Procedure. For further information, please refer to the Academic Integrity Section in your Unit Description. BN105/BN105D Information Technology for Users in Organisations Page 2 of 4 Prepared by Dr Sai Lakkaraju Moderated by: Dr Jahan Hassan July 2017 Assignment Description Pineapple Travel Agency (PTA) has offices in Melbourne and Sydney. They specialise in individual travel itineraries for their clients. A new client, Ada Lovelace, has asked the local agency to plan a trip for her that will cover all continents (except Antarctica). Ada plans to spend approximately $29,000 to $31,000 on airfares accommodation and spending money and has given the agency a list of cities she wishes to visit. She has told the company that she will be spending $60 per day. Using the spreadsheet (ALItinerary.xlsx) perform the following tasks: ORIGINAL QUOTE 1. Sort the spreadsheet in continents and then cities 2. Using “absolute formulas” linked to cell G1 fill in the daily spending money for each city (Column D). 3. Using formulas calculate how much per day Ada will have to spend in each city (Column E). 4. Using formulas calculate the total Ada will spend in each city (Column G) 5. Using a formula calculate the total amount Ada will spend on her holiday (the airfare is $7,500) 6. Format the spreadsheet so on the monetary values have $ 7. Rename the sheet 1 “Original Quote” REVISED QUOTE 1. Add a new sheet to the worksheet and rename it “Revised Quote” 2. Copy the original details to this sheet. 3. PTA will advise Ada that her expectation of spending $60 a day in all cities is not realistic. They will suggest the following: Spending Money per day Continent Per Day Africa $ 8 0 .00 Asia $ 7 0 .00 Europe $ 120.00 North America $ 100.00 Oceania $ 110.00 South America $ 6 0 .00 • Create this table in the worksheet • Using the information in the above table and either a LOOKUP or IF function allocate the new “Per Day” spending amount to each city. 4. Using formulas answer the questions in the “Questions” sheet. Per Day Per Stay Money to be spent in the Most Expensive City Money to be spent in the Least Expensive City Average money to be spent Original Itinerary Total Revised Itinerary Total Increase required Percentage Increase BN105/BN105D Information Technology for Users in Organisations Page 3 of 4 Prepared by Dr Sai Lakkaraju Moderated by: Dr Jahan Hassan July 2017 5. Format the Revised Quote sheet • All monetary amounts should have $ signs • Wrap the text in the column headings • Change the column widths to fit the data CREATING A CHART OF THE REVISED QUOTE 1. Research how to make a chart with non-contiguous data (also called non-adjacent data) 2. Using the “Revised Quote” sheet create non-contiguous chart using the following data: • City • Continent • Total Per day • Total Per Stay 3. Formatting details for chart: • Chart Type: Combo • Secondary Axis: Total per Day • Location: New Sheet • Sheet Name: Revised Quote Chart • Chart Title: Revised Itinerary LETTER
BN105InformationTechnology for Users in Organisations代写 1. CREATE A LETTERHEAD FOR PINEAPPLE TRAVEL AGENCY • Use a picture of a Pineapple in the letterhead • Use the street address of your campus as the address for the travel agency 2. USING THE LETTERHEAD WRITE A SHORT LETTER TO ADA Lovelace (no more than 200 words) • Explain to Ada that her expectations of $60 per day is not realistic. • Include the table with the suggested spending money per continent. • Also include details of: • The Most/Least Expensive city by day and in total • The increase from the original quote to the revised quote BN105/BN105D Information Technology for Users in Organisations Page 4 of 4 Prepared by Dr Sai Lakkaraju Moderated by: Dr Jahan Hassan July 2017 Marking criteria: Marks are allocated as per the assignment task specifications as follows: TASK MARK ORIGINAL QUOTE 1 Spreadsheet sorted in continents then cities 0.5 2 Original quote – absolute formula used for daily spending money 1.0 3 Daily spending money for each city calculated 0.5 4 Total spending money for each city calculated 0.5 5 Total Amount spent for holiday 0.5 6 Format spreadsheet 0.5 7 Rename sheet 0.5 Sub Total 4.0 REVISED QUOTE 1 Add new sheet and rename it 0.5 2 Copy all the details from "Original Quote" to the new sheet 0.5 3 Create spending Money Table - and use LOOKUP or IF Function to calculate the new daily spending money 3.0 4 Answer the question on the "Questions" sheet 2.0 5 Format the sheet as per the specifications 1.0 Sub Total 7.0 CREATING A CHART OF THE REVISED CHART 1 Research how to make a chart with non-contiguous data (also called non adjacent data) 2 Using "Revised Quote" create a non-contiguous chart as per specifications 3.0 3 Format the chart as per specifications 2.0 Sub Total 5.0 LETTER 1 Create a letterhead as per specifications 3.0 2 Write a letter to Ada Lovelace as per specifications 6.0 Sub Total 9.0 Total Marks 25.0 Scaled to 15.0 BN105InformationTechnology for Users in Organisations代写
版权声明:本站文章来源为原创以及网络整理,意在为留学生分享各种Essay写作技巧以能够顺利完成学业,Essay写作格式以及Essay范文仅供学习参考,不得抄袭。如本站文章和转稿涉及版权等问题,请及时联系本站,我站将在第一时间予以删除。
标签: #for
相关文章
论文题目:Discuss how Porterrsquo;s Five Force model might contribute to a SWOT analysis. ?论文语言:英语论文 English论文专业:business and financial management字数:不超2500学
2023-03-18
Saturday March 20th 2010 Minimum wage formula #39;won#39;t work for HK#39; Martin Wong and Paggie Leung Hong Kong#39;s vast income gap means it cannot apply a simple ......
2020-09-22
Some options of term paper outline formatsTerm papers are best when developed from an outline. Many students do not understand the functions of an outline and therefore ......
2020-09-22
Termpaper for the Course of TranslationComputer Translation of Homonymy and PolysemyIn this paper, I want to discuss computer translation from the perspective of its treatm......
2020-09-22
31265 Communications for IT Professionals assignment 代写 Assignment Outline 31265 Communications for IT Professionals This document contains details for assessments for Communications for IT Profess
2019-10-25
代写BUIL 1305 Research Methods for the Built Environment BUIL 1305 Research Methods for the Built Environment Week 5 Research Strategies Nick Blismas Acknowledgments These course materials have histo
2019-10-25