Information Systems Project

(1)

Information Systems Project

SCHOOL OF ADVANCED TECHNOLOGY

Course Number: Contribution to Program: Normative Hours:

DAT2250 Vocational

Core

60.00

Approval Date:

January 0001

Applicable Program(s): AAL:

0336X01FWO Computer Programmer 4 0336X03FWO Computer Programmer 4

Prepared by: Approved by:

Patricia Murphy Professor

Co-Requisites: Approved for Academic Year:

N/A 2008-2009

Pre-Requisites:

CST8285 and CST8288 and DAT2234D and DAT2335

COURSE DESCRIPTION

This course integrates the skills learned throughout the program. Following appropriate software engineering methodologies and using object-oriented modeling, teams plan, analyze, design, and implement computer applications. The teams manage and complete development and implementation of projects (case-study or real projects). Teams participate in: interviews; technical reviews; presentations; and technical report writing. The culmination of the course is a final presentation and submission of a finished product, including a complete documentation set.

RELATIONSHIP TO PROGRAM LEARNING OUTCOMES

This course contributes to your program by helping you achieve the following Program Learning Outcomes:

Computer Programmer - 0336X01FWO

1 Use documented solutions to troubleshoot problems associated with software installation and customization.(CP) 2 Develop, test, document, deploy, and maintain secure program code based on specifications.(CP)

3 Perform routine maintenance on a database.(CP)

4 Apply knowledge of networking concepts to develop, deploy, and maintain program code.(CP) 5 Gather and document required information and assist in an analysis of a business.(CP) 6 Use relevant methodologies, policies, and standards to develop secure program code.(CP) 7 Maintain effective working relationships with clients.(CP)

8 Conform to workplace expectations found in information technology (IT) environments.(CP)

9 Contribute to the successful completion of the project applying the project management principles in use.(CP)

Computer Programmer - 0336X03FWO

ESSENTIAL EMPLOYABILITY SKILLS

(2)

This course contributes to your program by helping you achieve the following Essential Employability Skills:

1 Communicate clearly, concisely and correctly in the written, spoken and visual form that fulfills the purpose and meets the needs of the audience.(CP)

2 Respond to written, spoken or visual messages in a manner that ensures effective communication.(CP) 3 Execute mathematical operations accurately.(A)

4 Apply a systematic approach to solve problems.(CP)

5 Use a variety of thinking skills to anticipate and solve problems.(CP)

6 Locate, select, organize and document information using appropriate technology and information systems.(CP) 7 Analyze, evaluate and apply relevant information from a variety of sources.(CP)

8 Show respect for diverse opinions, values, belief systems and contributions of others.(CP)

9 Interact with others in groups or teams in ways that contribute to effective working relationships and the achievement of goals. (CP)

10 Manage the use of time and other resources to complete projects.(CP) 11 Take responsibility for one's own actions, decisions and consequences.(CP)

COURSE LEARNING REQUIREMENTS/EMBEDDED KNOWLEDGE AND SKILLS COURSE LEARNING REQUIREMENTS

When you have earned credit for this course, you will have demonstrated the ability to:

EMBEDDED KNOWLEDGE AND SKILLS

1. Participate in project inception; planning and determining project scope and feasibility to work effectively with a client and meet their needs.

·Communicate clearly with client, in a timely fashion, to arrange and document meetings using email, agendas, and minutes. ·Conduct interviews with a client, to assess project scope and feasibility.

·Participate in planning, task identification, scheduling and assigning tasks using available project resources.

·Recognize implications of non-disclosure agreement (NDA). ·Prepare a preliminary investigation report including scope and feasibility (economic, tehnological, schedule, organizational).

(3)

2. Elaborate, document and build prototypes of project

requirements, based on a client's requests and the anticipation of their needs, using software engineering principles; object-oriented analysis and design modeling; knowledge of database design and networking theory.

·Gather more detailed information to use in the problem solving and analysis of system requirements.

·Evaluate and decide on the best alternative to pursue in the creation of a detailed design of the computer system.

·Use UML and software tools to create object-oriented models (class diagrams, use case diagrams, sequence diagrams and state transition diagrams) to represent the end user's requirements.

·Recognize role of business rules in analysis of business environment

·Apply knowledge of database design to create well-designed databases

·Using knowledge of component design and communication networks, create architectural models for programs in a networked environment

·Perform functional reviews of elaborated models with the end user.

·Participate in technical reviews with your team and course professor

·Build prototypes of high risk elements.

·Prepare a system requirement document (verified with end user), systems design specifications report, preliminary verification, validation and user documentation.

·Adapt models to end user's change requests.

3. Construct secure program code as part of a quality computer system, using knowledge of program development, testing, installation, communications, and technical writing.

·Create and execute test plans for verification and validation of classes, integrated components, system and installation. ·Follow appropriate methodologies to resolve problems effectively and minimize risk in the development of secure program code.

·Create database from detailed schema.

·Recognize potential security risks associated with creating a computer system

·Convert existing data to the new database (if necessary) ·Adapt product to end user's change requests

·Create complete industry-compliant technical documentation to support installation/uninstall and maintenance.

·Create end user documentation. 4. Participate in the transition phase to test and deploy the

entire computer system, in accordance with workplace and client's expectations of quality, standards and timely delivery.

·Apply knowledge of networking concepts to support development and deployment of programs.

·Install complete, quality and secure software system, complete with documentation, to meet client's expectations.

·Present and defend system integrity and project development choices using software engineering principles and workplace standards.

·Comply with software licensing agreements.

·Follow existing confidential and privacy regulations as they apply to work.

(4)

5. Work in a team environment, cooperatively and effectively, to successfully complete a software engineering project using an appropriate choice of tools to plan, schedule and track progress.

·Form and contribute to a project team, under a student project manager.

·Using scheduling software, create project schedules on Gantt charts and track work status, making adjustments to ensure timeliness.

·Show respect for the diverse opinions, values, belief systems, and contributions of others

·Interact with others in groups or teams in ways that contribute to effective working relationships and the achievement of goals. ·Manage the use of time and other resources to complete projects on time.

·Take responsibility for one's own actions, decisions, and consequences.

·Recognize personal limits and seek assistance in a timely manner to resolve problems. - WSR notes problems and resolution.

LEARNING RESOURCES

Project - To be announced by professor BlackBoard notes - Deliverable specifications BlackBoard announcements

Shared network team accounts

Recommended Textbook (purchased for DAT2234d):

1) Systems Analysis & Design in a Changing World, 4th edition by Satzinger, Jackson and Burd, Course Technology, ISBN 1-4188-3612-5 or

2) OO Systems Analysis & Design and the Unified Approach, Satzinger, Jackson, Burd, Course Technology, 2005

LEARNING ACTIVITIES

During this course, you are likely to experience the following learning activities:

Samples of learning activities include: - Project discussion

- Participation in problem solving during in-class lectures and team meetings

- Creation of documentation and executable for a fully functioning information system

EVALUATION/EARNING CREDIT The following will provide evidence of

your learning achievements:

This activity validates the following Course Learning Requirements and/or Essential Employability learning outcomes:

(5)

1. Documentation (35%) ·Participate in project inception; planning and determining project scope and feasibility to work effectively with a client and meet their needs. [CLR1]

·Elaborate, document and build prototypes of project requirements, based on a client's requests and the anticipation of their needs, using software engineering principles; object-oriented analysis and design modeling; knowledge of database design and networking theory. [CLR2]

·Construct secure program code as part of a quality computer system, using knowledge of program development, testing, installation, communications, and technical writing. [CLR3]

·Participate in the transition phase to test and deploy the entire computer system, in accordance with workplace and client's expectations of quality, standards and timely delivery. [CLR4]

·Work in a team environment, cooperatively and effectively, to successfully complete a software engineering project using an appropriate choice of tools to plan, schedule and track progress. [CLR5]

·Communicate clearly, concisely and correctly in the written, spoken and visual form that fulfills the purpose and meets the needs of the audience. [EES1]

·Respond to written, spoken or visual messages in a manner that ensures effective communication. [EES2]

·Execute mathematical operations accurately. [EES3] ·Apply a systematic approach to solve problems. [EES4]

·Use a variety of thinking skills to anticipate and solve problems. [EES5]

·Locate, select, organize and document information using appropriate technology and information systems. [EES6]

·Analyze, evaluate and apply relevant information from a variety of sources. [EES7]

2. Project Production Release -Technical Inspection And Product Review 40%

·Execute mathematical operations accurately. [EES3] ·Apply a systematic approach to solve problems. [EES4]

·Use a variety of thinking skills to anticipate and solve problems. [EES5]

·Locate, select, organize and document information using appropriate technology and information systems. [EES6]

·Analyze, evaluate and apply relevant information from a variety of sources. [EES7]

3. Presentation - 10% _{·Participate in the transition phase to test and deploy the entire computer system, in} accordance with workplace and client's expectations of quality, standards and timely delivery. [CLR4]

(6)

4. Peer and Professor's evaluation - 15% ·Participate in project inception; planning and determining project scope and feasibility to work effectively with a client and meet their needs. [CLR1]

·Elaborate, document and build prototypes of project requirements, based on a client's requests and the anticipation of their needs, using software engineering principles; object-oriented analysis and design modeling; knowledge of database design and networking theory. [CLR2]

·Show respect for diverse opinions, values, belief systems and contributions of others. [EES8]

·Interact with others in groups or teams in ways that contribute to effective working relationships and the achievement of goals. [EES9]

·Manage the use of time and other resources to complete projects. [EES10] ·Take responsibility for one's own actions, decisions and consequences. [EES11]

COLLEGE GRADING NUMERICAL EQUIVALENT TABLE

Final Grade Mark Equivalent Numeric Value Final Grade Mark Equivalent Numeric Value

A+ 90-100% 4.0 C+ 67-69% 2.3 A 85-89% 3.8 C 63-66% 2.0 A- 80-84% 3.6 C- 60-62% 1.7 B+ 77-79% 3.3 D+ 57-59% 1.4 B 73-76% 3.0 D 53-56% 1.2 B- 70-72% 2.6 D- 50-52% 1.0 F 0-49% 0 FSP 0 0

PRIOR LEARNING ASSESSMENT AND RECOGNITION

Prior Learning Assessment (PLA)

See College Directive E35 for details on eligibility and process. Not a candidate for PLA at this time.

RELATED INFORMATION The following information is course-specific:

Late assignments and deliverables will be treated as follows: any missed evaluation points will result in a grade of '0" (including missed interview, weekly status meetings and technical reviews) In the case of a documented emergency the professor, in consultation with the Chair, will determine how the marks will be made up and/or final grade adjusted.

Individual and team Weekly Status Reports (WSR) may impact the final grade on each assigned grade. Any team member who is consistently not contributing to the project could be asked to leave a team. Each student must contribute to deliverables, as part of a team, to meet the requirements of this course. If an individual team member does not adequately contribute to a deliverable (signed WSR), the professor will adjust the student's mark to fairly reflect their contribution.

(7)

professor's evaluation)listed above. All team members are expected to participate in each aspect of the project (documentation, coding, testing and presenting) as verified by acknowledgements in the documentation and WSR.

The following information is school/department-specific:

Retention of course material. It is your responsibility to retain copies of all assignments, labs and mid-term tests (returned from the professor), and any other evaluations and pertinent records (except for final exams, which are not returned) in case you become involved in an appeal hearing at a later date.

It is also your responsibility to retain course outlines for possible future use to support applications for transfer of credit to other educational institutions.

See College Directives E15 or E24 for details in your Instaguide.

Harassment/Discrimination/Violence will not be tolerated.Any form of harassment (sexual, racial, gender or disability-related), discrimination (direct or indirect), or violence, whether involving a professor and a student or amongst students, will not be tolerated on the college premises. Action taken will start with a formal warning and proceed to the full disciplinary actions as outlined in Algonquin College Directive - A8.

Harassment means one or a series of vexatious comment(s) (whether done verbally or through electronic means), or conduct related to one or more of the prohibited grounds that is known or ought reasonably to be known to be unwelcome/unwanted, offensive, intimidating, derogatory or hostile.

This may include, but is not limited to: gestures, remarks, jokes, taunting, innuendo, display of offensive materials, offensive graffiti, threats, verbal or physical assault, stalking, slurs, shunning or exclusion related to the prohibited grounds.

For further information, a copy of the official policy statement can be obtained from the Student Association.

Violation of the Copyright Act

· General - The Copyright Act makes it an offence to reproduce or distribute, in whatever format, any part of a publication without the prior written permission of the publisher. For complete details, see the Government of Canada website at http://www.cb-cda.gc.ca/info/act-e.html. Make sure you give it due consideration, before deciding not to purchase a textbook or material required for your course.

· Software Piracy- The Copyright Act has been updated to include software products. Be sure to carefully read the licensing agreement of any product you purchase or download, and understand the term and conditions covering its use, installation and distribution (where applicable). Any infringement of licensing agreement makes you liable under the law.

Disruptive Behaviouris any conduct, or threatened conduct, that is disruptive to the learning process or that interferes with the well being of other members of the College community. It will not be tolerated.

Members of the College community, both students and staff, have the right to learn and work in a secure and productive environment. The College will make every effort to protect that right.

Incidents of disruptive behaviour must be reported in writing to the departmental Chair as quickly as possible. The Chair will hold a hearing to review available information and determine any sanctions that will be imposed. Disciplinary hearings can result in penalties ranging from a written warning to expulsion.

For further details, consult the Algonquin College Directive - E27 in your Instaguide.

The following information is College-wide: Email

Algonquin College provides all full-time students with an e-mail account. This is the address that will be used when the College, your professors, or your fellow students communicate important information about your program or course events. It is your responsibility to ensure that you know how to send and receive e-mail using your Algonquin account and to check it regularly.

Centre for Students with Disabilities (CSD)

If you are a student with a disability, it is strongly recommended that you identify your needs to the professor and the Centre for Students with Disabilities (CSD) by the end of the first month of the semester in order that any necessary support services can be arranged for you.

Academic Integrity

Adherence to acceptable standards of academic honesty is an important aspect of the learning process at Algonquin College. Academic work submitted by a student is evaluated on the assumption that the work presented by the student is his or her own, unless designated otherwise. For further details consult Algonquin College Directives E16 (http://www.algonquincollege.com/directives/sectionE/E16.pdf) and E43 (http://www.algonquincollege.com/directives/sectionE/E43.pdf).

(8)

Course Assessments

It is Algonquin College's policy to give students the opportunity to complete a course assessment survey in each course that they take which solicits their views regarding the curriculum, the professor and the facilities. For further details consult Algonquin College Directive E38 (http://www.algonquincollege.com/directives/sectionE/E38.pdf).

Use of Electronic Devices

With the proliferation of small, personal electronic devices used for communications and data storage, Algonquin College believes there is a need to address their use during classes and examinations. During classes, the use of such devices is disruptive and disrespectful to others. During examinations, the use of such devices may facilitate cheating. For further details consult Algonquin College Directive E39 (http://www.algonquincollege.com/directives/sectionE/E39.pdf).