MIST 7810: Advanced Business Applications
Software (Excel)
JE Aronson
Course Schedule
(Updated only on WebCT)
At the Summit
of Montserrate, Bogotá, Colombia, June 2007
This Course Schedule is tentative.
Topics,
assignments (details in the assignment document),
and due dates are subject to change.
This schedule
is a general plan for the course, not a contract. Unexpected
(and even expected) changes may occur.
This is a 1.5 credit hour course that
meets twice per week for about 7 weeks.
Holidays
and Breaks appear just after
the preceding class day.
THE SPRING 2010 SCHEDULE IS NOT
CONFIRMED.
| Day |
Date Fall 2008 Sanf 109 |
Date Spring 2010 Sanf 109 |
Topic and Text Sections |
| 1 |
T 8/18 |
R 1/7 |
Introductions Course Overview In Class Day 1 Activities [Read the Syllabus, Policies, etc.] |
| 2 |
R 8/20 |
T 1/12 |
Intro to Excel 01 Start Using Excel Today. 1.1 (means Section 1.1 of the text (POAC)) First steps in Excel 1.2 Ranges, Editing, and Spell Checking Basic Problem Solving in Excel. We will cover the basic Excel material through examples. |
| On
your own: 2.2 Formatting the (whole) worksheet: Styles AutoFormat Formatting Printed Output |
|||
| 3 |
T 8/25 | R 1/14 | Intro to Excel 02 Basics of Functions via the Gradebook example. Multiple ways of solving a problem using some functions in different ways. IF(), AVERAGE, VARIANCE, STDEV(), MAX(), MIN(), SUM(), SUMIF(), COUNT(), COUNTIF(), LOOKUP() and data manipulation. Conditional Formats (Chapter 7) MLK Day is Monday, 1/18 |
| 4 |
R 8/27 |
T 1/19 | 3.1 Basics of Formulas and
Functions 01 Important functions include VLOOKUP, INDEX, MATCH, Logical Functions including IS, to determine the state of cells and cell values. See the Functions01 Worksheet Intro page and Tabs for these topics: Math and Stat Functions Random Functions (including financial simulation) Financial Functions Logical Functions (including 'in-line' logic and IF() ) Information Functions (IS() indicates a cell's status) Lookup and Reference (including VLOOKUP, INDEX, MATCH, and Data Validation) Date and Time Functions and Formulas Text Functions |
| 5 |
T 9/1 |
R 1/21 | 3.2 Formulas and Functions 02 Plus Introduction to What If Analysis and Goal_Seek (Chapter 10) |
| 6 |
R 9/3 |
T 1/26 | Formulas and Functions 03 |
| 7 |
T 9/8 | R 1/28 | Formulas and Functions 04 7 Using Advanced Functions (Later: Conditional Formatting and Filtering) Practice Exam 1 |
| 8 |
R 9/10 | T 2/2 | Exam
1 (Basics, Formatting, Functions, Regression) |
| 9 |
T 9/15 | R 2/5 | Exam 1 Discussion 4.1 Basic Charts and Graphics 4.2 Additional Charting Techniques Forecasting directly in Charts |
| 10 |
R 9/17 | T 2/9 | Regression Analysis (linear,
multilinear, and nonlinear) 01 (Not in textbook. See notes.) |
| 11 |
T 9/22 | R 2/11 | Regression Analysis (linear, multilinear, and nonlinear) 02 |
| 12 |
R 9/24 | T 2/16 | (Data) Tables (Lists) 5.1, 5.2 Tables (Lists), More Tables (including 7 Filtering and Conditional Formatting) |
| 13 |
T
9/29 |
R 2/18 | 5.3 Pivot Tables and Pivot Charts |
| 14 |
R 10/1 |
T 2/23 | 11 Connecting to External
Data Review |
| 15 |
T 10/6 |
R 2/25 |
Exam
2 (Comprehensive, but the focus is on Charts, |
| Final Week | Final Week | Nothing Scheduled | |
| Topic
worth Covering: 10.1, 10.2 Optimization with trial-and-error and Goal Seek, and Solver in the Analysis Tool Pack Optimization 2: Solver If time, start |
There is not enought time in the course to cover even a rudimentary
development of VBA (Visual Basic for Applications; i.e., macros).
The text's Chapter 12: "Expanding Excel with Visual Basic for
Applications," is an excellent introduction to programming and VBA. If
you ever need to develop a program within Excel, this chapter is a
complete programming class, using VBA as the implementation vehicle.
M T W R F S = Monday, Tuesday, Wednesday, Thursday, Friday, Saturday