Thursday, March 3, 2011

Day 13 - Excel Spreadsheet 2

Today, in class, we downloaded the Exel Spreadsheet 2 template and saved it to the desktop. We then used formulas and functions to complete the worksheet. After all the information had been correctly entered into the worksheet, we learned how to format the worksheet by adding background color and by adding a boarder around each cell.

Click here to view my work

Skills/Outcomes: Using the average function, using the minimum/maximum function, determining and properly using the range function; calculating the final grade numeric using a created formula, converting the final grade to a letter using a created formula, using the contif function to assess the grades; using the boarder tool and the background color tool.

ISTE NETS T Standards:
3a. demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations

No comments:

Post a Comment