June 9th, 2008
Week 14
Week 14
“Discuss dynamic geometry and excel spreadsheets as a pedagogical tool. What are the advantages and disadvantages and why?”
Geometers Sketchpad could be used by a teacher with an interactive whiteboard, by individual students in an ICT suite or by small groups of students working at a single computer. The Geometer’s Sketchpad is a dynamic construction, demonstration, and exploration tool that adds a powerful dimension to the study of mathematics. You and your students can use this software program to build and investigate mathematical models, objects, figures, diagrams, and graphs.
- With Sketchpad™, you can give your students a tangible, visual way to explore and understand core concepts—from numbers and operations, algebraic thinking, and geometry and measurement in elementary and middle school to algebra, geometry, trigonometry, precalculus, and calculus in high school and college. Concepts that students frequently find difficult become very clear when they see visual representations on the screen and interact with them using Sketchpad.
- Sketchpad has the flexibility to help you meet your teachingneeds regardless of your subject matter, technological expertise, grade level, or curriculum. You can take advantage of our subject-specific, ready-to-use activity books and sample activities or create your own activities and demonstrations to differentiate learning for all students.
- Sketchpad provides you with a faster, more dynamic and engaging way to demonstrate mathematical concepts than using transparencies or drawing on the board. Sketchpad works easily with your LCD projector, classroom computer, or SMART Board.
- Sketchpad can help you quickly explore variables, relationships, and the mathematics of change with your students. When you construct objects in Sketchpad, you can drag points and lines with the mouse. As shapes and positions change, all mathematical relationships are preserved, allowing you and your students to examine an entire set of similar cases in a matter of seconds.
- You can use Sketchpad across the mathematics curriculum, so you don’t need different software for each class, concept, or grade level that you teach.
- Sketchpad’s friendly user interface allows you and your students to get quickly up to speed so you can spend your time teaching mathematics, not software.
- You can quickly and easily generate teaching aids such as worksheets, tests, reports, and presentations with accurately measured figures by exporting Sketchpad files to word-processing programs and spreadsheets, other drawing programs, and the Internet.
GeoGebra is dynamic mathematics software for schools that joins geometry, algebra and calculus. GeoGebra is an interactive geometry system. You can do constructions with points, vectors, segments, lines, conic sections as well as functions and change them dynamically afterwards. GeoGebra has the ability to deal with variables for numbers, vectors and points, finds derivatives and integrals of functions and offers commands like Root or Extremum.
Microsoft’s Excel is a wonderful application that can be used to achieve student learning outcomes. Applications like Excel’s ability to help you quickly organize and create graphical representations of data for easier analysis is becoming a dominate force not only in the educational arena, but in the corporate world.
It’s no wonder why many educators from all levels are fast learning that applications like Excel not only need to be introduced in a students’ K-12 program, but it need to be introduced early and revisited often to reinforce the skills associated with such applications. Yet, many educators seem to be intimated by the level of understanding and competence required to effectively use applications like Excel in their teaching. In fact, many of our staff developers are often told by the educators who they work with, “If I don’t understand it, do you think that my students will?” While this statement is no doubt true, we encourage teachers to think of using technology, in this case applications like Excel, as they would any other tool in teaching. As with anything newly learned, it takes time to develop a new skill.
**What’s Good About It?**
1. Using Excel can enhance understanding of content within a graphic presentation of the information; it provides a visual representation of data that makes it easier to analyze.
2. Excel reduces the difficulty of plotting data and allows students a means for interpreting the data.
3. You can also reverse the traditional process of analyzing data by giving students a completed chart and see if they can reconstruct the underlying worksheet. This goes a long way toward helping them understand the relationship between the data and the chart.
4. Excel can easily convert any chart or data set into a web page, making it very easy to share information among groups. Many universities are using this model for data sharing between students who aren’t even on the same continent.
5. Excel’s ability to dynamically generate charts and graphs in seconds makes it easy to quickly demonstrate relationships between numbers.
6. As a teaching tool, students can see how different types of graphs and charts can be used to represent the same series of data. As one teacher stated, “For years it took me three to five days to teach kids the use a pie chart, bar graph, and/or a line graph to accurately represent information. Now with Excel, it makes it so much easier because the kids are far more motivated to use the application to manipulate data and to chart any information.”
One of the best things is that you can compare data between any two or more variables. Using storage devices (disks), you can store data and use it to conduct a comparative analysis of any information that you have collected over time. For example, you can compare





