Time/ No. Teaching Objectives Suggested Activities: Resources: Link to SMSC: Extension: G&T; Rich Questions: what; why; H&S of group work; research; worksheets; Literacy; SEN where; when and how Lessons files; Numeracy; ICT practical’s Misconceptions equipment Database Concept Whole class; discuss the PPT, real How can we make SEN: Understand What is a relational Visual check of importance of databases world sure that our important key database? equipment 2 (a) describe a database freedom and words and terms (computer and database as a Worksheet; features of a Are database relationship models, privacy is secure personal persistent organised database (mix and G&T: Explain the diagrams art? worksheet, when dealing with belongings) store of data match) key terms used WWW databases? Check (b) explain the use of Examples of databases whiteboard, data handling software used and organisations lighting, to create, maintain and that may use them interrogate a database windows, ventilation, Research the data tripping protection act why is it – hazards, important when creating correct seating a database? position for computer use Whole class; case studies when data has been leaked via using a database importance – of security Data Models Explanation of different PPT, real Can we link SEN: Understand How can different database data models (flat file world employment to a important key models be integrated? 1 databases, hierarchical database database model? words and terms database, relational models, G&T: Research database) worksheet and explain the Whole class; case study use of different linked a hotel booking models giving – system relationships examples – Worksheet; other real world examples create – own database
Time/ No. of Lessons Teaching Objectives Suggested Activities: group work; research; practical’s Resources: worksheets; files; equipment Link to SMSC: Literacy; Numeracy; ICT Extension: G&T; SEN Rich Questions: what; why; where; when and how Misconceptions H&S 2 Database Concept (a) describe a database as a persistent organised store of data (b) explain the use of data handling software to create, maintain and interrogate a database Whole class; discuss the importance of databases Worksheet; features of a database (mix and match) Examples of databases used and organisations that may use them Research the data protection act – why is it important when creating a database? Whole class; case studies when data has been leaked via using a database – importance of security PPT, real world database models, worksheet, WWW How can we make sure that our freedom and privacy is secure when dealing with databases? SEN: Understand important key words and terms G&T: Explain the key terms used What is a relational database? Are database relationship diagrams art? Visual check of equipment (computer and personal belongings) Check whiteboard, lighting, windows, ventilation, tripping hazards, correct seating position for computer use 1 Data Models Explanation of different data models (flat file databases, hierarchical database, relational database) Whole class; case study linked – a hotel booking system – relationships Worksheet; other real world examples – create own database PPT, real world database models, worksheet Can we link employment to a database model? SEN: Understand important key words and terms G&T: Research and explain the use of different models giving examples How can different database models be integrated?