How do I get good marks? - creating a database

• Look carefully at the data set you have been given.
• Design a suitable database with sensible fields and data types.
• Include sensible validation.
• Import the data set you have been given.
• Make use of your plan.

What will lose me marks? - creating a database

• If you need help to design or create your database or to analyse your information.
• If you produce a poorly designed database.

How do I get good marks? - creating a data entry form

• Design a data entry form that is easy to use
• Include helpful features such as messages, validation, dropdown menus,etc
• Test your data entry form by adding records
• Add additional records without errors
• Make use of your plan

How do I get good marks? - extracting information

• Think about what information you want to get from the database
• Design and run queries that will produce the information you need
• Present your results clearly in well designed reports that make sense to other people - e.g. use sensible titles and column headings
• Make use of your plan.

What will lose me marks? - extracting information

• If you run queries from your database that give results that are not important or don't make sense.
• If your reports do not make sense

How do I get good marks? - creating a questionnaire and spreadsheet

• Design your questionnaire and spreadsheet at the same time
• Make sure the questionnaire will gather the information you need.
• Make sure that the data you collect can be analysed using a spreadsheet
• Avoid biased questions.
• Decide what formulae you will need to give you the information you require.
• Test your spreadsheet to make sure it is error-free and that it can process the data you collect
• You need to check your work and modify it.
• Use feedback from others such as your tutor or peers to make improvements.
• Use the spreadsheet to present results in meaningful ways such as charts.
• Make use of your plan.

What will lose me marks? - creating a spreadsheet

• If you produce a poorly designed spreadsheet.
• If you use formulae that do not provide useful information.
• If you do not provide FORMULAE view versions of your spreadsheet.
• If you do not check your work for accuracy and quality.
• If you do not use the spreadsheet to present results effectively