EssentialsWorksheetsData

Version:1.0 StartHTML:0000000173 EndHTML:0000028912 StartFragment:0000002641 EndFragment:0000028876 SourceURL:file://localhost/Users/paulingm/Desktop/Spreadsheets.doc Science and Technology: 3.6.10.B, 3.7.10.D Mathematics: 2.6.8.A, 2.6.8.F Career Education and Work: 13.3.8.E Reading, Writing, Speaking and Listening: 1.6.8.F, 1.1.8.E, 1.1.8.F, 1.4.8.B || 3c, 3d, 4c, 6a, 6b, 6c, 6d || Spreadsheets are used to create graphic representations of data for analysis. || How can students calculate, recalculate and organize data? How can students use spreadsheets to efficiently manage/sort text & data? How can students extract information from a spreadsheet? What are some basic functions found in a spreadsheet program? How can a spreadsheet be formatted to make the information more readable? How can students choose the most effective application for manipulating and/or displaying data? How can students choose the correct graphic chart to display data? || Multiple student created projects || Vocabulary quiz Screen shot quiz Chart quiz || Saved file Printed document Teacher Observation Student participation || Self reflection Self assess rubric || Entering, sorting, formatting and organization of data. How to filter and export data. Auto Sum function and other basic functions. Utilization of color, shading and grid lines Different applications are better suited for specific outcomes Different graphs are better suited for specific outcomes || Enter data into a cell. Navigate from cell to cell by using arrow key, tab and enter keys. Navigation between worksheets in a book using sheet tabs. Format data using format menu/banner to correct identify the data type (currency, time, text, date, general number, Labels vs Values, apostrophe). Sort data ascending and descending by outside column or by specific column (custom sort). Labeling column headings and row headings. Utilize filter to view selected data from a worksheet. To export selected columns of data for use in other applications. Use AutoSum for adding a column or row of numbers. Use Functions such as AVG, MIN, MAX to calculate average, minimum, maximum values for a range of data. Format a worksheet using font color, borderline color, style and shading (background cell color). Demonstrate selecting data for charts and choosing appropriate style of chart. || Teacher Demonstrated Teacher Directed Independent Self Learning Student Exploration ** || Book: iWork '09: Keynote, Pages and Number by Richard Harrington Software: Open office, Microsoft Excel, Numbers Online Tutorials Teacher prepared materials || Student IEP and 504 plans will be followed. Modified rubrics and requirements. Extended time allowance. || Student GIEP plans will be followed. Instruction will be differentiated for students who have demonstrated mastery of content. Teacher approved independent project. ||
 * **Grade 8** || **Classroom 2.0** ||
 * || **Goal Area: Data/Spreadsheets** ||
 * || **Pennsylvania Academic Standards**:
 * || **ISTE Standards:**
 * || **Essential Understandings:**
 * || **Overarching and Essential Questions:**
 * || **Vocabulary:** cell, column, row, formula, function, sum, average, autosum, formula bar, main box, address, chart, range, sort, ascending, descending, gridlines, print area, header row, value, label, worksheet, template, wrap, merge ||
 * || **Assessments: Performance Tasks, Projects**
 * || =Assessments: Quizzes, Tests and Academic Prompts=
 * || **Assessments: Other Evidence (e.g., observations, work samples, dialogues)**
 * || =Assessments: Student Self-Assessment=
 * || **Students will need to know . . . (targeted understandings):**
 * || **Students will be able to do . . . (targeted skills):**
 * || **Teaching and learning experiences:
 * || **Materials and Resources:**
 * || **Accommodations:**
 * || **Enrichments:**
 * || **Time:** Approximately 10 class periods ||