|
MASTER SYLLABUS |
|||||||||
|
GIS 1110 |
|||||||||
| Class Hours: 3.0 | Credit Hours: 3.0 | ||||||||
| Laboratory Hours: 0.0 | Date Revised: Fall 00 | ||||||||
| NOTE: This course is not designed for transfer credit. | |||||||||
| Catalog Course Description: | |||||||||
| Introduces the concept of database structure to GIS projects and provides skill training in the use of relational databases for spatial and multiple table queries. Structured Query Language (SQL) is used. Students design, develop, maintain, query and modify a variety of GIS databases. Database importing, exporting, and file conversion are also covered. | |||||||||
| Entry Level Standards: | |||||||||
| Students should have knowledge and experience working in the Windows operating system environment, including the use of the Microsoft Office software components. Students should also have the ability to use a standard keyboard and maintain a rate of 10 words per minute. Students should also have mathematics, writing, and verbal skills at the college level. | |||||||||
| Prerequisite: | |||||||||
| GIS 1010 | |||||||||
| Textbook(s) and Other Course Materials: | |||||||||
| TBA | |||||||||
| I. Week/Unit/Topic Basis: | |||||||||
| TBA | |||||||||
| II. Course Objectives*: | |||||||||
| A. | Understand the relationship between GIS analysis and database management. I, II, IV | ||||||||
| B. | Understand how to balance the requirements of database performance and cost. I, II, IV | ||||||||
| C. | Understand how to evaluate needs, develop a GIS database and implement the data collection for a GIS project. I, II, IV | ||||||||
| D. | Understand how to make effective use of tools of database management. I, II, IV | ||||||||
| *Roman numerals after course objectives reference goals of the GIS program. | |||||||||
| III. Instructional Processes*: | |||||||||
| Students will: | |||||||||
| 1. | Use spatial elements, measurements, locations and references to develop graphic and numerical awareness of the real world. Understand how information in the form of maps and numbers connect to the physical world. Numerical Literacy Outcome, Transitional Strategy | ||||||||
| 2. | Be familiar with the basic procedures and the overall quality of GIS databases. Numerical Literacy Outcome, Problem Solving and Decision Making Outcome | ||||||||
| 3. | Participate in open discussions regarding the strengths and weaknesses of GIS procedures and what improvements might be made in future releases. Active Learning Strategies, Communication Outcome, Transitional Strategy | ||||||||
| 4. | Use the Internet and electronic mail to communicate effectively between the instructor, other students, and for information gathering. Technological Literacy Outcome, Information Literacy Outcome | ||||||||
| 5. | Internalize the work ethic by demonstrating regular attendance, punctuality, dependability, cooperation with teachers and peers, and professionalism. Personal Development Outcome | ||||||||
| *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. | Demonstrate understanding of special database design problems associated with the use of GIS data. A, B, C, D | ||||||||
| 2. | Use Structured Query Language (SQL) for GIS applications. A, B, C, D | ||||||||
| 3. | Demonstrate understanding of several DBMS formats used with GIS data and methods used to convert from one to another. A, B, C, D | ||||||||
| 4. | Successfully execute complex SQL queries of GIS databases. A, B, C, D | ||||||||
| 5. | Demonstrate understanding of relational database design and be able to independently create an efficient design of a multiple table GIS database. A, B, C, D | ||||||||
| *Letters after performance expectations reference the course objectives listed above. | |||||||||
| V. Evaluation: | |||||||||
| A. Testing Procedures: 65% of grade | |||||||||
| Four tests will be administered (three tests plus the final) counting for approximately 65% of the final grade. | |||||||||
| B. Laboratory Expectations: 35% of grade | |||||||||
| Students will be assigned group and/or individual projects. The ability to work with others, the ability to make efficient use of equipment, and the level at which students perform will contribute to the grade. | |||||||||
| C. Field Work: | |||||||||
| N/A | |||||||||
| D. Other Evaluation Methods: | |||||||||
| N/A | |||||||||
| 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 and other forms of academic dishonesty are prohibited. A student guilty of academic misconduct, either directly or indirectly through participation or assistance, is immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions that may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F for the exercise or examination or to assign an F in the course. | |||||||||
| C. Use of Equipment: | |||||||||
| Any act of misuse, vandalism, malicious or unwarranted damage or destruction, defacing, disfiguring, or unauthorized use of property/equipment belonging to Pellissippi State is subject to disciplinary sanction. | |||||||||