Educational Activities

The Winnipeg School Division No. 1
General InformationSubmit Activity | Search Activity Site 
Math Activities | Technology Skills Continuum Guide | Home

MS Works - Spreadsheet Part 1 - SP-III.2.6

(Originally from the Inner City Technology Goals Document – June 1997)

Description:
Students create an addition math table in Microsoft Works Spreadsheet

Math: Yes

TypeLessonPlan: Lesson Plan - 1 class

TechnologySkills: Spreadsheet, format, add cells, simple formulas

SoftwareUsed: MS Works 3.0 Spreadsheet

EarlyYears:

MiddleYears: Yes

S1-S4:

SpecificGrade:

Submittedby: Chris McCubbins

E-mail:

Details:
Open Microsoft Works and click on Spreadsheet.

Introduce or review cells in a spreadsheet. Type the word addition in cell A1. Use the mouse drag to highlight from cell B1 to cell L1. Click on Format. Click on Column Width and change Column Width to 5. Now type the number 0 to 10 in cells B1 to L1. Next type the number 0 to 10 in cells A2 to A12. Highlight cells B1 to L1 and change the fotn by clicking on Format, then Font and Style. Now select a different color and font. Click on OK.

Next highlight cells A2 to A12 change the font as for cells B1 to L1.

Demonstrate how to add two cells to get a sum, work through several as a group. Students will complete work on their won while observing and assisting.

Extensions:  (Literature Links, Further Explorations, etc.)



Filename:  Mathematics Spreadsheet Part 1.htm


General InformationSubmit Activity Search Activity Site | Technology Continuum Guide | Home
Copyright © 1995-98 The Winnipeg School Division No. 1. All rights reserved.
Please send comments to: tlc@wsd1.org