Using Gantt Charts: Teaching Tips
Here are some teaching ideas and activities for using the Gantt Chart Excel template, which is available for free download on this website.
Using Gantt Charts: Teaching Tips Review the Teaching Activity
Analysis
Gantt Chart Excel Template
This is a free tool for your students to use to make Gantt Charts using an easy-to-use Excel template. Ideal for project planning and input into marketing plans and other assessment tasks.
Gantt Chart Excel Template Review the Teaching Activity
Target Market Assessment
In this activity, students compare the assessment factors for three market segments. They need to rate each factor and then choose the best segment overall to be their chosen target market.
Target Market Assessment Review the Teaching Activity
Marketing Financial Forecasts
In this mini case study, an accountant firm is trying to forecast the likely profit from a new software program that they plan to launch onto the market – but they have two quite different profit expectations – can your students help them?
Marketing Financial Forecasts Review the Teaching Activity
How Would You Segment These Consumers?
In this introduction to segmentation (and viable segments) students review information for 12 consumers and split them into segments. It sounds simple, but is it?
How Would You Segment These Consumers? Review the Teaching Activity
GE-McKinsey Multi-Factor Excel Template (Teaching Ideas)
In this set of activities, students download a free Excel template to run the GE matrix, in order to understand its construction and how it works. They can also use the template to assist them in with various marketing reports and/or assignments.
GE-McKinsey Multi-Factor Excel Template (Teaching Ideas) Review the Teaching Activity
Run Cross-tabs in Excel (Template Tool)
This is an easy-to-use Excel template tool that allows students to learn how to use and interpret cross-tabs, when analyzing market research data. As well as cross-tabs, the template also allows students to produce charts quickly – an ideal tool for their assignments and reports.
Run Cross-tabs in Excel (Template Tool) Review the Teaching Activity
Creating Customer Journey Maps (Student Tool and Tasks)
In this task, students download and use the customer journey map (CJM) Excel template to develop CJM’s for different personas.
Creating Customer Journey Maps (Student Tool and Tasks) Review the Teaching Activity
Constructing Perceptual Maps
This exercise is designed to give students a good sense of how to use perceptual maps effectively from a marketing perspective. Students will need access to Excel and the free mapping template.
Constructing Perceptual Maps Review the Teaching Activity
Reviewing Perceptual Maps
In this activity, students are presented with consumer perception data, along with an easy-to-use Excel perceptual mapping tool, to determine the relative positioning of competing brands
Reviewing Perceptual Maps Review the Teaching Activity