Tentative Schedule for BUAN 370 Spring 2024
 note subject to change
 

USD FINAL EXAM SCHEDULE SPRING 2024

Date TOPIC ASSIGNMENT
tue 30 jan Introduction to Class  
thr 1 feb branches of problem types, exploratory data analysis  
tue 6 feb descriptive statistics in R  
thr 8 feb Boolean Logic,  For While Loops, Automating Cleaning Example DataCamp:  Introduction to Statistics (2/11)
tue 13 feb simlulation, ggplot DataCamp:  Introduction to R (2/11)
thr 15 feb preproceeing, cleaning data fundamentals  
tue 20 feb panel data/ cross sectional data DataCamp:  Intermediate R (2/18)
thr 22 feb importing data into R DataCamp:  Introduction to Importing Data in R (2/25)
tue 27 feb Automating Processes,   
thr 29 feb Querying dataframes with dplyr using the TIdyverse DataCamp:  Introduction to Data Visualization with ggplot2 (/25)
tue 5 mar Combining dplyr and ggplot2 for descriptive analysis and data visualizations DataCamp:  Introduction to the Tidyverse (3/10)
thr 7 mar review for exam DataCamp:  Intermediate Data Visualizations with ggplot2 (3/10)
tue 12 mar EXAM ONE  
thr 14 mar database overview, lifecycle RDBMS  
tue 19 mar relational database model/database application (ms access)  
thr 21 mar entity relationship model/normalization  
tue 26 mar NO CLASS SPRING BREAK/EASTER
thr 28 mar
tue 2 mar SQL - CREATE, INSERT, DROP,  
thr 4 apr SQL -  SELECT FROM, WHERE  
tue 9 apr query case study/SQL DataCamp:  Introduction to SQL (4/7)
thr 11 apr SQL - LOGICAL OPERATORS, IN EXACT MATCH,  
tue 16 apr SQL - IN EXACT MATCH,IN AND NULL, SORT CALCULATE DataCamp:  Intermediate SQL (4/14)
tue 16 apr SQL - TWO TABLES OR MORE, DataCamp:  Joining Data in SQL (4/21)
thr 18 apr AGGREGATES (I and II). SELF JOIN  
tue 23 may review for exam  
thr 25 may EXAM TWO  
tue 30 apr cleaning data exercise  
thr 2 may Dealing with Missing Information, TIDY Data , Deletion vs. Deletion when necessary DataCamp:  Cleaning Data in R (5/5)
tur 7 may WORK WEEK  
thr 9 may Last Day of Class/WORK