CMPS 173/273 Syllabus

1.0 Contact Information

Dr. Patrick McDowell

Office: 329B Fayard Hall

 

Email: pm@selu.edu

1.1 Course Information

The purpose of these courses is to provide non-CS majors with basic computer skills including proficiency in commonly used PC software (Word, Powerpoint, Access, and Excel), basic descriptive statistics, digital logic, and an introduction to computer science and programming. The computer programing will be focused on learning the fundamentals with BASIC with the end goal of gaining working familiarity with LabView. The class will presented using a both a mix of theory and hands-on exercises.

2.1 Course Time and Place

Section 1 – T/Th, 11:00 – 12:15

Section 2 – T/Th, 3:30 – 4:45

 

Anzalone Hall – Room 216

 

2.2 Text

Computer Sciene, an Overview; J.Glenn Brookshear

Microsoft Office 2003; Robert T. Grauer and Maryann Barber

2.2 Grading Policy

 

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. 

 

Grade Scale

90 to 100 – A

80 to 89 – B

70 to 79 – C

60 to 69 – D

0 to 59 – F

 

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.

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.
  • Course Outline/Schedule
  • Review of CMPS 173 topics
    • Word
    • Powerpoint
  • Introduction to Excel
    • Overview and data entry
    • Formulas and Functions
    • Data Display
      • Charts
      • Graphs
      • Pie Charts/histograms
    • Basic Descriptive Statistics
      • Averages and weighted averages
      • Median and mode
      • Variance and standard deviation
  • Introduction to Access
    • Overview of Relational Databases
      • Creation and viewing of tables
        • Design View
        • Adding Data to Table
        • Creating Relationships between Tables
    • Creating and Running Queries
      • Single Table Queries
      • Multiple Table Queries
    • Data Entry Forms
      • Using the wizard to make the data entry form
    • Reports
    • Review
  • Computing Fundamentals
    • Boolean Logic
    • Digital number systems
      • Binary numbers
      • Binary to Decimal
      • Binary to Hex to Decimal
      • 2’s Complement
    • Logic
      • AND, OR, NOT, XOR
      • If statements
      • Loops
        • For
        • While
  • Introduction to Basic Programming
    • Introduction to programming
    • Setting up the basic interpreter working the editor
      • “Hello World”
    • variables
      • variable types and data representation
      • Dim statement
    • Simple input/output statements
      • Print
      • input
    • Control Flow statements
      • If -then
      • If-then-else
      • For – next
      • Select case
      • Gosub – return
    • File I/O
    • Math Functions
      • Abs
      • Sqr
      • Randomize
    • Arrays
    • Calling subprograms
      • Call statement
  • Introduction to Labview Programming
    • What is Labview, where is used, why is it used
      • Simple examples
      • How to work the Labview envionment
    • Basic operations:
      • Numerical operators
      • Formula boxes
      • Boolean functions
    • Loops
      • For loops
      • While loops
      • Shift registars
    • If statements
    • Arrays
    • Sequences
    • File I/O
    • Intro to data collection
      • Analog to digital conversion
      • Nyquist
      • Sound card
  • Review