Schedule+-+Spring+2017

= Spring 2017 Class Schedule =

SFAC#8 (Chapter 3): ||   ||
 * ~ Date ||~ Chapter ||~ Coverage ||~ Assignment ||~ Due Date ||
 * 01/10/2017 || Chapter 1 || AIS: An Overview || SFAC#2 (Amended): [[file:aop_CON2.pdf]]
 * 01/12/2017 || Chapter 2 || Transaction Processing & ERP ||  ||   ||
 * 01/17/2017 || Chapter 3 || Systems Documentation Techniques - DFDs ||  ||   ||
 * 01/19/2017 || Chapter 3 || Systems Documentation Techniques - Flowcharts || Model Assignment #1 || 01/24/2017 ||
 * 01/24/2017 || 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/27/2017**
 * (Note this is a Friday)** ||
 * 01/26/2017 || 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/31/2017 ||
 * 01/31/2017 || Chapter 4 || Relational Databases ||  ||   ||
 * **02/02/2017** || **Exam 1** || **Covers Chapters 1 - 3.** ||  ||   ||
 * 02/07/2017 || 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/14/2017 ||
 * 02/09/2017 || Chapter 5 || The REA Data Model ||  ||   ||
 * 02/14/2017 || 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/17/2017**
 * (Note this is a Friday)** ||
 * 02/16/2017 || Chapter 6 || Implementing an REA Data Model ||  ||   ||
 * 02/21/2017 || 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/22/2017**
 * (Note this is a Wednesday)** ||
 * **02/23/2017** || **Exam 2** || **Covers Chapters 4, 5, & 6** ||  ||   ||
 * 02/28/2017 || XBRL - 2 || Introduction to XML/Non-Vocabulary XML ||  ||   ||
 * 03/02/2017 || XBRL - 2 || XML and UBL || Ex 2-2 || 03/09/2017 ||
 * 03/07/2017 || XBRL - 3 || Lecture ||  ||   ||
 * 03/09/2017 || XBRL - 3 || UBL Schema || Ex 3-2 - submit two files .xml and .xsd || 03/21/2017 ||
 * **03/14/2017** || **No Class** || **Spring Break** ||  ||   ||
 * **03/16/2017** || **No Class** || **Spring Break** ||  ||   ||
 * 03/21/2017 || XBRL - 4 || XBRL - Lecture ||  ||   ||
 * 03/23/2017 || **No Class** ||  ||   ||   ||
 * 03/28/2017 || **No Class** ||  ||   ||   ||
 * 03/30/2017 || XBRL - 4 || XBRL || Ex 4-1, 4-2 & 4-3 - only one file should be submitted. || 04/04/2017 ||
 * 04/04/2017 || XBRL - 6 || Lecture ||  ||   ||
 * 04/06/2017 || XBRL - 6 || XBRL (IFRS), iXBRL, and other Topics || Ex 6-2 || **04/10/2017 (Note this is a Monday)** ||
 * **04/11/2017** || **Exam 3** || **XBRL Chapters 1, 2, 3, 4, and 6** || [[file:Assessment.pdf]] Example Test Questions (1 per chapter) ||  ||
 * 04/13/2017 || Tableau ||  ||   ||   ||
 * 04/18/2017 || Tableau ||  ||   ||   ||
 * 04/20/2017 || Tableau ||  ||   ||   ||
 * 04/25/2017 || Tableau ||  ||   ||   ||
 * **05/02/2017** || **Exam 4 - Tableau** ||  || 7:00 AM to 12:00 PM (noon) ||   ||