|
Subject to change. |
I
Sys 201
|
Course Info(Syllabus) |
|
Day |
Date/(Lab?) |
Lecture Title |
Readings |
Assignments |
||||||||||||||||||||
| 1 | 1/4 (Lecture) |
Course Introduction/Business Driven Technology |
Ch 1 PLUG-IN B1 (link to file on McGraw Hill's Website) |
Start: Get Connected Follow-up Assignment Start: TWF Follow-up Assignment (view video & answer questions) Start: Syllabus Quiz (take home quiz--use the Course Info tab above) |
||||||||||||||||||||
| 2 | 1/6 |
Identifying and Implementing Competitive Advantages |
Ch 2 | Due: Competitive Advantage BlackBoard Quiz before class |
||||||||||||||||||||
| 3 | 1/11 |
Internet Search |
None | Due: Get Connected Follow-up Assignment Due: Syllabus Quiz |
||||||||||||||||||||
| 4 | 1/13 (Lecture) |
Valuing and Storing Organizational Information |
Chs 6 & 7 | Start: ER Diagram Preparation Problems Due: Valuing and Storing Information BlackBoard Quiz before class |
||||||||||||||||||||
| 5 | 1/18 |
Web Search Practice |
Packet (pp. 1-9) Search Engines and Subject Directories |
|||||||||||||||||||||
| 6 | 1/20 (Lecture) |
Designing Database Applications: Using MS Access 2007 |
Packet (pp. 10-19) Entity Relationship (ER) Diagrams and Table Mapping |
|||||||||||||||||||||
| 7 | 1/25 |
Problem Solving Using MS Access Queries |
Packet (pp. 20-32) Principles of Query Construction |
Due: Database Build Follow-up Problems Start: AFAS DB Queries Project |
||||||||||||||||||||
| 8 | 1/27 (Lecture) |
Business Intelligence, TPS, DSS, and EIS |
Chs 8 & 9 Business Plug-in B18 (in textbook) |
Due: Business Intelligence and Decision Making BlackBoard Quiz before class | ||||||||||||||||||||
9 |
2/1 |
Database/Web Exam |
Due: AFAS DB Queries Project | |||||||||||||||||||||
10 |
2/3 (Lecture) |
Measuring the Success of Strategic Initiatives |
Ch 4 Packet (pp. 33-48) Design and Use of Performance Measures |
Start:Measurement Follow-Up Problems Due: Measurement BlackBoard Quiz before class |
||||||||||||||||||||
11 |
2/8 |
Using MS Excel |
Packet (pp. 49-57) Excel Modeling Practice Problems (to be done to prepare for class, but not to be handed in) |
Due: Measurement Follow-Up Problems Due: Excel Modeling BlackBoard Quiz (administered in class) Start: LISP Measurement Project |
||||||||||||||||||||
12 |
2/10 (Lecture) |
Creating Customer Centric Organizations |
Ch 11 |
Due: LISP Measurement Project | ||||||||||||||||||||
13 |
2/15 (Lab) |
Hardware/Connecting to Networks |
Start: Perfect PC Follow-up Assignment Due: Hardware/Networks BlackBoard Quiz before class |
|||||||||||||||||||||
| 14 | 2/17 (Lecture) | Career Workshop | ||||||||||||||||||||||
| 2/22 | NO CLASS--Monday classes instead | |||||||||||||||||||||||
| 15 | 2/24 (Lab) | Decision Making Using MS Excel | Packet (pp. 58-70) Goal Seek and Solver | |||||||||||||||||||||
The Midterm Exam will be proctored in the Testing Center Thursday (2/24) through Monday (2/28) with a late fee on Monday. Use the study guides posted for each day to aid in your
preparations for the exam.
Midterm Exam Point Breakdown
|
||||||||||||||||||||||||
|
Day |
Date (Lab?) |
(Lecture) Title |
Readings |
Assignments |
||||||||||||||||||||
| 16 | 3/1 (Lecture) |
Depicting Processes with Flowcharting |
Packet (pp.103-122) Algorithms and Flowcharting | |||||||||||||||||||||
| 17 | 3/3 |
Programming with MS Excel |
Packet (pp. 123-131) Computer Programs and Programming Environments Packet (pp. 132-147) Programing with Visual Basic and Excel |
Start: UVTours Programming Project Data set for UVTours Programming Project |
||||||||||||||||||||
| 18 | 3/8 (Lecture) |
Developing Systems |
Chapter 17 Business Plug-ins B14 & B15 (in the textbook) |
Start: Pivot Table Preparation Problems Set 1 Data set for Pivot Table Preparation Problems Set 1 Due: Developing Systems BlackBoard Quiz before class |
||||||||||||||||||||
19 |
3/10 |
MS Excel: Pivot Tables |
Packet (pp 73-94) Pivot Tables for Data Analysis, Part 1 Dataset to Accompany Reading (Use same data set for Pivot Table Preparation Problems) |
Due: Pivot Table Preparation Problems Set 1 Start: Pivot Table Preparation Problems Set 2 Data set for Pivot Table Preparation Problems Set 2 |
||||||||||||||||||||
| 20 | 3/15 (Lecture) |
Creating Innovative Organizations and Collaborative Partnerships |
Chs 13 & Ch 15 |
Due: UVTours
Programming Project Due: Innovation/Collaboration BlackBoard Quiz before class |
||||||||||||||||||||
| 21 | 3/17 |
MS Excel: Pivot Tables 2 |
Packet (pp. 95-102) Pivot Tables for Data Analysis,
Part 2 |
Due: Pivot Table Preparation Problems Set 2 |
||||||||||||||||||||
| 22 | 3/22 (Lecture) |
E-business |
Ch 14 PLUG-IN B11 (Textbook) |
Due: E-business BlackBoard Quiz before class | ||||||||||||||||||||
| 23 | 3/24 |
Excel Exam |
Due : CompExcel Pivot Tables Project | |||||||||||||||||||||
| 24 | 3/29 (Lecture) |
Data Security and Privacy |
Business Plug-in B6 (Textbook) |
Due: Security/Privacy BlackBoard Quiz before class |
||||||||||||||||||||
| 25 | 3/31 (Lab) |
Designing Web Pages: HTML Basics |
Packet (pp. 148-162) Create Web Pages with HTML In Class: McKell's htmlexample page In Class: McKell's htmlexample files |
Start: HTML Project |
||||||||||||||||||||
| 26 | 4/5 (Lab) |
Creating Web Pages Using KompoZer and using CSS |
In Class Handout - Using KompoZer: A Web Authoring Tool In Class: WYSIWYG Example Resources |
|||||||||||||||||||||
| 27 | 4/7 |
Final Exam Review |
|
|||||||||||||||||||||
| 28 | 4/12 |
HTML Exam |
Due: HTML Project beginning of class | |||||||||||||||||||||
|
The Final Exam will be proctored in the Testing Center during the final exam period. Use the study guides posted for each day to aid in your preparations for the exam. Final Exam Point Breakdown
|
||||||||||||||||||||||||