8th+excel+formulas+2

8th grade formulas 2

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 Formulas & Functions Formatting Skills
 * Working with toolbars
 * Working with the menus
 * Keyboard moves
 * Entering info in a spreadsheet
 * Entering formulas
 * AutoSum and AutoSum list
 * Number formatting
 * Formatting using the toolbar
 * Formatting using the formatting palette
 * Cell alignment and spacing
 * Shrinking or wrapping text in a cell
 * 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

1 - Use the fictitious information below to get the total rainfall for each year. **I will check for the formula!!** 2 - Create a chart or graph for the months’ rainfall listed below.

Your chart should have these numbers in it -
 * || 2012 || 2013 || 2014 ||
 * January || 1.2 || 3.1 || 2.1 ||
 * February || 2.9 || 0.9 || 3 ||
 * March || 4.3 || 5.1 || 3 ||
 * April || 2.6 || 3.2 || 1.4 ||
 * May || 0.9 || 1.2 || 2.3 ||
 * June || 5.1 || 3 || 0.6 ||
 * July || 0.1 || 4.1 || 2.4 ||
 * August || 3.5 || 2.5 || 2.1 ||
 * September || 2.3 || 3.1 || 1.3 ||
 * October || 3.62 || 6.2 || 2.2 ||
 * November || 6 || 5.32 || 4.0 ||
 * December || 2.43 || 2.1 || 4.3 ||
 * total sum || xxx || xxx || xxx ||


 * *NOW CREATE AN APPROPRIATE CHART/ GRAPH FOR THE INFORMATION ( ** with out totals ** ) **
 * How to make your chart/graph - **
 * ** highlight all the info you want included in your graph (DON'T include totals) **
 * ** Insert -> charts **
 * **Change colors as you see fit.**

Add a Picture - first it must go to your desktop - then to the spreadsheet.

VIDEO HELP!!!!

__ Scoring Guide __
 * 1)  Creating chart (like above) – 10
 * 2)  Using SUM tool – 15
 * 3) chart – title - 10
 * 4)  Graph – common heights of bars – readable (no total in graph) - 10
 * 5)  Border on chart - 10
 * 6)  Graph title(10)
 * 7) horizontal and vertical – months/ inches of rain – 20
 * 8) Picture = 10

media type="custom" key="11137440" Samples