Excel 2010 - ideas for classroom exercises / tasks?

I'm training some adults on Excel 2010 - at a basic/intermediate level. Topics include protecting a workbook, tables, sparklines, functions and formulas (specifically nested IF commands), data validation etc...

ThI was following a course that I have purchased, but I have been asked to customise it a bit. Currently, the course has exercises after each section for the students to work through, but they just follow instruction - there's no thinking required, so what I want to do is split the classes into 2 groups of 4 people, and assign the two groups a task (the same task) of creating an Excel Spreadsheet which should incorporate aspects of the topics covered.

Can anyone give me some ideas, suggestions or examples for a spreadsheet that I could ask the groups to create? My brain is fried after reading all of the training materials, and I'm losing the will to carry on...
LVL 17
Chris MillardAsked:
Who is Participating?
 
ScriptAddictCommented:
A basic IF statement should be in there as well.
0
 
sentnerCommented:
Definitely cover Pivot Tables, as those add a great deal of value to many spreadshets.
0
 
ScriptAddictCommented:
Vlookup and Hlookup get my vote

Proper use of a sumproduct formula would also be of great value to your trainees.

0
Introducing Cloud Class® training courses

Tech changes fast. You can learn faster. That’s why we’re bringing professional training courses to Experts Exchange. With a subscription, you can access all the Cloud Class® courses to expand your education, prep for certifications, and get top-notch instructions.

 
ScriptAddictCommented:
Some basic text manipulation formulas like:

Left()
Right()
Mid()


ok I'll stop now.
0
 
Chris MillardAuthor Commented:
Pivot tables are covered in a different class, and are not part of this course, so I need to steer clear. B ut basically, what I'm looking for is a "scenario" that I can give the students. For example, one of the exercises shows a spreadsheet where nested IFs are used to calculate how much profit a salesperson will earn based on his/her sales. The profit is 10% if sales were over £10000, 5% if less than £10000 but over £5000, 2% if less than £5000 but over £2000 etc...

What I really want to be able to do is say to the sudents I want you to create a spreadsheet that shows me "something" and as part of that spreadsheet, you are going to have to work out how to calculate "this" based using nested IFs etc., and you must ensure that people entering data cannot enter the wrong type of data etc...

But I'm struggling to think of a real-world scenario that I can get them to create...
0
 
sentnerCommented:
Things like product inventory or address books are great learning experiences.  One thing I use that is "real world" is a spreadsheet for tracking my credit card usage and interest over time.  You can enhance this type of thing with charts, tables, and so forth.
0
 
kgerbChief EngineerCommented:
roybridge,
Take a look at this.  A community college I used to work for had a client that wanted specific training on lookup functions so I created this material.  There are a few examples in there that might give you some ideas.

Kyle
Look-Up-and-Logic-Functions.pdf
0
 
redmondbCommented:
Thanks for sharing, Kyle. I've no doubt that will come in handy.
0
 
Chris MillardAuthor Commented:
Thanks for the suggestions
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.