COMPSCI 105

Handbook and Syllabus

Professor William T. Verts


Complete printable Spring 2017 syllabus in .PDF format.


SEMESTER CALENDAR




IMPORTANT PLACES FOR COMPSCI 105

The Library computer lab is in DuBois 1685 (side room).


LAB SCHEDULE

All lab sections have a TA responsible for helping out and for collecting your assignments. While the lab assignments are mandatory, attending a computer lab to do them is optional; seats in the lab are available on a first-come first-served basis. We have computers reserved in the labs for the first 15 minutes of each session; after that the lab attendants may release empty lab seats to anyone.


TEXTBOOKS

Computer Literacy Workbook, 2016-2017 Printing, Twenty-Third Edition -- William T. Verts.

This book is an outgrowth of several years worth of teaching COMPSCI 105. It consists of material taken directly from my lectures, and contains all of your homework and lab assignments, study guides, sample exam questions, and the extra credit project. This book is "COMPSCI 105 in a box". Make sure that you get the 2016-2017 (YELLOW) edition, but not any of the following editions:

Computer Science Companion, 2016 Printing, Third Edition -- William T. Verts

This is a reference book that applies to all of my classes. In early editions of the Workbook there was a reference section in the back; that reference material has been extracted and quintupled in size to form the Companion. Not all of the material applies to this class, but it represents the union of all material I cover in all of my classes. Many students take follow-on courses from me where the other material will be presented, often from a different direction.


MATERIALS YOU WILL NEED

You will need a flash drive if you need to move files back and forth between the campus labs and your home computers, or if you want to bring me a file to examine.

Please get a small stapler to carry in your backpack at all times (for preparing your reports to turn in).


GENERAL EDUCATION STATEMENT

The document you are reading contains an older version of the mission of COMPSCI 105 (shown below), but is still a valuable, if slightly out-of-date, resource. As part of the University requirements on General Education courses, the General Education Statement is a link to a more formal and much more current statement on how COMPSCI 105 addresses the general education mission.


THE MISSION OF COMPSCI 105

The course description for COMPSCI 105 reads as follows:

Microcomputers are now used widely not only in academia but also in all areas of modern life. For this reason, it's important that all student understand how computers work and how computers can be used as a problem-solving tool. The focus of this course is on computer applications. The course stresses the ways in which computers can help you solve problems efficiently and effectively. The course provides a broad introduction to hardware and software aspects of microcomputers. The four application areas are discussed: word processing, spreadsheets, databases, and telecommunications. The course uses the University's microcomputer labs, and weekly 90-minute lab sessions are an integral part of the course. Students who are more interested in computer programming should take COMPSCI 121 or COMPSCI 119. Prerequisites: reasonable high school math skills. Typing ability is also an important asset for the course.

Obvious Mission

The description above, although fundamentally correct, speaks only of the superficial mission of the course. The obvious and primary mission of COMPSCI 105 is to insure that students become competent using microcomputers. This is achieved in two ways. First, we teach specific packages (Microsoft Word, Excel, and Access as parts of Microsoft Office, and several Internet tools). Second, we approach the teaching of these packages in such a way that students can generalize to similar packages they may encounter later on.

Ulterior Mission

More important than the individual packages are the skills in problem solving that are taught. This course satisfies the R2 (Tier 2) requirement for analytical reasoning, which means that problem solving (including the proper use of mathematics) is an important part of the course. Some of the questions you will answer in this course include:


SUBJECT SYLLABUS

  1. Introduction
  2. The PC Clone Computer
  3. Microsoft Windows
  4. Word Processors
  5. Spreadsheets
  6. Databases
  7. Networks and the Internet
  8. Special Topics

General Course Rules


NOTES ON CHEATING

Copying files from one machine to another is ridiculously easy. Some of you may be tempted by this fact to "share" assignments, or to engage in out-and-out thievery. Either case constitutes incorrect behavior, and will not be condoned. Only in extremely rare and unusual cases will two assignments look identical; under most circumstances your assignments will exhibit some form of stylistic "signature" that makes it unique to you. We find cases of cheating when two (generally incorrect) assignments bear that same signature (character formats, paragraph styles, page layout, choice of commentary, etc.). We then put the assignments one on top of the other and hold them up to the light: failing the "shadow" test means you and your accomplice are both in deep weeds.

When found, we will follow the directions in the published guidelines on academic honesty. Please read this document carefully.

DO YOUR OWN WORK!

Notes for Anxious, Math-Anxious, Computer-Phobic, and Learning Disabled Students

One of the most common things that we hear in office hours is "I'm not like all your other students" followed directly by "I don't know very much about computers". What prompts those statements is a certain nervousness about learning a new and intimidating subject, using unfamiliar high-technology equipment, and a feeling that all the other students know far more than you do. You have no reason to feel this way. If you knew lots and lots about computers, you wouldn't be in this class, and thank goodness you aren't like all the other students!

Math Anxious

Yes, Virginia, you will be using mathematics in this course. We believe that in today's world the ability to use mathematics is a critical survival skill. The ability to reason mathematically is a necessary and important part of making informed decisions, and the lack of such skills is equivalent to illiteracy. We aren't going to ask you to derive the quadratic equation, plot the orbit of a cardioid, solve an indefinite integral, or prove that E=mc2, but there are some practical skills that we are going to insist that you have. These include (but are not limited to) solving and writing arithmetic expressions, knowing how to take a percentage of a total, converting quantities from one unit to another, converting between and reasoning about number bases, using logic (AND, OR, and NOT), computing simple interest rates, and creating, modifying, and reasoning about graphical presentations of data. If we present any assignments that require more advanced treatments of mathematics, such as trigonometry (which we have done in the past), we will give you enough background to be able to solve the problem. We will not leave people in the lurch; there will always be some form of assistance available.

Computer-Phobic

If you would rather be on the far side of the planet (any planet) than dealing with a computer, please give us a chance! Even though it is now a necessary part of our everyday lives, working with computers is also one of the most intellectually rewarding activities I know of, and it can be great fun as well! We will do our best to show you the ropes, and we hope that our excitement wears off on you.

Learning Disabled

If you have a documented learning disability, have contacted the Disabled Student Services office, and have signed the forms so that we will be notified, we will be able to help you. In a class of 400+ students, it is inevitable that several will have some form of learning disability. We accept and acknowledge that fact, and are willing to accommodate you the best way we can. This includes giving untimed, oral, or private exams, and scheduling regular office hours for consultation.

Any Combination of the Above

If you are learning disabled and math-anxious, or math-anxious and computer phobic, or all three, things will be a bit more difficult for you, but all is not lost! Make certain that you seek help from any of us during office hours; that is why we are here! If one person does not meet your needs, seek out another! We will work with you until you understand the material; that's our job!


Back to Dr. Bill's COMPSCI 105 Class
Back to Dr. Bill's Home Page