Spring 2009 MIS 342 - Advanced Business Computer Applications

Course Policy	Software Installs!	VPN	HW web site Problems	Groups	IT Links!
Virtual Classroom	Using VirtualPC	Windows Explorer	MELB	Self Extracting files	LearnSQL!
			System Objects!

* Week	Class	Date	Class work	Presentations	* Assignments
1/3	1	Tue, 1/13/09	Discuss class setup, book Project1 MELB	CourseInro Safe Computing
1/3	2	Th, 1/15/09	Dual/External Monitors
2/4	3	Tue, 1/20/09	ICE101-Flatfiles or Why not Excel? Discuss Project2, Project3 VirtualPC	C1-Access Introduction Study Guide-Creating a Database	ICE101
2/4	4	Th, 1/22/09	Project 1 questions Chapter 1
2/4		Fri, 1/23/09	Reminder that homework is due Friday nite at 11:59:59pm		Project1- web site
3/5	5	Tue, 1/27/09	Discuss Homework1	C2-Databases	HW01
3/5	6	Th, 1/29/09	ICE02	Study Guide- Building a Database	HW02
* Week	Class	Date	Class work	Presentations	* Assignments
4/6	7	Tue, 2/3/09	Project 2	C3-Queries Query Tips Query Exercises
4/6	8	Th, 2/5/09	Work on Project3	Study Guide- Queries	HW03
5/7		Tue, 2/10/09		C4-Form and Report Basics Form and Report Tips Study Guide- Basic Forms and Reports Practice Exam
5/7	9	Th, 2/12/09			HW04
6/8	10	Tue, 2/17/09	Assessment Day
6/8	11	Th, 2/19/09	ICE501	LearnSQL! Table, query tips C5-Tables, Advanced Queries Lookup Study Guide- Advanced Queries
* Week	Class	Date	Class work	Presentations	* Assignments
7/9	12	Tue, 2/24/09	Project2	AdvancedQueries1 AdvancedQueries2
7/9	13	Th, 2/26/09	Project 3
8/10		Tue, 3/3/09	Spring Break
8/10		Th, 3/5/09	Spring Break
9/11	14	Tue, 3/10/09	Using Graphs in Forms to save time CrosstabGraph- custom form Excel Pivot Table Answer Review for midterm	CrosstabGraph	HW05 Project3
9/11	15	Th, 3/12/09	Midterm 1 Chapters 1 to 5
* Week	Class	Date	Class work	Presentations	* Assignments
10/12	16	Tue, 3/17/09		Study Guide- Advanced Forms Form Tips
10/12	17	Th, 3/19/09		C6-Advanced Forms	HW06
11/13	18	Tue, 3/24/09	Midterm due start of class
11/13	19	Th, 3/26/09		C7-Advanced Reports
12/14	20	Tue, 3/31/09	Review Midterm	Study Guide - Advanced Reports
12/14	21	Th, 4/2/09		Report Tips	HW07
* Week	Class	Date	Class work	Presentations	* Assignments
13/15	22	Tue, 4/7/09	Linked table madness	SimpleXML C8-Integrating Access with Office Study Guide - Sharing Data
13/15	23	Th, 4/9/09	Midterm 2 Chapters 6 to 8	Integration Tips see Ch8PivotTable.xls and Ch8PivotTable.accdb in \\store\classes\20095000822\ReadOnly\	HW08
14/16	24	Tue, 4/14/09		C9-Action Queries More Action Queries ActionQuery Examples
14/16	25	Th, 4/16/09		Study Guide-Action Queries	HW09
15/17	26	Tue, 4/21/09	Midterm 2 due at start of class
15/17	27	Th, 4/23/09	ICE1001	C10-Macros Study Guide- Macros
16/18	28	Tue, 4/28/09	ICE1101 Chapter11.mdb	C11-VBA Study Guide - VBA
16/18	29	Th, 4/30/09		C12-Managing DB Study Guide - Managing Databases	HW10 Project2 Evaluations
			RateMyProfessors.com	Course Evaluation
Final		Th, 5/7/09 1 to 3pm	Somsen 301-Open book, open notes, laptop	Final Exam Topics	Project 2 Group Evaluations due Friday May 1, 11:59:59pm