SS3 Integration

Well I think I finally accomplished the Integration Assignment. I'm unsure about the layout of my web page. For some reason I couldn't get the side bar to fix the lay out of the text. This was definately a lot of work and took me quite a few hours, but I think it's a neat idea to get the students more involved in Microsoft Excel. It allows them to get hands-on practice and try to figure out things on their own using an Instruction Sheet. Using the side bar I made a Table of Contents to link all of the required material. For instance, lesson plan, student spreadsheet, instruction sheet, and a spreadsheet reference. I hope this is what was expected. If anyone would like to take a look and see if I'm missing anything feel free to do so. Thanks and I hope you enjoy! Lesson: What Color Are Your Skittles?

SS2 Gradebook

This assignment took a lot of hard work and determination. For some reason I'm having a lot of problems figuring out the functions and applying them to the grade book. However, I think I finally figured out everything, except I’m not sure about the letter grades. I used the substitute formula rather than the IF formula, because I couldn't get it to work. I hope that this is what you’re looking for. I thought I knew how to use Excel, but these past two assignments have really made me doubt that opinion. Here is a link to Spreadsheet 2.

SS1 Gradebook

This was definitely harder than I thought it was going to be. I have worked with Excel before, but I hadn't done a grade book and worked with curving grades. I hope that it's right. After receiving help from my discussion posting, I think I calculated the curve and final grades correctly. I added a bar graph on a separate sheet that included the students names along with their original and adjusted averages. Once I got everything sorted out I think this would be a great way to track grades. I would definitely use this in the future if there aren't school wide grade book programs that we have to use. Here is a link to my Spreadsheet 1.