CISC127 Spreadsheet Concepts and Applications

Department of Science, Technology, Engineering & Mathematics: Computer/Information Science

I. Course Number and Title
CISC127 Spreadsheet Concepts and Applications
II. Number of Credits
3 credits
III. Minimum Number of Instructional Minutes Per Semester
IV. Prerequisites
Math Placement Test score of 5 or better or MATH095 (C or better)
V. Other Pertinent Information
Lab assignments are an essential part of this course and a minimum of 8 laboratory projects aimed at developing spreadsheet expertise will be used. Lab time could be devoted to lab exercises, as well as demonstrations. Students will be evaluated by test results, laboratory projects, class participation, attendance, and initiative. There will be at least two tests which will comprise at least 50% of the grade. There is no comprehensive final examination.
VI. Catalog Course Description
This course is an in-depth study of the spreadsheet, database, and graphics capabilities of a widely used software package. Topics include: creating worksheets and templates, printing reports and graphs, using macros, and writing simple programs. Extensive laboratory work is required.
VII. Required Course Content and Direction
  1. Learning Goals:

    1. Course
    2. Students will:
      1. solve “what if” and other problems using a spreadsheet and its powerful functions;
      2. create a database and perform various types of data manipulation, including sorting, extraction of data, and production of graphs and charts;
      3. write macros which eliminate detailed repetitive routine; and
      4. write programs which include looping, subroutines, and “if” statements.
    3. Core (if applicable)
    4. This course is not included in the Core.
  2. Planned Sequence of Topics and/or Learning Activities:

    1. Computer Basics
      1. navigating the computer operating system
      2. copying files and creating subdirectories
    2. The Spreadsheet Environment
      1. navigating the package
      2. menu/command structure
      3. spreadsheet organization and default parameters
      4. entering simple formulas involving basic arithmetic operations
      5. loading and saving a file
      6. use of short-cut keys
      7. solving a simple “What if” problem
    3. The Spreadsheet Component
      1. building a spreadsheet
      2. row/column operations
      3. formatting and printing capabilities
      4. developing templates
      5. creating windows and titles
      6. building complex formulas using date and logical functions
      7. solving more complex problems using data and logical functions
    4. The Graphics Component
      1. creating bar, line, and pie graphs
      2. formatting and sizing a graph
      3. printing graphs
    5. The Data Management Component
      1. creating a database
      2. sorting and extracting data
      3. database functions
    6. Spreadsheet Macros and Programming
      1. entering and invoking a macro
      2. writing a simple macro
      3. programming macros
      4. user-interaction commands
      5. use of subroutines, if statements, and looping
      6. screen control commands
      7. string functions and other special functions
  3. Assessment Methods for Core Learning Goals:

    1. Course
    2. The assessment of Course Learning Goals is based on written tests, labs and other assignments, as well as performance-based tasks as appropriate.

    3. Core (if applicable)
    4. This course is not included in the Core.
  4. Reference, Resource, or Learning Materials to be used by Students:

    Departmentally selected textbook and other learning materials. Details provided by the instructor of each course section. See course format.
VIII. Teaching Methods Employed
Section VIII is not being used in new and revised syllabi as of 12/10/08.

Review/Approval Date - 9/98; Revised 10/2010