Spreadsheets and the Interactive Whiteboard

1. Spreadsheets and the Interactive Whiteboard in the Primary Mathematics Classroom

3. Junior School

6. Junior School Computer Room 30 Computers - IWB

9. It is an understatement to say that Learning is enhanced through the use of technology. • In mathematics we use technology for: • games and drills to aid instant recall of facts • practice in computation • explaining geometrical and measurement principles using the vast resources of the Internet and commercially produced educational software

10. It's about Culture: How to Really Integrate ICT Australian Teacher Magazine Article “The integration of technology across the curriculum has become a major priority for educational authorities and schools over the last decade; this is more recently seen as essential for giving young people the understanding and skills necessary to compete in an ever expanding, knowledge-hungry world.”(John Raiti) http://icttaskforce.edna.edu.au/icttaskforce/Jahia/home/inspired

11. Australia’s New Government Computers for Students Australian Secondary Schools Computer Fund A new personal computer for all students Yrs 9 -12 “However, this alone will not encourage teachers to use the new technology in the most productive way.” (John Raiti) Now more than ever, are teachers and students challenged to use existing ICT programs for discovery and mathematical insights. http://icttaskforce.edna.edu.au/icttaskforce/Jahia/home/inspired

12. Our aim is : • to get young minds excited about making their own -------- discoveries in mathematics and • to encourage students to tell us about these -------- discoveries The Spreadsheetis an excellent tool for doing this + An Interactive Whiteboard = A Winning Combination

13. “Mathematics is a tool with which God created the Universe.” Galileo Galilei 1564 - 1642

14. Spreadsheets are now more available to 12 year olds. You might ask “Why 12 year olds?” If you’ve ever had a problem with your TV remote or DVD player, as the saying goes, “Ask a 12 year old.” They’ll fix it for you! Getting young minds excited about their discoveries in Mathematics is what we are about. How to do this? Numbers can seem ordinary at first but … What interesting patterns we can find in them! Then they become more fascinating to students.

15. Pythagoras concluded that there are only Four Important Areas of Mathematics The Quadrivium of Mathematics Discrete Continuous The Absolute The Applied The Static The Moving Arithmetic 4 + 2 = 6 Music Geometry Astronomy This is the focus of our presentation today using spreadsheets

16. Even though spreadsheets have not been used much resources for them have been available for quite some time. Two excellent books are: Switched on Maths - Spreadsheets in Maths

17. Dr Ann Williams – Griffith University in Brisbane “The power of spreadsheets lies in their capacity to take the students beyond what they can achieve within the normal classroom with pencil and paper.” Spreadsheets permit the exploration of relationships, thus presenting opportunities for higher order thinking skills.

18. Bloom’s Taxonomy Developed by Benjamin Bloom in the 1950’s as a means of expressing qualitatively different kinds of thinking: Remembering,Understanding,Applying, Analysing, Evaluatingand Creating. Lorin Anderson (former student of Bloom) revised the taxonomy in the 1990’s and made a number of changes. Note that in this presentation, I am using the Anderson’s terms, but Bloom’s original order.

19. BLOOM’S TAXONOMY EvaluatingJustifying a decision or course of actionChecking, hypothesising, critiquing, experimenting, judgingCreatingGenerating new ideas, products, or ways of viewing thingsDesigning, constructing, planning, producing, inventing.AnalysingBreaking information into parts to explore understandings and relationshipsComparing, organising, deconstructing, interrogating, findingApplyingUsing information in another familiar situationImplementing, carrying out, using, executingUnderstandingExplaining ideas or conceptsInterpreting, summarising, paraphrasing, classifying, explainingRememberingRecalling informationRecognising, listing, describing, retrieving, naming, finding Higher Order Thinking Skills Lower Order Thinking Skills

20. Spreadsheets are under-utilised in Mathematics Our 12 year olds have very limited knowledge Writing of formulas is new to them In 2008 we upgraded to Microsoft Office 2007 It has a very different menu system to 2003 version First task: Teach the new screen features of Excel We did this using the Interactive Whiteboard

22. Quick Access toolbar Title Bar Office Button Office Button Quick Access toolbar Title Bar

25. Brackets of X + 20 9 26 36 8 3 11 3

26. 20 9 26 36 8 3 11 3 L4 M5 K3 M6 M5 M3 M4

27. = B6 - B5 = B6 - B5 653

28. Spreadsheets do the computational hard work while students concentrate on exploring and discovering.

29. Instructions for the Product Chart Click on A1 and drag to cell O1 Drag down to row 25 Use ‘page’ colour to colour the whole page. Use a text box to make the heading “Number Patterns” In B8 type ‘Number’, C8 type ‘2x table’, C9, 3x table etc In B9 type 1. Click on the corner and drag down to B10 Click on the + sign and highlight the ‘Fill series’ Drag down to number 15. In C9 type ‘ = B9*2 Drag the corner down 15. Repeat for all the other tables. Highlight C9 to M9 and click on the ∑ symbol Repeat for all the rows At C24 type sum and drag the cell across to O24 Do the same for all the columns down

30. Draw lines to show patterns

32. The best teachers are those who equip students to THINK for themselves.

38. Powerful learning does not occur by accident, it is usually the result of an effective learning situation created by a skilful teacher. (Joyce & Showers, 1991)

42. Questions Do the work responses of the students demonstrate a deep understanding of the concepts or Ideas? Does classroom talk lead to sustained conversational dialogue between student and teacher and between student and student to enhance understanding of the topic at hand? Is the lesson connected to a focus on identifying and solving real world problems?

43. Better a thousand days of diligent study, is one day with a great teacher. (Japanese Proverb)