SmarterApp Logo
How to Add a Calculator Accommodation
2024-03-26 14:03:06 -0400 |

Overview

The calculator user interface (UI) is provided by Desmos. There are three types of calculator accommodation available:

The calculator accommodation can be assigned to an assessment as an “assessment-wide” accommodation (that is, the calculator is available in every segment of the assessment) or it can be assigned to a specific segment.

Creating a Calculator Accommodation

Pre-requisites

To create an assessment-wide Basic Calculator accommodation, the following information is required:

Calculator Creation Steps

To create a calculator accommodation for an assessment, take the following steps:

  1. Determine the testid of the assessment that should have a calculator assigned to it
  2. Determine the type of calculator that should be assigned to the Assessment
  3. Copy the SQL for the desired calculator into an editor
  4. Replace the placeholders with appropriate values
  5. Execute the SQL against your database

SQL to Create an Assessment-Wide Basic Calculator Accommodation

NOTE: There must be two records per language - one for the calculator code (e.g. TDS_CalcBasic) and another for the disabled calculator code (i.e. TDS_Calc0). The INSERTs below insert a dependency for English (ENU) and Spanish (ESN)


INSERT INTO `client_testtooltype` (`clientname`,`toolname`,`allowchange`,`tideselectable`,`rtsfieldname`,`isrequired`,`tideselectablebysubject`,`isselectable`,`isvisible`,`studentcontrol`,`tooldescription`,`sortorder`,`dateentered`,`origin`,`source`,`contexttype`,`context`,`dependsontooltype`,`disableonguestsession`,`isfunctional`,`testmode`,`isentrycontrol`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator',1,0,'TDSAcc-Calculator',0,0,1,1,0,NULL,0,NOW(),'TDSCore_Staging_Configs_2013','TDSCore_Staging_Configs_2013','TEST','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','Language',0,1,'ALL',0);

INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_Calc0','None',0,0,'Calculator feature is disabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',1,'TDSCore_Staging_Configs_2012','TDSCore_Staging_Configs_2012','TEST','ALL',NULL);
INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_CalcBasic','Basic',1,0,'Basic Calculator is enabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',1,'TDSCore_Staging_Configs_2012','TDSCore_Staging_Configs_2012','TEST','ALL',NULL);

INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','TEST','Language','ESN',1,'Calculator','TDS_CalcBasic','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',1,'Calculator','TDS_CalcBasic','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ESN',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');

SQL to Create an Assessment-Wide Scientific Calculator Accommodation

NOTE: There must be two records per language - one for the calculator code (e.g. TDS_CalcBasic) and another for the disabled calculator code (i.e. TDS_Calc0). The INSERTs below insert a dependency for English (ENU) and Spanish (ESN)


INSERT INTO `client_testtooltype` (`clientname`,`toolname`,`allowchange`,`tideselectable`,`rtsfieldname`,`isrequired`,`tideselectablebysubject`,`isselectable`,`isvisible`,`studentcontrol`,`tooldescription`,`sortorder`,`dateentered`,`origin`,`source`,`contexttype`,`context`,`dependsontooltype`,`disableonguestsession`,`isfunctional`,`testmode`,`isentrycontrol`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator',1,0,'TDSAcc-Calculator',0,0,1,1,0,NULL,0,NOW(),'TDSCore_Staging_Configs_2013','TDSCore_Staging_Configs_2013','TEST','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','Language',0,1,'ALL',0);

INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_Calc0','None',0,0,'Calculator feature is disabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',-1,'Fairway','Fairway','TEST','ALL',NULL);
INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_CalcSciInv','ScientificInv',1,0,'Scientific Calculator is enabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',4,'Fairway','Fairway','TEST','ALL',NULL);

INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ESN',1,'Calculator','TDS_CalcSciInv','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',1,'Calculator','TDS_CalcSciInv','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ESN',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');

SQL to Create an Assessment-Wide Graphing Calculator Accommodation

NOTE: There must be two records per language - one for the calculator code (e.g. TDS_CalcBasic) and another for the disabled calculator code (i.e. TDS_Calc0). The INSERTs below insert a dependency for English (ENU) and Spanish (ESN)


INSERT INTO `client_testtooltype` (`clientname`,`toolname`,`allowchange`,`tideselectable`,`rtsfieldname`,`isrequired`,`tideselectablebysubject`,`isselectable`,`isvisible`,`studentcontrol`,`tooldescription`,`sortorder`,`dateentered`,`origin`,`source`,`contexttype`,`context`,`dependsontooltype`,`disableonguestsession`,`isfunctional`,`testmode`,`isentrycontrol`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator',1,0,'TDSAcc-Calculator',0,0,1,1,0,NULL,0,NOW(),'TDSCore_Staging_Configs_2013','TDSCore_Staging_Configs_2013','TEST','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','Language',0,1,'ALL',0);

INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_Calc0','None',0,0,'Calculator feature is disabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',-1,'TDSCore_Staging_Configs_2013','TDSCore_Staging_Configs_2013','TEST','ALL',NULL);
INSERT INTO `client_testtool` (`clientname`,`type`,`code`,`value`,`isdefault`,`allowcombine`,`valuedescription`,`context`,`sortorder`,`origin`,`source`,`contexttype`,`testmode`,`equivalentclientcode`)
VALUES ('[SBAC for production assessments, SBAC_PT for practice assessments]','Calculator','TDS_CalcSciInv&TDS_CalcGraphingInv&TDS_CalcRegress','ScientificInv&GraphingInv&Regressions',1,0,'Regressions Calculator is enabled','[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',0,'TDSCore_Staging_Configs_2013','TDSCore_Staging_Configs_2013','TEST','ALL',NULL);

INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ESN',1,'Calculator','TDS_CalcSciInv&TDS_CalcGraphingInv&TDS_CalcRegress','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',1,'Calculator','TDS_CalcSciInv&TDS_CalcGraphingInv&TDS_CalcRegress','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ENU',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');
INSERT INTO `client_tooldependencies` (`context`,`contexttype`,`iftype`,`ifvalue`,`isdefault`,`thentype`,`thenvalue`,`clientname`,`_key`,`testmode`)
VALUES ('[the value of the testid column from configs.tblsetofadminsubjects for the assessment]','TEST','Language','ESN',0,'Calculator','TDS_Calc0','[SBAC for production assessments, SBAC_PT for practice assessments]',UNHEX(REPLACE(UUID(), '-', ''),'ALL');

back to TDS Configuration Tasks

As of Fall 2018 the Smarter Balanced Test Delivery System (TDS) is no longer supported.

The code base and documentation for the TDS is available within the Smarter Balanced GitHub repository.

Creative Commons License Unless stated otherwise, all content on SmarterApp.org is licensed under a Creative Commons Attribution 4.0 International License.