R. Craig Collins > ITSW
2334 > Home Page
R. Craig Collins > ITSW
2334 > Home Page
Advanced Spreadsheets © R. Craig Collins, 2004/2006 TC Distance Education
| Resources using TC
Web Mail |
Book |
Access the Course TC
Desire2Learn (Available Right click here to save all
Student Data Files |
About the Instructor |
| Right click here for altac1.xls | Tutorial 1 grading rubric | Excel
Tips Formula construction =sum(cell:cell) should only be used to add. If you want to use other mathematical operators (MOs) or mix mathematical operations, use =cell math cell, such as =b7*b4+c7*c4 Formula order Operations are read left to right, to change this, you can use parenthesis, such as =(b7*b4)+(c7*c4) Reading Formulas To see all the formulas, instead of Excel's default display of the solutions to formulas, hold down the [Ctrl] key, and touch [~] key (usually to the left of the [1] key, top left of your keyboard. Make sure you press [Ctrl]+[~] again, to put it back the way it was. |
|
| Right click here for chem1.xls | Tutorial 2 grading rubric | ||
| Right click here for Frosti1.xls | Tutorial 3 grading rubric | ||
| Right click here for park1.xls | Tutorial 4 grading rubric | ||
| Right click here for custloans.xls | Tutorial 5 grading rubric | ||
| Right click here for javacafe.xls | Tutorial 6 grading rubric | ||
| Right click here for properties1.xls | Tutorial 7grading rubric | ||
| Right click here for popcorn1.xls | Tutorial 8 grading rubric | ||
| Right click here for curve1.xls | Tutorial 9grading rubric | ||
| Right click here for auto1.xls | Tutorial 10grading rubric | ||
| Details on Take Home Test | in D2L, week 13 | ||
