Tips and Tricks·369 discussions

Spreadsheet excercises

Locked

Does anyone have any suggestions for some excercises/projects for spreadsheets? The classes are for adults. Any ideas would be really appreciated.

Topic

Spreadsheet excercises

In reply to Spreadsheet excercises

You could have the class create a spreadsheet with their own personal budget. This would give them pratice in basic things like formatting cells for dollar amounts and dates, based upon their monthly bills. This would also allow them to use some basic sum and subtraction formulas. Or, as a project have them select one bill, and track the amount spent or paid for the last 6-12 months, so that would provide data to make a simple graph, so they can understand how businesses use graphs and charts for trending purposes. I love using Excel, I hope this helps. If you are interested in some more basic examples or advanced examples please feel free to contact me.

Spreadsheet excercises

In reply to Spreadsheet excercises

Poster rated this answer

Spreadsheet excercises

In reply to Spreadsheet excercises

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.

Spreadsheet excercises

In reply to Spreadsheet excercises

Poster rated this answer

Spreadsheet excercises

In reply to Spreadsheet excercises

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. [email protected]

Spreadsheet excercises

In reply to Spreadsheet excercises

Poster rated this answer

Spreadsheet excercises

In reply to Spreadsheet excercises

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).

Spreadsheet excercises

In reply to Spreadsheet excercises

Really good answer. However, haven’t heard back from him as of yet.

Spreadsheet excercises

In reply to Spreadsheet excercises

This question was closed by the author

[Author]

Replies