This learning scenario builds on the previous learning scenario. Now the collected data is loaded into a data analysis tool, such as Excel. In the next step, the students analyse the data to see if there are differences in quality and what kind of voices (gender, age, height of voice) are recognised better or worse.
| Creator | Annika Nowak | ||||
| Subject | Computer Science & Physics | ||||
| Length | 60 minutes | ||||
| Pedagogical Approach | Explorative learning | ||||
| Competencies from the framework Additional competencies | Data management competency IT competency Scientific investigation cycle ________________ Data analysis | ||||
| Grades | 5-9 | ||||
| Link to the worksheet |
Learning Activities
| LA1: Orientation | In the first phase, the students familiarize themselves with the Excel program. They open the program and get to know the first functionalities. |
| LA2: Download data series | Students load the measured data series into Excel. |
| LA3: Analyze data series | Students are given a data series and perform calculations based on that data series. |
| LA4: Interpret data series | In the penultimate step, students interpret the results and draw conclusions based on them. |
| LA5: Presentation | Students present the results of their analyses in plenary. |