Task 2

TASK 2 (AO6): Working with the TradersDatabase

Teacher Guidancefor Task 2:

  • Pupils will need to download the 'Traders' database, this is available in Access, Excel and CSV format for importing into another database package
  • At this stage it would be a good idea to remind students of the structure of a database and to ensure they fully understand the following:
    • Fields
    • Data type
    • Key fields
    • Queries - simple and complex
    • Sorting
    • Reports
    • Editing data in a database
  • Whilst some scenarios have been given for the students to complete you may wish to undertake a group activity to identify possible scenarios and information that the management team may require from the database
  • A brainstorming activity could be undertaken before downloading the database to establish the possible fields that would be required in the database. This can then be compared with the fields used in the ‘Traders’ database

OCR EvidenceRequirements

Assessment Objective 6 requirescandidates to use a realisticbusiness database. Candidates must not use search engines to evidence thisassessment objective. There is no requirement in this unit to set up adatabase. Centres should provide candidates with a database. This shouldcontain sufficient records to make searching and sorting realistic andworthwhile tasks.

Candidates should provide evidence ofthe design and results of queries and the reports carried out for specifiedpurposes, either in printed form or by providing the electronic file. Thepurposes may be specified by the candidates or by the centre in the form of aseries of tasks. However, tasks must not specify the exact criteria forcandidates to use. For example, it would be appropriate for a task to statethat a user requires a list of all customers who live in Leeds, in alphabeticalorder of last name. It is not acceptable for a task to specify that a query isto be set up where Town = Leeds, sorted on last name in ascending order.Searches using more than one criterion may use Boolean operators (AND and/orOR) or may achieve these effects using options in the software. Sorting must beincluded in a query, this may be the same query that includes the searchcriteria or it might be an additional query.

For Distinction the two different typesof report that are required can be produced from the same query or from twodifferent queries – what is important is that two types of report are evidenced– and that each report displays the data effectively. For example a query tolist all the customers living in Leeds may be used to generate address labelsand an alphabetical list of customers.

Essential SkillsWales - Level 2:

AO6 - Evidence from this task must beat Distinction level to meetrequirements of ESW at L2

Materials created for the above task mayalso provide evidence to support:

ICT2.1.1 - Describe how you will approach an activitythat involves the use of ICT (Workbook - Brieflydescribe your task)

ICT2.1.2 - Use ICT independently to carry out the activity effectively (Workbook - annotated screenshots)

ICT2.2.1 - Find, select and use different sourcesof appropriate ICT-based and non-ICT-basedinformation (Workbook - how the candidatefound, selected and used sources, together with an explanation of why thesources selected were appropriate to the task)

ICT2.2.2 - Search for, select and get relevantICT-based and non-ICT-based information (Workbook – simple and complex searches)

ICT2.3.1 - Enter, organise, develop, format and combineICT-based and non-ICT-based information to suit content and your purpose, inthe form of: a) text, b) tables, c) images, d) numbers, e) records (Workbook – editingthe database, developing and naming queries and reports)

ICT 2.3.2 - Present combined information,using consistent formats and layouts that are appropriate to your purpose and audience,using ICT, and review your work (Workbook –producingreports that are fit for purpose)
Diweddarwyd diwethaf: Tuesday, 8 May 2012, 4:16 PM