Educational Technology I:
Productivity Tools

Fall Semester, 1997

Course number: EDDV 186
Credits: 1 credit

Instructor: Gary A. Feurer
Room WHL 301B
Phone: 831-2751
email: feurer@udel.edu
Office Hours:
   Mon. 9:00-10:00, 11:00-1:00
   Tues. 9:00-11:00
Description || Texts || Requirements || Assignments || Teams || Addresses 

Description

Intended for students in the freshman or sophomore year of the Elementary Teacher Education program, this course provides a grounding in basic computing concepts and the personal productivity tools generally available to users of personal computers with a connection to the outside world. Students will learn to use electronic mail, word processing, draw and paint programs, databases, and spreadsheets. Readings, discussions, and a written assignment will cover some of the social and ethical issues raised by computing and computer-mediated communication: equitable access to resources; intellectual property and copyright; cracking and computer theft; and the preservation and invasion of privacy in electronic documents.

Texts

Requirements

In addition to attending class, students are expected to complete weekly reading assignments in preparation for each class meeting, and, for most weeks, a computer-based laboratory activity building on the lecture. Lab activities are to be completed before the next week's class. The course grade will be based on the following:
    1. Graded laboratory activities. Throughout the semester there will be regularly assigned, gradedcomputer-based lab activities related to class lectures and laboratory experiences. Each activity is due at the next class meeting.
        2. Work for these assignments is to be done on a individual basis, not in groups or in collaboration with another person. Sharing work on the lab assignments is a form of academic dishonesty.


        Procedures for turning in work:

        To Submit work on paper: 
        Have your name computer-printed (not hand-written) in the upper left-hand corner. This should be followed by your section number and the assignment identifier.

        To submit work electronically:
        Find the MAC volume of the ITC file server, to which you have access in the computer classrooms in WHL 203-I and WHL 309.
        Put your homework on this path:

        MAC: Ed Tech I: Homework: [Your section number]
         

        Name the file using your last name, a comma, then your first name, then the assignment identifier. All this will be demonstrated in class.

    2. Report. You and one or two team members will be assigned a reading about the ethical and societal issues posed by information technology. These readings are on reserve in the Education Resource Center on the first floor of the Willard Hall Education Building. Some readings are on-line and will be accessed via the World Wide Web. Your team will write a 500-word summary of the article, e-mail it to the instructor and your classmates, and lead a short (5- to 10-minute) class discussion about the issue(s) addressed. Each team will be assigned a class meeting during which it will present its report. The appendix to this syllabus explains the details of how this process is to work. Click Here for Teams.
    3. Mid-Term Exam. A short exam will be administered during the 7th class meeting.  (vocabulary list)
    4. Final exam.  (supplementary vocabulary list)

Click Here for Grading Formula

Back to the top

Topics and Assignments

Choose a week.
1
2
3
4
5
6
7
8
9
10
11
12
13

Class Meeting Schedule

Weeks 1 - 3: Basic Tools and Issues

1. (Sept. 8, 9) Fundamental concepts of computing: hardware, software, and data.

2. (Sept. 15, 16) E-mail and the World Wide Web.
Introduction to Claris works. Saving and retrieving documents.

3. (Sept. 22, 23) The MAC operating system and introduction to ClarisWorks.
Saving and retrieving files.

Weeks 4 - 6: Word Processing

4. (Sept. 29, 30) Word Processing I.
Formatting a document: margins, tabs, fonts, headers, footers.

5. (Oct. 6, 7) Word Processing II.
Power tools: cut, copy, paste, find, spell check, thesaurus, footnotes, columns.

6. (Oct. 13, 14) Word processing III.
Importing graphics. Importing unformatted text. Hidden characters. Finding and replacing hidden characters.

To “hand in” your homework electronically, follow the instructions on page two of this syllabus. Use the assignment identifier “WP3.” In other words, if your name is Stacey Higgins, your file name will be “Higgins Stacey WP3.”

Week 7

7. (Oct. 27, 28) Mid-term Exam.

Weeks 8- 9: Graphics Programs

8. (Nov. 3, 4) Graphics programs I.
Using the ClarisWorks drawing program. The basic drawing tools. Selecting, copying and pasting. Grouping objects.

9. (Nov. 10, 11) Graphics programs II.
Using the ClarisWorks paint programs. The differences between drawing and painting.

Weeks 10 - 11: Spreadsheets

10. (Nov. 17, 18) Spreadsheets I.
Fundamental concepts of spreadsheets.  Opening and saving a spreadsheet. Moving around a spreadsheet. Using formulas and functions for calculations. Printing.

11. (Nov. 24, 25) Spreadsheets II.
Types of data and formatting the contents of cells. Relative and absolute copying. Inserting rows and columns.


Weeks 12 - 13: Database Management Programs

12. (Dec. 1, 2) Database management programs I.
Introduction to database management programs. Fields and records. Planning a database. Creating a database, adding records, and saving to disk.



13. (Dec. 8, 9) Database management programs II.
Querying a database. Sorting records Designing layouts and labels.

Appendix: Topics for Student Reports

Students will work in teams of two or three. Each team is responsible for reading one from a list of articles to be distributed at the first class meeting and reporting on it to the class. Each team will prepare a 500 word summary of the article or chapter read and send it to all members of the class and the instructor by E-mail at least two days before the class meeting on which your team will present. You should also prepare a printed, word-processed version of your summary that is handed in to your instructor. All team members are expected to attend and to have something to say if called upon. All class members are expected to have read the report of the week before coming to class and should be prepared to participate in the class discussion.

Reading List

Signup for Report

Team Assignments

Back to the top