Difference between revisions of "SAM V1"

From CIDI Wiki
Jump to navigation Jump to search
 
(180 intermediate revisions by 10 users not shown)
Line 2: Line 2:
|-
|-
| style="text-align: left; vertical-align: top; padding: 0.2em 0.4em;"|
| style="text-align: left; vertical-align: top; padding: 0.2em 0.4em;"|
[[Image:Database.gif|Database Icon]]&nbsp;&nbsp;<font size="+1">'''Student Accommodation Manager Version 1 (SAM V1)'''</font>
[[Image:SAM.png|80px|SAM Logo]]&nbsp;&nbsp;<font size="+1">'''Student Accommodation Manager'''</font>


The Student Accommodations Manager Version 1 (SAM V1) 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 is developed and hosted using Intuit's [http://www.quickbase.com QuickBase] and follows a [[Wikipedia:Software_as_a_service|software-as-a-service]] model where there is no software to install or server to manage or own.  Essential functions such as system availability and backups are provided for you.  Predefined reports as well as a powerful report writer allow you to quickly and easily find, filter, and transform data.  SAM V1 can also serve as a forms repository and auto-generate accommodation notification letters.  For institutions lacking strong IT support, SAM V1 offers a viable multi-user, web-based solution.
The Student Accommodation Manager 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 is developed and hosted using [http://www.quickbase.com QuickBase] and follows a [[Wikipedia:Software_as_a_service|software-as-a-service]] model where there is no software to install or server to manage or own.  Essential functions such as system availability and backups are provided for you.  Predefined reports as well as a powerful report writer allow you to quickly and easily find, filter, and transform data.  SAM can also serve as a forms repository and auto-generate accommodation notification letters.  For institutions lacking strong IT support, SAM offers a viable multi-user, web-based solution.




[[Image:help.gif|Help Icon]]&nbsp;'''Learn More:'''
[[Image:help.gif|Help Icon]]&nbsp;'''Learn More:'''


*SAM V1 Fact Sheet
*[https://www.quickbase.com/db/bgfg6wqr6 SAM Demo Application], for access please contact Doug Neal at [mailto:doug.neal@amac.gatech.edu doug.neal@amac.gatech.edu] or Sam Evans at [mailto:sam.evans@amac.gatech.edu sam.evans@amac.gatech.edu] also reach them toll-free at 866-279-2964
*[https://www.quickbase.com/db/bcsnjrd97 SAM V1 Demo Application], for access please contact Joe Davis at 866-279-2964 or [mailto:davisj@uga.edu davisj@uga.edu]
*[[SAM_Testimonial|Read what SAM customers are saying...]]
*[[Media:SAMV1vsSAMV2.pdf|Comparison of SAM V1 and SAM V2]]
| align="center" style="width: 25%;"|
| align="center" style="width: 25%;"|
__TOC__
__TOC__
Line 21: Line 20:
==Features==
==Features==


SAM V1 was developed using Intuit's [http://www.quickbase.com QuickBase] and utilizes standard QuickBase features and [http://quickbase.intuit.com/overview/security/ security], including:
SAM was developed using [http://www.quickbase.com QuickBase] and utilizes standard QuickBase features and [http://www.quickbase.com/product-tour/security security], including:


* Totally web-based
* SAM is completely web-based, all information stored in SAM is available anywhere there is access to the internet
* 24-hour, 365-day availability
* SAM is accessible 24-hours a day, 365-days of the year removing the need to carry file folders desk to desk, office to office
* No special software or installations required
* SAM customers do not have to update software on any computer where SAM is used reducing user frustration
* Accessible / [http://www.amac.uga.edu/samvpat.php VPAT] Voluntary Product Accessibility Template
* SAM customers do not have to purchase additional software for every computer reducing costs
* Custom, printable reporting
* SAM meets [[SAMVPAT|VPAT]] requirements allowing any user access to valuable information
* Email integration
* SAM provides customers the ability to run/create/save/archive reports as easily as clicking on a mouse
* Searchable on-line help
* SAM provides customers the ability to create reports that reduce the time spent in compiling required reports
* Advanced access control via logins, users and roles
* SAM reports can be exported into excel providing greater communication between DSP offices and Financial decision makers
* Data encryption
* SAM reports can be emailed directly to 3rd parties which allows easier relay of the information hosted in SAM
* Daily backups
* SAM reports can be printed as necessary making administrative tasks easier and less time consuming
* Redundant data storage
* SAM provides email integration allowing users to use SAM as a communication tool for students, professors and DSP staff
* SAM provides searchable on-line help allowing users to obtain help without having to pick up the phone
* SAM allows customers to define user roles which controls access to information protecting privacy
* SAM's Quickbase application provides data encryption which fights against unwanted use of stored data
* SAM's Quickbase application provides daily backups freeing IT support to accomplish other vital tasks
* SAM's Quickbase redundant data storage procedures ensures all data is stored in duplicate preventing the loss of data
 
==Training==
*[http://www.amacusg.org/presentations/SAM/index.html SAM Training Presentation]
* SAM and the NEW Quickbase: [[Media:SAM_and_the_New_QuickBase.pdf|PDF]] | [[Media:SAM_and_the_New_QuickBase.docx|DOC]]


==Terminology==
==Terminology==


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


* [[Wikipedia:Application_software|What is an application?]]
* [[Wikipedia:Application_software|What is an application?]]
Line 47: Line 55:
==Tables==
==Tables==


SAM V1 organizes data into different [[SAM V1:Tables |tables]] that allow you to instantly access, sort, and find information for an individual student or related data sets.
SAM organizes data into different [[SAM V1: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 V1:Students|Student]] table, however, SAM V1 allows users to manage data for and report on:
At the core is the [[SAM V1:Students|Student]] table, however, SAM allows users to manage data for and report on:


{| width="100%"
{| width="100%"
Line 69: Line 77:
==Access==
==Access==


Access to SAM V1 requires a login and password.  Each user is provided with their own login and password.  A user’s login is their email address.  Passwords are case sensitive.
Access to SAM requires a login and password.  Each user is provided with their own login and password.  A user’s login is their email address.  Passwords are case sensitive.


[https://www.quickbase.com/db/main?a=signin Login to SAM V1]
[https://www.quickbase.com/db/main?a=signin Login to SAM]


==Security==
==Security==


Users of SAM V1 benefit from the following [http://quickbase.intuit.com/overview/security/ security] measures provided for all [http://www.quickbase.com QuickBase] applications:
Users of SAM benefit from the following [http://www.quickbase.com/product-tour/security security] measures provided for all [http://www.quickbase.com QuickBase] applications:


* An industry-standard, 128-bit Secure Socket Layers (SSL) protocol is employed to ensure information is neither intercepted nor corrupted during transmission over the Internet.
* An industry-standard, 128-bit Secure Socket Layers (SSL) protocol is employed to ensure information is neither intercepted nor corrupted during transmission over the Internet.
Line 83: Line 91:
==Permissions==
==Permissions==


SAM V1 users can access the same data simultaneously.  However, using [[SAM_V1:Permissions|roles and permissions]], you can determine what data users can see and what actions users can perform.
SAM users can access the same data simultaneously.  However, using [[SAM V1:Permissions|roles and permissions]], you can determine what data users can see and what actions users can perform.


==Reporting==
==Reporting==


With SAM V1, you can quickly and easily find and view your data the way you want.  Reporting is simple, with:
With SAM, 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.
* A host of pre-defined reports to help you get started quickly.
Line 95: Line 103:
==Implementation==
==Implementation==


The SAM V1 customer application is created by copying the master SAM QuickBase application.  SAM con [[NEON]] is used as the source master when the customer will also be an [[Disability_Professional_Member_Guide|AMAC Member]] and have students in [[NEON]].  SAM sin [[NEON]] is used as the source master when the customer will not have related students in [[NEON]].
Prior to creating the SAM application for the customer, the customer will complete the guide provided by the SAM team. [[Media:SAM Implementation LIVE.pdf|SAM Implementation Guide]].  This implementation guide helps our customer identify:
 
Prior to creating the SAM V1 application for the customer, the customer should complete the [[Media:SAMV1 Implementation Guide w instructions.doc|SAMV1 Implementation Guide with instructions]].  This Microsoft Word document helps the customer identify:


* How many users will have access
* How many users will have access
Line 106: Line 112:
* The list of available accommodations
* The list of available accommodations


Completed documents and questions can be emailed to Joe Davis [mailto:davisj@uga.edu davisj@uga.edu].   
Completed documents and questions can be emailed to Doug Neal at [mailto:doug.neal@amac.gatech.edu doug.neal@amac.gatech.edu].   


When the SAM V1 customer application is created, [http://www.amac.uga.edu/ AMAC] will use the information provided in the implementation guide to provision users, create any new roles and permissions, and customize the values for multiple-choice fields.
When the SAM customer application is created, [http://www.amacusg.org/ AMAC] will use the information provided in the implementation guide to provision users, create any new roles and permissions, and customize the values for multiple-choice fields.


==Importing and Synching Data==
==Importing and Synching Data==


* [[SAM_V1:import|Banner]]
* [[SAM V1:import|Data Import Guide]]
* [[SAM_V1:PeopleSoft|PeopleSoft]]


==Licensing Agreement==
== Standard Pricing ==
 
* For information on SAM pricing, please contact Doug Neal by phone at 404.385.1128 or by emailing him at doug.neal@amac.gatech.edu.
*[[Media:SAMV1_Services_Agreement.doc|SAM V1 Services Agreement]]
 
==Pricing==
 
{|width="100%" border="0" cellspacing="0" cellpadding="0" valign="top"
|-
| 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, [[Disability_Professional_Member_Guide|AMAC Members]] $750 (Reduced)
*Access to the SAM V1 application.
*Access to the SAM V1 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.
|-
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
Hosting/User Fees
| 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;"|
$180/month ($2,160/annually)
*Maximum database size of 5MB
*Maximum file attachment storage of 100MB
*Maximum 10 users
*Users can optionally pay QuickBase for an account and not pay hosting/user fees. QuickBase lowest plan of 5MB database, 100MB file attachment, and 10 users priced at $249/month. See [http://www.quickbase.com www.quickbase.com] for an overview and additional features of having a QuickBase account.
*Covers application hosting, server maintenance, application backup and security, and user maintenance.
|-
| style="border-left: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
Support Fee
| style="border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
$250/year
*Required the first year of purchase.
*Estimated six hours of support per month.
*Covers application questions and assistance with report creation.
|-
 
| colspan="2" style="border: 1px solid #cccccc; text-align: left; background: #cedff2; font-weight: bold; color: #000000; padding: 0.2em 0.4em;"|
 
===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;"|
$250/year
*Optional after the first year of purchase.
*Estimated six hours of support per month.
*Covers application questions and assistance with report creation.
|-
| 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
*Covers application customization, import of legacy data, and integration with external systems (i.e. Banner, PeopleSoft).
|-
| 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
|-
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
Additional Fees
| 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;"|
*$50/month per 5MB database storage (if database size exceeds 5MB)
*$100/month per 100MB file attachment storage (if file attachment storage exceeds 100MB)
*$3/month per user (if exceed 10 users)
|}
 
==Training==
 
*[http://www.amac.uga.edu/presentations/SAM/index.html SAM V1 Training Presentation]


==Frequently Asked Questions==
==Frequently Asked Questions==


Since SAM V1 is developed using Intuit's [http://www.quickbase.com QuickBase], the application layout, navigation, and functions are controlled by [http://www.quickbase.com QuickBase].  To learn more about a particular topic, choose from the list below:
Since SAM is developed using [http://www.quickbase.com QuickBase], the application layout, navigation, and functions are controlled by [http://www.quickbase.com QuickBase].  To learn more about a particular topic, choose from the list below:


* [http://www.quickbase.com/help/default.html#myquickbase.html What is My Quickbase?]
* [http://www.quickbase.com/help/default.html#myquickbase.html What is My Quickbase?]
Line 201: Line 136:
* [http://www.quickbase.com/help/default.html#importing_data.html How do I import data?]
* [http://www.quickbase.com/help/default.html#importing_data.html How do I import data?]
* [http://www.quickbase.com/help/default.html#flags.html How do I use the new and update flags]
* [http://www.quickbase.com/help/default.html#flags.html How do I use the new and update flags]
[[Category:Disability Service Provider]]
[[Category:Information Technology]]
[[Category:Services]]
[[Category:Software]]
[[Category:Reference]]
{| style="width: 100%; background: #FDF8D6; border: 1px solid #cccccc; text-align: left;"
|-
| style="text-align: left; vertical-align: top; padding: 0.2em 0.4em;"|
[[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 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.
[[Image:help.gif|Help Icon]]&nbsp;'''Learn More:'''
*SAM V2 Fact Sheet
*[https://www.uga.edu/amac/samv2/ SAM V2 Demo Application], for access please contact Joe Davis at 866-279-2964 or davisj@uga.edu
*[[Media:SAMV1vsSAMV2.pdf|Comparison of SAM V1 and SAM V2]]
*[http://media.wiley.com/product_data/excerpt/67/07645574/0764557467.pdf Why PHP and MySQL]
| align="center" style="width: 25%;"|
__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
[[Image:Alert.gif|Alert Icon]] For institutions considering SAM V2, it is important to remember:
* 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 [[Portal:IT_Unit|Information Technology]] (IT) Professional who will perform the installation of SAM V2 and manage permissions and implementation. 
*The [[Portal:IT_Unit|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|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:Accommodations|Accommodations]]
* [[SAM V2:Consent Types|Consent Types]]
* [[SAM V2:Referrals|Referrals]]
* [[SAM V2:Case Notes|Case Notes]]
* [[SAM V2:Tasks|Tasks]]
|
* [[SAM V2:Tests|Tests]]
* [[SAM V2:Orders|Alternate Media Orders]]
* [[SAM V2:Components|Components]]
* [[SAM V2:Class Schedules|Class Schedules]]
* [[SAM V2:Documentation|Documentation]]
|}
In addition, SAM V2 allows for easy application setup and customization by adding or editing records in the following tables:
* [[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]]
==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 [[SAM V2:Users|user]] accounts.
==Security==
* Internet transmission can be either unencrypted or employ 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 the responsibility of 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 user 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 access 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.
* A 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==
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, it is important to consider:
* The users who will have access
* The user permissions
* The multiple-choice field values
* The list of available accommodations
==Importing and Synching Data==
* [[SAM V2:import|Banner]]
==Licensing Agreement==
*[[Media:SAMV2_Services_Agreement.doc|SAM V2 Services Agreement]]
==Pricing==
{|width="100%" border="0" cellspacing="0" cellpadding="0" valign="top"
|-
| 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, [[Disability_Professional_Member_Guide|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.
|-
| style="border-left: 1px solid #cccccc; border-bottom: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
Hosting/User Fees
| 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;"|
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.
|-
| style="border-left: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
Support Fee
| style="border-left: 1px solid #cccccc; border-right: 1px solid #cccccc; vertical-align: top; background: #fafafa; padding: 0.2em 0.4em;"|
$500/year
*Required the first year of purchase.
*Estimated ten hours of support per month.
*Covers application questions and assistance with report creation.
|-
| colspan="2" style="border: 1px solid #cccccc; text-align: left; background: #cedff2; font-weight: bold; color: #000000; padding: 0.2em 0.4em;"|
===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
*Optional after the first year of purchase.
*Estimated ten hours of support per month.
*Covers application questions and assistance with report creation.
|-
| 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
*Covers application customization, import of legacy data, and integration with external systems (i.e. Banner).
|-
| 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
|}
[[Category:Disability Service Provider]]
[[Category:Information Technology]]
[[Category:Software]]
[[Category:Reference]]

Latest revision as of 08:08, 8 September 2018

SAM Logo  Student Accommodation Manager

The Student Accommodation Manager 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 is developed and hosted using QuickBase and follows a software-as-a-service model where there is no software to install or server to manage or own. Essential functions such as system availability and backups are provided for you. Predefined reports as well as a powerful report writer allow you to quickly and easily find, filter, and transform data. SAM can also serve as a forms repository and auto-generate accommodation notification letters. For institutions lacking strong IT support, SAM offers a viable multi-user, web-based solution.


Help Icon Learn More:

 

Features

SAM was developed using QuickBase and utilizes standard QuickBase features and security, including:

  • SAM is completely web-based, all information stored in SAM is available anywhere there is access to the internet
  • SAM is accessible 24-hours a day, 365-days of the year removing the need to carry file folders desk to desk, office to office
  • SAM customers do not have to update software on any computer where SAM is used reducing user frustration
  • SAM customers do not have to purchase additional software for every computer reducing costs
  • SAM meets VPAT requirements allowing any user access to valuable information
  • SAM provides customers the ability to run/create/save/archive reports as easily as clicking on a mouse
  • SAM provides customers the ability to create reports that reduce the time spent in compiling required reports
  • SAM reports can be exported into excel providing greater communication between DSP offices and Financial decision makers
  • SAM reports can be emailed directly to 3rd parties which allows easier relay of the information hosted in SAM
  • SAM reports can be printed as necessary making administrative tasks easier and less time consuming
  • SAM provides email integration allowing users to use SAM as a communication tool for students, professors and DSP staff
  • SAM provides searchable on-line help allowing users to obtain help without having to pick up the phone
  • SAM allows customers to define user roles which controls access to information protecting privacy
  • SAM's Quickbase application provides data encryption which fights against unwanted use of stored data
  • SAM's Quickbase application provides daily backups freeing IT support to accomplish other vital tasks
  • SAM's Quickbase redundant data storage procedures ensures all data is stored in duplicate preventing the loss of data

Training

Terminology

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

Tables

SAM 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 allows users to manage data for and report on:

Access

Access to SAM requires a login and password. Each user is provided with their own login and password. A user’s login is their email address. Passwords are case sensitive.

Login to SAM

Security

Users of SAM benefit from the following security measures provided for all QuickBase applications:

  • An industry-standard, 128-bit Secure Socket Layers (SSL) protocol is employed to ensure information is neither intercepted nor corrupted during transmission over the Internet.
  • Encryption technology is used to help protect data stored on disk.
  • A state-of-the-art data center provides intrusion detection software and hardware, advanced firewall software, daily back-ups to prevent data loss, video surveillance, and uninterruptible power supplies.

Permissions

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

Reporting

With SAM, 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 easy to use report writer that allows you to create tabular reports, summary reports, and even graphs and charts.
  • A powerful Find feature that allows you to filter data by multiple fields.

Implementation

Prior to creating the SAM application for the customer, the customer will complete the guide provided by the SAM team. SAM Implementation Guide. This implementation guide helps our customer identify:

  • How many users will have access
  • The name and email address of all users (this information will be used to create the QuickBase logins for users)
  • If any new roles and permissions are required in addition to the service provider and administrator roles
  • What role to assign to each user
  • The multiple-choice field values
  • The list of available accommodations

Completed documents and questions can be emailed to Doug Neal at doug.neal@amac.gatech.edu.

When the SAM customer application is created, AMAC will use the information provided in the implementation guide to provision users, create any new roles and permissions, and customize the values for multiple-choice fields.

Importing and Synching Data

Standard Pricing

  • For information on SAM pricing, please contact Doug Neal by phone at 404.385.1128 or by emailing him at doug.neal@amac.gatech.edu.

Frequently Asked Questions

Since SAM is developed using QuickBase, the application layout, navigation, and functions are controlled by QuickBase. To learn more about a particular topic, choose from the list below: