8th+excel+Multiplication+formulas

8th grade Multiplication formulas using Excel url}?f=print|print this page __PA standards__ –
 * NETS.1.6-8: Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.
 * NETS.2.6-8: Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others.
 * NETS.3.6-8: Students apply digital tools to gather, evaluate, and use information.
 * NETS.6.6-8: Students demonstrate a sound understanding of technology concepts, systems and operations.

__Objectives__ -

Student will be able to use Excel to do the following skills...
 * Workbook Skills
 * Working with toolbars
 * Working with the menus
 * Keyboard moves
 * Entering info in a spreadsheet

Formulas & Functions
 * Entering formulas || Formatting Skills
 * Number formatting
 * Formatting using the toolbar
 * Formatting using the formatting palette
 * Selecting columns and rows
 * Changing column width and row height ||

__Tech lab__ #8

__Evidence of best practice__ – students will be able to refer to the video and helpful tips on my wiki at anytime they get stuck.

__Activity__ - using excel students will create a simple chart using the multiplication formula.

** CREATING FORMULAS IN EXCEL ** - ONE-day assignment

Formulas are used to calculate math problems Directions Open sheets – remember each cell has a name (A1, B3, C6) You will create formulas to do multiplication.


 * 1) Begin in cell A2 (click in it) and enter number 1. Proceed down with numbers 2, 3, 4, 5, 9.6, 24, 63, 48, 125 - GOING DOWN
 * 2) Then enter the number 1 in cell B1
 * 3) Click in cell B2 – this is the cell you want to add the formula to multiply cell A2 and B1.
 * 4) Formulas must always start with =, so the formula would be =A2*B1 - press enter
 * 5) Click in cell B3 and enter formula (=A3*B1). Press enter and the answer appears.
 * 6) Continue this process until all are answered.
 * 7) ONCE FINISHED going to all 10 numbers/cells– click in cell B1 and change the number to 5 – watch all the numbers change
 * 8) change the size of the text to 14
 * 9) change the color in column A to red, B to Blue
 * 10) Change the font to a print other than the default
 * 11) add a border around ONLY the chart, NOT the whole workbook.

 //How to view formula bar// – go to top menu bar and look for "View" => go down to "formula bar"

**__Rubric – 100 points__** All numbers are input correctly 20 All text is size 18 - 10 borders around **table** - 10 Formulas are correct - each cell worth 5 points each (50 total) B1 is the number 5 in the end - 10

50% if formulas all wrong 25% if not formulas at all