CIT 261 VBA Programming for Microsoft Office CIT 261 VBA Programming for Microsoft Office This class uses LiveNet. Read the accompanying document: Special Notes for Students Students also need to read the document How Do I Survive this Online Class available from the WebCampus main menu. The rules shown in this document are added to those in this syllabus. Textbook: Microsoft Visual Basic for Applications by Zak. Read about it in the Special Notes for Students. _______________________________________________________________ Vital Questions When does the class begin?This class is taught through the Internet and begins on Jan. 21. Any students who has not contacted the instructor by e-mail message or phone call by Jan. 24 may be dropped from the class. The e-mail message need only say the student is ready to begin. When are assignments due?Check the class schedule for due dates. What if I am absent?This class is intensive and requires attendance and work completed each week. Anyone not in communication with me for any two week period (without prior approval) will have an F grade recorded as the final class grade. The worst part of an online class is procrastination!!! Where are the tests?The traditional class tests are replaced with projects. The midterm project will be worked on by a small group of students. The final project will be an individual effort. What is this individual project?You will be expected to build a working workbook designed to solve a specific problem. it will be worth more than other assignments. It will be due on May 11. More information will be given out half way through the semester. Can I do extra credit to improve my grade?Yes, if your average is below a C and if you have turned in all assignments. It does no good to do extra credit if you are not turning in regular assignments. What version of Office is covered in this class?This class covers Microsoft Office 2003. If you are using Microsoft Office 2007, it will be up to you to convert files to 2003 before turning them in. It will be up to you to figure out how to do the same tasks in ver. 2007. The lessons will cover only ver. 2003. What should I know as I begin this class?This is a second course in Programming and in MS Office. Students should have already worked with programming and with MS Office. Catalog Description: CIT 261 VBA Programming for Microsoft Office (3) The next logical step in Visual Basic programming and involves programming inside the production software: Word, Excel, PowerPoint, and Access. This is probably the most common type of programming in today’s work world. The programming creates more interactivity in the office software. Prerequisites: CIT 132, CIT 202, CIT 203, or instructor’s approval. [N] Course Description: Visual Basic is being used more and more inside office applications, to enhance and customize documents. This course will use Visual Basic for Applications, learned in CIT 129, and apply its use inside all 3 MS Office products. Course Objectives: The Visual Basic Editor and The Object Model Using VBA to customize MS Office documents. /a,b,c Object Variables: object, string, date and numeric /a,b,c The Selection Structure, Select Case Statement and MsgBox Function /a,b,c The For...Next, For Each...Next, and with Statements /a,b,c The Do...Loop Statement and String Functions /a,b,c Built-in Dialog Boxes and the Office Assistant, Custom Dialog Boxes /a,b,c Option button, Check box, and List Box Controls /a,b,c Automation /a,b,c Use on Office application to control a document of a different application type. /a,b,c The above goals will be measured using a combination of: Turn in working VBA programs showing understanding of the principles used to solve the problem. Develop and build working VBA programs as a group. Come up with a need, develop and build working VBA program as an individual. Spring 2008Revision date: Nov. 30, 2007 Instructor: Larry Hyslop Office: High Tech Center- 132 Office hours: M-W, F 10-11 am Great Basin College 1500 College Pkwy. Elko, NV 89801 Phone: 775-753-2305 (office) 753-8095 (home, before 7pm) 775-753-2160 (college fax) Email (outside of WebCampus): larryh (at) gwmail.gbcnv.edu Note: I check my email M-F only. Instructional Methods: The class will be taught by introducing a new skill or concept. The student practices on the computer by going through a tutorial in the book. Assignments are completed and turned in. Assignments: The assignments will consist of exercises from the instructor and/or the book. Each assignment will be graded on a points system. The assignments can be completed on your own time, and will require substantial time spent in the computer lab to complete. Team assignments will require two students to work together in completing a task. Check the WebCampus calendar for due dates. All assignments are due no later than the date listed. In case of absences, arrangements must be made with the instructor. Late assignments will be graded, and then reduced 5 points for each week late. Any assignment not handed in will be recorded as 0 points. Students should keep all messages regarding returned assignments until the grades have been shown on WebCampus. Grading: Each student must complete his/her assignments, individually. If two or more students turn in the same hard copy assignment or collaborate on a test, punitive measures as described in the Rules and Disciplinary Procedures for Members of the University Community will be enforced. See the General Catalog, P. 115, Section 6.3. Cumulative grades will be determined as follows: 100-98 A+ 97-93 A 92-90 A- Worth: 89-88 B+ Assignments: 65% 87-83 B Group Projects: 15% 82-80 B- Individual Project: 20% 79-78 C+ 77-73 C 72-70 C- 69-68 D+ 67-63 D 62-60 D- <60 F Cumulative grading will use + and - on assignments, tests and the final, recorded grade. Some times, and for very good reasons, a student is not able to finish a class, and needs to withdraw from the class. Through week 12: A grade of W (withdrawn) will be recorded for anyone who formally withdraws by meeting with the instructor and filling out a withdraw form. A grade of F will be recorded for anyone who simply does not come to class any more. It is important to realize that for any one withdrawing from the class, the difference between earning an W on the official class record or earning an F is the process of formally withdrawing After week 12: Anyone withdrawing will receive a grade based on all assignments, including those missed. Extra credit may be earned if your grade is currently a D or below. efore doing anything regarding this class, please consult with me. It is my job to assist you in making class decisions. Privacy: Some times during the class, your completed assignments may be displayed for the benefit of the entire class. If this bothers you, please notify me in writing during the first week of class. Special Needs: Any student with a disability needing academic adjustments or accommodations is requested to speak either with me or with the College Counselor, as soon as possible to arrange for appropriate accommodations. Files: A main set of student files will be downloaded from the Internet. Instructions will be part of lesson 1.Any additional files will be sent to students attached to email messages. Perseverance: This is a full semester class requiring considerable time spent on the computer each and every of the 16 weeks. You must be prepared to make this commitment. Getting started: Have your Internet access installed and ready before the semester begins.Call the WebCampus help line to get your username and password set up. Set up your WebCampus access using provided instructions. Remember your login name and password. Enter the WebCampus classroom. Print the file named Read First.Follow its instructions to print this syllabus (if needed) and the first lesson. Follow the instructions in lesson 1.