How to Add an Illustration Glossary Accommodation

Overview

The Illustration Glossary provides the student with an image/drawing that describes a particular word or phrase. In some cases, the illustration will have an accompanying definition. The Illustration Glossary is displayed as a modal window that can have one or two tabs (one for the image, another for the definition). The image and definition are contained within the item’s content.

Creating an Illustration Glossary Accommodation

Illustration Glossary Creation Steps

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

Determine the testid of the assessment that should have a calculator assigned to it
Copy the SQL for the desired calculator into an editor
Replace the placeholders with appropriate values
Execute the SQL against your database

SQL For Creating an Illustration Glossary Accommodation


USE configs;

START TRANSACTION;
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]',
    'Illustration Glossary',
    1,
    1,
    'TDSAcc-ILG',
    0,
    0,
    1,
    1,
    0,
    NULL,
    0,
    NOW(),
    'configs_insert_ig_accommodation.sql',
    'configs_insert_ig_accommodation.sql',
    'TEST',
    '[the value of the testid column from configs.tblsetofadminsubjects for the assessment]',
    NULL,
    0,
    1,
    'ALL',
    0);
COMMIT;

START TRANSACTION;
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]',
    'Illustration Glossary',
    'TDS_ILG0',
    'Do not show Illustration Glossary',
    1,
    0,
    'Do not show Illustration Glossary',
    '[the value of the testid column from configs.tblsetofadminsubjects]',
    -1,
    'configs_insert_ig_accommodation.sql',
    'configs_insert_ig_accommodation.sql',
    'TEST',
    'ALL',
    NULL),
(
    '[SBAC for production assessments, SBAC_PT for practice assessments]',
    'Illustration Glossary',
    'TDS_ILG1',
    'Show Illustration Glossary',
    0,
    0,
    'Show Illustration Glossary',
    '[the value of the testid column from configs.tblsetofadminsubjects]',
    1,
    'configs_insert_ig_accommodation.sql',
    'configs_insert_ig_accommodation.sql',
    'TEST',
    'ALL',
    NULL);
COMMIT;

START TRANSACTION;
INSERT INTO tds_coremessageobject(
    context,
    contexttype,
    messageid,
    ownerapp,
    appkey,
    message,
    fromclient
)
SELECT
    'testshell.aspx',
    'ClientSide',
    IFNULL(MAX(messageid), 0) + 1,
    'Student',
    'TDS.WordList.illustration',
    'Illustration',
    'AIR'
FROM
    tds_coremessageobject;
COMMIT;

START TRANSACTION;
INSERT INTO tds_coremessageuser(
    _fk_coremessageobject,
    systemid)
SELECT
    MAX(_key),
    'Student'
FROM
    tds_coremessageobject;
COMMIT;

-- needed in order to reset/recalc all the messages
START TRANSACTION;
DELETE FROM __appmessages;
DELETE FROM __appmessagecontexts;
COMMIT;

back to TDS Configuration Tasks