BN105InformationTechnology for Users in Organisations代写

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代写