The University of Western Ontario
London, Canada

Department of Computer Science


Computer Science 1032a – Information Systems and Design

Course Outline -- Fall Term 2011

 

Course Description

 

Computer Science 1032a is an introduction to information systems and the roles played by these systems in business.

 

This course satisfies the Information Technology requirement for a Certified Accountant, a Certified General Accountant or a Certified Management Accountant accreditation. The content of the course has been approved by The Institute of Chartered Accountants of Ontario, The Certified General Accountants of Ontario and The Society of Management Accountants of Ontario. The materials used in this course for the introduction to Microsoft applications software have been approved by Microsoft for use in the preparation for the Microsoft Office Specialist Certification exams.

 

Prerequisites

No prerequisites are required for this course.

 

Instructor: Diane Goldstein

Office: Middlesex College 366
Office Hours: to be announced
Phone: 661-2111 ext. 82978
E-Mail: dianeg@uwo.ca

 

Required Material

Experiencing MIS, Updated Second Canadian Edition, with Access to MyMISlab

David M. Kroneke, Andrew Gemino, Peter Tingling (Prentice Hall)

 

Course Web Page

 

The course website is located within WebCT. To access WebCT, navigate to http://webct.uwo.ca, select the “University of Western Ontario” link and login with your university personal computer account. Lecture notes, assignments and class information will be posted at this site. You are responsible for reading this information frequently.

 

Course Schedule

 

CS1032a Section 001 CS1032a Section 002

Lecture Times: Lecture Time:

Tuesday 11:30 am – 12:30 pm Tuesday 7 – 10 pm

Thursday 10:30 am – 12:30 pm

Location: Social Science Centre, Rm 2050 Location: Sommerville House, Rm 3345

 


Course Topics

  • Communications and Network Technology
    • Internet, WWW
    • Markup Languages: HTML, XML
    • Networks: LAN, WAN, VPN
  • Database Systems
    • Relational database concepts
    • Database design: Entity Relationship Diagrams
    • Query languages: SQL
    • Creating and using databases: Access
  • Information Systems
    • Enterprise Resource Planning systems
    • Reliability, availability, maintainability and integrity
    • Security
    • Systems Development Life Cycle
  • Spreadsheet applications
    • Designing and using spreadsheets: Excel

 

Scheduled Lectures

 

The scheduled lectures for the course use presentation software and appropriate applications software to present the course content. The required course materials supply portions of the course content. Readings and practice exercises will be assigned. Students are expected to come to class prepared, by completing the readings and exercises before class.

Lecture materials will be available on the course website. These materials are intended to aid in note-taking and provide review of course content. They are not complete course notes and are not a substitute for attending lectures.

Classroom Conduct

Students are expected to arrive promptly and remain in class until the end of the lecture, so as to not disturb others in the class. The use of a laptop is permitted during class, but it is expected that its use will be to assist in the learning of course materials and not for any other activities. Any behaviour or activity that may impede the ability of you or other students to learn will not be tolerated and if the behaviour persists the individual(s) involved will be asked to leave the classroom.

 

 

Teaching Assistant Consulting

 

Consulting will take place in one of the computer labs located in Middlesex College and the schedule will be posted on the course website once it has been established. Questions regarding assignments or lecture materials should be directed to the course Teaching Assistants (TAs) during their consulting hours. Questions requiring further information can be dealt with by contacting the course instructor.

 


Email Contact

 

Occasionally email messages may be sent to the entire class or to students individually. Email will be sent to your UWO email address as assigned to you by Information Technology Services (ITS).  It is your responsibility to read this email on a frequent and regular basis. You may wish to have this email forwarded to an alternative email address; see the ITS website for instructions on forwarding email. 

You should note that email at the university and thru other providers have quotas or limits on the amount of space that is dedicated to each account. Unchecked email may accumulate beyond those limits and you may be unable to retrieve important messages from the university. Losing email is not an acceptable excuse for not knowing about the information that was sent.

Email contact with the course instructor is encouraged, by sending brief and appropriate messages regarding lecture material or assignments. However, please first check the course discussion area in WebCT to see if the information has already been posted. If you contact the instructor via email or post a question on the WebCT discussion area, you can expect a response in a timely fashion, but not necessarily an instantaneous response. Please use proper, appropriate and respectful English when sending an email message or posting on the WebCT discussion area.

NOTE:  Email messages must be sent from your university account.

 

Computing Facilities

Students may complete their assignments on their own computer if it is equipped with the proper software or use the computers in the first-year Computer Science labs in Middlesex College or use the university’s General Student Computing Labs.

To use the Computer Science labs, each student will require an account on the Computer Science Department undergraduate computing facility, GAUL.  Computer Science account information will be forwarded to you via email. Details on this account can be found on the Computer Science Department’s web site, in the Computer Sciences Systems Group information on the Undergraduate Network (http://www.csd.uwo.ca/FAQ/node20.html).

In accepting the GAUL account, a student agrees to abide by the department's Rules of Ethical Conduct (http://www.csd.uwo.ca/UnderGrad/ethical.shtml).

The General Student Computing Labs at the university are currently located in:

  • HSB13, HSB14 & HSB16 - Health Sciences Building, rooms 13, 14, and 16
  • NCB 105 - North Campus Building, room 105
  • NSC 110 - Natural Sciences Centre, room 110
  • SH 1310 - Somerville House, room 1310 (lower level)

         SSC1000, SSC1012 & SSC1032 - Social Science Centre, rooms 1000, 1012 and 1032
Student Evaluation

         Midterm Exam: 2 hours (worth 33%)

         Final Exam: 3 hours (worth 37%)

         4 Assignments (worth a total of 30%)

To be eligible to obtain a passing mark in the course, the weighted average of the midterm and final exams must be at least 45%.

Note: weighted average = (total of weighted marks/sum of the weights) and

weighted mark = (weight*mark))

 

Academic Accommodation for Medical Illness

If you are unable to meet the course requirement due to illness or other serious circumstances, you must provide valid medical or other supporting documentation to your Dean’s office as soon as possible and contact the instructor immediately. It is the student’s responsibility to make alternative arrangements with the instructor once the accommodation has been approved and the instructor has been informed. For further information please see: http://www.uwo.ca/univsec/handbook/appeals/accommodation_medical.pdf.

A student requiring academic accommodation due to illness should use the Student Medical Certificate when visiting off-campus medical facility or request a Record’s Release Form (located in the Dean’s Office) for visits to Student Health Services. The form can be found at: https://studentservices.uwo.ca/secure/medical_document.pdf.

Exam Schedule

No electronic devices are allowed during exams (no calculators, iPods, cell phones, laptops, etc)

Note: Computer-marked multiple-choice exams may be subject to submission for similarity review by software that will check for unusual coincidences in answer patterns that may indicate cheating.

Midterm Exam

  • Tentatively set for Sunday, October 30, 2011, from 2:00 to 4:00 pm.
  • The location of the exam will be posted on the course website. 
  • Students requesting to write the deferred midterm for religious reasons, must notify the instructor and file documentation with their Dean’s office at least 2 weeks prior to the exam.
  • If you miss the Midterm Exam for any other reason, follow the procedure for Academic Accommodation for Medical Illness as given above. If the accommodation is approved by the Dean’s office, you will be granted permission to write the scheduled deferred exam.

Final Exam

  • The date, time and location of final exam will be announced by the Registrar’s Office.  The final exam will be held during the university final examination period (Saturday, December 10 to Wednesday, December 21).
  • Students requesting a deferred final exam prior to the final exam must supply their Dean's Office with written documentation at least 2 weeks prior to the Final Exam.
  • In the event of serious medical or compassionate grounds, a student must follow the procedure for Academic Accommodation for Medical Illness as given above.
  • A “Recommendation of Special Examination” form must be obtained from the Dean’s office, to be eligible to write the deferred final exam.

Assignment Schedule

Students are expected to view demonstrations during lectures and to do the exercises to prepare for the assignments. Once the assignment is completed, all of the parts of the assignment must be submitted on the WebCT site. It is the student’s responsibility to ensure that all parts of each assignment are correctly uploaded and submitted in WebCT, to ensure that the assignment can be marked accordingly.

Note: Assignments emailed to the instructor will not be accepted, unless there are extenuating circumstances.

The tentative assignment schedule is given below.

Assignment

Weight

Due Date (by 6:00 pm)

1

7%

Wednesday, October 5, 2011

2

8%

Wednesday, October 19, 2011

3

7%

Wednesday, November 16, 2011

4

8%

Wednesday, November 30, 2011

Note:  The instructions for each assignment will be posted on the course website at least 2 weeks in advance of the due date.

If for any reason the assignment schedule given above cannot be adhered to, the assignment marks will be pro-rated. The 4 assignments are worth 30% of the overall mark for the course. If an assignment has to be cancelled for any reason, the remaining assignment weights will be prorated to add up to 30%.

Assignment Marking:

  • Assignments will be marked by the TAs within 2 weeks of the assignment due date.
  • Individual marks and a detailed marking scheme will be posted in WebCT.
  • Questions regarding the marking of assignments should be directed to the course instructor.
  • Requests for mark adjustments will only be considered if they are made within 1 week of receiving the assignment mark. Assignment marks will be final after that date.
  • Requests for mark adjustments will only be considered when they are made in person and are for adjustments of 5 marks or greater.

Late Policy for Assignments:

         Late assignments will have a penalty of 25% of the maximum mark for the assignment deducted for each day (24 hours from the due time) that the assignment is late. Thus, if a student would have received 90% on an assignment, if it was submitted one day late the student would receive 65%, if it was submitted two days late the student would receive 40% and if it was submitted 3 days late the student would receive 15%.

        An assignment that is more than three days late will not be accepted.

        No extensions will be given for assignments. However, in the event of serious medical or compassionate grounds, a student must follow the procedure for Academic Accommodation for Medical Illness as given above. If an academic accommodation is approved by the Dean’s office, the weight of the assignment will be moved to one of the two exams.

Accessibility

Please contact the course instructor if you require material in an alternate format or if you require any other arrangements to make this course more accessible to you. You may also wish to contact Services for Students with Disabilities (SSD) at 661-2111 x 82147 for any specific question regarding an accommodation.

Ethical Conduct

 

Scholastic offences are taken seriously and students are directed to read the appropriate policy, specifically, the definition of what constitutes a Scholastic Offence, at the following Web site: http://www.uwo.ca/univsec/handbook/appeals/scholastic_discipline_undergrad.pdf.

 

Plagiarism: Students must complete their assignments in their own words. Whenever students take an idea, or a passage from another author, they must acknowledge their debt both by using quotation marks where appropriate and by proper referencing such as footnotes or citations. Plagiarism is a major academic offence (see Scholastic Offence Policy in the Western Academic Calendar). The University of Western Ontario uses software for plagiarism checking. Students will be required to submit their programs in electronic form for plagiarism checking.

 

All assignments are individual assignments. You may discuss approaches to problems among yourselves; however, the actual details of the work must be an individual effort.

 

The role of tutoring is to help students understand course material. Tutors should not write part or all of an assignment for the students who hire them. Having employed the same tutor as another student is not a legitimate defense against an accusation of collusion, should two students hand in assignments judged similar beyond the possibility of coincidence.

 

Academic dishonesty in assignments includes (but is not limited to): unacceptable collaboration, copying of another student’s assignment, allowing another student to copy, using code from an external source where a student’s own code is expected.

 

Assignments that are judged to be the result of academic dishonesty will, for the student's first offence, be given a mark of zero for the assignment, with an additional penalty equal to the weight of the assignment also being applied.

You are responsible for reading and respecting the Computer Science Department's policy on Scholastic Offences (http://www.csd.uwo.ca/UnderGrad/scholastic_offences.shtml) and Rules of Ethical Conduct (http://www.csd.uwo.ca/UnderGrad/ethical.shtml).