Curated and Reviewed by
Lesson Planet
This Spreadsheet Tutorial 3: Column Graphs, Error Bars, and Standard Error of the Mean activity also includes:
There's absolutely no error in using the tutorial! Learners use spreadsheets to create column or bar graphs with error bars. They also learn how to calculate the standard error of the mean in the tutorial. This is the third installment of a five-part Spreadsheet Data Analysis unit.
4 Views
5 Downloads
Concepts
Instructional Ideas
- Use the resource in connection with a lab report
Classroom Considerations
- Pupils should already be able to calculate mean and standard deviation on a spreadsheet
- It is advantageous if scholars understand the meaning of 95 percent confidence intervals
Pros
- Incorporates real-world scientific data (Galapagos finch beak depths)
- Use of different colors helps distinguish between information, instructions, and exercises
Cons
- None