Computer Application Technology PAT GR 12 2022 Learner Guidelines Eng

Downloaded from hlayiso.com COMPUTER APPLICATIONS TECHNOLOGY GUIDELINES FOR PRACTICAL ASSESSMENT TASKS LEARNER GUIDELINES 2022 These guidelines consist of 58 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 2 DBE/PAT 2022 NSC TABLE OF CONTENTS 1. What is the PAT? 4 2. Mark allocation 5 3. The topic 6 4. Overview of tasks 10 5. General 10 6. What you will need to complete the PAT 11 7. Dishonesty 11 8. Non-compliance 11 9. Preparation 12 10. Instructions for Phase 1 13 11. Instructions for Phase 2 23 12. Instructions for Phase 3 29 APPENDIX A: ASSESSMENT TOOLS 33 APPENDIX B: STYLE GUIDE FOR WORD PROCESSING DOCUMENTS 55 APPENDIX C: LEARNER DECLARATION OF AUTHENTICITY 56 APPENDIX D: SAMPLE OF QUESTIONS AND SOURCES TABLE (PHASE 1) 57 APPENDIX E: K-W-L-S CHART 58 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 3 DBE/PAT 2022 NSC TABLE OF FIGURES FIGURE 1: Data security and privacy in the digital age 6 FIGURE 2: Teenagers on social media 7 FIGURE 3: Example of Questions and Sources table 15 FIGURE 4: Levels of questions 16 FIGURE 5: Questions and Sources table with a question and relevant details added 16 FIGURE 6: Example of bibliographical information needed for a website 17 FIGURE 7: Example of bibliographical information needed for printed media 17 FIGURE 8: Example of Questions and Sources table with bibliographical information added 18 FIGURE 9: Criteria for checking the quality of information on websites 18 FIGURE 10: Example of Questions and Sources table with an example of criteria for quality information added 19 FIGURE 11: Example of Questions and Sources table showing summarised information 20 FIGURE 12: Example of Questions and Sources table showing links to summarised information 21 FIGURE 13: Levels of complexity of spreadsheet functions 26 FIGURE 14: Levels of complexity of database queries 27 Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 4 DBE/PAT 2022 NSC 1. What is the PAT? The PAT (practical assessment task) is an individual research project that involves extended independent work. It provides an opportunity for you to demonstrate the skills you have acquired in the subject in terms of your:  Research and information management skills  Ability to use software applications and technologies to produce quality outputs You will be provided with a very broad topic/scenario (see Section 3 – The topic) on which to base your PAT. You need to:  Analyse the broad topic/scenario and decide which issue/challenge/opportunity best aligns with your interests and where you believe you can find most data  Provide a short description of the problem and the task  Produce a single, clear, researchable focus question that will guide you through the task  Produce a set of high-quality questions in order to begin and guide you through the investigation  Search for, identify and evaluate possible sources of information to answer the questions you have formulated  Gather quality information from the sources you have identified  Set up a survey/questionnaire in order to gather additional data related to the task  Design and create a spreadsheet and database which reflect the management, processing and analysis of all the data and information  Create a report regarding your investigation with information that has been sifted, evaluated and summarised to present your findings  Design a simple website which conveys information about the topic you investigated and your findings The PAT will be done in THREE phases over the first THREE terms of the Grade 12 year: Phase 1: Define the task and find, access and evaluate information needed to complete the task Phase 2: Process data and information Phase 3: Present information, solution, findings and conclusions Your teacher will provide you with dates and deadlines for each phase. These are determined by the provincial and district structures of the education department. In the absence of a valid reason, non-compliance with the dates set could lead to you not being awarded the marks for the particular phase. Valid reasons for not timeously completing the phases of the PAT include the following:  Illness, supported by a valid medical certificate issued by a registered medical practitioner  Humanitarian reasons, which include the death of an immediate family member, supported by a death certificate  Your appearance in a court hearing, which must be supported by written evidence  Any other reason that may be accepted as valid by the head of the assessment body or his/her representative Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 5 DBE/PAT 2022 NSC NOTE: The three phases are designed to ultimately combine to produce a word-processed report and a website that contain your findings and conclusions. Each phase therefore 'feeds' into the next phase. The development of the final report starts in Phase 1 and is added to and refined as you complete the phases. It is therefore critical to view the task as a series of linked tasks, so you need to picture or 'imagine' what your final 'product' or report will look like and manage your time appropriately. 2. Mark allocation NOTE: The PAT counts 25% of your final Grade 12 mark for CAT. It is therefore crucial that you strive to produce work of a high standard. PHASE FOCUS MAXIMUM PERCENTAGE MARK (%) Phase 1 Find and access data and information 32 21% Phase 2 Process data and information 44 29% Present information/solution 70 47% Phase 3 Present information/solution – General 4 3% TOTAL 150 100% NOTE: The final PAT mark is a compulsory component of the final certification mark (100) for all candidates registered for Computer Applications Technology. Carefully read and take note of the sections referring to 'Dishonesty' (Section 7) and 'Non-compliance' (Section 8). Your PAT could be moderated by provincial subject advisors and a sample could also be quality assured by Umalusi. NOTE: You need to complete and hand in any outstanding work for the PAT at least three weeks before the final CAT practical examination. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 6 DBE/PAT 2022 NSC 3. The topic PROTECTION OF PRIVACY1 WHEN USING ICTs Figure 1: Data security and privacy in the digital age In this age of information technology most people frequently use digital devices and social media platforms for communicating, socialising, performing financial transactions, finding information, etc. It has become easy to share data, making information available and accessible to those who want it. Although ICTs have made our daily lives convenient and have placed information within easy and immediate reach of most people, we have to be aware of some of the potential challenges that arise from this progress. While we share information and transact over the internet, our private information may be made available to others, often without us realising the extent of our loss of privacy. This takes place in the following ways:  People are often required to accept terms and conditions when downloading apps which may require them to share their private data in exchange for such apps.  One is also often asked to accept cookies while browsing the internet, which will personalise content, add advertising, provide social media features and analyse how a website is used. When these cookies are accepted, you give consent to the processing and use of your personal data, which may include sharing your data with third parties.  Hidden data collection or unknown technical processes in smartphones could lead to less privacy, especially with regard to the Internet of Things (IoT).  Apps can ask for access to your location information so that they can deliver accurate information to you when you request directions to a specific place or you want to know what the weather conditions are in a specific area, etc.  Information can be made available to third parties for advertising, marketing or other purposes. Not all people know what their private data can be used for in the case of a privacy breach. We can keep our networks safe by putting protection mechanisms in place, e.g. by installing firewalls on personal computers, but this is not possible on mobile devices such as tablets and 1 The term 'privacy' in these PAT Guidelines refers to the privacy of personal information throughout. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 7 DBE/PAT 2022 NSC smartphones. Young people are often not well-informed about their online privacy and remain unaware of the challenges this exposure may bring. Governments around the world have become increasingly concerned over privacy breaches and have instituted laws to protect their citizens' private information, e.g. the POPI Act (POPIA) in South Africa. The POPIA refers to the Protection of Personal Information Act. Many people may not be aware of their legal rights as specified in this Act. The following aspects and issues, amongst others, related to ICTs may affect the privacy of users in some way:  Online transactions and financial privacy  Social media and youth privacy  POPI Act  Targeted marketing or advertising invading the privacy of people  Management of big data in respect of privacy  Internet of Things security and privacy  Privacy and the use of smartphones  Location information being shared could Figure 2: Teenagers on social media invade your privacy Your task is to:  Investigate how ONE or more of the aspects or issues mentioned above impact on the privacy of people on a national, provincial, local or school level  Your investigation should explore: o The extent to which the people in your investigation are affected by the possible loss of privacy and how they may be exploited unwittingly when using ICTs o The challenges and implications associated with the protection of privacy when using ICTs o How these challenges can be addressed and (partially) solved, by indicating how people can protect their privacy when using ICTs  Gather and analyse data relevant to the protection of privacy when using ICTs, e.g.: o Which measures you can put in place to protect your privacy when using ICTs o Which technology can protect your privacy while using ICTs o How many people are/have been affected by the loss of privacy (internationally, nationally and locally, etc.)  Identify possibilities that could address/solve the challenges posed by a loss of privacy when using ICTs  Identify a suitable audience (such as the government, a community forum, the school management team, your parents, fellow students) to whom you can present your research and findings in a report that they could use or implement. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 8 DBE/PAT 2022 NSC NOTE:  The focus of the PAT research must be on the protection of privacy when using ICTs.  Some data is generally better processed in a spreadsheet rather than a database, and vice versa. For this reason, you should use different data and statistics for the spreadsheet and for the database. In other words, your spreadsheet and database may NOT contain exactly the same data, where the spreadsheet is simply exported into a database table. (You may, however, use some of the spreadsheet data in the database, if it is relevant, as long as you add some more data to the database.)  The spreadsheet MUST ALSO contain data other than only the data gathered during your survey.2 LINKS to some relevant resources are listed below. These resources will help give you an idea of the type of research required. Although you may use the resources from this list, you must also include resources that you found on your own. 1. Putting the privacy paradox to the test: Online privacy and security behaviors among users with technical knowledge, privacy awareness and financial resources https://www.sciencedirect.com/science/article/pii/S0736585317307724 2. Big Data & Privacy: What's Really Going on with Your Personal Information? https://builtin.com/big-data/big-data-privacy 3. Your legal rights when your personal data gets leaked in South Africa https://businesstech.co.za/news/internet/229009/your-legal-rights-when-your-personal-data- gets-leaked-in-south-africa/ 4. Internet of Things and Privacy – Issues and Challenges https://ovic.vic.gov.au/privacy/internet-of-things-and-privacy-issues-and-challenges/ 5. The 'Privacy Paradox' in the Social Web: The Impact of Privacy Concerns, Individual Characteristics, and the Perceived Social Relevance on Different Forms of Self-Disclosure https://academic.oup.com/jcmc/article/19/2/248/4067550 6. Outdoor location tracking of mobile devices in cellular networks https://jwcn-eurasipjournals.springeropen.com/articles/10.1186/s13638-019-1459-4 7. What is behavioral targeting? https://www.lotame.com/what-is-behavioral-targeting/ 8. Data privacy or data protection in South Africa https://www.michalsons.com/blog/data-privacy-in-south-africa/150 9. South Africa's Protection of Personal Information Act, 2013, Goes into Effect July 1 https://www.natlawreview.com/article/south-africa-s-protection-personal-information-act-2013- goes-effect-july-1 2 Read the note about using 'external data' on page 24 and page 25. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 9 DBE/PAT 2022 NSC 10. Your Technology Is Tracking You. Take These Steps for Better Online Privacy https://www.npr.org/2020/10/09/922262686/your-technology-is-tracking-you-take-these-steps- for-better-online-privacy 11. Teens, Social Media and Privacy https://www.pewresearch.org/internet/2013/05/21/teens-social-media-and-privacy/ 12. Cookies: An overview of associated privacy and security risks https://resources.infosecinstitute.com/topic/cookies-an-overview-of-associated-privacy-and- security-risks/ 13. Privacy perception and information technology utilization of high school students https://www.sciencedirect.com/science/article/pii/S2405844018354926 14. 3 Major Internet Privacy Issues and How to Avoid Them https://securitytoday.com/articles/2019/09/03/3-major-internet-privacy-issues-and-how-to- avoid-them.aspx 15. Teen Social Media Statistics 2021 (What Parents Need to Know) https://smartsocial.com/post/social-media-statistics 16. What teens said about social media, privacy and online identity https://www.pewresearch.org/internet/2013/05/21/what-teens-said-about-social-media-privacy- and-online-identity/ 17. The IoT threat to privacy https://techcrunch.com/2016/08/14/the-iot-threat-to-privacy/ 18. Are teenagers really careless about online privacy? https://www.theguardian.com/technology/2013/oct/21/teenagers-careless-about-online-privacy 19. Teenage clicks: can teens protect their privacy on social media? https://webfoundation.org/2018/09/teenage-clicks-can-teens-protect-their-privacy-on-social- media/ 20. Microsoft Edge Privacy White Paper https://docs.microsoft.com/en-us/microsoft-edge/privacy-whitepaper/ 21. How to protect your privacy online https://us.norton.com/internetsecurity-privacy-protecting-your-privacy-online.html 22. Handy tips and tools for staying cyber secure http://www.icts.uct.ac.za/staying-cyber-secure 23. Privacy and Information Technology https://plato.stanford.edu/entries/it-privacy/ 24. Top 10 Ways to Protect Your Identity Online https://programs.online.utica.edu/resources/article/ten-ways-to-protect-your-identity Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 10 DBE/PAT 2022 NSC 4. Overview of tasks Phase 1 • Create a suitable folder structure. • Formulate a task definition and a focus question. (Planning and sourcing of • Draw up questions to guide the process/research. data and • Identify sources to find quality information. information, as • Identify the research methods you will use. well as critical • Perform background research. assessment of • Critically assess information sources. information • Start the final report. sources) • Hand in Phase 1. Phase 2 (Design and • Draw up and conduct a questionnaire/survey. implementation • Design and use a spreadsheet and database to of suitable analyse the survey results and other data/statistics tools for gathered. capturing and • Continue refining the final report as needed. analysis of • Hand in Phase 2. data) • Draw up findings, conclusions and recommendations Phase 3 in your own words. (Findings, • Complete the word processed report and create a conclusions and website to report on the process, findings and reporting) recommendations. • Hand in Phase 3. 5. General For this project, you are expected to hand in your own, original work. You will show that your work is original by signing the declaration of authenticity (APPENDIX C) after completing the PAT. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 11 DBE/PAT 2022 NSC 6. What you will need to complete the PAT To complete the tasks, you will need:  An office suite with the following software: o Word processing software o Spreadsheet software o Database software  An HTML editor (e.g. Notepad++) and a web browser (e.g. Edge, Chrome or Firefox)  Internet access to: o Find data and information o Administer electronic questionnaires, e.g. use e-mail to send questionnaires to respondents and receive completed questionnaires from respondents  Access to other sources, such as printed media (e.g. magazines, newspapers, brochures, textbooks) or other electronic material (e.g. e-books, e-articles)  Access to facilities to convert hard copies to electronic documents, e.g. scanner, digital camera, smartphone  Storage media to store and backup your work electronically, e.g. flash drive, rewritable CD/DVD 7. Dishonesty Since the PAT is an individual project that is part of your final promotion mark, you may NOT:  Get help from others without acknowledging this help  Submit work which is not your own  Lend your PAT work to other learners  Allow other learners to access or use your own material (this does not mean that you may not lend books to or borrow books from another learner, but you may not plagiarise other learners' research)  Include work directly copied from books, the internet or other sources without acknowledgement and recognition  Submit work typed or word-processed by another person The above actions constitute dishonesty, for which you will be penalised. 8. Non-compliance You will be given the opportunity to submit any outstanding work for the PAT as outlined in national and provincial documentation. NOTE: The absence of a PAT mark for CAT, without a valid reason, will mean that you will not receive a result for CAT at the end of Grade 12. This could influence the publication of your final Grade 12 results. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 12 DBE/PAT 2022 NSC 9. Preparation 1. Ensure that you understand the information management content, such as:  What a task definition is and how to formulate one  How to formulate a focus question  How to formulate research questions  Different types of information sources  How to evaluate information sources  What a questionnaire is and how to compile one  How to use application packages to process data and information  Know what data is best processed in which application  How to reference information and not commit plagiarism when compiling your report 2. Choose one or more aspects and issues related to privacy with the use of ICTs, based on the overall topic. Do some pre-reading regarding the aspects and issues before you start with Phase 1 in order to gain background knowledge about the aspects and issues and the challenges that they pose. 3. It could be helpful to complete a K-W-L-S chart after your pre-reading. See APPENDIX E. 4. Follow the instructions for each phase, create the documents requested and save them in the appropriate folders. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 13 DBE/PAT 2022 NSC 10. Instructions for Phase 1 The purpose of this phase of the PAT is to first create a suitable and logical electronic folder structure in which to store your work, and then to:  Determine what the problem is and what needs to be done – get 100% clarity  Decide what the focus of your investigation will be  Decide what data and information you will need for the project  Determine where the information (sources) could be found  Locate, evaluate and summarise the quality and relevance of information found in appropriate sources and add it to the report  Begin to design the structure and layout of the final word processing report to be completed in Phase 3 Create a suitable folder structure 1. Create an appropriate (electronic) folder structure in which to store your work as follows:  Create a main folder (your teacher may require you to name this in a specific way).  Within the main folder, each phase must have its own subfolder (you can/will add more subfolders to organise the work done in the different phases).  The names of the folders and files that you will store in them should be meaningful. NOTE:  All the documents that you create and the evidence that you collect must be saved in the appropriate folders.  The documents and folders must be organised in such a way that it is easy to navigate and find information.  It is your responsibility to ensure that you keep a backup copy of all your work at all times. Create a report Now start the report that will be used as the final product to communicate your findings and conclusions. Don't worry if you are unfamiliar with some of the 'headings'; you are simply putting together a 'skeleton' template or structure at this stage. You will add content (and other headings) to this report document throughout the course of the three phases of the PAT. 2. Create a word-processed report that contains the following:  A cover page A professional-looking, well-structured, custom-designed cover page using appropriate content controls in order to add: o Your name and surname o The name of your school o The subject name and the PAT topic o A content control for the abstract  An automatic table of contents  An automatic table of figures Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 14 DBE/PAT 2022 NSC  Headings You need to add the following provisional headings: Table of Contents, Table of Figures, Introduction, Task Definition, Focus Question, Discussion and Analysis, Findings, Conclusion, Bibliography and Appendices. NOTE: Some headings will not have any content until Phase 2 or 3.  An appendix under the heading Appendices you created in your report with a diagram or a screenshot showing the folder structure, including any subfolders, used for Phase 1. Give it a suitable heading such as 'Folder Structure' and paste the diagram or screenshot in this appendix.  An appendix with the declaration of authenticity that will be used during all the phases. HINTS:  Apply the word processing skills you have learnt to produce a professional-looking document. While you will only be formally assessed on these aspects after completing your report in Phase 3, take note now of the style guide in APPENDIX B of this document. This will save you a lot of time and effort at a later stage.  Save the report in a suitable subfolder in your 'Phase 1' folder. Define the task To show that you understand why you are conducting this investigation, you must be able to define, in your own words, what you will investigate and what you are required to do (±300 words or half a page in font size 12 pt as a guideline). This is called the task definition. 3. Your description should be added under the heading Task Definition (added in the previous section) and it must:  Provide a clear statement of the problem (current situation), i.e. why you are doing this investigation  Indicate the focus and the purpose of your investigation (desired outcome), i.e. give an overview of which of the aspects will be investigated and covered  Specify in broad terms how you will approach the task (study the requirements of the PAT and indicate how you intend to collect the data and information, manipulate it, etc.)  Identify a realistic target audience for the final report that will be drafted Considering the above, use the following questions to help you write your own task definition:  What is the current situation?  What will be the focus and purpose (desired outcome) of my investigation?  How will I go about the investigation considering all the PAT requirements?  Who is the target audience? NOTE: Keep in mind that (in the long term), when choosing the issue/challenge/ opportunity facing the sector, you will also need appropriate data and information (including a survey/questionnaire) which can be:  Processed using a spreadsheet  Captured and manipulated using queries and reports in a database Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 15 DBE/PAT 2022 NSC Determine the focus question To manage and complete the task, you must have a clear focus. 4. Considering the issue/challenge/opportunity facing the sector you have chosen and the requirements of the PAT, you need to set the focus for your investigation. To do this, you must set/ask ONE question (the focus question), which must clearly reflect what the main focus of your investigation will be. The 'answer(s)' to this question form(s) the 'solution' to the problem that will be reflected in your final report. This question should be added under the heading Focus Question (added in the previous section) and needs to be:  A single sentence (NOT two questions or a paragraph)  Clearly phrased, concise and researchable and must describe exactly the focus of the investigation within the broader issue/challenge/opportunity  Clearly relevant to/be the focus point of the chosen issue/challenge/opportunity Ask questions that will guide your investigation To solve the problem and answer the focus question, you need to ask more questions to help you find appropriate data and information. 5. First create a new appendix under the heading Appendices you created in your report. Give it a suitable heading, such as 'Questions and Sources Table', and create the following table (also see APPENDIX D): No. QUESTION QUESTION LEVEL CATEGORY TYPE OF BIBLIOGRAPHICAL QUALITY OF SUMMARY OF (1, 2, 3, 4) SOURCE INFORMATION INFORMATION INFORMATION FOUND FOUND 1 … … ... … … … … 10 Figure 3: Example of Questions and Sources table TIP: It might be useful to place this appendix in landscape format. NOTE: You will fill in the required information in the various columns in this table as you progress through Phase 1. 6. Read the focus question that you asked and need to answer. The focus question should guide you in identifying additional quality questions that will help you to find the data and information that you need. In other words, what else do I need to find out (and that I do not know) BEFORE I start this task? The K-W-L-S chart in APPENDIX E may help in this regard. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 16 DBE/PAT 2022 NSC 7. Compile and evaluate the list of questions (at least TEN) that show at least THREE of the four different levels of thinking, as follows: LEVEL TYPE OF LEVEL OR QUALITY OF QUESTION  Provide facts (who, when, where, what, how many, etc.)  Give direction to the investigation (why, how, etc.)  Support predictions or help with any changes, alternatives or variations (what if, if, etc.) Support your judgement or help to evaluate, critique, review or find meaning (would it  be better if, what recommendation, what would be best, etc.) Figure 4: Levels of questions NOTE: Fill in the questions (at least 10) and the level of each question in the source table, making sure that your (minimum of) TEN (10) questions collectively represent at least THREE of these four different types/levels. 8. Review your questions and categorise/group them under at least THREE categories. This is so that the information you gather in answer to these questions is logically grouped together. Add the category into which each question falls, e.g. 'Problem' or 'Solution', to the table. An example of a possible extract from this table (with the relevant details added) is shown below. NOTE: These categories will become headings, later in Phase 3. Some examples: Background: Why is privacy an important issue when using ICTs? Problem: Are people aware of the privacy options available to them when using ICTs? Impact: What are the possible results of a loss of privacy? Costs: What will it cost to ensure privacy when using ICTs for the individual? Solution: What can be done to address the possible challenges posed by a loss of privacy when using ICTs? NOTE: Do NOT use the examples above verbatim. QUESTION TYPE OF No. QUESTION LEVEL CATEGORY SOURCE (1, 2, 3, 4) 1 What is the most 2 Background … efficient way to conduct a survey? … … … ... … 10 … … … … Figure 5: Questions and Sources table with a question and relevant details added Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 17 DBE/PAT 2022 NSC 9. Rework or change the questions which you will then use to guide your investigation and finalise your list of:  At least TEN questions representing  At least THREE levels of questions types and  At least THREE categories of questions Identifying sources To solve the problem, you need to find and identify sources of data/information and gather quality data/information. 10. For EACH of the (minimum of) TEN questions you created (see point 7 on the previous page), locate sources to enable you to answer these questions by doing the following:  Identify a source to find the data/information for each question.  You must use the internet (at least TWO different websites) plus at least ONE other source, e.g. media (printed/electronic), such as newspapers, magazines, brochures, textbook, etc. or an expert (e-mail/interview), etc.  Provide bibliographical information for the sources you use (at least TWO websites and ONE other source) as follows: o For each website, record the following information: WEBSITE SOURCE Author(s)/Organisation/Publisher Smart Social Name of website and web page Teen social media statistics 2021 (What parents need to know) Date created/updated 25 February 2021 Date accessed 24 October 2021 URL https://smartsocial.com/post/social-media-statistics Figure 6: Example of bibliographical information needed for a website o For each other source, such as books and magazines, record the following information: OTHER SOURCE Author(s) Gogus A, Saygin Y Title of source Privacy perception and information technology utilization of high school students Date published/issued May 2019 Publisher Heliyon Figure 7: Example of bibliographical information needed for printed media Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 18 DBE/PAT 2022 NSC  Now add all this information in the appropriate columns in the Questions and Sources table you have created. Modify the table as needed. You can also add the bibliographical information as sources in the word processing document. A partial example of how you could go about it is shown below. TYPE OF NO. QUESTION BIBLIOGRAPHICAL INFORMATION … SOURCE 1 ... Internet/ Authors(s) Smart Social … Website Name of website/ Teen social media statistics 2021 … web page (What parents need to know) Date created/updated 25 February 2021 … Date accessed 24 October 2021 … URL https://smartsocial.com/post/social- … media-statistics 2 ... Magazine Author(s) Gogus A, Saygin Y … Title Privacy perception and information … technology utilization of high school students Date published May 2019 … Publisher Heliyon … 3 … Internet/ Authors(s) … Website Name of website/ … … web page Date created/updated … … Date accessed … … URL … … 4 … Internet/ … … Website Figure 8: Example of Questions and Sources table with bibliographical information added TIP: You can already enter these details as sources in your report document using the referencing functions of the word processing program using a style such as APA or Harvard. If the details are included in the sources of your report document, you may add the citation only, as shown above. The bibliography with all the details must be included in your Phase 1 document should you choose to include only the citation in this table. Once you have identified your sources (or during that process), you need to assess the potential quality of these sources of information in order to gather quality information. 11. For each of the THREE minimum sources you identified (at least TWO different websites plus at least ONE other source), you need to briefly evaluate the quality of the information using the following criteria: CRITERIA MOTIVATION/EXPLANATION Authority The 'validity' or 'credentials' of the publisher or author(s) Currency The date on which the material was published or updated Accuracy The correspondence of the information with other sources Objectivity Any presence of prejudice, bias, skewing of information, etc. Coverage How extensively the material covers the topic Figure 9: Criteria for checking the quality of information on websites NOTE: One-word sentences will NOT be accepted. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 19 DBE/PAT 2022 NSC 12. Now add all this information to the Questions and Sources table you created. Modify the table as needed. A partial example of how you could go about it is shown below and a more detailed version is provided in APPENDIX D. TYPE OF BIBLIOGRAPHICAL QUALITY OF INFORMATION NO. CATEGORY SOURCE INFORMATION FOUND 1 Smart Social The author is a leader in the field Authors(s) Authority of teen social media usage. Teen social media The article was Name of statistics 2021 (What published in website/ Currency parents need to 2020 reflecting web page know) the latest issues. Information provided corresponds with Date other sources created/ 25 February 2021 Accuracy and is also updated accurate in terms of providing ... Internet/ recent programs. Website There is no bias on the web page and the Date 24 October 2021 Objectivity information is accessed presented in a factual, objective fashion. https://smartsocial. The article com/post/social- provides media-statistics extensive coverage on a URL Coverage wide variety of issues about teen social media and privacy issues. 2 Authors(s) Gogus A, Saygin Y Authority … Title Privacy perception Currency and information technology utilization … ... of high school Magazine students Date May 2019 Accuracy … published Publisher Heliyon Objectivity … Coverage … 3 … … … … … Figure 10: Example of Questions and Sources table with an example of criteria for quality information added TIP: You can split the main table and create a separate table for the quality of the information if you find it easier to work with. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 20 DBE/PAT 2022 NSC Engage with and use data and information Now that you have identified and evaluated your potential sources of information, you can start to extract the relevant information and gain an understanding by summarising the information in your own words: 13. Gather all other information and data from the sources you identified, as follows:  Save a copy (screenshot/copied content) of each website that you intend to use in an appropriate folder. TIP: You can use a free online service, such as PrintFriendly.com, to capture and save the contents of a web page in a single (PDF) file. You can then open or import the PDF file to MS Word, depending on the version you have.  Process/Summarise the information to extract appropriate information that is relevant to your information requirements (you will need it to compile the final report in Phase 3).  Record/Save the information in ONE of the following two ways: i. Copy the information and paste it in the relevant cells in the last column of the Questions and Sources table you created (the 'Summary of Information Found' column). An extract of this type of table is shown below. SUMMARY OF TYPE OF BIBLIOGRAPHICAL QUALITY OF INFORMATION INFORMATION SOURCE INFORMATION FOUND FOUND Smart Social The author is a  Teen social leader in the field media statistics Authors(s) Authority of teen social media usage.  Helpful advice Teen social media The article was for teens Name of concerning statistics 2021 published in 2020 website/ Currency privacy (What parents reflecting the latest web page need to know) issues.  Helpful advice 25 February 2021 Information for building a provided positive digital Date corresponds with footprint created/ Accuracy other sources and updated is also accurate in Internet/ ... terms of providing Website recent programs. 24 October 2021 There is no bias on the web page and Date the information is Objectivity accessed presented in a factual, objective fashion. https://smartsocial. The article com/post/social- provides extensive media-statistics coverage on a wide URL Coverage variety of issues about teen social media and privacy issues. … … … … … … … … … … Figure 11: Example of Questions and Sources table showing summarised information Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 21 DBE/PAT 2022 NSC ii. Store the summarised information for each question in word processing files in an appropriate folder and add hyperlinks to the files in the last column of the Questions and Sources table you created ('Summary of Information Found' column). An extract of this type of table is shown below. Note the last column. TYPE OF BIBLIOGRAPHICAL QUALITY OF SUMMARY OF SOURCE INFORMATION INFORMATION FOUND INFORMATION FOUND Authors(s) … Authority … Hyperlink to summary 1 Name of website/ … Currency … Internet/ web page ... Website Date created/ … Accuracy … updated Date accessed … Objectivity … URL … Coverage … … … … … … … … … … … Figure 12: Example of Questions and Sources table showing links to summarised information NOTE: You may find that you still need additional sources, in which case you need to add them (as outlined in steps 10–12). Bear in mind that the information you finally add in the report needs to be suitably referenced, i.e. you may NOT commit plagiarism. Hand-in for Phase 1 Once you have completed Phase 1 of the project: 14. Submit a copy of your entire PAT folder to your teacher. The following should be in your Phase 1 subfolder: A single report document typed using a word processing application that includes the following:  A cover page with appropriate content controls to display your name and surname, the name of your school, the subject name and the PAT topic  The following provisional headings: Table of Contents, Table of Figures, Introduction, Task Definition, Focus Question, Discussion and Analysis, Findings, Conclusion, Bibliography and Appendices  Your task definition and focus question under the appropriate headings  An appendix with a diagram/screenshot of the folder structure for Phase 1  An appendix with the completed Questions and Sources table, with all the columns (see APPENDIX D in this document for an example) filled in, with:  A minimum of 10 questions, covering three categories of question types  Sources for each question (from at least TWO different websites plus at least ONE other source)  Appropriate bibliographical data for each question  An assessment of the quality of the sources for each of the questions  A summary of the content for each of the questions, either added in the table or in separate files with a hyperlink to each file  An appendix with the declaration of authenticity Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 22 DBE/PAT 2022 NSC NOTE: Apply the word processing skills you have learnt to produce the report. Take note of the style guide in APPENDIX B in this document. Your teacher will give you the date on which to submit your Phase 1 work for assessment. If you are unable to meet the deadline set, then you will need to provide a valid reason. Copy the report from this phase (Phase 1) to the relevant Phase 2 folder. Ensure that all electronic and/or hard copies of all documents/files are available and organised into a logical folder structure, clearly named and easy to find/navigate. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 23 DBE/PAT 2022 NSC 11. Instructions for Phase 2 The purpose of this phase of the PAT is to:  Design, create and administer a suitable questionnaire/survey to gain relevant insights from respondents in terms of the task  Create and use a suitably designed database and spreadsheet to analyse the data from the questionnaire/survey Creating a questionnaire and conducting a survey To collect data and information that will help answer your research questions and that you may not find in other documented sources, you need to create an electronic questionnaire. It needs to be skilfully and appropriately designed to ensure the easy and appropriate answering of questions, as well as accurate importing/capturing and processing of data and information. Remember that your survey needs to gather data that will help to answer the research questions. 1. The questions in the questionnaire should help you to gather data/information regarding peoples' perceptions or experiences (i.e. data/information not likely to be found in other sources, e.g. opinions and preferences). Brainstorm some topics whereby you can get feedback from people through a questionnaire regarding your specific focus question (from Phase 1). For some ideas, look at the examples on page 14. 2. Think of the options available to you in terms of how you are going to administer the questionnaire for at least 25 respondents, trying to reach a cross-section of people in terms of age, gender, etc. This can be done by:  Creating a questionnaire in a word processor and either e-mailing it (or placing a link online) or getting different people in your school to answer them (saved under different file names). Note that the questionnaire must be created in a word processor first (to be handed in even if it is ultimately going to be conducted online).  Printing and distributing copies of the questionnaire OR  Creating an online version of the questionnaire you created using a word processor or by using an online tool such as an editable PDF document, Google Forms or SurveyMonkey, etc. 3. Formulate at least FIVE questions, excluding biographical data (e.g. name, gender, age, area), as follows:  Ensure that all the questions are relevant and provide answers to questions that cannot be found in other sources.  Try to create questions where people can choose an answer from a list of possible answers (i.e. closed questions), as the responses to this type of question are often easier to record and process.  Keep in mind that processing the data from these questions will be done in either a spreadsheet or a database. Design your questions in such a way that they produce the appropriate data needed to answer the research questions.  Only include biographical data in your processing if it is relevant to the information needed to answer the research questions. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 24 DBE/PAT 2022 NSC 4. Design the layout of the questionnaire while bearing the following in mind:  It must suit the way in which it will be administered, e.g. use content controls/form fields to enable respondents to complete the questionnaire electronically and for you to easily save the data/information.  The questionnaire should be easy to interpret, with appropriate headings and clear instructions for users.  Related questions should be grouped together under relevant headings.  It must consist of a maximum of one page.  You need to use professional formatting and layout (e.g. appropriate word processing) techniques.  It is a good idea to get other learners to 'test' your survey to see whether it is easy. Remember that you should have at least 25 respondents. You need to store the completed questionnaires in an appropriate folder under Phase 2. In the case of an online survey, the results of these surveys must be downloaded and saved in an appropriate folder under Phase 2. Hard-copy questionnaires also need to be stored safely, preferably by scanning them and saving them in electronic format. Using the data from the questionnaire together with data from other sources  Identify data suitable for spreadsheet processing  Identify data suitable for database processing  Identify data from external sources that can be used in the spreadsheet or database Example: One of your research questions may be to find out how people are using the privacy settings on their devices when using social media. You designed some questions for your questionnaire to help you to answer this research question, e.g.:  Do you store passwords on your mobile device? Your respondents may choose ONE of the following answers: (1) Yes, encrypted OR (2) Yes, without encryption OR (3) No OR (4) I don't know. o You could perform various calculations using the data from your questionnaire, which gives you information from your respondents (e.g. how many users within your sample group store encrypted passwords on their devices). o You may want to compare these statistics with information about how people store passwords on their devices, locally, nationally or internationally. Use data from the internet or other sources that has been processed already. o Using these two sets of data may allow you to answer parts of your research question. Spreadsheets are better at processing 'number data', so you will not repeat the calculation of these percentages/differences, etc. in the database. o You are NOT required to obtain large amounts of external data, but rather to use some of the data already gathered. Decide on which of the data you have gathered will be better suited for processing in a spreadsheet and which of the data would be better suited for analysis and queries in a database. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 25 DBE/PAT 2022 NSC  In this same questionnaire you may want to find out which security settings are frequently used by the sample, and you may have included a question such as: o Which of the following security settings do you use on your smartphone? Your respondent may choose between the following options: (1) Screen lock OR (2) Password OR (3) Other – enter a setting.  Although this data could be obtained from the same questionnaire, it would be processed using a different application as it is not number data you are looking for.  You may wish to consider including more questions in your questionnaire to improve the quality of your research.  Biographical data should only be used in the processing if it adds to the quality of your research in a meaningful way. Process and analyse data in a spreadsheet You now need to process and analyse all data (such as the number of people affected, as well questionnaire data, etc.) that may require the use of a spreadsheet and worksheets within the spreadsheet. Use data suitable for spreadsheet processing, INCLUDING but NOT ONLY, data from the survey. 5. Create a spreadsheet with a meaningful file name and save it in an appropriate subfolder in the Phase 2 folder. 6. Capture/Import/Copy any suitable data you sourced in Phase 1 that you need to process AND the data from your questionnaire to this spreadsheet. Ensure that:  Only relevant, appropriate data from the questionnaire/survey data is captured  There are no processing errors/error indicators (formatting errors or inconsistencies) in the data 7. Design and format the spreadsheet with a good, user-friendly layout so that it is easy to read and interpret the data using appropriate formatting techniques:  Make sure the row and column headings/labels stand out, for example that they are formatted differently to other data  Use consistent colour, borders, wrapping and styles to format the spreadsheet  Ensure that the formatting makes it easy for anybody to interpret the data/results 8. Use filtering or sorting as needed on the data, as well as formulas and/or functions to process data and answer any data-related questions posed in Phase 1 (at least ONE from EACH level given on the next page): Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 26 DBE/PAT 2022 NSC LEVEL EXAMPLES OF FORMULAS/FUNCTIONS Simple functions that only use/include a single cell range, e.g. SUM, MAX, MIN, COUNT,  AVERAGE, MODE, MEDIAN, LEN, VALUE or a formula using any of the arithmetic operators ( +, – , * , / ) Functions that include a cell range and one other parameter/condition, e.g. ROUND, LARGE, SMALL, LEFT, RIGHT, CONCATENATE, COUNTIF, SUMIF OR  Calculations using a combination of arithmetic operators and brackets OR Calculations using a combination of any two simple functions from level  Functions that include a cell range plus two parameters/conditions, e.g. POWER, MID, FIND, COUNTIFS, SUMIFS, ROUNDUP, RANDBETWEEN or a simple IF-function or any of the DATE  and TIME functions OR Any combination of more than two functions of arithmetic operators, brackets and other functions  A LOOKUP or nested IF-function or functions not specified in the CAT CAPS curriculum Figure 13: Levels of complexity of spreadsheet functions NOTE: No marks will be awarded for functions that do not produce meaningful or relevant information. In other words, you must be able to use the information obtained from these formulas and functions as findings or partial findings and conclusions in your final report. If you are unsure of the level of functions, consult your teacher. Indicate to your teacher if you have used features/functions not in the curriculum. The types and complexities of spreadsheet functions and formulas needed are specified in more detail in the Assessment Instruments. 9. Summarise the results that you will use in the report on a separate worksheet within the same spreadsheet. 10. Create appropriate, meaningful graphs in your spreadsheet program that you will be able to use in your report to substantiate/support other information, claims or arguments, as follows:  Apply the skills that you have learnt in CAT and Mathematics/Mathematical Literacy when creating the graphs.  Use appropriate types of graphs, made understandable with appropriate legends, axis titles, data labels and other options, etc.  Ensure that the graphs are easy to read and interpret.  You must have at least two relevant graphs, although more might be useful. NOTE: You must be able to use the information obtained from these formulas, functions and graphs as findings or partial findings and conclusions in your final report. 11. Save the spreadsheet in your Phase 2 folder. Make sure that you use an appropriate file name. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 27 DBE/PAT 2022 NSC Process and analyse data in a database To enable further analysis of data and information you need to capture appropriate, relevant data in a database so that you can create queries and reports to support/substantiate the discussion of the problem or the recommendations/solutions. 12. Create a database with a meaningful file name and save it in an appropriate subfolder in the Phase 2 folder. 13. You need to create a table containing at least 5 fields to store data relevant to the tasks (e.g. other sources you identified in Phase 1 and from the survey), as follows:  At least one table must be created with suitable data for a database (NOT a direct import from the spreadsheet). Use only the data from your survey which is suitable for the database, as you have already used different data in your spreadsheet.  The table must contain at least 5 fields.  All fields must have an appropriate/meaningful name and a suitable/meaningful description.  Make sure that all fields contain single data units (e.g. separate fields for Name and Surname). 14. Use appropriate components/properties to ensure/promote accurate data capturing where appropriate, as follows:  All text fields must be set to appropriate sizes.  There must be at least one appropriate/meaningful validation rule and validation text.  There must be at least one appropriate/meaningful list/combo box.  There must be at least one appropriate/meaningful input mask. 15. Capture/Import/Copy at least 20 relevant records into the table. Ensure that:  Only relevant, appropriate data is added/captured  There are no formatting errors or inconsistencies in the data 16. Create queries (at least THREE) that will provide information that is meaningful or relevant to the task to process data and answer any data-related questions posed in Phase 1. Your queries (overall) need to show FOUR different levels of complexity, as follows: LEVEL COMPLEXITY OF QUERY  Only fields with 1 simple criterion (e.g. 'X', >X, =X, not 'X', Is Null) One field with combined criteria using conditions and relational operators (e.g. 'X' or 'Y', >1 and <10 or ranges such as 'Between 1 and 10')  OR One field with a criterion including wild cards ('*' or '?') Simple calculated field using arithmetic operators ( +, – , * , / )  OR Date and time functions/calculations Complex calculated field (e.g. SUM, MIN, MAX, AVG, COUNT) OR Queries that use Grouping  OR Queries that use logical (IF) functions or text functions OR Advanced functions that are not in the CAT CAPS curriculum Figure 14: Levels of complexity of database queries Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 28 DBE/PAT 2022 NSC NOTE: No marks will be awarded for calculations in queries that do not produce meaningful or relevant information. In other words, you should be able to use the information obtained from these calculations as findings or partial findings and conclusions in your final report. If you are unsure of the complexity levels of your queries, consult your teacher. Indicate to your teacher if you have used features/functions not in the curriculum. 17. Create a database report (at least ONE) which will provide information that is meaningful or relevant to the task to process data and answer any data-related questions posed in Phase 1. Your report must:  Be sorted according to at least one field  Be grouped appropriately on at least one field  Contain at least one meaningful calculation using a function in the report footer/group section NOTE: You must be able to use the information obtained from these queries and report(s) as findings and conclusions in your final report. Continue working on the report 18. Copy the report from Phase 1 to the relevant Phase 2 folder, if you have not done so already, and continue working on this report by adding your graphs under the Findings heading. You will need to expand this section (and other sections) in Phase 3. Hand-in for Phase 2 Once you have completed Phase 2 of the project: 19. Submit a copy of your entire PAT folder to your teacher. The following should be in your Phase 2 folder:  The original questionnaire you designed  A minimum of 25 completely answered questionnaires, saved in an appropriate folder under Phase 2. If you sent out your questionnaire using electronic media such as Google Forms or Survey Monkey, save a copy of the responses. If you used hard- copy questionnaires, they need to be scanned and saved in electronic format.  The completed spreadsheet with the analysis of the data, including graphs  The completed database with relevant queries and report(s)  Your updated report with your graphs added under the Findings section Copy the report from this phase (Phase 2) to the relevant Phase 3 folder. NOTE: Your teacher will give you the date on which to submit your Phase 2 work for assessment. If you are unable to meet the deadline set, you will need to provide a valid reason. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 29 DBE/PAT 2022 NSC 12. Instructions for Phase 3 The purpose of this phase of the PAT is to:  Interpret data and information, combine and remix the information to show your own understanding and insight and to answer the focus question  Complete the report by using good word processing principles and techniques  Create a website using HTML that takes into consideration appropriate layout, readability and other usability issues Report In order to communicate the knowledge and insight that you have gained, as well as the recommendations/solutions to the problem, you need to continue working on the report that you created in Phases 1 and 2 and add your findings and solutions. Use the data and information from Phase 2 and the understanding and insight that you have gained through your investigation to complete the report. Your report should, as a guide, consist of approximately 1 600–2 000 words (content only, excluding cover page, table of contents, references and graphics). Your report needs to be, as a guide, 6–8 pages long with the following sections:  A cover page  An introduction  Discussion and analysis  The findings and conclusions  Any appendices that are needed NOTE: You should use the graphs and database queries that you generated to enhance the discussion, analysis and findings in your report. Suitable headings must appear in these sections. The categories, created in Phase 1, now become headings. 1. Copy the report from Phase 2 to the relevant Phase 3 folder (if not done already). 2. Note that, over and above any specific instructions below, you need to apply the word processing skills you have learnt to produce a professional document. Take note of the style guide in APPENDIX B and the notes on referencing below: Referencing  Using the information in Phase 1, add an automatically generated reference list/ bibliography using the features of your word processor. Ensure that sources used are referenced clearly and appropriately.  All the information you need should be found in the (summary) documents you created in Phases 1 and 2.  Any graphics from other sources must be acknowledged clearly and appropriately.  Automatic, appropriate captions must be inserted correctly for all tables/figures.  Make sure that you do not plagiarise and use citations and/or footnotes appropriately using a referencing style such as Harvard or APA. NOTE: Your report must be written in your own words, except where information is correctly cited/acknowledged). You will be heavily penalised if you copy and paste large sections of text directly from the internet or any other source. Plagiarism is completely unacceptable. Be original and creative. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 30 DBE/PAT 2022 NSC 3. Complete the cover page.  You should have added a cover page in Phase 1. Ensure that you have a professional- looking, well-structured cover page using appropriate content controls, with: o Your name and surname o The name of your school o The subject name o The PAT topic you chose  Now add a meaningful abstract/extract in a suitable content control. An abstract is a brief summary (3–4 lines as a guideline) of the contents of the report. After reading the abstract, readers should be aware of the content of the report so that they can know, at a glance, whether or not they wish to read the full report. Note that the abstract is not an introduction to but rather an overview of the content and purpose of the report and should include a very brief mention of the findings. TIP: You are advised to recheck your abstract after you have completed the report. 4. Add an automatic table of contents and table of figures.  Add a provisional, automatically generated table of contents and table of figures once you have decided on the styles you are going to use for your headings.  Remember to update these tables once you have completed the report. 5. Write your introduction.  Give a clear overview and focus of the original problem.  Cleary state the focus and purpose of the investigation, pointing out which aspects you investigated.  Make sure you do not add any additional, unnecessary information. TIP: Consider your task definition and focus question when compiling your introduction but do not simply use them verbatim. 6. Discussion and analysis  You already have some headings added to your report, but you may need to add additional headings and subheadings to the report as this will allow you to group the relevant information together in a logical fashion.  Add information from Phases 1 and 2 (summaries, questionnaire, spreadsheet and database) and all information/data/graphics (tables, graphs, charts, pictures) as needed. Make sure the data and information added are relevant to the investigation.  Adding hyperlinks: o Hyperlinks/Bookmarks must be used to navigate to other websites and external documents, e.g. the spreadsheet and database from Phase 2. o Hyperlinks to these external data/information sources must be easy to locate and recognise/'understand'. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 31 DBE/PAT 2022 NSC 7. Formulating your findings  You need to formulate as least THREE appropriate claims, arguments or findings that are appropriate and relevant to the investigation (as guided by your focus question).  All these claims, arguments and findings must be: o Answers to your focus question and research questions o Supported by relevant, appropriate data/information/graphs/diagrams, etc. o Meaningful explanations of how or why the evidence supports these findings o Drawn from information presented in the report and address the original problem statement/focus in light of the evidence presented 8. Formulating your conclusion(s) Your conclusion(s) must:  Be meaningful and logical  Address the original problem statement/focus in light of the evidence presented The conclusion(s) should NOT contain new information that is not researched. 9. Once you have completed the report, do a final check in terms of the formatting and references covered in point 2 and remember to update the tables of contents and figures. Website In order to share the knowledge and insight you have gained with a broader audience, you need to create a website. This will serve as a 'summarised, visual' version of your report. Do not simply repeat the entire report in HTML format. 10. Create a website with a home page linked to at least TWO other web pages. Save it and all associated images in the relevant subfolder in your Phase 3 folder, using meaningful file names. 11. Your website should include at least the following:  A title  An introduction  A functional navigation system  Good quality information about the topic/your investigation, that is factually correct. The information should be structured for a website, using appropriate principles and techniques, such as headings, paragraphs, lists, horizontal lines, etc.  Graphics and/or images  Hyperlinks to other good quality information, where appropriate. These could also be the websites that you identified in Phase 1 as potential sources of information. 12. Ensure that your website is well laid out, readable and has a consistent appearance. It should be easy to skim/scan the website and to find important information. 13. Different elements/parts of the pages must be clearly distinguishable. 14. Graphics/Images should be relevant to the topic or purpose of the site, enhance understanding, display correctly and be of a high quality. They must be appropriately sized and cropped. It should also take into account visually impaired users. Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 32 DBE/PAT 2022 NSC 15. Use good Standard English and ensure there are no spelling or grammar mistakes. 16. Acknowledge information and graphics used from other sources appropriately.  The following link on how to insert a citation in word processing may be helpful: https://support.microsoft.com/en-us/office/create-a-bibliography-citations-and- references-17686589-4824-4940-9c69-342c289fa2a5  The following link on how to insert a citation in a website may be helpful: http://bit.ly/WebsitesHarvardReferencingGuide Hand-in for Phase 3 Once you have completed this phase of the project, submit a copy of your entire PAT folder to your teacher: The following should be in your Phase 3 folder:  The word processing report you completed in this phase  The website you created in this phase (home page linked to at least TWO other web pages), together with any resources needed for the website (graphics, etc.) NOTE: You also need to complete and hand in the final declaration (APPENDIX C). Your teacher will give you the date on which to submit your Phase 3 work for assessment. If you are unable to meet the deadline set, you will need to provide a valid reason. Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 33 DBE/PAT 2022 NSC APPENDIX A: ASSESSMENT TOOLS ASSESSMENT TOOL – PHASE 1 LEARNER'S NAME: ___________________________________________________________ DATE HANDED IN: ____________________ NOTE: This is a criterion-referenced tool and not a norm-referenced tool. The teacher MUST highlight or tick applicable criteria in the second column. The number of ticks in this second column does not always determine the mark obtained in columns 4 to 8. Relate the criteria to the mark, e.g. in item 1, if answers to all 4 questions are evident, then a mark of 4 is awarded. Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 1 TASK DEFINITION Clearly describes, in the learner's own words, the intention of the task/project (PAT), i.e. shows a thorough understanding of the problem (what the problem is), what he/she needs to investigate and why he/she is doing the investigation. Provides a clear overview of the focus of his/her investigation and the aspects to be investigated and covered, as well as how he/she will go about it, to whom it must be presented and how it must be presented.  What is the current situation? All 4 questions in the criteria Only 3 of the 4 questions in Only 2 of the 4 questions in Only 1 of the 4 questions in Not done OR  What will be the focus and purpose (desired clearly the criteria the criteria the criteria None of the outcome) of my investigation? answered and clearly clearly answered clearly criteria clearly  How will I go about the investigation, in the learner's own words answered and in the learner's and in the learner's own answered and in the learner's answered considering all the PAT requirements? 4 OR own words words own words  Who is the target audience for the final report? Any part of the (Target audience should be realistic) task definition not in the learner's own words Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 34 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 2 FOCUS QUESTION A clearly phrased, concise, researchable question that describes exactly what the focus of the investigation will be within the broader scenario and that is relevant to what was given in the task description. (Will clearly direct the investigation and provide an indication of the scope)  Clearly phrased, concise question All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects No focus question  Question will be researchable clearly present clearly present clearly present OR  Single sentence 4 No discernible  Clearly relevant to/focus point of the focus OR scenario/topic Not researchable 3 QUESTIONS – QUALITY (Questions to guide the research – This is NOT for the QUESTIONNAIRE.) A minimum of 10 questions, representing at least three of the four different levels (e.g. 'factual/closed', 'investigate/explore', 'predict/change', 'judge/evaluate') relevant to the topic, that will help to address the problem and provide a solution to the problem/focus question within the parameters of the PAT requirements, i.e. will provide qualitative as well as quantitative information. Questions are classified/categorised into a minimum of three groups.  All questions provided are relevant to the topic Clearly contains all Clearly contains 3 of the Clearly contains 2 of Clearly contains only None of the aspects have and will help to address the problem 4 aspects 4 aspects the 4 aspects 1 of the 4 been  Questions are representative of at least THREE aspects addressed different cognitive question levels 4  All questions are grouped/classified under categories  At least THREE different categories/groupings of questions Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 35 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 4 QUESTIONS – TECHNICAL ASPECTS Technical aspects such as number of questions and sources indicated. Learner identified a variety of sources (at least THREE sources).  Possible, appropriate source type (e.g. Clearly contains all Clearly contains 3 of Clearly contains 2 of the Clearly contains only None of the aspects have internet/printed media/people) indicated for each 4 aspects the 4 aspects 4 aspects 1 of the 4 been addressed question aspects  At least 10 questions included Number of sources, excluding questionnaire: 4  At least 2 websites identified as potential sources plus  At least 1 other source from another type/media (e.g. magazine, newspaper, brochure, textbook – printed or electronic format), e-mail/interview with an expert 5 SOURCES – BIBLIOGRAPHICAL INFORMATION Appropriate sources identified to answer questions and source details clearly indicated for at least THREE sources listed as required. Aspects/Criteria for websites: All applicable All applicable Applicable Some No source details  Authors(s) aspects addressed for aspects addressed for aspects addressed for at applicable aspects provided OR  Name of website/web page all 3 (minimum) at least 2 sources least 1 source addressed for at least No sources  Date created/updated sources OR OR 2 or 3 aspects 1 source provided  Date accessed 4 or 5 aspects addressed for at  URL 4 addressed for at least 3 least 2 sources Relevant aspects/criteria for other types of sources: sources  Authors(s)  Title  Date published  Publisher etc. Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 36 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 6 INFORMATION – EVALUATION Table completed for at least two websites and one other source, clearly evaluating the quality of the source and its contents by providing a clear, relevant motivation/explanation for each aspect. Aspects/Criteria: All aspects All aspects All aspects At least 2 of Only 1 of the  Authority clearly addressed addressed for at least addressed for at least 1 source the 5 aspects clearly 5 aspects clearly and correctly  Currency and correctly motivated/ 2 sources OR addressed and correctly done for all sources  Accuracy 4 explained for OR 4 or 5 aspects 2 or 3 aspects addressed for motivated/ OR  Objectivity all 3 sources addressed for 2 sources explained for all sources Not done for all  Coverage all 3 sources sources OR One-word answers 7 INFORMATION – SUMMARY Information from each source used is summarised in learner's own words. Summary gives information available in the source which is relevant to the topic and which will help to answer questions or is useful for solving the problem.  Summaries are completed for all the questions All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects clearly Only 1 of the 4 aspects None of the aspects clearly  Summaries give information available in the clearly present present clearly present present sources 4 OR  Information is relevant to the topic Not done  All summaries are in learner's own words Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 37 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 8 PHASE 1 DOCUMENT Single word processing document that contains all information required for Phase 1.  Single report document present Clearly contains all Clearly contains 3 aspects Clearly contains 2 of Clearly contains only No document  Minimum headings present: Table of Contents, 4 aspects the 4 aspects 1 of the Table of Figures, Introduction, Task Definition, 4 aspects Focus Question, Discussion and Analysis, Findings, Conclusion, Bibliography and Appendices 4  An appendix with a diagram/screenshot of the actual folder structure for Phase 1 is included  Evidence of sources available: Completed table of Questions and Sources table with all the columns is present TOTAL MARK FOR PHASE 1: 32 MARK OBTAINED Comment/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name: ____________________________________________ Teacher signature: __________________________ Date:______________________ Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 38 DBE/PAT 2022 NSC ASSESSMENT TOOL – PHASE 2 LEARNER NAME: _____________________________________________________________ DATE HANDED IN: ____________________ NOTE: This is a criterion-referenced tool and not a norm-referenced tool. The teacher MUST highlight or tick applicable criteria in the second column. The number of ticks in this second column does not always determine the mark obtained in columns 4 to 8. Relate the criteria to the mark, e.g. in item 1, if answers to all 4 questions are evident, then a mark of 4 is awarded. Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 1 QUESTIONNAIRE – QUALITY Well thought-out questionnaire that will provide answers to questions not likely to be found in other sources or that will lead to verifying, clarifying or supplementing other information. Some questions will also enable the processing of data using a spreadsheet and a database.  Clear instructions guide users in the answering Clearly contains all Clearly contains 3 of the Clearly contains 2 of Clearly contains 1 of No questionnaire OR of questions 4 aspects 4 aspects the 4 aspects the 4 aspects  Questions are relevant and mostly provide None of the 4 aspects clearly answers to questions that cannot be found in 4 present other sources or that supplement/verify/clarify  Questions enabled processing in spreadsheet and/or database  At least 25 completed questionnaires 2 QUESTIONNAIRE – TECHNICAL Electronically created questionnaire, professionally and appropriately designed for the way in which it will be administered (online, e-mail or printed) (e.g. created in a word processing program using appropriate principles and techniques such as controls/form fields or created in Google Docs or an editable PDF format) that will ensure easy and appropriate answering of questions as well as accurate importing/capturing and processing of data and information.  Form is created electronically, appropriate to the Clearly contains all Clearly contains 3 of the Clearly contains 2 of Clearly contains 1 of No questionnaire OR way it will be administered 4 aspects 4 aspects the 4 aspects the 4 aspects  Appropriate questions grouped together under None of the 4 aspects clearly relevant headings present 4  At least 5 questions, excluding biographical data such as gender and age  Professional formatting and layout (e.g. appropriate word processing techniques) Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 39 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 3 SPREADSHEET – TECHNICAL Well designed and formatted using appropriate formatting techniques (borders, shading, font alignment, etc.) with good layout and easy to read and interpret (row and column headings stand out). The format should contribute to readability, not hinder it.  Separate worksheet for results Clearly contains all Clearly contains 3 of the Clearly contains 2 of Clearly contains only No spreadsheet OR  Well-designed layout (headings and borders) 4 aspects 4 aspects the 4 aspects 1 of the None of the  Well formatted with appropriate, consistent 4 4 aspects aspects clearly formatting (e.g. freeze panes, conditional present formatting, absolute cell referencing)  Easy to read and interpret 4 SPREADSHEET – QUALITY Relevant data used. Processing is correct and relevant/appropriate and will answer questions, show trends/patterns, provide insights and contribute to the solution.  Data suitable to a spreadsheet was collected and Clearly contains all Clearly contains 3 of the Clearly contains 2 of Clearly contains only Most data not relevant is captured, excluding irrelevant biographical 4 aspects 4 aspects the 4 aspects 1 of the OR data 4 aspects  Analysis includes relevant, appropriate data Majority of the processing not other than responses from the respondents to relevant or the questionnaire/survey data 4 totally incorrect  Spreadsheet processing and analysis of data is suitable to the solution/Appropriate functions used  Functions applied and done correctly/No processing errors/error indicators/incorrect syntax Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 40 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 5 SPREADSHEET – GRAPHS At least TWO graphs that are relevant, meaningful and serve a purpose, are of the correct type and formatted to be easy to interpret (headings, labels, legends, etc.). The graphs will help to answer questions and contribute to the solution/explain aspects of the problem/solution.  At least one relevant, meaningful graph present, Clearly contains all At least 3 aspects At least 2 aspects At least 1 aspect No charts/graphs that will contribute to the solution 4 aspects included included included OR  A second relevant meaningful graph that will 4 None of the contribute to the solution 4 aspects are  Appropriate types of graph(s) and options used included  Graph(s) easy to read and interpret 6 SPREADSHEET – COMPLEXITY The following represent the four different levels of complexity of spreadsheet functions:  Simple functions that only use/include a single cell range, e.g. SUM, MAX, MIN, COUNT, AVERAGE, MODE, MEDIAN, LEN, VALUE or a formula using any of the arithmetic operators ( +, – ,*, / )  Functions that include a cell range AND one other parameter/condition, e.g. ROUND, LARGE, SMALL, LEFT, RIGHT, CONCATENATE, COUNTIF, SUMIF OR Calculations using a combination of arithmetic operators and brackets, or calculations using a combination of any two simple functions from level   Functions that include a cell range PLUS two parameters/conditions, e.g. POWER, MID, FIND, COUNTIFS, SUMIFS, ROUNDUP, RANDBETWEEN or a simple IF-function or any of the Date and Time functions OR Any combination of more than two functions of arithmetic operators, brackets and other functions  A LOOKUP or nested IF-function or functions not in the CAT CAPS curriculum  At least ONE meaningful calculation from level . Meaningful calculations Meaningful calculations Meaningful calculations Meaningful calculations No spreadsheet OR  At least ONE meaningful calculation from level . using using functions using using functions No relevant, functions from from any functions from from only 1  At least ONE meaningful calculation from level . all 4 levels 3 different levels any 2 different level meaningful processing done  At least ONE meaningful calculation from level . (, ,  (, ,  or ) levels (, ,  or (, ,  or 4 and ) ) NOTE: ) Any incorrect/meaningless aspect/function does NOT qualify for consideration. List any function (where applicable) used that is not part of the curriculum. Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 41 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 7 DATABASE – BASIC DESIGN Well designed and formatted with appropriate data types, field names, field descriptions and field properties. Each field contains one single piece of data (e.g. title, name, surname in three separate fields)  At least one table created with suitable data for a All 4 aspects clearly At least 3 of the 4 aspects At least 2 of the 4 aspects Only 1 of the 4 aspects No database OR database (NOT a direct import from the spreadsheet) present clearly present clearly present present  Table contains at least 5 fields None of the 4 aspects  All fields have appropriate, meaningful names and a 4 present suitable/meaningful description  All fields contain single data units (e.g. separate fields for Name and Surname) 8 DATABASE – VALIDATION Field properties/components to ensure accurate input/capturing of data  All text fields are set to an appropriate size All 4 aspects clearly At least 3 of the 4 aspects At least 2 of the 4 aspects Only 1 of the 4 aspects No table OR  There is at least one appropriate validation rule and present clearly present clearly present present None of the validation text 4 4 aspects  There is at least one appropriate list/combo box present  There is at least one appropriate input mask Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 42 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 9 DATABASE – PROCESSING At least 20 records, plus THREE relevant, meaningful and correct queries that will inform/support the problem/solution. NOTE: Incorrect/Meaningless queries or reports do NOT qualify for marks.  At least 20 appropriate, relevant records in one or All 4 aspects clearly At least 3 of the 4 aspects At least 2 of the 4 aspects Only 1 of the 4 aspects No database OR more tables present clearly present clearly present present  At least ONE relevant query that is correct and None of the 4 aspects meaningful and will inform/support the problem/ present solution/demonstrate understanding of appropriate links  A second other relevant query that is correct and 4 meaningful and will inform/support the problem/ solution/demonstrate understanding of appropriate links  A third other relevant query that is correct and meaningful and will inform/support the problem/solution/demonstrate understanding of appropriate links Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 43 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 10 DATABASE – COMPLEXITY OF QUERIES The following represent the four different levels of complexity of database queries:  Only fields with 1 simple criterion (e.g. 'X', >X, =X, not 'X', Is Null)  One field with combined criteria using conditions and relational operators (e.g. 'X' or 'Y', >1 and <10 or ranges such as 'Between 1 and 10') OR One field with criterion including wild cards ('*' or '?')  Simple calculated field using arithmetic operators ( +, – ,*, / ) OR Date and Time functions/calculations  Complex calculated field (e.g. SUM, MIN, MAX, AVG, COUNT) OR queries that use Grouping OR queries that use logical (IF) or text functions OR advanced functions that are not in the CAT CAPS curriculum  At least ONE meaningful aspect from level . Meaningful use of aspects Meaningful use of aspects Meaningful use of aspects Meaningful use of aspects No database OR  At least ONE meaningful aspect from level . from all from any from any from only 1 No relevant, 4 levels 3 different 2 different level  At least ONE meaningful aspect from level . (, ,  and levels levels (, ,  or meaningful queries done  At least ONE meaningful aspect from level . ) (, ,  or (, ,  or ) 4 ) ) NOTE: Any incorrect/meaningless aspect/function does NOT qualify for consideration. List any function (where applicable) used that is not part of the curriculum. Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 44 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 11 DATABASE – REPORT AND THE COMPLEXITY OF REPORT At least one relevant, meaningful and correct report that informs/supports the problem/solution. Report should contain relevant and selective information ONLY – e.g. based on a query. NOTE: Any incorrect/meaningless aspect/function does NOT qualify for consideration.  At least one relevant, meaningful and correct Meaningful use of all Meaningful use of any Meaningful use of any Meaningful use of any No database OR report 4 aspects 3 aspects 2 aspects 1 aspect  Report sorted according to at least ONE field No relevant, appropriate  Report is grouped appropriately on at least ONE 4 report(s) field  Contains at least ONE meaningful calculation using a function (MIN, MAX, SUM, AVG, COUNT) in the report footer/group footer TOTAL MARK FOR PHASE 2: 44 MARK OBTAINED Comment/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name: ____________________________________________ Teacher signature: __________________________ Date: _____________________ Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 45 DBE/PAT 2022 NSC ASSESSMENT TOOL – PHASE 3 LEARNER NAME: _____________________________________________________________ DATE HANDED IN: ____________________ NOTE: This is a criterion-referenced tool and not a norm-referenced tool. The teacher MUST highlight or tick applicable criteria in the second column. The number of ticks in this second column does not always determine the mark obtained in columns 4 to 8. Relate the criteria to the mark, e.g. in item 1, if answers to all 4 questions are evident, then a mark of 4 is awarded. REPORT Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 1 REPORT – TECHNICAL ASPECTS – COVER PAGE  Cover page added correctly All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects No cover page added  Appropriate content controls used where possible clearly present clearly present present OR  Name and surname, name of school and topic 4 No suitable added control  Meaningful abstract/extract included (summary of components problem/topic) 2 REPORT – TECHNICAL ASPECTS – HEADINGS (Note to teacher: Use the Navigation Pane to see the headings.)  Headings stand out clearly from other (body) text All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the aspects present (typically 12–18 pt) clearly present clearly present clearly present  Styles used to give headings due prominence  Different levels of headings are clearly 4 distinguished  Heading styles used to ensure that headings are formatted in a consistent way 3 REPORT – TECHNICAL ASPECTS – BODY TEXT  Appropriate line and paragraph spacing (no All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the aspects 'empty' paragraphs) used clearly present clearly present clearly present present  Consistent formatting throughout 4  Body text is easily distinguished from headings  All body text is left-aligned/justified Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 46 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 4 REPORT – TECHNICAL ASPECTS – PAGE LAYOUT  Automatic page numbering used All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the aspects  Header/Footers/Page numbering set clearly present clearly present clearly present present appropriately per section 4  Page breaks used to start new pages  Uses section breaks to start new sections, e.g. Appendices 5 REPORT – TECHNICAL ASPECTS – EASE OF NAVIGATION Professional, well-structured document that is easy to navigate and in which information is easy to find.  Updated, automatic table of contents, correctly All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the 4 aspects inserted clearly present clearly present clearly present clearly present  Other tables (tables, figures) and appendices OR correctly inserted in any way Totally  Hyperlinks/Bookmarks/Cross-references (other 4 dysfunctional than the table of contents) used appropriately and correctly to navigate within the report  Hyperlinks to external data/information sources, e.g. spreadsheet and database appropriately and correctly used 6 REPORT – TECHNICAL ASPECTS – GENERAL PRESENTATION  Appropriate, readable fonts, size (10–12 pt) All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the aspects  Not more than two fonts used clearly present clearly present present present  Appropriate word spacing and basic punctuation 4 used  No spelling or grammar mistakes highlighted Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 47 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 7 REPORT – PLAGIARISM AND CITATION ISSUES Presented in learner's own words with all sources cited and all graphics from other sources acknowledged. Signed declaration of authenticity is included.  All sources used are clearly and appropriately All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects clearly None of the aspects acknowledged/citations added for all sources clearly present clearly present present clearly  Graphics from other sources are clearly and 4 present appropriately acknowledged  Citations present are added correctly  A minimum of THREE citations added 8 REPORT – TECHNICAL ASPECTS – ACKNOWLEDGEMENTS AND EVIDENCE Professional, well-structured document that gives credit to sources used, using sound word processing functions, principles and techniques  Automatic reference list/bibliography correctly All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects clearly None of the 4 aspects inserted clearly present clearly present present clearly  Automatic, appropriate captions correctly present inserted for all tables/figures OR  Automatic table of figures/diagrams added 4 Not done  Supporting documentation added as part of document (appendices), clearly distinguishable from main document (e.g. different sections, restarting page numbers, descriptive headers/footers) 9 REPORT – INTRODUCTION Clear, concise introduction providing background information that tells the reader what the report is about. Clearly states the problem, purpose and the focus of the investigation. Answers the questions: What is the problem? What was the purpose of the investigation/Why did you do the investigation? What was your focus (which aspects did you investigate)?  Clear overview and focus of the problem given All 4 aspects clearly stated Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects clearly None of the 4 aspects  Purpose of the investigation clearly stated and no other/ clearly stated clearly stated stated clearly stated  Clear focus in terms of which aspects were 4 unnecessary information with no other/ unnecessary OR investigated information Only a copy of the  No unnecessary, additional information added, task definition/focus question appears other than what appeared in Phase 1 Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 48 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 10 REPORT – DISCUSSION (BODY) – ORGANISATION Information used from Phases 1 and 2 are relevant to the investigation/supportive of different aspects within the investigation and the information is logically sequenced and flows naturally from one aspect to the next to ensure easy reading and clear understanding. Content is organised using appropriate headings.  Only relevant, appropriate data/information used All 4 aspects clearly Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects clearly None of the 4 aspects from Phases 1 and 2 present clearly present clearly present present clearly present  Relevant information/questions grouped together under appropriate headings 4  Information logically sequenced and flows naturally from one heading/paragraph to next  All graphics used are relevant and appropriate 11 REPORT – DISCUSSION AND ANALYSIS – ARGUMENTS, FINDINGS AND SUPPORTING INFORMATION Discussion contains at least THREE relevant, appropriate findings/arguments/claims related to the investigation that are supported by data/ information gathered and processed (charts/graphs/queries/reports, etc.) or manipulated (combined, integrated and synthesised from various sources) and includes a meaningful explanation of how or why the data/information supports the finding/argument/claim (connects data/ information to argument/claim). The findings/recommendations convey knowledge gained and the learner's understanding of the problem and investigation, as well as some new/thoughtful ideas/insights that address the problem.  At least THREE appropriate claims/arguments/ All 4 aspects clearly Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 aspect clearly present None of the 4 aspects findings that are appropriate and relevant to the present for all clearly present clearly present for all claims/ clearly present investigation claims/ for most claims/ for all claims/ arguments OR  All claims/arguments/findings are supported by arguments arguments arguments OR Not done relevant, appropriate data/information (links to OR Only 2 aspects external data) OR All 4 aspects clearly present  Meaningful explanation of how or why the 4 clearly present for some claims/ Claims/ arguments not evidence supports the argument/claim and shows for only 1 claim/ arguments argument meaningful/ a clear understanding of the problem and totally investigation irrelevant  Findings/Recommendations include some new/ thoughtful ideas/insights about the problem/ investigation Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 49 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 12 REPORT – CONCLUSION Meaningful and logical conclusion drawn from the information and evidence presented, and addresses the original problem/investigation, appropriately summarised. Any new information presented at this point must have been appropriately investigated/researched, with supporting evidence.  Conclusion present All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the 4 aspects  Conclusion drawn from information presented in clearly present clearly present clearly present clearly present report and addresses the original problem OR statement/focus in light of the evidence 4 No conclusion presented  Conclusion is meaningful and logical  Conclusion relevant to the focus question in Phase 1 TOTAL MARK FOR REPORT: 48 MARK OBTAINED Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 50 DBE/PAT 2022 NSC WEBSITE Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 13 WEBSITE – GENERAL ASPECTS  Saved as HTML and opens correctly – no errors All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the 4 aspects  Home page with title included 4 clearly present clearly present clearly present clearly present  At least TWO other web pages OR  Style/Content suited to audience No website 14 WEBSITE – ORGANISATION AND READABILITY Correct grouping and structuring of elements and information. Layout and organisation enhance readability and understanding.  Attractive and usable layout. Pages have consistent All 4 aspects clearly present Only 3 of the 4 aspects Only 2 of the 4 aspects Only 1 of the 4 aspects None of the 4 aspects appearance (formatting, background, colours, clearly present clearly present clearly present clearly present layout, font, etc.) OR  Related information grouped together No website  Different elements/parts (e.g. header/banner/title, 4 body/content, footer, credits) clearly distinguishable/ separated, e.g. using horizontal lines  Techniques such as lists, tables, paragraphs and headings are used appropriately and correctly to structure the information Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 51 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 15 WEBSITE – GRAPHICS AND ACCESSIBILITY Relevance, quality and accessibility of graphics  All graphics are relevant to the topic/purpose of All 3 aspects clearly present Only 2 of the 3 aspects Only 1 of the 3 aspects None of the 3 aspects the site, are thoughtfully cropped/sized, are of clearly present clearly present clearly present high quality and enhance reader interest or understanding. OR 3  There are no broken images (images display) No website  All images have an ALT tag that describes the image and its link to ensure accessibility to visually impaired people 16 WEBSITE – NAVIGATION Functional, logical/intuitive and user-friendly navigation  Working hyperlinks are used to create a All 3 aspects clearly present Only 2 of the 3 aspects Only 1 of the 3 aspects None of the 3 aspects navigation system which allows users to move clearly present clearly present clearly present from the home page to related pages and back OR  Hyperlinks use meaningful descriptive text 3 No website  Navigation system is consistently placed throughout website 17 WEBSITE – INFORMATION – QUALITY Information presented in the website is relevant and factually correct, without unnecessary duplication of any information, to enable visitors to learn more about the topic/problem. References to other good quality information provided through functional hyperlinks.  Information from the report included and All 3 aspects clearly present Only 2 of the 3 aspects Only 1 of the 3 aspects None of the 3 aspects appropriately adapted clearly present clearly present clearly present  Demonstrates good understanding of the OR information/material included in the site, and No website additional, good quality information presented in 3 functional hyperlinks  Good language used, suited to the target group on the website with no spelling and grammar mistakes Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 52 DBE/PAT 2022 NSC Possible Mark CRITERIA/ASPECTS 4 3 2 1 0 mark obtained 18 WEBSITE – PLAGIARISM Guidelines were followed to show recognition or give credit for all material borrowed from other sources.  Three acknowledgements in the correct format All 3 aspects clearly present Only 2 of the 3 aspects Only 1 of the 3 aspects None of the 3 aspects inserted for any text content from other sources clearly present clearly present clearly present  Graphics/Images/Graphs from other sources 3 OR clearly acknowledged No website  Clear, easy-to-locate and accurate citations/ acknowledgements for all borrowed material 19 WEBSITE – ADDITIONAL TAGS/FEATURES USED (OUTSIDE CURRICULUM) Learner demonstrates knowledge/skills not included in the curriculum, but that enhance the website.  Appropriate tag/aspect not specified in curriculum The 2 aspects are clearly Only 1 of the 2 aspects None of the 2 aspects added present clearly present clearly present (Specify): OR __________________________________ No website 2  Appropriate tag/aspect not specified in curriculum added (Specify): __________________________________ TOTAL MARK FOR WEBSITE: 22 MARK OBTAINED Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 53 DBE/PAT 2022 NSC GENERAL Possible Mark CRITERIA 4 3 2 1 0 mark obtained 20 EVIDENCE AND ORGANISATION OF ALL DOCUMENTS (ALL PHASES) Format and organisation of material/evidence  Electronic and/or hard copies of all documents Clearly contains all 4 of Clearly contains 3 of Clearly contains 2 of Clearly contains 1 of No evidence OR (including evidence of sources) available the 4 aspects the 4 aspects the 4 aspects the 4 aspects  All files organised into a logical folder structure Contains none of the (subfolders within each phase), clearly named 4 4 aspects  Structure is easy to find/navigate  Meaningful folder and file names used throughout TOTAL MARK FOR GENERAL: 4 MARK OBTAINED TOTAL MARK FOR PHASE 3: 74 MARK OBTAINED Comment/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name: ____________________________________________ Teacher signature: __________________________ Date: _____________________ Copyright reserved Please turn over

Computer Applications Technology Downloaded from hlayiso.com 54 DBE/PAT 2022 NSC LEARNER NAME: __________________________________________________________ DATE: _____________________________ Assessment Summary Phase Focus Maximum Mark Mark Obtained 1 Find and access data and information 32 2 Process data and information 44 Present information/solution – Report 48 3 Present information/solution – Website 22 Present information/solution – General 4 Total: 150 /150 /100 Declaration of Authentication by Teacher I hereby declare that, to the best of my knowledge, the work assessed is solely that of the learner (except where there is clear acknowledgement and record of any substantive advice/assistance given to the learner) concerned and that the work was conducted under supervised/controlled conditions to ensure that it has not been plagiarised, copied from someone else or previously submitted for assessment by anyone else. Comment/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name: ____________________________________________ Teacher signature: ________________________ Date: _____________________ Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 55 DBE/PAT 2022 NSC APPENDIX B: STYLE GUIDE FOR WORD PROCESSING DOCUMENTS Cover page  Use appropriate content controls to display information.  Text should be typed using appropriate font sizes.  This should be the only page on which a page border is used.  Avoid 'arty' borders and backgrounds/Do NOT use Word Art/Text Art.  If a picture is used, the picture should be appropriate to the topic. Headings  The font used should be easy to read, e.g. Cambria or Calibri.  The font size should vary between 12 pt to 18 pt.  Ensure that headings stand out clearly from other text.  Use heading styles where appropriate to ensure that headings are formatted in a consistent way. Analysis and Discussion  Use a font that is easy to read and that is the same as the heading font or matches the heading font, e.g. Cambria or Calibri.  Do not use more than two different font types.  Use appropriate word spacing and basic punctuation (i.e. one space after a full stop and comma).  Font size should not be larger than 12 pt and not smaller than 10 pt.  Ensure that different paragraphs are clearly distinguished.  Use appropriate word processing principles and techniques to create white space and enhance readability (e.g. line and paragraph spacing).  Ensure that all body text is formatted in a consistent way. Using styles would help to ensure consistency.  Body text should be distinguished from headings.  Body text should be left-aligned. Paragraph formatting  Use appropriate and consistent line and paragraph spacing throughout.  Ensure there are no 'empty' paragraphs.  Ensure that all text in the body is left-aligned. Page layout  Use word processing functions to add page numbers.  Use page/section breaks to start new pages/sections, e.g. Appendices.  Use bullets and numbering where appropriate to enhance readability.  Use sufficient white space.  Tables, graphs and other graphics should have appropriate captions. General formatting and editing  Keep it simple – this is not an art or design competition – it is the quality of the report and content that matter.  Check the spelling and grammar of your document. Professional documents are error-free. Copyright reserved

Downloaded from hlayiso.com Computer Applications Technology 56 DBE/PAT 2022 NSC APPENDIX C: LEARNER DECLARATION OF AUTHENTICITY Learner name ID Number Grade 12 Year 2022 Subject Computer Applications Technology Practical Assessment Task (PAT) Teacher Did you receive any help/information from anyone to complete this project?  No  Yes (provide details below) Help/Information received from Nature of the help/information (provide evidence): (person): I hereby declare that the contents of this assessment task are my own original work (except where there is clear acknowledgement and appropriate reference to the work of others) and that I have not plagiarised, copied from someone else or used work previously submitted for assessment by anyone. _________________________ ___ / ___ / 2022 SIGNATURE OF LEARNER DATE Copyright reserved

Computer Applications Technology Downloaded from hlayiso.com 57 DBE/PAT 2022 NSC APPENDIX D: SAMPLE OF QUESTIONS AND SOURCES TABLE (PHASE 1) QUESTION SUMMARY OF N TYPE OF QUALITY OF INFORMATION QUESTION LEVEL CATEGORY BIBLIOGRAPHICAL INFORMATION INFORMATION O. SOURCE FOUND (1, 2, 3, 4) FOUND Smart Social Authors(s) Authority … Name of website/ Teen social media statistics 2021 (What parents need to know) Currency … web page Internet/ 25 February 2021 ... ... ... Date created/updated Accuracy … 1 Website <Hyperlink 1> 24 October 2021 Date accessed Objectivity … https://smartsocial.com/post/social URL -media-statistics Coverage … Gogus A, Saygin Y Author(s) Authority … Privacy perception and Title information technology utilization Currency … ... ... ... Magazine of high school students 2 <Hyperlink 2> May 2019 Date published Accuracy … Heliyon Publisher Objectivity … 3 … … … … … … … … … … … … … … … … … … … … … … … … … … … … … 10 … … … … … … … … … Copyright reserved Please turn over

Downloaded from hlayiso.com Computer Applications Technology 58 DBE/PAT 2022 NSC APPENDIX E: K-W-L-S CHART Example of a K-W-L-S Chart K W L S What I already know What I want to know What I learned What I still want to learn Copyright reserved