IS'97.8
Physical Design and Implementation with DBMS
CATALOG Students completing the analysis and logical design
course will continue in this course the detailed physical design
and implementation of a departmental database requiring
implementation. (Prerequisite: IS'97.7)
SCOPE The course covers information systems design and
implementation within a database management system environment.
Students demonstrate their mastery of the design process acquired
in earlier courses by designing and constructing a physical
system to implement the logical design.
TOPICS Data models and modeling techniques; structured and
object design approaches; differing models for databases:
relational, hierarchical, network and object oriented; CASE
tools; dictionaries, repositories, warehouses; implementation:
coding, testing, installation and post implementation review.
EXPLANATION AND EXPECTATIONS
Students who have completed the information analysis and
logical design course will engage in the physical design and
implementation process for a departmental level information
system, as part of the coordinated four course project sequence
begun in IS'97.7.
CASE tools or manual methods will be used within a team
oriented project environment to design and implement a database
requiring a departmental information system.
A data model of a physical flow will be completed and the detailed database design will be used to construct a database.
A corresponding functional analysis of the problem will be
completed. Program specifications will be developed and utilized
in construction of the physical system. Testing, integration, and
integration testing of the final system will be accomplished.
Tools will be used to measure complexity of solutions; quality
assurance measures implemented as project standards will be used
to control project quality and risk.
Code generators or libraries will be used to facilitate rapid
development of the desired system. Existing project management
software will be used to manage user expectation and completed
work.
Students completing this course will have mastered the
following learning units:
| Learning Unit Number |
Learning Unit Goal |
Learning Unit Objectives |
Competency Level and Body of
Knowledge Elements in Learning Units |
| 86 | to discuss the importance of finding synergistic solutions with team and clients | describe and explain interdependence
habits of empathetic listening, synergy and consensus
building (LO-0050) explain negotiation and interdependent activities (LO-0173) |
4 2.3.5 Group decision process 3 2.4.3 Group dynamics 4 2.4.4 Teamwork, leadership and empowerment 3 2.4.5 Use of influence, power and politics 3 2.4.6 Cognitive styles 2 2.4.7 Negotiating and negotiating styles 3 2.4.8 Consensus building 3 2.10.1 Communication skills 3 2.10.6 Proactive attitude and approach 3 2.10.9 Principles of negotiation 3 2.10.10 Fostering creativity and opportunity finding |
| 87 | to show how to develop agreements describing work to be done, and to commit, rigorously complete and self- evaluate agreed work | perform work estimates, commit to the work, and rigorously complete, self-evaluate against standards, and account for the work (LO-0105) | 3 2.2.3 Staffing and human resource
management 3 2.10.6 Proactive attitude and approach 3 2.10.7 Personal goal setting, decision making, and time management 3 2.10.8 Principle centered leadership 3 3.7.7 Management concerns; stress and time management |
| 88 | to develop skill with data modeling of databases | use DBMS, data modeling, and data
manipulation languages (LO-0124) use knowledge data models to differentiate model types; explain the different models for databases, e.g. relational, hierarchical, network and OO database; and explain how they are implemented in database management systems (LO-0130) |
3 1.6.2 Data models: relational,
hierarchical, network, object, semantic object 3 1.6.5 Data definition languages 2 1.7.1 Knowledge representation 2 1.7.2 Knowledge engineering 2 1.7.3 Inference processing 3 3.3.2 Data modeling: e.g., entity-relationship diagrams, normalization 3 3.4.3 Software implementation concepts and tools: e.g., data dictionary, repository... |
| 89 | to develop awareness of the syntactical and theoretical differences between database models | identify the components of hierarchical, network, and relational database models; discuss the data definitions required for each model; explain the reasons for specific commands within the data manipulation facilities; discuss logical interconversion between the models (LO-0201) | 3 1.6.2 Data models: relational,
hierarchical, network, object, semantic object 3 1.6.5 Data definition languages 2 3.8.2 Relating the application to the enterprise model |
| 90 | to develop skill in application of database systems development and retrieval facilities needed to facilitate creation of information system applications | apply life cycle implementation
(LO-0122) explain database administration and maintenance (LO-0138) |
2 2.8.3 Privacy law 3 2.10.10 Creative problem solving and opportunity identification 3 3.2.1 Systems development models: e.g., SDLC, prototyping 3 3.2.5 Selecting a systems development approach 3 3.4.1 CASE |
| 91 | to develop skills with application and structuring of database management systems | develop editors to facilitate data entry
into the database (LO-0133) demonstrate design and implementation skills with both
a graphical user interface and character based interface
to implement list boxes, dialog boxes, buttons and menu
structures design and implement simple reports to validate the
performance of application systems (LO-0134) apply software development principles, methods and tools to implementation of an IS application (LO-0140) |
3 1.2.1 Formal problems and problem
solving 3 1.2.4 Abstract data types 3 1.6.1 DBMS: features, functions, architecture 3 1.6.1.1 DBMS (features, functions, architecture); components of database system... 3 1.6.1.3 Logical design (DBMS independent design): ER, object oriented 3 1.6.2 Data models: relational, hierarchical, network, object, semantic object 3 1.6.5 Data definition languages 3 1.6.6.3 Application and user interfaces (DML, query, QBE, SQL) 4 1.6.7 Intelligent query processors and query organization 2 1.6.9 DBMS products: recent developments in database systems (.e.g., hypertext... 2 1.6.11 Data and database administration 3 1.6.12 Data dictionary, encyclopedia, repository 3 2.2.3.4 Education and training 3 2.2.15.7 Quality management: e.g., reliability and quality engineering; QC teams 3 2.3.1 Measurement and modeling 3 3.2.2 Package acquisition and implementation 3 3.2.3 Integrating software components 4 3.2.5 Selecting a systems development approach 3 3.5.1 Infrastructure planning: hardware, communications, database, site 3 3.9.7 Software development 4 3.10.1 Systems construction 3 3.10.2 Software systems construction: e.g., programming, unit testing, load module |
| 92 | to develop skill with application and physical implementation of database systems, using a programming environment | apply database design techniques to
implement a solution with calls from a program to the
DBMS (LO-0139) explain and apply networking
considerations in implementing distributed models develop client server applications and install and operate them in a multi-user environment. |
4 1.2.1 Formal problems and problem
solving 4 1.2.4 Abstract data types 4 1.6.1 DBMS: features, functions, architecture 3 1.6.1.2 DBMS: overview of relational algebra 4 1.6.1.3 Logical design (DBMS independent design): ER, object oriented 3 1.6.2 Data models: relational, hierarchical, network, object, semantic object 3 1.6.2.1 Relational data model terminology; mapping conceptual schema to a... 4 1.6.2.2 Conceptual modeling (e.g., entity-relationship, object-oriented) 3 1.6.3 Normalization 4 1.6.4 Integrity (referential, data item, intra-relation): representing relationships... 4 1.6.5 Data definition languages 4 1.6.6 Application interface 3 2.3.1 Measurement and modeling 4 2.10.6 Proactive attitude and approach 3 3.8.2 Relating the application to the enterprise model |
| 93 | to develop skills with use of a combination of code generators and language facilities to implement multi-user departmental or simple enterprise level systems | use code generators to implement an IS application and compare the results with hand-coded versions of the same application (LO-0196) | 3 1.3.7.30 Code generators |
| 94 | to provide an opportunity to develop and use project management, project standards, and a system implementation plan, and to implement a documentation plan | create and present technical and end
user telecommunication system documentation (LO-0074) identify
security and privacy considerations and how they may be
solved within the context of the telecommunications
system (LO-0075) explain configuration controls (LO-0135) develop consistent with good practice a departmental
level DBMS project, and develop systems development and
user documentation (LO-0136) work in teams tracking individual and team results;
develop assignments and performance rating measures to
evaluate and ensure quality assurance in the development
process (LO-0137) develop program level, system and user documentation
(LO-0147) apply development concepts to a project of reasonable complexity in a team environment (LO-0148) |
3 1.2.4 Abstract data types 2 1.4.8 Protection and security 3 1.5.4 Local area networks 3 1.5.5 Wide area networks: switching techniques, broadcast techniques, routing 3 1.5.8 Network configuration, performance analysis and monitoring 3 1.6.1 DBMS: features, functions, architecture 3 1.6.2 Data models: relational, hierarchical, network, object, semantic object 3 1.6.4 Integrity (referential, data item, intra-relation); representing relationships... 3 1.6.5 Data definition languages 3 1.6.9 DBMS products: recent developments in database systems (e.g., hypertext... 3 1.6.11 Data and database administration 2 2.1.4 Role of IS within the enterprise: strategic, tactical and operations 3 2.2.1.1 Alignment of IS planning with enterprise planning 3 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 3 2.2.8 IS as a service function: performance evaluation -- external/internal, market... 3 2.2.10 Strategic use of IS: e.g., competitive advantage and IS, process re-engineer... 3 2.2.11 End user computing support, role and functions 2 2.2.13 Backup, disaster planning and recovery 2 2.2.15.3 Management of group decision support systems 2 2.2.15.4 Data administration 2 2.2.15.5 Ownership of data and application systems 3 2.2.15.6 Optimizing the climate for creativity 3 2.2.15.7 Quality management: e.g. reliability and quality engineering; QC teams 3 2.2.16 Security and control, viruses and systems integrity 3 2.3.1 Measurement and modeling 2 2.3.3 Cost/Value of information, competitive value of IS 3 2.3.5 Group decision process 2 2.4.1 Job design theory 3 2.4.3 Group dynamics 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.5 Use of influence, power and politics 3 2.4.7 Negotiating and negotiating styles 3 2.4.8 Consensus building 2 2.10.3 Presentation skills 2 2.10.4 Consulting skills 3 3.1.4 System components and relationships 2 3.7.1 Project planing and selection of appropriate process model; project scheduling... 2 3.7.2 Project organization management, principles, concept and issues 2 3.7.4 Project staffing considerations: e.g., matrix management, human factors, team... 2 3.7.5 Project control: planning, cost estimation, resource allocation, software tech... 3 3.7.8 Systems documentation 3 3.7.11 Scoping and scope control 2 3.7.12 Configuration management 2 3.7.14 Project tracking: e.g., PERT, Gantt 3 3.8.3 Requirements determination and specification 3 3.9.4 Techniques to enhance the creative design process 3 3.10.1 Systems construction 2 3.10.5 Systems integration and system testing: verification and validation, test plan... 3 3.12.1 Transaction processing systems |
| 95 | to show how to design a conceptual relational database model and logical database model, convert the logical database designs to physical designs, develop the physical database, and generate test data | explain a framework for evaluating an
information system function and value of individual
applications (LO-0055) explain the use of critical success factors (LO-0056) translate a logical system design into a physical design in a target environment, and, implement this specification into an operational system using DBMS technology (LO-0119) |
3 1.6.4 Integrity (referential, data
item, intra-relation): representing relationships... 3 1.6.5 Data definition languages 2 2.1.1 Hierarchical and flow models of organizations 2 2.1.5 Effect of IS on organizational structure; IS and continuous improvement 2 2.1.6 Organizational structure: centralized, decentralized, matrix 2 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 4 2.10.10 Creative problem solving and opportunity identification 3 3.9.1 Design: logical, physical |
| 96 | to provide opportunity to develop functional specifications for an information system, develop a detailed information system design, and develop information system application controls | use a methodology to specify and develop an information system of departmental level significance; ensure that data collection, verification, and control is accomplished; ensure that external audits will establish consistent goals and accomplishments (LO-0191) | 3 2.4.5 Use of influence, power and
politics 3 2.7.1 Reasons for resistance to change 3 2.7.2 Strategies for motivating change 3 2.7.3 Planning for change 3 2.7.4 Managing change 3 3.3.1 Organizational and software process modeling 2 3.3.3 Data oriented methodologies 3 3.3.4 Process oriented methodologies 3 3.3.5 Behavior oriented (event modeling) methodologies 3 3.7.13 System development quality assurance 4 3.9.5 Information presentation alternatives; cognitive styles |
| 97 | to show how to develop a conversion and installation plan, develop a hardware systems and environmental plan | develop a detailed training, conversion
and installation plan for hardware and software involving
a newly developed information system application
(LO-0194) design networked solutions and install the DBMS on the server along with appropriate OS and telecommunications hardware and software |
4 2.4.6 Cognitive styles 3 2.7.1 Reasons for resistance to change 3 2.7.2 Strategies for motivating change 3 2.7.3 Planning for change 3 2.7.4 Managing change 3 3.9.7 Software development 3 3.10.4 Systems conversion: approaches, planing, implementation 3 3.10.6 Training: e.g., user, management, operation, systems, training materials |
| 98 | to show how to develop detailed program specifications, develop programs, set up system test parameters, install and test the new system, implement the conversion plan, employ configuration management | develop, test, install and operate a
significant information system application program
(LO-0193) develop, test, install and operate both client and
server applications; ensure that all multi-user aspects
of the application function as planned develop, test, install, and operate coupled application systems that have no pathological coupling mechanisms; describe and explain how other mechanisms might involve inappropriate coupling mechanisms, and illustrate consequences of such design errors; discuss and explain both off-line batch as well as on-line coupling mechanisms |
3 1.2.1 Formal problems and problem
solving 3 1.2.1.4 Software design process; from specification to implementation 3 1.2.1.5 Problem recognition statement and algorithmic determination; procedural... 3 1.2.1.6 Implementation strategies (top-down, bottom-up; teams vs individual... 3 1.2.4 Abstract data types 3 1.2.4.1 Purpose and implementation of abstract data types 3 1.2.4.3 Formal specifications, preconditions and post-conditions, algebraic... 3 1.2.4.4 Modules, cohesion, coupling; data flow diagrams, and conversion to... 3 1.2.4.5 Correctness, verification and validation: pre- and post-conditions, invariants... 3 1.2.4.6 Control structures; selection, iteration, recursion; data types and their uses in... 3 1.2.5.1 Files (structure, access methods): file layouts; fundamental file concepts... 3 1.2.5.2 Files (structure, access methods): directories, contents and structure, naming... 3 1.6.1.3 Logical design (DBMS independent design): ER, object oriented 3 1.6.2 Data models: relational, hierarchical, network, object, semantic object 3 1.6.3 Normalization 3 1.6.4 Integrity (referential, data item, intra-relation): representing relationships... 3 1.6.5 Data definition languages 2 1.6.11 Data and database administration 2 1.6.12 Data dictionary, encyclopedia, repository 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.8 Consensus building 2 3.4.2 Group-based methods: e.g., JAD, structured walkthroughs, design and code... 3 3.10.3 Software integration: e.g., packages 3 3.10.4 Systems conversion: approaches, planing, implementation 3 3.10.5 Systems integration and system testing: verification and validation, test plan... 3 3.10.7 Software project management: scoping, scheduling, configuration manage... 3 3.10.8 Systems installation 2 3.10.9 Post implementation review 2 3.11.1 Service request and change control 2 3.11.3 Tuning and balancing 4 3.11.4 Systems and software maintenance concepts |
| 99 | to show how to develop a physical work-flow plan with a client | participate non-confrontationally in a
team environment, and demonstrate empathetic listening
skills to facilitate determination of alternate
mechanisms for a horizontally integrated work group in
improving its function through process redesign,
including incorporation of information systems to ensure
documentation and quality (LO-0216) design a workflow using graphical tools or image
systems development software in the presence of a client convert the workflow to both an IDEF 0 and IDEF 3 type drawing; convert the IDEF3 drawing into an event driven model satisfactory for a graphical user interface |
3 2.3.5 Group decision process 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.7 Negotiating and negotiating styles 3 2.4.8 Consensus building 3 2.10.2 Interviewing, questioning and listening |
| 117 | to show how to present a system design, test plan, implementation plan, and evaluation, in written and oral form | present and explain solutions to a peer
group for critique and improvement (LO-0028) apply oral and written communication skills to present proposed solutions and accomplishments (LO-0125) |
3 2.10.1 Communication skills 3 2.10.2 Interviewing, questioning and listening 3 2.10.3 Presentation skills 4 2.10.5 Writing skills 3 3.7.9 User documentation (e.g., reference manuals, operating procedures, on-line... |
| 127 | to discuss performance evaluation consistent with quality management and continuous improvement | develop performance measures consistent with the concepts of valuing employees that facilitate team cooperation and discourage competitiveness among team members; discuss the reasons for such measures and explain the negative consequences of misunderstanding these issues (LO-0184) | 3 2.2.3 Staffing and human resource
management 3 3.7.4 Project staffing considerations: e.g., matrix management, human factors, team... |
IS'97.9
Physical Design and Implementation with Programming
Environments
CATALOG Students who have completed the analysis and logical
design course will extend their knowledge by implementing an
information system using a programming language capable of
calling functions in a DBMS. Teams will use project management to
implement an information system. (Prerequisite: IS'97.7)
SCOPE This course is designed to follow IS'97.7, Analysis and
Logical Design, which addresses the early part of the system life
cycle. This course addresses the latter part of the life cycle
and is concerned with physical design, programming, testing and
implementation of the system.
TOPICS Selection of programming language environment which
uses a database; software construction: structured, event driven
and object oriented application design; testing; software quality
assurance; system implementation; user training; system delivery;
post implementation review; configuration management;
maintenance; reverse engineering and re-engineering.
EXPLANATION AND EXPECTATIONS
Students who have completed the information analysis and
logical design course will continue participating in the
coordinated four course project sequence begun in IS'97.7 by
learning to develop information systems which are implemented
using a third or fourth generation programming language capable
of calling DBMS functions.
If object-oriented programming has not been taught to the
students earlier in the curriculum, then it should be used here.
If only object-oriented methods have been used, some procedural
facility should be employed.
System representation (data flow) or object representation,
modular design, use of control structures with proof of
correctness, verification, testing and validation should be
integral components of software quality assurance. Implementation
standards should be developed by the students and used rigorously
as project teams complete a significant system. A conversion and
training plan should be developed and implemented involving both
hardware, data, people, and software systems.
Project management tools should be used to ensure timely
completion of the project. Interdependence skills should be
practiced and evaluated. Presentation of all life cycle events
should be accomplished.
Students completing this course will have mastered the
following learning units:
| Learning Unit Number |
Learning Unit Goal |
Learning Unit Objectives |
Competency Level and Body of
Knowledge Elements in Learning Units |
| 100 | to develop skill in analysis, design, and development of application software using a programming environment | design and implement information systems
application software using a programming environment
which utilizes database programming (Designs should
include screen editors, data update mechanisms, audit and
operations controls, and should contain appropriate
printed reports.) (LO-0208) use productivity tools to develop conceptual data and functional models |
4 1.2.1 Formal problems and problem
solving 4 1.2.4 Abstract data types 4 1.6.2 Data models: relational, hierarchical, network, object, semantic object 4 1.6.5 Data definition languages 4 1.6.6 Application interface 4 1.6.6.2 DML, query, QBE, SQL, etc.: database query language; data definition... 4 1.6.6.3 Application and user interfaces (DML, query, QBE, SQL) 4 2.3.1 Measurement and modeling 3 2.10.10 Fostering creativity and opportunity finding 3 3.1.2 Systems concepts: e.g., structure, boundaries, states, objectives 4 3.3.2 Data modeling: e.g., entity-relationship diagrams, normalization 3 3.4.3 Software implementation concepts and tools: e.g., data dictionary, repository... 3 3.8.2 Relating the application to the enterprise model 4 3.9.7 Software development |
| 101 | to identify differences between a structured, event-driven, and object-oriented application design and explain the implications of these approaches to the design and development process | employ a programming environment to develop a simple event-driven application with a GUI interface (LO-0025) | 2 1.3.6 Object oriented extensions to
languages 2 1.4.10 OS support for human interaction: e.g., GUI, interactive video 3 3.3.5 Behavior oriented (event modeling) methodologies 3 3.3.6 Object oriented methodologies 4 3.9.6 Human-computer interaction (e.g., ergonomics, graphical-user interfaces, voice... |
| 103 | to be able to develop program tests and system tests | construct effective queries using both
structured and unstructured query tools (LO-0132) reverse engineer data flows from fourth GL applications to ensure verification (LO-0142) |
3 1.2.1 Formal problems and problem
solving 3 1.2.4 Abstract data types 3 1.2.4.4 Modules, cohesion, coupling; data flow diagrams, and conversion to... 3 1.2.4.5 Correctness, verification and validation: pre- and post-conditions, invariants... 3 1.3.4 Non-procedural languages: logic, functional 3 1.6.6.3 Application and user interfaces (DML, query, QBE, SQL) 3 1.6.7 Intelligent query processors and query organization 3 3.8.3 Requirements determination and specification 3 3.9.7 Software development 3 3.10.2 Software systems construction: e.g., programming, unit testing, load module... 3 3.11.2 Reverse and re-engineering |
| 104 | to understand the different programming environments available for business application development | explain the characteristics, requirements and use of several programming environments including graphical and conventional environments; explain the concepts of software portability and the concepts of interoperability (LO-0207) | 2 1.3.1 Fundamental programming language
structures; comparison of languages and... 4 1.3.5 Fourth-generation languages 4 1.3.6 Object oriented extensions to languages 3 1.3.7 Programming languages, design, implementation and comparison |
| 112 | to develop a functional understanding of proactive principled behavior and time management | describe and explain character habits of proactive leadership and time management (LO-0042) | 4 2.3.5 Group decision process 2 2.10.6 Proactive attitude and approach 2 2.10.8 Principle centered leadership 2 3.7.7 Management concerns; stress and time management |
| 113 | to ensure attitudes necessary to successful team behavior including empathetic listening, consensus negotiation, conflict resolution, and synergistic solution finding, and to apply the concept of commitment and rigorous completion | use and apply team work, empowerment
methods, apply meetings concepts and methods, use group
techniques, use empathetic listening skills, employ
synergistic solution development (LO-0121) ensure that empathetic listening is practiced; ensure that individuals listen, commit and rigorously complete assignments; explain the relevance of such action in ensuring team effectiveness (LO-0156) |
3 2.3.5 Group decision process 4 2.4.3 Group dynamics 3 2.4.4 Teamwork, leadership and empowerment 4 2.4.8 Consensus building 4 2.10.2 Interviewing, questioning and listening |
| 114 | to ensure goal setting and alignment of team activities with project obligations | discuss and explain the concepts of
shared vision and mission directed activity in
information system development (LO-0017) discuss and apply mission directed work by aligning team mission to project mission by tracking to ensure the results (LO-0155) |
3 2.2.1 IS planning 4 2.3.5 Group decision process 4 2.10.2 Interviewing, questioning and listening 4 2.10.8 Principle centered leadership 4 3.9.4 Techniques to enhance the creative design process 4 3.10.7 Software project management: scoping, scheduling, configuration manage... |
| 115 | to describe interactions with higher levels of management in selling project objectives and performing project management tasks | explain and prove the relationship of IS
activities to enhancing competitive position (LO-0160) explain functions of IS management, CIO, project manager ... (LO-0164) |
2 2.2.7 CIO and staff functions 3 2.2.10 Strategic use of IS: e.g., competitive advantage and IS, process re-engineer... 3 2.2.15 Management of sub-functions 3 2.3.2 Decisions under certainty, uncertainty, risk 3 2.3.3 Cost/Value of information, competitive value of IS 2 3.5.2 Planning the IS architecture 2 3.5.3 Planning for operations 3 3.6.1 Feasibility assessment 2 3.6.3 Contingency planning 3 3.10.9 Post implementation review |
| 116 | to describe and explain life cycle concepts, and apply them to the course project | explain and apply various life cycle
concepts in engaging in and completing a project of a
considerable size and scope, involving teams; tell how to
ensure accepting and incorporating standards compatible
with successful life cycles (LO-0185) explain the
different responsibilities of IS, CS and SE as they
pertain to software and systems development activities;
apply lessons learned to the course project (LO-0236) explain how formal software engineering techniques can contribute to the success of software and system development efforts; apply these techniques to the course project (quality assurance, verification and validation, correctness and reliability, testing, etc.) (LO-0237) |
2 2.1.5 Effect of IS on organizational
structure; IS and continuous improvement 3 2.2.2 Control of the IS function: e.g., EDP auditing, outsourcing 3 2.2.3 Staffing and human resource management 2 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 2 2.2.8 IS as a service function: performance evaluation -- external/internal, market... 2 2.2.9 Financial administration of IS: e.g., funding and chargeout 2 2.2.12 IS policy and operating procedures formulation and communication 3 2.2.13 Backup, disaster planning and recovery 3 2.3.1 Measurement and modeling 4 2.4.4 Teamwork, leadership and empowerment 4 2.4.8 Consensus building 4 3.1.3 Properties of open systems 4 3.1.4 System components and relationships 3 3.1.5 Systems control: standards, control theory, feedback, loops, measurement... 4 3.2.1 Systems development models: e.g., SDLC, prototyping 2 3.2.1.1 Systems development life cycle: software life-cycle models (iterative... 3 3.2.2 Package acquisition and implementation 4 3.2.5 Selecting a systems development approach 3 3.3.7 Software engineering process and products 3 3.7.1 Project planning and selection of appropriate process model; project scheduling... 3 3.7.2 Project organization management, principles, concept and issues 3 3.7.6 Managing multiple projects 3 3.7.7 Management concerns; stress and time management 3 3.7.12 Configuration management 3 3.8.1 Problem opportunity identification: e.g., service requests, from planing process 4 3.9.7 Software development 4 3.10.2 Software systems construction: e.g., programming, unit testing, load module... 4 3.10.3 Software integration: e.g., packages 4 3.10.4 Systems conversion: approaches, planing, implementation 4 3.10.5 Systems integration and system testing: verification and validation, test plan... 4 3.10.8 Systems installation 4 3.11.4 Systems and software maintenance concepts |
| 118 | to discuss and apply the concept of life-long learning | discuss and apply the concept of learning to learn continuously (LO-0158) | 4 2.2.3.4 Education and training |
| 120 | to present and explain the evolving leadership role of information management in organizations | describe and explain the composition of
personnel needed to make up the team for a given project
and use personnel management strategies (LO-0153) explain to a non-IS knowledge worker what they have to do to manage their information resources and requirements (LO-0178) |
2 2.2.3 Staffing and human resource
management 3 2.4.3 Group dynamics 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.5 Use of influence, power and politics 2 2.8.3 Privacy law 2 2.8.4 Agencies and regulatory bodies 3 2.10.3 Presentation skills 3 2.10.8 Principle centered leadership 3 3.4.1.2 Tools: CASE tools, code generators, CDSS 3 3.7.4 Project staffing considerations: e.g., matrix management, human factors, team... 3 3.7.9 User documentation (e.g., reference manuals, operating procedures, on-line... |
IS'97.10
Project Management and Practice
CATALOG Advanced IS majors operating as a high-performance team will engage in and complete the design and implementation of a significant information system. Project management, management of the IS function and systems integration will be components of the project experience. (Prerequisites: IS'97.8 and IS'97.9)
SCOPE This course covers the factors necessary for successful
management of system development or enhancement projects. Both
technical and behavioral aspects of project management are
discussed.
TOPICS Managing the system life cycle: requirements
determination, logical design, physical design, testing,
implementation; system and database integration issues; metrics
for project management and system performance evaluation;
managing expectations: superiors, users, team members and others
related to the project; determining skill requirements and
staffing the project; cost-effectiveness analysis; reporting and
presentation techniques; effective management of both behavioral
and technical aspects of the project.
EXPLANATION AND EXPECTATIONS
This is the capstone course for IS majors who have completed
the systems analysis and design sequences. It focuses on engaging
in and completing a major system development project, thereby
completing the coordinated four course project sequence begun in
IS'97.7.
Within the project context management of IS, systems
integration is an explicit requirement for students to address.
The project is a team effort and allows a final opportunity to
practice personal and interdependence skills to ensure team
member empowerment and success. Project management tools will be
employed by the team to ensure tracking of the project and
communication of project goals and accomplishments to the client.
CASE may or may not be used depending on resources. However,
project standards will be developed for all life cycle and other
actions. Software quality assurance methodologies will be
employed to ensure a successful outcome for the project.
On-going presentation of project planning, analysis, design,
conversion plan, and other documentation will be done by the
team. Each team member should play a significant role in some
aspect of presentation.
Students completing this course will have mastered the
following learning units:
| Learning Unit Number |
Learning Unit Goal |
Learning Unit Objectives |
Competency Level and Body of
Knowledge Elements in Learning Units |
| 105 | to ensure skills needed to design a project development and implementation plan | explain steering and other committee functions, and the rationale for horizontal teams in organizational development and re-engineering of IS (LO-0054) | 3 2.10.10 Creative problem solving and
opportunity finding 2 3.7.3 Work breakdown structures and scheduling |
| 106 | to further develop and practice essential project management skills | apply meeting design concepts to organizing and conducting effective team and client meetings which ensure shared vision, creativity and empowered actions (LO-0116) | 3 2.2.3.6 Ensuring positive climate for
creativity 3 2.3.5 Group decision process 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.8 Consensus building 3 3.4.2 Group-based methods: e.g., JAD, structured walkthroughs, design and code... |
| 107 | to develop skill in use of project management tools and methods within the context of an information systems project | use and apply project management tools, techniques and software in definition, implementation and modification of project goals; produce timely management, individual, team and customer information progress reports to ensure quality software development, physical workflow system implementation, computer systems installation (LO-0150) | 3 2.10.4 Consulting skills 4 2.10.7 Personal goal setting, decision making, and time management 4 3.7.1 Project planning and selection of appropriate process model; project... 4 3.7.5 Project control: planning, cost estimation, resource allocation, software tech... 4 3.7.14 Project tracking: e.g., PERT, Gantt |
| 108 | to select the proper project management tools and demonstrate their use | use project management concepts and
tracking tools (PERT, GANTT) (LO-0104) use project
management techniques e.g. tracking, PERT, GANTT
(LO-0120) use CASE and other tools (LO-0123) |
3 3.4.1 CASE 3 3.7.5 Project control: planning, cost estimation, resource allocation, software tech... 3 3.7.14 Project tracking: e.g., PERT, Gantt |
| 109 | to initiate, design, implement and discuss project close down | discuss and explain the concepts of terminating a project; explain and list the requirements for project close down (LO-0186) | 3 3.7.15 Project close-down |
| 110 | to determine and analyze a significant problem using the systems approach to problem solving | develop and use detailed specifications
to state and solve an information systems application
problem including physical flows, database design, system
functions, program requirements and design, as well as
database and software implementation (LO-0195) design and implement a systems integration plan for an
enterprise level system involving LAN and WAN techniques;
implement systems connections, install and configure
systems, and install, test and operate designed solutions
integrate end user solutions and approaches into the
enterprise model; develop and implement conversion and
training plans develop and evolve written standards for all life cycle project activities; present and defend solutions; conform time management and accountability to the developed standards |
4 1.2.1 Formal problems and problem
solving 4 1.2.4 Abstract data types 4 1.6.2 Data models: relational, hierarchical, network, object, semantic object 4 1.6.4 Integrity (referential, data item, intra-relation): representing relationships... 3 1.6.11 Data and database administration 4 3.2.3 Integrating software components 3 3.5.1 Infrastructure planning: hardware, communications, database, site 3 3.5.2 Planning the IS architecture 4 3.10.1 Systems construction |
| 111 | to develop requirements and specifications for a database requiring multi-user information system | identify physical flows and horizontal
integration of organizational processes, and relate these
flows to the relevant databases which describe the flows develop event driven functional models for the
involved organizational process identify and specify the processes which solve the organizational problem and define the related database application (LO-0189) |
2 1.6.1 DBMS: features, functions,
architecture 2 1.6.2 Data models: relational, hierarchical, network, object, semantic object 1 1.6.3 Normalization 2 1.6.5 Data definition languages 2 1.6.12 Data dictionary, encyclopedia, repository 3 3.3.2 Data modeling: e.g., entity-relationship diagrams, normalization 2 3.8.3 Requirements determination and specification |
| 121 | to present and explain the evolving leadership role of information management in organizations | explain setting an ethical standard
(LO-0171) explain the relevance and use of a professional code
of ethics explain and demonstrate successful application of
ethical argument in identifying and evaluating
alternatives based on social contextual analysis in
client centered information systems development
environment explain the alignment of IS with organizational
mission; explain the relationship of departmental
processes with the strategic success of the organization explain budget planning and administration (LO-0172) explain and illustrate the application of ethical models, e.g. principle centered leadership, in project management standards and practice |
3 2.2.1 IS Planning 3 2.2.5 Determining goals and objectives of the IS organization 2 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 2 2.2.8 IS as a service function: performance evaluation--external/internal, market... 2 2.2.9 Financial administration of IS: e.g., funding and chargeout 4 2.2.3.6 Ensuring positive climate for creativity 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.5 Use of influence, power and politics 3 2.4.6 Cognitive styles 3 2.4.7 Negotiating and negotiating styles 3 2.4.8 Consensus building 3 2.8.6 Ethics: plagiarism, honesty, codes of ethics 3 2.10.6 Proactive attitude and approach 3 2.10.7 Personal goal setting, decision making, and time management |
| 122 | to examine the process for development of information systems policies, procedures and standards in the organization | explain the relevance of IS management
aligning itself with business process (LO-0159) explain and develop standards and policies which are
involved in the development of information systems of
organizational scope (LO-0190) explain the benefits of cross-functional teams in
policy and procedure development explain the benefits of team mission statement development, and of aligning team missions with organizational missions |
3 2.2.1 IS planning 3 2.2.5 Determining goals and objectives of the IS organization 2 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 2 2.2.8 IS as a service function: performance evaluation -- external/internal, market... 2 2.2.9 Financial administration of IS: e.g., funding and chargeout 3 2.4.4 Teamwork, leadership and empowerment 3 2.4.5 Use of influence, power and politics 3 2.4.7 Negotiating and negotiating styles 3 2.4.8 Consensus building 3 2.8.6 Ethics: plagiarism, honesty, codes of ethics 3 2.10.6 Proactive attitude and approach 3 2.10.7 Personal goal setting, decision making, and time management 3 3.3.3 Data oriented methodologies 3 3.10.7 Software project management: scoping, scheduling, configuration manage... |
| 125 | to discuss outsourcing and alternate implementations of the IS function | explain outsourcing as an alternative to
an internal IS function (LO -0231) define, explain, and compare from a cost-benefit
perspective various outsourcing arrangements (LO-0232) manage the IS function in a small organization
(LO-0233) explain outsourcing (LO-0234) |
2 2.1.6 Organizational structure:
centralized, decentralized, matrix 2 2.2.2 Control of the IS function: e.g., EDP auditing, outsourcing 2 2.2.4 IS functional structures -- internal vs outsourcing 2 2.2.5 Determining goals and objectives of the IS organization 2 2.2.6 Managing IS as a business: e.g., customer definition, defining IS mission, IS... 2 2.2.8 IS as a service function: performance evaluation -- external/internal, market... 2 2.2.9 Financial administration of IS: e.g., funding and charge out 2 2.2.12 IS policy and operating procedures formulation and communication 2 2.2.15.8 Management consulting relationships, outsourcing 2 2.3.3 Cost/Value of information, competitive value of IS 1 2.8.7 Risks, losses and liability in computing applications 2 3.6.2 Risk management principles |
| 126 | to discuss management of time and interpersonal relations | explain four generations of time management concepts, and personal and interpersonal reasons for the success of each stage; use the mechanisms within a project environment (LO-0235) | 4 3.7.7 Management concerns; stress and time management |