MIS2502 Data Analytics

Remaining Slides, In Class and Homeworks now posted on site

SAS EM Account Set Up instructions, Slides, and In Class Exercise #1 posted to site .

Please see questions on Weekly Question site

Please respond to weekly question

The solution for the In Class SQL Out exercise has been posted under  the In Class link .

In Class SQL Pen  and Paper and SQL Out solutions posted in In Class Folfer

SQL Homework Assignment Posted in Homework folder

As follow on to my email of  Thursday Jan 30th, a reminder regarding the ER Diagram assignments .

Assignment and instructions can be found in the Homework folder

Follow the instructions!

Due Wed as an email attachment before class at the latest

The 2502 Section 002 MySQL course materials have been posted and emailed. You must have this done by next week!  

·         Review the SQL1 – Out PowerPoint  posted on the Community Site in slide decks 

·         Your MySQL IDs and passwords have been set up in your gradebook. Go get them.

·         Connect to (from a school PC) or download (to your PC) the MySQL Workbench using the QuickGuide to MySQL Workbench Quick Guide posted in Slide Decks. . Confirm connectivity using the “ Select query” at the end of the guide.    You’ll need your MySQL IDs and passwords for this

·         Review the MySQL and Workbench Tutorial PowerPoint posted  posted in Slide Decks

Next week we start MySQL programming!

In Class ERD problems and solutions posted  in In Class Assignments.

Hi Everybody,

The Wed class cancellation  created a bit of a problem for us in that we’ve got a lot of material to cover and really can’t afford to lose 2.5 hours.    

David Schuff  designed the Data Analytics class a couple years back and is teaching another section this semester.  I’m teaching from his material so the content is almost identical, including the syllabus and ground rules.  

 So, to get caught up , I need you to view David Schuff’s  class capture in advance of our next class.  The class capture links can be found at    

http://community.mis.temple.edu/mis2502sec003s14/category/class-capture/.  You need to view the 1^st 2 of these.    

 And I’ve posted and emailed  the related PowerPoints.Read these in their entirety.

01-Things You Can Do

02 –Information Architecture

03-Relational Data Modeling

 On the 29^th we’ll have a quick quiz on this material (up through slide 11 in deck 03- Relational Data Modeling) before moving into  further into Entity Relationship Modeling.

See you then   

Thanks

Frank Hoban