McKay School of Education > Technology > Spreadsheets
Technology Skills Assessment - Spreadsheets
To successfully complete this task, you must be able to complete the skills shown below. A sample task is also provided so you can practice the skills before taking the technology assessment. You may complete the task on your own or you may choose to go through our step by step tutorial. The content and data needed for this assignment will be provided as well.
- Pictures and text to use in your spreadsheet
- Step by Step Tutorial - Creating this spreadsheet in Microsoft Excel 2007
|
To successfully complete this task, you must be able to complete the skills shown below. A sample task is also provided so you can practice the skills before taking the technology assessment. Since you will only be evaluated on your ability to complete the tasks listed below, content has been provided to help you save time. Use a spreadsheet to create a gradebook for your class. Then create a graph to show the grade breakdown by assignment. It should look identical to the example shown on the right (same layout, colors, font, etc). You can use the data for the spreadsheet provided (to help you save time). When you are finished, save your spreadsheet as a file called "class_grades.xls". Make sure you include the following elements:
|
Click on image to see enlarged version |


