Screenshot or printout of list of Lists are accurate. female customers. Screenshot of query design. Screenshot or printout of list of male customers. Screenshot of query design Query Attach a printout of the list of Data is queried correctly. Task 3 Q2 customers who were born before 1 Lists are accurate. February 1970. Screenshot of query design. Screenshot of query design Report Attach a copy of the Report that The Report identifies the number of customers that Task 3 Q3 identifies how many customers can can be contacted by post mail, SMS, email. be contacted by. Sufficiency for ER 1.1: All required correct for filter, query, merge, statistical, financial and logical. Two of Task 1 Q1, Task 2 Q1 and Task 3 Q1 correct for ‘sort’ Three of Task 1 Q4, Task 1 Q7, Task 2 Q3. ER 1.2 Task 1 Q7 Formula used to classify prices as Learner selects appropriate function to create a and column showing and price range for ‘Low’ ‘High’. ‘Low’ ‘High’ bags. Problem-solving and Screenshot of data with additional techniques are applied to function most appropriate. ‘If’ column showing Price range. meet stakeholder needs and Learner selects appropriate function for displaying requirements of the entity. proportional data. Labels on graph accurately describe the data. Task 2 Q2 Copy of letter addressed to customer Content of letter is appropriate for customers and supplies required information. informing them about a 30% special sale offer. Customer information merged into letter enables letter to be delivered to the customer.
Screenshot or printout of list of female customers. Screenshot or printout of list of male customers. Screenshot of query design Lists are accurate. Screenshot of query design. Query Task 3 Q2 Attach a printout of the list of customers who were born before 1 February 1970. Screenshot of query design Data is queried correctly. Lists are accurate. Screenshot of query design. Report Task 3 Q3 Attach a copy of the Report that identifies how many customers can be contacted by. The Report identifies the number of customers that can be contacted by post mail, SMS, email. Sufficiency for ER 1.1: All required correct for filter, query, merge, statistical, financial and logical. Two of Task 1 Q1, Task 2 Q1 and Task 3 Q1 correct for ‘sort’ Three of Task 1 Q4, Task 1 Q7, Task 2 Q3. ER 1.2 Problem-solving and techniques are applied to meet stakeholder needs and requirements of the entity. Task 1 Q7 Formula used to classify prices as ‘Low’ and ‘High’. Screenshot of data with additional column showing Price range. Learner selects appropriate function to create a column showing ‘Low’ and ‘High’ price range for bags. ‘If’ function most appropriate. Learner selects appropriate function for displaying proportional data. Labels on graph accurately describe the data. Task 2 Q2 Copy of letter addressed to customer informing them about a 30% special sale offer. Content of letter is appropriate for customers and supplies required information. Customer information merged into letter enables letter to be delivered to the customer.
29026-Assessor-guidelines.docx