Educational Studies
Department
Professional Development Program
SYLLABUS
Course
Name:
Introduction
to computers and computing, problem solving, changes in technology, and the
impact of computers in our lives. Computer Fundamentals provides a working
knowledge of computers and Windows operating environment with an emphasis on
word processing, desktop publishing, spreadsheets, presentation, and web
editing software programs. This course designed to focus on student computing
needs.
Rationale:
Today
the average person depends on, is served by, or is
required to operate some form of a computer. From spreadsheets to web pages,
students need to build skills and understanding to succeed in the ever-growing
world of information technology. Knowledge of computers and computing is not
only necessary to assure future success but is necessary to solve everyday problems
and think critically. Students should be able to speak intelligently about
computers and computing technology and be prepared for
the changes computers will continue to bring into their lives.
Required
Text:
1.
Computers: Tools for an Information Age: Brief Edition by H.L. Capron
and J.A. Johnson
Recommended Texts:
1.
Microsoft PowerPoint 2002: Introductory
Concepts and Techniques by Shelly, Cashman, and Sebok
2.
Microsoft Word 2002: Introductory Concepts and Techniques by Shelly, Cashman, and Vermaat
3.
Microsoft Excel 2002: Introductory Concepts and Techniques by Shelly, Cashman, and Quasney
4.
Microsoft Publisher 2000: Introductory Concepts and Techniques by
Shelly, Cashman, and Starks
5.
Microsoft FrontPage 2002: Illustrated Brief by Jessica Evans
Course
Objectives and Standards:
After
completing this course, the student will be able to:
1.
Demonstrate personal computing skills via the use of electronic
communications, online databases, search tools, application (word processing,
desktop publishing, presentation graphics, spreadsheets, and
authoring/web-editing), and operating system software.
·
AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 1.2.b, 1.2.c, 1.4.a, 2.0.3, 2.07, 2.1.1, 2.1.2, 2.1.3, 2.1.4, 2.2.4, 2.3.2, 2.4.1, 2.4.4,
2.4.5
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.A, II.B, II.D,
II.E, II.F, III.A, III.B III.C, IV.A, IV.B, V.A, V.B, V.C, V.D, VI.A, VI.B,
VI.C, VI.E
2.
Describe the advantages, disadvantages and ethical considerations of
computer technology and the effect computers continue to have in our society.
·
AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 2.1.1, 2.1.2, 2.3.2
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.B, III.C, IV.B, V.A., V.C, VI.A, VI.B, VI.C, VI.E
3.
Develop instructional materials.
4.
Research and develop a standards-based training/teaching plan and original
learning aid.
5.
Classify and review online teaching materials.
Course
Contents:
·
Computer Basics (Hardware)
·
Computing Proficiency using Operating System and Application Software
(Windows, Microsoft Office, Publisher, and FrontPage)
·
Understanding Networks (Internet and Online Databases)
·
Computing Proficiency using Fundamental Services (Electronic Mail and
Browsers)
·
Introduction to the World Wide Web and the Internet (History, Current
Status)
·
Ethical Issues in Computing (Assistive Technologies, Privacy, Piracy)
·
Introductory Instructional Design Principles
Instructional
Strategies:
1.)
Lecture
2.)
Demonstration
3.)
Hands-On Activities
4.)
Situational Learning
5.)
Online Activities
6.)
Collaboration
7.)
Games
Assignments, Assessment and Standards:
1)
Quizzes: 30%
Three (3) quizzes: each worth 10%, administered online. Quizzes
to include t/f, multiple choice, short answer, and essay questions pertaining
to the textbook material. (10% x 3 = 30%)
·
AECT/ECIT Standards addressed: 1.1.3.b, 2.4.4
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, III.C, V.A, V.C,
VI.A
2)
PowerPoint Final Project: 12%
Research and create a slide presentation that
focuses “How Things Work” and includes interactivity into presentations in an
effort to check for learner understanding. Use of proper citations (MLA) is
required. In addition, perform research using online databases (ProQuest, ERIC, etc.) on use of presentation graphics
software in organizational settings. Present your research in a two-page paper
using MLA formatting guidelines.
·
AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 1.2.b, 1.2.c, 1.4.a,
2.0.3, 2.1.1, 2.1.3, 2.4.1
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.E, II.F, III.A,
III.C, IV.A, V.A, V.B, V.C, V.D, VI.A
3)
Word Final Project: 12%
Working in pairs, create your own ethical scenarios regarding computing and share with partner via e-mail. The response is to be evaluated according to your own ethical code. Follow MLA guidelines for formatting paper.
· AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 2.1.1, 2.1.2, 2.3.2, 2.4.7
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.B, III.C, IV.B, V.A., V.C, VI.A, VI.B, VI.C, VI.E
4)
Excel Final Project: 12%
a)
Choice 1: This project focuses on the concept of money as a measure of
value and a means of exchange. Create the following:
i)
Personal budget outlining your monthly expenses and income
ii)
Extrapolate this information into a year’s worth of expenses and income
iii)
Determine the future value of an eliminated expense (8% interest over 10
years)
iv)
Research the topic of web-based transactions (are they secure?) and
present your research in a two-page paper using MLA formatting guidelines.
b)
Choice 2: This project focuses on learning other methods of communication,
specifically ciphers, meaning, “hidden, of zero value, invisible.” Create the
following:
i)
A unique cipher (device used to create code and decode messages)
ii)
One activity demonstrating how the cipher works
iii)
Research the topic of web-based transactions (are they secure?) and
present your research in a two-page paper using MLA formatting guidelines.
5)
Publisher Final Project: 12%
This project focuses on the use of publications as
a method to disseminate information in organizational settings. Research the
topic of Assistive Technology or Digital Divide - and create a two-page
newsletter or a tri-fold brochure.
·
AECT/ECIT Standards addressed: 1.1.3.a, 1.2.c, 2.0.2, 2.1.1, 2.1.2, 2.3.2
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.A, II.B, II.D,
II.E, III.A, IV.B, V.A, V.C, V.D, VIB
6)
FrontPage Final Project: 12%
Publishing your own work is an essential component
to growth and development. This project focuses on the creation and publication
of your projects created this semester in a three-page web site, published on
the Seton Hall web server.
·
AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 2.0.2, 2.0.7, 2.1.1, 2.1.4,
2.2.4, 2.3.2, 2.4.1, 2.4.4, 2.4.5
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, III.C, V.A, V.C
7)
Training Plan: 20%
Design and develop a teaching/training plan for a topic of a content area (unit,
textbook chapter, etc) to demonstrate application of the principles and develop
two plans. Identify the group – age, level, etc. – taught.
Develop an original learning aid.
· AECT/ECIT Standards addressed: 1.1.3.a, 1.1.3.b, 1.3.a, 2.0.2, 2.1.1, 2.1.2, 2.1.3, 2.1.4, 2.3.2, 2.4.3
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.A, II.B, II.C, III.A, III.C, IV.A, IV.B, V.A, V.B, V.C
8)
Materials Review: 20%
Review five online teaching materials for a specific topic.
9)
Software Lesson and Demonstration: 10%
Working in groups of four, select a software program,
prepare, and teach a lesson to the other three group members.
·
AECT/ECIT Standards addressed: 1.1.1.a, 1.1.3.a, 1.1.3.b, 1.3.a, 2.0.2, 2.1.1, 2.1.2,
2.1.3
·
ISTE/NETS Foundation Standards addressed: I.A, I.B, II.A, III.A, III.C, V.A, V.C, VI.A
Course Recommendations:
· Students are expected to attend every scheduled session of this course. Unexcused absences will result in the lowering of the final grade.
· As scholars, you are required to give credit to any sources you consult while preparing your assignments. All materials from other sources, both quoted and paraphrased, must be cited in the text (if mentioned) as well as in your reference list. You may not use any portion of previously submitted research papers. Plagiarism in any form will not be tolerated.
· Under the Americans with Disabilities Act and Section 504 of the Civil Rights Restoration Act, students at Seton Hall University who have a disability may be eligible for accommodations in this course. Should a student require such accommodations, he or she MUST self identify at the Office for Disability Services (DSS) Room 67, Duffy Hall, provide documentation of said disability, and work with DSS to develop a plan for accommodation. The contact person is Mrs. Linda Walter at 973 313-6003.
Determination of Grade:
Quizzes (3)............................................................................................................... 30%
PowerPoint Final Project............................................................................................ 12%
Word Final Project..................................................................................................... 12%
Excel Final Project.................................................................................................... 12%
Publisher Final Project............................................................................................... 12%
FrontPage Final Project.............................................................................................. 12%
Teaching Plan and Learning
Aid.................................................................................. 20%
Materials Review........................................................................................................ 20%
Software Lesson and
Demonstration............................................................................ 10%
Bibliography:
Ageloff, R., Oja, D., &
Carey, P. (2001). New perspectives on Microsoft Excel 2002. Course Technology, Inc.
Andersen,
V. (2001). How to do everything with Access 2002. The McGraw-Hill Companies.
Barber, M. & Grauer,
R.T. (2002) Exploring PowerPoint 2002. Pearson Education.
Bitter, G. G. &
Pierson, M. (2001). Using technology in
the classroom (5th ed.).
Pearson Education.
Bitter, G.G. &
Pierson, M.E. (2002). Using technology in the classroom. Boston, MA:
Allyn & Bacon.
Brown, M. & Edmonds, T.K. (2002). Essential
FrontPage 2002 for Web professionals.
Pearson Education.
Callahan, E. (2001). Microsoft
Access 2002: Visual basics for
applications step by step. Microsoft
Press.
Feddema, H. (2001). Microsoft
Access version 2002 inside out.
Microsoft Press.
Frye, C. (2001). Microsoft
Access version 2002 plain and simple.
Microsoft Press.
Frye, C. (2001). Microsoft
Excel version 2002 plain and simple.
Microsoft Press.
Frye, C. (2001). Microsoft
Excel version 2002: Step by step with CD-ROM. Microsoft Press.
Gordon, D. T. (2000). Digital
classroom: How technology is changing
the way we teach and learn. Harvard
Education Publishing Group.
Heinich,
R., Russel, J. D., Molenda,
M., & Smaldino, S.E. (2001). Instructional
media and technologies for learning.
Pearson Education.
Howell, D., Howell, D, Morrow, J., Sequin, A.,
Summerville, J. (2002). Using PowerPoint in the classroom.
Corwin Press, Inc.
Ivens, K. & Carlberg,
C. (2001). Excel 2002: The complete reference.
The McGraw-Hill Companies.
Jacobson, R. (2001). Microsoft Excel 2002: Visual basic for
applications step by step. Microsoft Press.
Joyce, J.
& Moon, M. (2001). Microsoft Word version 2002 plain and simple. Microsoft Press.
Maran, R. (2002). Word
2002 simplified. John Wiley &
Sons, Inc.
Millhollon, M. & Poor, A. (2001). Microsoft
Word version 2002 inside-out. Microsoft Press.
Napier, H.A., Rivers, O., &
Judd, P. J. (2001). Mastering and using Microsoft Word 2002: Comprehensive course. Course Technology, Inc.
Nelson, S. L. (2001). Excel
2002 from A to Z: A quick reference to
more than 300 Microsoft Excel tasks, terms, and tricks. Redmond Technology Press.
Nelson, S. L. (2001). Word 2002 from a to Z: A quick
reference of more than 300 Microsoft Word tasks, terms and tricks. Redmond Technology Press.
Nelson, S.L. (2001). PowerPoint
2002 from A to Z. Redmond Technology
Press.
Norton, P. & Sprague D. (2001). Technology
for teaching. Boston, MA: Allyn and Bacon.
Perspection, Inc. (2001). Microsoft
Word version 2002 step-by-step. Microsoft
Press.
Robinson, C. & Simpson, A.
(2001). Mastering Access 2002 premium
edition. Sybex,
Inc.
Shelly, B., Cashman,
T. J., & Vermaat, M. E. (2001). Microsoft
Word 2002: Complete concepts and
techniques. Course Technology, Inc.
Shelly, G. B., Cashman, T. J., & Mick, M.L. (2002). PowerPoint
2002: Complete concepts and techniques.
Boston, MA: Course Technology.
Shelly, G. B., Cashman,
T. J., & Quasney, J. S. (2001). Microsoft
Excel 2002 comprehensive concepts and techniques. Course Technology, Inc.
Shelly, G. B., Cashman, T. J., & Starks, J. (2001). Microsoft
Publisher 2002: Complete concepts and
techniques. Course Technology, Inc.
Shelly, G. B., Cashman, T. J., & Starks, J. (2001). Microsoft
Publisher 2002: Introducory
concepts and techniques. Course
Technology, Inc.
Weverka, P. & Poremsky,
D. (2001). Word 2002: The complete
reference. The McGraw-Hill Companies.