● single and multiple table structures with appropriate field characteristics, including
o field names
o field data types, e.g. alphabetic (text and memo), numeric (number, currency, and date/time), alphanumeric (text and memo), logical (yes/no and true/false), web (hyperlink), lookup wizards
o field sizes (e.g. byte, integer, long integer, single, double and decimal)
o field formats (e.g. fixed and decimal places)
o default values
● validation rules and text, which applies to a range, format and length for different data types including input masks
● indexing (e.g. primary key, foreign key)
● create new records (e.g. populate tables with data manually or import a data set from an external source (text file or spreadsheet))
● edit and delete existing records of data
● create, edit and delete relationships
● use wizards.
Links to Learning Outcomes |
Links to Assessment criteria |
|
|---|---|---|
1C.4 Develop a database with a realistic data set with guidance, including: ● a single table structure ● a data-entry form. 2C.P4 Develop a relational database with a realistic data set, which includes: ● two tables ● sort records ● data-entry forms. 2C.P5 Test the functionality and purpose of the relational database for functionality, repairing any faults.* 2C.M3 Develop the database demonstrating awareness of users’ requirements and accuracy. To include: ● customised dataentry forms ● queries and output data reports ● onscreen navigation and guidance 2C.M4 Gather feedback from others and use it to improve the database and test any additional functionality, repairing any faults.* 2C.D3 Refine the database solution using automated tools and techniques to improve productivity, accuracy and the presentation of output data, taking account of user feedback.* 1C.5 Test the functionality of the database and repair any faults with guidance.*
|
Sentences with different forms: statement, question, exclamation, command
Organising Information: Organise information and ideas into structured and sequenced sentences, paragraphs and whole texts, using a variety of linguistic and structural features to support cohesion and overall coherence.
Sentence Structure: Use a range of sentence structures for clarity, purpose and effect, with accurate punctuation and spelling.
Analysis of information: Interpreting Results, Drawing conclusions from data, Comparing data
Money: Budgeting, Estimating, Rounding to nearest pound, using correct symbols, calculating costs using a calculator
Using numbers: Written or mental methods, using a calculator, rounding and estimating, problem solving
Anonymous Assessment - Learners assess an anonymous piece of work containing deliberate mistakes against given success criteria.
Just a Minute - At the end of the lesson teachers ask learners to summarise their learning. The comparison of these summaries against learning objectives informs planning.