Chapter 4 Teaching with the Basic Three Software

Chapter 4 Teaching with the Basic Three Software Tools: Word Processing, Spreadsheet, and Database Programs M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved.

Technology Integration Example: Money Management with Spreadsheets • Phase 1: Relative advantage • Phase 2: Objectives and Assessments • Phase 3: Integration Strategies • Phase 4: Instructional Environment • Phase 5: Evaluating and Revising M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 2

Why Use Software Tools? • Improved Productivity • Improved Appearance • Improved Accuracy • More Support for Interaction M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 3

The Three Basic Productivity Tools Word Processing Databases M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Spreadsheets 4. 4

Recent Developments • PDA tools • Web-enabled features • Better file-exchange compatibility – Cross platform • Software suites and integrated packages M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 5

Word Processing Definition • Documents as a stream of text on a computer Characteristics • Text • Graphics • Placement on page Desktop publishing • Individual pages M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 6

Word Processing Research • Improves writing • Improves attitudes toward writing • More revising • Increased sharing and feedback M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Issues • When to introduce • Keyboarding skills • Effects on handwriting • Impact on assessment 4. 7

Word Processing Educational Impact for Teachers • Saves time • Better appearance • Document sharing M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Integration Strategies • Support the learning of the writing process • Dynamic group product approach • Individual language, writing, and reading exercises • Encouraging writing across the curriculum 4. 8

Word Processing Recommended strategies for teaching word processing • Demonstrate basics • Assign individual practice • Demonstrate formatting features • Assign more individual practice • Demonstrate procedures with new files • Assign more individual practice M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 9

Spreadsheets Definition • Programs designed to organize and manipulate numerical data • The program • The product M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Characteristics • Information in columns and rows • Calculations • Data manipulation • Charting 4. 10

Spreadsheets Research • Useful tools – Problem solving – Statistical analysis Issues • Spreadsheets versus grade book packages – Flexibility – Setup M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 11

Spreadsheets in the Classroom Teacher Productivity • Grade keeping • Budgets • Attendance charts • Performance assessment checklists M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Instructional Activities • Demonstrations • Student products • Support for problem solving • Storing and analyzing data • Projecting grades 4. 12

Spreadsheets Recommended strategies for teaching spreadsheet skills • Demonstrate basics • Assign individual practice • Demonstrate formulas and formatting features • Assign more individual practice M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 13

Databases Definition • Programs that allow users to store, organize, and manipulate information (both text and numerical data) • Program • Product M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Characteristics • Files • Fields • Records • Store and update data • Queries • Reports • Formulas 4. 14

Databases Research Issues • Acquire useful skills in searching and using information • Useful in inquiry and problem solving skills • Increase teacher skills with lesson design • Simplified access versus privacy • Coping with information overload M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 15

Databases Teacher Productivity • Reduces data redundancy • Saving time locating and/or updating information • Data comparisons • Reveals relationships among data M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. Instructional Activities • Research and study skills • Organizational skills • Create profiles (information pictures) • Posing and testing hypotheses • Research/search information 4. 16

Databases Recommended strategies for teaching databases • Demonstrate basics • Assign individual practice • Demonstrate database creation and use • Assign more individual practice M. D. Roblyer Integrating Educational Technology into Teaching, 4/E Copyright © 2006 by Pearson Education, Inc. Upper Saddle River, New Jersey 07458 All rights reserved. 4. 17