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