Spreadsheet-Based Applications with Visual Basic
Credit Hours: 3 hours
Prerequisites: COMP 1200 or higher
Instructor: Dr. Daniela Marghitu
Graduate Teaching Assistant: Chetan Prakash Somani
- COMP3010 Custom Package - ISBN #0133943003 (Can be purchased on student discounted rate from Auburn University book store at http://www.aubookstore.com/)
- VBA and Macros for Microsoft Excel 2013 by Bill "Mr. Excel" Jelen Que.
- MYITLAB - http://myitlab.com/Prentice Hall/Pearson Education
In the COMP 3013 Spreadsheet-Based Applications with Visual Basic course, students develop the ability to design and implement software applications using technologies that include programmable spreadsheets. Students are able to develop software tools that interface with production systems and embed analytical models into these systems. They are introduced to the design and implementation of applications such as simulations, spreadsheet front-ends for modeling, and multimedia applications.
The topics in this course provide a thorough knowledge of the skills on the following core topics.
- Reinforcement of Excel 2013 concepts and skills
- Introduction to Object Oriented Programming concepts and skills
- Working with Excel and Macros
- Working with Excel and VBA
- Introduction to VBA
- VBA Variables, Data Types and constants
- Working with Ranges
- Looping and Flow Control
- Working with User-Defined Functions
- Event Programming
- Application Development with Excel and VBA
In this course, students will develop the ability to design and implement software applications using technologies that include programmable spreadsheets and databases. Students will be able to develop software tools that interface with production systems and embed analytical models into these systems.
Two course pre-tests will be administered at the beginning of the semester covering the previous Excel and Programming knowledge required for this course. Class Assignments will be made available once all students will take these pre-tests.
The course consists of several topics spread across the semester including three proctored examinations. There are 8 lab assignments, 6 home assignments and MyITLab modules for training. Learners are required to study from the lecture notes, and do the assigned reading, training sessions and home and lab assignments. More information is given about these activities in the ‘Course Requirements’ section of the syllabus and also in the course website on Canvas.
All examinations will be proctored. The proctors for the examinations should be recognized by the Distance Learning & Outreach Technology (DLOT) office of Auburn University. More information about the proctors is given in the ‘Examination Process’ section of the syllabus.
A variety of media will be used to communicate among class members and with the instructor. Most of these media will be part of the software Auburn University supports for distance course delivery, that is, Canvas software. Canvas includes many types of communication tools, including online submission of assignments, email among class members, online discussions, and chats. The students will use some or all of these to complete class requirements.
Lecture and content materials will be provided in Canvas in the form of PowerPoint handouts with voiceover.
The course training modules are available at Prentice Hall MyITLab website MyITLab (http://www.myitlab.com/). The students receive the access code when they purchase a custom package of the text book from the Auburn University book store.
- Case Study:
Students will be organized in groups and assigned case study, which is worth 150 points, on "Creating a management application" using all the accumulated knowledge and skills.
Lab Assignments are worth 10, 20 points. Students will train themselves using the required MyITLab training and do their homework and lab assignments. Lab Assignments will be the focus of the weekly class labs whereas students will need to work mostly on their own for the home assignments. Pop-up quizzes will be administered at lab time from the lab and home assignments content.
- Examination 1:
Examination 1 is designed to give an opportunity to review all that the students have learned until this point in time. It includes 50 multiple-choice questions for 50 minutes. Reviewing all lectures notes and examples, and working diligently on lab assignments and MyITLab modules will be helpful. This exam will be available on Canvas.
- Examination 2:
Examination 2 is designed to give an opportunity to review all that the students have learned until this point in time. It includes hands on exercises for 50 minutes. Reviewing all lectures notes and examples, and working diligently on lab assignments and MyITLab modules will be helpful. This exam will be available on Canvas.
- Final Examination:
This final examination will cover all of the material for this course. The examination is designed to give an opportunity to review all that the students have learned from the beginning to this point in time. It is comprehensive and it includes multiple-choice questions as well as hands-on exercises for 2 ½ hours. Reviewing all lectures notes and examples, and working diligently on lab assignments and MyITLab modules will be helpful. This exam will be available on Canvas.
- Performance Evaluation:
The students work in this course will be evaluated on the basis of the assignments and Examinations. Examinations will include material from the assigned readings in the text, the assigned exercises, and class lectures. You should expect to do well on the exams only if you read study and understand the assigned readings in the text and complete the assigned exercises. Detailed information about examinations can be found on the Exams Info web page in the course website. The MyITLab skill modules will be made available online at all times. The final course average will be computed as follows:
|Home & Lab Assignments + Case Study||40%||400 pts|
|Exam 1||10%||100 pts|
|Exam 2||20%||200 pts|
|Final Exam||30%||300 pts|
The final course grade will be determined by the final class average using the scale below, with the following constraint: to earn a passing grade in this course, a student must earn a passing grade for the assignment average.
|Grade Percent||Letter Grade|
|90% or above||A|
|Less than 60%||F|
Students are allowed to redo examinations only upon presenting. Therefore, they should check their work carefully with criteria statements before turning in assignments or examinations. The students will be required to complete the online Course Evaluation Questionnaire before the final course grade is officially recorded.
Prerequisite & Computer Access Necessary:
A computer with Windows 8 or Windows 7 operating system, Microsoft Office 2013 and an internet connection is necessary. Basic Excel and Programming skills are necessary.
Late Submissions and Exams Make-Up:
Assignments late submission will only be allowed with a valid university excuse. This means a Doctor's statement (not an In-Out slip) or other documentation must be provided. An assignment has to be submitted no later than one week after the date covered by the valid university excuse and no later than the last day of class.
Make-up exams will only be given with a valid university excuse. This means a Doctor's statement (not an In-Out slip) or other documentation must be provided. All make-ups will be given at the end of the semester unless other arrangements are made with the instructor. The student is responsible for informing the instructor prior to missing an examination or no later than one week after the examination or skill assessment test official date.
Learners with Disabilities:
Any learner with a qualified disability which requires accommodations should contact The Program for Students with Disabilities, 1244 Haley Center, Auburn University, AL 36849, 334-844-2096 PH, 334-844-2099 FAX. More information is available on their website at http://www.auburn.edu/disability. The office will fax or mail the required forms to learners to apply for services. Learners who have questions to participate in this course should contact the above office in advance to ensure proper accommodations.
Plagiarism and Academic Dishonesty:
Plagiarism is the act of presenting directly or indirectly someone else’s work as your own. Plagiarism is a major type of academic dishonesty and will not be tolerated. Similarly cheating on tests in any way, falsifying bibliographies, fraudulent quotes, and similar practices are intolerable forms of academic dishonesty. The University’s policy for academic misconduct in the Student Code of Conduct will be followed for this course (Tiger Club, pp. 83 and 92). If any questions regarding its contents, the students are expected to contact the instructor.