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
_________________________________________________________

Wednesday, October 28, 2009

Trendlines and Excel

The 8th Grade Algebra students used Excel to make a scatter graph of certain data. Later they applied a trendline to the data and used the corresponding equation to calculate a new value. This lesson took one class period to complete.

Thursday, October 22, 2009

Dominant and Recessive Traits in Filemaker Pro 9 and Excel

The 8th Grade Science students used Filemaker Pro 9 to create a database with their class's data which included information about seven different physical traits. Once the students compiled all this data (which they obtained by importing their classmates' exported data files from the teachers' shared folder on the Middle School server), they used Excel to calculate and compare the percentages of the dominance of the different traits. This project took three class periods to complete.



Tuesday, October 20, 2009

Sumerian Cities and Sketchup

The 6th Grade Social Studies students used Google Earth and Google Sketchup to create a model of an ancient Sumerian city. They included crop fields, irrigation canals, fortifications, housing and a ziggurat. The students needed to use navigation tools like zoom, orbit and pan in order to construct all the different features of their model. This lesson took approximately four days to complete.



Friday, October 16, 2009

Divisibility Rules and Excel

The 6th Grade Math students used Excel to create formulas that checked the divisibility of numbers from 1 to 200. Using the Formula Builder, they combined several functions including IF, OR, MOD, and ISEVEN to construct the different rules. Later the students used conditional formatting to identify patterns. The lesson took three class periods to complete.

Friday, October 9, 2009

Special Points in Circles and Geometer's Sketchpad

The 8th Grade Geometry students used Geometer's Sketchpad to construct and examine the four points of concurrency and their properties. This lesson took one class period to complete.

Wednesday, October 7, 2009

Black Death Journal and Google Docs and Word

The 7th Grade Social Studies students did research on conditions in Europe during the Bubonic Plague. They recorded their notes in a document created and saved in their Google Docs account. From there, the students created a Word document that they formatted like a medieval journal or diary. Drawing from their notes in Google Docs, the students wrote about the plague from the point of view of a person living during that time period. This lesson took four days to complete.



Friday, October 2, 2009

AcentuaciĆ³n and Premiere Pro

The 6th Grade National Spanish students created a short movie that explained accent rules for different groups of words. They animated pictures and text, and later added a sound track. This lesson took five class periods to complete.