Task 3 Final Submission Instructions

What This Submission Is For

Task 3 is assessed through the three-week database practical sequence. There is no separate one-day assessment after the sequence.

Your final submission is the finished evidence package from the database lessons. It must show the database you built, the views and reports you created, and the documentation that explains your decisions.

Final Product

Your final product must include:

1. one Microsoft List used as a single-table database
2. suitable fields and data types
3. a required unique LoanID primary key equivalent
4. at least 12 realistic equipment loan records
5. a usable new/edit item form
6. at least 4 saved query views
7. at least 2 saved report views
8. a clear visual interface for a staff user
9. completed Microsoft Lists view evidence
10. completed database documentation

What To Submit In The LMS

Submit these three items:

1. Evidence document
   • File name: CSCGT_Task3_2026_Surname_FirstName_Evidence.docx
   • This is your main evidence document.
   • It must include your documentation, screenshots and short explanations.
2. Excel data export
   • File name: CSCGT_Task3_2026_Surname_FirstName_DataExport.xlsx
   • Export your Microsoft List to Excel.
   • Open the file before submitting and check that it includes your submitted records.
3. Microsoft Lists share link
   • Paste the link into the LMS submission comment box.
   • Share the List with your teacher using school account access.
   • Keep the List available until marking and any moderation checks are complete.

Evidence Document Order

Your evidence document should be organised in this order:

1. student details and Microsoft Lists share link
2. database purpose and intended users
3. table/list structure explanation
4. data dictionary
5. primary key explanation
6. screenshots of fields, data types and records
7. form screenshot and form explanation
8. query view screenshots and explanations
9. report view screenshots and explanations
10. visual interface explanation
11. testing, limitations and improvements
12. final checklist

Screenshot Checklist

Include clear screenshots for:

• full list/table or main records view
• column names and data type evidence where possible
• LoanID values
• new/edit item form
• each saved query view
• each saved report view
• visual interface or view navigation

Screenshots should show your list name or your name where possible.

Final Check Before Submitting

• My evidence document is named correctly.
• My Excel export is named correctly.
• My Microsoft List is shared with my teacher.
• My Microsoft Lists share link is pasted into the LMS comment box.
• My evidence document includes screenshots in the correct order.
• My Excel export opens and shows my final records.
• My saved query and report views are visible in Microsoft Lists.
• My documentation describes my actual database, not just definitions.

Important

Do not delete or rename your Microsoft List after submitting. Your teacher may need to open the live List to verify forms, saved views, report views and interface choices.