Contents
IT&F: Class Schedule
| Date | Topic | Deck | How to prepare & Homework due |
|---|---|---|---|
| Tue 1/13 | Welcome to Information Technology and Finance: what you will learn, skills for your career |
Deck01 | Browse this web site. Bring to class any questions you might have. |
| Part I : Acquiring Business Process Automation Skills | |||
| Thu 1/15 | Foundational technology concepts. Recording processes with the macro recorder |
Deck02 |
H01 is due at the beginning of class Check your email and join the FinTech Group |
| Tue 1/20 | Modeling process: Activity diagrams |
Deck03 |
H02 |
| Thu 1/22 | How programs work: Loops |
Deck04 |
H03 - Orange words |
| Tue 1/27 | How programs works: Function calls CLASS MOVED ONLINE - SAME TIME |
Deck05 |
H04 - Orange words |
| Part II : Acquiring Business Intelligence (BI) Skills for Finance | |||
| Thu 1/29 | BI tools: SQL and DBMS |
Deck06 |
H05 - Orange words (every time from now on) |
| Tue 2/3 | Retrieving business data (SQL + VBA + Excel): Canned queries | Deck07 |
H06 |
| Thu 2/5 | Retrieving business data: Dynamic queries | Deck08 |
H07 |
| Tue 2/10 | Managing business data: Non-queries | |
H08 |
| Thu 2/12 | Data Quality: data cleaning I | |
H09 |
| Tue 2/17 | Data Quality: data cleaning II | |
H10 |
| Thu 2/19 | BI Tools: Pivot tables | |
H11 - Reading #5 |
| Part III: Acquiring Financial Analytics Skills | |||
| Tue 2/24 | Introduction to the Hedge Tournament |
H12 | |
| Thu 2/26 | Stock and Options transactions fundamentals | H13 | |
| Spring Recess | |||
| Tue 3/10 | Financial Metrics |
H14 | |
| Thu 3/12 | Transactions: Stocks |
H15 | |
| Tue 3/17 | Transactions: Options |
H16 | |
| Thu 3/19 | Option valuation: the Black-Scholes model |
H17- Reading #6 | |
| Tue 3/24 | Delta Hedging |
H18 | |
| Thu 3/26 | Implicit volatility |
H19 | |
| Tue 3/31 | Algo trading: delta hedging of a portfolio family |
H20 | |
| Thu 4/2 | The recommender |
H21 | |
| Tue 4/7 | Simulation |
H22 | |
| Thu 4/9 | Syncing |
H23 | |
| Tue 4/14 | Tweaking your robotrader |
H24-The last! | |
| Thu 4/16 | Tweaking your robotrader | ||
| Tue 4/21 | No regular class: All-day software clinic | ||
| Thu 4/23 | No regular class: software clinic | ||
| The McIntire Hedge Tournament: 4/23 - 6pm-9pm | |||
| Tue 4/28 | Results, ranking, pictures, and the history of the Tournament - regular class hours | ||