......Homee.. |....  Overview.... |.... Lessons.....|....  Assessment..... ....

Assessment > Medium term > Assessment criteria

The following may be considered as medium term assessment :

Although you will use the level descriptors to make a 'summative best fit' assessment at the end of the key stage, you will probably also like to monitor pupils progress at the end of each unit of work.

The following criteria bank only relates to this unit and its purpose is to :

  • Break the assessment of the unit into small manageable parts, enabling
    • teachers to identify areas of achievement
    • give confidence to pupils by showing progress, however small
    • inform future planning
  • Enable staff to show progress with individual pupils or whole classes.
  • To provide data for statistical analysis
Expectation from this unit can be summarised as :
  • Most pupils will:
    • understand how a database organises its data and how Microsoft Access uses objects to store, view, search and report information. This may vary depending upon the software used by the school. Pupils will use a prepared database to learn about searching and reporting. They will create one of their own, entering records from a data capture sheet and making advanced searches. They will have an understanding of the Data Protection Act.

  • Some pupils will not have made so much progress and will:
    • understand the basics of how a database works and the various parts of the schools database program. They will use a prepared example to make single keyword searches and view the information found. With help they will use wizards to create a simple database and enter records. They may have created their own data capture sheet or use a previously prepared one. Pupils understand the implications of having data about themselves held on a computer. They will give examples of where this occurs.

  • Some pupils will have progressed further and will:
    • be able to describe various database solutions and the data that they may hold. They will be able to relate this to the Data Protection Act. Pupils will use an example database to search and view information using advanced search techniques. They will create a database of their own entering records from a data capture sheet that had been previously designed. With help, pupils can create tables, forms, queries and reports in Microsoft Access


Levels are reported as whole numbers with intermediate progress as letters.
Each level subsumes the previous level.

If this unit has been completed as a paired activity thought must be given to how evidence of individual progress is gathered.

Level
Skill
Knowledge & Understanding
4

With help, can use the basic tools of a database program.

Can make keyword searches to find information.

With help they will create a simple database using wizards without making choices of their own.

Pupils will offer obvious examples of where databases are used, e.g. school.

They will describe the type of data that these databases hold.
4c
 Can use the tools within a database to view the records, make searches using prepared queries and look at reports.

Can create their own database using wizards without making choices of their own.

Have used a data capture sheet and can describe its function.

Better understanding shown of database use.

Can describe the component parts, e.g. records and fields.

Pupils have an understanding of the database software that the school uses. They can name the equivalent parts to Microsoft Access 'objects'.

4b
 Can create a database using wizards and with help has made decisions at each step.

Can search using multiple criteria and prepared queries.

Can give examples where databases are used in society and the type of data they hold.

Understands the implications of holding personal information on a computer and whether there needs to be any safeguards.

Has some understanding of the Data Protection Act.

 
4a
 Can create a database using wizards and has made autonomous decisions at each step.

Can search using multiple criteria and prepared queries.

Can edit existing queries to find new information.

Can give good examples where databases are used in society and the type of data they hold.

Understands that safeguards need to be taken to protect individuals and their personal information held on computers.

Has a better understanding of the Data Protection Act principles.
5

This level can be used to identify pupils who can:

  • use the basic database tools independently and reliably.
  • create a data base for themselves choosing which parts of a wizard to include.
  • enter data into a table or form from a previously designed and completed data capture sheet.

Pupils understand the options that wizards offer and can make choices based on an expected outcome.

They have a better understanding of data types and can select to use the most appropriate one when creating fields.
5c

This level can be used to identify pupils who can:

  • edit forms, queries and reports that they have previously created.
  • design and create data capture sheets that use a range of data types.

To edit various objects, pupils will need a better understanding of the audience so that the presentation is appropriate.

Pupils show a good understanding of data capture methods and can give examples other than paper based models.
5b

Pupils can design a simple database from a set of specifications, creating and completing a data capture system.

With little help they can either:

  • Use wizards, selecting appropriate options.
  • Manually create objects.

Either option, pupils are now autonomous uses of the database.

Pupils can use keywords effectively to search the database including multiple criteria queries. The results are displayed in report format and this may have been edited.

Pupils have a reasonable understanding of databases in the wider context and can give examples of where data about themselves is kept. They can relate this to the Data Protection Act and they will have views about its effectiveness, e.g. what precautions are taken by the school to keep personal data secure?

Pupils have a satisfactory understanding of database creation that enables them to work autonomously.
5a

This level can be used to identify pupils who have:

  • Completed all the activities in the unit.
  • Can independently identify when to use the different database tools.
  • Can create a database for themselves, making changes to put right mistakes and editing reports so that they are presented well.
  • Can create their database with an audience in mind making it 'fit for purpose'.

Can use simple validation rules when setting up tables.

At this level pupils have a good understanding of databases, the various parts and where they are used in society. They can describe the role of the Data Protection Act.

Pupils understand that the database needs to be 'fit for purpose' and that the design of forms and reports needs to be appropriate.

Pupils understand 'validation' and have entered criteria to enable this to work with some fields.

Understands that data can be checked by the software for errors in entry.

6

At this level, pupils should be able to design their own database system including their own choice of fields and data types.

The complexity should be sufficient to require some form of relationships.

A switchboard menu would possibly be included to help users navigate the database.

This unit of work does not include these skills.

This level requires pupils to have a much deeper understanding of how the database stores and uses its data, including the use of relationships.

This unit of work does not require pupils to work at this level.