Working with Excel and VBA
QAC 151
Spring 2022
| Section:
01
|
Many of us know Excel for its spreadsheets: a quick and easy way to store some information, share it, and maybe make some charts. The goal of this course is to show you the more advanced features of Excel. We will write code in Visual Basic for Applications (VBA), learn how to import data from external databases and Web-based resources, create custom menus to interact with a user, and examine how Excel can be used in business decision making. |
|
| Credit: .5 |
Gen Ed Area Dept:
NSM QAC, SBS QAC |
| Course Format: Laboratory Course | Grading Mode: |
| Level: UGRD |
Prerequisites: None |
|
Fulfills a Requirement for: (INFO-MN) |
|
Past Enrollment Probability: Less than 50% |
| SECTION 01 - 3rd Quarter | | Special Attributes: CQC |
Major Readings: Wesleyan RJ Julia Bookstore
John Walkenbach, EXCEL 2013 BIBLE, John Wiley and Sons, 2013
Reference Manuals, on-line custom materials and video tutorials
Reference Manuals, on-line custom materials and video tutorials
|
Examinations and Assignments:
This course will have weekly homework assignments and a final project. The book for the course is available online through the Wesleyan library. Starting with week 2, you must come to class prepared and be familiar with the readings. |
Additional Requirements and/or Comments:
Note for Mac users: This class will be using Excel for PCs. It is possible that some of the more OS-specific functions will work differently on your Mac. In addition, the Solver Add-in, which we will use in week 6, was dropped from the Excel for Macs release in 2009, but was reintroduced in 2011.
If you are considering taking this course, you must be sufficiently skilled in Excel. As a review, please familiarize yourself with the materials from the lynda.com online instruction videos listed below. Wesleyan University has an institutional subscription with lynda.com and you should be able to view the videos if you are on the campus network.
Excel 2013 Essential Training:
http://www.lynda.com/Excel-tutorials/Excel-2013-Essential-Training/116478-2.html
Excel 2013: Managing and Analyzing Data:
http://www.lynda.com/Excel-tutorials/Excel-2013-Managing-Analyzing-Data/15! 8657-2.html
Excel 2013: Charts in Depth:
http://www.lynda.com/Excel-tutorials/Excel-2013-Charts-Depth/135358-2.html
Excel 2013: Pivot Tables in Depth:
http://www.lynda.com/Excel-tutorials/Excel-2013-Charts-Depth/135358-2.html
Excel 2013: Managing Multiple Worksheets and Workbooks:
http://www.lynda.com/Excel-tutorials/Excel-2013-Managing-Multiple-Worksheets-Workbooks/158663-2.html
Please Note: The course meets the first half of the semester while QAC 155 meets during the second half of the term. |
| Instructor(s): Oleinikov,Pavel V Times: .M..... 07:10PM-10:00PM; Location: ALLB204; |
| Total Enrollment Limit: 19 | | SR major: 0 | JR major: 0 | | |
| Seats Available: -12 | GRAD: X | SR non-major: 5 | JR non-major: 5 | SO: 5 | FR: 4 |
| Drop/Add Enrollment Requests | | | | | |
| Total Submitted Requests: 13 | 1st Ranked: 0 | 2nd Ranked: 4 | 3rd Ranked: 0 | 4th Ranked: 2 | Unranked: 7 |
|
|