Task 3 Database Practical Assessment
Build, refine and submit a Microsoft Lists equipment loans database across the three database lesson weeks.
Assessment Evidence
- 1. Evidence DOCX with screenshots and explanations
- 2. Excel export of the Microsoft List data
- 3. Microsoft Lists share link in the LMS comment box
- 4. Live List kept available until marking and moderation checks are complete
Submission Method
What To Submit
Submit all three items through the LMS at the end of Week 3. The files become the permanent evidence, while the share link lets your teacher verify Microsoft Lists features that do not export cleanly.
Evidence document
Completed documentation template with screenshots and short explanations in rubric order.
Data export
Microsoft List exported to Excel so fields, records, LoanID values and sample data can be checked efficiently.
Microsoft Lists share link
Shared with the teacher so forms, saved query views, report views and interface choices can be verified live.
Week 1
Build the Database Foundation
Use the Week 1 workbook to plan, create and test the Microsoft List that acts as the single-table database.
Week 2
Create Query Views, Reports and Interface
Use the Week 2 workbook to turn the equipment loans list into saved query views, report views and a usable interface.
Week 3
Document and Submit the Final Product
Use the Week 3 workbook to document the database, check the final product and prepare evidence for LMS submission.
Microsoft Lists Mapping
| Database term | Task 3 evidence |
|---|---|
| Table | Microsoft List |
| Field | Column |
| Record | Item |
| Data type | Column type |
| Primary key | Required unique LoanID column |
| Form | New/edit item form |
| Query | Saved filtered, sorted or grouped view |
| Report | Saved report-style view |
| Visual interface | Clear list navigation, view names, form order and selected columns |
Marking Summary
Build Requirements
Equipment Loans Fields
| Field | Column type | Example | Purpose |
|---|---|---|---|
| LoanID | Single line of text | LOAN-001 | Unique identifier for each loan record |
| ItemName | Single line of text | Canon camera | Name of the borrowed item |
| Category | Choice | Camera | Groups items into consistent categories |
| BorrowerName | Single line of text | Jordan Lee | Person borrowing the item |
| YearLevel | Choice or Number | 12 | Year group of the borrower |
| DateBorrowed | Date and time | 2/6/2026 | Date the loan began |
| DueDate | Date and time | 9/6/2026 | Date the item should be returned |
| Returned | Yes/No | No | Current loan status |
| DateReturned | Date and time | 8/6/2026 | Actual return date |
| ConditionOut | Choice | Good | Condition when borrowed |
| ConditionIn | Choice | Damaged | Condition when returned |
| ReplacementCost | Currency | $85.00 | Approximate replacement cost |
| Notes | Multiple lines of text | Missing cable | Longer follow-up notes |
Query Views
Current Loans
Shows items that are still out.
Overdue Loans
Shows items that need follow-up.
Year 12 Loans
Shows loans for Year 12 borrowers.
Damaged or Follow Up
Shows records requiring attention.
Report Views
Weekly Loan Summary
A readable weekly summary for staff.
Replacement Cost Review
A report for damaged or expensive items.
Assessment Documents
Student Documents
Use these essential documents for the database practical. The teacher marking and administration documents are not part of the student workflow.
Document
Task overview
Assessment overview, purpose, conditions and policy notes.
Document
Student task sheet
Concise student instructions for the Microsoft Lists database practical.
Document
Three-week assessment instructions
Student-facing assessment instructions with parts A-H, evidence requirements and LMS submission items.
Document
Final submission LMS instructions
Copy-ready LMS instructions for submitting the final evidence document, Excel export and Microsoft Lists share link.
Document
Microsoft Lists how-to guide
Step-by-step Microsoft Lists guide for the three-week practical assessment.
Document
Database documentation template
Evidence document template for documenting purpose, structure, screenshots, views, testing and improvements.
Data file
Equipment loans sample data
Sample equipment loans records for practice and demonstration.
Attached files
Download the key PDFs, data file and example workbooks for the database practical.