[IAEP] Calculate and SocialCalc Lesson ideas?

[Edward Cherlin]

I can provide a spreadsheet that I use for monitoring my blood sugar,
because of my (relatively mild) diabetes.

I recommend that we think about a sequence of lessons on elementary
probability and statistics based on soccer (except possibly in
countries where baseball or cricket are the prime national sports). It
seems to me that this is the numeric topic most likely to rouse
interest among students while being acceptable to teachers. But I
would ask children what other questions they have that could be
answered with a spreadsheet.

The first topic, covering several lessons, is to have multiple
children doing multiple column data entry, and formula entry and
validation.

If we can copy a rectangular range of data from one spreadsheet to
another, we can demonstrate various other workflows and applications,
such as entering data singly, offline, and merging it in a
collaborative session.

Later on, someone could do up a spreadsheet for the Net Present Value
and Return on Investment of one computer for one child over a
lifetime, with replacements every so many years, and other such
matters. We could talk about how to evaluate progress on each of the
UN Millennium Development Goals. We could talk about the spreadsheets
needed for a microfinance institution and its borrowers.

On Fri, Oct 23, 2009 at 14:47, Caroline Meeks
<caroline at solutiongrove.com> wrote:
> Hi,
> I am working on curriculum for a professional development class for Sugar
> for elementary school teachers for a class project. The format would be a
> one-day hands on session followed by online session that are done over the a
> week or two remotely.
> For one of the online segments I'd like to have the teachers use Calculate
> and/or SocialCalc.  I'm looking for ideas for an interesting activity that
> would help them get hands on experience with the collaborative potential of
> these math activities.
> If possible I'd like this activity to support some of the other learning
> goals
>
> Helping the teachers see themselves as part of the global Sugar community
> and as global citizens working to educate the next generation.
> Valuing and bringing into the classroom the different cultures of their
> students. In the US teachers have an increasing diverse classroom.
> Teaching to standards
> Differentiated instruction
>
> Any ideas?
> --
> Caroline Meeks
> Solution Grove
> Caroline at SolutionGrove.com
>
> 617-500-3488 - Office
> 505-213-3268 - Fax
>
> _______________________________________________
> IAEP -- It's An Education Project (not a laptop project!)
> IAEP at lists.sugarlabs.org
> http://lists.sugarlabs.org/listinfo/iaep
>



-- 
Edward Mokurai (默雷/धर्ममेघशब्दगर्ज/دھرممیگھشبدگر ج) Cherlin
Silent Thunder is my name, and Children are my nation.
The Cosmos is my dwelling place, the Truth my destination.
http://www.earthtreasury.org/