meta data for this page
ACCUTRACK STUDENT DEMOGRAPHICS
Purpose: This section allows you to store profile/demographic information that can be used to query Student Groups in reports on the Center/Local Lab visit history in the system. Access: When you click on Student Demographics from the System Administration screen, you will see the following options:
- Profile Setup: Used to set up the profile questions and their values to assign to your student records.
- Student Profile: Used to view and assign profile values to your students.
- Profile Query: Used to run searches based on your various profiles and then report on, or create student groups with those searches.
Video Learning Series: Using Student Demographics
View video at: https://www.youtube.com/watch?v=1RKL8g_WfuQ
Purpose: Setup profile questions and answers to collect additional information for students.
Access: From System Administration > Student Demographics, click on Profile Setup.
When a new student signs-in, AccuSQL/AccuTrack will display the “New Student” screen used to collect contact information and demographic data. AccuSQL/AccuTrack gives you the flexibility to define up to 10 demographic questions on this screen. You can have students update their own profile values, you can assign them manually, and you can also import them.
Following is an explanation of the elements that comprise this screen:
The Question Navigator box allows you to select the question you want to set up. The Student screen has the capacity to show up to 10 profile questions. These questions are arranged in two columns, and each column has five questions. To select one of the questions, simply click on its position in the “Question Navigator” box. For example, to select the seventh question in the second column, simply click on it. The selected question will appear highlighted in a solid color.
Question Preview box
The “Question Preview” box shows how the selected question will appear on the Student screen. Use this box to preview the looks and format of the selected question.
This box allows you to edit the text of the selected question.
The Status Box allows you to define the status of the selected question. There are three options in this box:
- Show: Check this box if you want the question to be visible in the New Student screen. If you do not need this question, uncheck the Show box.
- Frame: Check this box if you want a frame or a border to appear around the question and the answer box.
- Answer Required: Check this box if you want force students to answer this question. When this box is checked, AccuSQL/AccuTrack will not allow the student to proceed with a sign in until an answer is selected from the drop-down box.
The font box allows you to define the appearance of the question:
- Opaque: Check this box if you want the question to have a colored background. Uncheck the box to use a transparent background.
- Border: Check this question if you want to have a border around the question
- Bold: Check this box to show the question in bold font.
- Italic: Check this box to show the question in italic font.
- Underline: Check this box to underline the question.
- Size: Use the drop-down box to select the size of the font.
The answers box shows the available answers for the selected question. You can use this box to add new answers or to edit or delete existing answers.
Modifying a Question
To change a question, simply select it in the Question Navigator then change the text in the “Question” box.
You can also change the status and appearance of the question. Click on “Save” to keep your changes.
For example, let’s say the first question is “College of“ (with the answers of “Business”, “Engineering”, “Art”, “Computer Science”, etc.) and a student is set to “Business” as the answer.
Then you change the question to read “Class” (with the answers of “Freshman”, “Sophomore”, “Grad Student”, etc.) Now the answer to this question for the student that had it set to “Business” needs this response updated to “Freshman”. This may not get updated if not corresponding with imported information and obviously is not the correct answer for this demographic on the student.
Entering the Answers to a Question
For each question you enter, you will need to define the answers that appear in the question’s drop-down list box. First select the question using the Question Navigator box, and then use the Answers box on the right side of the screen.
To add an answer, simply type it in the entry box and click on “Add”. To edit an answer, highlight the answer and click on “Edit”. The answer will be copied to the entry box. Make your changes and click on “Save” or “Cancel”. To delete an answer, highlight the answer then click on “Delete”.
For example, let’s say the first answer for the “Classification” question is “Grad Student” with other answers of “Freshman”, “Sophomore”, “Junior”, “Senior”, etc. Now you remove this “Grad Student” answer as an option. All the students that were marked this way will now display a blank or NULL result that were previously assigned this demographic.
Using Profile Fields for Local Labs
New for version 2015 and beyond of AccuSQL and AccuTrack, you can now create profile fields specifically for Local Labs. The sign in stations that have the local lab assignment you are creating the profile questions for will display the lab specific profile questions after the default questions are displayed. This section will show you an example of that functionality.
First, you need to click the Lab drop-down box and select the lab you are creating the profile for. In this case, I have a MATH lab. Once you change the lab, you will be able to create 10 more profile questions specific to the lab. In the following screen, 3 profile questions (and answers) have been setup specifically for the Math Lab:
Now in Student Demographics > Setup, the Lab would be selected and then to enable the profile update, the user would need to click the Update Profile On button.
And then the System > Lab ID should be set to the Math Lab.
Now when then student signs in, they will be presented with the 1-10 Profile Questions (depending on how many enabled in the Local Lab). In this case, they will be presented with the 3 profile questions specific to the Math Lab:
After the questions are answered and the student clicks Save, then he/she would go about the normal sign-in process.
Purpose: View and/or add profile values for students.
Access: From System Administration > Student Demographics, click on Student Profile.
Click on a Student Name to select the record, and then click Edit if you want to change any of the profile values for the student. Save when you are done. If you want to find a particular student in the list, you can click in the grid on either Student Name, or student ID and then begin typing either the last name or the student ID, depending on the column where you are typing.
If you would like to view or edit profile information for a specific lab, select the Lab from the drop-down box and the screen will show the profile fields specific to the selected lab. By default, the profile questions being displayed will be the ones for the current lab you are set to in System > Lab IDs > View/Modify Local Lab ID.
Purpose: To query the profile information.
Access: From System Administration, click on Student Demographics > Profile Query.
This screen shows the profile questions as you entered them in the Profile Setup screen. Each answer has a button with the caption “Set” next to it. Click on this button to set up the query. A selection menu will pop up showing the available selection for that question:
Start by selecting your filter for this question. Here are the available filters:
- One of the selected: Show students who selected one of the highlighted answers.
- NOT one of selected: Show students who did not select one of the highlighted answers.
- Empty: Show students who did not answer the question.
- NOT Empty: Show students that did answer the question.
- Whatever: Do not use this option for filtering data at all (show all regardless of how they answered the question).
If you use one of the first two options, use the mouse to select the answers you want from the answers list box on the right. To select more than one answer, hold the <Ctrl> key down and click on the answers. When done, click on the “OK” button. Do the same filtering on the other or combinations of questions as you like.
If you would like to query based on the profile fields for a specific lab, select it from the Lab drop-down box, and then use those values to build your query. By default, the profile query values being displayed will be the ones for the current lab you are set to in System > Lab IDs > View/Modify Local Lab ID.
The Profile Query screen has a reporting period selection box. If you use this box, the screen will only show the profile data of students who signed in during the selected period.
When you are done with setting up the profile query filters, you can run the query and view the results in one of the following formats:
Click on the “View” button to see the results of your query on the screen:
The list box at the left side of the screen lists the students that passed the filter(s). You can select any of these students by clicking on the name. When you select a student, the activities the student used will show up in the “Activity” list box on the right side of the screen. The box lists each activity, the number of visits, and total time. Under the two list boxes, you will see the profile questions and the answers selected by the highlighted student.
Click on the “Show Report” button to view students who meet your filter in a report. The report shows student’s name, sign-in ID, activity used, and number of visits and total time spent on that activity. The bottom of the report shows a count of the total visits and total time spent by all students that pass the filter.
Click on the “Export Data” button to send the data that meets your filter to an Excel file. You will see a browse window. Use this to select the location where you want to save the exported file and its name. Click on “Open” to proceed. AccuSQL/AccuTrack will save the file and will then ask you whether you want to see the file: If you click on “Yes”, AccuSQL/AccuTrack will launch MS Excel and will load the file. The exported file will have the following fields: Student’s name, sign-in ID, profile answers (P1 column is first Profile Question answer, and so on), activity (with the category between two square brackets ), the number of visits of that student to this activity, and the total time (in seconds).
Create a Student Group
Click on Create a Student Group to add the student returned from your query into group. Student Groups can be used in several places in AccuSQL/AccuTrack, including report filters. In the Specify a group name box, enter the name for the student group and then click OK. You will receive a message indicating the group is created. The group will consist of the students that were returned by your profile query and is viewable in the Users > Student Groups screen: