Part 1: Your first assignment is to create a spreadsheet in Excel which matches the artifact photo as shown in the "Process" section of this lab...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.
Part 2: Your second assignment is to create another spreadsheet in Excel...you will do this by opening the first spreadsheet to your desktop, but using a new name to save this file as instructed. This assignment will involve the insertion of the formula algorithms for the various objects and their respective calculations done during the Solid Object Lab Activity. As programmed cells these will now automatically do all of the calculations for you once your measurement data has been entered. Use the Formula Sheetfor assistance with which formula goes with which object shape and attribute to be assessed.
Part 3: Your third assignment is to complete the final spreadsheet in Excel...you will open the second spreadsheet to your desktop, but using a new name to save this file as instructed. This assignment will involve the insertion of the measurement data which you acquired using the dial calipers for the various shapes used during the Solid Object Lab Activity As you insert this data into the appropriate cells you will notice that the programmed cells will automatically do all of the calculations for you and begin and reflect the outputs in the appropriate cells. Once your measurement data has been completely entered you have created a solution key for the original lab activity and are now finished with the last aspect of this assignment. Your spreadsheet should be completely finished with all necessary calculations you need to self assess your original hand calculated work. Congratulations.
This exploration and documentation should include the following:
Brainstorm and Explore Various Excel Formatting Functions
Explore Excel Programming Features and Functions
Document Discoveries and Ideas for Future Consideration
Refine Thoughts About Approach and Outcomes
Compare Your Excel Spreadsheet Format with Peers for Uniformity
Create an Individual Artifacts for Teacher Review
Create A Common Artifact for Final Peer Review
Create Personal Web Portfolio Entry
...Then Brainstorm Together in Class Webpage Discussion Post
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 Geometry and 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.