Course Title: Analyse data from international markets

Part B: Course Detail

Teaching Period: Term1 2009

Course Code: MKTG5790C

Course Title: Analyse data from international markets

School: 650T TAFE Business

Campus: City Campus

Program: C5219 - Diploma of International Business

Course Contact : Gowri Raviganesh

Course Contact Phone: +61 3 9925 1337

Course Contact

Name and Contact Details of All Other Relevant Staff

Course Co-ordinator: Gowri Raviganesh
· Phone: 61 3 9925 1377
· email:

Max Kaltmann
· Phone: 61 3 9925 1544
· email:

Nominal Hours: 50

Regardless of the mode of delivery, represent a guide to the relative teaching time and student effort required to successfully achieve a particular competency/module. This may include not only scheduled classes or workplace visits but also the amount of effort required to undertake, evaluate and complete all assessment requirements, including any non-classroom activities.

Pre-requisites and Co-requisites


Course Description

This unit describes the performance outcomes, skills and knowledge required to analyse data from international markets.

No licensing, legislative, regulatory or certification requirements apply to this unit at the time of endorsement.

National Codes, Titles, Elements and Performance Criteria

National Element Code & Title:

BSBMKG511A Analyse data from international markets


BSBMKG511A/01 Interpret trends and market developments

Performance Criteria:

1.1 Use statistical analysis of Australian and international market data to interpret international market trends and developments
1.2 Analyse trends and developments within Australia and relevant international settings for their potential impact on international business activity within target market
1.3 Identify aspects of culture that may have an impact on international business activity within target market
1.4 Use measures of central tendency/dispersion and correlations between sets of data for quantitative interpretation of comparative international market data
1.5 Perform qualitative analysis of comparative international market information as a basis for reviewing business performance in international settings


BSBMKG511A/02 Interpret competitor market performance

Performance Criteria:

2.1 Analyse the international market performance of existing and potential competitors and their products or services to identify potential opportunities or threats
2.2 Compare international business performance to that of competitors to identify market position


BSBMKG511A/03 Report on market data

Performance Criteria:

3.1 Prepare, plot and interpret data for visual presentation
3.2 Assess visual presentation for potential problems and take corrective action if necessary
3.3 Ensure report meets organisational requirements in terms of content, format and level of detail
3.4 Submit report within the required timeframe

Learning Outcomes

Please refer to Elements of Competency.

Details of Learning Activities

  • An initial introduction to topics and techniques via a lecture will include the fundamentals and methods of business statistics.
  • Students will participate in tutorial-based discussion groups that will enable them to relate topics to the environment, in which they live and work. They will be required to present their own thoughts, opinions and ideas. A range of learning team activities will assist them to develop and apply their knowledge in different situations that reflect tasks, which they might encounter in a business environment.
  • A range of self directed learning activities would be provided for students to practice, reinforce and summarise the key learning.
  • Students will be responsible for managing the progress of their self-directed learning. Students will work on self-directed learning activities (multiple choice & Internet based case study) independently of the lecturer.

Teaching Schedule

Week beginningTopics /AssessmentTextbook References
Week 1 Feb 9Introduction to Statistics, sampling and data collectionChapter 7 & 8
Week 2 Feb 16Organisation and Visual representation of data Chapter 7 & 9
Week 3 Feb 23Measures of Central tendencies Chapter 10
Week 4 Mar 2Measures of Dispersion
Chapter 11
Week 5 Mar 9Probability and Normal Distribution Chapter 12
Week 6 Mar 16Sampling Distribution
Chapter 13
Weel 7 Mar 23Revision
Week 8 Mar 30Class Test (20%)  
Week 9 Apr 6Excel in lab
 Easter Break (April 9th to 15th inclusive) 
Week 9 Apr 13EXCEL in Lab
Week 10 Apr 20Estimation

Week 11 Apr 27Correlation and Regression Excel in lab Chapter 16
Week 12 Mar 4Correlation and Regression Chapter 16
Week 13 May 11Time Series, Excel in lab Chapter 18
Week 14 May 18Time Series
Chapter 18
Week 15 May 25

Index Numbers Revision, (Due date for Assignment 30%)

 Chapter 17
Week 16 Jun 1Revision 
Week 17 Jun 8Examination (50%) 
Week 18 Jun 15Course review and assessment feedback  
Chapter 12


Learning Resources

Prescribed Texts

Greg Dickman, Financial Forecasting And Data Analysis. Thomson.



Other Resources

Online Resources

Reference text
Jay Heizer & Barry Render, Principles of Operation Management, 6th Edition.

Overview of Assessment

Assessment will incorporate a variety of methods including tests, assignments and an examination. Tests will be closed book consisting of multiple choice questions, problem solving exercises and applied exercises. The assignment will require students to undertake basic research on a business theme. Students working in groups will be required to analyse data using MS Excel 2003 and write reports as directed.

Students will receive ongoing feedback on their progress in the course. Feedback on assessments will be given in a timely manner. Students will be informed about how to improve their performance in the competency / course and what they will need to to to be deemed competent or to gain a pass in the assessment.

Assessment Tasks

Assessment in this course will consist of 3 tasks:

  • 1 Test (held in week 8)
    In-class test worth 20 % will be held in week 8. Test will be closed book and one & ½ hour in duration. Formula sheet will be provided and only non-programmable calculators are allowed.
  • 2 Group Assignment (due week 15)
    Students need to source information from specified web sites. Analyse data using EXCEL “Data Analysis” tool pack and write reports. This is worth 30% and due in week 15.
  • 3 Exam (During Exam period)
    A closed book exam worth 50% covering all topics will be held during exam period.

Assessment Methods
Assessment will incorporate a variety of methods including written test, assignment and exam.

Students are assessed against all the performance elements of the course and must demonstrate an understanding of all elements to be deemed competent.  To receive a pass for this course student must also pass the final exam.

Assessment Matrix


ElementClass testAssignmentExamination
Interpret trends and market developmentsYYY
Interpret competitor market performance YY
Report on market dataYYY

Other Information

  • Assessment criteria.
    This course will enable students to achieve the following learning outcomes: 

1. Organising, summarising and presenting business data using statistical tools.

  • 1.1 Identify types of statistics that are common to business
  • 1.2 Differences between Sample and Population
  • 1.3 Introduction to sampling
  • 1.4 Distinguish primary and secondary data
  • 1.5 Explain why data is presented visually
  • 1.6 Organising raw data into Frequency and grouped frequency distribution
  • 1.7 Represent data tables graphically * Histograms * Polygons * Ogives * Bar chart * Pie chart
  • 1.8 Calculate the measure of central tendencies (only for raw data) * Mean * Mode * Media
  • 1.9 Identify the appropriate measure for a given situation
  • 1.10 Discuss the significance of skewness of a data. Calculate the measure of dispersion (only for raw data) * Range * Inter-Quartile range * Standard deviation
  • 1.11 Writing a brief Business report
  • 1.12 Use of software (excel) for analysing data

2. Drawing inferences about population from sample statistics

  • 2.1 Distinguish between a population and a sample
  • 2.2 Describe the special features of a normal distribution
  • 2.3 Understand and apply central limit theorem
  • 2.4 Calculate point estimates and confidence interval for the population mean
  • 2.5 Solve business problems that can be represented by a normal distribution
  • 2.6 Understand the principles of statistical inference
  • 2.7  Estimation  based on test statistics. Use of EXCEL

3.Measure the nature and degree of relationship between two variables and represent this relationship by a linear equation

  • 3.1 Discussing examples where there is association between two variables
  • 3.2 Understand dependent and independent variable
  • 3.3 Draw and interpret a scatter diagram
  • 3.4 Assess relationship with the help of correlation coefficient
  • 3.5 Interpret of correlation coefficient
  • 3.6 Understand linear regression
  • 3.7 Establish linear relation between two variables using the method of Least squares Regression
  • 3.8 Prediction based on linear regression equation
  • 3.9Check the goodness of fit using coefficient of determination. Use of EXCEL

4.Observing data at specified time intervals and use it for forecasts.

  • 4.1 Identify and interpret the four basic measures of variation in a time series analysis
  • 4.2 Describe a time series and explain its use by giving example
  • 4.3 Use common methods of fitting secular trend lines to time series (including semi averages, moving averages and least-squares)
  • 4.4 Forecast using trend. Use of EXCEL

5.Observing Prices of different items at specified time intervals and use it to measure the changes in retail price:

  • 5.1 Use of simple, composite & weighted Price indices to measure the change in retail prices.
  • 5.2 Special applications of the CPI

Course Overview: Access Course Overview