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