Skip to main content

Aspen - Did You Know..."Fieldsets: The Ultimate Power"

Aspen - Did You Know About Aspen's Field Sets Opiton? Or As I like to say, "Field Sets: Seeing the Data the Way YOU Want to See It!"

I thought I would use this space to provide additional information about some of the powerful, less well known features of Aspen, our SIS, from Follett School Solutions. One of the hidden gems that I use all of the time, but few people change is the "Field Sets" tool. This tool allows you to organize your data in a manner that makes sense to you, and meets your needs. It's really the tool that allows the end user to see the data in a spreadsheet view that makes the most sense for the specific job at hand. Field sets used in conjunction with queries, and quick charts are a powerful trio that will allow you to get a lot of use from Aspen.

Users can find the Field Sets Menu tool whenever the access any of the data tables in Aspen. Once you click on a table heading (commonly known as a top tab in "Aspenspeak") several options become available, and the field set menu is bundled with a group of tools located in the far, right-hand corner of your browser window, and is depicted in the screen capture below.


Clicking field set option will allow you access to multiple options. You will be able to select from existing field sets (many of these options may have already been created by district staff and shared with everyone in the organization) or manage your field sets. Selecting between the existing field sets will just change your present view to the selected view. This option allows you to make quick changes in how your data is displayed from saved view (or field set) options. 

If you choose the manage field set option you will be able to show/hide, create, edit, copy or delete existing field sets. You will only be able to edit or delete field sets that you own or have access rights to for editing or deletion purposes. Some field sets are system or district field sets, and you won't be able to edit or delete. However you can copy the field set, and then make changes to it to suit your purposes.

The main purpose of using field sets is that the end user can determine exactly how much or how little data they want to view in a particular field set. Depending on the purpose for viewing the data the end user may want to include vast amounts of data displayed in columns according to each field in the database tables, or very specific sets of data that is uncluttered by other fields or columns. In the image below I just wanted to view data concerning our student's Grade Point Average (GPA) and their class ranking. I created a field set that is uncluttered, and contains 5 fields from the student table.

Student Ranking & GPA Data
The illustration above depicts the concept that the end user gets to decide how much or how little data is displayed in a field set. Sometimes it is helpful to have a lot of data for analysis purposes, and sometimes it's helpful to have limited amounts of data, because you just want to create a list of students that meet a specific criteria. In the illustration depicted I wanted an ordered list of students by class rank with their GPA that could be easily shared with the appropriate adults in our organization. 

To create this list I did the following:
  1. Click on the Field Set Icon, and select manage field set. 
  2. Select the Field Set You would like to edit (GPA and Rank), and click the edit button. 
  3. Add and remove fields from the tables listed. The fields that are selected will determine what is displayed in the field set (or the spreadsheet) view.
  4. Click the Save button once you've made all of your changes to your field set. Remember you can always go back and edit an existing field set if you still need to make changes.


I am positive that once you learn how to use this simple, but powerful tool in Aspen you will find countless ways to use it to help analyze the data concerning your students. When you couple this tool with the ability to query the various data sets in Aspen you have a very powerful tool at your disposal. Use the comment tool in Blogger to let me know if you have any questions or requests about what I should write about in my next installation of "Aspen- Did You Know..."

Labels:

Comments

Post a Comment

Popular posts from this blog

Use Your Chromebook to Make Phone Calls

Use Your Chomebook to Make Phone Calls Since the district has moved over to a new phone system many of our classrooms no longer have the ability to dial an outside line. One way to get around this problem is to use your Chromebook to make a phone call. You can access Google Voice through your gmail account, or use Google Hangouts to make a call. There are several ways to initiate a phone call. Follow these simple directions to place your call. Click on Google Hangouts or Google Voice Simply click on either the Google Hangouts icon, or the Google Voice icon once you've accessed your gmail account. If you haven't setup your Google+ account you will have less features when using the Google Hangouts option. If you click on the Google Voice option you can simply type in the phone number that you want to call, or search for a number in your contacts. Phone calls made in the United States are free, and you can add money to your Google Voice account for international cal
8 comments
Read more

How to Check if your Chromebooks is a Managed Machine...

Is Your Chromebook a Managed Machine? Enrolled Devices: As we get closer to PARCC testing it is important insure that your Chromebook is enrolled in our domain. Enrolling the device in the domain insures that you will have the  appropriate Test Nav application on your device.  It is possible that some of the devices in your classroom didn't get properly enrolled. Review this blog to learn how to check whether or not your students' machine is enrolled properly. Check Your Device Settings: Check your settings by clicking on the Settings Taskbar on your Chromebook. Once you click on the settings tool bar you will be able to discover whether or not the Chromebook is managed. The picture below shows an unmanaged machine. The video below shows you how to check the tool bar settings. The picture below shows a managed machine. The video below shows you what the settings look like on a managed machine. Is Chrome OS Up to Date? It is al
3 comments
Read more

Using Aspen for Staff Attendance

How to Use Aspen for Staff Attendance & Substitute Replacement The West Warwick Public Schools partnered with Follett many years ago to use the power of Aspen for staff attendance and substitute replacement. We have three different workflows that staff members use for attendance and replacement purposes. Each one of the workflows will be explained below. How to Fill-out the Staff Absence Request Workflow in Aspen If a WWPS employee is going to be out for any reason that doesn't require approval they fill-out the Staff Absence Request Workflow. Sick, personal, bereavement, family illness, district sanctioned professional development, IEP meetings, and religious days are all examples of absences that do not need administrative approval. Staff members simply need to fill-out the Staff Absence Request Workflow. View the directions below for the one-step process. Once a staff member completes the Staff Absence Request Workflow an attendance record is created that al
1 comment
Read more