|
MASTER SYLLABUS |
|||||||||
|
CSIT 1200 |
|||||||||
| Class Hours: 3.0 | Credit Hours: 4.0 | ||||||||
| Laboratory Hours: 3.0 | Revised: Fall 04 | ||||||||
| Catalog Course Description: | |||||||||
| A study of Windows graphic interface development through Visual Basic programming language. The learner will use VBA (Visual Basic for Applications) for customizing applications such as Word, Excel, Access, MS Project, Visio, AutoCAD, accounting, and helpdesk. Topics include VBA visual programming tools, recording and modifying macros, debugging/error trapping, integrating with Internet and Intranet solutions. | |||||||||
| Entry Level Standards: | |||||||||
| The entry-level student is expected to have a basic familiarity with computers. The student should be able to use a standard keyboard and maintain 23 words per minute error-free typing rate. The student must have writing, verbal and English language skills at the college entry level. | |||||||||
| Prerequisites: | |||||||||
| n/a | |||||||||
| Corequisites: | |||||||||
| CSIT 1110 or consent of the instructor | |||||||||
| Textbook(s) and Other Course Materials: | |||||||||
| Visual Basic for
Applications by Diane Zak, Course Technology-Thompson Learning, 2001.
ISBN 0-619-00020-1 |
|||||||||
| I. Week/Unit/Topic Basis: | |||||||||
| Week | Topic | ||||||||
| 1 | Using the Visual Basic Editor, Tutorial 1 | ||||||||
| 2 | The Object Model, Tutorial 2 | ||||||||
| 3 | Object Variables, Tutorial 3 | ||||||||
| 4 | String Variables, Tutorial 4 | ||||||||
| 5 | Date Variables, Tutorial 5 | ||||||||
| 6 | Numeric Variables, Tutorial 6 | ||||||||
| 7 | Selection Structure, Tutorial 7 | ||||||||
| 8 | The Select Case Statement and the MsgBox Function, Tutorial 8 | ||||||||
| 9 | The Repetition Structure and the With Statement, Tutorial 9 | ||||||||
| 10 | More on the Repetition Structure and String Functions, Tutorial 10 | ||||||||
| 11 | Built-in Dialog Boxes and the Office Assistant, Tutorial 11 | ||||||||
| 12 | Custom Dialog Boxes, Tutorial 12 | ||||||||
| 13 | Option Button, Check Box, and List Box Controls, Tutorial 13 | ||||||||
| 14 | Automation and Error Trapping, Tutorial 14 | ||||||||
| 15 | Final Exam Period | ||||||||
| II. Course Objectives*: | |||||||||
| A. | Develop skills in solving problems by using a computer. I, II, III | ||||||||
| B. | Demonstrate basic fundamentals of Microsoft Windows concepts. III | ||||||||
| C. | Analyze problems, then design and code Visual BASIC statements to form working graphic-based programs. I, II, III, V, VI, XV | ||||||||
| D. | Develop, code, debug and modify input/output/control/visual features. V, VI, VII | ||||||||
| E. | Apply Visual Basic programming skills to develop real world applications in Word, Excel, and Access. VI, X, VI, XII, VIII | ||||||||
| F. | Understand the syntax and semantics of Visual BASIC programming language. II, III, IV, VI, VII | ||||||||
| *Roman numerals after course objectives reference goals of the CSIT program. | |||||||||
| III. Instructional Processes*: | |||||||||
| Students will: | |||||||||
| 1. | Use Visual BASIC tools to create a well-documented application based on client input or industry research. Communication, Problem Solving and Decision Making, technological Literacy, Personal Development, Transitional Strategy, Active Learning | ||||||||
| 2. | Use professionally accepted methods and materials in completion of applications. Technological Literacy, Personal Development, Transitional Strategy, Active Learning | ||||||||
| 3. | Use graphical interface and animation, and create a link from Visual BASIC project to a web site. Technological Literacy, Information Literacy, Numerical Literacy, Active Learning, Personal Development, Problem Solving and Decision Making | ||||||||
| 4. | Use the Internet as a medium for obtaining documentation and instruction, and for submitting assignments. Communication, Technological Literacy, Information Literacy, Personal Development, Transitional Strategy, Active Learning | ||||||||
| 5. | Practice elements of the work ethic such as punctuality, professionalism, dependability, cooperation, and contribution. Personal Development | ||||||||
| 6. | Learn to analyze and solve problems using structured analytical techniques. Technological Literacy, Information Literacy, Numerical Literacy, Active Learning, Personal Development, Problem Solving and Decision Making | ||||||||
| 7. | Use professional tools to produce software components and documentation. Technological Literacy, Personal Development, Transitional Strategy, Active Learning | ||||||||
| 8. | Plan the logic for complete business programs. Technological Literacy, Information Literacy, Numerical Literacy, Active Learning, Personal Development, Problem Solving and Decision Making, Communication. | ||||||||
| *Strategies and outcomes listed after instructional processes reference TBR's goals for strengthening general education knowledge and skills, connecting course work 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 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 the Visual 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 windows which are visually correct and which function according to specifications. B | ||||||||
| 12. | Create fully functioning window driven client-based problem solving programs complete with documentation per instructor specifications. B, C, D, E | ||||||||
| *Letters after performance expectations reference the course objectives listed above. | |||||||||
| V. Evaluation: | |||||||||
| A. Testing Procedures: | |||||||||
| A minimum of three tests is recommended. Tests will cover material presented in class. Tests are not to be missed without a valid excuse. | |||||||||
| B. 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. | |||||||||
| C. Field Work: | |||||||||
| n/a | |||||||||
| D. Other Evaluation Methods: | |||||||||
| Class participation, quizzes and homework will also comprise the final grade for the course. | |||||||||
| E. Grading Scale: | |||||||||
| 93 – 100
A
88 – 92 B+ 83 – 87 B 78 – 82 C+ 73 – 77 C 65 – 72 D Below 65 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. [NOTE: No differentiation is noted for excused/unexcused absences. These will be treated as an absence.] (Pellissippi State, 2004-2006 Catalog, page 83) | |||||||||
| B. 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. (Pellissippi State, 2004-2006 Catalog, pages 62-63) | |||||||||
| C. Accommodations for disabilities: | |||||||||
| If you
need accommodation 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. Privately
after class or in the instructor's office.
To request accommodations students must register with Services for Students with Disabilities: Goins 127 or 131, Phone: (865) 539-7153 or (865) 694-6751 Voice/TDD. |
|||||||||
| D. Other Policies: | |||||||||
| 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. (Pellissippi State, 2004-2006 Catalog, pages 67-70) |
|||||||||