[IAEP] Calculate and SocialCalc Lesson ideas?

[Caroline Meeks]

Thanks Edward,

this is a good suggestion. I like the use of sports as a topic.

I am aiming this training at elementary school teachers in "low performing"
schools.  Teachers who feel they are struggling to get their students to
grade level in math.  I'd like to focus on using powerful tools like
Calculate and SocialCalc but using them for addition, subtraction,
multiplication and division.

Any ideas?

Thanks,
Caroline

On Fri, Oct 23, 2009 at 9:06 PM, Edward Cherlin <echerlin at gmail.com> wrote:

> 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/
>



-- 
Caroline Meeks
Solution Grove
Caroline at SolutionGrove.com

617-500-3488 - Office
505-213-3268 - Fax
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://lists.sugarlabs.org/archive/iaep/attachments/20091024/313e355c/attachment-0001.htm