[Yr11 Information Technology] Spread sheet Exercises for 2013

Thu Nov 29 11:58:05 EST 2012

Another nice tutorial of Floating charts, probably more suited for Data Visualisation.
http://www.techrepublic.com/blog/window-on-windows/an-easy-technique-for-creating-a-floating-column-chart-in-excel/6936?tag=nl.e064&s_cid=e064

[cid:bmglogo7b13002]

Philip Pike
Director of ICT

Bacchus Marsh Grammar
T. 03 5366 4893  F. 03 5366 4850
E. pikep at bmg.vic.edu.au  W. http://www.bmg.vic.edu.au
South Maddingley Road | PO Box 214 | Bacchus Marsh Victoria 3340

-----Original Message-----
From: yr11it-bounces at edulists.com.au [mailto:yr11it-bounces at edulists.com.au] On Behalf Of Esther Andrews
Sent: Wednesday, 28 November 2012 5:16 PM
To: Year 11 Information Technology Teachers' Mailing List
Subject: Re: [Yr11 Information Technology] Spread sheet Exercises for 2013

Thanks Damien, that's a fun activity!
It would be interesting to compare the graphs the students come up with and as a class decide which ones are the most effective and why.

This is a neat little activity about bubble charts that I use towards the end of Outcome 1:
http://www.sccs.swarthmore.edu/users/06/adem/engin/excel/bubble_chart/index.php

I agree with Margaret that it is developing the critical thinking skills that is the challenge. When presented with raw data, students will happily produce column charts until the cows come home without thinking about whether it is the best way to represent the data.

-----Original Message-----
From: yr11it-bounces at edulists.com.au [mailto:yr11it-bounces at edulists.com.au] On Behalf Of ATKINSON-BUCK, Damien
Sent: Wednesday, 28 November 2012 3:51 PM
To: Year 11 Information Technology Teachers' Mailing List
Subject: Re: [Yr11 Information Technology] Spread sheet Exercises for 2013

I do love introducing excel with the Candy is Dandy exercise from Microsoft http://www.microsoft.com/education/en-us/teachers/plans/Pages/using_graphs.aspx
Did it today with my new group of year 11's (I used bags of snakes, jubes, jelly beans  and jelly beans due to various allergies), they loved it - I wouldn't let them eat it until they at least got to the report. I've never seen a group work so productively!

Damien Atkinson-Buck
Head of Learning Area: Technology/Arts
Ivanhoe Grammar School
-----Original Message-----
From: margaret.lawson at konstantkaos.net [mailto:margaret.lawson at konstantkaos.net]
Sent: Wednesday, 28 November 2012 11:53 AM
To: Year 11 Information Technology Teachers' Mailing List
Subject: Re: [Yr11 Information Technology] Spread sheet Exercises for 2013

I guess the challenge is how to we develop the critical thinking skills required to use the appropriate chart. I know that most of my kids have the usual Year 11 problems and then some more ...

What strategies have worked for us?

Margaret

> Margaret,
> I used ORB Resources and GCT.com.au
> Some great tutorials for all aspects of excel and other programs.
> Andrew
>
>
> Andrew Weir
> Head Of Learning eLearning
> Thomas Carr College
>
> -----Original Message-----
> From: yr11it-bounces at edulists.com.au
> [mailto:yr11it-bounces at edulists.com.au] On Behalf Of
> margaret.lawson at konstantkaos.net
> Sent: Tuesday, 27 November 2012 11:48 PM
> To: yr11it at edulists.com.au
> Subject: [Yr11 Information Technology] Spreadsheet Exercises for 2013
>
>
> After a fabulous VITTA PD Day on Monday, I was inspired by how Esther
> Andrews from Bendigo Senior Secondary went about teaching Unit 1.
>
> So I have been starting to see what is out there to use for my Year
> 11's for 2013.
>
> Does anyone have some good examples of scatter charts? Scatter and
> bubble seemed to be the hardest concepts for my Year 11's to grasp
> this year and I want to re-think how to introduce the kids to these concepts.
>
> I came across this site while looking for examples of Excel exercises:
>
> http://www.oneil.com.au/pc/excel2010.html
>
> :)
>
> Margaret Lawson
>
>
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> Year
> 11 It Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html -
> Victorian Curriculum and Assessment Authority http://www.vitta.org.au
> - VITTA Victorian Information Technology Teachers Association Inc
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>
> _______________________________________________
> http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe
> Year 11 It Mailing List kindly supported by
> http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html -
> Victorian Curriculum and Assessment Authority http://www.vitta.org.au
> - VITTA Victorian Information Technology Teachers Association Inc
> http://www.swinburne.edu.au/ict/schools - Swinburne University
>

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe Year 11 It Mailing List kindly supported by http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc http://www.swinburne.edu.au/ict/schools - Swinburne University

Privacy, Virus and Copyright Warning

The information contained in this electronic message (e-mail), and any files transmitted with it:

* is intended for the named recipients only. If you have received this in error, please advise the sender and delete it and any copies immediately;
* Any personal information in this email must be used in accordance with the Privacy Act 1988 and this always applies even if it has been sent to you in error.
* represents the views of the sender and does not necessarily represent the views or formal advice of Ivanhoe Grammar School;
* may be subject to Copyright, so no further use should be made of it without the author's permission.

The School does not represent or warrant that the email or any files attached do not contain errors or are free from computer viruses or other defects nor does it accept responsibility for any loss or damage resulting directly or indirectly from the use of the email or any attached files.

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe Year 11 It Mailing List kindly supported by http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc http://www.swinburne.edu.au/ict/schools - Swinburne University

_______________________________________________
http://www.edulists.com.au - FAQ, resources, subscribe, unsubscribe Year 11 It Mailing List kindly supported by http://www.vcaa.vic.edu.au/vce/studies/infotech/infotechindex.html - Victorian Curriculum and Assessment Authority http://www.vitta.org.au  - VITTA Victorian Information Technology Teachers Association Inc http://www.swinburne.edu.au/ict/schools - Swinburne University
________________________________
PRIVATE & CONFIDENTIAL
The content of this e-mail and any attachments may be private and confidential, intended only for use of the individual or entity named. If you are not the intended recipient of this message you must not read, forward, print, copy, disclose, use or store in any way the information this e-mail or any attachment contains.
If you are not the intended recipient, please notify the sender immediately and delete or destroy all copies of this e-mail and any attachments.
Our organisation respects the privacy of individuals. For a copy of our privacy policy please go to our website or contact us.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://www.edulists.com.au/pipermail/yr11it/attachments/20121129/cd60dcf3/attachment-0001.html 
-------------- next part --------------
A non-text attachment was scrubbed...
Name: bmglogo7b13002
Type: image/png
Size: 4842 bytes
Desc: bmglogo7b13002
Url : http://www.edulists.com.au/pipermail/yr11it/attachments/20121129/cd60dcf3/bmglogo7b13002-0001.png 