SLDS+K-12+Contract+Amendment+2013-001.pdf

(The remainder of this page is intentionally left blank)

This Contract Amendment is not effective until fully executed by all parties.

All other terms of the Contract remain in effect.

1. Section 1, Scope of Services. The scope of services is hereby amended to add additional services as described in Addendum A attached with this Amendment.

Scope of Work

Whereas, the contract, Section 4 - Merger and Modification, allows for amending the contract upon a signed written agreement by both parties, therefore, the parties agree to amend the contract as follows:

The parties agree to the following terms and conditions and expressly agree that if any of the following terms and conditions conflict with any of the terms and conditions of the Contract, then, notwithstanding any term in the Contract, the follOwing terms and conditions govern and control the rights and obligations of the parties.

AMENDMENT to Contract between the State of North Dakota, acting through its Information Technology Department in cooperation with its Office of Management and Budget State Procurement Office (STATE), and Otis Educational Systems, Inc.

(CONTRACTOR);

AMENDMENT NUMBER: 2013-001

CONTRACT AMENDMENT

CONTRACT NUMBER AND TITLE: POWERSCHOOL ElL ANDDATAWARBOUSE

PRODUCTS&SERVICES CONTRACT

OtisEd Deliverable for the Data Warehouse:

., Finance reports - Deliverable 45 (corresponding to Activity D in the below table) o Model data, ETl, and develop cubes (December 2013) o Develop reports (March 2014)

North Dakota Deliverables for the Data Warehouse:

• Discipline reports - Deliverable 49 o Modify PowerSchool (October 2013) o Create domain (March 2014) o Create reports/further define requirements with discipline data committee andlor report working group (May 2014)

• Data dictionary- Deliverable 8 (June 2014)

• Transition plan - Deliverable 56 (May 2014)

Due dates are at the end of the month noted.

This scope of work applies to the K-12 SlDS project as a whole. North Dakota's expectation is that OtisEd will assist the North Dakota project team in completing this scope by providing staff in the capacity listed in the table at the end of this document. Additional staff members required, jf not covered under the roles noted, will be added via change order.

Extension Scope of Work:

The work during the Year 4 extension of the project will expand the work previously done. The approved scope for the extension is noted below, followed by the roles, activities, and hourly rates required to meet the scope.

Description:

Year 4 of the K-12 SlDS project schedule is from July 1, 2012 through June 30, 2014 - this time was extended twelve (12) months from the original date of June 28,2013 due to the Department of Education providing a no-cost extension to the grant funding.

Timeframe:

The purpose of this addendum is to increase the project length by twelve months, adjust the scope of work, increase hourly rates for three OtisEd contractors, and increase the Not to Exceed limit of the addendum to cover the addition of eTranscripts.

Addendum A - Scope of Work

AMENDMENT NUMBER: 2013-001

CONTRACT NUMBER AND TITLE: POWERSCHOOLETLANDDATAWARHOUSE

PRODUCTS & SERVICES CONTRACT

Page3of 5

Page4 of5

I!!!, Security application - Deliverable 50 (June 2013)

North Dakota Activities for the eTranscripts Phase 4 Functionality:

• Student/parent interface (December 2013)

• Improve school functionality for initial release (December 2013)

• Single sign-on ability (December 2013)

Ongoing Activities:

• SLDS and STARS data-sync (June 2014)

'. Portal expansion and maintenance (June 2014)

• Data loads/maintenance/expansions (June 2014)

• Vertical reporting work/operations' (june 2014)

• Modify iMart model in Cognos (June 2014)

'. Security application expansion and maintenance (June 2014)

• User training (June 2014)

• Optional enhancements to eTranscripts (June 2014) eTranscripts invoices to be sent separately to assure accurate billing to the eTranscripts project.

Activity Description Hourly Rate eTranscripts developer (James OtisEd to provide a resource to perform development on

$145Sheridan) the eTransc:ripts application eTranscripts Payment Activities:

* The Finance Reports are to be redeveloped at OtisEd's expense with a 450-free hour limit, once written and signed-off speclflcations are provided to OtisEd.

Page 5 of5

# Role/Activity Description Hourly Rate

ETl developer/report OtisEd to provide a full-time resource to work on Ell

A developer A (Steve Derzi) development, report writing, and associated data structure $145 and research

ETl developer/report OtisEd to provide a full-time resource to work on ElL

B developer B (Jimmy Lin) development, report writing, and associated data structure $135 and research

C Report developer OtisEd to provide a full-time resource to work on report $135writing

D Finance Reports OtisEd to provide work hours at no charge for work related

$0* to re-creating finance reports

OtisEd to provide a resource to perform the following work:

• Rework portal security Portal and security • Portal maintenance and expansion

E developer (James $145 Sheridan) • Evaluate the portal strategy and determine ongoing solution

OtisEd to provide a resource to perform design activities on F Portal designer the portal, along with advising on portal improvements and $135 strategy OtisEd to provide professional services with information and

G Assessment consultant research on assessments previously loaded by OtisEd, and

$135Information and changes to the Assessment Load Manager tool

H Product manager OtisEd to provide professional services, including modeling

$135 or consulting as needed

I Project manager OtisEd to provide professional services $135

J Business Analyst OtisEd to provide professional services $135

K Senior consulting services OtisEd to provide professional services from its senior $160(Eddie Parker) consultant l Travel North Dakota to cover state-approved OtisEd travel N/Aexpenses as related to the project

DataWarehouse Payment Activities:

Year 4 Data Warehouse Not to Exceed Limit is $1,451,450 without a change request.

Year 4 eTranscripts Not to Exceed Limit is $100,000 without a change request.

Year 4 Extension Roles and Hourly Rates