unit 8.5 lesson 1 databases murder at highfield high start/computer/central resources/ future...
DESCRIPTION
Discussion Point 1 In the times of the Yorkshire Ripper there were no computerised databases Police used paper records instead Discuss the following with the person sat next to you – you have 2 minutes to discuss! –What difficulties do you think the police had in solving this crime? Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit folder into your documents. Organise - copyTRANSCRIPT
![Page 1: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/1.jpg)
Unit 8.5Lesson 1
DatabasesMurder at Highfield High
Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit folder into your documents. Organise - copy
![Page 2: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/2.jpg)
Discuss the following
1)What is the main purpose of a database And information you can add.
2) Examples of businesses that use a database with reasons why
![Page 3: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/3.jpg)
Discussion Point 1• In the times of the Yorkshire Ripper there were
no computerised databases
• Police used paper records instead
• Discuss the following with the person sat next to you – you have 2 minutes to discuss!
– What difficulties do you think the police had in solving this crime?
Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit folder into your documents. Organise - copy
![Page 4: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/4.jpg)
Feedback
Have a look at your assessment from last lesson and correct answers using a green
pen.
Reflect on this unitWWW:
EBI:
![Page 5: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/5.jpg)
Activate: Lesson AimsAll: I can evaluate databases and filter results.
Good OutstandingI can search a database using Filter and Advanced Filter
I can Evaluate mistakes found in a database
I can Evaluate mistakes found in a database
I can analyse strengths and weaknesses of using a database
![Page 6: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/6.jpg)
Revision• A database is a carefully organised filing
cabinet or library of data – stored on computer
• Database software is designed to store data in a way that makes it easy to sort and search
• Database software can handle very large amounts of data very quickly eg Google
![Page 7: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/7.jpg)
Scenario• An horrific murder has taken place at Highfield High
School on staff training day
• The police have compiled a database of staff in the school at the time of the murder
• So far, the police have interviewed the deputy head and headteacher
• They have collected descriptions of all the teachers and where they were at the time of the murder
• Your task during this unit is to find out who the murder is!
![Page 8: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/8.jpg)
Activity 1
• Copy the Year 8 database 8.5 folder into your documents. Open the Murder database file and lesson 6 activity folder.
• You need to use a filter to search the database
outlined in your Learning Log
• Don’t forget to record their names on your sheet
![Page 9: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/9.jpg)
Filter• Click Records, Filter, Advanced Filter/Sort
Select the correct field or fields to
search in eg Shoe Size
This filter is looking for suspects with:Size 10 Feet that are blonde and work in maths department and are 6ft or work in the English department and are 6ft
Enter the search criteria(s)
![Page 10: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/10.jpg)
What now?• The police would like you to search for the
following suspects using tblsuspects.
• Use Filter, Advanced Filter/Sort to search for the following information
• You have this lesson to do the Filter and find the murderer!
• Don’t rush – you must be accurate or the wrong person will be convicted of a crime they didn’t commit!
Extension – Lesson 2 - activity 2 and 3
![Page 11: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/11.jpg)
Challenge
Complete lesson activity 3 in your document on page 5
![Page 12: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/12.jpg)
Consolidate
![Page 13: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/13.jpg)
Consolidate:
Key Words: Filter, Sort, Database, Input Forms, Query, reports, Information, Google slides, Google email
![Page 14: Unit 8.5 Lesson 1 Databases Murder at Highfield High Start/Computer/Central Resources/ Future Skills/Computer Science/ Year 8 / 8.5 Databases - Copy Unit](https://reader034.vdocuments.us/reader034/viewer/2022051303/5a4d1b597f8b9ab0599aa654/html5/thumbnails/14.jpg)
Feedback