University Of San Diego

Education 580A

Computers for the Educator

Instructor:

Barry Sovel

Course Syllabus

Fall 2000

HOME
Portfolio/Final

Demonstration requirements

for more information or for suggestions, email the instructors.

For more information about Barry Sovel

This page last updated 27 August 2000

 

return to top of page

Course Syllabus

University of San Diego

Barry Sovel

EDUC. 580A

Fall 2000

September 21

Session #1

REGISTRATION/ INTRODUCTION

Saving and transferring Word files between Mac and PC

EMAIL:

student survey

lab rules & procedures

Intro to email; setting up an n2mail email account

HW: bring floppy disk; bring an idea you hope might be found on the Internet

September 28

Session #2

INTERNET I

Saving images to your desktop

 
Saving your files to floppy disk [Mac & PC]

Distribution of Final Demonstration activities

Using the Internet with Netscape

basic searches, advanced searches with simple Boolean logic, saving images and other files from the Internet

HW: begin thinking about a letter or lesson; bring any email addresses of friends and colleagues

October 5

Session #3

WORD PROCESSING I

USD.rtf

RULERS and TABS

 
Word Processing Techniques

More than a typewriter

  • simple editing
  • cut and paste
  • tabs and indents
  • tables
  • inserting images

HW: bring in some numeric data, such as test scores, grades, attendance, money, growth charts, etc

October 12

Session #4

SPREADSHEETS I


Spreadsheet basics

Spreadsheet applications for teachers

HW: practice and explore

October 19

Session #5

HYPERSTUDIO

 
HS basics (tutorial & materials provided)

Additional projects for advanced users

HW: bring in some numeric data, such as test scores, grades, attendance, money, growth charts, etc.

October 26

Session #6

INTERNET II

 
More Netscape
bookmark organization, creating Netscape documents, setting up portable webpages, exploring the EDIT functions

Using the Internet for simple Lesson creation

HW: bring in ideas for newsletters and special documents

November 2

Session #7

WORD PROCESSING II

 
Using Graphic elements in a Word processed document

More on Tables

HW: bring in at least 5 names with complete address info (street, city, state, zip, phone)

November 16

Session #8

DATABASE: DESIGN for

MAILMERGED documents

 
Database intro (using ClarisWorks)

DB applications for teachers

Mailmerge w/WP document (personalized form letters)

HW: bring portfolio artifacts that are already completed and your 'cover' materials

November 30

Session #9

PORTFOLIO PREPARATION

CLASS PRESENTATIONS

 

Work on your portfolio assignments

student show and share [first half of students]

HW: bring in completed Final Demonstration/Portfolio materials

December 7

Session #10

CLASS PRESENTATIONS

PORTFOLIOS DUE

course summary & wrap-up

student show and share [remaining students]

evaluation of course & instructors

return to top of page

Final Demonstration

[click here to download this page as a MS Word file]

In order to demonstrate your successful completion of this class, you will be expected to assemble a "portfolio" of your work. It will be due on or before the last class, December 7, 2000.

Plan to submit your work in two formats:

  • a printed copy
  • a clearly labeled copy on disk, in any major format available to you - e.g., Microsoft Works; Microsoft Office (Word, Excel); ClarisWorks; Word Perfect, etc.

    Please indicate whether it is for a Mac or a PC.

Required of all participants:

Five minute Show and Share:
pick at least one of your portfolio artifacts that demonstrates how you will connect technology to your curriculum and classroom

A cover page that includes, besides your name, course name and date,

  • a graphic or piece of clip art
  • at least two font sizes (one at 36 pt. or larger, and one at 18 pt. or smaller)
  • a "draw" element (box, line, arrow, shading/color fill, etc.)

an annotated Table of Contents, showing the assignment number, name, location [page # or filename] and a short description.

NOTE 1:

If, for some reason, you cannot submit your work on disk (due to lack of adequate access to the necessary hardware or software, for example), then you will need to attach to each document a separate page that specifically explains how you created that document (by identifying the settings, procedures, etc. that you used ).

NOTE 2:

For some items, it may not be possible/appropriate to present them in both formats. No problem. Just let us know, so we know where to look to find your work. The important thing is that you are able to demonstrate your competency, not attempt the ridiculous or the impossible.

Your portfolio must include at least 10 of the following 13 types of documents (or their equivalents - substitutions may be allowed at the discretion of the instructor)

Although many types of documents meet the requirements for more than one assignment, a single document can only be used to satisfy one assignment.

  

1. Computer terms:

A list of at least 20 terms, words, acronyms, etc., and a definition or description of each in "layman's" terms. The focus or purpose should be clear. Previous students' lists have included:
  • "20 computer terms every student should know"
  • "How to survive a trip to the computer store - an essential glossary"
  • "Computer hardware [or software] terminology"
  • "You know you're a computer nerd when you can understand these terms"
  • "Computer jargon - 20 new (to me) examples"
  • "Computerese - how to understand what our computer literate students are talking about"

2. Word Processing example

A Word processing document, in the form of a letter , lesson handout or a memo, demonstrating the use of two or more of the following formatting elements:
  • headers/footers
  • a live date
  • tabs and/or tables and/or multiple line settings
  • multiple margin, and/or indent settings (i.e., hanging indent, paragraph indent, bulleted list, etc.)
  • forced section or page break
  • two or more columns [without using tables]

3. A Spreadsheet document, of at least four columns and five rows, demonstrating use of

  • formulas
  • row and column titles
  • sorting
  • formatting (i.e., text size, style, justification, borders, shading, etc.)

4. A Text document with graphics

  • add multiple graphic objects to a word processed document OR
  • show more than one method of using a graphic on a word processed page, such as anchored vs. moveable

5. Expected Uses

Expected Uses of the material presented in this course: a list or description of at least three ways you can/will use your computer related skills and interests in your own classroom, with your students, or in other areas connected to your job. Database example

6. Create a mail merged document(s) from a database you create.

The database should contain at least 5 records and 4 fields
STRONGLY SUGGESTED (especially if this is a first effort): create a name & address file (of students, family & friends, etc.)&emdash;it will be useful later

7. Module integration

Create a document that uses two or more of the following program modules
[this cannot be fulfilled by using the cover sheet]:
Word Processing(WP), Spreadsheet (SS), Database (DB), Draw (DR), Paint (PT).

Some examples may include
  • a WP document with a SS or a graphic imported into a frame
  • a SS document with text imported from a WP file
  • a DB file transformed into a SS document (or vice versa)
  • a multimedia Hyperstudio stack
  • a html document [homepage] utilizing WP text and imported graphics

8. Basic Netscape Skills Demonstration:

Use Netscape to find three (or more) sites useful to you in your job; add an annotated review for each bookmark; and save them as a Netscape document. The annotation should explain why the site is useful, including the recommended grade level and/or subject focus.
NOTE: This document should only include only bookmarks that you have found.

9. Email:

  • Send an email to multiple recipients ( including to a-teacher@attbi.com with a CC. to yourself
  • Include in the body of your message a statement of how you could use email in your personal life; how you could use email with your students; and some other way, besides email, that you could use the Internet in your job or with your students

10. Complete and submit the HyperStudio Tutorial Project [on disk]

You need only print the first page; the rest may be submitted on disk.

11. Create your own HyperStudio project, including

  • at least five cards
  • same backgrounds on at least three cards
  • at least one example of scrollable text or a movie or some graphics

    You need only print the first page; the rest may be submitted on disk.

12. Internet lesson: Create a simple four to five question/step, linked Internet lesson that supports one of your favorite classroom lessons

  • it must include a full set of instructions
  • be grade appropriate
  • each question/step must utilize a "hot" link
  • it must be interactive (i.e., require some response/input/activity from the learner)

13. Create a STEP-BY-STEP lesson/instruction sheet for a computer related activity or skill

  • identify your intended audience
  • be sure to include what is needed to be able to complete the lesson

Remember, this portfolio is not a "test" - it is a demonstration of the type and range of computer skills you can use for job related purposes. Your project will be more meaningful to you if it is authentic, that is, if it actually does relate to the work you do. Keep this in mind as you develop your skills and your demonstration documents.