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 nonCS 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 handson 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
 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
 Introduction to Basic Programming
 Introduction to programming
 Setting up the basic interpreter working the editor
 variables
 variable types and data representation
 Dim statement
 Simple input/output statements
 Control Flow statements
 If then
 Ifthenelse
 For – next
 Select case
 Gosub – return
 File I/O
 Math Functions
 Arrays
 Calling subprograms
 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
