Author: mgo

Lesson	Learning Objectives	AFL	Learning Outcomes	Success Criteria	Lesson Score (1—5)	Checkpoint Level
1	Know the purpose of a Database / Understand Key database terminology / Identify advantages / disadvantages of computerised and paper based databases	1	To complete the worksheet covering purposes of databases, key terms and advantages and disadvantages of computerised and paper based databases.	All pupils - complete worksheet / Most pupils - answer thoroughly / Some pupils - show clear understanding
2	Know what a data capture form is and purpose / Create a well designed, suitable data capture form	2 / 1	To produce a computer generated data capture form	All pupils - design a basic form / Most pupils - well designed form / Some pupils - design form unaided
3	Know how to complete a data capture form / Understand need for clear instructions / Collect information from car park	2	Completed data capture form	All pupils - collect info - 4 cars / Most pupils - collect info - 10 cars / Some pupils - collect info - 15 cars		Data capture form
4	Know main data types used in a database / Understand most appropriate data type use / Enter data into a database	2	Create computer database	All pupils - set up database / Most pupils - understand data types / Some pupils - enter all info into database
5	Know main data types used in a database / Understand most appropriate data type use / Enter data into a database	2	Create computer database	All pupils - set up database / Most pupils - understand data types / Some pupils - enter all info into database
6	Know what a query is and why they are useful / Understand how to use search criteria for specific records	3	Complete queries using search criteria / Print out results of queries	All pupil - search database, print 2 queries / Most pupils - complete advanced search / Some pupils - paragraph on query validity		Database
7	Know how to send and receive e-mails	3	Produce photofit poster from description / Email as attachment the photo fit to police	All pupils - create poster, email to police / Most pupils - more detail to poster / Some pupils - pupil considers audience
8	Know the risks of digital communication	3	Poster on risks associated with digital communication	All pupils - create poster / Most pupils - poster with more detail / Some pupils - audience considered		E—Safety
9 - 11	Know how to use features of powerpoint / Be able to solve clues as to given crime	3	Pupils to produce slide show summing up the results of their investigations.	All pupils - Presentation showing results / Most pupils - 5 slides and effective / Some pupils - Audience considered
12	Know how to write an evaluation	3	Complete a detailed evaluation of software, processes used	All pupils - explain what they did / Most pupils - discuss problems / solutions / Some pupils - Compare work to criteria		Evaluation

Suggested Targets For Improvement :

Summative Test Result

Summative Topic—Final Assessment