TracCloud: Students Listing: Difference between revisions
From Redrock Wiki
No edit summary |
No edit summary |
||
(24 intermediate revisions by the same user not shown) | |||
Line 1: | Line 1: | ||
{{TracCloudGuideTabs}} | {{TracCloudGuideTabs}} | ||
<div class="tcWidgetPage"> | |||
<div class="categoryWide"> | |||
{{TracCloudGuideListingsTOC}} | |||
</div> | |||
<big><b>Students Listing</b></big><br> | |||
Student data is one of the most important parts of your Trac System, on top of being the record that all their [[TracCloud:_Attendance_Listing|visits]], appointments, [[TracCloudGuideGlobalDocs|documents]], and more are assigned to, you also have the student's information directly. You can run reports on visits grouped by student majors, or send emails to students of a certain class, cohort, or any other field you have available. This article goes over some of the ways you can search for these records.<br><br> | |||
[[File:7254776.png|800px]]<br><br> | |||
The <b>Students Listing</b> itself (found by clicking 'Students' in the Navigation Bar) contains all student records uploaded to your Trac System. From this page, we're able to manage student data in bulk, creating lists, sending emails, or submitting SAGE referrals, or we can open a specific student record and manage just one student profile at a time. | |||
Each column of information displayed has a clickable header that will sort the listing accordingly. Clicking once sorts ascending, a second click will sort descending.<br><br> | |||
| | [[File:5615785.png|800px]]<br><br> | ||
Using the Search Bar on this screen, we can easily perform quick searches to find specific students. Right clicking in the search bar (shown below) will provide a list of available student fields to search, click any of these to auto-fill the search bar.<br><br> | |||
<div style="float: left; margin-right: 2em; margin-bottom: 1em"> | |||
[[File:4475592.png|300px]] | |||
</div> | |||
<b>Example Searches:</b> | |||
* Find a student by a single value, such as ID. Specifying 'Students.ID=' actually isn't required for ID or Name searches, but it works well as an example. | |||
:::<i>Students.ID=1931</i><br><br> | |||
* ...or name. Names should be formatted as 'Last, First' or 'First M Last'. 'First Last' will also work if middle names are not being imported. | |||
:::<i>Day, Rob</i><br><br> | |||
* Search multiple fields at once, separate your searches by a space. | |||
:::<i>Students.Major=Mathematics Students.Class=Sophomore</i><br><br> | |||
* When performing multiple searches where at least one field contains a space, make sure to surround the contents you're searching for with quotation marks. | |||
:::<i>Students.Major="Chemical Engineering" Students.Status=Active</i><br><br> | |||
* Search in Custom Fields. It's recommended to use the right-click menu to select these, as it will always auto-fill the correct field name. | |||
:::<i>#sql:InState#=Yes</i><br><br> | |||
* Date searches such as this are required to be formatted as YYYY-MM-DD | |||
:::<i>Students.BirthDate=1993-07-16</i><br><br> | |||
* We also offer a special search to find students where today is their birthday. | |||
:::<i>birthdaytoday</i><br><br> | |||
<hr> | |||
==Students Search== | |||
The Student Listing also has a unique Search utility found in the hamburger menu {{#fas:bars}}. This utility has the ability to search related tables to find relevant students. This includes the ability to run searches such as "students who have had appointments in the last 7 days" or "students who have ongoing referrals." | |||
[[File:2162434.png|700px]]<br><br> | |||
* <b>Search Type</b> | |||
::This can be set to <i>New Search</i>, <i>Search Selection</i>, <i>Remove found from Selection</i>, or <i>Add found to Selection</i>, depending on the desired effect of this search. | |||
* <b>General Info tab</b> | |||
::This tab is where you can search for basic information about the student. ID, Status, Name, etc. | |||
* <b>Appointments</b> | |||
::This tab allows you to search for students by appointment information. For example, "students who had an appointment from 02/10 to 02/20 with a status of <i>Missed</i>." | |||
* <b>Visits</b> | |||
::This tab allows you to search for students by [[TracCloud:_Attendance_Listing|visit info]]. For example, "students who visited more than 2 times from 02/10 to 02/20 where the subject was <i>MAT100</i>." | |||
* <b>Registration</b> | |||
::This tab allows you to search for students by [[TracCloudGuideListingsRegistrations|registration info]]. For example, "students who are actively enrolled in more than one math course." | |||
* <b>Documents</b> | |||
::This allows you to search for students by [[TracCloudGuideGlobalDocs|documents]]. "Students who have a document of a certain filename uploaded in the last month." | |||
* <b>Surveys</b> | |||
::Students who have received or responded to a survey in a certain time period. [[TracCloudST|Requires SurveyTrac.]] | |||
* <b>SAGE Referrals</b> | |||
::Students who have ongoing or completed referrals of a specific type in a specified date range. [[TracCloudSAGE|Requires SAGE.]] | |||
* <b>Resources</b> | |||
::This tab allows you to search for students by their [[TracCloudGuideBasicsResources|resource]] usage, whether they have certain items checked out or overdue. | |||
<hr> | |||
{{#lst:Template:TracCloudListingDescriptions|Hamburger_Menu}} | |||
{{#lst:Template:TracCloudListingDescriptions|List_All}} | |||
{{#lst:Template:TracCloudListingDescriptions|Search_Students}} | |||
{{#lst:Template:TracCloudListingDescriptions|Power_Search}} | |||
{{#lst:Template:TracCloudListingDescriptions|Search_by_Term_Enrollment}} | |||
{{#lst:Template:TracCloudListingDescriptions|Lists}} | |||
{{#lst:Template:TracCloudListingDescriptions|Saved_Searches}} | |||
{{#lst:Template:TracCloudListingDescriptions|FindMerge_Duplicates}} | |||
{{#lst:Template:TracCloudListingDescriptions|Find_by_Values}} | |||
{{#lst:Template:TracCloudListingDescriptions|Change_Field_Values}} | |||
{{#lst:Template:TracCloudListingDescriptions|Selected}} | |||
{{#lst:Template:TracCloudListingDescriptions|Views}} | |||
{{#lst:Template:TracCloudListingDescriptions|Send_Survey}} | |||
{{#lst:Template:TracCloudListingDescriptions|Register_In}} | |||
{{#lst:Template:TracCloudListingDescriptions|Assign_Success_Plan}} | |||
{{#lst:Template:TracCloudListingDescriptions|Create_Referral}} | |||
{{#lst:Template:TracCloudListingDescriptions|Create_Task}} | |||
{{#lst:Template:TracCloudListingDescriptions|Toggle_Photos}} | |||
{{#lst:Template:TracCloudListingDescriptions|Create_Chart}} | |||
{{#lst:Template:TracCloudListingDescriptions|Export_CSV}} | |||
{{#lst:Template:TracCloudListingDescriptions|Send_Email}} | |||
{{#lst:Template:TracCloudListingDescriptions|Send_Email_to_Faculty}} | |||
{{#lst:Template:TracCloudListingDescriptions|Show_these}} | |||
{{#lst:Template:TracCloudListingDescriptions|Print}} | |||
{{#lst:Template:TracCloudListingDescriptions|New_Record}} | |||
[[Category:TracCloud]] | |||
<HR> | |||
<i>See Also</i> | |||
* [[TracCloudTechImport|Importing Student Data]] | |||
* [[TracCloudGuideGlobalLists|Student Lists]] | |||
</div> |
Latest revision as of 15:55, 18 November 2024
Students Listing
Student data is one of the most important parts of your Trac System, on top of being the record that all their visits, appointments, documents, and more are assigned to, you also have the student's information directly. You can run reports on visits grouped by student majors, or send emails to students of a certain class, cohort, or any other field you have available. This article goes over some of the ways you can search for these records.
The Students Listing itself (found by clicking 'Students' in the Navigation Bar) contains all student records uploaded to your Trac System. From this page, we're able to manage student data in bulk, creating lists, sending emails, or submitting SAGE referrals, or we can open a specific student record and manage just one student profile at a time.
Each column of information displayed has a clickable header that will sort the listing accordingly. Clicking once sorts ascending, a second click will sort descending.
Using the Search Bar on this screen, we can easily perform quick searches to find specific students. Right clicking in the search bar (shown below) will provide a list of available student fields to search, click any of these to auto-fill the search bar.
Example Searches:
- Find a student by a single value, such as ID. Specifying 'Students.ID=' actually isn't required for ID or Name searches, but it works well as an example.
- Students.ID=1931
- Students.ID=1931
- ...or name. Names should be formatted as 'Last, First' or 'First M Last'. 'First Last' will also work if middle names are not being imported.
- Day, Rob
- Day, Rob
- Search multiple fields at once, separate your searches by a space.
- Students.Major=Mathematics Students.Class=Sophomore
- Students.Major=Mathematics Students.Class=Sophomore
- When performing multiple searches where at least one field contains a space, make sure to surround the contents you're searching for with quotation marks.
- Students.Major="Chemical Engineering" Students.Status=Active
- Students.Major="Chemical Engineering" Students.Status=Active
- Search in Custom Fields. It's recommended to use the right-click menu to select these, as it will always auto-fill the correct field name.
- #sql:InState#=Yes
- #sql:InState#=Yes
- Date searches such as this are required to be formatted as YYYY-MM-DD
- Students.BirthDate=1993-07-16
- Students.BirthDate=1993-07-16
- We also offer a special search to find students where today is their birthday.
- birthdaytoday
- birthdaytoday
Students Search
The Student Listing also has a unique Search utility found in the hamburger menu . This utility has the ability to search related tables to find relevant students. This includes the ability to run searches such as "students who have had appointments in the last 7 days" or "students who have ongoing referrals."
- Search Type
- This can be set to New Search, Search Selection, Remove found from Selection, or Add found to Selection, depending on the desired effect of this search.
- General Info tab
- This tab is where you can search for basic information about the student. ID, Status, Name, etc.
- Appointments
- This tab allows you to search for students by appointment information. For example, "students who had an appointment from 02/10 to 02/20 with a status of Missed."
- Visits
- This tab allows you to search for students by visit info. For example, "students who visited more than 2 times from 02/10 to 02/20 where the subject was MAT100."
- Registration
- This tab allows you to search for students by registration info. For example, "students who are actively enrolled in more than one math course."
- Documents
- This allows you to search for students by documents. "Students who have a document of a certain filename uploaded in the last month."
- Surveys
- Students who have received or responded to a survey in a certain time period. Requires SurveyTrac.
- SAGE Referrals
- Students who have ongoing or completed referrals of a specific type in a specified date range. Requires SAGE.
- Resources
- This tab allows you to search for students by their resource usage, whether they have certain items checked out or overdue.
Hamburger Menu
Every listing page in the Trac System features a hamburger menu with utilities to search for or interact with your list of records. Some of these options are specific to a certain listing/record-type, others are shared. The following list includes definitions for the hamburger menu options available on this listing, and how they can be utilized.
- List All
- This option will show all records on the current listing. Some listings have an additional toggle for only showing "Active" records, such as Students and Registrations, which will still override a "List All" search if checked.
- This option will show all records on the current listing. Some listings have an additional toggle for only showing "Active" records, such as Students and Registrations, which will still override a "List All" search if checked.
- Search
- This utility will open a pop-up window unique to each Listing it's present on, allowing you to search your records by a number of different fields. In the case of the Student Listing, you could use this to search related records, such as 'Students who have at least 2 Visits in the Learning Center' or 'Students with a recent Document upload in their timeline.'
- Power Search
- This option provides a simple but powerful search utility to find the records you need. String together multiple searches, adding or removing results for each. Use Search Symbols to include ranges of data, and Save Searches for later use if needed. The search term 'blankornull' can be used to find all records with a value of nothing ("") or null ().
- Search by Term Enrollment
- Lists
- See Student Lists and Watch Lists for more information.
- See Student Lists and Watch Lists for more information.
- Saved Searches
- See Saved Searches for more information.
- See Saved Searches for more information.
- Find/Merge Duplicates
- These utilities can be used to cleanup duplicate records in your Trac System. We highly recommend reaching out to Redrock Support directly for assistance in cleaning up this data.
- These utilities can be used to cleanup duplicate records in your Trac System. We highly recommend reaching out to Redrock Support directly for assistance in cleaning up this data.
- Find by Values
- Change Field Values
- This utility allows you to make modifications in to your records in bulk. Similar to the Merge Duplicates utility, we highly recommend coordinating with Redrock Support directly on this setting.
- This utility allows you to make modifications in to your records in bulk. Similar to the Merge Duplicates utility, we highly recommend coordinating with Redrock Support directly on this setting.
- Selected...
- The Selection Tool offers several options to filter and manage your records. More information on this feature can be found in its own dedicated article here.
- The Selection Tool offers several options to filter and manage your records. More information on this feature can be found in its own dedicated article here.
- Views
- See Views for more information.
- See Views for more information.
- Send Survey
- Allows you to send a survey to the current user list. More information.
- Allows you to send a survey to the current user list. More information.
- Register In
- Allows you to quickly enroll a student in a new registration. Depending on your import configuration, manually recreated registrations may be deactivated during your auto-import.
- Allows you to quickly enroll a student in a new registration. Depending on your import configuration, manually recreated registrations may be deactivated during your auto-import.
- Assign Success Plan
- Allows you to assign a new Success Plan to the current student list. More information.
- Allows you to assign a new Success Plan to the current student list. More information.
- Create Referral
- Allows you to create a batch referral through SAGE. More information.
- Allows you to create a batch referral through SAGE. More information.
- Create Task
- Allows you to send a task to the current student list. More information.
- Allows you to send a task to the current student list. More information.
- Toggle Photos
- Enable or disable student photos on the Student Listing.
- Enable or disable student photos on the Student Listing.
- Create Chart
- Based on the data currently being viewed a chart can be generated to visually illustrate the relationships in the data.
- Based on the data currently being viewed a chart can be generated to visually illustrate the relationships in the data.
- Export CSV
- Export current listing contents to a CSV file.
- Export current listing contents to a CSV file.
- Send Email
- Allows you to send an email directly to a list of users.
- Allows you to send an email directly to a list of users.
- Send Email to Faculty
- This email utility allows you to email faculty linked to student registrations. The faculty recipients can be determined by subject, status, and grade. One email will be sent per linked registration, so if there are 3 students listed enrolled in MAT100 with Dave Smith, Dave Smith will receive 3 emails. Faculty recipients can also be filtered by scheduled day/time if section schedule is being imported.
- Show these <records>
- This utility takes your selection of records, finds the related records, and takes you to that listing with the resulting records. For example, on the Registration listing, you can "Show these Students" to display the student records for the registrations that you were viewing.
- This utility takes your selection of records, finds the related records, and takes you to that listing with the resulting records. For example, on the Registration listing, you can "Show these Students" to display the student records for the registrations that you were viewing.
- Allows you to print the contents of the current listing, by extension this also allows you to export the current list as a PDF file.
- Allows you to print the contents of the current listing, by extension this also allows you to export the current list as a PDF file.
- New <Record>
- Allows you to create a new record based on your selected listing.
- Allows you to create a new record based on your selected listing.
See Also