GettingReadyForExcel

Basic Excel skills you need to have confidence in before the first class where we will use Excel:
 * 1) can say if letters are used to describe rows or columns
 * 2) can locate cells C2, C22, and CC22
 * 3) if you counted how many M&Ms of each color there were in a bag of M&Ms, you could make a table in Excel that looked like this (below) to describe your findings:[[image:Picture_2.png]]
 * 4) given a table like the one above, you could create a chart to visually represent your findings like this:[[image:mandm1.png width="298" height="177"]]
 * 5) or this: [[image:mandm2.png width="337" height="206"]]
 * 6) On the chart of M&Ms, you could write a formula to go in this cell that would calculate the total number of M&Ms in the bag: [[image:Picture_3.png]]
 * 7) can predict what will happen if you click and drag when your cursor is a white plus sign, a black plus sign, or a black double-sided arrow
 * 8) can describe the difference between a worksheet and a workbook; can add more worksheets to a workbook and can change the name of a worksheet
 * 9) can create a continuous series (such as January 2009, February 2009, March 2009, . . . November, 2010, December 2010) by just filling in a few cells, then clicking and dragging
 * 10) can create a repeating series (such as Team A, Team B, Team C, Team A, Team B, Team C, . . . ) by just filling in a few cells, then clicking and dragging

If you need resources to teach yourself these skills, try [|Atomic Learning] (log into myCampus and go through that link...UMF has paid for your membership) or these resources designed to help K-12 students learn through lesson plans on "real" content (i.e., not spreadsheets in isolation but as a tool in a real context).