Mike Kreicker
Ann
Zinyemba

Word
Access
Excel
Publisher
PowerPoint

 
 
 

Microsoft Excel Lesson #8- Multiplication Table

Essential Question: How can I calculate Math in a spreadsheet?

NTES Standard:

5. Technology Research Tools

c. Students evaluate and select new information resources and technological innovations based on the appropriateness for specific tasks.

By the End of Grade 7-

Students know how to select information and technological resources based on the appropriateness and efficiency for completing tasks, providing the desired information, or addressing the identified objectives.

By the End of Grade 8-

Students know how to select and use information and communication technology tools and resources to collect and analyze information and report results on an assigned hypothesis or research question.

3.     Technology Productivity Tools

b. Students use productivity tools to collaborate in constructing technology-enhanced models, prepare publications, and produce other creative works.

By the End of Grade 8-

Students describe how to use online environments or other collaborative tools to facilitate design and development of materials, models, publications, and presentations; they know how to apply utilities for editing pictures, images, and charts.

Resources: Copies of Rubric/Self Check

Student Rubric: Click Here

Points:  Points

Save As: “LastNameFirstIntial”MutliTable

Directions: Podcast


Multiplication Table

1) Open your multiplication table.

 

2) Hold down Control key (Cntrl) and click on the numbers 2-4-6-8-10-12 and on the letters B-D-F-H-J-L. All these rows and columns should be highlighted.

 

3) Go to the Paint Bucket on the drawing toolbar and select a light color.

 

4) Highlight all the cells in chart from A1 to M13. Go to Format>Row>Height. Change number to 20 and hit OK.

 

5) Highlight all the cells in chart from A1 to M13.Go to Format>Column>Width. Change number to 7 and hit OK.

 

6) Highlight all the cells in chart from A1 to M13. Right click>Format Cells>Border Tab>Outline and Inside.

 

7) View>Header and Footer>Custom Header

                    Left Section Type>Multiplication Table

                    Right Section Type> Your Name and period

 

8) Save and print! Turn into tray!

DMS Comp App Home ~ MSD Decatur Home Page ~ Decatur Middle School Home Page

 


Ann Rosborough

Decatur Middle School Computer Applications
5108 S. High School Rd.
Indianapolis, Indiana 46224