23. Interactive Spreadsheets

Here’s the Interactive Spreadsheets learning interaction from my eBook, Engaging Interactions For eLearning:

Description: Interactive spreadsheets are exercises that allow the learner to plug-in figures or information into a system and see the direct results of their actions. Consider using interactive spreadsheets when it is important to show the effects of actions over time, or when you need to emphasize cause-and-effect relationships.

Read Learning By Doing, by Clark Aldrich, for more information on interactive spreadsheets.

Example: The classic example of this type of interaction is a lemonade stand:

You must operate a lemonade stand and determine how and when to spend your money. After making your decisions, you will be able to watch how your lemonade stand performs over (simulated) time.

Example questions:

How much will you charge for lemonade? (If you price it too high, people will not buy it. If you price it too low, you will not make money.)

Next weekend will be very hot. Do you think you will sell more lemonade than usual? If so, should you buy extra supplies?

Level(s) of Interaction: 3, 4
Knowledge Type(s): Factual
Conceptual
Procedural
Metacognitive
Advertisements

0 Responses to “23. Interactive Spreadsheets”



  1. Leave a Comment

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s





%d bloggers like this: