Spring 2002 CIS 5.2
Microcomputers
in Business Administration
Instructor Rave Harpaz
Email
rbharpaz@sci.brooklyn.cuny.edu
Office hours Before and after class, Mon+Wed 13:00-14:00
This course provides an overview of microcomputer applications for business administration, including a brief introduction to computer concepts, Microsoft Windows, Microsoft Office, Microsoft Word, Microsoft Excel, Microsoft Access, Microsoft PowerPoint, and Microsoft Outlook.
Textbook and Supplies
Microsoft
Office 2000: Introductory Concepts and Techniques,
Enhanced edition
by Shelly/ Cashman/ Vermaat (ISBN: 0-7895-6251-0)
Two 3 ½” floppy disks
Grading Your grade will be determined by your performance on 3-4 announced examinations, a final exam and a number of laboratory exercises and assignments. These will contribute to your grad as follows:
Laboratory exercises and assignments 40 %
Announced examinations (4) 40 %
Final exam 20 %
You are expected to read each assigned project prior to the lecture. Lectures will be short, to the point, and will discuss the highlights of the Project for that week. Most of the class time will be spent working on your Laboratory assignments.
Weekly Laboratory assignments can only be handed immediately BEFORE lecture begins the following week. Laboratory assignments handed in after lecture begins the following week are considered late.
No assignments will be accepted more than one week late. Late assignments are penalized 25%, and assignments two weeks late are penalized 50%. Plan to spend approximately six to eight hours each week working on laboratory assignments.
Attendance Although class attendance is not mandatory, you are responsible for whatever is done in class. While our textbooks cover most basic concepts, class is our only source for the specifics that will allow you to learn the material and pass the class. Make sure you get the notes and assignments if you miss a class. You should get at least one other students phone number.
Introduction to Computers (power point slides)
Windows 98 & Managing Files (power point slides, page INT 1.31-1.59)
Microsoft Office 2000 (page INT 1.61-1.74)
Word
Unit (weeks 3-7)
Project 1 - Creating And Editing A Word Document (page WD 1.1-WD 1.58)
Project 2 - Creating A research Paper (page WD 2.1-WD 2.52)
Project 3 - Using A Wizard To Create A Resume And
Creating A Cover Letter With A Table (page WD 3.1-WD 3.58)
Excel
Unit (weeks 7-10)
Project 1 - Creating A Worksheet And Embedded Chart (page E 1.1-E 1.57)
Project 2 - Formulas, Functions and Formating (page E 2.1-E 2.55)
Project 3 - ???
Access
Unit (weeks 10-13)
Project 1 - Creating A Database using Design And Datasheet Views (page A 1.1-A 1.51)
Project 2 - Querying A Database using The Select Query Window (page A 2.1-A 2.43)
Exam #3
PowerPoint
Unit (weeks 13-15)
Project 1 - Using A Design Template And Autolayouts To
Create A Presentation (page PP 1.1-A 1.67)
Project 1 - Using Outline View And Clip Art To Create
A Slide Show (page PP 1.1-A 1.67)