Schedule+-+Spring+2018

= Spring 2018 Class Schedule =

SFAC#8 (Chapter 3): ||   ||
 * ~ Date ||~ Chapter ||~ Coverage ||~ Assignment ||~ Due Date ||
 * 01/09/2018 || Chapter 1 || AIS: An Overview || SFAC#2 (Amended): [[file:aop_CON2.pdf]]
 * 01/11/2018 || Chapter 2 || Transaction Processing & ERP ||  ||   ||
 * 01/16/2018 || Chapter 3 || Systems Documentation Techniques - DFDs ||  ||   ||
 * 01/18/2018 || Chapter 3 || Systems Documentation Techniques - Flowcharts || Model Assignment #1 || 01/23/2018 ||
 * 01/23/2018 || Preparing DFD's ||  || Depending on the first letter of your last name complete Problem **5** (A-L), or Problem **7** (M-Z) in Chapter 3 of your textbook. For all problems first prepare an Entities and Activities table then proceed with the problem preparing a context-level DFD and a Level-0 DFD. When finished submit your file(s) in either .pdf or .jpg format via WebCourses. || 01/26/2018 **(Note: This is a Friday)** ||
 * 01/25/2018 || Flowcharts ||  || Assignment #3: Complete the Flowchart (be sure to prepare the flowchart asked for in the problem), from assignment #2. When finished submit your file(s) in either .pdf or .jpg format via WebCourses2 (Canvas). || 01/28/2018 **(Note: This is a Sunday)** ||
 * **01/29/2018** || **Exam 1** || **Covers Chapters 1 - 3.** ||  ||   ||
 * 01/30/2018 || Chapter 4 || Relational Databases ||  ||   ||
 * 02/01/2018 || Chapter 4 || Relational Databases/Queries || Complete Problem 3 in chapter 4, For requirements a-c your design should be similar to Table 5. If using Access you must use Access 2010 nothing earlier, if you don't have it, complete your assignment in one of the campus labs. You are required to do A-F. You need to have at least 3 queries: 1) Simple with fields from 1 table; 2) Simple with fields from 2 or more tables; 3) a query that contains a calculation.

After completing your database, please upload just the database file. || 02/08/2018 ||
 * 02/06/2018 || Chapter 5 || The REA Data Model ||  ||   ||
 * 02/08/2018 || Chapter 5 || The REA Data Model || Depending on the first letter of your last name complete Problem **4** (A-F), Problem **3** (G-L), Problem **2** (M-R), or Problem **1** (S-Z) from chapter 5. Use draw.io to create your REA diagram. || 02/13/2018 ||
 * 02/13/2018 || Chapter 6 || Implementing an REA Data Model ||  ||   ||
 * 02/15/2018 || Chapter 6 || Implementing an REA Data Model || If you did problem #1 or #2 for the REA assignment prepare an integrated REA for Joe's Ice Cream. If you did #3 or #4 for the REA assignment prepare an integrated REA for Sue's Gallery. Use the solutions provided for Joe's Ice Cram Revenue & Expenditure Cycles (1 & 2) or Sue's Gallery (3 & 4) from chapter 5 if needed. Prepare a table listing the relational database based on your integrated REA. The table should include the table names, primary keys, foreign keys and non-key attributes. For your table of primary/foreign keys use Word (or other word processing program to build a table). You do NOT need to create tables using Access for this assignment. || **02/18/2018**
 * (Note this is a Sunday)** ||
 * **02/19/2018** || **Exam 2** || **Covers Chapters 4, 5, & 6** ||  ||   ||
 * 02/20/2018 || XBRL - 2 || Introduction to XML/Non-Vocabulary XML ||  ||   ||
 * 02/22/2018 || XBRL - 2 || XML and UBL || Ex 2-2 || 03/01/2018 ||
 * 02/27/2018 || XBRL - 3 || Lecture ||  ||   ||
 * 03/01/2018 || XBRL - 3 || UBL Schema || Ex 3-2 - submit two files .xml and .xsd || 03/08/2018 ||
 * 03/06/2018 || XBRL - 4 || XBRL - Lecture ||  ||   ||
 * 03/08/2018 || XBRL - 4 || XBRL || Ex 4-1, 4-2 & 4-3 - only one file should be submitted. || 03/22/2018 ||
 * **03/13/2018** || **No Class** || **Spring Break** ||  ||   ||
 * **03/15/2018** || **No Class** || **Spring Break** ||  ||   ||
 * 03/20/2018 || XBRL - 6 || Lecture ||  ||   ||
 * 03/22/2018 || XBRL - 6 || XBRL (IFRS), iXBRL, and other Topics || Ex 6-2 || 03/27/2018 ||
 * 03/27/2018 || Tableau || Introduction to Big Data ||  ||   ||
 * **03/29/2018** || **Exam 3** || **XBRL Chapters 1, 2, 3, 4, and 6** || [[file:Assessment.pdf]] Example Test Questions (1 per chapter) ||  ||
 * 04/03/2019 || Tableau || Introduction to Tableau || Measure vs. Dimension; Discrete vs. Continuous Data ||  ||
 * 04/05/2019 || Tableau || Creating Charts || Charts Assignment || 04/12/2018 ||
 * 04/10/2018 || Tableau || Calculations ||  ||   ||
 * 04/12/2018 || Tableau || Table Calculations || Calculation Assignment || 04/19/2018 ||
 * 04/17/2018 || Tableau || Interactive Dashboards || Dashboard Assignment || 04/24/2018 ||
 * 04/19/2018 || Tableau || Working with Data ||  ||   ||
 * 04/24/2018 || Tableau || Dirty Data || Data assignment??? || ???? ||
 * **Check with Testing Lab** || **Exam 4 - Tableau** ||  || 7:00 AM to 12:00 PM (noon) ||   ||