| Forest type (PFTName) | Mature area (ha) |
|---|---|
| Conifer Lowland | 903,009 |
| Conifer Upland | 745,944 |
| Mixedwood | 471,449 |
| White Birch | 242,519 |
| Poplar | 219,451 |
Chapter 3 — Practice Demo Lab: Reference Solution
Lab: Build a chart-and-PivotTable deliverable together
Note
Reference solution for the Chapter 3 Practice Demo Lab (Tasks 1–6 of Lab: Build a chart-and-PivotTable deliverable together). The graded Canvas lab has its own private answer key.
Task 1 — Choose the question
Worked example: “Which forest type has the most mature area in Region 3E?” (Any of the three suggested questions is fine.)
Task 2 — Build the PivotTable
On on_forest_statistics_1_clean.xlsx: Insert → PivotTable. For this question:
- Filters:
SERAL_NAME→ set to Mature - Rows:
PFTName(forest type) - Values:
SumOfTotalHa→ Sum (label it “Sum of area (ha)”)
Sort the Values column largest-to-smallest. The PivotTable answer:
Answer: the forest type with the most mature area in Region 3E is Conifer Lowland (~903,009 ha).
Task 3 — Build the PivotChart
Select the PivotTable → PivotTable Analyze → PivotChart → Clustered Column. Then:
- Chart title: “Mature area by forest type, Region 3E”
- Y-axis title: “Area (hectares)” — units must appear
- X-axis: forest type
Task 4 — Add a slicer
PivotTable Analyze → Insert Slicer → tick a categorical field (e.g., AC_10 age class, or LGDS seral code). Click a slicer button and confirm both the PivotTable and the PivotChart update together.
Task 5 — Export and caption
Right-click the chart → Save as Picture → PNG into outputs/. Example caption:
Mature forest area by provincial forest type, Region 3E. Source: Government of Ontario — Forest Resources of Ontario 2021 (Open Government Licence — Ontario).
Task 6 — Submit
Submit a one-page worksheet with your question, your Rows/Columns/Values choices, and the exported PNG + caption — with all group members’ names. (Graded lab: follow Canvas.)