|
|
|
|
|
Lecturer: Dr. Guy J. Cortesi [email protected] Office Hours: by appointment Course Description: ITM 510 will
motivate students to be more involved in understanding and building
end-user applications using Excel and elements of VBA. The majority of
business users use less than 10% of Excel’s capabilities. This course
will help you expand your knowledge of the built-in functions (mostly
financial and statistical), other Excel tools (Data Analysis, macros)
and elements of VBA used in decision making. (The selection of
functions and content was made in cooperation with other business
areas, based on what will be discussed during the MBA program). Course Objectives: By the end of the course you should be able to:• Develop and demonstrate your technical skills through developing elementary spreadsheets, elements of Excel objects and macros • Extend your analytic skills in the areas of data and decision making • Practice reflective thinking through analysis of various requirements in business oriented problems • Be able to easier participate in discourse in your business environment and in other courses Textbook 1. Crnkovic, J and Baltzan, P.: Advanced Excel (Custom text) McGraw Hill, 2008 The textbook is required and will be used in class. It is important for all course students to have an Internet-based e-mail account for this class. Students may use a university account or their own personal account. Course Website This course has its own web site, containing assignments and readings. Please consult this site for the latest information regarding this course. It is located on the Internet at: <https://www.albany.edu/~gc227838/itm510> The course also uses Blackboard to manage Project submittals
and assignments. Please refer to your Blackboard account for
these item. ITM 510 is an S/U course. Your achievement of these objectives will be assessed through a combination of individual assignments and a group project. There are four individual projects (max 20 points each) and a test (max 20 points). To be successful (S), you must amass 70 or more points. Total possible points = 100. An (S) requires a
total of 70 points. Participation Each student is expected to participate in every class. Positive participation means speaking so everyone can hear; asking appropriate questions; replying to questions, contributing ideas and participating in discussion without dominating it; and helping others. Positive participation creates a supportive learning environment in which other students feel comfortable asking questions and everyone contributes to the discussion. Positive participation requires that students come prepared for class. This means distilling the terminology and major concepts of assigned readings; having points of personal interest in mind for discussion; having questions in mind for ideas that are unclear; knowing what the day’s topics will be and what assignments are due; and bringing appropriate texts, materials, and tools for the day’s class. Written and Verbal Expression Being able to communicate effectively with all sorts of people is necessary for sustained success in managing information systems. Students are expected to use proper spelling and grammar and to adapt their speaking and writing to their audience. Those who habitually use words, phrases, abbreviations or acronyms that may be unfamiliar to the audience without proactively explaining them in an understandable way, will have points deducted in written assignments and in class participation as applicable. Class Attendance/Lateness There will be a
15 minute break during each class. Students are expected to attend
every scheduled class. Students are responsible for all
assignments, handouts, and work done in classes that are missed. Academic Honesty Students are expected to understand and abide by the “Standards of Academy Integrity” in the Graduate Bulletin at: https://www.albany.edu/grad/requirements_general_admissions.html#standards_integrity Class Schedule The class meets on Wednesdays from 5:45-8:35PM in BA222.
The
schedule of classes as well as the other information in
this syllabus is subject to change. The latest, authoritative
version is
the current one posted this website. All necessary changes will be
announced in class. Test date will not be changed.
Assignments (Projects)
Updated 1/5/2010 gjc |