Getting ready for level 3 information

I plan to get the students to develop a map of New Zealand Crashes based upon the nzta dataset.
http://www.nzta.govt.nz/resources/crash-analysis-system-data/

Because the dataset is all number and characters there needs to be an explanation behind it. http://www.nzta.govt.nz/resources/guide-to-coded-crash-reports/index.html

Right, to work...

Implement complex procedures to develop a relational database embedded in a specified digital outcome involves:
I think I met this really well, as it will be embedded with a website that should display mapping references.
• designing and constructing a database with a workable table structure
at least three tables will be needed
• creating queries to retrieve and modify data
queries to find specific events will be needed, modifying data will be using count and sum statements
• allowing data in at least one database table to be changed from another application (eg spreadsheet, web page, Portable Document Format (PDF) form, student created custom desktop application)
Students will be importing data and displaying through a webpage
• applying design elements and formatting techniques to customise data input and display
Students will be required to display data through their map in a readable block
• applying data integrity and testing procedures to ensure the outcome meets the specifications
Testing always

• applying data access permissions as appropriate to the outcome.

Setting up their work and database to meet given requirements

Skilfully implement complex procedures to develop a relational database embedded in a specified digital outcome involves: 

• showing accuracy in designing and constructing the table structure, applying design elements, techniques and procedures 

• showing independence with regard to decision making when producing the outcome. 

Efficiently implement complex procedures to develop a relational database embedded in a specified digital outcome involves: 

• designing and constructing a database with a well-organised table structure (eg elimination of redundant data, effective data validation, effective use of data properties) 

• producing the outcome in a manner that economises the use of resources (eg optimisation of data input, and effective use of shortcuts such as macros and buttons). 

3 Specified digital outcome refers to a digital information or media outcome and its relevant specifications. The specifications must be of sufficient rigour to allow the student to meet the standard. The specifications need to be agreed prior to the outcome being made. They may be teacher-given or developed in negotiation with the student. 

4 Examples of digital information outcomes suitable for students to develop may include: sports day management system, web based ordering system, product pricing updates, point rewards notifications, teacher mark book and automatic email notifications, music podcast management system, student course selection and confirmation systems, online product display, email PDF event (talent quests, sports) registration. 

5 The relational database design includes the table structure (fields, data types, size, keys and relationships, formatting, and validation rules), interface design, and a plan for linking data between applications. 

6 Complex procedures to develop a relational database include: 

• creating queries which combine data from multiple tables 

• creating queries which insert, update or delete to modify data 

• creating customised input forms 

• creating customised data displays from multiple tables (eg reports, PDFs, webpages, program interfaces). 

As the data is mostly imported through csv files, I won't have an customised input form as this project doesn't need this.

7 Data integrity procedures may include: checking for the relevance, accuracy, and 

reliability of the information (eg formulae auditing, proof reading, spell checking).