Presentation
CAT PAT Phase 3
- Institution
- 12th Grade
This document is my Phase 3 of the CAT PAT completed in 2019. I received 98% for Phase 3, and a final mark of 98% for my entire PAT. The other phases are also linked.
[Show more]
1 review
By: thomanitshigabe • 2 year ago
Content preview
Computer Applications TechnologyPractical Assessment Task (PAT)
Grade 12 - 2019
PHASE 3
Name: Mandy Deetlefs
Hand in date: 2 August 2019
20Febuary
,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: __________02/09/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.
,TABLE OF CONTENT:
Statement of Authenticity __________________________________________________________ 2
Table of figures ___________________________________________________________________ 4
Introduction _____________________________________________________________________ 6
Task definition__________________________________________________________________ 6
Task Description and Solution _______________________________________________________ 7
TASK DESCRIPTION ______________________________________________________________ 7
Phase 1 _______________________________________________________________________ 7
Phase 2 _______________________________________________________________________ 9
Screen captures: _________________________________________________________________ 11
PowerPoint ___________________________________________________________________ 11
Word ________________________________________________________________________ 13
Excel ________________________________________________________________________ 20
Access _______________________________________________________________________ 46
Conclusion ______________________________________________________________________ 71
Self-Evaluation/ Future Developments ________________________________________________ 71
Bibliography& Referencing: ________________________________________________________ 73
3
I, Mandy Deetlefs, declare this is my own work.
,Table of figures
Figure 1 Completing the presentation .................................................................................................. 11
Figure 2 Planning presentation in PowerPoint ..................................................................................... 11
Figure 3 Adding transitions to presentation ......................................................................................... 12
Figure 4 Recording of the presentation ................................................................................................ 12
Figure 5 Creating my task definition and main question ...................................................................... 13
Figure 6 Compiling 20 different questions............................................................................................ 14
Figure 7 Clients' Email Addresses.......................................................................................................... 14
Figure 8 Conducting research for task .................................................................................................. 15
Figure 9 Framework of packages .......................................................................................................... 16
Figure 10 Summary of ideas for each package ..................................................................................... 16
Figure 11 Integrated ideas for packages ............................................................................................... 17
Figure 12 Composing of Email .............................................................................................................. 17
Figure 13 Emails conducted using mail merge ..................................................................................... 18
Figure 14 Setting up of Questionnaire .................................................................................................. 18
Figure 15 Restricted editing of graph ................................................................................................... 19
Figure 16 Password requirement.......................................................................................................... 19
Figure 17 Changing Tab colours ............................................................................................................ 20
Figure 18 Data from Questionnaire Sheet ............................................................................................ 20
Figure 19 No gridlines ........................................................................................................................... 21
Figure 20 Prices sheet alterations ......................................................................................................... 21
Figure 21 Formula used to convert currencies ..................................................................................... 22
Figure 22 Remove gridlines................................................................................................................... 22
Figure 23 COUNTIF calculation and formula......................................................................................... 23
Figure 24 Country Chosen Graph .......................................................................................................... 23
Figure 25 Changing Data Types ............................................................................................................. 24
Figure 26 Formatting axis...................................................................................................................... 24
Figure 27 Budget Sheet ......................................................................................................................... 33
Figure 28 Custom Formatting ............................................................................................................... 33
Figure 29 VLOOKUP function used in Budget ....................................................................................... 34
Figure 30 Nested IF function used + cell referencing ........................................................................... 34
Figure 31 Formatting............................................................................................................................. 35
Figure 32 VLOOKUP function in Budget Sheet ...................................................................................... 35
Figure 33 Use of Cell Styles ................................................................................................................... 36
Figure 34 SUM function ........................................................................................................................ 37
Figure 35 Merging Cells in Budget Sheet .............................................................................................. 37
Figure 36 Formulas................................................................................................................................ 38
Figure 37 Conditional Formatting ......................................................................................................... 38
Figure 38 Remove gridlines + SUM function......................................................................................... 39
Figure 39 Linking Prices sheet to Budget .............................................................................................. 39
Figure 40 AutoFill .................................................................................................................................. 40
Figure 41 Working with columns as a whole ........................................................................................ 40
Figure 42 Freezing Columns and Rows ................................................................................................. 41
Figure 43 Conditional formatting added to Calendar .......................................................................... 42
Figure 44 Custom formatting the Date ................................................................................................. 43
Figure 45 Inserting Days Name Range .................................................................................................. 44
Figure 46 Inserting Expense Name Range ............................................................................................ 44
4
,Figure 47 Inserting Dates Name Range ................................................................................................. 45
Figure 48 Inserting Primary Key ............................................................................................................ 46
Figure 49 Using different Data Types.................................................................................................... 47
Figure 50 Importing data from Excel .................................................................................................... 47
Figure 51 Changing format of hours ..................................................................................................... 48
Figure 52 Yes/ No Data type ................................................................................................................. 49
Figure 53 Input Mask ............................................................................................................................ 49
Figure 54 Sorting Data .......................................................................................................................... 50
Figure 55 Formatting Table ................................................................................................................... 50
Figure 56 Various Data Types for Table 3 ............................................................................................. 51
Figure 57 Using Transpose Special Paste option .................................................................................. 51
Figure 58 Import Excel file .................................................................................................................... 52
Figure 59 Using Boolean operators....................................................................................................... 52
Figure 60 Using LookUp Wizard as Data Type ...................................................................................... 53
Figure 61 Change format of date and created Input Mask................................................................... 54
Figure 62 Relationship formed into a report ........................................................................................ 56
Figure 63 Not displaying all fields ......................................................................................................... 57
Figure 64 Creating Criteria .................................................................................................................... 58
Figure 65 Using calculation in Queries.................................................................................................. 59
Figure 66 Changing Format of field....................................................................................................... 60
Figure 67 Using Boolean Operators ...................................................................................................... 62
Figure 68 Creating criteria .................................................................................................................... 63
Figure 69 Formatting Form ................................................................................................................... 64
Figure 70 Making use of different labels and buttons .......................................................................... 65
Figure 71 Improving presentation of form ........................................................................................... 66
Figure 72 Switchboard created to switch amongst forms .................................................................... 67
Figure 73 Using calculations in report .................................................................................................. 68
Figure 74 Using calculations ................................................................................................................. 70
5
I, Mandy Deetlefs, declare this is my own work.
,Introduction
Task definition
1
In this task I will be acting as a travelling agent1, organizing a 14 day educational trip for 6 people.
This should include a trip to a factory chosen by me as well as other non-educational facilities. This
will be planned using various methods of formatting on database and excel.
2
The prescribed 6 travelers have provided me with a budget. This should include the flights (return),
all accommodation, transport and activities.
3
To ensure that it is a trip of a lifetime for the travelers, I will firstly need feedback from the clients in
order to organize the data into meaning information using Microsoft Word [to make a questionnaire
and also an email to all the clients making use of mail merge], Excel [to draw up an appropriate
budget and the daily agenda/ calendar] Database [to compare the data in Word by making a query,
and a table providing suggestions towards the trip as well as all the information behind it] and lastly
PowerPoint [used in the meeting to display the different factory options as well as the different
destinations the clients can visit in the country].
4
My solution will be to ensure that the clients do not stress about the trip by ensuring I stick to the
correct budget and they are presented with a luxurious trip of a lifetime. I will make use of different
sources in order to retrieve the data required.
Found in Phase 1
1
A person whose job involves making the necessary arrangements for travelers.
6
,Task Description and Solution
TASK DESCRIPTION
Phase 1
Process& Development:
During Phase 1, my aim was to gather as much detailed and sufficient information as possible all
relating to the trip overseas. This was done by using different sources for my research. These sources
included:
• Magazine
• Internet
• Survey
• Local Citizens
• Reviews
• Previous Visitors
• Social Media
These sources helped me compile 20 questions that would be answered by the 6 clients to ensure
they were notified of all necessary elements with regards to their trip to the UK. I organized them
into the following subheadings: Factual Questions, Investigative Questions; Change Questions;
Comparison Questions. These questions would not only help the clients be included in the decision
making, but that they were all happy with the decisions made. The questions consisted of closed and
open-ended questions. There was a variety of options to choose from which allowed each client to
express their own interests and individuality.
Once I compiled 20 different questions, I then stated how each one would be used in the following
packages:
o Word
o Excel
o Access
o PowerPoint
Throughout this phase, I made use of various typography techniques (themes, alignment etc.) to
maximize the readability of the document. I also made my own themes and used page/ section
breaks to prevent Orphan lines in my tables.
7
I, Mandy Deetlefs, declare this is my own work.
, Obstacles I encountered
One of the biggest issues I had was ensuring the reliability of each source. Most sources (especially
from the Internet) are often outdated due to things constantly evolving and improving around the
world. I couldn’t find exactly what I was looking for to receive reliable data that I could optimally use.
To overcome this I made sure I used a variety of different sources to ensure that my data was open
ended. Another obstacle I encountered was when I imported some of my tables from Excel into
Access and I had to change the formatting which wasn’t always possible.
Method
Advantages:
The method I used allowed for me to easily compile 20 closed and open-ended questions. It made
the process of finding sources and then the converting them into accurate data much easier so that I
could plan the trip without any unanswered questions. Once I finished this phase, I was able to
already start planning the 2nd and 3rd phases of the trip.
Disadvantages:
The method I used often restricted me in terms of finding a lot of information. For example, I only
used one source per question and I had to ensure that each piece of information I found was reliable
and related to the trip overseas. Although I started well in advance, time was still a major factor
especially due to the fact that I made use of so many sources in this phase
8
, Phase 2
In Phase 2, my aim was to plan my 4 packages (Word, Excel, Access and PowerPoint) by sorting the
data found from my sources. In doing that, I was able to conduct how they would be used to solve
my main question.
A. Task 1: Firstly, I gathered all data and information found from my different sources. I made
sure that all evidence was included to prove all my information was reliable and trustworthy.
I did this by taking screenshots and then using hyperlinks to link them to my Phase 2. If I
used the Internet as my source, I copied and pasted the URL so that the clients could refer
back to the websites I made use of. I also stated the article title, the date of creation, date it
was last updated as well as my personal opinion of the reliability and readability of each
website.
Secondly, I explained in detail how I would integrate the information I found into the
different packages for each question. This helped me to stay organize and remind myself of
the purpose of each question.
B. Task 2: During this stage, I had all the necessary information to plan and create a framework
for Phase 3. I stated each question that was going to be used in Word, Excel, Access and
PowerPoint. With this, I included the name/sheet/etc. that you would find the information
in. I found it vital to state everything I was going to use to ensure the typography was
adequate enough for the clients. This included the calculations, formatting etc. I grouped
each element by the tabs they are found in so it would be more convenient when compiling
the documents.
Obstacles I encountered
A challenge in this Phase was to indicate how I would utilize each question into the different
packages. I found it difficult to decide whether or not I would be able to optimally make use of each
question and where I would use it to ensure it would have maximum impact. Another challenge I
picked up was the amount of work I gave myself. By choosing 4 packages, I had to plan even more to
ensure each package would serve its purpose.
Method:
Advantages:
In this phase, I grouped the work so that I could finish one section at a time. This prevented me from
forgetting to do something and helped me to plan efficiently and effectively. There was a lot to plan
and think about and therefore I had to be productive. Another advantage was the fact that I made
use of the template given. This did not only help me finish the task on time, but it made it a lot
easier to structure my work in such a way that it made the planning a lot more effective. I was able
to maintain a flow in the data that I processed into data using the various packages.
9
I, Mandy Deetlefs, declare this is my own work.
, Disadvantages:
Throughout my method, I struggled to compile different excel and access sheets due to the fact that
the data analyzing process required me to sort the data into different subheadings (Transport,
Destinations etc.). The open-ended questions were difficult to sort because each person had their
own opinion on each question. This increased the workload as I realized that I would need to
compile many tables, queries etc.
Factories
One of the elements the clients requested was going to a factory that was enriched with educational
values. In order to ensure that this was a possibility, I had to do some extensive research to find
something fun and exciting, but would still fit into the demands of the tight budget. This research
was found from of the internet and previous visitors. To make my job easier, I included the top picks
I found in the Questionnaire so that I could
Transport
Next what I had to consider was how the clients would get from one place to the next. To find
information, I made use of a combination of the internet, surveys and previous visitors to find what I
was looking. These options were then incorporated in the Questionnaire so that the clients could
choose which one would be more convenient for them in terms of comfort and the budget
limitations.
Airlines
With transport, a big question mark was which Airline would be most suitable for the trip to England.
I had to consider how long the flights were as well as the costs. I found my information on this topic
by making use of Google. To decide, I chose the top 6 cheapest flight prices that I could find on
www.travelstart.com. Once that was completed, I included this in the Questionnaire so that I could
receive input from the clients themselves so that they were comfortable with the flight hours and
prices.
10
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 R1.200,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