k"dIDNSUBJECTCUNITCLEVELCDESCCþPOINTCþQUESTIONCþ 1.00000ICT OCR ICT A project 1B DB 1-2 . . Look at the data stored in a database - Use the database your teacher supplies to answer the questions supplied 2.00000ICT OCR ICT A project 1B DB 1-2 . . Find answers to questions using the data in the database - Create and use queries to answer the questions 3.00000ICT OCR ICT A project 1B DB 3-4 . . Sort the database into order - Sort at least one database field into ascending or descending order 4.00000ICT OCR ICT A project 1B DB 3-4 . . - Describe how you sorted the database. Use screen dumps. 5.00000ICT OCR ICT A project 1B DB 5-7 . . Change some of the data in the database when appropriate (edit data - make changes - correct errors) - Print out the data and highlight the errors 6.00000ICT OCR ICT A project 1B DB 5-7 . . - Correct the errors and print a corrected version 7.00000ICT OCR ICT A project 1B DB 5-7 . . - Make changes to the data in the database - you must change at least two records 8.00000ICT OCR ICT A project 1B DB 8-10 . . Ask people questions to get more data to add to the database - Make a form for getting the data to put in the database 9.00000ICT OCR ICT A project 1B DB 8-10 . . - Get people to fill in the form. 10.00000ICT OCR ICT A project 1B DB 8-10 . . Add this new data to the database - Add the data from the data capture form to the database 11.00000ICT OCR ICT A project 1B DB 11-13 . . Develop a method of collecting data (design a dc form) - Make a form for getting the data to put in the database 12.00000ICT OCR ICT A project 1B DB 11-13 . . Create a database using this data - Make the database in your chosen software and enter some real (not made-up) data 13.00000ICT OCR ICT A project 1B DB 11-13 . . Visually check the database for accuracy - Check the data and highlight any errors (there must be errors!) 14.00000ICT OCR ICT A project 1B DB 11-13 . . Search the database for answers to specific questions (answer the questions you have set) - Write a series of questions you want to be able to answer from your database. Add them to your introduction. 15.00000ICT OCR ICT A project 1B DB 11-13 . . - Make queries to answer the questions 16.00000ICT OCR ICT A project 1B DB 14-16 . . Collect a range of data - Data capture forms filled in from a variety of people, or from different places. Say where the data comes from. 17.00000ICT OCR ICT A project 1B DB 14-16 . . Create a database using selected data - Within the data you collect you should identify some which, for some reason, is unsuitable (eg it may be incomplete) 18.00000ICT OCR ICT A project 1B DB 14-16 . . Edit the database in light of the mistakes found - Highlight the errors and print a corrected version of the errors you found 19.00000ICT OCR ICT A project 1B DB 14-16 . . Search the database, using the results of previous searches, for answers to specific questions - Create queries with a search on a second field (complex search) - your questions must allow for this! 20.00000ICT OCR ICT A project 1B DB 17-19 . . Check the database for accuracy using validation routines - Include validation checks in your database 21.00000ICT OCR ICT A project 1B DB 17-19 . . - Use screen dumps to explain your validation checks 22.00000ICT OCR ICT A project 1B DB 17-19 . . Using more than one condition, search the database for answers to specific questions - Create complex queries with AND or OR in the criteria - your questions must allow for this! Show screen dumps 23.00000ICT OCR ICT A project 1B DB 20-22 . . Give reasons for the choice of software. - Explain why you chose your database software compared with alternative software that could do the job 24.00000ICT OCR ICT A project 1B DB 20-22 . . - Explain why you didn't use the available alternative software 25.00000ICT OCR ICT A project 1B DB 23-25 . . Give reasons for the choice of fields, field types and lengths (ie in field definition table) - Write an explanation of why you included each field in your database 26.00000ICT OCR ICT A project 1B DB 23-25 . . - Write an explanation of why you decided on each field length in your database 27.00000ICT OCR ICT A project 1B DB 23-25 . . - Write an explanation of why you decided on each field data type in your database 28.00000ICT OCR ICT A project 1B DB 26-28 . . Identify the required output for a given task - Write an introduction to what you are designing a database for 29.00000ICT OCR ICT A project 1B DB 26-28 . . - Make a list of all the outputs you require from your database. Add it to your introduction 30.00000ICT OCR ICT A project 1B DB 26-28 . . - Explain why you chose the fields on your data capture form 31.00000ICT OCR ICT A project 1B DB 26-28 . . Give reasons for the relevance of their choice of software to the required output - Explain why your chosen software is the best one to be able to get the outputs you have identified. 32.00000ICT OCR ICT A project 1B DB 26-28 . . Give reasons for the relevance of their choice of fields, field types and lengths to the required output - Explain why the fields you have chosen allow you to collect the data needed to get the outputs you have identified 33.00000ICT OCR ICT A project 1B DB 26-28 . . Comment upon how easy it is to use the software to produce the required output - Explain how easy it was to get the software to search to get the answers to the questions you set 34.00000ICT OCR ICT A project 1B DB 26-28 . . Comment upon how easy it is to produce the required output in different forms of tables and graphs. - Explain how easy it was to get the software to produce reports, tables and graphs.