ISTE+2014+Excel

=Excel for Teachers and Students=

Clear Targets: I can.. - identify basic worksheet and workbook concepts and terms. - enter and edit data. - modify worksheets and templates. - use formulas to calculate and return values. - format cells to enhance the appearance of a worksheet. - change the page setup to define how the printed worksheet appears. - use the text to columns feature to manipulate Powerschool data.

** Professional Development Standards for This Training **
ISTE NETS for Teachers


 * 1. Facilitate and Inspire Student Learning and Creativity ** Teachers use their knowledge of subject matter, teaching and learning, and technology to facilitate experiences that advance student learning, creativity, and innovation in both face-to-face and virtual environments. Teachers: a. promote, support, and model creative and innovative thinking and inventiveness. b. engage students in exploring real-world issues and solving authentic problems using digital tools and resources.


 * 3. Model Digital-Age Work and Learning ** Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society. Teachers: a. demonstrate fluency in technology systems and the transfer of current knowledge to new technologies and situations.


 * Why use Spreadsheets?**


 * **Organizational Features for Students and Teachers**
 * **Data Collection and Organization**
 * **Students make charts and graphs from spreadsheet records, learning to organize their ideas and present information to an audience.**
 * **Charts add meaning to information, helping students to analyze and interpret data, as they identify the maximum and minimum, mean, median and mode of a data set.**
 * **The computer can generate bar graphs, line graphs and pie charts.**
 * **Pie charts reinforce the idea of percentages as these are represented visually, and help students compare ratios.**


 * Example of Teacher Lesson Plan**


 * [|Details]
 * [[file:empowerstudents/Lesson Plan Template.xlsx|Download]]
 * 73 KB

**Separating Text into Columns**
1. If you have text all in one column that you would like in two different columns, such as, first name and last name in one single column. 2. Click on the **Data** tab in the Ribbon. 3. Under the heading of Tools, click on **Text to Columns**. 4. Make sure **Delimited** is selected, click **Next**. 5. Selected the way that the data is separated, such as, tab, space, comma, etc. Click **Next**. 6. Select Column data format: general, text, date for each column. Click **Finish**.


 * Example of Entering Data and Making a Basic Graph**


 * [|Details]
 * [[file:empowerstudents/Estimation.xlsx|Download]]
 * 12 KB

Images for use:

How to Make a Pictograph


 * Example of Entering Formulas** Directions for students to make a multiplication table. Also includes higher ordered thinking skills to make other tables using formulas.


 * [|Details]
 * [[file:empowerstudents/Multiplication Table.doc|Download]]
 * 538 KB

**Tips for Entering Formulas** 1. Formulas are just equations. Instead of adding or subtracting numbers you are adding and subtracting the contents of a cell. 2. Excel includes a number of predefined functions to use as well. You can combine the predefined functions into your own formula. 3. When you type in formulas, the order of operations must be correct. The correct order is: parentheses, exponents, multiplication, division, addition, then subtraction. 4. Remember if you use formulas with equations in the numerator and denominator, you need to use parenthesis to force the spreadsheet to calculate them properly. 5. Make sure when copying a formula that you are copying the formula and not the results.


 * Example Using the Average Temperature lesson to model inputting data and using various toolbars to manipulate data**. [|Temperature Data] Inserting a Chart


 * 1) Select columns that you want to graph (make sure that you include the titles).
 * 2) Click the Insert - Chart icon on the Function Toolbar. (Or Click __I__nsert > Ch__a__rt... The "Chart Wizard" window appears.)
 * 3) Select the type of graph (chart) that you would like to create (bar, pie, linear, etc.).
 * 4) Then select Next>> three times.
 * 5) Type in the Title and a Subtitle, if desired.
 * 6) Then select Finish.
 * 7) You then can cut and paste the graph to put into the 3rd page labeled Charts.


 * [|Details]
 * [[file:empowerstudents/How to Create a Self Checking Worksheet.pdf|Download]]
 * 165 KB


 * Templates and Tutorials**


 * [|Details]
 * [[file:empowerstudents/Sub folder Documents.xlt|Download]]
 * 1 MB

**Inserting a Chart **
1. Select columns that you want to graph (make sure that you include the titles). 2. On a PC, click F11 and your chart will appear. 3. On a Mac, click the **Chart icon on the** Ribbon. **(Or Click** __I__nsert > Ch__a__rt... **The "Chart Wizard" window appears.)** <span style="font-family: Arial,Helvetica,sans-serif;">4. Select the type of graph (chart) that you would like to create (bar, pie, linear, etc.). <span style="font-family: Arial,Helvetica,sans-serif;">5. If using the **Chart Wizard**: a. Then select **Next>>** three times. b. Type in the **Title** and a **Subtitle**, if desired. c. Then select **Finish**. <span style="font-family: Arial,Helvetica,sans-serif;">6. You can change the titles, colors and preferences by double clicking on the graph on the items you would like to change. 7. You can insert the chart on a different sheet by going to **Chart** on the top menu and selecting move chart.

Try this:
//**Use data found on internet to model inputting data and using various toolbars to manipulate data.**// //**World Cup Data**//


 * [|Details]
 * [[file:empowerstudents/WorldCupData.xlsx|Download]]
 * 37 KB



<span style="font-family: Verdana,Geneva,sans-serif;">**Absolute and Relative Cell Referencing** <span style="font-family: Verdana,Geneva,sans-serif;">1. Enter 10 in A1 and 20 in A2. <span style="font-family: Verdana,Geneva,sans-serif;">2. Click in cell B2 and type =A1+A2, then Enter. You should get 30. (10+20=30) <span style="font-family: Verdana,Geneva,sans-serif;">3. Now click in cell B2, Cntl Click, Copy. <span style="font-family: Verdana,Geneva,sans-serif;">4. Click in cell B3, Cntl Click, Paste. I got 20?? <span style="font-family: Verdana,Geneva,sans-serif;"> 5. Odd 10+20 is not 20. This is because the default for cell referencing in Excel is Relative. Which means that when we thought we were copying the formula into Cell B3 we actually copied the movements of up one and left one which is where A1 and A2 are relatively located from B2. <span style="font-family: Verdana,Geneva,sans-serif;"> 6. Absolute cell referencing will cause this to work properly. To reference a cell using absolute cell referencing you need to use a dollar sign ($). To actually copy the formula not the spaces moved you need to put the formula in as =$A$1+$A$2. <span style="font-family: Verdana,Geneva,sans-serif;"> 7. You can mix relative and absolute cell referencing, but we are not going to cover that today.


 * Example of Absolute and Relative Cell Referencing**

<span style="font-family: Verdana,Geneva,sans-serif;">**More Examples** [|Linear Equations in Excel]


 * <span style="font-family: Verdana,Geneva,sans-serif;">[|Data for Inserting into Excel] ** **<span style="font-family: Verdana,Geneva,sans-serif;"> Use data above to create a chart showing population differences in the 5 largest counties in Tennessee. ** Landmarks for Schools Raw Data

<span style="font-family: Verdana,Geneva,sans-serif;">**Spreadsheet Lessons** **<span style="font-family: Verdana,Geneva,sans-serif;">[] ** **<span style="font-family: Verdana,Geneva,sans-serif;">[] ** **<span style="font-family: Verdana,Geneva,sans-serif;">@http://mathforum.org/mathtools/cell/a,11.8.3,ALL,ALL/ **
 * Helpful Links: **

=
**<span style="font-family: Verdana,Geneva,sans-serif;">[] **======

=
**<span style="font-family: Verdana,Geneva,sans-serif;">[|http://www.lttechno.com/links/spreadsheets.html] **======

=
**<span style="font-family: Verdana,Geneva,sans-serif;">[] **======

<span style="font-family: Verdana,Geneva,sans-serif;">**<span style="font-family: Verdana,Geneva,sans-serif;">[|How to Make a Pictogram] **


 * <span style="font-family: Verdana,Geneva,sans-serif;">http://rms102.wikispaces.com/Using Excel **