Excel

= = =Excel for the Classroom= Bill Gates Retirement movie media type="youtube" key="zms4oyaIgo4" height="344" width="425"

=Session 1=

Step by step instruction can be found at the [|USD on-line tutorial]

: Quick Overview of a Worksheet : Customizing your Desktop : Overview of the Toolbars: Formula, Standard, Formatting, Title

Working with Cells : Editing & Selecting: Moving, Coping, Inserting, Deleting, Merging, Selecting Ranges : Formatting Text & Numbers : Formatting Backgrounds: Highlight, Fill : Borders – Line Style

Basic Excel Help media type="youtube" key="FNPNS6MT1Kk" height="344" width="425"

=Session 2=

: Intro to Functions <span style="font-size: 9pt; font-family: 'Arial','sans-serif';">AutoFill vs. Move Relative vs. Absolute formulas Reviewing Formulas SHIFT ~

<span style="font-family: Wingdings; mso-fareast-font-family: Wingdings; msolist: Ignore; msofareastfontfamily: Wingdings; mso-bidi-font-family: Wingdings; msobidifontfamily: Wingdings;">: <span style="font-family: 'Arial','sans-serif';">Functions: Statistical Operators <span style="font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">1. <span style="font-family: 'Arial','sans-serif';">Average, Mean, Median, Mode, Max, Min <span style="font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">2. <span style="font-family: 'Arial','sans-serif';">Standard Deviation <span style="font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">3. <span style="font-family: 'Arial','sans-serif';">Nested Operatives <span style="font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">4. <span style="font-family: 'Arial','sans-serif';">Creating a Numbered List <span style="font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">5. <span style="font-family: 'Arial','sans-serif';">Cell Referencing Techniques ($) <span style="font-family: 'Arial','sans-serif';">Movie Help <span style="font-size: 9pt; font-family: 'Arial','sans-serif';"> media type="youtube" key="T0depz1iecI" height="344" width="425"

<span style="font-family: Wingdings; mso-fareast-font-family: Wingdings; msolist: Ignore; msofareastfontfamily: Wingdings; mso-bidi-font-family: Wingdings; msobidifontfamily: Wingdings;">: <span style="font-family: 'Arial','sans-serif';">Shortcuts: Moving Away from the Mouse

=Session 3=

<span style="font-family: 'Arial','sans-serif';">Importing data from a Word Document:

<span style="font-size: 8pt; font-family: 'TI-83 Symbols'; mso-fareast-font-family: 'TI-83 Symbols'; msolist: Ignore; msofareastfontfamily: 'TI-83 Symbols'; mso-bidi-font-family: 'TI-83 Symbols'; msobidifontfamily: 'TI-83 Symbols'; mso-bidi-font-size: 12.0pt; msobidifontsize: 12.0pt;">Ò <span style="font-family: 'Arial','sans-serif';">Creating Charts <span style="font-size: 8pt; font-family: 'TI-83 Symbols'; mso-fareast-font-family: 'TI-83 Symbols'; msolist: Ignore; msofareastfontfamily: 'TI-83 Symbols'; mso-bidi-font-family: 'TI-83 Symbols'; msobidifontfamily: 'TI-83 Symbols'; mso-bidi-font-size: 12.0pt; msobidifontsize: 12.0pt;">Ò <span style="font-family: 'Arial','sans-serif';">Integrating Charts into the Classroom <span style="font-size: 8pt; font-family: 'TI-83 Symbols'; mso-fareast-font-family: 'TI-83 Symbols'; msolist: Ignore; msofareastfontfamily: 'TI-83 Symbols'; mso-bidi-font-family: 'TI-83 Symbols'; msobidifontfamily: 'TI-83 Symbols'; mso-bidi-font-size: 12.0pt; msobidifontsize: 12.0pt;">Ò <span style="font-family: 'Arial','sans-serif';">Dealing with Data

Sorting Data [|PSSA data] [|PaAYP data] [|PVAAS data]

<span style="font-size: 9pt; font-family: 'Arial','sans-serif';">Printing Options <span style="font-size: 9pt; font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">1. <span style="font-size: 9pt; font-family: 'Arial','sans-serif';">Selected Cells <span style="font-size: 9pt; font-family: 'Arial','sans-serif'; mso-fareast-font-family: Arial; msolist: Ignore; msofareastfontfamily: Arial;">2. <span style="font-size: 9pt; font-family: 'Arial','sans-serif';">Optimizing pages

Classroom Ideas & Activities