Microsoft+Excel+II

 ==== **  MASTERING MICROSOFT OFFICE SUITE FOR CLASSROOM MS Excel      II    ** ==== ====  **Friday February 20, 2009**      ==== ====  **Facilitator: Frances O'Neill  Foneill@schools.nyc.gov   **    ==== ====    **<span style="font-family: 'Comic Sans MS', cursive;">Presider: Phyllis Berkowitz PBerkow@schools.nyc.gov  <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">  **    ==== ==== <span style="color: #2014b3; font-family: 'Comic Sans MS', cursive;"> **<span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">Presisder: Susan Scott SScott2@schools.nyc.gov  <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">  **    ==== ====<span style="color: #2014b3; font-family: 'Comic Sans MS', cursive;">   <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">**Office of Instructional Technology**     <span style="color: #2014b3; font-family: 'Comic Sans MS', cursive;"> ====

<span style="color: #2014b3; font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">
====<span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"> I.<span style="font-family: 'Comic Sans MS', cursive;"> Excel Review 8:30-8:40      ==== ==== <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">II. Grade book independent work 8:40-10:30     ==== ====<span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"> <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">III. Advanced Tools 10:30 – 11:00     ==== ====<span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">   ====
 * <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">//Freezing Windows & Panes//
 * <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">//Filtering Data//
 * <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">Linking Pages

<span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">
====<span style="font-family: 'Times New Roman', Times, serif;">**<span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">IV. Excel Integration In the Classroom. M&M activity 11:00-12:00  ** ==== <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"> <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">V. 12:00 PM – 1:00 PM: Lunch
 * <span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: Arial, Helvetica, sans-serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"> <span style="font-family: 'Comic Sans MS', cursive;">//**Group work. Gathering information**//
 * <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;">// <span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: Arial, Helvetica, sans-serif;">**Creating an Excel sheet with data**  <span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;">      //


 * VI. 1:00-2:00 //<span style="font-style: normal; font-family: Symbol; mso-fareast-font-family: Symbol; mso-bidi-font-family: Symbol; mso-bidi-font-style: italic;"><span style="font-family: 'Comic Sans MS', cursive; msolist: Ignore;">· //// Create a Lesson- Use either Word to create your lesson plan. Use Excel to introduce data about the content.

VII. 2:00- 2:30 Share out // VII. 2:30-3:00- Evaluation **<span style="font-size: 12pt; font-family: Arial; mso-bidi-font-weight: bold; mso-fareast-font-family: 'Times New Roman'; mso-ansi-language: EN-US; mso-fareast-language: EN-US; mso-bidi-language: AR-SA;">: <span style="color: #165027; font-family: 'Comic Sans MS', cursive;">http://oitqpcredit.wikispaces.com/survey

===<span style="font-family: 'Times New Roman', Times, serif;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"><span style="font-family: 'Comic Sans MS', cursive;"> <span style="color: #165027; font-family: 'Comic Sans MS', cursive;">     === <span style="color: #165027; font-family: 'Comic Sans MS', cursive;">

** __Excel In the Classroom__ **
http://www.emints.org/ethemes/resources/S00000602.shtml Links to ideas for doing classroom projects that include the use of Microsoft Excel. There are many examples of using timelines, graphs, and probability charts for a variety of fun activities. Many sites offer step-by-step instructions or allow you to download a pre-formatted spreadsheet

http://www.wmburgweb.com/Resources/Lesson/index.htm Use the Internet and spreadsheets to find calories and fat in a typical fast food meal.

http://www.internet4classrooms.com/on-line_excel.htm Toturials, samples and links to lesson plans.

http://www.lttechno.com/links/spreadsheets.html Lesson Plans by grade level, tutorials and other resources.

Online Interactive Tools:
 * <span style="font-family: Verdana, Arial, Helvetica, sans-serif;">Collecting, Representing, and Interpreting Data Using Spreadsheets and Graphing Software: Collecting and Examining Weather Data, by [|Illuminations]
 * <span style="font-family: Verdana, Arial, Helvetica, sans-serif;">on NCES’s Web site. Select Bar Graph from the pull down menu labeled "Select Type of Graph" and click GO! Follow the instructions and print your very own colorful 3-D bar graph [|Create a Graph]
 * http://www.ncwiseowl.org/kscope/techknowpark/FreeFall/Graphing.html3