1 / 33

Chapter 5 Administrative Software

Learn about the different types of administrative software that can assist educators in accomplishing tasks such as word processing, spreadsheet management, database organization, and presentation creation. Explore the advantages and features of each software category and discover how they can be applied in teaching and learning.

theresav
Download Presentation

Chapter 5 Administrative Software

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. Chapter 5Administrative Software Teaching and Learning With Technology, 3e

  2. Educator Computer Competencies • Step One • Ability to use computer hardware in teaching and learning • Step Two • Ability to identify, evaluate, and apply computer software to teaching and learning

  3. Computer Software Categories • Administrative Software • Software that assists an educator in accomplishing administrative, professional, and management tasks • Academic Software • Software that assists both educators and learners in the teaching and learning process itself

  4. Types of Administrative Software • Productivity Software • Word processing • Spreadsheet • Database management software • Presentation software • Classroom Management Support Software • Customized • Manage school and classroom tasks

  5. Obtaining Administrative Software • Commercial package • Freeware • Offered to users without cost • Shareware • Offered to users for a small fee or for a limited time. • All types must be carefully evaluated

  6. Productivity Software • Word processors • Electronic spreadsheets • Database management systems • Presentation software

  7. Word Processors • Most commonly used application • Functions include • Document preparation and editing • Desktop publishing • Archiving and printing • Microsoft Word one of most popular

  8. Document Preparation and Editing • Insertion and Deletion of Text • Text Selection and Enhancement • Word Wrap and Formatting • Spelling and Grammar Tools • Copy, Cut, Past, Drag and Undo

  9. Desktop Publishing • WYSIWYG Displays • Graphics and Clip Art • Tables and Columns • Autoformats • Word Art

  10. Archiving and Printing • Ability to • Save the document in numerous formats • Print it out in black and white or color • Archive or store a document to a floppy or hard disk • Stores the text • All its formatting commands • Exporting a document • “Save as” in choice of formats

  11. Ready-Made Word-Processing Tools • Templates • Documents that are preformatted for a specific use but contain no data • Macro • Prerecorded set of commands • Automates a complex task • Example: Labels • Wizards • Miniprograms that create customized templates

  12. Word Processors in the Classroom • Table 5.3 on page 177-178 • Word Processing in Teaching and Learning • Summarizes educational applications of word-processing features

  13. Electronic Spreadsheets • Advantages • Accuracy • Given accurate data, will always produce accurate results • Can be modified easily • New or modified entries are automatically recalculated • Microsoft Excel is an example

  14. Spreadsheet Organization • Data in vertical columns and horizontal rows • Intersections of rows and columns called cells • Cells can perform mathematical calculations

  15. Formulas and Functions • User-entered formulas • Stored, premade formulas • Finance and statistics • Trigonometry

  16. What-If Analysis • Example • Teacher uses spreadsheet for grades • Student data entered • Formula for averaging grades • Can add a hypothetical grade • Computes the resulting final grade

  17. Charts and Graphs • Turn data into its graphic counterpart • For selected cells • Information turned into accurate graph • Formats include line, bar and pie chart • Some allow graphing in color and three-dimensional shapes

  18. Templates and Macros • Like word-processing software • Create and reuse useful formats • Some can be found as shareware or freeware • Create your own spreadsheet templates

  19. Spreadsheets in the Classroom • Table 5.4 on page 182. • Lists examples of teaching and learning applications for each of the spreadsheet features.

  20. Database Management Software • Ease-to-use system for • Creating customized records to contain data • Retrieving targeted records • Updating and editing information • Organizing reports from the data • Sorting all data at the touch of a key • Example: Electronic card catalog

  21. Database Organization • A FIELD is an electronic storage location as in a Last Name field • A RECORD is a collection of related fields as the record for one book • A FILE is a collection of related records such as all the books in the library

  22. Sorting • Records can be sorted by data in one or multiple fields • Arranges all records into ascending or descending order based on • Alphabetic characters • Numeric characters

  23. Querying • Ability to find a single item • Software looks for and matches targeted criteria • In the Library example, it could be a specific author’s name

  24. Reports • Templates built into the software • Allows you to print the results of specific queries • Allows you to print only the most pertinent information from the database

  25. Database in the Classroom • Table 5.5 on page 185 • Charts examples of the teaching and learning applications for each of the database features

  26. Presentation Software • Programs to create digital support materials for oral presentations • Prearranged group of electronic slides • Displayed on monitors or screen • Typically proceed in linear sequence • Nonlinear, hyperlink-driven sequencing possible

  27. Presentation Capabilities • Multimedia Elements • Text, graphics, animation, sound, video • Wizards and Templates • Built-in wizards and slide templates • Resource Libraries • Clip art, animation, sound and video

  28. Presentation Capabilities • Hyperlinks • Hyperjump to out-of-sequence slides, other slide shows or other software • Animation • Printing • Outline, speaker’s notes, audience handouts (one to six slides per page) • Display Options • Timed, self-playing

  29. Presentation Software in Classroom • Helps students organize their thoughts into chunks • Critical thinking applied to review and identify key elements • Students gain experience with multimedia-type software • Table 5.6 on page 190 for examples of educational applications

  30. Integrated Productivity Packages • Word processing, spreadsheets and database management in one • Include many but not all capabilities • More economical purchase for school • Microsoft Works is an example

  31. Management Support Software • Web-enhanced districtwide software • Enter and track student data • Accessible to parents • Classroom level • Student rolls • Grading functions • Seating charts • Attendance

  32. Portfolio Assessment Software • Organization by Standards and Competencies • Observations • Multimedia Samples • Customization • Hyperlinks • Links to navigate the portfolio

  33. Evaluating Software • Table 5.7 Productivity Software Evaluation Rubric p. 193 • Table 5.8 Classroom Management Software Evaluation Rubric p. 199 • Evaluations based on installation instructions, site licensing, tech support, updates, tutorials, platforms, report capabilities, hardware capabilities, cost. • Use technology money wisely

More Related