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
_________________________________________________________

Monday, November 17, 2008

A Vocabulary Lesson with Excel

Students in some of the 6th Grade Language Arts classes created a crossword puzzle in Excel with their vocabulary words of the week. Clues were added as comments and students used conditional formatting with the first letter of each word. They programmed Excel to make the first letter display green if the word entered was correct and red if the word was incorrect. Once they finished with the formatting, they saved a copy as lastname_key.xls and dropped it into their teacher's drop box. Then they saved the document under a new name: lastname_puzzle.xls, and proceeded to erase the answers so that another classmate could actually work out the puzzle. The students took three classes to finish this assignment.