澳洲論文代寫 > essay代寫 > 墨爾本essay代寫 > > 正文

墨爾本essay代寫

Australia: EXCEL AND THEORY 代寫

 
*Assignment detail(必填)
1*科目Subject :business computing
2. 學校University name: otago
3*作業字數:
是否有計算或數據處理 (是或否):    好像沒有哦是否需要圖表 (是或否) :是
4*學術級別Study level(Bachelor -Master-PhD:5級,
5.*您想拿到作業的日期(: 我們一般都在當晚交給作業):星期日
6. 學校要求的Assignment due day日期:下禮拜一
7*作業格式(Essay or Report):
8*需要幾個References
9*References Style(APA–Harvard-Chicago-Others):
10.建議概述(對這份作業的重點要求):
 
*Assignment material(必須提供以下資料)
1.你的教科書名是什么Text Book(s) Used in Class:一本看上去大大的書,老師讓買全班沒人買
2. 如果有lecture notes請提供
3. 請提供作業評分標準Assignment making guide or assessment criteria
4. 請提供作業正文和要求Assignment requirement
5. 如果是Case study 請提供case (可掃描)
 
作業資料請和本表格文件一起壓縮后發來給我們。
 
 
 

 

 
 
 
 
 
BX5550001
 
Business computing
 
 
assignment 2: excel and Theory
 
 
 
DUE: Week 6 Day 2
cohort 1: 18 September 2013
cohort 2 & 3: 19 September 2013
 
 
This assignment contributes 30% of the total course grade
 
Assignment rationale
 
You are expected to show understanding on the following learning outcomes (number 2 and 4 on Course Outline):
·          Discuss and evaluate communication technologies to meet business requirements;
·          Use software functions effectively to produce information to meet business requirements.
 

Assignment Presentation                                                                                                        

 
Question 1 is to be Word processed, 1.5 spacing, font size 12. It should be presented with suitable headings and layout, correct spelling and grammar, and tidy presentation.
 
The page limit is 3 pages. 
 
Question 2 is to be prepared using Excel. Refer to the marking guide for full details of requirement.
 
 
Submission & Late hand-in of assignment:
You are expected to submit your assignment no later than at the commencement of class on Week 6 Day 2 (18 September for cohort 1, 19 September for cohort 2 and 3). You are reminded of, and referred to, the policy in the Course Outline regarding late hand-in of assignment.
 
Plagiarism:
You are reminded of, and referred to, the policy in the Course Outline.
 
Question 1:                                                                                                                                                                   (10 marks)
Evaluate various communication technologies and how they meet the requirements of business. In your evaluation you are required to explain, discuss and evaluate the following:
a)       Communication channels, with specific reference to the wireless and physical connections                          2 marks
b)       Communication Devices                                                                                                                                      2 marks
c)        Computer Networks                                                                                                                                            2 marks
d)       The internet, with specific reference to:                                                                                                           4 marks
                                 i.            Security (1 mark)
                                ii.            Communication methods (1 mark)
                              iii.            Search tools (1 mark)
                               iv.            Electronic commerce and cloud computing (1 mark)
 Australia: EXCEL AND THEORY  代寫
Question 2:                                                                                                                                                                    (20 marks)
Prepare a spreadsheet using Microsoft Excel 2010.
 
You are an administrator for a business communication and personal improvement training provider – Improvement Unlimited. Your job is to:
 
·         Track all of the training packages that you sell. Businesses purchase a package with or without accommodation.
·         Collect a deposit of 20% of the total cost of the training package. Most of your customers choose to pay for their packages on a monthly payment plan for one year, which you calculate based on a standard interest rate 6%.
·         Calculate general statistics to summarize for your manager. Check results to make sure you created formulas and functions correctly.
 
Customer package purchases
Company ID Business name Package Accommodation needed Number of people  
10034 The happy confectionary company 2-day personal improvement seminar Yes 10  
3421 The coffee club 2-day communication seminar No 5  
12123 CC's clothing Combination 3-day course Yes 6  
23901 JJ's importers Combination 3-day course No 7  
12012 The Den sport bar 2-day communication seminar Yes 12  
20301 Nelson garage One-day seminar Yes 20  
20310 Macy’s travel agency 3-week combination course No 10  
12314 Don B. accounting Online course Yes 12  
           
 
 
Packages available
Training Course Cost per person Accommodation cost per person
2-day communication seminar $450.00 $200.00
2-day personal improvement seminar $550.00 $200.00
Combination 3-day course $1,000.00 $300.00
3-week combination course $3,000.00 $1,680.00
Online course $70.00 $0.00
One-day seminar $175.00 $100.00
 
Prepare a spreadsheet showing:
1.        The cost for each business training session in total and per person
2.        The amount of the down payment, the balance left to pay and the monthly payments where the interest rate is 6% per annum
3.        Statistics of the packages purchased
4.        1 suitable chart
 
The spreadsheet produced must show evidence of:
 Australia: EXCEL AND THEORY  代寫
Skills
·         Create at least 2 range names                                                                1 mark
·         Use each name range at least once in a formula or function                         1 mark
·         Display the current date                                                                         1 mark
·         Use absolute referencing in at least 2 different formulae or functions                  1 mark
·         Use the IF statement at least once                                                        1 mark
·         Create at least 2 different LookUp functions                                         2 marks
·         Use the PMT function to calculate the monthly payments                             1 mark
·         Use a data validation technique to ensure only valid data can be entered for accommodation requirements (Yes or No). Include Input and Error messages  2 marks
·         Protect the worksheet by using data protection techniques to limit which cells a user can enter data in (don’t add a password)                                                1 mark
 Australia: EXCEL AND THEORY  代寫
Results
·         Analyse the packages sold by using at least 2 statistical functions (choose from count, maximum, minimum, average, median)                                               2 marks
·         Produce 1 suitably labelled chart/graph. Move this chart to a separate sheet       1 mark
·         Explain the different methods of placing data and charts from a Spreadsheet into a Word document. Use one of the charts produced above to clearly demonstrate the difference between linking and embedding a chart into Word.                             3 marks
 
Set out
·         Place BUSINESS booking details and COST on separate worksheets and name each worksheet with a suitable name                                                                                                                             1 mark
Set up the worksheets to display in a professional manner using proper techniques
·         (including layout, formatting, your name and student ID as a right hand header and the current date [as fields] in the footer)                                                                                                               2 marks
 
Refer to the marking guide for full details of requirement of the assignment.


 

tag:
下一篇:沒有了

Contact us / 聯系我們

QQ: 273427
QQ: 273427

Online Service / 在線客服

Hours / 服務時間
全天24小時為您服務

熱情 專業 誠信 守時
Copyright ? 2008-2018 assignment代寫

在線客服

售前咨詢
售后咨詢
微信號
Essay_Cheery
微信

在線客服

售前咨詢
售后咨詢
微信號
Essay_Cheery
微信
英国代写_数学代写_c++/c代写_留学生代写怎么查出来?