WebKIDSS Variables Overview
40 Questions
0 Views

Choose a study mode

Play Quiz
Study Flashcards
Spaced Repetition
Chat to lesson

Podcast

Play an AI-generated podcast conversation about this lesson

Questions and Answers

What is the primary purpose of Alphanumeric/String variables in WebKIDSS?

  • To display a single line of information such as names or phone numbers (correct)
  • To capture numerical data only
  • To allow multiple options to be selected
  • To store a True/False response

    • Which variable type would be most suitable for capturing a student's active status?

  • Checkbox
  • Number
  • Dropdown List
  • Boolean (correct)

    • If you want to allow the user to select only one item from a list of options, which variable type should you use?

  • Dropdown List (correct)
  • Multiple Select List
  • Multiple Checkboxes
  • Radio Button (correct)

    • What is a limitation of using Alphanumeric/String variables in WebKIDSS?

    <p>They are not suitable for date formats</p> Signup and view all the answers

    Which variable type allows for a list of items where users can select one or more options?

    <p>Multiple Select List</p> Signup and view all the answers

    What is the maximum number of digits allowed for Number variable types in WebKIDSS?

    <p>10 digits</p> Signup and view all the answers

    Which variable type is best suited for capturing a phone number?

    <p>Alphanumeric/String</p> Signup and view all the answers

    What format does the Date variable type utilize for storing dates?

    <p>DD/MM/YYYY</p> Signup and view all the answers

    What is the purpose of the Procedural Dates Report?

    <p>To list various due dates related to student evaluations</p> Signup and view all the answers

    Which of the following is NOT classified as a kind of variable in WebKIDSS?

    <p>Teacher Enterable</p> Signup and view all the answers

    What type of variable would you use to define custom data specific to an IEP?

    <p>Student Form</p> Signup and view all the answers

    Which report would you use to check for students with IEPs that are overdue?

    <p>Overdue IEPs</p> Signup and view all the answers

    What type of data is included in the calculated variables category in WebKIDSS?

    <p>Age this IEP</p> Signup and view all the answers

    Which of the following reports is designed for teachers and their rosters?

    <p>Teacher Rosters/Non-Duplicated Teacher Rosters</p> Signup and view all the answers

    What is a key feature of the Blank/Duplicate KIDS IDs report?

    <p>It identifies students without a valid KIDS ID.</p> Signup and view all the answers

    What is one potential use of the GAP Report?

    <p>To find students not receiving full-time services</p> Signup and view all the answers

    What should you do to specify the Sort Order for the report?

    <p>Select a variable and click 'Add One'.</p> Signup and view all the answers

    What is the purpose of selecting 'Break on 1st Sort Field'?

    <p>To generate multiple pages based on sort criteria.</p> Signup and view all the answers

    What appears only once in the report?

    <p>The header row for the report.</p> Signup and view all the answers

    Which option must be selected to include a page break based on the sorting order?

    <p>Page Break on 1st Sort Field.</p> Signup and view all the answers

    What is the recommended action after entering the body for the report?

    <p>Enter the footer for the report.</p> Signup and view all the answers

    In the Custom Transportation Service Example, how is the report sorted?

    <p>By LEA, then building, then provider.</p> Signup and view all the answers

    What step follows after creating a new form in the process?

    <p>Check the 'Use' option.</p> Signup and view all the answers

    What happens if you do not check the 'break on...' boxes?

    <p>You will generate a single list without breaks.</p> Signup and view all the answers

    What is the first step to create a Medicaid Student List Type 2 form?

    <p>Choose 'Edit Forms' from the Main Menu</p> Signup and view all the answers

    Which variable should be included in the Form Body of the Medicaid List Type 2 form?

    <p>Provider Name</p> Signup and view all the answers

    When selecting variables to sort in the Medicaid List Type 2 form, which of the following is mentioned as an option to add?

    <p>Med-Log Delivery Date</p> Signup and view all the answers

    What action should be taken after entering data in the Footer section of the form?

    <p>Click the 'Save' Button</p> Signup and view all the answers

    What is the purpose of selecting 'Find Students-Find on Fields' in the Medicaid section?

    <p>To filter students based on submission dates</p> Signup and view all the answers

    In the context of building the Medicaid Student List Type 2 form, what should you do after entering a form name?

    <p>Verify that the 'Use' checkbox is marked</p> Signup and view all the answers

    What is the appropriate operator to select for filtering students based on the submitted date?

    <p>is greater than or equal to</p> Signup and view all the answers

    What is the last step mentioned in creating the Medicaid Student List Type 2 form?

    <p>Click 'Done'</p> Signup and view all the answers

    What is the purpose of adding the absolute indicators ($) in the modified VLOOKUP formula?

    <p>To prevent the search field from shifting when copying to other cells.</p> Signup and view all the answers

    What will the modified VLOOKUP formula return if a KIDS ID number is not found in the search area?

    <p>#N/A error indicating no match found.</p> Signup and view all the answers

    What does the ISNA function accomplish in the nested formula?

    <p>It identifies if the VLOOKUP results in an #N/A value.</p> Signup and view all the answers

    What output does column G produce based on the modified formula?

    <p>Indicates whether a KIDS ID is matched or unmatched.</p> Signup and view all the answers

    Why can FTE not be accurately calculated for the current school year?

    <p>Not all Individualized Education Programs (IEPs) are completed.</p> Signup and view all the answers

    What data should be included when completing a service line export for last year's FTE calculation?

    <p>Active and inactive students from both Archived and non-Archived sets.</p> Signup and view all the answers

    Which of the following best describes the modified VLOOKUP formula?

    <p>A lookup that remains constant even when copied across rows.</p> Signup and view all the answers

    What does the formula =IF(modified_column_f_formula, 'No', 'Yes') signify?

    <p>It identifies whether a student is included in the SpedPRO list.</p> Signup and view all the answers

    Study Notes

    WebKIDSS Variables

    • There are 11 different types of variables in WebKIDSS
    • Alphanumeric/String variables are for text entries up to 150 characters and used for names, phone numbers, etc.
    • Boolean variables are True/False responses, used to indicate Active/Inactive status, for example.
    • Checkbox variable is a single checkbox with the value "Yes" if checked.
    • Date variables store a date in DD/MM/YYYY format.
    • Dropdown List allows for selection from a predefined list of up to 20 items.
    • Multiple Checkboxes presents a list of up to 20 items where users can select one or more.
    • Multiple Select List presents a list of up to 100 items where users can select one or more.
    • Number variables allow for entering numerical data only, including whole numbers, partial numbers, and negative numbers up to 10 digits.
    • Radio Button variables allow for selecting one option from a list of up to 20.
    • Time variables capture data in HH:MM AM/PM format.
    • Built In Print Lists are accessible from the Main Menu under the Medicaid section and allow different types of reports to be generated.

    Variable Kinds

    • There are 8 kinds of variables in WebKIDSS
    • Student Predefined variables are defined by the WebKIDSS program and are located in the IEP:, Goal:, B/O:, Serv:, and Stu: sections of the variable lists.
    • Student Form variables are created by the user/agency and are identified by the Form: section of the variable lists.
    • Student Agency Predefined variables are created by the Agency for use on the Demographics Screen or on a Custom Agency Predefined Variable Screen.
    • Preferences Predefined variables are controlled by the Preferences section of WebKIDSS and contain information like Agency Address and Agency Name. They are located in the Pref: section of the variable lists.
    • Business Form variables are Agency created variables used only in Business Forms.
    • Business Agency Predefined variables are created by the Agency and utilized within the User Profile.
    • Medicaid Predefined variables are created by the WebKIDSS program and utilized within the Medicaid portion of WebKIDSS.
    • Medicaid Form variables are created by an Agency for use when creating Medicaid forms.

    Generating Reports

    • CSSF Modifications Example describes how to create a new form for a report.
    • Custom Transportation Service Example provides steps for creating a form to generate a report on transportation services sorted by LEA, building, and provider.
    • To generate a report, navigate to the "Edit Forms" option, create a new form, and choose "Student List Print Form - Type 2".
    • To include data in the report, double-click the variable from the list provided above the Body box.
    • The "Form Header" defines the header row appearing once, while "Form Body" contains information that repeats for each student.
    • Define a Sort Order by selecting variables and clicking "Add One."
    • Save the form and click "Done."

    Generating a Medicaid Report

    • To generate a Medicaid report, select "Medicaid List Print Form - Type 2" under "Edit Forms"
    • Enter a form name, verify the "Use" checkbox is marked, and enter the header information.
    • In the "Form Body," select variables from the list by double-clicking them.
    • Save the form and choose variables for sorting.
    • Click "Save" and "Done."
    • From the Main Menu, navigate to the Medicaid section, choose "Print a Medicaid List Form," and then "Find Students - Find on Fields."
    • Under "Field," locate "Med-SerLog: Med-Log Submitted Date (D)."
    • Choose "is greater than or equal to" in the Operator dropdown.

    Modifying Formulas

    • The formulas within WebKIDSS can be modified to include absolute references using the dollar sign ($) to prevent the search field from changing when copying the formula to other rows.
    • For example, =VLOOKUP(A2,'LIST #2 SpedPRO'!$C$2:$F$18,1,FALSE) uses absolute references for $C$2:$F$18
    • The formula =ISNA(VLOOKUP(A2,'LIST #2 SpedPRO'!$C$2:$F$18,1,FALSE)) can be used to check for errors in the VLOOKUP formula.
    • The formula =IF (modified_column_f_formula, "No", "Yes") returns "No" if the VLOOKUP formula returns an #N/A error and "Yes" otherwise.

    Calculating FTE

    • FTE (Full-Time Equivalent) is not fully calculated until the end of the school year.
    • To calculate FTE for previous years, export a service line report including all active and inactive students.

    Studying That Suits You

    Use AI to generate personalized quizzes and flashcards to suit your learning preferences.

    Quiz Team

    Related Documents

    Data Workshop FY23.pdf

    Description

    Explore the 11 different types of variables used in WebKIDSS. This quiz covers essential concepts including alphanumeric, boolean, and date variables, as well as dropdowns and checkboxes. Test your knowledge and understanding of these variable types and their applications.

    Use Quizgecko on...
    Browser
    Open
    Browser
    Browser