Information Technology 381

ITEC 381: Spreadsheet Programming

Prerequisite: ITEC 281 and either MATH 126 or MATH 151

Credit Hours: (3)

Teaches fundamental programming concepts using spreadsheet technology common in today’s business environment.  This course may not be used to satisfy a B.S. requirement or a technical elective in the Information Technology Department.  


Detailed Description of Content of Course

Topics include:
1. Introduction to Programming
    a. Problem specification and top-down design
    b. Stepwise refinement
     c. Programming environment
    d. Variables
    e. Input and output
    f. Assignment statements and precedence

2. Control structures
    a. If statements
    b. While statements
    c. For Loop Statements

3. Additional concepts
    a. Working with existing built in functions
    b. Event handling and built in controls
    c. Arrays
    d. Objects
    e. Debugging


Detailed Description of Conduct of Course

Students will be given programming projects and problems which will allow them to learn programming concepts and algorithm development in the spreadsheet environment.   


Goals and Objectives of the Course

Students who complete the course will be able to:
1. Take a problem and develop an appropriate well structured algorithm.
2. Implement their solution in a standard spreadsheet programming language.


Assessment Measures

Evaluation will be based on homework assignments, projects and examinations.


Other Course Information

None.


Review and Approval

Spring 2010        Initial Course Approval    Art Carter, Chair

Revised: May 30, 2012