CMPS 273, Spring 2008 Syllabus
Instructor Dr. Cris Koutsougeras
Office: Fayard Hall, Room 307C
Office Phone: (985) 549-2189
Email Address: ck (of course at selu.edu)
This is the second course in the 173/273 sequence whose purpose is to provide non-CS majors with basic computer skills. Students will review the basics of Microsoft applications, fundamentals of computer science, statistics, and programming. Each student should get a USB thumb drive in order to save work and software that may be provided for the class. The class will be presented using a both a mix of theory and hands-on exercises.
Students will study and gain familiarity with the following topics.
- Review of Microsoft Applications
- Review of Basics of Computer Science
- Fundamentals of Programming
Course Time and Place : M/W 1:00 – 2:15 Anzalone Hall – Room 216
Text: Computer Science, An Overview; J.Glenn Brookshear
There will be 2 to 4 quizzes, 1 midterm, a final exam, and several assignments. The material for the quizzes, and exams will be taken from the assignments and lectures. Students are expected to be in class and do the assigned work. Of note is the final exam.
If the student’s grade average is 93 or better and no homework has been missed or late, the final will be one part, otherwise it will be two parts.
Depending on your performance you should in general expect the following grades:
90 to 100 – A 70 to 79 – C 80 to 89 – B
60 to 69 – D 0 to 59 – F
If the class median is outside the B region then there will be curving. When you study, you need to work problems, read the text, etc. well before the test.
Work turned in late will be charged 10 percent per class late period.
Attendance is important. Absences will have an adverse effect on your grade in the following ways: missed quiz points, missed announcements concerning assignments and due dates, non-exposure to material not directly covered in text.
Academic dishonesty is a serious subject. In this class the objective is too learn, and since there are many computer based assignments, unless otherwise stated, working together is okay, but it is the students responsibility to make sure that they can do the assignments. Copying someone else’s work is dishonest, and will impair performance on in class quizzes. Copying someone else’s work on examinations, plagiarism, improper acknowledgement of sources, etc are considered serious offenses and are grounds for disciplinary action as outline in the current general catalogue.
If assignments are turned in that appear to be copied students will share the grade. For example, if a score of 90 is given and 3 students are found to have “collaborated to a very high degree” then each will be given 30 points.
Classroom Decorum: Free discussion, inquiry, and expression is encouraged in this class. Behavior that interferes with either (a) the instructors ability to conduct the class or (b) the ability of students to benefit from the instruction is not acceptable. Examples may include routinely entering the class late or departing early; use of beepers, cell phones, or other electronic devices; repeatedly talking in class without being recognized; talking while others are speaking; or arguing in a way that is perceived as “crossing the civility line.
- If you are a qualified student with a disability seeking accommodations under the Americans with Disabilities Act, you are required to self-identify with the Office of Disability Services, Room 203, Student Union. No accommodations will be granted without documentation from the Office of Disability Services.
- It is University policy that the classroom is not a place for children, and that students are not to bring their family members for day care or baby sitting.
- Review of Microsoft Applications
- Word – Resume and cover letter
- PowerPoint presentation.
- No more than 5 lines per slide
- Introduction to Excel
- Brief review
- Formulas and series of numbers (Homework 1)
- Data Display and Interpretation
- Pie Charts/histograms (Homework 2)
- Basic Descriptive Statistics
- Averages and weighted averages
- Median and mode (Homework 3)
- Variance and standard deviation
- Samples and Populations (Homework 4)
- Excel Project 1 – Crunch time series numbers (about 2000 of them) and write report
- Use Excel to crunch numbers
- Integrate spreadsheet into Word document
- Integrate graphs and results into Word document
- Make short PowerPoint of project.
- Quiz 1
- Review of Fundamentals of Computer Science (Chapters 1, and 2)
- Bits and Bytes
- Logical Operations (AND, OR, etc) (1.1, 1.2)
- Gates and logic circuits (Homework 5)
- Binary numbers (Binary to decimal etc.) (Homework 6) (1.4)
- Binary Operations (+, -, etc) (1.5)
- Programming Concepts (5.2 – 5.3)
- Data types
- Assignment Statements (Homework 7)
- Control Statements (Homework 8)
- Procedures (Homework 9)
- Quiz 2
- Review Introduction to Programming using BASIC
- Setting up the basic interpreter working the editor (In class Program 1)
- variable types and data representation
- Dim statement
- Simple input/output statements
- Input (In class Program 2)
- Control Flow statements
- If -then
- If-then-else (Program 1)
- For – next (Program 2)
- Calling sub routines
- Math Functions (Program 3)
- Quiz 3
- Cumulative Review
Important dates to be noted:
- Thursday, February 14 is the last day to withdraw or resign from Term I classes.
- Friday, March 14 is the last day to withdraw or resign from regular classes.
- Thursday, May 1 is the last day to withdraw or resign from Term II classes.
- Monday, May 19 is the last day to return rental textbooks without a fine.