APPROVAL SHEET

CURRICULUM CHANGE

NOTE: One copy of this approval sheet must accompany the original of each proposal during the entire approval process. Proposals should be prepared according to the Guides and Format for submitting Course/Curriculum Proposals.

Date: September 21, 2005

Department: School of Computer Information Systems

Signature of Initiating Unit Chair/Dean:

Desired Effective Date of Change: Spring 2006

Nature of Change (Circle One): ADD DELETE MODIFY

Current Listing in Catalog:

None

New Listing for Catalog:

CIS 3XX3 Business Database Management Systems

3 credits: 3 hours lecture

Offered: Fall

Prerequisites: CIS 2223 and advanced standing

Essentials of database design, creation and manipulation for business and accounting applications using a microcomputer-based package. Emphasis on advanced queries, reports and macros. Offered for CIS majors and non-majors.

Justification:

1) As per a request from the Accounting Department to provide their majors with database background before ACCT 4323 (Accounting Information Systems).

2) To provide CIS majors with a thorough background in the use of a popular microcomputer-based DBMS (ACCESS), especially because their core database class has recently been modified and now emphasizes SQL Server and structured query language.

Approved: Date:

Chairperson, Curriculum and

Standards Committee

Chairman, Assembly

Chancellor

CIS 3XX3 – Business Database Management Systems

Instructor: Office Hours:

Office:

Phone:

E-mail:

=================================================================================

Course Purpose/Objectives: This course provides students the opportunity to learn database creation, manipulation and administration utilizing one of the leading database productivity packages created for the microcomputer. Introductory through advanced topics will be studied with an emphasis on current business applications. This course is offered for CIS majors and non-majors.

Prerequisites: CIS 2223 and advanced standing

Text/Materials:

1) Microsoft Office ACCESS 2003 Comprehensive Concepts & Techniques, Shelly,Cashman&Pratt,

Thomson Course Technology, 2006

2) one ZIP diskette (100MB or 250 MB) or a (USB) memory stick 3) pencil 4) an e-mail account

Special Note:

It is the policy of the University of Arkansas-Monticello to accommodate individuals with disabilities pursuant to federal law and the University’s commitment to equal educational opportunities. It is the responsibility of the student to inform the instructor of any necessary accommodations at the beginning of the course. Any student requiring accommodations should contact the Office of Special Special Student Services located in Harris Hall room 120; phone 870–460-1026; TDD 870-460-1626; fax 870-460-1926.

Teaching Methods & Course Format:

Lectures, computer lab assignments, written exams, and an individual project should be expected .

Grading:

Approximately 450 points may be earned during the semester: three exams @50 points each; individual assignments & short exercises @ 250 ; and a student project @ 100 points.

Semester letter grades will be determined using the following standard percentage for junior/senior/graduate courses:

A 93%-100% B 80%-92% C 70%-79% D 60%-69% F Below 60%

(see the instructor before this occurs)

Course Policies:

Students are expected to attend all classes. In the rare event that a student must be absent it is her/his responsibility to obtain materials which may have been distributed. Points for missed in-class assignments normally can not be redeemed for more than ¾ credit and at the discretion of the instructor. Exams can be taken early but no student should expect to take make-up exams. See or call your instructor within 18 hours of an unusual absence

CIS School policy dictates that incompletes (“I”) can only be considered when students have successfully completed a minimum of 75% of the course/coursework and, is allowed only at the discretion of the instructor.

Student Conduct Code: All students are required to comply with the requirements of the Student Conduct Code as specified in the UAM Student Handbook. The handbook which includes the conduct code (pp. 35-41) is available online at http://www.uamont.edu/Student Handbook 2004-2005.pdf.

The use of cell phones in class should be considered prohibited.

Assignments: All assignments are expected no later than the end of the day (5 o’clock) on the due date. Late submission of assignments is defined as three days passed the original due date and those assignments will be assessed a 25% penalty. However, all assignments must be completed for students to earn a passing grade in the course (that is, whether credit is earned or not).

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog.

Posting of Grades: UAM will no longer send grade reports to all students. You may access your grades through Campus Connect on the UAM homepage, http://www.uamont.edu/. To have your grades mailed to you, complete the grade request form available in the Registrar’s Office in Monticello or the Student Services offices in Crossett or McGehee

General Course Outline:

Part I.

1. Project 1 – Creating and Using a Database

2. Project 2 – Creating and Using Queries

3. Project 3 – Maintaining a Database

4. Integration – Sharing data with EXCEL

5. EXAM #1 (Project 1-3 ++)

Part II.

6. Project 4 – Reports and Forms objects

7. Project 5 – Enhancing Forms

8. Project 6 – Switchboards, Pivot Tables and Pivot Charts

9. Web Feature

10. EXAM #2 (Projects 4-6 ++)

Part III.

11. Project 7 – Advanced Reports

12. Project 8 – VBA and Multi-page Forms

13. Project 9 – Database Administration

14. SQL Feature

15.EXAM #3 (Project 7-9 ++)

16. Semester Project

Important dates to remember:

5 September ** LABOR DAY HOLIDAY **

31 October Pre-registration begins

9 November Last Day to drop with “W”

18 November Preregistration ends

24-25 Nov ** Thanksgiving Holiday **

6 December Last Day to WITHDRAW from classes

9 December Last Day of classes

12-16 December FINAL EXAMs

(see UAM schedule)

APPROVAL SHEET

CURRICULUM CHANGE

Date: September 21, 2005

Department: School of Computer Information Systems

Signature of Initiating Unit Chair/Dean:

Desired Effective Date of Change: Spring 2006

Nature of Change (Circle One): ADD DELETE MODIFY

Current Listing in Catalog:

None

New Listing for Catalog:

CIS 3XX3 Introduction to C# Programming

3 credits: 3 hours lecture

Prerequisites: General Education Mathematics, Grade of “C” or better in CIS 2203

Design and development of intermediate Windows forms-based application using a task-driven approach with a C-based language.

Justification:

1) Gives the students the opportunity to learn an “elegant” programming language that allows developers the opportunity to create significant productivity enhancements to complex software applications that are at the same time highly maintainable.

2) The similarities of C# to Java and C++ (which have been classically known to be challenging languages for the beginner to learn) make it easier for students to move to these other C-based programming languages should/when the need arises.

3) Previously this course was offered in a senior seminar format. However, to better accommodate the SIS program and our CIS majors it is deemed important to offer the course with its own specific course designator and description in the catalog at the intermediate level.

Approved: Date:

Chairperson, Curriculum and

Standards Committee

Chairman, Assembly

Chancellor

CIS 3XX3 Syllabus

Introduction to C# Programming

Instructor: Office Hours:

Office:

Phone:

E-mail:

=================================================================================

Course Purpose/Objectives:

Using a task-driven approach, students will have the opportunity to reinforce programming concepts ;

learn another high-level programming language; demonstrate integrated computing skills; and integrate OOP with a database .

Prerequisite:

Students must have prior experience in at least one high-level programming language.

Text/Materials:

1) An Information Systems Approach to Object-Oriented Programming using Microsoft Visual C#.NET, Lutes&Harringer&Purdum,Thomson Course Technology, 2006

2) one ZIP diskette (100MB or 250 MB) or a (USB) memory stick 3) pencil 4) an e-mail account

Special Note:

Teaching Methods & Course Format:

Lectures, computer lab assignments, written assignments, student demonstrations, quizzes, hands-on and written exams, and an integrated project should be expected .

Grading:

Approximately 450 points may be earned during the semester: three major exams @100 points each; individual programming assignments & short exercises @ 125 ; and a student presentation @ 25 points.

Graduate students taking the class for credit will develop a portfolio of additional programming problems with their field of study in mind. They will also formally investigate another popular Object-Oriented Language of the instructor’s choice or investigate advanced topics in OOP. A written report will be submitted, and a presentation on the findings (including sample code) will be presented to the class. Total points for the semester for graduate students is approximately 700.

Semester letter grades will be determined using the following standard percentage for junior/senior/graduate courses:

A 93%-100% B 80%-92% C 70%-79% D 60%-69% F Below 60%

(see the instructor before this occurs)

Course Policies:

The use of cell phones in class should be considered prohibited.

Assignments: All assignments are expected no later than the end of the day (5 o’clock) on the due date. Late submission of assignments is defined as three days passed the original due date and those assignments will be assessed a 25% penalty. However, all assignments must be completed for students to earn a passing grade in the course (that is, whether credit is earned or not).

Academic Dishonesty: Plagiarism and cheating are serious offenses and may be punished by failure on exam, paper or project; failure in course; and or expulsion from the University. For more information refer to the "Academic Dishonesty" policy in the University Undergraduate Catalog.

Posting of Grades: UAM will no longer send grade reports to all students. You may access your grades through Campus Connect on the UAM homepage, http://www.uamont.edu/. To have your grades mailed to you, complete the grade request form available in the Registrar’s Office in Monticello or the Student Services offices in Crossett or McGehee

General Course Outline:

Part I.

1. Chp 1 – Introduction to OOP and the .NET paradigm

2. Chp 2 – Creating a Simple Application (using Windows Form)

3. Chp 3 – Storing Data in Objects (creating variables and setting data types)

4. Chp 4 – Manipulating Data in Objects (usage of Assignment Statements)

5. EXAM #1 (Chps 1-4)

Part II.

6. Chp 5 – Decisions and Data Validation

7. Chp 6 – Catching Exceptions

8. Chp 7 – Adding Methods for Objects

9. Chp 8 – List controls and Looping constructs

10. EXAM #2 (Chps 5-8)

** Paper: Two Language Comparative Study (Procedural language vs. OOP language)

Part III.

11. Chp 9 – Arrays and Collections

12. Chp 10 – Encapsulation

13. Chp 12 – User Interface Objects

14. Chp 13 – Database Connectivity with ADO.NET

15. Chp 14 – Inheritance and Polymorphism

16. Database Programming with C# (student presentations)

17. EXAM #3 (final exam)

*** Graduate Presentations

Important dates to remember: