Your assignment is to create a spreadsheet in Excel which matches the given artifact photo...make it look as identical as you possibly can, cell location of data or text, cell border and line weight, cell color as necessary...recreate the spreadsheet accurately.
Use the Advanced Data Analysis PowerPoint (click the link) to follow the directions in creating the Excel Spreadsheet and programming the various functions to create the graphed outcomes...Good Luck! After you have successfully completed this activity: Down load and save a copy onto your desktop named as: "YourName Histogram Activity 1 - P#" Upload this to your web portfolio with a link name same as your file.
Part 2: Follow the directions as articulated at the bottom of the above spreadsheet to complete all aspects of the Histogram spreadsheet and various graphed outcomes through use of the Excel features.
After you have successfully completed this activity: Down load and save a copy onto your desktop named as: "YourName Histogram Activity 2 - P#" Upload this to your web portfolio with a link name same as your file.
Reflect on your experience on the class website Reflection Blog
Artifact Presentation and Reflection:
A gallery walk of each groups Initial Spreadsheet Artifacts followed by a group discussion about the various approaches and uniformity. After reflection and group analysis, construct a final presentation documenting your process and what new things you have learned about "outliers" and the functions available in the Excel Spreadsheets for your class and teacher. Your presentation artifact shall be a PowerPoint presentation of no less that 5 slides and no more than 15. Your presentation should address all factors considered and how looking at the other groups work may have affected your final analysis.
All PowerPoint presentations should be of professional and conservative business or scientific format. These shall then be posted on an ongoing web based class project site and each persons personal web portfolio for display on the internet. All pages and portfolios shall conform to internet safety standards and acceptable language and content policies.
A formal peer review shall be done as a discussion post on the class webpage and shall be completed appropriate to said venue with regard to commentary, language and content. This review/reflection is to be a graded activity of self and peer assessment skills.