Please find enclosed within this downloadable resource the following:
A PowerPoint that takes a step-by-step and logical approach to creating a bar chart in excel for even the most computer fearful! The PowerPoint shows the children a click-by-click approach to creating a bar chart - perfect for those creating a bar chart in excel for the first time, or for those who have made one before a much needed brush up.
The PowerPoint provides screenshots of the process from entering in the data all the way to customising the graph once it has been created. In addition to this, there is a learning objective and differentiated success criteria for the children to view whilst creating their own bar charts.
This resource is an activity drawing on real action research using actual raw data as an introduction to quantitative data analysis.
The students work in small groups, focusing on one set of raw data each. They discuss any problems with the data and how they would analyse it and present the results. They then present their findings to the rest of the class.
Extension work could involve students designing their own questionnaire and carrying it out before analysing the data and writing up their work as a small-scale research project.
6 week unit of work for computing/ICT based on the topic Seaside. I have used this with year 2 but it could easily be adapted for different year groups. Resources needed are purplemash and some of the 2simple software products, but again, activities could be adapted to use software you have in school.