CpSc 110, Computer Concepts

Syllabus: Fall, 2009

Dr. Conlon


For a printable version of this syllabus, click here.


Catalog Description: A computer literacy course stressing the use of applications software on personal computers. It covers a survey of computers and their impact on society and the use of word processing software. Other application software is also covered, such as spreadsheets and database software, but the particular applications examined may vary from section to section. (3 credits)


Class Meetings:

Section

Days

Period

Time

Room

2

TR

C

11:00 a.m.-12:15 p.m.

ATS 129



Instructor

Phone

Email

Office

Michael P. Conlon, Ph.D.

724-738-2143

michael.conlon@sru.edu

ATS 252


Office hours: MW 2:00-3:45 p.m., R 3:30-5:00 p.m., or by appointment.


Office hours are for you. Please feel free to visit me to discuss any problems. Do not wait until problems become unmanageable. If I am doing other work during my office hours, I will gladly drop what I am doing to help you. If my office hours are inconvenient, see me before or after class and we will find a better time to meet.


Texts: Introductory Go! Technology in Action, Sixth Edition, by Evans et. al., ISBN #0-13-245261-8, and Go! Office 2003, Third Edition, by Gaskin et. al., ISBN #0-13-505923-2. These books are available shrink-wrapped together under ISBN #0-13-508988-0. Be sure to get the CD-ROM with Go! Office 2003.


Supplies: You will need a USB flash-memory stick for saving files. Be sure to put your name on it!


Grading Policy: To pass you must take all exams, submit all assignments, and earn a passing grade. Late assignments will receive a grade of zero, but nonetheless must be submitted for you to pass. No late assignment will be accepted once the last week of classes has begun. No assignment will be accepted after the last class of the semester. Of course, exceptions will be made in extraordinary circumstances.


Lab Policy: You are expected to use lab time fully. You will be penalized for wasting time in lab. If you finish early, experiment with class software (Windows, Word, Excel, Audacity, and PowerPoint), re-do sections of your workbook which you don't know very well, or do assignments from other courses that require Microsoft Office. If you don't finish your lab assignment during lab time, you are expected to complete it on your own time.

Lab printouts are normally due at the beginning of the subsequent lab class. All projects from a single lab date must be stapled together in numerical order or they will not be accepted. Labs are graded as correct or unacceptable. Unacceptable labs will need to be corrected and resubmitted. There will be a ten-point penalty for each extra day or fraction it takes for you to submit a correct lab. Do not delay printing and stapling your lab until the beginning of class, or you risk a lateness penalty.


Important dates:


Exam 1

Exam 2

Exam 3

Final

Section 1

Sep 24

Oct 20

Nov 24

Tue, Dec 15, 10:30 a.m.-12:30 p.m.


Grading:

Projects

Lab Work

Class Exams

Final Exam

Attendance, etc.

30%

15%

30%

15%

10%


Email: I will occasionally communicate with the class via electronic mail. Assignments may be announced this way. You are responsible for checking your SRU email regularly.

Attendance, reading, and participation: Please do all assigned reading before the class in which it is covered. You are expected to attend and participate in class, and you must do the reading to participate intelligently. You are expected to learn the material in the texts, much of which will not be covered explicitly in lectures. Do not expect me to reiterate your textbooks. I will take attendance, and you will be penalized for poor attendance. In addition, since exams will contain much material not from the texts, you cannot do well on exams if you miss classes. If you must be absent for an examination, please see me one week in advance to make alternate arrangements to take the exam.


Plagiarism policy: Plagiarizers will receive a failing grade for the course. I encourage cooperation in study and in learning how to do the computer assignments, but ensure that all assignments are ultimately your own work. A computer assignment is "your own work" if you had a major part in creating it, you have typed it completely by yourself, you have learned enough in doing it that you could do a similar project without assistance from other persons, and it is substantially different from other people's projects. If you submit a project which is more-than-typically the same as someone else's project, you will receive an F or WF for the course.


Electronic Devices Policy: No electronic communication, computation, or entertainment devices may be used in exams. Cell phones must be turned off during exams, and placed under your seat or in your backpack. Use of electronic entertainment devices during lecture and lab time is inappropriate.


Course Philosophy: While a large portion of this course is dedicated to training in computer application programs, it is important to realize that training in specific computer applications is of only ephemeral value. Next year, or next month, newer versions of these applications may be released, or competing programs may supersede them in the marketplace, rendering your training largely obsolete. Rather, it is the purpose of this course to teach you the principles of computing, and principles do not change very rapidly. We use the applications somewhat for their immediate utility, but primarily as examples of these general principles. Armed with knowledge of these principles of computing, you will be more able to adapt to the changes in the technology so that what you learned in this course will still be of significant value to you when these applications are a distant memory. Please understand that the material covered in lecture classes is, in the long term, more important than what is covered in lab.


Course Outcomes: This course and its outcomes support the Information Systems Learning Outcomes of Problem Solving and Critical Thinking (PS&CT), Communication and Interpersonal Skills (C&IS), and Ethical and Professional Responsibilities (E&PR). These Information Systems Learning Outcomes are tied directly to the University Wide Outcomes of Critical Thinking and Problem Solving, Communication, and Values and Ethics.

Course Objectives

Departmental Learning Outcomes

The student will be able to:

  1. Define or identify terms and concepts as they are commonly used in the field of computers. [PS&CT e; C&IS a, b, d, e]

  2. Maintain files using at least one operating system and/or operating environment. [PS&CT e]

  3. Demonstrate the use of fundamental concepts of various software packages such as word processing, spreadsheet, and database. [PS&CT c; C&IS b]

Problem Solving and Critical Thinking.

Solve abstractand complex problems using software design methodology. Make informed choices among alternative solutions.

Communication and Interpersonal Skills.

Use written, oral and electronic methods for effective communication.



Calendar (tentative)

Date

Subject

Reading

Sep

1

Why Computers Matter

TIA Ch. 1


3

Lab. Logging in; Windows and Widgets







8

Computer History, Looking at Computers

TIA pp. 36-47; Ch. 2


10

Lab. Application TBA.







15

The Internet

TIA Ch. 3


17

Lab. Word Introduction

Go, Ch. 5






22

Information Technology Ethics

TIA pp. 144-163


24

Exam 1. Lab. Word Formatting and Organizing Text

Go, Ch. 6






29

Application Software

TIA Ch. 4

Oct

1

Lab. Using Graphics and Tables

Go, Ch. 7






6

Systems Software

TIA Ch. 5


8

Lab. Special Document Formats, Columns, and Mail Merge

Go, Ch. 8






15

Computing Alternatives

TIA pp. 258-271






20

Exam 2. Lab. Excel: Creating a Worksheet and Charting Data

Go, Ch. 9


22

Understanding Hardware

TIA Ch. 6






27

Lab. Managing Workbooks and Analyzing Data

Go, Ch. 10


29

Networking and Security

TIA Ch. 7





Nov

3

Lab. Using Functions and Tables

Go, Ch. 11


5

Protecting Your Computer

TIA pp. 365-377






10

Lab. Audacity.

http://wiki.audacityteam.org/


12

Mobile Computing

TIA Ch. 8






17

Lab. Getting Started with Access Databases and Tables

Go, Ch. 12


19

Digital Entertainment

TIA pp. 420-435






24

Exam 3. Lab. Sort and Query a Database

Go, Ch. 13





Dec

1

Closer Look at Hardware

TIA Ch. 9


3

Lab. Forms, Filters, and Reports

Go, Ch. 14






8

Careers in Information Technology

TIA pp. 472-485


10

Lab. PowerPoint

Go, Ch. 15, 16






15

Final Exam, 10:30-12:30