Multiplication Practice
| Subject Area: Math/Computer | X + X + X + X + X |
| Grade Level: Middle School | |
| Software Program: Excel (Office '97) | |
Equipment Needed:
|
|
| Time Required: One or two 40 minute sessions | |
| Student instructions: | |
| Task: In
this project, you will be using formulas to drill and
practice multiplication. A skills sheet will be given to
the student to complete during the first 15 minutes of
the session. The teacher may prefer to call out the
problems orally to the students. At this time, the
student will work problems using pencil and paper. When
the student has finished this, they will be sent to the
computer. Students will enter Excel and begin on the
spreadsheet by entering the problem into the excel
worksheet. The top number (the multiplican) will go in
"A" cells from 1 to 25. Students will then
insert the multiplier (the bottom number) into the
"B" column from 1 to 25. To check for
correctness, the student will insert the formula into C1.
To do this the student clicks on the autosum button (it
looks like a fancy e, and it is located by Fx). The student should now click in the window showing =sum(A1:B1). Click right after the word "sum". Now backspace over "sum" and change it to say "product". Now press enter. Now click in the C1 cell, hold down the mouse button while highlighing the 50 cells. Now click on edit, go to fill, and click on down. This will fill down the formula and write the answers. Now the student should check their answers to the computer answers. Any difference would indicate an error with the technology or the math. Students should see the teacher if they are having trouble with different answers. (See the bottom of this page for a math worksheet with multiplication practice problems.) |
|
| Step 1: Let's Get
Started On the Computer: 1. Open a new Excel spreadsheet. 2. Create a spreadsheet that is at least 3 columns by 25 rows. 3. Insert your numbers for the problems. 4. Fix your formula. 5. Check your work and protect your cells with the answers. (See step #2) 5. Let your teacher check your work. |
| Step 2: Protecting your formulas: 1. Once you are sure that your formulas work, you should lock them so that they won't accidentally get deleted or changed. 2. Click on the line right beneath the top "C" cell. This will highlight all of "C". 3. Select the Format option at the top of the screen. Click on cells. 4. Now click on the tab called "Protection" and make sure that there is a checkmark in locked. If not, click in the square and put the check in locked. 5. Have the teacher check your work. |
| Addition Practice:
You can create a multiplication practice sheet just like you created the addition practice. In your formulas, simply leave the word "autosum". |
Multiplication Worksheet
| 1. 56 x 40 = | 2. 126 x 127 = | 3. 19 x 34 = | 4. 123 x 321 | 5. 299 x 345 |
| 6. 45 x 87 = | 7. 345 x 983 = | 8. 23 x 98 = | 9. 50 x 2 = | 10. 100 x 50 = |
| 11. 67 x 90 = | 12. 12 x 12 = | 13. 1234 x 1234 = | 14. 90 x 5 = | 15. 670 x 450 = |
| 16. 9075 x 3456 = | 17. 15 x 5 = | 18. 456 x 23 = | 19. 19 x 10 = | 20. 456 x 890 = |
| 21. 45 x 45 = | 22. 12 x 15 = | 23. 45 x 23 = | 24. 78 x 14 = | 25. 56 x 67 = |
Evaluation:
| Content Based Web Site Rubric | |||||
| 1 | 2 | 3 | 4 | ||
| Layout/ Design | Spreadsheet is unattractive or inappropriate. Text is difficult to read. Backgrounds and graphics are distracting. | Spreadsheet appears busy or boring. Text may be difficult to read. Backgrounds and graphics are somewhat distracting. | Spreadsheet is eye-catching and attractive. Text is easy to read. The backgrounds are subtle and appropriate. | Spreadsheet is creatively designed with text in tables. Graphics and backgrounds enhance the page. | |
| Information | Information is poorly written, inaccurate, or incomplete. | Some information is provided, but is limited or inaccurate. | Information is well written and interesting to read. | Information is accurate and complete, is creatively written, and is cleverly presented. | |
| Formulas/multiplication | 0 to 50% accurate information. | 51%-70% accurate information. | 71% -93% accurate information. | 94% to 100% accurate information. | |
| Following Classroom Guidelines | Students are often out of their area without permission and are disruptive to the class. | Students occasionally leave area without permission. | Students stay in their area and talk quietly to their own partner only. | Students are always on task, stay in their own area, and work quietly. | |