BN105InformationTechnology for Users in Organisations代写
100%原创包过,高质代写&免费提供Turnitin报告--24小时客服QQ&微信：120591129
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代写
