Attachment_B_-_Functional_Requirements_(1).xlsm

Instructions

STATEWIDE INFORMATION MANAGEMENT MANUAL

SECTION 19B.3 MID-LEVEL SOLUTION REQUIREMENTS TEMPLATE TOOL

INSTRUCTIONS:

Identify the Project Number and Agency/State Entity Name:

In the Instructions tab, enter the Project Number and Agency/State Entity Name. This information will automatically populate on each corresponding "Requirement Type" tab.

Enter requirements:

Enter mid-level solution requirements in the corresponding tab based on the "Requirement Type" (i.e., Functional Mandatory, Functional Desirable, Non-Functional Mandatory, Non-Functional Desirable, Project-Transition Mandatory, Project-Transition Desirable). For additional instructions , refer to the SIMM Section 19B.1 Preparation Instructions Section 2.6.

Note: Footer information may be modified based on Agency/state entity preference.

Create a combined worksheet that displays all requirements:

Click on the "Create Combined Worksheet" button to combine all the requirements from the separate "Requirement Type" tabs (i.e., Functional Mandatory, Functional Desirable, Non-Functional Mandatory, Non-Functional Desirable, Project-Transition Mandatory, Project-Transition Desirable) onto one worksheet. Do not re-select the "Create Combined Worksheet" button if a "Combined" tab already exists, as the automatic combine macro will not function correctly. To ensure proper functionality, first delete the existing "Combined" tab and then select the "Create Combined Worksheet" button to update the combined listing of requirements.

Format the "Combined" tab:

Click on the File Menu tab, select Print. In the Print Menu, use the appropriate drop down arrows to change the "Portrait Orientation" to "Landscape Orientation" and change the "No Scaling" to "Fit All Columns on One Page."

Set Print Area:

Prior to printing from a tab/worksheet, set the Print Area.

To do this, Select the entire area to be printed. Once selected, click the Page Layout Menu tab, then select Set Print Area.

Attach requirements:

Once completed and ready to submit, attach the completed requirements documentation as indicated in Section 2.6.

California Department of Technology SIMM Section 19 Mid-Level Solution Requirements B.3 Mid-Level Solution Requirements Template &P

August 2016

Create Combined Worksheet

Functional Mandatory

FUNCTIONAL MANDATORY

&P of &N &D

Functional Desirable

FUNCTIONAL DESIRABLE

&P of &N &D

Non-Functional Mandatory

1. At the end of the design phase and prior to coding

2. At the end of coding and prior to User Acceptance Testing

IIS Webserver logs should be enabled and have the following options configured:

Change log format to "W3C" Add all fields except "Cookie" Add 3 Custom Fields:

Field Name Source type Source X-Forwarded-For Request Header X-Forwarded-For Content-Type Request Header Content-Type

* Data security,

* Regulatory compliance,

* System access, and

* System vulnerability protection.