Google Sheets, Excel Online, J2Spreadsheet, J2 Database and 2Investigate
register online, private information, personal information, identity theft, branching database, fields, records, formula, variable
Private and Personal Information lesson resources from Common Sense Media. Available via a Hwb Playlist.
Understand how to protect themselves from online identity theft, e.g. security symbols such as a padlock, phishing, scam websites
Use technology safely, respectfully and responsibly; recognise acceptable/unacceptable behaviour; identify a range of ways to report concerns about content and contact.
Remind pupils that databases can be thought of as a collection of records that contain data in the form of words, numbers, sound and images. This data is contained in ‘fields’ on a ‘record’. Pupils are to create their own simple database. Pupils could use ready made gathered information from ‘Top Trump’ type cards or use information gathered from other sources. Pupils will need to be shown how to add and amend (change) the data contained in the fields on a record and add a suitable image. Once a number of records have been added, pupils can revise sorting and graphing the data based on their own questions.
Begin to create data sets and extract information from them with tables, charts, spreadsheets and databases.
Select, use and combine a variety of software (including internet services) on a range of digital devices to design and create a range of programs, systems and content that accomplish given goals, including collecting, analysing, evaluating and presenting data and information.
Show the pupils a simple ready made branching database. Make reference to classification trees used in science - minibeasts example. Users are able to question the database following a particular path. Recommend initially that the pupils use about six records and that they are going to be able to differentiate easily between them. Some example branching databases that the pupils could experiment with include, minibeasts, musical instruments, food, book characters. Suggest that the first question splits the records equally into two, e.g. if the branching database was about musical instruments, do you pluck the instrument? Pupils can use the clipart examples - animals, faces, fairytales, aliens, etc. or possibly search and import images. They can also research and add further information about that record to create a fact file.
Explain to the pupils that in the same way as we can sort and group records in a database to answer questions, we can also do this with spreadsheet data. Either using the downloadable resource or a spreadsheet you have created, show the pupils how to enter information into the correct columns / rows on the spreadsheet. Show how to create a filter to help to narrow down the information to help to answer questions.
Remind pupils that spreadsheets can help them to solve mathematical problems, and that a spreadsheet has cells that are organised in rows and columns with assigned letters and numbers e.g. A4, D23. Open a blank spreadsheet and create two columns (Number A and Number B). Number A has the numbers 1 to 12, and Number B contains the number 2. In a third column the children are going to insert the formula that multiplies the two numbers together eg. =B3*C3, =B4*C4, etc. Once this has been done explain that you want the children to show you the 6 times table. All they have to do is change the Number B column from 2 to 6 and the answers will update automatically.
Explain to the pupils that ICT models are very useful ways for people to test out their ideas, and to ask the question, “What happens if...?” Operation Sustainable Future is an ICT modelling activity based around global warming and sustainability issues. Pupils are to record their choices to each of the challenges presented to them. They must then make note of the resulting world based on these choices. Go back through the challenges again but this time change their choices. What happens to the final resulting world they have created?