Task 04 Spreadsheets
Task04 GRADE SHEET | Tasks due by 11:59 p.m. on due date.
Orange links are links to help files on the web. Blue links are file and pages to the class site.
| You will download your individual file (from your sakai dropbox) and modify 18 to 20 spreadsheets | due 03/26 | |
| You will demonstrate sheet setup skills, create new spreadsheets, format cells, control the display of rows with conditional formatting | due 03/26 | |
| You will demonstrate that you can freeze panes, validate data, and hide data | due 03/26 | |
|
You will demonstrate that you know how to work with various formulas and functions |
due 03/26 | |
| Link to the intro demo file: covers all of the above (March 6 intro demo) | due 03/26 | |
| You will demonstrate how to pull vectored data from two sheets into a fomula | March 8 vector demo file | due 03/26 | |
| You will demonstrate charting and chart formatting and chart annotating | March 8 chart demo file | due 03/26 | |
| You will demonstrate facility with filtering and sorting, subtotalling, totalling, and commenting | March 20 files | due 03/26 | |
| You will demonstrate how to print rows with column headers on each page | due 03/26 | |
| You will include headers and footers and setting up worksheets for printing and basic page layout | due 03/26 | |
| You will save and post document to your sakai dropbox | due 03/26 | |