Presentation
CAT PAT
- Institution
- 12th Grade
This document contains phase 2 of the CAT PAT required in 2019. It covers majority of what is expected in the document and how to lay it out.
[Show more]
Content preview
Computer ApplicationsTechnology
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
The benefits of buying summaries with Stuvia:
Guaranteed quality through customer reviews
Stuvia customers have reviewed more than 700,000 summaries. This how you know that you are buying the best documents.
Quick and easy check-out
You can quickly pay through EFT, credit card or Stuvia-credit for the summaries. There is no membership needed.
Focus on what matters
Your fellow students write the study notes themselves, which is why the documents are always reliable and up-to-date. This ensures you quickly get to the core!
Frequently asked questions
What do I get when I buy this document?
You get a PDF, available immediately after your purchase. The purchased document is accessible anytime, anywhere and indefinitely through your profile.
Satisfaction guarantee: how does it work?
Our satisfaction guarantee ensures that you always find a study document that suits you well. You fill out a form, and our customer service team takes care of the rest.
Who am I buying this summary from?
Stuvia is a marketplace, so you are not buying this document from us, but from seller mandylee14. Stuvia facilitates payment to the seller.
Will I be stuck with a subscription?
No, you only buy this summary for R400,00. You're not tied to anything after your purchase.
Can Stuvia be trusted?
4.6 stars on Google & Trustpilot (+1000 reviews)
53340 documents were sold in the last 30 days
Founded in 2010, the go-to place to buy summaries for 14 years now