Microsoft Visual Basic for Applications, by Diane Zak, Thomson Learning/Course Technology. ISBN 0-619-00020-1

Note: Application Lessons: Excel, Word, and Access will be used each week.

Week	Tutorial	Topic(s)
1	1	Application and Programming Concepts; Using the Visual Basic Editor
2	2, 3	The Object Model; Object Variables
3	4	String Variables
4	5	Date Variables; Test 1
5	6	Numeric Variables
6	7	The Selection Structure
7	8	The Select Case Statement and the MsgBox Function
8	9	The Repetition Structure and the With Statement
9	10	More on the Repetition Structure and String Functions
10	11	Built-In Dialog Boxes and the Office Assistant; Test 2
11	12	Custom Dialog Boxes
12	13	Option Button, Check Box, and List Box Controls
13	14	Automation
14	15	Automation and Error Trapping
15	→	Final Exam

1. Develop skills in solving problems by using a computer. I, II, III
2. Demonstrate basic fundamentals of Microsoft Windows concepts. III
3. Analyze problems, then design and code BASIC statements to form working graphic-based programs. I, II, III, V, VI, XV
4. Develop, code, debug and modify input/output/control/visual features. V, VI, VII
5. Apply Visual Basic programming skills to develop real world applications in Word, Excel, and Access. VI, X, VI, XII, VIII
6. Understand the syntax and semantics of three BASIC programming language variations. II, III, IV, VI, VII

1. Use BASIC tools to create a well-documented application based on client input or industry research. Communication Outcome, Technological Literacy, Transitional Strategy, Mathematics, Active Learning
   
   
2. Use professionally accepted methods and materials in completion of programming and application enhancements. Technological Literacy, Transitional Strategy, Mathematics, Active Learning
   
   
3. Use command line and graphical user interface to design working BASIC projects. Technological Literacy, Mathematics Outcome, Active Learning
   
   
4. Learn to analyze and solve problems using structured analytical techniques. Technological Literacy, Mathematics Outcome, Active Learning
   
   
5. Use professional tools to produce software components and documentation. Technological Literacy, Transitional Strategy, Active Learning
   
   
6. Plan the logic for complete business and technical programs. Technological Literacy, Mathematics Outcome, Active Learning, Communication Outcome

Upon successful completion of this course, the student should be able to

1. Recognize basic data types. A, B
2. Use arithmetic, logical and conditional operators. A, B, D
3. Demonstrate the proper use of the editor, window environment and program operation procedures. (A, E)
4. Identify and properly use the keyboard, mouse and function key set. (A, B)
5. SAVE and Back-Up all programs developed in the course on their own disk and electronically submit final programs to the instructor as required to meet timelines established. (A, B, E)
6. Demonstrate working program commands, icons, operators, arguments, variables and controls. (B, C, D, E)
7. Demonstrate correct program syntax and design. (B, C, D, E)
8. Demonstrate use of program statements to match logic requirements. (B, C, D, E)
9. Demonstrate a working knowledge of Basic program language terms, statements, properties, methods, events, controls, forms and functions. (B, C, D, E)
10. Debug/refine software and meet all (turn-in) requirements. (C, D, E)
11. Develop end-products which are visually correct and which function according to given specifications. (B)
12. Create fully functioning client-based problem solving programs complete with documentation per instructor specifications. (B, C, D, E)

1. Testing Procedures:
   Students are evaluated primarily on the basis of tests and laboratory assignments. Each instructor must provide full details the first week of class via a syllabus supplement.
   
   Three tests will be given. Tests will cover the terminology, concepts and material presented in class. Test will be short answer format. Tests are not to be missed without a valid excuse.
   
   
2. Laboratory Expectations:
   Lab attendance is required. Assignments will be given and must be completed and handed in at the designated date. The student is expected to turn in all required documentation for each lab. Use of online resources is encouraged other than when taking a test. See “Other Evaluation Methods” below.
   
   
3. Field Work: N/A
   
   
4. Other Evaluation Methods:
   Projects will be given each week. Points will be deducted for being late, missing key components, improper logic and not using correct design standards.
   
   
5. Grading Scale:

   93 – 100%	A
   88 – 92%	B+
   83 – 87%	B
   78 – 82%	C+
   73 – 77%	C
   65 – 72%	D
   Below 65%	F

1. 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. [NOTE: No differentiation is noted for excused/unexcused absences. These will be treated as an absence.]
   
   
2. Academic Dishonesty:
   Plagiarism, cheating, and other forms of academic dishonesty are prohibited. Students guilty of academic misconduct, either directly or indirectly through participation or assistance, are immediately responsible to the instructor of the class. In addition to other possible disciplinary sanctions which may be imposed through the regular Pellissippi State procedures as a result of academic misconduct, the instructor has the authority to assign an F or a zero for the exercise or examination or to assign an F in the course.
   
   
3. Computer Usage Guidelines:
   College-owned or –operated computing resources are provided for use by students of Pellissippi State. All students are responsible for the usage of Pellissippi State's computing resources in an effective, efficient, ethical and lawful manner.
   
   
4. Accommodation for Disabilities:
   If you need accommodations because of a disability, if you have emergency medical information to share, or if you need special arrangements in case the building must be evacuated, please inform the instructor immediately. Please see the instructor privately after class or in his/her office. Students must present a current accommodation plan from a staff member in Services for Students with Disabilities (SSWD) in order to receive accommodations in this course. Services for Students with Disabilities may be contacted by going to Goins 127 or 131 or by phone: 694-6751(Voice/TTY) or 539-7153.