A sick kid can really throw off a person’s plans! I am putting the finishing re-touches on my SORLA Excel Session. I need to run through all of the pieces. The really hard part about doing an “advanced” session is that you never really know if the people you get will be… advanced. So, my first activty is planned as a review… but it could become a lesson in itself. This session includes some basics, a sample lesson, sample testing data… and more to be determined tomorrow!
If you were writing an “Advanced” Excel session, what would you include?
Here’s an outline for now…
Excel Advanced Class
Basic Lists
• Resize columns
• Alpha by Last
• Sort by date
• Filter by Gender
• Format Date Cell
• Random Number
• Choose a name
• Concatenate
Basic Math
• Format cells: currency
• Multiplication
• Drag formulas
• Total/Sum
• Format as table
M&M Activity
• Create data table
• Total data
• Create a column chart
• Copy data to a new sheet
• Drag formulas
• Find percent
• Create a pie chart
NWEA Sample Data
• Create Mail Merge in Word
o Name:
o Grade:
o Fall 2003:
o Spring 2004 Target:
o Spring 2004:
o Target Growth:
o Target Met?