CMPS 173/273 Syllabus

Contact Information

Dr. Patrick McDowell

Office: 329B Fayard Hall

Email: pm@selu.edu

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.

Text

Computer Sciene, an Overview; J.Glenn Brookshear

Microsoft Office 2003; Robert T. Grauer and Maryann Barber

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