商业决策Business_decision_Assignment(1)(2010 new).doc

BTEC CentreGuangdong AIB Polytechnic College UnitUnit 6:Business Decision MakingClass2008 Management, MarketingAssignmentA1: Collecting and analyzing Data Date issuedOct. 11, 2010Date deadlineNov. 05, 2010TutorLiu Houwei，Lin Kuisheng, Yang LiyanIVHuangguanDeclaration:I am aware that cheating and plagiarism will not be tolerated in any assignment and that this work complies with the requirements.Students Signature： (In Pinyin) (In Chinese)Class: Student No.: Learning Outcomes 1. Use a variety of sources for the collection of data, both primary and secondary1.1 prepare and implement a plan for the collection of primary and secondary data for a given business problem.1.2 describe and justify the survey methodology and frame used.1.3 develop and use a questionnaire and justify its design for a particular purpose.2. Apply a range of techniques to analyze data effectively for business purposes2.1 create information for decision making by summarizing data using representative values, and use the results to draw valid and useful conclusions in a business context.2.2 analyze data using measures of dispersion, and use to inform a given business scenario.2.3 calculate quartiles, percentiles, correlation coefficient, and use to draw useful conclusions in a business context.3. Produce information in appropriate formats for decision making in an organizational context3.1 using data from a given business scenario, prepare a range of graphs using spreadsheets line, pie, bar charts and histograms, and draw valid conclusions based on the information derived3.4 prepare a formal business reportAssessment CriteriaEvidencePass1.1 prepare and implement a plan for the collection of primary and secondary data for a given business problem.List all items to be investigated and judge their sources, list steps to achieve the investigation.1.2 describe and justify the survey methodology and frame used.Analyze the local market, decide the sample for surveying and justify the methodology of survey.1.3 develop and use a questionnaire and justify its design for a particular purpose.Design a questionnaire and use it to visit the consumers, analyze the feasibility and rationality of the questionnaire.2.1 create information for decision making by summarizing data using representative values, and use the results to draw valid and useful conclusions in a business context.Use suitable tables to summarize data, get a range of representative values by calculating the mean, mode, median etc of them to draw useful conclusions.2.2 analyze data using measures of dispersion, and use to inform a given business scenario.Calculate the variation, standard deviation. Judge the quality of collected data and inform the company.2.3 calculate quartiles, percentiles, correlation coefficient, and use to draw useful conclusions in a business context.Calculate quartile, percentiles, correlation coefficient of quantitative variables and draw useful conclusions.3.1 using data from a given business scenario, prepare a range of graphs using spreadsheets line, pie, bar charts and histograms, and draw valid conclusions based on the information derivedPlot line, pie, bar charts and histograms for the collected data, give valid conclusions.3.4 prepare a formal business reportOrganize the whole assignment as a formal report for decision making.MeritM1 complex problems with more than one variable have been exploredThe objectives of the research are relevant to support the decision making the company will make in the scenario, key variables identified.M2 complex information/data have been synthesized and processedStudent is able to synthesize mathematical tools to analyze data and reach the required goals.M3 logical and coherent arguments have been presentedThe assignment is written in appropriate structure with technical language, the logical and coherent arguments are presented.DistinctionD1 the validity of results has been judgedEvaluate the validity of the results and discuss the drawback in the work.D2 substantial activities/projects or investigations have been planned, managed and organizedThe business report showing that the substantial investigations, analysis have been made. Also the project well organized and executed according to the problem in the scenario.D3 convergent and lateral thinking have been appliedKey variables in the questionnaire are included. And suitable statistical methods are used to analyze given variables to get useful conclusions. The convergent and lateral thinking can be demonstrated in the work.Grading： Detailed Grading1.11.21.32.12.22.33.13.4M1M2M3D1D2D3Tutors comments:Tutors signature: Date:IVs comments on above grading decision:Final grading decision1.11.21.32.12.22.33.13.4M1M2M3D1D2D3IVs Signature: Date:Purpose：After finishing the assignment, student should know how to collect the data, analyze them by suitable mathematical tools and present them in proper form, to support decision making in business scenario. Scenario Hongxin is a private English training company established in 1994 in Guangzhou. Now this company wanted to get into children Quality-oriented Education training market by opening a private training center in Tianhe district which targets at primary school students and is doomed to compete with the Childrens Palace established by local government. At the early stage of the project, they decided to only provide most popular training courses, like playing musical instrument, singing, drawing, tae kwon do, kung fu, dancing and so on. The marketing Dept. needed to provide suggestion to senior management about go for it or not, and at the same time provide suggestion about the initial marketing strategy. Before everything began, the marketing Dept. planned to launch a market research project. You are designated to be responsible for this project; please design a viable plan for collecting the primary and secondary data, survey the market, display and analyze the data and write a formal report to support the decision making. Tasks: 1. Design a viable plan for collecting the primary and secondary data for local market. (Outcome 1.1)(1) List all items you want to investigate. (2) Estimate which of them are primary and secondary data(3) Design several steps to finish the survey. 2. Describe and justify the survey methodology and frame used. (Outcome 1.2)3. Design a questionnaire and use it to survey the market, justify its design. (Outcome 1.3)(1) Design a questionnaire for the survey. (2) Visit consumers and fill the questionnaire.(3) Justify the design of the questionnaire.4. Use suitable tables to summarize data, get a range of representative values by calculating the mean, mode, median etc of them to draw useful conclusions. (Outcome 2.1)(1) Use tables to present those data.(2) Calculate the mean, mode, median of the data(3) Draw useful conclusions.5. Measure the dispersion of the data, and inform the decision-makers of company. (Outcome 2.2)(1) Calculate the variance and standard deviation of data.(2) Get valuable conclusion to inform the decision-makers of company in the report.6. Select some proper data and calculate their quartile, percentiles, correlation coefficient, and use them to draw useful conclusion (Outcome 2.3)7. Plot line, pie, bar charts for collected data by Microsoft