1 | vhs | Date | Topics | Read | Assg | Notes/Resources | |||
---|---|---|---|---|---|---|---|---|---|
2 | [Schedule] | Assignments - Highlighted in blue - not always highlighted - see due dates 'pink' for details & descriptions | |||||||
3 | Due Dates - Highlighted in pink (subject to change). | Links at due dates | |||||||
4 | Logictics/Admin - Highlighted in yellow: Our class meets Mon, Tue and Friday | See UGA calendar ( here ) for important dates | |||||||
5 | |||||||||
6 | Please use piazza messaging for questions, once you are set up there. Private piazza messages if you need it to be private | ||||||||
7 | 1 | Mon, Jan 10 | -- 1st Week: Am I in the right class - Discuss Framworks : Excel & Python | ||||||
8 | Mo | HW 1 assigned (try all different assignment submission methods) | HW1 | HW1 Assigned (see link @ due date below) - Sun Jan 16, 2022 | |||||
9 | Mo | Course Introduction: Syllabus discussion | High Level - we will do these later in the Semester | ||||||
10 | We | Tutorial: Submit an assignment, create a Youtube Video, post a link | Screencast, Youtube creating demonstration, posting a video on piazza | ||||||
11 | Fr | Excel Framework - Installation and Introduction | Excel warm-up, compute mean, sum, subtraction | ||||||
12 | Fr | Lab - Test out Excel & Start Watching Movie - watch rest at home | Freakonomics Movie | ||||||
13 | Fr | --- Drop/Add Ends : Friday Jan 14 | Fri: Jan 14- Last day to drop (or add). *** 11:59 PM. *** | ||||||
14 | 2 | Mon, Jan 17 | |||||||
15 | Su | HW 1 due (please note submitting via odin is being replaced by eLC folder) | Due 11:59 PM Sunday | ||||||
16 | Mo | MLK Day - No Class. UGA Holiday | |||||||
17 | We | Analyzing Data | xlsx | ||||||
18 | Fr | Lab: Analyzing Data (different data from Wednesday) | Lab | ||||||
19 | Sat | HW2 Assigned - an extension to lab | |||||||
20 | 3 | Mon, Jan 24 | |||||||
21 | Mo | Work on HW2 together. | HW2 | AND, IF, MAX, COUNTIF() | |||||
22 | We | COUNTIF(), Charts (histograms), and ARRAYS | |||||||
23 | Fr | Lab - Categorical - Histograms | Lab | ||||||
24 | Fr | Summary 1 Assigned : Chapter 1: Freakonomics - 1 page Summary (due Tuesday Feb 1) | |||||||
25 | Fr | HW 2 due (submitting via eLC) 10% is from last Friday's Lab. | Due 11:59 PM Friday (extension) - | ||||||
26 | 4 | Mon, Jan 31 | |||||||
27 | Mo | Ch 1: Freakonomics Discuss Real World Data & Benford Law - | Ch1 | We will lower our pace this week and work on HW3, and discuss Ch1 in text | |||||
28 | Mo | Discuss Benford's Law (Please read//skim Wikipedia page) | RD | Benford's Law of Digits | |||||
29 | Mo | HW3: Assigned. Benford Law Patterns in the Real World | |||||||
30 | We | Work on HW3 in class. | |||||||
31 | Th | Summary 1 Due : Reading Assignment Chapter 1 | |||||||
32 | FR | Lab: HW 3 - continue working on HW3 (not upcoming HW4) | HW3 | Finish Work on HW3 - Find Data Sets | |||||
33 | Su | HW 3 Due (eLC) 10% from labs (checking progress) | Due 11:59 PM Sunday Feb 6. | ||||||
34 | 5 | Mon, Feb 07 | |||||||
35 | Agenda: | Freakonomics Discuss Ch 2 / Intro to Statistics & Coin toss revisit | |||||||
36 | Mo | Ch 2 Freakonomics Discussion (prepare for summary) | |||||||
37 | We | Intro to Statistics: Variables of Statistics | |||||||
38 | We | 1.xls | 2.xls | Historgrams w/ Bins & Correlation | |||||
39 | Th | Summary 2 Due : Reading Assignment Chapter 2. | |||||||
40 | Fr | Cyberday - no in-class meeting. Will be a do at home lab. | pHW4 | Practice for HW4. - create histograms - HW4 will be an extension of preH | |||||
41 | HW 4 is due next week - due to no inclass meeting this week | (for the pre-assignment you will not to turn anytning in - but it is expected you complete the practic) | |||||||
42 | 6 | Mon, Feb 14 | Comparing Variables: Histograms & Time Series (Bollinger Bands) | ||||||
43 | Agenda | Intro to Statistics: Histograms & Finance | |||||||
44 | Mo | Went over preHW4, Introduction to Finance (PDF from last week) | Intro to Statistics Viewing Data & Finance Basics | ||||||
45 | We | Chapter 3: Freakonomics : Multiple Variables -- Summary Due Friday | will open eLC Thursday - around noon. | ||||||
46 | We | Looking at Multiple Variables in Finance - & Compare | |||||||
47 | We | Viewing Data - from different Vantage Points. Scatterplot & Correlation | Discuss HW4: Comparing Data - Histograms & Scatter Plots | ||||||
48 | Fr | Lab | Lab | ||||||
49 | 7 | Mon, Feb 21 | Comparing Variables: Casuation (distant) & Correlations | ||||||
50 | Agenda | Practical Statistics: Correlation & Regression (preview) & Causation (distant, preview) | |||||||
51 | Mo | Summary 3 Due: Chapter 3: Organization Structures. | Already Assigned... file not visible | ||||||
52 | Mo | Chapter 4: Freakonomics : Correlation & Distance Causes | |||||||
53 | Tu | Update all grades - Summary & HW - make sure you have submitted everything due so far. | |||||||
54 | Tu | LabWk6 -- Bolllinger -- HW 4 due (submitting via eLC) 10% Lab | HW4 | { Comparing Data } Due 11:59 PM Tuesday - moved due to COVID issue | |||||
55 | We | Correlation - HW .cvs file ---> | CSV | ||||||
56 | Comparing Data, Bollinger Bands - Go over. | ||||||||
57 | Fr | Lab: Correlation | Lab | Wk7HW5 | |||||
58 | Fr | Summary 4 Due: Chapter 4: Distant Causes | |||||||
59 | 8 | Mon, Feb 28 | Correlation : Continue | ||||||
60 | |||||||||
61 | Mo | Chapter 5 & 6: Freakonomics: Causation & Correlation & Regression | Last Chapter is Ch 6 -- Before "Bonus Material" | ||||||
62 | We | Correlation & Regression | XLS | ||||||
63 | We | LabWk7 -- Regression Intro - HW5 -- due (eLC) 10% is from Lab | Correlation & Regression { Linear } | ||||||
64 | Th | Wk8: Summary 5: Due Chapter 5 | |||||||
65 | FR | Lab: Correlation (not optional) & Sharpe Ratio (optional) | Lab | Wk8HW6 | |||||
66 | LabWk8 -- Regression Continue - HW6 -- Lab refinements | ||||||||
67 | 9 | Mon, Mar 07 | Spring Break.βοΈβ± π | ||||||
68 | Mo | -- Spring Break π π π π· | |||||||
69 | We | -- Spring Break π€ΈπΌββοΈ β· ππΌ | |||||||
70 | Fr | -- Spring Break π» π€ ππΌ π | |||||||
71 | 10 | Mon, Mar 14 | Normalization - Z-Score - and a bit of Python | ||||||
72 | Mo | Simple Python programs. | Get next book for next week. ( presentation - 2 people teams - sign up later this week ) | |||||||
73 | Mo | Python get started. | Spyder - Anaconda | ||||||
74 | We | Z-Score to wrap - up Excel Section {simple normalization} | |||||||
75 | Fr | Exam 1 : Histograms, Benford Law, Bollinger Bands & Correlations : MC & Short Answers (in-class) & Take-Home portion | |||||||
76 | |||||||||
77 | 11 | Mon, Mar 21 | Odds & Ends Excel & Analyzing Data :Z-Score Continue | ||||||
78 | Mo | Next Book & More Python - familiarization | |||||||
79 | We | Go over exam - grades will be posted later in the evening | Alll HW is graded - posting to eLC in the evening. | ||||||
80 | Th | March 24 -- Withdrawal Deadline. -- all grades will be available -- | |||||||
81 | Fr | Python Anaconda - PyCharm Set up Continue | |||||||
82 | 12 | Mon, Mar 28 | Python Begin | ||||||
83 | Mo | Presentation #1: Chapter 1 : Prostitutes & Santa -- Riley & Matt | |||||||
84 | We | ||||||||
85 | Fr | *** Cyberday - python practice *** no in-person session ** | Lab | Python - exercise - you will need to create a youtube video to demo | |||||
86 | 13 | Mon, Apr 04 | |||||||
87 | Mo | Presentation #2: Chapter 2 : Suicide bombers & Life Insurance -- McEver & Cameron | |||||||
88 | Tu | LabWk11-HW7-- Intro Python (Video Demoing work -& write-up) | |||||||
89 | We | Python | DIR | ||||||
90 | Fr | Python | Python Lab | ||||||
91 | 14 | Mon, Apr 11 | |||||||
92 | Mo | Presentation #3: Chapter 3: Apathy & Altruism -- Josie & Holt | |||||||
93 | We | Python - Continue - and | zip | DIR | |||||
94 | Fr | Lab - python scripting - HW8 - LabWk14 - Panda Frames Intro | DIR | Survey Monkey will be posed - Saturday | |||||
95 | 15 | Mon, Apr 18 | |||||||
96 | Mo | Presentation #4: Solving Large Problems in Surpising Ways - Andre & Blake | |||||||
97 | TU | SM | HW8 DUE - recembles lab - some extension since there is extra time | ||||||
98 | WE | DIR | HW9 not posted until after exam - it will utilize code from portfolio.py | ||||||
99 | We | Final Exam - effort level: 2 HW | Talk about Final Project & Exam 2 (2 week project), and HW9 | ||||||
100 | Fr | ||||||||
101 | FR | Exam 2: 5% MC & short Answers (other 5% is your presentation) | Book Chapters Up to Al Gore Chapter and Python/Pandas Q/A | ||||||
102 | FR | Exam 2 : no bathroom breaks during exam - 1 sheet allowed | 1 sheet allowed - no open electronics. | ||||||
103 | 16 | Mon, Apr 25 | |||||||
104 | Mo | Presentation #5: Al Gore & Mount Pinatubo -- Ethan & Chris | LASt one | ||||||
105 | Mo | Go over exam 2 | Working on grades - will update later Tuesday evening. | ||||||
106 | We | --> Post HW9 we will work on the bulk of HW We & Fr - together | HW9 | Discuss HW9 | |||||
107 | We | ||||||||
108 | We | Asses Portfolio Toward a Market Simulatr | Slides - General (overlap with last week) | ||||||
109 | We | Slides - Code Specific - also Final Project Options (read over this before Friday) | |||||||
110 | Fr | Notes (start talking about this) | |||||||
111 | Fr | Last LAB - follow-on & HW9 -- DUE May 02 | Casual Lab - discuss HW9 and HW10 (we will work on HW9 together) | ||||||
112 | HW4 - FR-Mon | HW9 | DIR | HW9 DUE - will accept HW Monday w/ not penalty | |||||
113 | 17 | Mon, May 02 | |||||||
114 | Mo | May 02 Our Last day of Class : Via ZOOM - see piazza for link | Please make sure you state what you ar doing as Final Project (HW9) | ||||||
115 | Mo | HW10 statement on what you are doing for Final Exam | HW10 | HW10 DUE - FInal Project Outline -- e.g., analyze more complex portfolios | |||||
116 | --> see notes on more complex scnearios - also compute sharpe ratio. | ||||||||
117 | Tu | May 03 Last Day of Classes UGA | |||||||
118 | We | May 04 - Reading Day | No assignments can be due. | ||||||
119 | Fr | May 06 -- Our Final Exam 12:00 - 3:00 pm (Boyd 222) | Project Oriented - Presentation Everyone must be present - | ||||||
120 | 18 | Mon, May 09 | |||||||
121 | |||||||||
122 | Recover from class | ||||||||
123 | |||||||||
124 | |||||||||
125 | 19 | Mon, May 16 | |||||||
126 | Mo | Monday -- Grades Due 12:00 pm (noon) | |||||||
127 | |||||||||
128 | |||||||||
129 | |||||||||
130 | |||||||||
131 | Summary of topics covered (order may vary) [bold - cover, non-bold = some options ] | ||||||||
132 | |||||||||
133 | Introduction - quantitative analysis - with Excel & Python | ||||||||
134 | Installing : Python/IDE/Debugger & Excel and packages | ||||||||
135 | Excel Introduction : Functions, Array formulas, Charts | ||||||||
136 | Histogram & Distributions & Comparing Data | ||||||||
137 | Correlation & Regression | ||||||||
138 | Normal Distribution & Z-Score | ||||||||
139 | Python: Intro | ||||||||
140 | Python: Input & Output - readin/writing to a file | ||||||||
141 | Python: Read/Write to a .csv file (pandas and non pandas) | ||||||||
142 | Python : Pandas - programming using 'spread sheets' concepts | ||||||||
143 | Python: Pandas (2D) Selection & Computations (on any axis - row, columns) | ||||||||
144 | Python : Webscraping - dynamic pages and non-dynamic | ||||||||
145 | Python : The case of analyzing "big data" | ||||||||
146 | Python : Plot and Chart Pandas Frames with matplot lib. |