Educational Technology I:
Productivity Tools

Summer Session, 1997

Course number: EDDV 186
Credits: 1 credit

Instructor: Gary A. Feurer
Room WHL 301B
Phone: 831-2751
email: feurer@udel.edu
Office Hours: 3:00-5:00, Mon. and Wed.
Description || Texts || Requirements || Assignments || Teams 

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, 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; hacking 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 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, graded computer-based lab activities related to class lectures and laboratory experiences. Each activity is due at the time of the class meeting, but may be handed in up to one week late without penalty.

      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:

        Work submitted on paper must have your name printed (not hand-written) in the upper left-hand corner. This should be followed by your section number and the assignment identifier.

        Work submitted electronically should be put on the MAC volume of the ITC file server, which you have access to 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 6th class meeting.
    4. Final exam.

Click Here for Grading Formula

Topics and Assignments

 
Choose a session.
Week 1
Monday
Wednedsay
Week 2
Monday
Wednedsay
Week 3
Monday
Wednedsay
Week 4
Monday
Wednedsay
Week 5
Monday
Wednedsay

Week 1: Basic Tools and Issues

1. Fundamental concepts of computing: hardware,software and data.
E-mail and the World Wide Web.

2. The MAC operating system and introduction to ClarisWorks.
Saving and retrieving files.

Week 2: Word Processing

1. Word Processing I.
Formatting a document: margins, tabs, fonts, headers, footers.
Power tools: cut, copy, paste, find, spell check, thesaurus, footnotes, columns.

2. Word processing II.
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 3: Graphics Programs

1. Graphics I.
Using the ClarisWorks drawing programs. The basic drawing tools. Selecting, copying and pasting. Grouping objects.

Graphics II.
Using the ClarisWorks paint programs. The differences between drawing and painting.

Week 4: Spreadsheets

1. Fundamental concepts of spreadsheets.Opening and saving a spreadsheet. Moving around a spreadsheet. Using formulas and functions for calculations. Printing.

2. Spreadsheets II.
Types of data and formatting the contents of cells. Relative and absolute copying. Inserting rows and columns.

Week 5: Database Management Programs

1. Database management programs I.
Introduction to database management programs. Fields and records. Planning a database. Creating a database, adding records, and saving to disk.

2. 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

Team Assignments