Unformatted text preview: Career & Management Studies GENERAL INFORMATION
Course Title Course Number Course Co-Requisite(s) Course Schedule
Tuesday section: Tuesdays 6:00- 9:00 pm Information Systems M G C R 3 3 1 Course Outline
Section 7 6 1 Semester
Winter Year 2011 Course Pre-requisite(s) CMSC 101 College Algebra and Functions
Monday section: Monday 6:00 to 9 pm INSTRUCTOR INFORMATION
Name Leo Kerklaan
Office Hours Phone (514) 683-9619 E-mail [email protected]
Before class from 5:30pm in Burnside Hall - Room 1B45 ADDITIONAL INSTRUCTOR(S)
Name Charles Quesnel
Section 7 5 Phone (514) 694-1932 E-mail [email protected] 1 Office Hours Before class from 5:30pm in McConnell Engineering Building - Room 13
Phone E-mail Name
Section Office Hours COURSE DESCRIPTION (as per Calendar)
Introduction to principles and concepts of information systems in organizations. Topics include information technology, transaction processing systems, decision support systems, database and systems development. Students are required to have background preparation on basic micro computer skills including spreadsheet and word-processing. COURSE OBJECTIVES
From the theory side of this course: Obtain a clear understanding of I.S. and its critical importance in supporting and transforming business organizations in a global, web based environment. Topics include: Ethics, privacy, security, ecommerce, mobile computing, business systems and management, along with issues related to data, information and knowledge management. On the practical side, the following two topics, supported by 2 major assignments, will be covered in depth: 1) Assuming our students have basic Excel spreadsheet knowledge, we will examine how Excel can be used as a decision making and reporting tool. Here we will cover a host of powerful functions along with tools such as Filtering, Pivot Tables, Sub Totals, Charting, Tables, Goal Seeking and the Solver. 2) With no assumed prior knowledge, we will examine the creation, use, and understanding of a relational database. Examine the powerful means to capture, query, report and display the transformation of data into information and knowledge using Microsoft Access. McGill University Centre for Continuing Education Career and Management Studies - Page 1 READING MATERIAL
Required Theory text: Introduction to Information Systems - Supporting and Transforming Business Canadian Edition. The authors are: Rainer, Turban, Splettstoesser-Hogeterp, Sanchez-Rodriguez and is published by Wiley. Recommended EVALUATION
Assignment Due Date
13 Additional Evaluation Information
Major Excel assignment Major Access database assignment Short - Theory paper Monday class: Feb. 28 - Tuesday class: Feb. 15 Small group presentation. Details will be provided in class. Details provided in respective classes. Date, time and location to be announced. Assignment 11-Apr-11 13 Assignment Mid-Term Week 9 Week 7 5 25 Presentation
Participation Final Exam 5
4 35 TOTAL 100% COURSE REQUIREMENTS
Your will need access to the internet with a computer that has the following software: Microsoft Excel, Access. Word and Power Point (any version will do - In class the lecturers will be using Office 2010). Both the Monday and Tuesday classes will use the Student Response System (clicker). This device can be obtained from the McGill University Bookstore (Purchased as new or used and returned upon completion of the course). ADDITIONAL INFORMATION
Both the Monday and Tuesday classes use the classroom recording system. This will enable you to watch the recording of each of the 13, 3 hour classes (lecturers computer screen and voice) through the web. Additionally, our courses web site on WebCT has numerous short e-learning video modules dealing with specific topics in both Excel, Access and database concepts. These modules reinforce the actual in class teaching material. Note: The week of February 21 is considered Study Break. There are no university classes this week. The instructor uses myCourses (WebCT) mail to communicate with students.
McGill University Centre for Continuing Education Career and Management Studies - Page 2 DETAILED COURSE OUTLINE:
Jan. 4 & 10 TOPICS
Introduction to the course. Excel - Short introduction and the use of the VLookUp and IF functions. Ch 1 - Modern organizations in the global, web-based environment. Excel. Round and other functions. READINGS AND ACTIVITIES
Note: The 2 dates are for the Tuesday & Monday classes. Read theory chapter 1 - for next week's class. Download, print and start the excel assignment. Regularly check the lecturers weekly agenda for more details. Read chapter 2 for next week. Work on the Excel assignment. Work on your theory paper. 2 Jan. 11 & 17 3 Jan. 18 & 24 Ch 2 - Information Systems: Concepts and Management. Excel: Sorting, Filtering, Pivot tables.
Ch 5 - Network applications. Excel: Subtotals. Database functions. Charts. text to columns. Data Validation. Read chapter 5 for next week. Note: Chapters 3 & 4 will be covered after the midterm. Work on the Excel assignment. Work on your theory paper.
Read chapter 6 for next week. Work on the Excel assignment. Work on your theory paper.
Read Tech Guides 1 & 2 found at the end of the theory text for next week. Work on the Excel assignment. Work on your theory paper. Start thinking about the midterm Work on the Excel assignment. Work on your theory paper. Prepare for the midterm. 4 Jan. 25 & 31 5 Feb. 1 & 7 Ch 6 - E-Business and E-Commerce. Excel: Date, Time, text functions. Tables, Goal seeking, Solver. Macros. Tech Guide 1 & 2 - Computer hardware and software. Excel: Midterm preparation. 6 Feb. 8 & 14 7 Feb. 15 & 28 Midterm examination. No class before or afterwards. Ch 3 - Ethics, privacy and information security. Access & databases: Tables & properties. Importing data. Read chapter 3. Complete your Excel assignment. Work on your theory paper. Read chapter 4. Complete your theory paper. Work on your Access database assignment. 8 Mar. 1 & 7 9 Mar. 8 & 14 Ch 4 - Data, information and Knowledge Management. Access: Various type of Queries.
Ch 7 - Wireless, mobile computing & commerce. + Tech Guide 4 Access: All about creating Reports. Ch 8 - Organization Information Systems. Access: Additional data types & all about Forms. Access & databases: Final exam preparation reinforcing material above.
Ch 10- Acquiring Information Systems and Applications. Access & databases: Final exam preparation. Read chapter 7. Work on your Access database assignment. 10 Mar. 15 & 21 Read chapter 8. Work on your Access database assignment. 11 Mar. 22 & 28 Read chapter 9. Work on your Access database assignment. 12 Mar. 29 & Apr 4 Ch 9 - Managerial support systems. Read chapter 10. Work on your Access database assignment. 13 Apr. 5 & 8 Complete your Access database assignment. Prepare for your final exam. Check your grades in WebCT to ensure that you have received proper credit for your work. McGill University Centre for Continuing Education Career and Management Studies - Page 3 RIGHT TO SUBMIT IN ENGLISH OR FRENCH WRITTEN WORK THAT IS TO BE GRADED ADDITIONAL INFORMATION
Graduate Level (85-100% Pass (80-84%) (75-79%) (70-74%) (65-69%) In accord with McGill University's charter of students' rights, students in this course have the right to submit in English or in French any written work that is to be graded. In cases where language acquisition is part of the assessment objectives, the work must be submitted in the language evaluated. Grade
A AB+ B BC+ C D* Undergraduate Level
(85-100% (80-84%) (75-79%) (70-74%) (65-69%) (60-64%) (55-59%) (50-54%) Conditional (0-49%) Failure Pass ASSIGNMENTS PICKUP Marked assignments cannot be picked up from the offices at Continuing Education, therefore if your marked assignments are not available in class before the end of term you must submit a selfaddressed stamped envelope to your instructor or these assignments will not be returned. Remember to keep a photocopy or back-up of your creative work before it is handed in to your instructor. (0-64%) Failure Pass F P EMAIL POLICY * Although D is a passing grade, it will not permit entry into a subsequent course for which it is a prerequisite, nor will it be recognized if the course is a compulsory course in your program. POLICIES
McGill University values academic integrity. Therefore all students must understand the meaning and consequences of cheating, plagiarism and other academic offences under the Code of Student Conduct and Disciplinary Procedures (see www.mcgill.ca/integrity for more information). E-mail is one of the official means of communication between McGill University and its students. As with all official University communications, it is the student's responsibility to ensure that time-critical e-mail is assessed, read, and acted upon in a timely fashion. If a student chooses to forward University e-mail to another e-mail mailbox, it is that student's responsibility to ensure that alternate account is viable. Please note that to protect the privacy of the students, the University will only reply to the students on their McGill e-mail account. RESOURCES
Various services such as Walksafe, McGill Libraries, the Writing Centre, the bookstore, etc., are available to Continuing Education students (www.mcgill.ca/ conted/studentres/services/). FINAL EXAM POLICY REGULATIONS Students should not make other commitments during the final exam period. Vacation plans do not constitute valid grounds for the deferral or the rescheduling of examinations. See the Centre for Continuing Education Calendar for the regulations governing examinations or go to (www.mcgill.ca/ conted/studentres/records/exams/regulate/). IDENTIFICATION Students are required to present their McGill photo I.D. card for entrance to their examination. EXAM SCHEDULE Examination schedules are posted online approximately 6-8 weeks before the examination period begins (www.mcgill.ca/conted/studentres/ records/exams/cmsexams/). COMPUTER LABS Free access to computer labs are available at 688 Sherbrooke (12th floor), MACES, the McLennan Library and other location on campus. MINERVA AND ONLINE RESOURCES Access your personal student information online with Minerva (www.mcgill.ca/minerva-students). Information regarding online resources such as email, VPN, myCourses (WebCT), etc. can be found at www.mcgill.ca/it. MACES The McGill Association of Continuing Education Students, MACES (www.maces.mcgill.ca), is located at 3437 Peel, 2nd floor, tel. (514) 398-4974. "In the event of extraordinary circumstances beyond the University's control, the content and/ or evaluation scheme in this course is subject to change." McGill University Centre for Continuing Education Career and Management Studies - Page 4 ...
View Full Document
- Spring '09
- Management, Visual Basic for Applications, Microsoft Office 2007, Access Database assignment