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.
I can understand how to protect myself from online identity theft, e.g. identifying secure sites, phishing, scam websites.
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.
I can construct, refine and interrogate data sets within tables, charts, spreadsheets and databases to test or support an investigation.
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.
I can use a range of spreadsheet formulae, e.g. + - / x, sum, average, max, min.
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?
I can construct, refine and interrogate data sets within tables, charts, spreadsheets and databases to test or support an investigation