|
MASTER SYLLABUS |
|||||||||
|
CSIT 2465 |
|||||||||
| Class Hours: 3.0 | Credit Hours: 4.0 | ||||||||
| Laboratory Hours: 3.0 | Revised: Spring 04 | ||||||||
| NOTE: This course is not designed for transfer credit. | |||||||||
| Catalog Course Description: | |||||||||
| A study of database program development for business applications using desktop development tools. Topics include table creation and maintenance, indexing, data manipulation, forms, reports, labels, queries, data modules, object-oriented data manipulation (OODML), event-driven applications, rapid application development (RAD) and client-server development. | |||||||||
| Entry Level Standards: | |||||||||
| The student must have an understanding of database concepts including entity-relationship modeling, normalization and relational operations. The student must also have experience applying theoretical principles to database application development. The student must have math, writing, verbal and English language skills at the college entry level. The student should be able to use a standard keyboard and maintain 23 words per minute error-free typing rate. | |||||||||
| Prerequisites: | |||||||||
| CSIT 1810 and one programming course | |||||||||
| Textbook(s) and Other Course Materials: | |||||||||
| The dBASE Developer Book I – Getting Started, Blue, Ted; Blue Star Press, 1999. | |||||||||
| I. Week/Unit/Topic Basis: | |||||||||
| Week | Topic | ||||||||
| 1 | Lecture: Introduction,
Database fundamentals, Object-oriented principles, Overview of xBase vs.
OODML, Overview of rapid application development (RAD), The Visual dBase
environment.
Lab: Introduction, navigation, the desktop. |
||||||||
| 2 | Lecture: Language
overview, Creating and modifying tables, Records, and fields, Data types,
Operators and expressions.
Lab: Creating/modifying/organizing tables, forms, menus, queries, reports, labels. |
||||||||
| 3 | Lecture: Tables and
indexes, Locating data.
Lab: Creating/modifying/organizing tables, forms, menus, queries, reports, labels. |
||||||||
| 4 | Lecture: Control Structures,
Program flow, Expressions and Operators.
Lab: Creating/modifying/organizing tables, forms, menus, queries, reports, labels. |
||||||||
| 5 | Lecture: Forms and
components.
Lab: Creating/modifying/organizing tables, forms, menus, queries, reports, labels. |
||||||||
| 6 | Lecture: Forms and
components, Menus, Queries.
Lab: Creating/modifying/organizing tables, forms, menus, queries, reports, labels. |
||||||||
| 7 | Lecture: Reports,
Labels.
Lab: Interactive programming, project. |
||||||||
| 8 | Lecture: Exam I, Event-driven
programs, Object-oriented programming.
Lab: Interactive programming, project. |
||||||||
| 9 | Lecture: Objects,
Classes, Variables, Arrays, Data access objects, Calculated fields.
Lab: Interactive programming, project. |
||||||||
| 10 | Lecture: Searching,
Sorting, Filters
Lab: Interactive programming, project. |
||||||||
| 11 | Lecture: Built-in
Functions and Methods
Lab: Interactive programming, project. |
||||||||
| 12 | Lecture: Advanced
forms, Form objects.
Lab: Interactive programming, project. |
||||||||
| 13 | Lecture: Advanced
reports, Report objects.
Lab: Interactive programming, project. |
||||||||
| 14 | Lecture: Advanced
topics, Application projects.
Lab: Interactive programming, project. |
||||||||
| 15 | Lecture: Application
projects.
Lab: Project demonstrations. |
||||||||
| 16 | Final Exam | ||||||||
| II. Course Objectives*: | |||||||||
| A. | Discuss the advantages and disad-vantages of using a database management system as opposed to conventional filing methods. II III IV VII IX XI XII | ||||||||
| B. | Recognize the language of data definition and data manipulation and its importance. III IV VII XI | ||||||||
| C. | Develop a software application using object-oriented programming techniques and design tools. III IV VII IX XI XII | ||||||||
| D. | Describe the factors involved in the transformation of a conceptual design into a logi-cal database design and into a physical database design. III IV VII IX XI XII | ||||||||
| E. | Describe the importance of the database administra-tion function. I II III IV V IX XI XII | ||||||||
| F. | Use a database management package including use of a query language. III IV VI VIII IX | ||||||||
| *Roman numerals after course objectives reference goals of the Computer Science and Information Technology program. | |||||||||
| III. Instructional Processes*: | |||||||||
| Students will: | |||||||||
| 1. | Use professional tools to produce software components and documentation. Technological Literacy Outcome, Personal Development Outcome, Transitional Strategy | ||||||||
| 2. | Create a well-documented database application based on client input or industry research. Problem Solving and Decision Making Outcome, Technological Literacy Outcome, Information Literacy Outcome, Personal Development Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 3. | Participate in a software development team. Communication Outcome, Problem Solving and Decision Making Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 4. | Practice elements of the work ethic such as punctuality, professionalism, dependability, cooperation, and contribution. Personal Development, Transitional Strategy | ||||||||
| 5. | Present a finished product to the class. Communication Outcome, Personal Development Outcome, Active Learning Strategy | ||||||||
| 6. | Participate in a peer review of term projects. Problem Solving and Decision Making Outcome, Communication Outcome, Transitional Strategy, Active Learning Strategy | ||||||||
| 7. | Use professionally accepted methods and materials in completion of applications. Technological Literacy Outcome, Personal Development Outcome, Transitional Strategy | ||||||||
| *Strategies and outcomes listed after instructional processes reference Pellissippi State’s goals for strengthening general education knowledge and skills, connecting coursework to experiences beyond the classroom, and encouraging students to take active and responsible roles in the educational process. | |||||||||
| IV. Expectations for Student Performance*: | |||||||||
| Upon successful completion of this course, the student should be able to: | |||||||||
| 1. | Recognize and use standard relational database and object-oriented terminology. D, F | ||||||||
| 2. | Recognize and perform relational database operations. C, E, F | ||||||||
| 3. | Create user documentation for application programs. C, E, F | ||||||||
| 4. | Use object-oriented prototyping tools to speed program development. B, C, D, F | ||||||||
| 5. | Design and create database forms. A, C, F | ||||||||
| 6. | Design and create printed reports. A, C, F | ||||||||
| 7. | Implement a graphic user interface (GUI) using forms. A, C, F | ||||||||
| 8. | Create properties, event handlers and methods. C, F | ||||||||
| 9. | Integrate application component modules into a complex application. A, B, C, D, E, F | ||||||||
| *Letters after performance expectations reference the course objectives listed above. | |||||||||
| V. Evaluation: | |||||||||
| A. Testing Procedures: 50% of grade | |||||||||
| Exams will comprise 50% of the final grade. Two exams will be given during the course of the semester. Dates will be announced in class and each exam will count 250 points of the final grade. | |||||||||
| B. Laboratory Expectations: 20% of grade | |||||||||
| Lab assignments will be made during the course of the semester. A late penalty may be imposed on any overdue assignment. Failure to satisfactorily complete all labs may result in a grade of F in the course. Labs will count 200 points (20%) of the final grade. | |||||||||
| C. Field Work: | |||||||||
| The term project may require off-campus meetings and/or interviews. | |||||||||
| D. Other Evaluation Methods: 30% of grade | |||||||||
| An extensive term project will be as-signed. The project will emphasize practical solutions to database problems and will require design, develop-ment, and documentation of working database applications. Failure to satisfactorily complete a term project will result in a grade of F for the course. The projects will count 300 points (30%) of the final grade. A portion of the project grade will be determined by peer evaluation. | |||||||||
| E. Grading Scale: | |||||||||
| 900 -
1000 A
800 - 899 B 700 - 799 C 600 - 699 D 0 - 599 F |
|||||||||
| VI. Policies: | |||||||||
| A. Attendance Policy: | |||||||||
| Pellissippi State Technical Community College expects students to attend all scheduled instructional activities. As a minimum, students in all courses must be present for at least 75 percent of their scheduled class and laboratory meetings in order to receive credit for the course. | |||||||||
| B. Academic Dishonesty: | |||||||||
| Plagiarism, cheating, software piracy, non-educational use of computer systems and other forms of academic dishonesty are strictly prohibited. | |||||||||