Unit R002 Using ICT to create business solutions (OCR Set task - Wizards and Templates CANNOT be used) Name: LO2: Be able to select and use software to handle data Lower Mark Band (1-6) Middle Mark Band (7-11) Upper Mark Band (12-15) Creates a spreadsheet or database Creates a spreadsheet or database Creates a spreadsheet or database importing P1 M1 D1 importing data with accuracy importing data accurately which data with accuracy which some mostly complete fully which meets some of the specified meets most of the specified requirements. meets the specified requirements. requirements. Sig Sig Sig and manipulates data with some Edits and manipulates data mostly Edits and manipulates data with complete P2 M2 D2 accuracy and provides some relevant accurately and provides mostly relevant accuracy and provides wholly relevant information to meet particular purposes. information to meet particular purposes. information to meet particular purposes. Sig Sig Sig The choice of data-handling software The choice of data-handling software used The choice of data-handling software used is P3 M3 D3 used is of limited appropriateness to is of sound appropriateness to the wholly appropriate to the audience and the audience and purpose. audience and purpose. purpose. Sig Sig Sig row labels o formulae involving arithmetic operators2, i.e. +.-,*,/ o simple functions2, i.e.: o SUM – AVERAGE – Content MIN – Learners must be taught how to use software to handle data, i.e.: MAX – Creating business spreadsheets: IF – Import/open csv files and save in an appropriate file type cell references, i.e. relative, absolute o • enter title, column headings and row labels Editing and manipulating data in spreadsheets: • enter2/import data, i.e.: insert and delete rows/columns • • text change/amend data in cells o • numeric o amend formulae • title o change data to model outcomes • column/field headings search data o •
Unit R002 Using ICT to create business solutions (OCR Set task - Wizards and Templates CANNOT be used) Name: LO2: Be able to select and use software to handle data Lower Mark Band (1-6) Middle Mark Band (7-11) Upper Mark Band (12-15) P1 Creates a spreadsheet or database importing data with some accuracy which meets some of the specified requirements. M1 Creates a spreadsheet or database importing data mostly accurately which meets most of the specified requirements. D1 Creates a spreadsheet or database importing data with complete accuracy which fully meets the specified requirements. Sig Sig Sig P2 and manipulates data with some accuracy and provides some relevant information to meet particular purposes. M2 Edits and manipulates data mostly accurately and provides mostly relevant information to meet particular purposes. D2 Edits and manipulates data with complete accuracy and provides wholly relevant information to meet particular purposes. Sig Sig Sig P3 The choice of data-handling software used is of limited appropriateness to the audience and purpose. M3 The choice of data-handling software used is of sound appropriateness to the audience and purpose. D3 The choice of data-handling software used is wholly appropriate to the audience and purpose. Sig Sig Sig Content Learners must be taught how to use software to handle data, i.e.: Creating business spreadsheets: • Import/open csv files and save in an appropriate file type • enter title, column headings and row labels • enter2/import data, i.e.: o text o numeric o title o column/field headings o row labels o formulae involving arithmetic operators2, i.e. +.-,*,/ o simple functions2, i.e.: – SUM – AVERAGE – MIN – MAX – IF o cell references, i.e. relative, absolute Editing and manipulating data in spreadsheets: • insert and delete rows/columns • change/amend data in cells • amend formulae • change data to model outcomes • search data
Cambridge%20Nationals%20R002%20LO2%20Mark%20Sheet.docx