1 / 16

OCR Nationals ICT – Unit 1

OCR Nationals ICT – Unit 1. Task 6 Grade A. Task Overview.

pegeen
Download Presentation

OCR Nationals ICT – Unit 1

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. OCR Nationals ICT – Unit 1 Task 6 Grade A Task Overview. In this task, you will update and use a database file called Hosts, which you will need to download and save. This database contains details of host families who are able to accommodate staff and students when they are in Paris. You will enter, edit and delete data appropriate to the needs of the French department. You will search for data relevant to the trip and for the higher levels you will also sort data and print report(s). • Using the Booklet. • This booklet contains everything you will need to complete this task, divided up into 2 sections. • RED SECTIONS – Explain exactly WHAT you have to do. • GREEN SECTIONS - Give you the space to put your evidence

  2. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 – U1T6S2 – Unchanged database You need a screenshot of your unchanged database TABLE here before you start.

  3. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part A Part A Update the database as follows: A new host family has just joined the exchange scheme. They live in the St Germain district and can accommodate 2 guests. They offer vegetarian cuisine, have 1 child and speak English. Their rating is excellent and they have been allocated Reference F1300. Add a new record for this host family. Edit the record for F1101 – this family are now able to accommodate 2 guests. The host family with the reference F1909 has withdrawn from the scheme. Delete this entire record from the database. Check your amendments carefully to ensure that you have not made any errors.

  4. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part A1 – U1T6S4 – First change Using text and images, explain the first change you made to the database.

  5. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part A2 – U1T6S5 – Second change Using text and images, explain the second change you made to the database.

  6. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part A3 – U1T6S6 – Third change Using text and images, explain the third change you made to the database.

  7. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part B Part B The trip organisers would prefer to place students with hosts who have an excellent rating. The trip organisers will need to know the host reference, the district where the hosts are located and how many guests the host is able to accommodate. You must create and save a query to find this information. You should display the data in alphabetical order of district.

  8. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part B – U1T6S8 – Query design Using text and images, show the design of the query you created.

  9. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part B – U1T6S9 – Query results Using text and images, show the results of the query you created.

  10. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part C Part C Present the results of this query in a suitable report. Once you have created the report, you should save it as a PDF and send it to me.

  11. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part C – U1T6S11 – Report Using text and images, show how you created the report.

  12. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part D Part D Some students have special dietary requirements. The trip organisers would like to find out which hosts offer Vegetarian, Vegan or Halal cuisine. The trip organisers will need to know all the information about each of these hosts. Create and save a query to find this information. This query should display the data in numeric order of the number of guests that can be accommodated.

  13. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part D – U1T6S13 – Query design Using text and images, show the design of the query you created.

  14. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part D – U1T6S14 – Query results Using text and images, show the results of the query you created.

  15. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part E Part E Present the results of the query in Part D in a suitable report. You must choose a different report format from the one that you used for your first query. Once you have created the report, you should save it as a PDF and send it to me.

  16. OCR Nationals ICT – Unit 1 Task 6 Grade A Task 6 Part E – U1T6S16 – Report Using text and images, show how you created the report.

More Related