---

Class Location & Times: This is a three-credit course that runs for sixteen weeks – from 2 September through 16 December. The class will be a hybrid class which will meet in the classroom roughly every other week, after the first month. In “off” weeks, assignments will be submitted electronically.

Catalog Description: Introduction to customization, automation and integration of Microsoft Office applications using Visual Basic for Applications. Teaches programming logic, principles and techniques. Prerequisites: CIT 201B and CIT 202B or equivalent strong working experience with Microsoft Office. No previous programming experience required.

Textbook: You will have the option of focusing on Access or Excel. Select one of the following books:

• Julitta Korol, Access 2007 Programming By Example with VBA, XML and ASP
  ISBN 9781598220421
• Julitta Korol, Excel 2007 VBA Programming with XML and ASP
  ISBN 9781598220438

Software: This course will focus on development of applications using Office 2007.

Data Files: The source files for exercises in the textbook can be downloaded from

• www.wordware.com/files/access07
• www.wordware.com/files/excel2007

Course Objectives: When you successfully complete the course, you will be able to

• Record and modify macros to automate frequently performed tasks in Excel and Word
• Use the Visual Basic Editor to write and debug procedures for MS-Office applications
• Use the Object Browser to locate information about objects and their properties, methods and events
• Summarize program requirements using pseudo code or flow charts
• Write procedures which include the programming structures of sequence, selection and repetition
• Write procedures which manipulate application objects
• Incorporate user-friendly dialog boxes and user forms in programs
• Write procedures to automate charts and reports.

Measurement of Objectives: You will know you are meeting the course objectives stated above as you successfully

• complete the assignments that teach and reinforce the skills and techniques covered in the course,
• attend class and participate in classroom activities, and
• complete projects that require you to demonstrate mastery of concepts and skills.

All of these activities result in points that are accumulated during the semester. The final point total determines the grade you earn.

Grading Policy: The following are the requirements of the course, their weights and the minimum accumulated points for each letter grade:

Requirements	Points	Letter Grade	Minimum Points
In-class Activities	100	A	540
Exam I	75	B+	490
Exam II	75	B	450
Homework	150	C+	400
Application Project	200	C	360
Total	600	D	300

Student Behavior

Ground Rules: You and your fellow students want to get the most out of this course. This will be possible only if everyone follows these guidelines:

• Treat fellow students and your professor with courtesy and respect.
• Arrive to class on time and ready to get to work and to learn.
• Turn off cell phones and beepers during class. Cell phones and any other “messaging” devices must be put away during class time.
• Safeguard classrooms and computers by not eating or drinking in the classroom.
• Use classroom computers for class work – no surfing the Internet, no reading e-mail, no playing games, etc. during class time.

Academic Honesty: According to the Schedule of Classes, “CSN demands a high level of academic behavior. Acts of academic dishonesty including plagiarism and cheating, are regarded as very serious offenses.” In this class any academic irregularities will result in a grade of ZERO for the specific test/assignment.

Note: If you have any concerns about this course and/or me, please contact me first. If I cannot resolve your issue, please contact the CET department office at 651-4660 and speak to the department chairman. You will remain anonymous and all communications will be strictly confidential. Please DO NOT wait till the last minute to make your concerns known to me and/or to the department chairman.

Student Resources

Disability Resource Center: If you have a documented disability that may require assistance, you will need to contact the Disability Resource Center (DRC) for coordination of your academic accommodations. The DRC is located in Student Services on each campus. The phone numbers for each DRC office are: West Charleston 651-5644, Cheyenne 651-4045, and Henderson 651-3795. For students that would like to perform community service or earn extra money, stop by the DRC to fill out a job interest card. This office hires students as note takers, proctors, scribes, and lab assistants as needed.

The Reentry Program: This program assists students pursuing an Associate of Applied Science Degree and/or Certificate programs at CSN with a special emphasis on individuals pursuing non-traditional occupations. To be eligible the student must complete a FASFA each year, declare an AAS degree or certificate program, participate in required meetings, maintain adequate academic progress & have demonstrated financial need. Services include: Career guidance & exploration, information on non-traditional occupations, mentoring and academic advisement, community assistance referrals, Academic & Life Strategies workshops, employability workshops, scholarships for tuition and books, assistance with transportation, uniforms and tools, Textbook Assistant Loan Program. The ReEntry Program phone numbers are Cheyenne 651-4700; Charleston 651-5089; Henderson 651-3174.

Tutorial Services: All CSN students are allowed 4 hours of free tutoring per one credit of coursework. Students enrolled in this course are entitled to 12 hours of free tutoring. To make arrangements for this benefit, you must take your semester schedule to Tutorial Services at the campus of your choice. The earlier you apply for help, the more likely that you will succeed.

Retention/Student Success Services: The Office of Student Retention (651-2626 at Cheyenne, 651-7367 at West Charleston, and 651-3103 at Henderson) offers a wide array of services and programs to help make your experience at CCSN a successful and rewarding one. Among them are:

• Coyote Student Coaches - Free Tutoring on a walk-up basis during posted hours. Student Coaches are available in the D lobby at the West Charleston campus, in the student Lounge at the Cheyenne campus, and in the C building at the Henderson campus.
• Success Planning Appointments - The staff of the Retention Office is committed to helping you succeed at CSN by sitting down with you, assessing your needs and getting you plugged in to CSN's many resources.