Solutions to Revision Exercises
Module: Computer Literacy Advanced (HCLT108-1)
Week number (Date): 8,(13 April 2023)
Unit covered: Unit 11 and 12 ( Microsoft Excel 2021)
Instructions:
To enrich your learning experience at Boston even further, and to ensure that you are exposed to a
variety of resources in this module, announcements will be posted every week containing additional
materials or activities for you to work through.
It is important to note that these activities are neither compulsory nor weighted, but that it will be to your
advantage to participate. The purpose of the activities is to help you better understand the content of
your weekly unit/s of study, and it will assist in creating insight and deeper meaning.
Activity 6 is based on Units 11 and 12 of the prescribed study guide for this module.
You are required to do your own research and attempt to answer the questions below.
Question 1 9 marks
You have been provided with the attached spreadsheet with research data on Hockey team members
from different countries. You are requested to provide an analysis report on this data. As part of your
report, you have decided to use pivot tables to show the team details for each country.
1 HCLT108-1-Jan-June2023-T&L-W8-Memo-IM-V2-12042023
Module: Computer Literacy Advanced (HCLT108-1)
Week number (Date): 8,(13 April 2023)
Unit covered: Unit 11 and 12 ( Microsoft Excel 2021)
Instructions:
To enrich your learning experience at Boston even further, and to ensure that you are exposed to a
variety of resources in this module, announcements will be posted every week containing additional
materials or activities for you to work through.
It is important to note that these activities are neither compulsory nor weighted, but that it will be to your
advantage to participate. The purpose of the activities is to help you better understand the content of
your weekly unit/s of study, and it will assist in creating insight and deeper meaning.
Activity 6 is based on Units 11 and 12 of the prescribed study guide for this module.
You are required to do your own research and attempt to answer the questions below.
Question 1 9 marks
You have been provided with the attached spreadsheet with research data on Hockey team members
from different countries. You are requested to provide an analysis report on this data. As part of your
report, you have decided to use pivot tables to show the team details for each country.
1 HCLT108-1-Jan-June2023-T&L-W8-Memo-IM-V2-12042023