Welcome to the MS Computer Lab Blog!
The objective of our blog is to share information about how we integrate our technology curriculum into the subject area curriculum. The foundation of this effort is the methodology of team teaching the lessons with the Middle School subject area teachers. Each post describes a particular lesson, the software used, some of the skills that were targeted, and the number of days that were spent in the lab.
Click to enlarge
_________________________________________________________
Tuesday, December 9, 2008
Climate Change and Excel
The 6th Grade Pre-Algebra 6 class did a project in Excel that examined temperature change in certain cities over the span of the last 50 years. They used a formula to convert the Fahrenheit readings to Centigrade and then applied several other formulas, such as mode, median and average (to arrive at the mean). The students graphed the temperature change and then added a trendline. Later on they inserted a histogram from the Data Analysis Tools. Finally, they went to Google Earth, found the city that they were researching, showed the latitude and longitude grid, and took a screenshot, which they inserted into their Excel worksheet. The lesson took four class periods.
