Sunshine Connections technical resources

**
**

Download these technical resources to plan and implement your Sunshine Connections project.

On This Page
General architectureGeneral architecture
Database managementDatabase management
User experienceUser experience
Identity management – Active Directory Internet Admin Tool (ADAT)Identity management – Active Directory Internet Admin Tool (ADAT)
Identity management – Active Directory Federation Services (ADFS)Identity management – Active Directory Federation Services (ADFS)
Identity management – Account MaintenanceIdentity management – Account Maintenance
Identity management – Flexible Authorization System (FAS R1)Identity management – Flexible Authorization System (FAS R1)

Portable Document FormatGet Adobe Acrobat Reader

XML Paper Specification fileView and generate XPS

General architecture

Title and descriptionDownloads

General Architecture Overview
The Sunshine Connections implementation for the Florida Department of Education combines several Microsoft technologies to provide a single portal with essential tools for teachers to improve the quality and efficiency related activities and processes.

Portable Document Format fileGeneralarcitecture.pdf (588 KB, Portable Document Format file)
XML Paper Specification fileGeneralarcitecture.xps (900 KB, XML Paper Specification)

Database management

Title and descriptionDownloads

Database management overview, data sources, and longitudinal data
The primary objective of the Sunshine Connections Data Warehouse is to bring together information from disparate sources and put the information into a format that is conducive to making strategic educational decisions for all Sunshine Connections stakeholders.

Portable Document Format filedatabasemanagement.pdf (192 KB, Portable Document Format file)
XML Paper Specification filedatabasemanagement.xps (287 KB, XML Paper Specification)

Data loading SSIS package

Portable Document Format filessispackage.pdf (1.1 MB, Portable Document Format file)
XML Paper Specification filessispackage.xps (1.6 MB, XML Paper Specification)

User experience

Title and descriptionDownloads

User experience through Microsoft Office SharePoint Server 2007 technologies
The user interface (UI) of Sunshine Connections is implemented using Microsoft Office SharePoint Server 2007. The first release of Sunshine Connections will contain core Florida Comprehensive Assessment Test (FCAT) analysis functionality for teachers to see longitudinal student performance data for each student.

Portable Document Format fileuserexperience.pdf (60 KB, Portable Document Format file)
XML Paper Specification fileuserexperience.xps (182 KB, XML Paper Specification)

SharePoint MOSS 2007 Portal Implementation

Portable Document Format filesharepoint.pdf (309 KB, Portable Document Format file)
XML Paper Specification filesharepoint.xps (320 KB, XML Paper Specification)

Florida Comprehensive Assessment Test (FCAT)
district and school math multi district comparison

Portable Document Format filemath.pdf (217 MB, Portable Document Format file)
XML Paper Specification filemath.xps (217 KB, XML Paper Specification)

FCAT district and school reading multi district comparison

Portable Document Format filereading_district.pdf (1.3 MB, Portable Document Format file)
XML Paper Specification filereading_district.xps (233 KB, XML Paper Specification)

FCAT district and school reading multi school comparison

Portable Document Format filereading_school.pdf (236 KB, Portable Document Format file)
XML Paper Specification filereading_school.xps (207 KB, XML Paper Specification)

FCAT superintendent – Staff master schedule

Portable Document Format filesuperintendent.pdf (193 KB, Portable Document Format file)
XML Paper Specification filesuperintendent.xps (192 KB, XML Paper Specification)

FCAT superintendent – Student master detail

Portable Document Format filesuperintendent_student.pdf (354 KB, Portable Document Format file)
XML Paper Specification filesuperintendent_student.xps (234 KB, XML Paper Specification)

FCAT superintendent – Teacher class roster

Portable Document Format filesuperintendent_teacher.pdf (101 KB, Portable Document Format file)
XML Paper Specification filesuperintendent_teacher.xps (211 KB, XML Paper Specification)

FCAT principal – Staff master schedule

Portable Document Format fileprincipal_staff.pdf (82 KB, Portable Document Format file)
XML Paper Specification fileprincipal_staff.xps (186 KB, XML Paper Specification)

FCAT principal – Student master detail

Portable Document Format fileprincipal_student.pdf (82 KB, Portable Document Format file)
XML Paper Specification fileprincipal_student.xps (186 KB, XML Paper Specification)

FCAT principal – Teacher class roster

Portable Document Format fileprincipal_teacher.pdf (101 KB, Portable Document Format file)
XML Paper Specification fileprincipal_teacher.xps (201 KB, XML Paper Specification)

FCAT student analysis – Achievement levels

Portable Document Format fileachievement.pdf (82 KB, Portable Document Format file)
XML Paper Specification fileachievement.xps (222 KB, XML Paper Specification)

FCAT student analysis – My Group list

Portable Document Format filegrouplist.pdf (82 KB, Portable Document Format file)
XML Paper Specification filegrouplist.xps (228 KB, XML Paper Specification)

FCAT student analysis – Student FCAT math

Portable Document Format filestudentmath.pdf (208 KB, Portable Document Format file)
XML Paper Specification filestudentmath.xps (120 KB, XML Paper Specification)

FCAT student analysis – Student FCAT read

Portable Document Formatfile studentread.pdf (207 KB, Portable Document Format file)
XML Paper Specification filestudentread.xps (119 KB, XML Paper Specification)

FCAT student analysis – Student FCAT

Portable Document Format filestudentanalysis.pdf (223 KB, Portable Document Format file)
XML Paper Specification filestudentanalysis.xps (155 KB, XML Paper Specification)

FCAT student analysis – Student math graph

Portable Document Format filestudentmath.pdf (81 KB, Portable Document Format file)
XML Paper Specification filestudentmath.xps (192 KB, XML Paper Specification)

FCAT student analysis – Student read graph

Portable Document Format filestudentread.pdf (81 KB, Portable Document Format file)
XML Paper Specification filestudentread.xps (191 KB, XML Paper Specification)

Identity management – Active Directory Internet Admin Tool (ADAT)

Title and descriptionDownloads

User interface
Learn about the screens, actions, database tables, Web services and stored procedures used in the implementation of the Active Directory Internet Admin Tool (ADAT) interface.

Portable Document Format fileuserinterface.pdf (753 KB, Portable Document Format file)
XML Paper Specification fileuserinterface.xps (766 KB, XML Paper Specification)

Use cases

Portable Document Format fileusecases.pdf (470 KB, Portable Document Format file)
XML Paper Specification fileusecases.xps (756 KB, XML Paper Specification)

Test plan

Portable Document Format filetestplan.pdf (554 KB, Portable Document Format file)
XML Paper Specification filetestplan.xps (701 KB, XML Paper Specification)

Web services

Portable Document Format filewebservices.pdf (949 KB, Portable Document Format file)
XML Paper Specification filewebservices.xps (243 KB, XML Paper Specification)

Password generator
Learn about the classes, subsystems, and configurations used in the implementation of the Password Generator. The business logic of the Password Generator is implemented as and works with components of the Sunshine Connections architecture system.

Portable Document Format filepasswordgenerator.pdf (429 KB, Portable Document Format file)
XML Paper Specification filepasswordgenerator.xps (929 KB, XML Paper Specification)

Identity management – Active Directory Federation Services (ADFS)

Title and descriptionDownloads

ADFS Overview
In developing the identity and access management strategy for Sunshine Connections, the FL-DOE understood that requiring individual school districts to maintain duplicate user credentials is not always desired. Leveraging the existing Active Directory infrastructure in each school district for user authentication alleviates users from having to remember another user ID and password.

Portable Document Format fileadfsoverview.pdf (50 KB, Portable Document Format file)
XML Paper Specification fileadfsoverview.xps (173 KB, XML Paper Specification)

District ADFS design
To facilitate identity management, the Active Directory Federation Service (ADFS) is being introduced into the Sunshine Connections forest to facilitate district-level user authentication and state-level resource authorization.

Portable Document Format filedesign.pdf (180 KB, Portable Document Format file)
XML Paper Specification filedesign.xps (643 KB, XML Paper Specification)

Identity management – Account Maintenance

Title and descriptionDownloads

Physical design
The password management application will be implemented using ASP.Net to make ADSI calls to make password changes in the Sunshine Connections Active Directory, and to store "secret questions" and a hash of the users' answers to those questions in a SQL Server database.

Portable Document Format filephysicaldesign.pdf (127 KB, Portable Document Format file)
XML Paper Specification filephysicaldesign.xps (522 KB, XML Paper Specification)

Application
The goal of this document is to describe the constructors, classes, methods and properties used in the implementation of the Account Maintenance application.

Portable Document Format fileapplication.pdf (137 MB, Portable Document Format file)
XML Paper Specification fileapplication.xps (473 KB, XML Paper Specification)

User interface
The goal of this document is to describe the user interaction with the Sunshine Connections Account Maintenance Tool.

Portable Document Format fileuserinterface.pdf (350 KB, Portable Document Format file)
XML Paper Specification fileuserinterface.xps (1.1 MB, XML Paper Specification)

Identity management – Flexible Authorization System (FAS R1)

Title and descriptionDownloads

FAS overview
The Flexible Authorization System (FAS) was created based on a need identified by Florida school districts to map district staff members to students and groups of students so those staff members could access student information.

Portable Document Format filefasoverview.pdf (71 KB, Portable Document Format file)
XML Paper Specification filefasoverview.xps (229 KB, XML Paper Specification)

User interface
This is the user interface design document for the Sunshine Connections FAS R1 Tool. The goal of this document is to describe the various screens and backend database interaction. The business logic of the FAS v1 interface is implemented as and works with components of the Sunshine Connections architecture system.

Portable Document Format filefasuserinterface.pdf (440 KB, Portable Document Format file)
XML Paper Specification filefasuserinterface.xps (985 KB, XML Paper Specification)

Application
Learn about the constructors, classes, methods and properties used in the implementation of the FAS v1 application.

Portable Document Format filefasapplication.pdf (1.4 MB, Portable Document Format file)
XML Paper Specification filefasapplication.xps (2.0 MB, XML Paper Specification)

Test plan

Portable Document Format filefastestplan.pdf (526 KB, Portable Document Format file)
XML Paper Specification filefastestplan.xps (680 KB, XML Paper Specification)

Use cases

Portable Document Format filefasusecases.pdf (575 KB, Portable Document Format file)
XML Paper Specification filefasusecases.xps (1.1 MB, XML Paper Specification)



Was this information useful?