Genesee Course Catalog

Official Course Information

Please select a Course Section from the List below or use the Search box on the right if you know the Title.

Computer Information Systems Courses:

CIS215 - Scripting Languages
Credits: 4 Catalog Description: Introduces scripting languages, using them to accomplish tasks ranging from simple file management and report writing to system administration and dynamic web page generation. Students should plan sufficient time to complete the necessary programming projects using the college's computing facilities. Prerequisite: CIS125. Lecture: 4 hrs. Student Performance Outcomes: Upon successful completion of CIS 215, the student will be able to: 1. Write a simple script in a modern scripting language and execute it at the shell prompt. 2. Write a simple script in a modern scripting language and execute it on a web server by accessing the URL of this program in a web browser. 3. Effectively use scalar variables, arrays and hashes (associative arrays) to solve programming problems. 4. Effectively use conditional statements and loops to solve programming problems. * 5. Write scripts that will create distinct, dynamically generated web pages depending on different POST and GET requests. * 6. Write scripts that will process and validate web form data, where this data may come from any or all of the following sources: text areas, check boxes, radio buttons, selection lists and hidden fields. 7. Use the scripting language's documentation (printed and on-line) to investigate and effectively use the scripting language's built-in functions and/or subroutines. 8. Effectively use regular expressions to solve programming problems. 9. Write user-defined functions and/or subroutines. 10. Write scripts that will perform basic input/output operations on files on the filesystem. 11. Execute basic SQL queries on a database. 12. Write a script that will perform basic SQL queries on a database. * This course objective has been identified as a student learning outcome that must be formally assessed as part of the College's Comprehensive Assessment Plan. All faculty teaching this course must collect the required date (see Assessing Student Learning Outcomes form) and submit the required analysis and documentation at the conclusion of the semester to the Office of Assessment and Special Projects. Content Outline: 1. Introduction to Unix, the shell, and Perl. 2. Writing and executing bash and perl scripts in the shell. 3. Writing perl script to execute on a web server using CGI (Common Gateway Interface). Writing similar scripts in bash and php and executing them on a web server. 4. Working with Scalars and Arrays. 5. Conditional Statements 6. Using Built-in Functions. 7. Generating Dynamic HTML Documents. 8. Processing Input Data from HTML forms. 9. Looping Structures (for, foreach, while, until). 10. Working with Hashes (Associative Arrays). 11. Writing Subroutines 12. Regular Expressions 13. <, >, >> and Files. 14. Introduction to SQL. 15. Working with an SQL server from inside a script. 16. Final Project. Grading: The main criteria for grading will be the accomplishment of learning objectives outlined in class. Exams and projects will each make up approximately half the grade. Effective Term: Spring 2001

CIS215 - Scripting Languages

Credits: 4

Catalog Description: Introduces scripting languages, using them to accomplish tasks ranging from simple file management and report writing to system administration and dynamic web page generation. Students should plan sufficient time to complete the necessary programming projects using the college's computing facilities. Prerequisite: CIS125.

Lecture: 4 hrs.

Student Performance Outcomes:
Upon successful completion of CIS 215, the student will be able to:

1. Write a simple script in a modern scripting language and execute it at the shell prompt.

2. Write a simple script in a modern scripting language and execute it on a web server by accessing the URL of this program in a web browser.

3. Effectively use scalar variables, arrays and hashes (associative arrays) to solve programming problems.

4. Effectively use conditional statements and loops to solve programming problems. *

5. Write scripts that will create distinct, dynamically generated web pages depending on different POST and GET requests. *

6. Write scripts that will process and validate web form data, where this data may come from any or all of the following sources: text areas, check boxes, radio buttons, selection lists and hidden fields.

7. Use the scripting language's documentation (printed and on-line) to investigate and effectively use the scripting language's built-in functions and/or subroutines.

8. Effectively use regular expressions to solve programming problems.

9. Write user-defined functions and/or subroutines.

10. Write scripts that will perform basic input/output operations on files on the filesystem.

11. Execute basic SQL queries on a database.

12. Write a script that will perform basic SQL queries on a database.

* This course objective has been identified as a student learning outcome that must be formally assessed as part of the College's Comprehensive Assessment Plan. All faculty teaching this course must collect the required date (see Assessing Student Learning Outcomes form) and submit the required analysis and documentation at the conclusion of the semester to the Office of Assessment and Special Projects.

Content Outline:
1. Introduction to Unix, the shell, and Perl.
2. Writing and executing bash and perl scripts in the shell.
3. Writing perl script to execute on a web server using CGI (Common Gateway Interface). Writing similar scripts in bash and php and executing them on a web server.
4. Working with Scalars and Arrays.
5. Conditional Statements
6. Using Built-in Functions.
7. Generating Dynamic HTML Documents.
8. Processing Input Data from HTML forms.
9. Looping Structures (for, foreach, while, until).
10. Working with Hashes (Associative Arrays).
11. Writing Subroutines
12. Regular Expressions
13. <, >, >> and Files.
14. Introduction to SQL.
15. Working with an SQL server from inside a script.
16. Final Project.

Grading:
The main criteria for grading will be the accomplishment of learning objectives outlined in class. Exams and projects will each make up approximately half the grade.

Effective Term: Spring 2001