RUTGERS - THE STATE UNIVERSITY OF NEW JERSEY
Management Information Systems (29:623:220)
Fall 2005
T Th 4:00-5:20PM, Engelhard Hall 003
Syllabus
- Instructor and TA
|
Role |
Name |
Office Hours |
Phone |
Email |
| Instructor |
Dr. Hui Xiong |
Ackerson Hall, 200K
T Th 5:30-6:30pm |
973-353-5261 |
hui@rbs.rutgers.edu |
| TA |
Xiaoyun He |
Ack, 2rd floor, cubic
M F 1:30:2:30pm |
973-353-1865 |
xiaoyun@cimic.rutgers.edu |
-
Schedule:
Lecture, Homework and Exam Schedule
-
Internal Web Pages:
Class Notes,
Homeworks
,
Instructor Announcements,
TA Announcements.
- Course
Objectives: The object of this course is to
provide a comprehensive understanding of the use of computer systems and
application software. The entire course requires a “hands-on” approach to
learning application packages, including Microsoft Word, Excel, Access and
PowerPoint.
- Required
Textbook: Glen J. Coulthard & Sarah Hutchinson
Clifford, “Advantage Series: MS Word 2003, MS Excel 2003, MS Access 2003”
(Introductory Edition), McGraw Hill.
- Web Site:
http://cimic.rutgers.edu/~hui/teaching/fall2005/220.html. This course
web site is the location for course documents, assignments, announcements
and other information. You should check it frequently to remain updated.
You are responsible for keeping aware of the
announcements on the course web site.
In-class work (including attendance) 20%
Assignments 20%
Exam I (MS Word) 20%
Exam II (MS Excel) 20%
Exam III (MS Access) 20%
-
Attendance: Regular attendance is compulsory. You
are not allowed to check your emails, access Web sites not
related to the course or work on something that is beyond the scope of this
course during the class time.
-
Assignments: You may have discussions with your
class members, but you have to submit your own work. Please be sure to keep
a copy of the assignment by yourself in case that there is any problem with
your hand-in or you have to use it later this semester. Assignments have to
be submitted before the beginning of the class on the
specified due day. No late submissions will be
accepted.
- Exams:
There will be no make-up exams. You are required to present a
written proof for situations such as going on to an emergency room due to
unexpected and serious illness. Chatting during the exam is not
allowed. Email communication during the exam will be considered
cheating. No collaboration between class members will
be allowed during any exam. There will be no extra-credit
project.
- Students
are responsible for reviewing the specified chapters covered by the lecture.
Please note that you are responsible for the ENTIRE contents of each
chapter plus any additional handouts, unless otherwise notified.
You are not allowed to possess, look at, use, or in any other way derive
advantage from the solutions prepared in prior years, whether these
solutions are former students’ work or copies of solutions that were made
available by instructors.
· Scholastic
Dishonesty Policy: The University defines academic
dishonesty as cheating, plagiarism, unauthorized collaboration, falsifying
academic records, and any act designed to avoid participating honestly in the
learning process. Scholastic dishonesty also includes, but not limited to,
providing false or misleading information to receive a postponement or an
extension on assignments, and submission of essentially the same written
assignment for two different courses without the permission of faculty
members. The purpose of assignments is to provide individual feedback as well
to get you thinking. Interaction for the purpose of understanding a problem is
not considered cheating and will be encouraged. However, the actual solution
to problems must be one's own.
Topics to be covered:
-
Introduction to Word Processing (Microsoft Word
for Windows) Starting and quitting Word. Creating documents, editing,
spelling and saving documents. Selecting characters, lines and paragraphs;
centering, bolding, italicizing and changing font sizes; importing picture
objects and using help. Using templates. Creating resumes, cover letters,
fax cover sheets. Creating tables, sorting, adding footnotes and endnotes
and styling to create outline and research papers.
-
Introduction to Spreadsheets (Microsoft Excel for
Windows) Basic characteristics of worksheets and workbooks. Entering text
and numbers. Formatting and using formulas and functions. Fill handle,
AutoComplete, AutoFormat, AutoFit and other methods to speed up the use of
Excel. Using Templates and saving your work. Creating charts and 3-D charts,
displaying formulas. What-if analyses, Three-dimensional sheets.
-
Introduction to Database Management Systems
(Microsoft Access for Windows) Relational database design. Creating database
tables. Open tables, add records. Close tables and databases. Create and use
forms, queries, reports and other features of Access.
- Other
topics to be considered Microsoft PowerPoint for
Windows. Using the Internet as a research tool; obtaining business
information; using search engines.
- Helpful Comments: To get full
benefit out of the class you have to work regularly. Read the textbook regularly
and start working on the assignments soon after they are handed out. Plan to
spend at least 10 hrs a week on this class doing assignments or reading.
Good Luck, and Welcome to the course Management Information Systems
Hui Xiong