Difference between revisions of "SAM V2"

From CIDI Wiki
Jump to: navigation, search
(Security)
Line 1: Line 1:
{| width="95%"
+
{| style="width: 100%; background: #FDF8D6; border: 1px solid #cccccc; text-align: left;"
 
|-
 
|-
| valign="top"|
+
| style="text-align: left; vertical-align: top; padding: 0.2em 0.4em;"|
='''Student Accommodations Manager Version 2 (SAM V2)'''=
+
[[Image:Database.gif|Database Icon]]&nbsp;&nbsp;<font size="+1">'''Student Accommodation Manager Version 2 (SAM V2)'''</font>
  
The Student Accommodations Manager Version 2 (SAM V2) is an easy-to-use database software application that helps postsecondary Disability Service Providers manage student data, accommodations, exams, forms, letters, reports, and more.
+
The Student Accommodations Manager Version 2 (SAM V2) is a secure, web-based database application designed to help postsecondary Disability Service Providers manage student data, disabilities, accommodations, case notes, and much more.  SAM V1 was developed using the leading open source solutions of [http://www.php.net PHP] and [http://www.mysql.com MySQL].  SAM V2 follows a traditional purchased software model where the SAM V2 software and database, along with PHP and MySQL, are installed on a server owned and managed by the institution.  Essential functions such as installation, system availability and backups are the responsibility of the institution.  Predefined reports as well as a report writer allow you to quickly find, filter, and transform data; however, knowledge of [http://www.w3schools.com/SQL/sql_intro.asp SQL] is required.  For institutions with solid IT support, SAM V2 offers an affordable multi-user, web-based solution.  
  
SAM V2 allows disability service providers to manage and report on:
+
<hr>[[Image:help.gif|Help Icon]]&nbsp;'''Learn More'''<hr>
  
* [[SAM V2:Students|Students]]
+
*SAM V2 Fact Sheet
 +
*[https://www.uga.edu/amac/samv2/ SAM V2 Demo Application]
 +
*[[Media:SAMV1vsSAMV2.pdf|Comparison of SAM V1 and SAM V2]]
 +
| align="center" style="width: 20%;"|
 +
__TOC__
 +
|}
 +
 
 +
==Features==
 +
 
 +
* Totally web-based
 +
* Accessible
 +
* Custom, printable reporting
 +
* Access control via logins and permissions
 +
* Hardware maintenance and availability are the responsibility of the institution
 +
* Software installation and configuration are the responsibility of the institution
 +
* Database backup and availability are the responsibility of the institution
 +
 
 +
For institutions considering SAM V2, it is important to remember that the institution must have a web server with [http://www.php.net PHP] and [http://www.mysql.com MySQL] installed.  The Disability Service Provider needs to identify a campus Information Technology (IT) Professional who will perform the installation of SAM V2 and manage persmissions and implementation.  The IT Professional should review the [[SAM V2:Installation|installation specifics]] as well as the architecture and features prior to purchasing SAM V2.
 +
 
 +
==Terminology==
 +
 
 +
SAM V2 is a relational database application.  An understanding of the following terms and concepts is essential to understanding the SAM V1 design:
 +
 
 +
* [[Wikipedia:Application_software|What is an application?]]
 +
* [[Wikipedia:Database|What is a database?]]
 +
* [[Wikipedia:Record_%28database%29|What is a record?]]
 +
* [[Wikipedia:Field_%28computer_science%29|What is a field?]]
 +
* [[Wikipedia:View_%28database%29|What is a report or view?]]
 +
 
 +
==Tables==
 +
 
 +
SAM V2 organizes data into different [[SAM V2:Tables |tables]] that allow you to instantly access, sort, and find information for an individual student or related data sets.
 +
 
 +
At the core is the [[SAM V2:Students|student]] table, however, SAM V2 allows users to manage data for and report on:
 +
 
 +
{| width="100%"
 +
|-
 +
|
 
* [[SAM V2:Disabilities|Disabilities]]
 
* [[SAM V2:Disabilities|Disabilities]]
 
* [[SAM V2:Accommodations|Accommodations]]
 
* [[SAM V2:Accommodations|Accommodations]]
Line 15: Line 52:
 
* [[SAM V2:Case Notes|Case Notes]]
 
* [[SAM V2:Case Notes|Case Notes]]
 
* [[SAM V2:Tasks|Tasks]]
 
* [[SAM V2:Tasks|Tasks]]
 +
|
 +
 
* [[SAM V2:Tests|Tests]]
 
* [[SAM V2:Tests|Tests]]
 
* [[SAM V2:Orders|Alternate Media Orders]]
 
* [[SAM V2:Orders|Alternate Media Orders]]
 +
* [[SAM V2:Components|Components]]
 
* [[SAM V2:Class Schedules|Class Schedules]]
 
* [[SAM V2:Class Schedules|Class Schedules]]
 
* [[SAM V2:Documentation|Documentation]]
 
* [[SAM V2:Documentation|Documentation]]
| width="5%"|
 
| valign="top"|
 
__TOC__
 
 
|}
 
|}
  
==Demo==
+
In addition, SAM V2 allows for easy application setup and customization by adding or editing records in the following tables:
[https://www.uga.edu/amac/samv2 Log in to the SAM V2 Demo]
+
  
==Getting Started==
+
* [[SAM V2:Accommodation Masters|Accommodation Masters]]
 +
* [[SAM V2:Multiple Choice Fields|Multiple Choice Fields]]
 +
* [[SAM V2:Reports|Reports]]
 +
* [[SAM V2:Users|Users]]
 +
* [[SAM V2:Permissions|Permissions]]
  
*SAM V2 is a relational database application, and as such, an understanding of the [[SAM V2:Terminology | database terms]] and concepts is essential.
+
==Access==
*The Disability Service Provider needs to identify a campus Information Technology (IT) Professional who will oversee the installation of SAM V2 and manage persmissions and implementation.
+
*Installation of SAM V2 is performed by the institution.
+
* SAM V2 requires the institution to have a web server with PHP and MySQL.
+
* The IT Professional can review the [[SAM V2:Installation|SAM V2 installation specifics]] and [[SAM V2:Architecture and Features|SAM V2 architecture and features]].
+
  
==Instant Access to the Information You Need==
+
Access to SAM V2 requires a login and password.  Each user is provided with their own login and password.  It is up to the institution to manage [[SAM V2:Users|user]] accounts.
  
* SAM V2 is comprised of a number of different [[SAM V2:Tables |tables]] that allow you to organize, sort, and find student information from individual files to large data sets.
+
==Security==
* When asked, you will have disability information, student accommodations, case note history, and contact information right at hand.
+
  
==Report and Communicate All Your Information==
+
* Internet transmission can be either unencrypted or employe 128-bit Secure Socket Layer (SSL) encryption.  As the web server is owned and managed by the institution, it depends on the institution to determine the configuration.
 +
* The physical security of the web and database server(s) is performed by the institution.
  
* Transform data by choosing from a host of pre-defined report templates.
+
==Permissions==
* Create your own reports using SQL.
+
* SAM V2 offers a sophisticated '''Find''' feature that allows you to filter data by multiple fields.
+
  
==Built-in Network Sharing and Permissions==
+
SAM V2 users can access the same data simultaneously. However, using permissions, you can determine what data users can see and what functions users can perform.
  
* Users can [[SAM V2:Login and Passwords |login]] to SAM V2 and access the same student file simultaneously.
+
Functions include adding, editing, viewing or deleting data. For example, a iser can be setup so that they can view records in a table but not add records to the table.
* SAM V2 offers levels of access [[SAM V2:Permissions | permission]] so you can determine what your users can do and see.
+
 
 +
Table level permissions can be configured for users.  For example, a user can be setup to acccess student records but not disability records.  SAM V2 does not support field level permissions.  If a user can view student records, the user can view all fields on the student record.
 +
 
 +
==Reporting==
 +
 
 +
With SAM V2, you can quickly and easily find and view your data the way you want. Reporting is simple, with:
 +
 
 +
* A host of pre-defined reports to help you get started quickly.
 +
* An built-in report writer that allows you to create, print, or export tabular and summary reports.
 +
* A powerful Find feature that allows you to filter data by multiple fields.
 +
 
 +
A good knowledge of [http://www.w3schools.com/SQL/sql_intro.asp SQL] is required to create custom reports using the SAM V2 [[SAM V2:Reports|report]] interface.
  
 
==Implementation==
 
==Implementation==
  
* The institution is responsible for configuring SAM V2.
+
The institution is responsible for installing and configuring the SAM V2 software. Most setup customizations are easily performed by adding or modifying records in the database located under the administration menu.
** Configuration is performed by adding or modifying records in the database located under the administration menu.
+
* To help with implementation, AMAC has developed a [[Media:SAM_V2_Implementation_Guide.doc|SAM V2 Implementation Guide]]. This document helps the disability service provider identify:
+
** The users who will have access
+
** The user permissions
+
** The multiple-choice field values
+
** The list of available accommodations
+
  
==Security==
+
To help with implementation, AMAC has developed a [[Media:SAM_V2_Implementation_Guide.doc|SAM V2 Implementation Guide]]. This document helps the disability service provider identify:
  
* Internet transmission can be either unencrypted or use 128-bit Secure Socket Layer (SSL) encryption.  Since the web server is owned and managed by the institution, it depends on the institution to determine the configuration.  Both http and https protocols are supported. 
+
* The users who will have access
* Only users with a username and password can access the SAM V2 application.  User management is managed within the administrative functions of the SAM V2 application by the institution.
+
* The user permissions
* Users are assigned permissions, which determine which data within the SAM V2 application they can see and what functions they can perform.  User permission management is managed within the administration functions of the SAM V2 application by the institution.
+
* The multiple-choice field values
* Functions include adding, editing, viewing, or deleting data.  For example, a user can be setup so that users can view records but not add records.
+
* The list of available accommodations
* Only table level permissions exist for users.  SAM V2 does not support field level permissions.  For example, a user can be setup to access student records but not disability records.  If a user can view student records, they can view all fields on the student record.
+
* Physical security of the web and database server(s) is performed by the institution.
+
  
==Licensing==
+
==Licensing Agreement==
  
 
*[[Media:SAMV2_Services_Agreement.doc|SAM V2 Services Agreement]]
 
*[[Media:SAMV2_Services_Agreement.doc|SAM V2 Services Agreement]]
  
==Pricing, Services, & Technical Support==
+
==Pricing==
  
{| border="1" cellspacing="1" cellpadding="1"
+
{|width="100%" border="0" cellspacing="0" cellpadding="0" valign="top"  
|'''Required Costs'''
+
|-
Cost of SAM V2 and Initial Training
+
| colspan="2" style="border: 1px solid #cccccc; text-align: left; background: #cedff2; font-weight: bold; color: #000000; padding: 0.2em 0.4em;"|
|
+
===Required Costs===
 +
|-
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 +
Initial Application Fee and Training
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 
One Payment of $950, AMAC Members $750 (Reduced)  
 
One Payment of $950, AMAC Members $750 (Reduced)  
 
*Source code for the SAM V2 application and database.
 
*Source code for the SAM V2 application and database.
Line 85: Line 126:
 
*One phone training and one follow-up phone training within 14 days of the purchase.  Training may be conducted via web conferencing based on the user(s) needs.
 
*One phone training and one follow-up phone training within 14 days of the purchase.  Training may be conducted via web conferencing based on the user(s) needs.
 
|-
 
|-
|Hosting/User Fees  
+
| style="border-left: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
|
+
Hosting/User Fees
 +
| style="border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 
None
 
None
 
*PHP and SAM V2 PHP source code are installed on web server owned and managed by institution.
 
*PHP and SAM V2 PHP source code are installed on web server owned and managed by institution.
 
*MySQL and SAM V2 MySQL database are installed by the institution on server owned and managed by institution.
 
*MySQL and SAM V2 MySQL database are installed by the institution on server owned and managed by institution.
 
*PHP and MySQL are open source.
 
*PHP and MySQL are open source.
|-  
+
|-
|'''Optional Costs'''
+
| colspan="2" style="border: 1px solid #cccccc; text-align: left; background: #cedff2; font-weight: bold; color: #000000; padding: 0.2em 0.4em;"|
Support Fee  
+
===Optional Costs===
|
+
|-
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 +
Support Fee
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 
$500/year  
 
$500/year  
 
*Estimated ten hours of support per month.
 
*Estimated ten hours of support per month.
 
*Covers application questions and assistance with report creation.
 
*Covers application questions and assistance with report creation.
|-  
+
|-
|Customization Fee  
+
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
|
+
Customization Fee
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 
$125/hour  
 
$125/hour  
*Covers application customization, import of legacy data, and integration with external systems (i.e. Banner).
+
*Covers application customization, import of legacy data, and integration with external systems (i.e. Banner, PeopleSoft).
*Cost estimates can be requested
+
 
|-
 
|-
|On-Site Customer Training
+
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
|
+
On-Site Customer Training
 +
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
 
$1,200/day plus travel costs  
 
$1,200/day plus travel costs  
 
|}
 
|}

Revision as of 18:10, 7 November 2008

Database Icon  Student Accommodation Manager Version 2 (SAM V2)

The Student Accommodations Manager Version 2 (SAM V2) is a secure, web-based database application designed to help postsecondary Disability Service Providers manage student data, disabilities, accommodations, case notes, and much more. SAM V1 was developed using the leading open source solutions of PHP and MySQL. SAM V2 follows a traditional purchased software model where the SAM V2 software and database, along with PHP and MySQL, are installed on a server owned and managed by the institution. Essential functions such as installation, system availability and backups are the responsibility of the institution. Predefined reports as well as a report writer allow you to quickly find, filter, and transform data; however, knowledge of SQL is required. For institutions with solid IT support, SAM V2 offers an affordable multi-user, web-based solution.


Help Icon Learn More

Features

  • Totally web-based
  • Accessible
  • Custom, printable reporting
  • Access control via logins and permissions
  • Hardware maintenance and availability are the responsibility of the institution
  • Software installation and configuration are the responsibility of the institution
  • Database backup and availability are the responsibility of the institution

For institutions considering SAM V2, it is important to remember that the institution must have a web server with PHP and MySQL installed. The Disability Service Provider needs to identify a campus Information Technology (IT) Professional who will perform the installation of SAM V2 and manage persmissions and implementation. The IT Professional should review the installation specifics as well as the architecture and features prior to purchasing SAM V2.

Terminology

SAM V2 is a relational database application. An understanding of the following terms and concepts is essential to understanding the SAM V1 design:

Tables

SAM V2 organizes data into different tables that allow you to instantly access, sort, and find information for an individual student or related data sets.

At the core is the student table, however, SAM V2 allows users to manage data for and report on:

In addition, SAM V2 allows for easy application setup and customization by adding or editing records in the following tables:

Access

Access to SAM V2 requires a login and password. Each user is provided with their own login and password. It is up to the institution to manage user accounts.

Security

  • Internet transmission can be either unencrypted or employe 128-bit Secure Socket Layer (SSL) encryption. As the web server is owned and managed by the institution, it depends on the institution to determine the configuration.
  • The physical security of the web and database server(s) is performed by the institution.

Permissions

SAM V2 users can access the same data simultaneously. However, using permissions, you can determine what data users can see and what functions users can perform.

Functions include adding, editing, viewing or deleting data. For example, a iser can be setup so that they can view records in a table but not add records to the table.

Table level permissions can be configured for users. For example, a user can be setup to acccess student records but not disability records. SAM V2 does not support field level permissions. If a user can view student records, the user can view all fields on the student record.

Reporting

With SAM V2, you can quickly and easily find and view your data the way you want. Reporting is simple, with:

  • A host of pre-defined reports to help you get started quickly.
  • An built-in report writer that allows you to create, print, or export tabular and summary reports.
  • A powerful Find feature that allows you to filter data by multiple fields.

A good knowledge of SQL is required to create custom reports using the SAM V2 report interface.

Implementation

The institution is responsible for installing and configuring the SAM V2 software. Most setup customizations are easily performed by adding or modifying records in the database located under the administration menu.

To help with implementation, AMAC has developed a SAM V2 Implementation Guide. This document helps the disability service provider identify:

  • The users who will have access
  • The user permissions
  • The multiple-choice field values
  • The list of available accommodations

Licensing Agreement

Pricing

Required Costs

Initial Application Fee and Training

One Payment of $950, AMAC Members $750 (Reduced)

  • Source code for the SAM V2 application and database.
  • Access to the SAM V2 online application documentation.
  • One phone training and one follow-up phone training within 14 days of the purchase. Training may be conducted via web conferencing based on the user(s) needs.

Hosting/User Fees

None

  • PHP and SAM V2 PHP source code are installed on web server owned and managed by institution.
  • MySQL and SAM V2 MySQL database are installed by the institution on server owned and managed by institution.
  • PHP and MySQL are open source.

Optional Costs

Support Fee

$500/year

  • Estimated ten hours of support per month.
  • Covers application questions and assistance with report creation.

Customization Fee

$125/hour

  • Covers application customization, import of legacy data, and integration with external systems (i.e. Banner, PeopleSoft).

On-Site Customer Training

$1,200/day plus travel costs