HOME
 
SYLLABUS
 
SCHEDULE
 
LECTURE SLIDES
 
LECTURE FILES
 
Course Content
 
TIMELINES
 
ASSIGNMENTS
 
GRADE DATABASE
 
RESOURCES
 
Link to GUAC
 
LINK TO UARK EPIC

 

Tentative Schedule for BUAN 370 Fall 2021
note subject to change
 

USD FINAL EXAM SCHEDULE Fall_2021
 

Date TOPIC SLIDE DECK READINGS ASSIGNMENT
wed 1 sept Introduction to Class      
mon 6 sept NO CLASS Labor Day      
wed 8 sept branches of problem types      
mon 13 sept the learning problem      
wed 15 sept importing data into R      
mon 20 sept descriptive statistics in R     SWIRL Assignment (19 Sept)
wed 22 sept preprocessing and
cleaning data fundamentals
     
mon 27 sept panel data      
wed 29 sept cross sectional data      
mon 4 oct Automating Processes,
For/While loops
     
wed 6 oct Boolean Logic, A
utomating Cleaning Example
     
mon 11 oct review for exam      
wed 13 oct EXAM      
mon 18 oct database overview, lifecycle RDBMS intro to database powerpoint INTRO PDF 1,2,
DBD CH 1, . 2, 3
VIDEO Hans Rosling
 
wed 20 oct database overview, lifecycle RDBMS lecture 2 INTRO PDF 1,2,
DBD  CH 1, 2, 3
VIDEO DB Fundamentals
db Assignment one
mon 25 oct relational database model intro to RDBMS DBD, CH 4,5, 6, 7;
 tutorial A
 
wed 27 oct database application (ms access) access_db_mini-slides

tutorial b,
database troubleshoot tutorial

db Assignment two
mon 1 nov entity relationship model/normalization

ERM/ED,database design-KEYS,
normalization

DBD CH 8, 9, 10, 11  
wed 3 nov query case study/SQL

a review of QBE queries
getting to be (WAIT FOR IT )  EPIC

   
mon 8 nov SQL - CREATE, INSERT, DROP, SQL working packet one What we have covered so far SQL LINES CONVERTER  
wed 10 nov SQL -  SELECT,
SELECT FROM, WHERE
IN AND NULL, SORT CALCULATE
SQL working packet one SCRIPT FOR SELECT FROM, SELECT FROM WHERE  
mon 15 nov SQL - LOGICAL OPERATORS, IN EXACT MATCH, SQL working packet one SCRIPT FOR LOGICAL_OPERATORS TO SORT_CACLULATE  
wed 17 nov SQL - IN EXACT MATCH,
IN AND NULL, SORT CALCULATE
SQL working packet one SCRIPT FOR LOGICAL_OPERATORS TO SORT_CACLULATE  
mon 23 nov SQL - TWO TABLES OR MORE,
AGGREGATES (I and II). SELF JOIN
SQL working packet two SCRIPT FOR TWO TABLES  
wed 24 nov NO CLASS THANKSGIVING      
mon 29 nov EXAM REVIEW SQL working packet two SCRIPT FOR TWO TABLES  
wed 1 dec EXAM      
mon 6 dec Visualization      
wed 8 dec GGPLOT2 Last Day of Class     db working assign pckt (A3)
MON 13 dec FINAL EXAM/PROJECT  FOR SECTION 1 2PM to 4 PM  
WED 15 dec FINAL EXAM/PROJECT   FOR SECTION 2 5PM to 7 PM