NQF5 Robotics Processing Automation Developer (RPA) – 251201004-PM-03, Access, Analyse and Visualise Structured Data using Spreadsheets and Scraping Tools

SECTION 3: CURRICULUM COMPONENT SPECIFICATIONS – SECTION 3B: PRACTICAL MODULE SPECIFICATIONS

SECTION 3B: PRACTICAL SKILLS MODULE SPECIFICATIONS 3. 251201004-PM-03, Access, Analyse and Visualise Structured Data using Spreadsheets and Scraping Tools, NQF Level 5, Credits 6 3.1 Purpose of the Practical Skills Module The focus of the learning in this module is on providing the learner with an opportunity to acquire the skills to use spreadsheets to analyse and visualise data The learner will be required to: PM-03-PS01 : Report data using spreadsheets PM-03-PS02 : Summarise and format data using spreadsheet tables PM-03-PS03 : Create, use and edit pivot tables and pivot charts PM-03-PS04 : Create, use and edit dashboards PM-03-PS05 : Create and configure hierarchies and time data PM-03-PS06 : Apply a spreadsheet data model PM-03-PS07 : Import data from files PM-03-PS08 : Import data from databases PM-03-PS09 : Import data from reports PM-03-PS10 : Visualize data PM-03-PS11 : Scrape data from the web using an appropriate tool 3.2 Guidelines for Practical Skills 3.2.1 PM-03-PS01 : Report data using spreadsheets Scope of Practical Skill Given a suitable problem to solve, the learner must be able to: PA0101 Create spreadsheet report PA0102 Filter and format data PA0103 Create charts Applied Knowledge AK0101 Data analysis AK0102 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0101 Reporting is done by creating charts or spreadsheets containing the correct data 3.2.2 PM-03-PS02 : Summarise and format data using spreadsheet tables Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0201 Create a table PA0202 Summarise data PA0203 Sort, filter, and validate data PA0204 Format summarized data Applied Knowledge AK0201 Data analysis AK0202 Spreadsheet functions and capabilities Internal Assessment Criteria 251201004 - Occupational Certificate: Robotic Processing Automation (RPA) Developer Page 62 of 108 IAC0201 A spreadsheet table is created and summarized data sorted, filtered, validated and formatted 3.2.3 PM-03-PS03 : Create, use and edit pivot tables and pivot charts Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0301 Use pivot tables and pivot charts PA0302 Import data from a CSV file PA0303 Create a pivot table PA0304 Edit pivot tables and pivot charts Applied Knowledge AK0301 Data analysis AK0302 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0301 Pivot tables and charts are created, used and edited, using data imported from a CSV file 3.2.4 PM-03-PS04 : Create, use and edit dashboards Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0401 Create dashboards PA0402 Conduct data analysis in excel pivot tables PA0403 Arrange tables and charts PA0404 Slice data PA0405 Filter data using a slicer PA0406 Add calculated columns to a dashboard PA0407 Find anomalies Applied Knowledge AK0401 Data analysis AK0402 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0401 Excel dashboards are created containing data backed tables and charts, data are sliced, filtered and calculated and anomalies found 3.2.5 PM-03-PS05 : Create and configure hierarchies and time data Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0501 Create a hierarchy PA0502 Configure time data PA0503 Create an animated time chart Applied Knowledge AK0501 Data analysis 251201004 - Occupational Certificate: Robotic Processing Automation (RPA) Developer Page 63 of 108 AK0502 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0501 Hierarchies are created on a spreadsheet, time data are configured and ultimately an animated time chart is created 3.2.6 PM-03-PS06 : Apply a spreadsheet data model Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0601 Explore an excel data model PA0602 Add multiple tables PA0603 Create relationships PA0604 Add external data PA0605 Import external data and use it PA0606 Link out to external data PA0607 Use the DAX (data analysis expressions) function PA0608 View data within a spreadsheet data table Applied Knowledge AK0601 Data analysis AK0602 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0601 A spreadsheet data model is applied for integrating data from various imported tables and creating relationships between them 3.2.7 PM-03-PS07 : Import data from files Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0701 Pre-format and import CSV files PA0702 Import data into the software program PA0703 Shape and transform data PA0704 Load data Applied Knowledge AK0701 Data analysis AK0702 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0701 Data are imported from pre-formatted files into excel and configured 3.2.8 PM-03-PS08 : Import data from databases Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0801 Import data into excel from a SQL server database PA0802 Identify available data sources 251201004 - Occupational Certificate: Robotic Processing Automation (RPA) Developer Page 64 of 108 PA0803 Preview, shape, and transform data PA0804 Table relationships and hierarchies PA0805 Load data Applied Knowledge AK0801 Data analysis AK0802 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0801 Data are imported into excel from various identified databases and configured, taking table relationships and hierarchies into account 3.2.9 PM-03-PS09 : Import data from reports Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA0901 Import data from spreadsheet reports PA0902 Transform spreadsheet report data Applied Knowledge AK0901 Data analysis AK0902 Spreadsheet functions and capabilities Internal Assessment Criteria IAC0901 Data are imported from spreadsheet reports and converted 3.2.10 PM-03-PS10 : Visualize data Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: PA1001 Create and format measures PA1002 Visualize data using: Pivot charts Cube functions Charts for cube functions PA1004 Create and refine a pivot chart Applied Knowledge AK1001 Cube functions and when to use them AK1002 A number of charts for use with cube functions Internal Assessment Criteria IAC1001 Data is visualized in excel with created and refined pivot charts and charts with cube functions in order to produce a graphical representation of a set of data 3.2.11 PM-03-PS11 : Scrape data from the web using an appropriate tool Scope of Practical Skill Given a suitable problem to solve, a PC or laptop and spreadsheet software, the learner must be able to: 251201004 - Occupational Certificate: Robotic Processing Automation (RPA) Developer Page 65 of 108 PA1101 Apply web scraping procedure: Find the URL to scrape Inspecting the page Find the data you want to extract Write the code Run the code and extract the data Store the data in the required format PA1102 Import data to spreadsheet or local file Applied Knowledge AK1101 Purpose of data scraping AK1102 Data scraping tools AK1103 Legal issues AK1104 Web scraping procedure Internal Assessment Criteria IAC1101 Required data is scraped from the web using appropriate procedure 3.3 Provider Programme Accreditation Criteria Physical Requirements: Valid licenses software and application, including OS. Internet connection and hardware availability Examples and information specified in the scope statement and all the case studies, scenarios and access to hardware and software implied in the scope statements of the modules. Remote learners: Provider must provide business IT simulation system (e.g., invoice processing). Human Resource Requirements: Lecturer/learner ratio of 1:10 (Maximum) Qualification of lecturer (SME): o NQF 6 industry recognised qualification with 1 year’s experience in the IT industry o RPA vendor certification Assessors and moderators: accredited by the MICT SETA Legal Requirements: Legal (product) licences to use the software for learning and training OHS compliance certificate Ethical clearance (where necessary) 3.4 Exemptions No exemptions, but the module can be achieved in full through a normal RPL process