| Norwell Public Schools | |||||||||||||||
| Technology Skills and Concepts | |||||||||||||||
| Scope and Sequence | |||||||||||||||
| 3.0 Spreadsheet / Database | K | 1 | 2 | 3 | 4 | 5 | 6 | 7 | 8 | 9 | 10 | 11 | 12 | ||
| The Graph Club | |||||||||||||||
| Max Count (Scholastic Keys) | |||||||||||||||
| Excel | |||||||||||||||
| Spreadsheet Skills | |||||||||||||||
| 3.01 Understand terminology | B | B | B | B | B | D | S | S | S | S | S | S | S | ||
| 3.01.1 Spreadsheet, Document, Workbook, Sheet | B | D | D | D | S | S | S | S | S | S | |||||
| 3.01.2 Cell, Column, Row, Value, Label | B | D | D | D | S | S | S | S | S | S | |||||
| 3.01.3 Chart, Graph, Bar, Pie, Series, Axis, Labels, Title | B | B | B | B | B | D | S | S | S | S | S | S | S | ||
| 3.01.4 Formulas, Functions, Sum, Average, Sort, Find, Default | B | D | D | S | S | S | S | ||||||||
| 3.02 Function and Purpose of spreadsheet | B | D | D | D | S | S | S | S | S | S | |||||
| 3.03 Enter data into cells / sheet | B | D | D | D | S | S | S | S | S | S | |||||
| 3.04 Create charts (graphs): Bar, Pie: Include labeled axis, Title | B | B | B | B | B | D | D | S | S | S | S | S | S | ||
| 3.05 Format | B | D | D | S | S | S | S | S | S | ||||||
| 30.5.1 Cell formats: Font, Size, Alignment, Number ($), Border | B | D | D | S | S | S | S | S | S | ||||||
| 3.05.2 Sheet formats: Row height, column width, alignment | B | D | S | S | S | S | S | S | |||||||
| 3.05.3 Print formats: Page Orientation, Margins | B | D | D | S | S | S | S | S | S | ||||||
| 3.05.4 Cells: Advanced number, Advanced border, Protection | B | D | S | S | S | S | |||||||||
| 3.05.5 Charts: Colors, Font, Size, Scale | B | D | D | S | S | S | S | S | |||||||
| 3.05.6 Insert images, Citation | B | D | S | S | S | S | S | S | |||||||
| 3.06 Copy & Paste: Click and Drag, Auto fill | B | D | S | S | S | S | S | ||||||||
| 3.07 Copy & Paste: Cell to Cell, Document to Document | B | D | S | S | S | S | S | ||||||||
| 3.08 Create charts (graphs): Line, XY, Scatter | B | D | D | S | S | ||||||||||
| 3.09 Spreadsheet/table design: Rows, Columns: Insert, Delete, Reposition | B | B | D | D | S | S | S | S | S | ||||||
| 3.10 Sort, Filter, Find | B | D | D | S | S | S | S | ||||||||
| 3.11 Functions: Average, Sum, etc. | B | D | D | S | S | S | S | ||||||||
| 3.12 Write and use formulas | B | D | D | S | S | S | S | ||||||||
| Excel (as database application) | |||||||||||||||
| Access | |||||||||||||||
| Database Skills | |||||||||||||||
| 3.13 Understand terminology | B | D | S | S | S | S | S | ||||||||
| 3.13.1 Database, Field, Record, Report, Field properties | B | D | S | S | S | S | S | ||||||||
| 3.13.2 Browse, Sort, Search, Delete, Data | B | D | S | S | S | S | S | ||||||||
| 3.14 Function and Purpose of a database | B | D | S | S | S | S | S | ||||||||
| 3.15 Create records: Entering info / data | B | D | D | S | S | S | S | ||||||||
| 3.16 Create fields, Properties | B | D | D | S | S | S | |||||||||
| 3.17 Auto Fill fields | B | D | S | S | S | ||||||||||
| 3.18 Create reports: Sort, Organize, Filter | B | D | D | S | S | S | S | ||||||||
| 3.19 Import / Export data | B | D | D | S | |||||||||||
| 3.20 Link between databases | B | D | D | S | |||||||||||
| 3.21 Format | B | D | D | S | S | S | S | ||||||||
| 3.21.1 Report format | B | D | D | S | S | S | S | ||||||||
| 3.21.2 Print, Print Preview, Print formats | B | D | S | S | S | S | S | ||||||||
| 3.21.3 Create Headers & Footers | B | D | S | S | S | ||||||||||
| Tools, Software or other technologies | |||||||||||||||
| Cruncher | |||||||||||||||
| Data Studio and probe ware | |||||||||||||||
| Winnebago Library Database | |||||||||||||||
| Web based databases | |||||||||||||||
| Create A Graph web site | |||||||||||||||
| http://nces.ed.gov/nceskids/graphing/index.asp | |||||||||||||||
| Graphing Calculators | |||||||||||||||
| B = Beginning Skills | |||||||||||||||
| D = Developing Skills | |||||||||||||||
| S = Secure Skills | |||||||||||||||