Home
Picture of Children at Computers
TechnoKids LogoPicture of Children at Computers
 

 

Curriculum







TECHNOTHINK TECHNOLOGY PROJECT

Microsoft Excel Lesson Plans

Teacher Guide - Customizable Resource Files

Are you looking for fun Microsoft Excel lesson plans to use with your students? TechnoThink is full of creative ways to use spreadsheets.

The lesson plans are divided into four parts:

  • You Found my X Cell
  • EXCELlent Word Search
  • Mad Lib with EXCELlence
  • EXCEL your Brainpower with a Quiz

 

Part 1: You Found my X Cell

What to teach spreadsheet basics in a FUN way? Engage your students in a game of strategy called "You Found my X Cell" to learn spreadsheet basics. This game is similar to the family favorite Battleship. It is a great way to teach students spreadsheet terminology, cell references, and how to enter and format data in a cell. Who will be the first to say, "You found all my X cells"?

 

Part 2: EXCELlent Word Search

Your students will enjoy learning spreadsheet skills when they make a challenging word search for their friends. This fun activity teaches how to:

  • add data into a cell
  • format text
  • merge and center cells
  • fill a cell with color
  • format borderlines
  • insert clip art
  • adjust column width
  • set print settings

microsoft excel lesson plans word search

 

Part 3: Mad Lib with EXCELlence

Teaching advanced spreadsheets skills can be FUN! Have your students learn about 3D cell referencing, by making silly sentences in the style of a "mad lib". A mad lib is an unexpected sentence or story that is created using words that a person selects.

microsoft excel lesson plan for 3d cell referencing

Click to see a sample of the Mad Lib Planning Sheet.

 

Part 4: EXCEL your Brainpower with a Quiz

Have FUN with FUNCTIONS. Follow the detailed Microsoft Excel lesson plans to make a multiple choice quiz created using if-then statements. If-then statements are formulas that are used to display a particular type of response based on the answer that is entered into a cell. For example, if a person types in the correct answer to a multiple choice question, "You are smart" will appear in a cell but if the answer is incorrect then, "Try again" will appear.

 

What do I Receive When I Order TechnoThink?

When you order TechnoThink you receive:

  • Teacher Guide
  • Certificate of Achievement
  • Parent Letter
  • Animal Word Search sample file
  • Word Search template
  • Mad Lib sample file
  • Mad Lib template
  • Designing a Mad Lib handout
  • Disney Quiz template
  • Spiderman Quiz sample file

 

How much does TechnoThink Cost?

The TechnoThink technology project is great value for your money. You will receive a teacher guide and customizable resource files for a price that is affordable.

 

Software: Microsoft Excel 2000, XP, 2003

 

Primary Technology Projects Junior Technology Projects
Intermediate Technology Projects Senior Technology Projects
Camp Technology Projects Teacher Technology Projects
About Technology Projects sitemap

 

MS Excel Lesson Plans

Other MS Excel Technology Projects by TechnoKids:
 
TechnoBiz: Develop a plan to increase candy sales using MS Excel.
 
TechnoSales: Plan and organize a bake sale using MS Excel.
 
Entrepreneur: Become a restaurateur and use MS Excel to organize the business venture.
 
TechnoInvestor: Buy and sell stocks on the TechnoStock Exchange. Use MS Excel or organize trade information.
 
TechnoCEO
Attract investors to invest in your company. Organize financial data using Excel and PowerPoint.
 
Consultant
Develop a plan to increase sales. Learn advanced spreadsheet skills such as pivot tables, formulas, and mail merge.
 
Intro to Excel
Create an electronic grading book to help keep track of student's marks using MS Excel.
 

 

 

Computer Lesson Plans

FUN Technology Projects by TechnoKids:
 
TechnoKnight: Go on a quest to save a mystic creature. With each challenge you earn your right to become a knight. Can you save the kingdom?
 
Olympics:
Represent your country in the TechnoOlympics. Participate in Techno
Gymnastics, Internet hurdles, and the graphics relay. Will you win gold, silver, or bronze?
 
TechnoPhotos: Become a pop art sensation! Transform your photo to create images that are a tribute to Andy Warhol.
 
TechnoPirate: Dress like a pirate with a hat, eye patch, and parrot. Then sail the seven seas to find treasure in an Internet hunt. Next, make a treasure map using MS Word with an "X" to mark the spot. Can your friends use the map to find the treasure?
 
 
Picture of TechnoKids Computer Curriculum Picture of TechnoKids Computer Curriculum View a Video about TechnoKids Computer Curriculum

© 2008 TechnoKids Inc.

TechnoKids Inc., 2097 Bates Common, Burlington, ON, Canada, L7R 0A5
Toll Free: 1.800.221.7921
Phone: 1.905.631.9112
Fax: 1.905.631.9113

 information@technokids.com