Spreadsheet: 06bb5115-a216-4dd4-9795-eecc59845e97
Sheet: Districts

Student Data Systems Community
LEA Data Tools
LEA | SIS | WAREHOUSE PRODUCT | [NAME] OF USE | LEVEL OF USE | BUSINESS INTEL PRODUCT | [NAME] OF USE | LEVEL OF USE | REPORTING TOOL | [NAME] OF USE | LEVEL OF USE | OTHER TOOLS | [NAME] OF USE | LEVEL OF USE
Alpine | PowerSchool/moving to [NAME] |  |  |  | Cognos |  | Ext | Cognos |  | Ext
Beaver | SIS2000+ |  |  |  | DigitalSAMS |  | Min
[NAME] | SIS2000+ |  |  |  | Cognos |  | Ext | Crystal Reports, SQL queries |  | Ext | SPSS |  | Ext
Cache | PowerSchool |  |  |  | Cognos |  | Ext |  |  |  | SPSS |  | Ext
Canyons | Skyward
Carbon | SIS2000+ | MS Access |  |  | Cognos/STARS |  | Ext | Cognos |  | Ext
Dagget NUES | SIS2000+
[NAME] | Oracle/Encore | Custom |  |  | Oracle OBIEE/Oracle BI tool, Discoverer adhoc query tool |  | Ext |  |  |  | SPSS |  | Ext
Duchesne | PowerSchool |  |  |  | DigitalSAMS |  | Min
Emery | SIS2000+ |  |  |  | Cognos
[NAME] | SIS2000+ |  |  |  | DigitalSAMS |  | Min
Grand | SIS2000+ |  |  |  | Cognos
Granite | Discovery |  |  |  | Web Networks |  | Ext | SQL Reporting Services |  | Ext
Iron | PowerSchool |  |  |  | DigitalSAMS |  | Ext
Jordan | Skyward | Skyward |  | limited | Cognos |  | Ext | Skyward |  | Ext | SPSS |  | Ext | Excel
[NAME]  ([NAME]) | Powerschool
[NAME] | SIS2000+ |  |  |  | DigitalSAMS |  | Min
Logan | SIS2000+/Pinnacle | SQL database |  |  | Cognos |  | Ext | Cognos,Crystal Reports, SQL queries |  | Ext
Millard | Powerschool |  |  |  | Cognos |  | Min | PHP, SQL queries |  | Min
Morgan County School District | PowerSchool
Murray School District | SIS2000+ | SQL database |  |  | Cognos |  | Mod | Cognos, SQL Queries |  | Mod | SPSS |  | Mod
NEBO School District | SIS2000+ | MySQL, MSSQL | MSSQL is primarily used for SIS, but additional tables have been added for storing district-specific data.  MySQL is used to store a wide variety of district-specific data. | Ext | Cognos,alio Intelligence | Cognos is primarliy used to generate reports of disagregated CRT data.  We are just beginning to use the new alio Intelligence tool, primarily for financial queries and reports. | Mod | PHP for mini report cards, student profile, elementary collaboration; Cognos, SQL | SQL is our primary means of responding to adhoc data requests.  Cognos is used to generate disagregated CRT reports.  PHP is used to write web applications that provide employees access to data and allow entry of new data. | Ext
[NAME] ([NAME]) | PowerSchool |  |  |  | Cognos |  | Min
North Summit NUES | PowerSchool |  |  |  | Cognos |  | Min | PHP in Powerschool |  | Ext
Ogden | SIS2000+ |  |  |  | Cognos |  | Ext | Cognos, PHP, OSIS |  | Ext
Park City | PowerSchool | Homegrown in SQL Server 2005 |  |  | Cognos |  | Mod | SQL queries, , PHP scripts, working on custom tool using PHP/Apache/JavaScript for reporting inside Powerschool |  | Mod
Piute  ([NAME]) | Powerschool
Provo | PowerSchool |  |  |  | DigitalSAMS |  | Min
[NAME] | SIS2000+ |  |  |  | DigitalSAMS, Cognos |  | Min
[NAME] | [NAME] | AAL eSIS | Custom based on eSIS [NAME], MS Access | Our Data Warehouse Use is based on our SIS Oracle Database we use other tools such as MS Access to connect and retrieve the data.  In addition to the SIS Database we use the SERF data that comes back as well as our own clearing house data files. | Ext | MS Access, [NAME], SPSS, eSIS | The description of Business Intelegance Poroducets is a bit of a strech in the normal terms but the tools such as MS Access and SPSS allows to create appropriate views of the data for schools/teachers and administrators | Ext | eSIS, MS Access, SPSS, [NAME], Application Express | The nature of reporting takes on several different meanings.  In some cases the reports are individual student based consisting of multiple years of history, such as our Cummulative Assessment Report or is some cases it is true stistical analysis of multiple data points regarding large or small groups of students, general in SPSS. | Ext
Salt Lake Center For Science Education | AAL eSIS
Salt Lake School For The Performing Arts | AAL eSIS
San Juan | SIS2000+ | Custom built on SQL Server |  | Mod |  |  |  | SQL Server Reporting Services, custom-built Silverlight grid |  | Mod
[NAME] (CUES) | Sevier |  |  |  | MS Excel for graphic representation |  | Ext | Crystal Reports via NWEA |  | Ext | PICK db and PICK reporting tools |  | Ext
South Sanpete ([NAME]) | PowerSchool |  |  |  |  |  |  |  |  |  | Looking into Phoenixlearning
South Summit NUES | PowerSchool |  |  |  | DigitalSAMS |  | Min
Tintic (CUES)/USOE | SIS2000+
Tooele | SIS2000+ | SQL database |  | [NAME] | Cognos |  | Min | SQL queries, Cognos, SPSS |  | Ext | stoneware |  | min
[NAME] | SIS2000+ |  |  |  | Cognos |  | Mod | Cognos |  | Mod
USDB | SIS2000+
Wasatch | SIS2000+ |  |  |  | DigitalSAMS, Cognos |  | Ext, Min
Washington County | PowerSchool | Working on custom-built (SQL) |  |  | Cognos, Powerschool |  | Ext | Cognos, SPSS, MS Reporting Services, PHP, custom Powerschool SQL reports |  | Ext | MS Excel as analysis tool |  | Ext
[NAME]  (CUES)/USOE | SIS2000+ |  |  |  | Cognos, MS Excel for analysis |  | Min
Weber | AS400 |  |  |  | Cognos |  | Min | Crystal reports, PHP, Lansa |  | Ext