CSE 2337 Introduction to Data Management
Fall 2009
|
Instructor: Dr. Yuhang
Wang
Time: MW 4PM - 4:50PM
Room: Embrey 129
Office: Room 800J in Expressway Tower
Office Phone: (214) 768-3716
Email: yuhangw@engr.smu.edu
Office Hours: MW 2:45PM-3:45PM in SIC 312, and by telephone or email. You can also schedule an appointment.
Lab Hours: Section 1: F 1:00PM - 2:50PM, Section 2: Tu 1:00PM - 2:50PM
Lab Location: Patterson Hall 214
TA: K. Ramesh
TA
Email: kramesh@smu.edu
09/02/2009: Lab #1 assigned.
09/09/2009: Lab #2 assigned.
09/14/2009: Homework #1 assigned.
09/16/2009: Lab #3 assigned.
09/23/2009: Lab #4 assigned.
09/30/2009: Lab #5 assigned.
10/14/2009: Lab #6 assigned.
10/21/2009: Lab #7 assigned.
10/28/2009: Lab #8 assigned.
11/02/2009: Homework #2 assigned.
11/04/2009: Lab #9 assigned.
11/11/2009: Lab #10 assigned.
11/18/2009: Lab #11 assigned.
Textbook
|
- Gross, Akaiwa, Nordquist, Succeeding in Business with Microsoft Office – Excel 2007, Thomson/Course Technology, ISBN# 978-1-4239-0605-6
- Cable, Succeeding in Business with Microsoft Office – Access 2007, Thomson/Course Technology, ISBN# 978-1-4239-0606-3
|
Course Objective
|
:This class will serve as an introduction to some of the many ways it is possible to analyze and manage data and extract meaningful information from data to solve real-life business problems. It is no secret that data is produced at such an amazing rate that sophisticated techniques are required for analysis. The course will help to examine data from the perspectives of databases and spreadsheets. The course will emphasize practical skills and reinforce those skills through hands-on activities and computer lab. |
The schedule that follows is tentative and may be modified based on the flow of the class.
Date |
Topic |
Lecture Slides |
Reading |
08/26/09 |
Introduction |
|
|
08/31/09 |
Introduction to Excel |
|
Excel – Chapter 1 |
09/02/09 |
Basic Statistics, Excel functions |
|
Excel – Chapter 2 |
| 09/09/09 |
Visualization and Data Presentation |
|
Excel – Chapter 3 |
| 09/14/09 |
Applying Logic to Decision Making |
|
Excel – Chapter 4 |
09/16/09 |
Data Retrieval and Data Analysis |
|
Excel – Chapter 5 |
09/21/09 |
Advanced Excel Topics |
|
Excel – Chapter 6 Excel – Chapter 6 |
09/23/09 |
Advanced Excel Topics |
| 09/28/09 |
Data Organization for Effective Analysis |
|
Excel – Chapter 7 |
| 09/30/09 |
Data Organization for Effective Analysis, Using Data Tables and Scenarios |
|
Excel – Chapter 7, 8 |
10/05/09 |
Using Data Tables and Scenarios |
Excel – Chapter 8 |
| 10/07/09 |
Exam # 1 |
|
|
| 10/14/09 |
Advanced Topics: Enhancing Decision Making |
|
Excel – Chapter 9 |
10/19/09 |
Introduction to Data Management |
|
Access – Chapter 1 |
10/21/09 |
Introduction to Access |
|
Access – Chapter 1 |
10/26/09 |
Building Databases |
|
Access – Chapter 2 |
10/28/09 |
Building Databases |
11/02/09 |
Analyzing Data for Effective Analysis |
|
Access – Chapter 3 |
11/04/09 |
Analyzing Data for Effective Analysis |
11/09/09 |
Collecting Data with well-designed Forms |
|
Access – Chapter 4 |
11/11/09 |
Collecting Data with well-designed Forms |
11/16/09 |
Exam # 2 |
|
|
11/18/09 |
Developing Effective Reports |
|
Access – Chapter 5 |
11/23/09 |
Developing Effective Reports |
11/30/09 |
Database Design: Introduction to SQL |
|
Access - Chapter 3-Level 3 |
12/02/09 |
Advanced SQL |
|
|
12/07/09 |
Advanced SQL |
|
12/09/09 |
Exam # 3 |
|
|
The class grade will be based upon lecture exams, lab cases, quizzes and homework assignments.
There will be three major exams in this course. Each exam will cover material from the lecture. There will be no cumulative final exam for this course. Quizes: unknown number, may or may not be announced
The breakdown is as follows:
Assignment |
Value |
3 Exams |
30% |
Homework Assignments (~3) |
30% |
Tutorials, Lab Cases |
30% |
Class Participation, Attendance and Quizzes |
10% |
There will be approximately 3 to 5 homework assignments throughout the semester. Each homework assignment will have its due date listed below. Late homework submissions will not be accepted.
Exam # 1 is scheduled for Wednesday, October 7.
- In class, 50 minutes
- Rule: open book, open notes, but no computer allowed.
- Format: short questions that are similar to homework #1
- cse2337-f09SampleExam1.pdf
Exam # 2 is scheduled for Monday, November 16.
- In class, 50 minutes
- Rule: open book, open notes, but no computer allowed.
- Format: short questions that are similar to exam #1
This course emphasizes a hands-on approach to learning and therefore the lab component is an extremely important part of this class. You will do a great deal of work in lab. There will be a pre-lab assignment and lab assignment each week for lab.
- Pre-Lab Assignments: These will consist of reading and working through various chapters of the lab manuals. These assignments will be due at 9:00 a.m. on the Lab day (before any labs for that week) and will be submitted to the TA at kramesh@smu.edu.
- Lab Assignments: The Lab assignment will be directly related to the pre-lab assignment submitted the day before. The Lab assignment will be due on the Lab day at 10:00 p.m. to the TA at kramesh@smu.edu. Late assignments will only be accepted under justifying circumstances. You must see the instructor in person with valid excuse before any late work will be accepted. The TA will not permit any excuses for any worked missed and will only score make-up work at the direction of the instructor.
* Click here to download data files for all chapters of the Excel book. You need these files for the lab assignments.
* Click here to download data files for all chapters of the Access book. You need these files for the lab assignments.
Labs:
- Lab 1
- Lab 2
- Lab 3
- Lab 4
- Lab 5
- Lab 6
- Lab 7
- Lab 8
- Lab 9
- Lab 10
- Lab 11
- All the handouts for the class will be posted on the web at the URL http://engr.smu.edu/~yuhangw/classes/cse2337_f09/index.htm
- Even though office hours are provided, you may contact me any time through
email or meet me with an appointment.
- Late Homework Policy: Homework will be due at the beginning of class on
the due date, unless otherwise noted. Late homework (due before 5 pm) will
receive a 25% penalty per day. In case of emergencies, please talk to me to
make special arrangements. If you will be out of town for a non-emergency
(such as an interview), you should turn in the assignment early, rather than
late, to avoid a penalty.
- Academic dishonesty may be defined broadly as a student's misrepresentation
of his or her academic work or of the circumstances under which the work is
done. This includes plagiarism in all papers, projects, take-home exams, or
any other assignments in which the student represents work as being his or
her own. It also includes cheating on examinations, unauthorized access to
test materials, and aiding another student to cheat or participate in an act
of academic dishonesty. Failure to prevent cheating by another may be considered
as participation in the dishonest act.
- Honor Code. Intellectual integrity and academic honesty are fundamental
to the processes of learning and evaluating academic performance; maintaining
them is the responsibility of all members of an educational institution. The
inculcation of personal standards of honesty and integrity is a goal of education
in all the disciplines of the University. The faculty has the responsibility
of encouraging and maintaining an atmosphere of academic honesty by being
certain that students are aware of the value of it, that they understand the
regulations defining it, and that they know the penalties for departing from
it. The faculty should, as far as is reasonably possible, assist students
in avoiding the temptation to cheat. Faculty must be aware that permitting
dishonesty is not open to personal choice. A professor or instructor who is
unwilling to act upon offenses is an accessory with the student offender in
deteriorating the integrity of the University. Students must share the responsibility
for creating and maintaining an atmosphere of honesty and integrity. Students
should be aware that personal experience in completing assigned work is essential
to learning. Permitting others to prepare their work, using published or unpublished
summaries as a substitute for studying required materials, or giving or receiving
unauthorized assistance in the preparation of work to be submitted are directly
contrary to the honest process of learning. Students who are aware that others
in a course are cheating or otherwise acting dishonestly have the responsibility
to inform the professor and/or bring an accusation to the Honor Council. Students
and faculty must mutually share the knowledge that any dishonest practices
permitted will make it more difficult for the honest students to be evaluated
and graded fairly, and will damage the integrity of the whole University.
Students should recognize that their own interest, and their integrity as
individuals, suffer if they condone dishonesty in others.
- The Honor System. All undergraduate students at SMU are under the jurisdiction
of the Honor Code, and as such will be required to sign a pledge to uphold
the Honor Code. The Honor Council is composed of 22 students appointed by
the Student Senate to represent the undergraduate schools and classes of the
University. The Council's responsibility is to maintain and promote academic
honesty. Students are required to warn or to report to the Honor Council or
faculty any student suspected of violating the Honor Code, and to inform the
instructor of a course in which violations are suspected that he or she may
not be achieving an atmosphere conducive to academic honesty. Suspected violations
reported to the Honor Council by a student or by an instructor will be investigated
and, if the evidence warrants it, a hearing will be held by a Board composed
of five members of the Honor Council. Suspected cases of academic dishonesty
may be either handled privately by the appropriate faculty member in whose
class the alleged infraction occurred, or referred to the Honor Council. Appeals
of actions by the Honor Council shall be submitted to the All-University Judicial
Council in writing no later than three class days after the hearing. Appeals
of actions taken by instructors independently of the Honor Council may be
made through the traditional academic routes.
- Disability Accommodations: Students needing academic accommodations for
a disability must first contact Ms. Rebecca Marin, Coordinator, Services for
Students with Disabilities (214-768-4557) to verify the disability and establish
eligibility for accommodations. They should then schedule an appointment with
the professor to make appropriate arrangements. (See University Policy No.
2.4.)
- Religious Observance: Religiously observant students wishing to be absent
on holidays that require missing class should notify their professors in writing
at the beginning of the semester, and should discuss with them, in advance,
acceptable ways of making up any work missed because of the absence. (See
University Policy No. 1.9.)
- Excused Absences for University Extracurricular Activities: Students participating
in an officially sanctioned, scheduled University extracurricular activity
should be given the opportunity to make up class assignments or other graded
assignments missed as a result of their participation. It is the responsibility
of the student to make arrangements with the instructor prior to any missed
scheduled examination or other missed assignment for making up the work. (University
Undergraduate Catalogue)