Irene Adler: Cerys Bethany Rebecca Simon Owen G

1. Lord Blacklock: Morgan Owen D Oakley Kieran Irene Adler: Cerys Bethany Rebecca Simon Owen G Sherlock Holmes: Rachel Charlotte Daniel Thomas Dredger: Chris G Michael Ryan Inspector Lestrade: Jay Joe Matthew F Jordan Mycroft Holmes: Jacob Matthew B Robert Kane Dr J Watson: Chloe H Erin Chloe A

2. What will the outside world look like in 1891? Who is Jack? You are now in 1891…

3. In todays Lesson You will learn… • How to create a database Table • How to use Validation in the database • How to change field sizes in the database

4. Lesson Target Setting I’m not sure what a database is or why they are used… I have a basic idea what a database is and I have a basic idea why they are used I know what a database is and a range of ideas where and why they are used. Note: Students to use this diagram to identify where they currently are and identify where they would like to be at the end of the lesson. Teacher may want to print this. I know what a database is and a range of ideas where and why they are used. I can make connections between the advantages and disadvantages and I can compare them against other ways to store information. I know what a database is and a range of ideas where and why they are used. I can explain the advantages and disadvantages and I can compare them against other ways to store information. I can also create my own database table and methods such as validation and field sizes.

5. Story Behind Murder 1… Click Here Watson to Sherlock… There has been a murder at the old vicarage house. The cleaner of the old church has been strangle and carefully positioned on the vicars desk. That is all we have to go on so far… Sherlock to Watson… We must go now before any evidence is disturbed!!! Get my Hat and pipe Watson!

6. How to create a database Table (Notebook) • Table Field Size Validation

7. Create a Table in the Database… keep this as your notepad at all times… You don’t know when clues will pop up Clue Number:………… Clue: ………………. Where Found: ………………. Description of Clue: …………… …………………………………………. …………………………………………. …………………………………………. …………………………………………. • Type: • Weapon, • Personal_Object, • Clothing • Body Part, • Imprint • Other

8. Murder 1 At the old vicarage…. Remember Watson…. Victim Number 1 Note: Animation Link (Email the Animation to students)

9. Attacked! • On your way back home you have been clobbered! Click on these for sound effects…

10. Eye Witness Miss Darcey (Shop Owner) “A bald man with a tattoo on one side of his face hit Mr Sherlock Holmes he did …. with what appeared to be a cane before clobbering Dr Watson and sending him spread eagled over that poor woman’s market stall Just there. The Man ran off with Mr Holmes’ satchel (carrying the evidence). The man was about 6 foot tall with bushy eyebrows. I think the tattoo was a snake wrapped around a dagger and he looked like he needed a shave. A right nasty piece of work he looked” Students to pick out keywords… (Literacy)

11. Back at home! What have we learnt today? What type of person is the killer likely to be? Write a paragraph explaining this… Review your Solo Taxonomy sheet from earlier… -Where are you now? - How and Why?

12. Identifying the Killer Assessment Unable to explain what type of person the killer could be… Could describe the Killer with a few basic descriptive words Can use a range of descriptive words to explain the likely killers personality Note: Use this to assess the students literacy and description skills in the review. Print this and give to the students. Use a range of descriptive and abstract words and uses an extensive vocabulary to explain the typical personality of the killer. Can justify why they think they would be like this. A range of descriptive and abstract words used with extensive vocabulary to explain the typical personality of the killer. Can justify their description. Could even use this information to build up a number of suggestions where the killer is likely to strike next and develop a good understanding of future crimes they might commit.

13. Identify where you currently are on the Solo diagram I’m not sure what a database is or why they are used… I have a basic idea what a database is and I have a basic idea why they are used I know what a database is and a range of ideas where and why they are used. I know what a database is and a range of ideas where and why they are used. I can make connections between the advantages and disadvantages and I can compare them against other ways to store information. I know what a database is and a range of ideas where and why they are used. I can explain the advantages and disadvantages and I can compare them against other ways to store information. I can also create my own database table and methods such as validation and field sizes.

14. To be Continued….

15. Plan of Lessons • Lesson 1- Introduction, Database Table (Fields, Validation, Field Sizes), Murder (1) – type of character? • Lesson 2- Assault promotional material, next murder\robbery (2) • Lesson 3– Assault in the public house {bald man again}, Witnesses instead of clues (Literacy), Spreadsheet on Gangs • Lesson 4- Database Queries and Report for the Chief Inspector - murder\robbery (4), Catch the man doing the assaults “Crazy Talk” • Who is Jack 5 – Conclusion – Murder 4, Solving the crime, Acting out

16. Story Jack Moriarty – Killer (One of Gang Leaders), Killed people who saw him threatening and stealing. Potential people who would tell on him Assault – A bloke from his Gang (Could even be related and protecting his relative) Clues: Murder 1 {Vicarage}: (Boot size 8 or 9), Blood Type O, Tassle from a cloak Murder and Robbery 2 {Old Mansion House}: A Jack Note, A dark hair, A dog scratch (red herron) Murder 3: Assault {Public House} (bald man with tattoo again, age and only 4 fingers) Murder 4: {Theatre} A Jack Note, finger print, weapon Murder 5 {In the street}: Acted out showing the final clue i.e. a tattoo or glasses? Blood hand print to measure as well to be sure…