INF1020: Management Information Systems - Syllabus

Contact Information

Name	Prof. Yitzchak Rosenthal
Office	Belfer Hall room 1313-D
Telephone	(212)960-5400 x5438 (best way to reach me is via email)
Office Hours	Wilf Campus - M/W 4:15-5PM or after class; Beren Campus - M/W 1:10-1:45 or after class
Email

Course Objectives

To provide a level of computer literacy necessary to succeed in today's business environment. The course will cover software applications from the Microsoft Office suite of applications as well as a general introduction to computing concepts.

Books

New Perspectives: Microsoft Office 2003, First Course, Second Edition
Course Technology
by: Shaffer, Carey, Finnegan, Adamski, Ageloff, Zimmerman
ISBN: 0-619-26808-5
Publisher's website for book: http://www.course.com/downloads/newperspectives/Office2003/FirstCourse2e.cfm
Student Downloads: http://www.course.com/catalog/downloads.cfm?isbn=0-619-26807-7
New Perspectives: Computer Concepts, Comprehensive, 8th Edition
by Parsons and Oja
Course Technology
ISBN: 0-619-26765-8
Publisher's website for book: http://www.course.com/np/concepts8

Grading

Homework: 20%
Midterm: 40%
Final: 40%

Attendance

You are permitted up to 3 absences. If you have more than 3 absenses then you MUST have a very good excuse for ALL of your absenses or else your grade will suffer.

Topics

Date	Topics	Readings
Week 1	Overview of YU computing facilities: network accounts, email, angel, forwarding ymail to another email account, submitting HW to angel. Major parts of a computer (CPU, memory, secondary storage, etc.) Overview of operating systems and the Windows user interface. Using Windows Explorer. Folder hierarchy, full path to file/folders, shortcuts, compressed (zip) files.	Office 2003 (read following sections): Essential Computer Concepts, Exploring the Basics of Microsoft Windows XP, Managing Your Files, Using Common Features of Microsoft Office 2003 Computer Concepts: Orientation section
Week 2	Digital vs. Analog. Advantages/disadvantages of each. How computers store information. Binary number system and the representation of information. What files actually contain. Filename extensions. Executable files. Sizes of data (bytes, KB, MB, GB, TB, etc). Data rates (KbPS, MbPS, etc). Intro to Microsoft Excel. Using the user interface. Basic formatting. Simple formulas. Format cells.	Office 2003: Excel tutorial 1 Computer Concepts: p. 60-67, p233-234 (analog/digital), Chapter 2 - Computer Hardware
Week 3	Excel formulas in depth. Order of operations, functions, paramaters/arguments, nested functions. SUM(), AVERAGE(), MIN(), MAX(), COUNT(), etc. Date functions, filling a series.	Office 2003: Excel Tutorial 2 Computer Concepts: N/A
Week 4	Logical data types and functions. Other types of cell references: other worksheets, absolute vs. relative.	Office 2003: Excel Tutorial 3 Computer Concepts: N/A
Week 5	Advanced formatting. Excel charts and graphics. Intro to computer networking concepts.	Office 2003: Excel Tutorial 4 Computer Concepts: Chapter 5 - Internet and Lan Technology
Week 6	Overview of basic Internet architecture. Intro to HTML.	Office 2003: N/A Computer Concepts: Chapter 6 - Web pages, web sites and E-Commerce
Week 7	More Internet architecture. More HTML. Hosting a website. FTP. MIDTERM	Office 2003: N/A Computer Concepts: N/A
Week 8	Intro to databases and Microsoft Access. Tables, primary keys, foreign keys, many-one relationships, one-one relationships, data types, creating a database in Access, simple queries.	Office 2003: Access - Tutorial 1 Computer Concepts: Chapter 10 - databases
Week 9	Access - advanced quries. Modifing a database.	Office 2003: Access - Tutorial 2 & 3 Computer Concepts:
Week 10	Access - more queries, forms, reports.	Office 2003: Access - Tutorial 4 Computer Concepts: N/A
Week 11	Overview of large scale corporate computing. Intro to Microsoft PowerPoint	Office 2003: Powerpoint - Tutorial 1 Computer Concepts: Chapter 12 - Beyond desktop computing.
Week 12	More Microsoft PowerPoint Intro to software development and programming using Microsoft VBA and Excel Macros	Office 2003: Powerpoint - Tutorial 2 Computer Concepts: Chapter 11 - Computer programming.
Week 13	More programming with VBA for Excel.	Office 2003: N/A Computer Concepts: N/A

Computer Resources

http://yrosenthal.com

This website, http://yrosenthal.com , will be the primary source for disseminating course related information. This includes the course syllabus, homework assignments and other course related materials.

YU Email (yums.yu.edu - YUMS stand for YU Mail System)

YU provides an email account (AKA ymail account) for every student and faculty member. I will be communicating with you via your yums accounts. You are ABSOLUTELY REQUIRED to check your YU email at least once a day. If you don't want to check your yums accounts regularly then you can forward ymail to any other email account (e.g. to your aol, yahoo or gmail accounts). See instructions on http://yums.yu.edu.

email address: Your email address is generally the first letter of your first name follwed by the first 7 characters of your last name followed by @yu.edu. (e.g. John Rosenbergersteinowitz would be jrosenbe@yu.edu). If you have a middle initial, it might appear after your first initial. To find your email address, you can search the following webpage for your name: http://yu.edu/search
password: If you have never logged into YUMS before then your password should be the first letter of your last name followed by the last 4 digits of your social security number. If you have used YUMS in the past then your password is whatever it was the last time you used YUMS.
Help with YUMS: Direct any problems you have with email to the MIS office on the 13th floor of Belfer Hall (room 1315). You can also call the YU MIS helpdesk at (212)960-5294 or email them at helpdesk@yu.edu.
Forwarding YUMS mail to another email account: See instructions on http://yums.yu.edu

Angel Online Course Management System:

Angel is a web-based course management system in use in many of YU's courses. You WILL need to login to the Angel system in order to submit your HW assignments. However, for the most part, course related information for my courses is posted on http://yrosenthal.com rather than on Angel.

Accessing the Angel website: https://angel.ac.yu.edu/yu/ (You can also get to it by following the link on http://yrosenthal.com or the link in the student section of http://yu.edu)
Angel userid: Your Angel userid is the same as your ymail userid without the @yu.edu (see the ymail section above). For example, if your ymail userid is jdoe@yu.edu then your Angel userid would be jdoe
Password: If you have never logged in before then your password should be the first letter of your last name followed by the last 4 digits in your social security number. If you have used Angel in the past then your password is whatever it was the last time you used Angel. Note: the password is NOT necessarily the same as your ymail password.
Help with Angel: If you have any problems with angel or can't login send an email to angelsupport@yu.edu

YU Network Accounts

Every student and faculty member in YU receives a userid and password that allows them to access the YU network.

Userid: Your YU Network userid is the same as your ymail userid without the @yu.edu (see the "YU Email" section above). For example, if your ymail userid is jdoe@yu.edu then your YU Network userid would be jdoe
Password: If you have never logged in before to the YU network then your password should be the first letter of your last name followed by the last 4 digits in your social security number. If you have used you YU Network account in the past then your password is whatever it was the last time you used Angel. Note: the password is NOT necessarily the same as your ymail password.
Where are the computers?: You can access the YU Network on the Wilf campus from computers in the Gottesman Library and from computers in rooms B1103, B1105 and B1111. On the Beren campus you can use the computers in the public labs or computer equipped classrooms in 245Lex or in 215Lex.
Where can I store my personal files? (MyDocuments, Z: drive, Desktop): Personal files that you want to store on the YU network can be stored in the MyDocuments folder. This folder is synonymous with the root folder on the Z: drive (ie. Z:\). The Z: drive for every user will contain their own files. You cannot access the Z: drive of any other user. You can also store files and information on your computer's "Desktop". However this is NOT recommended (keep reading). You are limited to approximately 25MB of storage space on the Z: drive and a much smaller amount on the Desktop. This IS NOT A LOT OF SPACE. You will need to occasionally "Clean your profile" to remove unneeded files by following the instructions in the "Cleaning your profile" link found on the desktop. If you run out of space, you will not be able to log off your YU Network Account until you free up some space.
Help with YU network accounts: Direct any problems you have with the YU network accounts to the MIS office on the 13th floor of Belfer Hall (room 1315). You can also call the YU MIS helpdesk at (212)960-5294 or email them at helpdesk@yu.edu.
USB drives / Thumb drives / Jump drives
: It is highly recommended that you purchase a "USB" drive (AKA thumb drive or jump drive) to save your files on. You can plug the USB drive into the flat USB port on the computer when you start working. When it is plugged in, the USB drive will appear as a new drive letter under windows. You can remove the USB drive and take it with you when you are done.

Other YU computing services (e.g. accessing the web from your dorm room)

Support for the YU computer systems is handled by two departments (1) the YU MIS department and (2) the YU Academic Computing, Networking and Support Services department. Information for both departments is available at: http://yu.edu/mis/. An all purpose help desk is available (http://www.yu.edu/mis/asp/help_desk.asp). Contact the Help Desk at: (212)960-5294 or e-mail at helpdesk@yu.edu