(April 25, 1999)
|
Faculty
of Management
Dept of Management Science & Information Systems
|
Current
courses
(Home
page)
About
the professor
Site map
|
Course: 22:198:604
Computers & Information Systems CIS99
Lee
Papayanopoulos
|
Homework Assignments
Course Sessions
IT Headlines
Social Issues
Student Web Pages
Rutgers Libraries
|
Course
description:
In this broad survey of
information technology, we study the hardware, software,
connectivity, and uses of large and small computers. We
review the systems development process, and the nature of
Management Information Systems. Database fundamentals (Access)
are introduced and the principles of computer networks
are explored. Business and managerial aspects of these
topics are considered. Elementary programming is reviewed
through macros, BASIC, and Visual
BASIC (studying information systems without any
knowledge of programming is like doing astrophysics
without math).
Incoming students
possess, to varying degrees, such skills as word
processing, using electronic spreadsheets, and navigating
around Windows and the Internet.
Therefore, only minimal in-class instruction is provided
in these areas. Deficiencies must be remedied through
individual study. The course is organized in two primary
parts: (a) Tools & General Concepts and (b)
Developing and Using Program & Data Systems.
This course is intended
for anyone wishing to get an overview of information
technology in a single course. MIS majors and those with
extensive experience in IT will benefit from more
specialized courses.
|
Fortune
50 Companies
Useful
Links (Jobs, Technology,
News, Business/Finance, Sports)
|
Search Engines:
Altavista | Yahoo |
HotBot
| Excite |
Lycos
Search Engine Watch
|
Text: SUBJECT TO CHANGE. Shelly Cashman Series: Custom
Edition (by G. B. Shelly and T. J. Cashman)
Published by Boyd & Fraser (A Division of
South-Western)
It is unlikely that you will find this customized book
anywhere other than at a bookstore in the Rutgers
vicinity. Because of frequent changes, old
"used" copies may be inconvenient to use (check
with the instructor)
|
Session
|
Date
|
Topics
|
Reading
|
Assignments & Handouts
|
1
|
|
Internet
& WWW, (Email, Browsers (Netscape),
BBs, searching)
|
Chap
7
|
Cybersurfing,
one-page paper
|
2
|
|
Document
Formatting, HTML,
Web publishing with Word
|
Word
Projects
|
Create
your web page
|
3
|
|
General
HW Concepts, computer bits, bytes,organization &
performance
|
Chap
1, 3-5
|
one-page
hardware paper; Binary Arithmetic exercises
|
4
|
|
General
SW Concepts, Operating Systems, Windows, UNIX
|
Ch
2, 8, WIN
|
one-page
software paper
|
5
|
|
Desktop
Publishing, Graphics/MSPaint, OLE, other MS
tools (Pwrpnt...)
|
TBA
|
(see
next section: Assignments)
|
6
|
|
Telecommunications,
networks
|
Chap
6
|
End
of Chapter exercises
|
7
|
|
Midterm
Test (1st half of period) Lecture: MIS,
Strategic/Competitive use
|
McF,
Porter
|
Comparative
one-page paper
|
| |
|
{ Fall
|
Break |
{ |
8
|
|
BASIC
Programming
|
BASIC
Note
|
Homework
#8, below
|
9
|
|
O.O.P.S.!
|
|
|
10
|
|
Excel (optimization,
macros),
Visual Programming I
|
VB
|
Macro exercises
|
11
|
|
Visual BASIC II, DBMS I
|
VB, Access
|
|
12
|
|
DBMS II
|
Access
|
|
13
|
|
Systems Development Methods
|
|
Short paper
|
| |
|
Review, Problems
|
|
Optional session, to be scheduled
|
| |
|
Final Exam
|
|
|
The work you submit
must be your own. Cite your sources in a bibliography
|
Do not discard your files on the 1-page
papers. You will need them to post on your web page and
to turn in at the end of the term. |
- Email &
the Web
(due
on 3rd session)
(Please, buy 2 or more
diskettes)
|
A. Obtain your email user name and password
if you do not have them
B. Chain email? Form a group of 4 or more (e.g.
Ashley, Boyd, Richardson, Ying).
Alphabetically, the first member (in this case Ashley)
sends a brief message to B (with cc:
R & Y) as to what this
term's CIS theme ought to be. B adds a
brief comment, forwards to R with cc: A
& Y, etc. Last person (Y)
adds comment with cc: A & Y
& forwards to PAPAYANO@pegasus. Please, begin Subject
line with the code CIS.
Begin each message with your email address followed by
your name (last name, first) C. Surf the Web.
Write a 1-page report on two diverse, exotic
"places" and one discussion group that you
discovered. |
2. Getting on
the Web
|
A. What?
You are not on the web yet? Create your web page according to our
class discussion (& post your one-page papers
starting with Homework
#1C). B. Check the World Wide Web
Consortium website and the history of
the WWW. C. TBA |
3. Hardware
& Systems Concepts
|
A.
Using an article(s) from a trade journal or the daily
press, write a 1-page paper on a "hardware" topic of
general interest. B. Read Chap. 1, 3, 4, 5 in
Discovering Computers C. Do
practice problems given out on 2/11 |
4. Software
& Operating Systems
|
A. Using an
article(s) from a trade journal or the daily press, write
a 1-page paper on a "software"
topic of general interest. B.
Read Chap. 2, 8 in Discovering
Computers C.
Write the ASCII representation of your last
name
D. WIN
Project 1, "In the Lab", #2;
Project 2, "In the Lab", #2&3;
Project 3, "In the Lab" #2 (Windows
Explorer). |
You know, of course, that sessions 5 and 6
have been reversed
|
Please, note style/format
of one-page papers, below. Also, note that MS Word is one of
the short-review topics. You must decide how well you
know it --from prior courses and/or experience. The
following is a bigger assignment than I would normally
ask for. Hand in as much of it as you consider reasonable
& appropriate for your needs. Accordingly, from the MS Word section of
the text, please do:
|
5. Document
Processing & Desktop Publishing
|
A. Art show: Create an
original Paint picture & post it on
your web site
B. MSW
Project 1 "In the Lab" Exercise #2
C. MSW
Project 2 "In the Lab" Exercise #2
D. MSW
Project 3 "In the Lab" Exercise #2
E.
MSW Project 4 "In the Lab" Exercise
#2
F. MSW Project 6 "In
the Lab" Exercise #3 |
6. Telecomm
|
Midterm questions will be based, in part,
on end-of-chapter exercises |
7. Strategic Uses
|
1-page
paper (as per class discussion) |
8. BASIC
|
Click here for
assignment. |
9. Excel & VB
(Hand in hard copy for (a)-(c);
part (d)
will not be collected; do as much as you need to get
comfortable with Excel)
|
(a) In the Lab exercise
# 2, p E5.55 of Project 5. (b)
Using Excel
solve
MAX 6 X + 4 Y + 5 Z
SUBJECT TO:
5 X + 7 Y + 8 Z < 925
6 X + Y + 15 Z < 975
X + 3 Y + 7 Z < 545 , all variables being
non-negative.
(c) Repeat with
equalities (replace < with = in the 3
inequalities)
Can you verify the accuracy of the solutions using
different software?
(d) Project 1 "In
the Lab" # 1-3
Project 2 "In the Lab" # 1-3
Project 3 "In the Lab" # 1-3 |
10. Visual BASIC
|
Write an
event-driven version of (a)
the Payroll program and (b) the
Calculator program of Homework #8. |
11. Access
(Hand in hard copy for all)
|
Project 1
(Creating) In the Lab exercises # 1 and 3
Project 2 (Querying) In the Lab exercises # 1 and
3
Project 3 (Maintaining) In the Lab exercises # 1
and 3
Read these sections and do as many of the other
exercises as possible |
What's included in Final Exam (This is a partial list;
will discuss in class)
|
All class
notes (including, but not
limited to, Telecommunications, Strategic Uses of IT, QBASIC,
VBA, & Solver topics)
Excel Chapters ("Projects"): 1, 2, 5
Access Chapters ("Projects"): 1,
2, 3 |
| |
Be sure to check links from this page
(via Student Web
Pages) to your
individual page. Post your "1-page"
homeworks and a little something about yourself. Also,
don't forget your artwork (see Homework 5.A). |