GY451 GIS Programming and Customization Advanced Cartography/GIS Level 3 (3 hrs.) S09

21273 01 8:15-9:45 203 Martin Hall

Instructor: Dr. Miriam Helen Hill
Office: 205 Martin Hall

Office Hours: Monday 9:45-2:45 or by e-mail or WWW by appointment in the virtual classroom or AOL IM

E-mail AND (Both go to AOL)
Telephone: (256) 782-8063

Course Description: Prerequisite: GY307 and GIS Processing and Theory and GIS Accessory Tools (at least concurrent) Consent of Instructor is required
Emphasizes construction of macros, objects, and program interfaces whereby software can be adapted or created to meet individualized user needs.

Text: Robert Burke, Getting to Know ArcObjects: Programming ArcGIS with VBA, Redlands, CA: ESRI Press, 2003. 1-58948-018-X

Alan I Rea, Microsoft Visual Basic for Applications Boston: McGraw-Hill, 2003, 0-07-283616-4

AND ONE of the following:

Robert T. Grauer and Maryann Barber, Exploring Microsoft Access 2000 with VBA, Upper Saddle River, NJ: Prentice Hall, 2001. 0-13-019698-3. 448+ (VBA is a long chapter in the appendix).

Evan Callahan, Microsoft Access 2002 Visual Basic for Applications Step by Step, Redmond, WA: Microsoft Press, 2001. 0-7356-1358-3. (Disk) 333 pages. (Note that this is 2002 and not 2000).

Robert Smith and David Sussman, Beginning Access 2000 VBA: A Comprehensive Tutorial to Programming Using VBA Indianapolis: Wiley, 2003. 0-7645-4383-0 (disk) list $39.99, 864 pages.

Resource List:

Map Objects

Bruce A Ralston, Developing GIS Solutions with MapObjects and Visual Basic: Learning to Program GIS Applications from the Ground Up, Albany, NY: Onword Press, 2002. 0-7668-5438-8. (disk) 315 pages.

Amir H. Razavi, ArcGIS Developer's Guide for VBA: Using VBA to Maximize ArcGIS 8.X Development, Clifton Park, NY: Thomson, Delmar Learning Onword Press, 2002, 0-7668-6325-5. 188 pages

Visual Basic Sources

Patrick G. McKeown and Craig A. Piercy, Learning to Program with Visual Basic VB6.0, 2nd ed., New York: John Wiley & Sons, 2002, 0-471-41862-5. (disk with VB 6.0 software) 594 pages.

Julia Case Bradley and Anita C. Millspaugh, Programming in Visual Basic 6.0 Update Edition, Boston: McGraw-Hill Irwin 2002. 0-07-251381-0 (disk) 694 pages.

Access 2000

Sarah E. Hutchinson and Glen J. Coulthard, Microsoft Access 2000 Complete Edition Advantage Series, Boston: McGraw-Hill Irwin, 2000. 0-07-234801-1, 651+ pages.

Rob Krumm, Access 2000 Programming for Dummies: A Reference for the Rest of Us! New York: Wiley, 1999. 0-7645-0565-3 (disk) 424 pages.

Cary N. Prague, Jennifer Reardon, Lawrence S. Kasevich, P.V. Phan, and Diana Reid, Access 2000 Programming Weekend Crash Course, New York: Wiley, 2000, 0-7645-4688-0 (disk) 614 pages $29.99.

Craig Eddy and Timothy Buchanan, SAMS Teach Yourself Microsoft Access 2000 in 24 Hours, Indianapolis: SAMS , 1999. 0-672-31289-1. 403 pages, $19.99.

Paul Cassell and Pam Palmer, SAMS Teach Yourself Microsoft Access 2000 in 21 Days, Indianapolis: SAMS, 1999. 0-672-31292-1 (disk) 785 pages, $29.99.

General ESRI Software

Scott Hutchinson, Inside ArcView GIS 8.3, Thomson/Delmar Learning, 2004, 0-7668-3475-1. 510 pages.

Maribeth Price, Mastering ArcGIS, NY: McGraw-Hill, 2004. 0-07-286543-1. 580 pages.

David M. Theobald, GIS Concepts and ArcView Methods, Conservation Planning Technologies 0-9679208-1-7

David M. Theobald, GIS Concepts and ArcGIS Methods, Conservation Planning Technologies 0-9679208-2-5

Other resources and prerequisite: a USB key (minimum 256 M)is required. Access to computers and the World Wide Web are required and available through university facilities. Students are expected to be familiar with computers and to have had previous experience using ArcGIS 8.3 or 9.x and ArcView 3.x. GY 451 Levels One and Two must precede or be concurrent with this course.

Purpose of the course: This course is designed to provide hands on experience using Visual Basic for Applications to program macros and develop custom tailored applications for ArcGIS and Access and other applications is Microsoft Office. Emphasis will be on learning to use the Visual Basic programming skills, to customize these software, and to understand database structure and use.

Computer requirement: ArcGIS and Access are available for student use in the GIS laboratory.

Class homepage: The class homepage will be at and linked to Dr. Hill's homepage at This syllabus will also be linked to the class homepage.

All materials presented in this class are done so with educational goals in mind and are not intended to cause distress or any nature. Please be aware that controversial materials, theories, exhibits, etc. will be presented in this class. If you are unwilling or unable to view these presentations in the educational light in which they are presented, then you need to reconsider your enrollment in this class.

Grading: Three examinations will count 15% of the grade each. Two projects will count for 15%. Daily activities will count 15%. The final portfolio will count 10%. Guaranteed percentage grades will be: above 90% A; 80-90% B; 70-80% C; 60-70% D; below 60% F. Papers without names or with illegible names, and late submissions may earn NO CREDIT.

Reading Assignments: Use the attached schedule to read and work through the assignments BEFORE coming to class.

Examinations: Examinations will contain a variety of questions and question formats including practical hands-on computer work. They may contain both written and oral parts.

Projects: A project in ArcGIS and in Access will demonstrate competence with customization.

Portfolio: When interviewing, a portfolio is needed to demonstrate the GIS and cartographic work that you have undertaken. The final activities in this class will emphasize the maintenance of this document.

Back-Up your work routinely to your USB key or CD.

Attendance: No specific attendance records will be kept. Attendance is expected and the benefits are inherent. Daily activities will be assigned in class. If you miss one of these activities, outline a chapter in one of the supplemental books. You are also expected to work on the computer assignments outside of class time, although a portion of the class sessions will be devoted to computer work.

Class membership: Class members are expected to answer and ask questions, be involved in activities, and to facilitate an educational academic atmosphere. Proper attitude and behavior are expected. At all times presence should facilitate a smooth flow of intellectual ideas, knowledge, and intelligent discussion. Failure to contribute or promote this important goal will risk grade penalties. Computer laboratory rules are to be strictly adhered to and unauthorized manipulation of the systems will risk removal of access privileges.

Additional Comments: During class sessions, other bonus points might be offered. These are only available to the students in attendance that day. Bonus credit is possible for exceptional meritorious performance or behavior in all categories of grading. No individual extra credit papers, projects, or activities are planned. See Dr. Hill with any questions.

Academic Dishonesty: Academic dishonesty is defined to include any form of cheating or plagiarism. A discussion of the topic is set forth in the student handbook. Working and studying with classmates are beneficial and to be encouraged. Copying work is not to be confused with comparing work and discussing similarities and differences. You are responsible for both understanding answers submitted and the completion of the materials.

You will need: Bring ALL of your texts, class notes, paper, pencil, and other related materials to each class meeting.

Questions or problems: Please contact the professor. Asking questions is an extremely important part of the learning process.

Class Schedule: Use the outline provided to complete the assigned reading BEFORE class on the designated dates. Specific readings generally will not be announced in class.

COURSE OUTLINE (Tentative*) GIS Programming and Customization Advanced Cartography/GIS Level 3 S09

week 1 intro.

1, 2week 8
Examination 2 (March 2)
week 23, 4
work out your plan for Access
5, 6week 9
database work
week 37, 8

9, 10week 10

week 4

11, 12week 11

week 5
Examination (Feb. 9)

13, 14week 12

week 615, 16
17, 18week 13

week 719, 20

Presentation (April 15)

week 14

*Any major changes to this schedule will be announced in class.

No grades will be posted or available from the instructor by telephone. All grades are final at noon CST on April 20, 2009.