Today we talked about databases. If we had MS Office, we would be learning Access, which could take up an entire quarter by itself. So for once, not having Office is to our advantage. Instead we are using Google Forms and Google Sheets to learn how to create a database and then filters to display our reports.
First, the students created a "survey" using Google Forms with the various fields they needed to gather (name, height, etc.). Then, using a list I provided them of 10 people, the students filled in the data. Google Forms automatically creates a spreadsheet to display the results so the students opened it up and made some formatting changes to make it look good. Finally, the student created three copies of the first sheet and used different filters to create three different reports. This is would also work for a science project or a database of books lying around the house.
First, the students created a "survey" using Google Forms with the various fields they needed to gather (name, height, etc.). Then, using a list I provided them of 10 people, the students filled in the data. Google Forms automatically creates a spreadsheet to display the results so the students opened it up and made some formatting changes to make it look good. Finally, the student created three copies of the first sheet and used different filters to create three different reports. This is would also work for a science project or a database of books lying around the house.