7th+Solar+system

7th grade solar system excel project

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
 * AutoSum and AutoSum list ||
 * Formatting Skills
 * 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 || Graphing ||

__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__ -

__**CREATING CHART**__
 * 1) research using Google the distance of each planet to the sun in miles.
 * 2) in cell A1 - type "planets"
 * 3) in cell A2 though A - type the names of each planet - one per cell
 * 4) in cell B1 type "Distance of planet to sun in Millions of Miles"
 * 5) in cell B2 - type the distance **WITHOUT** words example 34.5 NOT 34.5 miles
 * 6) highlight cell A1 down to cell
 * 7) click on "Charts" in the tool bar above the cells
 * 8) choose the type of chart that will display the distances - because of the large number difference the first bar will be almost flat and the last bar will be high.

__**CHART OPTIONS**__ from toolbar
 * 1) if the graph does not have a title or the horizontal or vertical axis are not labeled you go to "Titles" and type in your label
 * 2) Another nice option, especially for this graph because the numbers are difficult to read you can dd the numbers to the chart. go to "other options" and choose "Value"

__**Changing color of bars**__ - use the toolbar click on the chart and change colors or double click bars and change color under "Fill"

__**Add a picture -**__ Find a picture using Google images makes sure you click it TWO times to see the full size image drag the image to your desktop them from the desktop take it to your excel doc.

~EVERYTHING MUST FIT ON ONE PAGE~ //**sample**// - this is a sample - under the blue bar are the numbers and above the purple bars should be the numbers (I did not want to give you the answers :) )