60 likes | 295 Views
Microsoft Excel 2003 for the Technology Instructor’s Soul. Understanding what’s new for you… and for your students. Corinne Hoisington. Adding Lists. Improved list functionality helps you structure worksheet data Easier to perform list arithmetic and statistical calculations
E N D
Microsoft Excel 2003for theTechnology Instructor’sSoul Understanding what’s new for you… and for your students Corinne Hoisington
Adding Lists • Improved list functionality helps you structure worksheet data • Easier to perform list arithmetic and statistical calculations • Auto filter drop downs (Sorting) • Blue Asterisk * to insert row to list • Total Row
Great Grade Book Functionality • The “Adding Lists” feature will help us as faculty to quickly design a grade book • Add students very easily without redoing formulas • Find the class Average, High/Low Grades
Side by Side Benefits • Side by Side Panes make it easier for you to grade student assignments when you can see the ‘key’ right next to their work.
BINOMDIST CHIINV CONFIDENCE CRITBINOM DSTDEV DSTDEVP DVAR DVARP FINV FORECAST GAMMAINV GROWTH HYPGEOMDIST INTERCEPT LINEST LOGEST LOGINV LOGNORMDIST NEGBINOMDIST NORMDIST NORMINV NORMSDIST NORMSINV PEARSON POISSON RAND RSQ SLOPE STDEV STDEVA STDEVP STDEVPA STEYX TINV TREND VAR VARA VARP VARPA ZTEST Improved Statistical Functions Precision Improved