CMGT/445: CASE STUDY: APPLIANCE WAREHOUSE – Application Implementation
BlackWolf
TemplateLibrary.zipTemplate Library/form_01_request-for-information-services.rtf
REQUEST FOR INFORMATION SERVICES
Date:
System enhancement:
Title:
Department:
Location:
New system:
E-mail:
REQUEST FOR:
URGENCY:
[ ] Correction of system error
[ ] Immediate attention required
[ ] System enhancement
[ ] Handle in normal priority sequence
[ ] New system
[ ] Defer until new system is developed
DESCRIPTION OF REQUESTED SYSTEMS SERVICES:
(ATTACH ADDITIONAL DOCUMENTS AS NECESSARY)
(To be completed by the Information Technology Department)
[ ] Approved
Assigned to IT contact person:
User:
Urgency code (1 low to 5 high):
[ ] Modified (see attached notes)
[ ] Rejected (see attached notes)
Date:
Action:
Template Library/form_02_preliminary-investigation-report.rtf
Note: In MS Word 2010, Click Review – Restrict Editing – Stop Protection and remove all highlighted material after completing the form
PRELIMINARY INVESTIGATION REPORT
Subject:
Date:
INTRODUCTION
[Provide a brief description of the system, the name of the person or group who performed the investigation, and the name of the person or group who initiated the investigation.]
SYSTEMS REQUEST SUMMARY
[Explain the basis of the systems request, including an explanation of major problems or opportunities mentioned in the request.]
PRELIMINARY INVESTIGATION FINDINGS
[Describe the results of the investigation, including the scope of the proposed project and the conclusions that were reached. Mention all significant findings, including the results of interviews and other fact-finding, and provide an estimate of current costs.]
RECOMMENDATIONS
[Present a specific recommendation for further action.]
TIME AND COST ESTIMATES
[Include an estimate of time and expenses necessary for additional IT department work. This should be quite specific for the next phase and should include a timetable and cost estimate for the entire project.]
EXPECTED BENEFITS
[Explain all tangible benefits, with specific dollar estimates, using a range if appropriate. Also mention any intangible benefits.]
Template Library/form_03_system-requirements-document.rtf
SYSTEM REQUIREMENTS DOCUMENT
· Introduction
· Summary
· Findings
· Recommendations
· Time and Cost Estimates
· Expected Benefits
· Appendix
Template Library/form_04_system-design-specification.rtf
SYSTEM DESIGN SPECIFICATION
Management Summary
Template Library/form_05_systems-requirements-change-request.rtf
SYSTEM REQUIREMENTS CHANGE REQUEST
PRINT THE FOLLOWING INFORMATION:
NAME
DEPARTMENT
JOB TITLE
DESCRIPTION OF CHANGE:
REASON FOR CHANGE:
ATTACH ADDITIONAL INFORMATION AND DOCUMENTS AS NEEDED:
CHECK THIS BOX IF ATTACHMENTS ARE INCLUDED:
SIGNED _________________________________________________________ DATE __________________________
CONTROL NUMBER
DATE RECEIVED
TO BE COMPLETED BY THE PROJECT COORDINATOR:
IMPACT ANALYSIS:
Include an estimate of resources needed, with specific costs and timetables.
ACTION:
ACCEPT
DEFER UNTIL (DATE)
REJECT FOR THE FOLLOWING REASONS:
SIGNED ___________________________________________________________ DATE _____________________
Template Library/form_06_interview-documentation.rtf
INTERVIEW DOCUMENTATION
Name of System: Page
Date:
Prepared by:
Title:
Purpose:
Location:
Template Library/form_07_report-analysis.rtf
SYSTEM DOCUMENTATION
NAME OF SYSTEM
DATE
PAGE of
ANALYST
PURPOSE OF DOCUMENTATION
FIELD FIELD TYPE FIELD LENGTH
Template Library/form_08_data-element-description.rtf
DATA DICTIONARY
DATA ELEMENT DESCRIPTION
SYSTEM
DATA ELEMENT NAME LABEL
ALTERNATE NAMES
TYPE AND LENGTH OUTPUT FORMAT
DEFAULT VALUE ACCEPTABLE VALUES
PROMPT/COLUMN HEADER
SOURCE
SECURITY
RESPONSIBLE USER
DERIVATION FORMULA
DESCRIPTION AND COMMENTS
Template Library/form_09_data-flow-description.rtf
DATA DICTIONARY
DATA FLOW DESCRIPTION
ID NAME
ALIAS
DESCRIPTION
ORIGIN DESTINATION
RECORD
VOLUME AND FREQUENCY
COMMENTS
Template Library/form_10_process-description.rtf
DATA DICTIONARY
PROCESS DESCRIPTION
SYSTEM
PROCESS NAME
PROCESS ID
INPUT DATA FLOWS
OUTPUT DATA FLOWS
PROCESS DESCRIPTION
Template Library/form_11_record-description.rtf
DATA DICTIONARY
RECORD DESCRIPTION
SYSTEM
RECORD ID
RECORD NAME
ALTERNATE NAMES
DEFINITION
RECORD DATA ELEMENTS
Template Library/form_12_data-store-description.rtf
DATA DICTIONARY
DATA STORE DESCRIPTION
LABEL
ENTRY TYPE
DESCRIPTION
ALIAS
COMPOSITION (ATTRIBUTES)
NOTES
LONG NAME
Template Library/form_13_external-entity-description.rtf
DATA DICTIONARY
EXTERNAL ENTITY DESCRIPTION
LABEL
ENTRY TYPE
DESCRIPTION
ALIAS
VALUES & MEANINGS
NOTES
LONG NAME
Template Library/form_14_program-documentation.rtf
SYSTEM DOCUMENTATION
NAME OF SYSTEM
DATE
PAGE of
ANALYST
PURPOSE OF DOCUMENTATION
PROGRAM IDENTIFICATION
PURPOSE
FILES – DATABASES – CLOUD REQUIREMENTS
WEB PROCESSING REQUIREMENTS AND RESOURCES
Template Library/form_15_npv_template.xls
NPV Template
| Net Present Value (NPV) Template | ||||||||
| Note: | ||||||||
| Cells B12:H12 and B16:H16 contain formulas to multiply discount factors * benefit and cost values | ||||||||
| Cells I12 and I16 contain adjusted cost and benefit totals | ||||||||
| Cell C18 contains the calculation for net present value (NPV) | ||||||||
| Year | Year | Year | Year | Year | Year | Year | Total | |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Benefits | ||||||||
| Factor | ||||||||
| PV of Benefits | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Costs | ||||||||
| Factor | ||||||||
| PV of Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Net Present Value: | - 0 |
Sheet2
Sheet3
Template Library/form_16_system-security-checklist.rtf
SYSTEM SECURITY CHECKLIST
· Overview of System S ecurity I ssues and C oncerns
· Analysis of Physical Security
· Analysis of Network Security
· Analysis of Application Security
· Analysis of File Security
· Analysis of User Security
· Analysis of Cloud vulnerability, if any
· Additional Comments and Recommendations
Template Library/form_17_payback-analysis-template.xls
Payback Analysis Template
| Payback Analysis Template | ||||
| Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits | ||||
| Year | Costs | Cumulative | Benefits | Cumulative |
| Costs | Benefits | |||
| 0 | - 0 | - 0 | ||
| 1 | - 0 | - 0 | ||
| 2 | - 0 | - 0 | ||
| 3 | - 0 | - 0 | ||
| 4 | - 0 | - 0 | ||
| 5 | - 0 | - 0 | ||
| 6 | - 0 | - 0 |
Sheet2
Sheet3
Template Library/form_18_roi-template.xls
ROI Template
| Return on Investment (ROI) Template | ||||
| Note: Cells C8:C14 and E8:E14 contain formulas to accumulate costs and benefits | ||||
| Cell C17 contains formula to calculate ROI | ||||
| Year | Costs | Cumulative | Benefits | Cumulative |
| Costs | Benefits | |||
| 0 | - 0 | - 0 | ||
| 1 | - 0 | - 0 | ||
| 2 | - 0 | - 0 | ||
| 3 | - 0 | - 0 | ||
| 4 | - 0 | - 0 | ||
| 5 | - 0 | - 0 | ||
| 6 | - 0 | - 0 | ||
| - 0 | - 0 | |||
| ROI: | 0.0% |
Sheet2
Sheet3
Template Library/form_19_npv-template.xls
NPV Template
| Net Present Value (NPV) Template | ||||||||
| Note: | ||||||||
| Cells B12:H12 and B16:H16 contain formulas to multiply discount factors * benefit and cost values | ||||||||
| Cells I12 and I16 contain adjusted cost and benefit totals | ||||||||
| Cell C18 contains the calculation for net present value (NPV) | ||||||||
| Year | Year | Year | Year | Year | Year | Year | Total | |
| 0 | 1 | 2 | 3 | 4 | 5 | 6 | ||
| Benefits | ||||||||
| Factor | ||||||||
| PV of Benefits | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Costs | ||||||||
| Factor | ||||||||
| PV of Costs | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 | - 0 |
| Net Present Value: | - 0 |
