Essential Skills Manual - Automotive Service Technician

TECHNICAL SKILLS

INVENTORY (TSI)

Automotive Service

Technician

NOC 7321

Direction

¾ Create a Pie Chart to produce a visual depiction of a group’s learning

needs

o Highlight the entire “Summary Chart” on the last page of your

spreadsheet.

o On the tool bar, choose the “Chart Wizard”

(Microsoft Office Excel 2003)

o Under chart “Chart type” choose “Pie”

o Under “Chart Sub-Type” choose the first Pie picture

o Click “Next”

o Choose “Data Range” and “Columns” then click “Next”

o Choose “Titles” and fill in “Chart Name” (Group Location and

Trade)

o On the same tool bar, choose “Legend” then “Bottom”

o On the same tool bar choose “Data Labels” then choose

“Category Name,” “Value,” and “Legend Key,” then click

“Next”

o Under Chart Location choose “As New Sheet” and click “Finish”

o To change a colour of a piece of the pie chart so 2s and 3s in

the same piece of the pie match,

• click inside the pie


• click on the piece of pie you want to change


• double click on that same piece and the colour chart
  will appear


• choose your colour

o To move or adjust items in the pie chart, right click on the pie

chart, choose “Edit” then choose the item you want to adjust

or move. Click outside the chart when you are finished

o Choose “Edit”, then “Copy” the pie chart and “Paste” it into the

“Group Learning Plan”

¾ Provide the instructor with a copy of both the TSI Group Summary

Chart and the Group Learning Plan within 24 to 48 hours so he/she

can choose appropriate learning resources; and put one copy of the

TSI Group Summary and the Group Learning Plan Pie Chart in the

office files.

Page 228 Automotive Service Technician

NOC 7321