Tuesday, March 1, 2011

Day 12 - Excel Spreadsheet 1

Today, in class, we learned how download the Excel Spreadsheet 1 template and save it to the desktop. We also learned how to use formulas and functions to complete the worksheet. We then learned how to create a sheet, rename the sheet as "Semester 1", copy and paste names to the semester sheet; create a formula on the "Semester 1" sheet that averages the 3 term grades, and sort the students from high to low on the "Semester 1" cover sheet.

Click here to view my work

Skills/Outcomes: Using the average function, copy and pasting text, formulas, using the handle, creating sheets, renaming sheets, formulas between worksheets, sorting.

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