9 replies
by laura.smith
by mjbrown59
by peroffl
I like to use stocks to teach some aspects of Excel to adults. Allow the students to pick some stocks or mutual funds and track the preformance of the stock/fund over the duration of the course (our course is 15 weeks). The spreadsheet can start off relatively simple: The amount invested, the cost of the units, the number of units purchase. Add in a column to show percent of loss/gain. Add in formatting to show currency, additional decimal places, shading/borders, etc. When you are teaching graphing, the students can experiment with different styles of graphs (pie charts with percent investment, line charts to show profit/loss of investment over time, etc.) The whole thing can be worked into a "final project" to show off the skills they have learned.
If you have any specific topics in mind, I'd be happy to discuss ideas with you via email.
by mjbrown59
by cmurphy
You can design a gradebook program to average grades. Making different sheets for different grading period. Linking sheets to find sem. averages from 6wks avgerages. Weighted grades, condition formatting to change color when a grade drops below a certain grade. Average with a drop grade.
Another idea is an inventory list to keep up with value of products on the shelf. If you are interested, I can send you some samples. Just e-mail me. murphy8@frontiernet.net
by mjbrown59
by dksmith
All of the other answers are good, but...
Is this a homogeneous group of people being taught? Do they have anything in common?
Adults have to learn what is relevant to them. Most things that are seen to be abstract will be dismissed as "not what I need."
Use the examples given to you, but pick the most appropriate example for the group being taught.
Email me for specific one-on-one advice for the class(es).
by mjbrown59
by mjbrown59
This discussion is closed to new replies.
Trending Tips and Tricks posts
Sort by Trending