Information Technology PAT GR 12 2020 Eng

Downloaded from hlayiso.com INFORMATION TECHNOLOGY GUIDELINES FOR PRACTICAL ASSESSMENT TASKS GRADE 12 2020 These guidelines consist of 32 pages. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 2 DBE/PAT 2020 NSC TABLE OF CONTENTS 1. INTRODUCTION 3 2. GUIDELINES 4 2.1 What is the PAT? 4 2.2 Mark allocation 5 2.3 The topic 6 2.4 What you need to be able to do the PAT 7 2.5 Malpractice 7 2.6 Non-compliance 7 2.7 PAT requirements 8 2.8 Instructions for Phase 1 9 2.9 Instructions for Phase 2 – Coding and testing 12 2.10 ANNEXURE A: Assessment tools 15 2.11 ANNEXURE B: Learner declaration 25 2.12 ANNEXURE C: Declaration of authenticity 26 2.13 Guidelines for teachers to provide guidance 27 2.13.1 What are the learners required to do and provide? 27 2.13.2 How will learners go about it? 27 2.13.3 Skills required 27 2.13.4 What must the learners be taught beforehand? 28 2.14 Malpractice 28 2.15 Learner declaration of authenticity of the PAT 28 2.16 Role of the teacher 29 2.17 Supervised/Controlled conditions 30 2.18 Managing the PAT 30 2.19 Evidence of assessment 30 2.20 Interview 30 2.21 Requirements 31 2.22 Non-compliance 31 3. CONCLUSION 32 Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 3 DBE/PAT 2020 NSC 1. INTRODUCTION The 17 Curriculum and Assessment Policy Statements subjects which contain a practical component all include a practical assessment task (PAT). These subjects are:  AGRICULTURE: Agricultural Management Practices, Agricultural Technology  ARTS: Dance Studies, Design, Dramatic Arts, Music, Visual Arts  SCIENCES: Computer Applications Technology, Information Technology, Technical Sciences  SERVICES: Consumer Studies, Hospitality Studies, Tourism  TECHNOLOGY: Civil Technology, Electrical Technology, Mechanical Technology and Engineering Graphics and Design A practical assessment task (PAT) mark is a compulsory component of the final promotion mark for all candidates offering subjects that have a practical component and counts 25% (100 marks) of the end-of-the-year examination mark. The PAT is implemented across the first three terms of the school year. This is broken down into different phases or a series of smaller activities that make up the PAT. The PAT allows for learners to be assessed on a regular basis during the school year and it also allows for the assessment of skills that cannot be assessed in a written format, e.g. test or examination. It is therefore important that schools ensure that all learners complete the practical assessment tasks within the stipulated period to ensure that learners are resulted at the end of the school year. The planning and execution of the PAT differs from subject to subject. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 4 DBE/PAT 2020 NSC 2. GUIDELINES 2.1 What is the PAT? The practical assessment task (PAT) is a software development project in which you will have the opportunity to demonstrate your software development and programming skills. The purpose of the PAT is to:  Work extensively with content knowledge to improve your programming and organisational skills;  Implement higher-order and critical-thinking skills, formulate strategies and solve problems on different levels; and  Develop good working practices to prepare you for the real world, such as: o Time management o Thorough planning o Perseverance to achieve and to excel in what you set out in your plan o Presentation and marketing of your product You will need to demonstrate knowledge and understanding of the software development life cycle through analysis, design, coding and testing of your project. You will have to show effective use of the software design tools and techniques which you have studied. The PAT is divided into TWO phases, as explained below. Phase 1: Outlines the project task, solution and a possible design of the project Phase 2: A working, fully documented Delphi application that implements the planned solution NOTE: Submission dates – Specific dates will be determined by your subject teacher. Phase 1: No later than ONE week before the end of Term 1 Phase 2: No later than the FIRST week of Term 3 LEARNERS MUST ADHERE TO THE DUE DATES FOR EACH PHASE. NOTE: You will be required to demonstrate and discuss your application during an interview session. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 5 DBE/PAT 2020 NSC 2.2 Mark allocation The PAT counts 25% of your final examination mark for Information Technology. It is therefore crucial that you strive to produce work of a high standard. PHASE DEVELOPMENT PHASE MAXIMUM MARK Phase 1 Analysis and Design 48 Phase 2 Coding and Testing 78 General Final Product and Impression 14 TOTAL 140 NOTE:  The PAT mark is a compulsory component of the final certification mark for all candidates registered for Information Technology.  Your PAT will be externally moderated by subject experts and quality assured by Umalusi. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 6 DBE/PAT 2020 NSC 2.3 The topic Tourism is an important industry in South Africa. It includes a wide range of aspects, such as organising tours, marketing tourist attractions, arranging transport and accommodation, etc. Software applications can be useful in assisting with activities within the tourism industry. Projects in the scenario of tourism could include the following:  Travel arrangements to and from destinations/tourist attractions, e.g. booking flights, buses, trains  Accommodation details, such as hotels, B&Bs, campsites, lodges, timeshare, etc.  Travel agencies organising vacations for their clients, e.g. destinations, distances to travel, time schedules  Providing information and/or booking tourist attractions, such as theme parks, aquariums, flea markets, etc.  Providing information and/or booking activities and events scheduled, such as music and sport  Booking tours/providing information on tours in different parts of the country/world  Health and safety, such as public awareness and the availability of resources and emergency services, etc.  Leisure and entertainment companies making translators, interpreters and communication facilities available to tourists  Preparation and management of travel documents, e.g. ID, passport, unabridged birth certificate, visa, travel insurance  Providing information and/or booking visits to heritage and cultural sites in South Africa/other countries  Any other topic related to any aspect of the tourism industry Choose an application/environment that relates to the tourism industry and do research on the information system requirements. You are not limited to the list of ideas above, but you need to keep within the overall theme – the tourism industry. Note that you need to choose data and functionalities (services) in such a way as to develop a well-rounded application related to the topic. NOTE: Your final program must comprise one single project with logically related parts. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 7 DBE/PAT 2020 NSC 2.4 What you need to be able to do the PAT To be able to do the PAT, you need the following:  The Delphi IDE (integrated development environment)  An office suite with the following software: o Word processing software o Database software  Storage media to save and backup your work electronically, e.g. a flash drive, rewritable CD/DVD 2.5 Malpractice As the PAT is an individual project that is part of your final promotion mark, you may NOT:  Get help from others without acknowledgement  Allow others to do programming code for you  Submit work which is not your own  Share your work with other learners  Include work directly copied from books, the internet or other sources without acknowledging it. The above actions constitute malpractice, for which a penalty will be applied, depending on the seriousness of the offence. NOTE: If you use work from other resources, it may not exceed 10% of the work that you submit. 2.6 Non-compliance You will be given up to a part of Term 3 to submit outstanding work or to present yourself for the PAT. Should you fail to fulfil the requirements for the practical assessment task, you will be awarded a zero ('0') for the PAT component of IT. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 8 DBE/PAT 2020 NSC 2.7 PAT requirements The project must include the following:  A database connection and database manipulation that entail performing different CRUD (Create, Read, Update and Delete) operations  A multiform GUI with good functionality and usability, based on sound HCI principles  The use of a text file for input/output purposes, e.g. to populate data structures and to provide reports  Other data structures that will be relevant to your program Database The database must:  Have at least TWO linked tables (relational tables implementing referential integrity)  Contain sufficient data volumes and uses a variety of field types (approximately 5 fields and at least 10 records per table)  Be accessed and manipulated by the program using code constructs AND SQL statements GUI The graphical user interface (GUI) must:  Have at least THREE forms/screens that allow for navigation between forms depending on the user choices  Interact with the database and other data structures to provide the necessary input, processing and output  Comply with general HCI principles Text files Your application must use a text file(s) for input and/or output. Classes and objects The appropriate use of one or more object(s) created within a class and used in other forms of the application. NOTE: The object(s) must NOT be a duplication of one of the tables contained in the database and must add value to the program. Other data structures/Advanced programming concepts The suitable use of other data structures that are not already used, e.g. an array. Advanced programming concepts can also be applied, e.g. inheritance, polymorphism, overloaded methods. NOTE: The mark obtained for your project will be greatly influenced by the quality of the programming code that manipulates the data successfully in order to adhere to the user requirements in the best possible way. Quantity cannot replace variety, effectiveness and quality. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 9 DBE/PAT 2020 NSC 2.8 Instructions for Phase 1 During this phase you have to show that you have done a proper and thorough user requirement analysis. This needs to be done in order to determine who the users are and what the users of the system would require it to do. The following can be used as a guideline: Choose a topic from the provided TOPIC list or any related topic within the provided scenario. SCENARIO AND SCOPE: DEFINE THE TASK Write a brief description (approximately 200 words) in your own words to describe in general terms the problem/task, and how the project will solve the problem. Your explanation must highlight that:  You understand the needs of the task that you have chosen  Your solution will solve the needs of the task Also provide a simple/brief description of the scope of the project. USER REQUIREMENTS The user is the target audience and will thus determine the needs and requirements of the program. Determine the clients/users and their requirements. The aim is to identify the user(s), user needs, acceptable limitations and processing requirements of the system. Use a table or a use case diagram to explain the role, activity and limitations of each user of the system. NAVIGATION/DESCRIPTION OF FLOW DIAGRAM Clearly indicate the logical program flow and navigation between screens. Use a flow diagram or any other form of illustration to present a global overview of the project/system. DESIGN THE DATABASE The aim is to design a relational database to serve as a data source, as well as to manipulate data contained in the database using programming code AND SQL statements. Show the design of the database, including the tables, relationships, field names, field types and field sizes. The database should provide data to the program to be processed and create reports. The Delphi program must be able to manipulate the content of database tables, e.g. update/edit/ delete/add data, provide results of queries, provide reports. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 10 DBE/PAT 2020 NSC DESIGN THE GRAPHICAL USER INTERFACE (GUI) The aim is to produce a GUI design that considers good human-computer interaction (HCI) principles. Your design should include measures that prevent errors from occurring due to invalid input and that minimise the amount of information a user has to enter. Use HCI design principles and design a GUI that considers the following:  The user, type of user and context of the user  User requirements, usability  Dialogues – must be relevant, simple and clear  Icon usage and presentation – well selected and relevant, well placed and purposely used  Colour – appropriate use and combination of colours  Feedback – neat, clear and well presented  Helpful error messages  Exits – clearly marked, placed correctly  Shortcuts  Flow of information on the screen – top to bottom and left to right  Sensible use of space on the screen Provide examples of planned data capture and data entry designs (screen dumps may be used from a prototype of the project but must be annotated) and of planned output design. Show the GUI design following HCI principles of interface(s), excluding introductory screens. DATA DICTIONARY Text files Your application must use a text file(s) for input and/or output. Explain where a text file(s) can be used in your application so that it adds value to the application. Classes and objects Your application must contain at least one object class. Explain where objects can be used in your application so that it adds value to the application. Other data structures/Advanced programming constructs Your program must use a one-/two-dimensional array/an array of objects OR apply programming concepts, such as inheritance, polymorphism, overloaded methods, method binding, etc. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 11 DBE/PAT 2020 NSC SOFTWARE TOOL – INPUT, PROCESSING, OUTPUT (IPO) (FORMAT, DATA TYPES/STRUCTURES, VALIDATION) Use an IPO illustration/table to:  Design the overall solution, considering all constituent parts and the interrelationships between the various parts of the program/system;  Specify the format, data types, source of input, source of output, validation of input and error checking mechanisms;  Specify processing that needs to be done and provide algorithm(s)/formulae to show how the processing will be done; and  Provide a clear description to indicate the input, processing and output requirements of the system for at least TWO of the main interfaces. HAND IN Hand in a document that provides the following:  A clear description of the chosen topic;  User requirements – detailed information stating the role, activities and limitations of each user of the planned system;  A clear description of data structures to be used: o A planned database design o The use of one or more text file(s) o The use of one or more class(es) and object(s) o The use of any other data structure/advanced programming concept  A GUI design;  A data dictionary; and  The IPO design, including validation and error checking techniques. Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 12 DBE/PAT 2020 NSC 2.9 Instructions for Phase 2 – Coding and testing This is where you implement your design by using appropriate software tools (programming language, database software, IDE, etc.) and techniques to construct a solution to the problem. DEVELOP THE DATABASE Design and construct the database according to the planning document that was developed during Phase 1. Apply appropriate techniques and sound database development rules. Pay attention to the following:  Table names should start with the prefix 'tbl', e.g. tblSuppliers.  The use of spaces in field names might affect reading data from fields into the Delphi application.  The size of text fields must be restricted/limited as the columns in the DBGrid in the Delphi application will be affected by the field size.  The data types of fields must be well thought out as this information will ultimately connect to components in the Delphi application, e.g. the difference between the Number and AutoNumber data types, the difference between saving a date as text or as a DateTime data type.  Keep the purpose of the project in mind when setting up fields and tables.  Ensure that the database connects correctly to the program and interacts with the program in a meaningful and effective way that supports the program once you have written the Delphi code. DEVELOP THE GUI Develop the GUI according to the planning document that was developed during Phase 1. Use appropriate components to ensure easy use and effective navigation. Follow HCI principles to ensure that the application is user-friendly and provides all necessary requirements for the user(s) to use the program effectively and navigate through the options/functionalities easily. WRITE THE CODE Write code to develop the program/system according to the planning document that was developed during Phase 1. Note the following:  Use good programming techniques and structures.  Implement effective algorithms and sound defensive programming techniques to produce a robust program.  Use appropriate structures to satisfy the requirements of the algorithms.  Use multinested loops and conditional structures.  The following data structures are compulsory in addition to the database: o Text file – reading OR writing OR appending o Class(es) and object(s) o The use of any other data structure not already used/advanced programming construct Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 13 DBE/PAT 2020 NSC  Use OOP principles, re-use code, use functions, procedures, methods and objects.  Use relevant validation procedures and components.  Develop a well-designed and user-friendly GUI.  Rename relevant components to add to readability and documentation of your code.  Input data using the most effective method, e.g. a text file, database, keyboard, most suitable GUI components.  Process the data using the most appropriate methods.  Generate output of data using the correct components and structures, with formatting where needed.  Ensure smooth interaction between classes/forms/tabs.  Correctly manipulate and query the database. DOCUMENT THE PROGRAM Project notes for the user: These project notes must describe how the user should interact with the program. It can include notes on how to navigate through the program, specific requirements, such as passwords and installation procedures if applicable. The notes must also describe any known bugs or problems. Project notes can be written as part of the help function of the program. Tool tip texts can also be provided. Project notes for developers: These project notes could include specifications/limitations applicable to the project to ensure that the program is installed and set up correctly, e.g. the connection to the database. Project notes related to the programming code should be embedded as comments in the code. Document the code so that other programmers will be able to interpret the code and understand the purpose of individual pieces of code. It should also include comments to explain sections of complex code. TEST THE PROGRAM/SYSTEM Test the program/system using clearly defined typical data, erroneous data and boundary (extreme) data. HAND IN Hand in:  The completed Delphi project (Delphi code, text files, database and any other resources required to execute the program successfully) and project notes;  The declaration of help received (ANNEXURE B); and  The declaration of authenticity (ANNEXURE C) Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 14 DBE/PAT 2020 NSC INTERVIEW Demonstrate your program and answer questions about the program and the code during an interview session. Guidelines for the demonstration of the project:  The teacher will schedule dates and times for demonstrations. About 15 minutes per project will be allowed.  You should hand in all the documentation before the demonstration takes place – at least ONE week in advance.  The demonstrations must be done electronically on a computer.  You must execute your computer program and show all the features of the program to the teacher for evaluation.  The teacher can require you to execute test procedures to make sure that the entire program is working correctly.  The teacher can use the mark sheet for Phase 2 as a guideline and allocate marks accordingly during the demonstration.  As part of the demonstration, the teacher will identify random pieces of the programming code in the project and ask you to explain the purpose and working thereof. This is done to ensure that you did the coding yourself. A similar type of procedure will be followed during moderation. If you cannot explain the code used in the project, no marks can be awarded for the project.  You must hand in the electronic copy of the project that was demonstrated. The teacher will use this copy to allocate any outstanding marks to finalise the mark. Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 15 DBE/PAT 2020 NSC 2.10 ANNEXURE A: ASSESSMENT TOOLS Phase 1: Name of learner: SCENARIO/SCOPE 4 3 2 1 0 (± 200 words) Scenario and Scope An excellent presentation of All FOUR points were THREE points were TWO points were presented Totally inadequate or not  Topic is clearly stated all FOUR points listed presented with presented with with shortcomings applicable  Thorough description of what shortcomings shortcomings OR Poor or no coverage of the the problem/task involves OR OR A good attempt to present aspects 4 (purpose) A good presentation of A good presentation of ONE of the points No scope or extremely  Describe a possible solution for THREE points TWO points vague and unclear the problem/task  Brief description of the scope USER REQUIREMENTS 4 3 2 1 0 State WHO the users are.  Role, activity and  Minor shortcomings in  Shortcomings in the  Major shortcomings in  Not done or incorrect or limitations of at least the discussion of role, discussion of role, the discussion of role, irrelevant Role, activity and limitations of TWO different types of activity and limitations of activity and limitations of activity and limitations of the users users of the system at least TWO different users, e.g. sections left users discussed types of users of the out  Only ONE user of the 4 (In table format OR a use case  Well documented, neat system  Only ONE user of the system discussed diagram) and to the point  Well documented, but system discussed  Poorly documented – can improve slightly  Not well documented, not acceptable but still acceptable Navigation/Description of flow 4 3 2 1 0 diagram A diagrammatical representation An excellent attempt to A good attempt to show the A satisfactory attempt to A poor attempt to show the No diagram of the design and flow of events show the sequence of all sequence of all steps and show the sequence of steps sequence of steps and flow OR when the program is used steps and flow of events flow of events when the and flow of events when the of events when the program Incorrect, irrelevant or 4 when the program is program is executed with program is executed with is executed with major unsuitable for the executed with no minor shortcomings significant shortcomings shortcomings application shortcomings Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 16 DBE/PAT 2020 NSC DATA STRUCTURES 4 3 2 1 0 Database design All database design Good database design with Acceptable database Database design done, but No database or incorrect or  All fields relevant requirements met minor shortcomings design with several with limited value irrelevant  Type and size of fields well A well-designed relational A relational database shortcomings A poor attempt to normalise No relational database 4 chosen database normalised normalised with minor A relational database a relational database Database not normalised  Relational correctly shortcomings normalised with major  Normalised shortcomings Class description and class Class well defined with One incorrect/irrelevant Two incorrect/irrelevant Three or more No class diagram or totally diagram attributes and methods that aspect identified in the class aspects identified in the incorrect/irrelevant aspects incorrect serve a definite purpose in diagram/description, e.g. class diagram/description, identified in the class the context of the Scope e.g. diagram/description, e.g. application Scope Scope 4 Return type Class diagram included; Return type Return type Method type illustrates an appropriate Parameters Method type Method type design in terms of the attributes and the proposed Parameters Parameters methods with no errors Text file(s) and array/advanced Excellent and relevant Acceptable and relevant Description of use of text An attempt to describe the Not done or incorrect or programming concepts description of use of text description of use of text file(s) with some use of a text file with major irrelevant file(s) AND a good file(s) AND an acceptable shortcomings AND the shortcomings OR an array/ application of an array/ application of an array/ application of an array/ advanced programming 4 advanced programming advanced programming advanced programming concepts with major concepts described concepts described concepts is described with shortcomings is described shortcomings GUI DESIGN 4 3 2 1 0  Design fits to program's Good GUI design Satisfactory GUI design Limited GUI design Poor GUI design GUI design not functional or intended use All of the listed principles Most (at least 4) of the Most (at least 3) of the Applied less than 50% (less does not support the  Appropriate components applied throughout the principles applied throughout principles applied than 2) of the principles intended use at all 4  Ease of use, logical flow system, e.g. with data the system, e.g. with data throughout the system, e.g.  Clearly marked navigation capturing, output, capturing, output, navigation with data capturing, output,  Friendly dialogue/Help navigation navigation Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 17 DBE/PAT 2020 NSC IPO – Software design tool DATA INPUT 4 3 2 1 0 Input interfaces (at least TWO) Clearly describes all inputs Minor shortcomings in Clear description according Poor attempt to describe No inputs described or  Source of input, such as according to all FOUR describing all inputs to THREE points listed input values incorrect keyboard, text file, array or points listed according to all FOUR points OR database listed Major shortcomings in  Data type describing all inputs 4  Format of input, e.g. date, according to all FOUR gender (M/F) points listed  GUI component used Input validation Clearly describes all points Clearly describes TWO Clearly describes ONE Poor attempt to describe No validation described or  At least FOUR different data listed points listed points listed validation incorrect types validated OR OR  At least FOUR inputs validated Minor shortcomings in Major shortcomings in including: o Validate for NULL/empty describing all points listed describing all points listed 4 field AND o Test if value was selected in a selection component  Associated error messages DATA PROCESSING 4 3 2 1 0 WHAT processing will need to be Lists at least EIGHT One or two processes not About 50% of the Only one or two processes No processes listed done processes to be done listed processes listed listed 4 HOW processing will be done – Clearly describes how at Clearly describes how Clearly describes how TWO Clearly describes how ONE Processes not described or supply algorithms, formulas, etc. least FOUR processes will THREE processes will be processes will be done process will be done incorrect or irrelevant be done done OR OR 4 An attempt to describe how A poor attempt to describe FOUR processes will be TWO or THREE processes done Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 18 DBE/PAT 2020 NSC DATA OUTPUT 4 3 2 1 0 Output interfaces (at least TWO) Clearly describes all Minor shortcomings in Clear description of all Poor attempt to describe No output described or  Data to output outputs by addressing all describing all outputs by outputs by addressing TWO outputs incorrect  Format of the output, e.g. THREE points listed addressing all THREE points points listed currency, date listed 4 OR  Output component, such as Limited outputs described dbGrid, rich edit, label, etc. TOTAL 48 Comments/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name:_____________________________________ Teacher signature: ___________________________________ Date:____________________________ Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 19 DBE/PAT 2020 NSC Phase 2: Name of learner: PROJECT ASSESSMENT DATABASE DESIGN 4 3 2 1 0 Implementation of database design Database design correctly Database design correctly Database design using at Database design not Totally inappropriate or implemented, with at least implemented, with at least least 2 relational tables, relational incorrect or not used 2 relational tables, 2 relational tables, but not properly One table with suitable suitable fields, data types suitable fields, data types implemented fields, data types and and sizes and sizes 4 Errors in fields, data types sizes Large/Adequate data Limited volume of data and sizes volume used GUI DESIGN 4 3 2 1 0 Ease of use/HCI principles Excellent – all four Good – one aspect Satisfactory – two aspects Limited – more than two Poor GUI design  Excellent layout and communication aspects applied correctly omitted or not applied well omitted or not applied well aspects omitted or not Little/No thought given to (screen tips, feedback, help, etc.) throughout the program applied well HCI principles  Most appropriate components 4  Readable/Relevant input/output  Excellent use of effects/colour/ icons/shortcuts/tool tip text, etc. DATA DICTIONARY 4 3 2 1 0 Variables and components Excellent – all four Good – one aspect Satisfactory – two aspects Limited – more than two Totally inappropriate or  Variety of appropriate variable types aspects applied correctly omitted or not used well omitted or not used well aspects omitted or not incorrectly applied  Correct use of local and global in all instances used well variables 4  Proper naming convention of variables, e.g. iNumber, sName  Correct prefix for components, e.g. edt, red, cmb Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 20 DBE/PAT 2020 NSC DATA STRUCTURES (excl. Database) 4 3 2 1 0 Text file(s) Excellent and relevant Good use of a text file Limited use of a text file An attempt to use a text file Not done or incorrect or use of one or more text with shortcomings irrelevant 4 file(s) Class(es) and object(s) Applicable class, correctly One minor shortcoming in Two minor shortcomings in More than two Class not compiled with applicable the compilation of the the compilation of the shortcomings in the implemented/poorly attributes and methods class/definition of a class/definition of a compilation of the class/ defined OR not relevant Object(s) correctly method/call of a method method/call of a method definition of a method/call of to the application OR instantiated Object(s) integrated Object(s) integrated with a method duplication of a table in 4 satisfactory with the the application with Object(s) not integrated well the database Methods correctly defined and called application shortcomings, e.g. limited with the application method calls Object(s) integrated well with the application Array OR advanced programming Excellent and relevant Limited use of array(s) Limited use of array(s) with An attempt to use an array Not done or incorrect or concepts use of array(s) Could include: Array of minor shortcomings Shows potential but not irrelevant Could include: Sensible objects or parallel arrays or OR used for a suitable purpose use of array of objects or two-dimensional array A basic application of or does not work correctly parallel arrays or two- OR inheritance or OR dimensional array polymorphism or method A basic application of either An attempt to apply 4 OR inheritance, polymorphism, binding or the use of inheritance or Excellent application of method binding or effective overloaded methods with polymorphism or method inheritance or use of overloaded methods minor shortcomings binding or the use of polymorphism or method overloaded methods with binding or effective use of major shortcomings overloaded methods INPUT 4 3 2 1 0 Input data Excellent application of all Minor shortcomings in the Approximately 50% of the Limited application of the No application of the  Variety of sources of input, such as FOUR aspects listed application of all FOUR aspects listed correctly aspects listed aspects listed from the keyboard, text file, array or aspects listed applied database 4  Correct data types  Appropriate format used, e.g. date, gender (M/F)  GUI component used Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 21 DBE/PAT 2020 NSC Validation/Error catching A variety of A variety of validation/error Limited validation/error Validation/error catching No effort at validation/ validation/error catching catching for relevant input catching poorly done or error catching for relevant input Mostly clear and Error messages and inappropriate/not Clear and appropriate appropriate error messages exception handling meaningful 4 error messages and and exception handling sometimes inappropriate/ exception handling mechanisms not meaningful mechanisms PROCESSING 4 3 2 1 0 Algorithm correctness/ All algorithms used are Appropriate algorithms that 50% of the algorithms used Algorithms are mostly Totally inadequate or not Processing appropriate, work work correctly but ONE are appropriate, work inadequate/not working working correctly correctly and meet all processing requirement not correctly and meets most correctly, processing 4 processing requirements met processing requirements requirements not all met Algorithm efficiency All algorithms provide the Most algorithms provide the Limited efficiency of Poor efficiency of Totally inadequate or not most efficient solutions most efficient solutions algorithms used algorithms used working correctly Good programming Acceptable programming Few algorithms use good Algorithms do not use good techniques used techniques used programming techniques programming techniques 4 Effective modular design Limited modular design with Poor modularity with limited Attempted use of own with correct use of own correct use of own functions use of own functions and functions and procedures functions and procedures and procedures procedures Relevant and appropriate use of Excellent use of complex Works correctly Works correctly with minor An attempt has been made No attempt has been complex code, e.g. code that works correctly Adds value to the system shortcomings with major shortcomings made 4 Dynamic component Adds value to the system OUTPUT 4 3 2 1 0  Layout Excellent application of all Minor shortcomings in the Approximately 50% of the Limited amount of aspects None of the aspects  Readability/Clarity, e.g. columns, FOUR aspects listed application of all FOUR aspects listed applied listed applied correctly listed applied correctly headings aspects listed correctly  Formatted, e.g. currency 4  Most appropriate component/data structure used for output Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 22 DBE/PAT 2020 NSC Database manipulation (Delphi code AND SQL) 2 1 0 Sort records in a table 2 Search for data in a table 2 Not done or does not work or incorrect Insert a new record to a table 2 Works, but poorly constructed/ Delete a record from a table 2 Works correctly and is Edit selected fields in a record 2 SQL using string manipulation, e.g. using Left, Mid and Right 2 applicable to task not applicable to task Complex selection SQL query, e.g. using HAVING/combination of AND and OR in a single query 2 At least two SQL queries using different calculations, such as minimum, maximum, sum and average 2 At least one query involving two tables using an SQL statement 2 At least one query involving two tables using Delphi code 2 At least one dynamic SQL using a variable 2 Documentation 4 3 2 1 0 Comments/Notes Code clearly annotated to fully Code clearly annotated to Code annotated to explain Code annotated to explain No comments or no (Explanation of program and explain all necessary parts explain all necessary parts most necessary parts certain parts project notes code) Explanation shows excellent Explanation shows good insight Explanation shows some Explanation shows little insight Project notes present and of a insight insight Extensive project notes present good standard Project notes present and of a Inadequate project notes 4 and of an excellent standard moderate standard present Clearly explains working of program Exceptional features Contains feature(s) that are NOT Contains eye-catching Uses standard Delphi GUI At least one attempt to No exceptional features part of the curriculum, e.g. feature(s), e.g. animation, using features, e.g. eye-catching apply standard Delphi GUI connecting or running on a mobile fairly complex code in an original buttons and other GUI features to enhance the device and sensible way to enhance components in an original and look and feel/ functionality Feature(s) must show a high level the look and feel/functionality of sensible way to enhance the of the product of complexity to implement the product look and feel/functionality of Learner must show 4 Learner must show knowledge the product knowledge and skills on Learner must show knowledge and skills on how the feature(s) and skills on how the feature(s) Learner must show how the feature(s) were were coded were coded knowledge and skills on how coded the feature(s) were coded TOTAL (implementation): 78 Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 23 DBE/PAT 2020 NSC General: Final product and impression Name of learner: Aspect 4 3 2 1 0 Mark Completeness Reached initial goal and Met at least 80% of the initial Met more than 50% of More than 50% of initial Almost none of the initial met all stated requirements requirements requirements not met requirements met 4 requirements in Phase 1 Professional product Useful and can be Useful as a real-life Useful as a real-life Not ready to be implemented Not ready to be implemented as implemented as a real- application with minor application with major as a real-life application, but a real-life application life application adjustments adjustments has some potential Poor design Well-designed and user- Good design and user- Good design and user- 4 friendly friendly friendly Contains no errors Contains minimal errors Contains several errors Ability to explain code Explained all selected Explained the selected code Unable to explain some of the Unable to explain most of the Unable to explain any selected code clearly and with with minor shortcomings selected code adequately selected code code confidence 4 Shows insight Shows some insight Limited insight No insight Shows excellent insight Attitude and Kept to due dates One of the phases was not on None of the phases on time commitment Well-designed phases time Showed no commitment Showed exceptional Showed some commitment 2 commitment and pride in and pride in work done work done TOTAL: 14 Copyright reserved Please turn over

Information Technology Downloaded from hlayiso.com 24 DBE/PAT 2020 NSC Assessment Summary PHASE FOCUS MAXIMUM MARK MARK OBTAINED Phase 1 Analysis and Design 48 Phase 2 Coding and Implementation 78 General Final Product and Impression 14 TOTAL 140 Adjustment % Final mark (Total x Adjustment %) DECLARATION OF AUTHENTICITY I hereby declare that the work assessed is solely that of the learner concerned (except where there is clear acknowledgement and a record of any substantive advice/assistance given to the learner) and was conducted under supervised/controlled conditions to ensure that the work has not been plagiarised, copied from someone else or previously submitted for assessment by anyone. Comment/Feedback: __________________________________________________________________________________________________________________________________________ __________________________________________________________________________________________________________________________________________ Teacher name: _______________________________________ Teacher signature:___________________________________ Date:________________________ Copyright reserved Please turn over

Downloaded from hlayiso.com Information Technology 25 DBE/PAT 2020 NSC 2.11 ANNEXURE B: LEARNER DECLARATION Learner declaration – Phase ____ I understand that work submitted for assessment must be my own. Have you received help/information from any person to produce this work? No Yes (Provide details below.) Help/Information Nature of the help/information (Provide evidence): received from (person): _________________________ ___ / ___ / 2019 SIGNATURE OF LEARNER DATE Copyright reserved

Downloaded from hlayiso.com Information Technology 26 DBE/PAT 2020 NSC 2.12 ANNEXURE C: DECLARATION OF AUTHENTICITY Declaration of authenticity Learner name ID number Grade 12 Year 2020 Subject INFORMATION TECHNOLOGY Practical Assessment Task (PAT) Teacher 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 have not been plagiarised, copied from someone else or previously submitted for assessment by any person. _________________________ ___ / ___ / 2019 SIGNATURE OF LEARNER DATE Copyright reserved

Downloaded from hlayiso.com Information Technology 27 DBE/PAT 2020 NSC 2.13 Guidelines for teachers to provide guidance 2.13.1 What are the learners required to do and provide? Learners are required, with appropriate supervision, to:  Choose an area of interest within the topic/scenario provided  Formulate a focus question that can be investigated/researched  Plan, research and carry out the project  Deliver a report to a specified audience  Provide evidence of all stages of the project for assessment 2.13.2 How will learners go about it? Learners will:  Plan and complete an individual project, applying a range of programming and software engineering skills and strategies to meet the objectives as set out by the PAT requirements  Identify questions to ask  Obtain, critically select and use selected information from a range of sources, process and analyse data, apply it relevantly and demonstrate understanding of appropriate linkages, connections and complexities of the topic and focus question  Select and use a range of skills, including design tools and algorithms, solve problems, take decisions critically, creatively and flexibly, to produce a software solution  Evaluate outcomes, both in relation to PAT requirements and own learning and performance  Use appropriate communication skills and media to present evidence in an appropriate format 2.13.3 Skills required Learners must be able to:  Do a complete user requirement analysis which includes a complete description of the role, activities, requirements and limitations of at least TWO different users of the planned system  Bring together information to suit the content and purpose  Apply decision-making and problem-solving skills  Extend planning, research, critical thinking, analysis, synthesis, evaluation and presentation skills  Develop confidence in applying the content, programming and software engineering principles and techniques they have studied  Develop and apply skills creatively, demonstrating initiative and enterprise  Seek advice and support when needed Copyright reserved

Downloaded from hlayiso.com Information Technology 28 DBE/PAT 2020 NSC 2.13.4 What must the learners be taught beforehand? The taught elements include:  Application software and ICT skills that will enhance the production of the report and the development of the project covering analysis and execution  Solution development content and skills, including the ability to define a task  Project management skills, including time, resource and task management 2.14 Malpractice Learners may NOT:  Get help/guidance from other persons without acknowledgment (complete ANNEXURE B for EACH phase)  Allow others to do the programming code for their project  Submit work which is not their own  Lend work to other learners  Allow other learners access to, or the use of, their own independently-sourced source material (this does not mean that learners may not lend their books to another learner, but learners should be prevented from plagiarising other learners' research)  Include work copied directly from books, the internet or other sources, without acknowledgement and attribution  Submit work typed or word-processed by another person These actions constitute malpractice, for which learners will be penalised. If malpractice is identified, the assessment authorities must be notified and details of any work which is not the learner's own must be recorded. 2.15 Learner declaration of authenticity of the PAT For each phase, learners complete a declaration (ANNEXURE B) for the work done during that specific phase. All substantive advice/help given to the learners should be recorded as part of the phase documents. After completing the PAT, learners should sign the declaration of authenticity (ANNEXURE C) to confirm that the work submitted is their own. Copyright reserved

Downloaded from hlayiso.com Information Technology 29 DBE/PAT 2020 NSC 2.16 Role of the teacher The teacher will teach the information management content, skills and strategies prior to the project. While managing the project and supervising the learners, the teacher will:  Conduct an initial planning review to discuss the topic/scenario, requirements, objectives and development of the project  Agree on the focus question (learners should record the guidance given as part of the Phase 1 documents, e.g. where appropriate, record their own initial question with clear evidence of the guidance and the final question)  Give regular feedback to learners, e.g. to formulate a focus question that is suitable and manageable  Assess the work of the learners at the end of each phase using the standardised assessment tool and record feedback given  Endorse each learner's assessment by signing the assessment tools for each phase, including a final declaration that the evidence submitted for assessment is the unaided work of the learner  Confirm their evaluation based on continuous observation and feedback, as well as an interview session to provide a final judgement regarding independent work, insight and problem-solving  Make the assessment of the work of the learners following any standardising and internal moderation procedures required The teacher will assess the potential project (task definition and scope) against the following checklist:  Is the focus area suitable for the project?  Does the focus question allow the learner to investigate and access the higher-level concepts and skills in the assessment objectives, e.g. to plan, research, analyse, evaluate and explain, rather than simply describe and narrate?  Are the focus question and proposed action clear and focused on an issue that can be managed within the time frame and available resources?  Do the focus question and proposed action indicate that the learner will be capable of investigating and researching the topic and carrying out the activity or task independently and within appropriate ethical or methodological guidelines?  Is the learner likely to face difficulties understanding the task and issues associated with the focus question? The teacher will authenticate the PAT:  The teacher will confirm on the assessment tool that the work assessed is solely that of the learner concerned and was conducted under supervised/controlled conditions.  The teacher will sign the assessment tool of each phase. Copyright reserved

Downloaded from hlayiso.com Information Technology 30 DBE/PAT 2020 NSC 2.17 Supervised/Controlled conditions The PAT must be managed in such a manner to be able to confirm that the work assessed is solely that of the learner concerned. 2.18 Managing the PAT The teacher must plan his/her work schedule according to the time allocated for the PAT in the CAPS document for Information Technology (teaching plan for Grade 12). There are different possible approaches to managing the PAT: Option 1:  The teacher could dedicate a portion of the time on a weekly basis to the PAT while simultaneously continuing with normal teaching to complete the Grade 12 curriculum in the rest of the week.  If he/she choose this option, he/she should start with the PAT process towards the end of the first term, completing one phase per term. Option 2:  Teachers could dedicate a continuous period of time to the PAT, e.g. the last week(s) of each term, also completing one phase per term. 2.19 Evidence of assessment Evidence presented for assessment must show how the individual learner has met the assessment objectives and criteria and must include the planning, feedback and progress of the project. The evidence for assessment will include the following:  The project product, including the documentation/report (content only, without the cover page, table of contents, references, graphics), design documents, final program (fully documented) and other evidence (for each phase)  The completed learner assessment tool (for each phase) 2.20 Interview Guidelines for the evaluation of the project:  Schedule dates and times for demonstrations – allow about 15 minutes per project.  Take in all the documentation before the demonstration takes place – at least one week in advance – and evaluate the documentation before the demonstration session.  Learners should demonstrate their projects electronically on the computer. Copyright reserved

Downloaded from hlayiso.com Information Technology 31 DBE/PAT 2020 NSC  During the demonstration session learners should execute test procedures to show that the entire program is working correctly.  Use the mark sheet for Phase 2 as a guideline and allocate marks accordingly during the demonstration.  As part of the evaluation, identify random pieces of programming code in the project and ask the learner to explain the purpose and working of the randomly selected code. This is done to ensure that the learner did the coding him-/herself. A similar type of procedure will be followed during moderation. If a learner cannot explain the code used in the project, a mark of zero should be awarded for the project.  Make sure that the learner hands in the electronic copy of the project that was demonstrated. Use this copy to allocate any outstanding marks in order to finalise the mark. 2.21 Requirements (National Protocol for Assessment Grades R –12, Chapter 3) Practical assessment task components must:  Comprise assessment tasks that constitute the learner's PAT mark as contemplated in Chapter 4 of the IT CAPS  Include a mark awarded for each assessment task (phase), as well as a consolidated mark  Be guided by assessment components as specified in Chapter 4 of the IT CAPS  Be available for monitoring and moderation  Be evaluated, checked and authenticated by the teacher before being presented as the learner's evidence of performance 2.22 Non-compliance (National Protocol for Assessment Grades R –12, Chapter 3) The absence of a PAT mark in IT, without a valid reason, will result in the learner not being resulted for the subject. The learner will be given up to the first week of Term 3 to submit outstanding work or present him-/herself for the PAT. Should the learner fail to fulfil the outstanding PAT requirements, such a learner will be awarded a zero ('0') for the PAT component for IT. In the event of a learner not complying with the requirements of the PAT, but where a valid reason is provided:  He/She may be granted another opportunity to be assessed in the assigned tasks, based on a decision by the head of the assessment body  The learner must, within three weeks before the commencement of the final end-of-year examination, submit outstanding work or present him-/herself for the PAT  Should the learner fail to fulfil the outstanding PAT requirements, the mark for the PAT component will be omitted and the final mark will be adjusted for promotion purposes in terms of the completed tasks Copyright reserved

Downloaded from hlayiso.com Information Technology 32 DBE/PAT 2020 NSC Valid reasons in this context 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  The learner appearing 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 3. CONCLUSION Upon completion of the practical assessment task, learners should be able to demonstrate their understanding of the industry, enhance their knowledge, skills, values and reasoning abilities, as well as establish connections to life outside the classroom and address real-world challenges. Furthermore, the PAT develops learners' life skills and provides opportunities for learners to engage in their own learning. Copyright reserved