Computer Applications
Technology
Practical Assessment Task
(PAT)
Grade 12 - 2019
PHASE 2
Name: Mandy Deetlefs
Hand in date: 10 May
2019 20Febuary
,Mandy Deetlefs 12AE3 Phase 2 Task 1 Topic 1
Statement of Authenticity
I Mandy Deetlefs hereby declare that the attached submission for my CAT PAT
2019 is my own work, and that all materials used, quoted or copied have been
correctly referenced.
I understand that if I am found guilty of plagiarism, I will be subject to various
disciplinary measures, including possible exclusion from final exams
Candidate’s Signature: ______________________________
Date: __________10/05/19_________
Scenario:
TOPIC 1: PLAN AN OVERSEAS TRIP
Overseas educational trips hold enormous value! Plan a 14-day overseas
trip for a group of six people. Adhere to the following:
Your trip must include a visit to a factory of your choice.
Your trip may include visits to other parts of the country without specific
educational focus.
The 14 days must include your travel time.
You do not have to include preparation details for the travels such as
passports, visas etc. – only plan the trip itself.
2|Page
, Mandy Deetlefs 12AE3 Phase 2 Task 1 Topic 1
Questions Evidence of the For internet For internet questions
information found evidence
only
1. What
Source 1: Magazine
IMG_0700.jpg
N/A N/A PowerPoint: I will include options found from the magazine
in the presentation so the clients will have a visual idea/
country does
the clients want IMG_0701.jpg more clarity of each choice.
Word: I will include options found from the magazine in a
to travel to? IMG_0702.jpg Questionnaire by making use of a drop down list for the
IMG_0703.jpg clients to fill in. It will be sent to them via email, making
use of mail merge.
IMG_0704.jpg Excel: I will use the results of the questionnaire to make a
pie chart for visual analysis. I will also use this information
to comply an accurate budget by making use of excel using
the functions =SUM. I will make use of the =COUNTIF and
=MODE function to count how many voted for a particular
country. Once I have confirmation on the destination, I can
then set up a daily agenda and make use of conditional
formatting to ensure readability of information.
Access: The results on the Questionnaire will be recorded
in a table that will be used to create a form as well as a
report using the functions AVG, MIN, MAX.
2. How
Source 2: Internet Article title: Flights from Excel: I will determine the most expensive, cheapest and the
Screenshot (23).png https://ww Johannesburg (JNB) to average price using =MAX, =MIN, =AVERAGE functions. I
many days will London Heathrow (LHR) will use the cheapest flight’s price and add it to the budget
they spend w.travelstar
t.co.za/sear | Emirates South Africa [Function: =SUM] to calculate the total expenses. I will also
travelling? make use of a line graph to show the variation of prices of
ch-results/in
ternational/ Date created: N/A the flight prices found. The results will also be included in
return Date updated: N/A the calendar and conditionally formatted to ensure
readability.
Readability rating: 7/10
Reliability rating: 6/10
3|Page
Technology
Practical Assessment Task
(PAT)
Grade 12 - 2019
PHASE 2
Name: Mandy Deetlefs
Hand in date: 10 May
2019 20Febuary
,Mandy Deetlefs 12AE3 Phase 2 Task 1 Topic 1
Statement of Authenticity
I Mandy Deetlefs hereby declare that the attached submission for my CAT PAT
2019 is my own work, and that all materials used, quoted or copied have been
correctly referenced.
I understand that if I am found guilty of plagiarism, I will be subject to various
disciplinary measures, including possible exclusion from final exams
Candidate’s Signature: ______________________________
Date: __________10/05/19_________
Scenario:
TOPIC 1: PLAN AN OVERSEAS TRIP
Overseas educational trips hold enormous value! Plan a 14-day overseas
trip for a group of six people. Adhere to the following:
Your trip must include a visit to a factory of your choice.
Your trip may include visits to other parts of the country without specific
educational focus.
The 14 days must include your travel time.
You do not have to include preparation details for the travels such as
passports, visas etc. – only plan the trip itself.
2|Page
, Mandy Deetlefs 12AE3 Phase 2 Task 1 Topic 1
Questions Evidence of the For internet For internet questions
information found evidence
only
1. What
Source 1: Magazine
IMG_0700.jpg
N/A N/A PowerPoint: I will include options found from the magazine
in the presentation so the clients will have a visual idea/
country does
the clients want IMG_0701.jpg more clarity of each choice.
Word: I will include options found from the magazine in a
to travel to? IMG_0702.jpg Questionnaire by making use of a drop down list for the
IMG_0703.jpg clients to fill in. It will be sent to them via email, making
use of mail merge.
IMG_0704.jpg Excel: I will use the results of the questionnaire to make a
pie chart for visual analysis. I will also use this information
to comply an accurate budget by making use of excel using
the functions =SUM. I will make use of the =COUNTIF and
=MODE function to count how many voted for a particular
country. Once I have confirmation on the destination, I can
then set up a daily agenda and make use of conditional
formatting to ensure readability of information.
Access: The results on the Questionnaire will be recorded
in a table that will be used to create a form as well as a
report using the functions AVG, MIN, MAX.
2. How
Source 2: Internet Article title: Flights from Excel: I will determine the most expensive, cheapest and the
Screenshot (23).png https://ww Johannesburg (JNB) to average price using =MAX, =MIN, =AVERAGE functions. I
many days will London Heathrow (LHR) will use the cheapest flight’s price and add it to the budget
they spend w.travelstar
t.co.za/sear | Emirates South Africa [Function: =SUM] to calculate the total expenses. I will also
travelling? make use of a line graph to show the variation of prices of
ch-results/in
ternational/ Date created: N/A the flight prices found. The results will also be included in
return Date updated: N/A the calendar and conditionally formatted to ensure
readability.
Readability rating: 7/10
Reliability rating: 6/10
3|Page
