1 / 18

Dardanelle Middle School Summer In-Service June 6 – 8, 2011

Dardanelle Middle School Summer In-Service June 6 – 8, 2011 . Presenters Lisa Huelle and Joe Rocconi. Schedule. Monday, Tuesday, Wednesday 8:00 – 3:00 Lunch on your own Monday NETS Technology Toolkit and Common Core Spreadsheet basics Tuesday Report back on spreadsheet lesson plans

vida
Download Presentation

Dardanelle Middle School Summer In-Service June 6 – 8, 2011

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. Dardanelle Middle SchoolSummer In-ServiceJune 6 – 8, 2011 Presenters Lisa Huelle and Joe Rocconi

  2. Schedule • Monday, Tuesday, Wednesday • 8:00 – 3:00 • Lunch on your own • Monday • NETS • Technology Toolkit and Common Core • Spreadsheet basics • Tuesday • Report back on spreadsheet lesson plans • BEGIN 2011 test data analysis using spreadsheets • Wednesday • Continue test data analysis using spreadsheets

  3. National Technology Standards • Student Technology Profile by Grade • Keep these on file or bookmark on your computer

  4. Technology Toolkit • The Dardanelle School District is adopting this terminology K-12. • All teachers are to use these terms when making technology based assignments to students • Technology Toolkit consists of… • Word processor • Spreadsheet software • Presentation software

  5. Technology Toolkit: Word Processor • Used for… • Typing sentences, paragraphs, essays, reports • Simple lists using bullets • Simple tables of information • Examples include • MS Word • Google Docs: text document • Open Office: word processor • Pages (apple)

  6. Technology Toolkit: Presentation Software • Used for… • Presenting oral summaries of research and/or data • Provides some animation capabilities • Examples include… • MS PowerPoint • Google Docs: presentation • Open Office: presentation • Keynote (apple)

  7. Technology Toolkit: Spreadsheets • Used for… • Listing and sorting data • Doing calculations • Simple addition & subtraction • Multiplication & division • Totaling large amounts of numbers • Averaging a LONG series of numbers • Plotting graphs • Bar graphs • Scatter plots • Pie charts • Radar plots • Many others…

  8. Technology Toolkit: Spreadsheets (continued) • Examples include… • MS Excel • Google Docs: spreadsheet • Open Office: spreadsheet • Numbers (apple)

  9. Spreadsheet software samples Final STUDENT Products

  10. Spreadsheet software samples

  11. Spreadsheet software samples

  12. Where did the students get the data to make the graphs… • Teacher does online search for spreadsheets on a topic of your choice… • Example: Arkansas Earthquake Data

  13. Spreadsheet software sample lessons Final STUDENT Products

  14. Spreadsheet basics • In this workshop, we will be using MS Excel • What we learn about spreadsheets will transfer to most other spreadsheet programs. • On your laptop, locate and open… • Microsoft Office Excel

  15. Helpful Hint: Online search for prepared spreadsheets with data… • Open your Internet Explorer • Go to www.google.com • Type in a topic from your curriculum that is likely to be associated with “data” using this method… • Arkansas trout filetype:xls

  16. Spreadsheet basics • Create AT LEAST one technology based lesson for your subject area. • The lesson plan should ID • SLE • Technology NETS • Use any part(s) of the Technology Toolkit • Describe the product required of the student in terms of the Technology Toolkit • Include a scoring guide or rubric that will be used by the teacher

  17. Data analysis project • DMS received the first draft of Benchmark 2011 test scores. • You will be broken into small teams and create spreadsheets plus graphs for the following subpopulations • LEP/ESL • Free & Reduced Lunch (Socio-economic disadv.) • IEP/Sp. Ed. • Each group will do a short summary of their data at the end of the workshop.

  18. Subpopulation data for comparison • AYP requirements for 2010-2011 • Math = 73.41% prof/adv • Literacy = 75.70% prof/adv • AYP requirements for 2011 – 2012 • Math = 82.28% • Literacy = 83.80% Did we make it? What about subpopulations? How far do we have to go?

More Related