Filtering Data in GuideK12

Whether you’re using Explorer, Planner, or Adviser you have the capability to filter or select data stream records.  There are two types of filtering that can be done in GuideK12; attribute filtering and spatial filtering.  Let’s explore each type. Attribute Filtering:  Attribute filtering allows you to filter or select records based on characteristics associated to […]

Visualizing Students and Using Layers

The Overlay section controls the layers, labels and various content on the map. Understanding the power of layers is important to unleash the power of GuideK12. Managing the visualization of the students on the map: Click on the Green Overlays button on the right-hand side of the screen. At the bottom of the drop-down menu […]

Using the Spatial Filter in Adviser

In the Optional Filter section is a button called spatial.  The spatial filter allows the user to move from a chart or graph of any sort into a map showing the geographies of the data represented in the charts and graphs.  The spatial filter button is a toggle.  Clicking once turns it on and clicking […]

Creating a Thematic Map

A thematic map shows areas of concentration – high or low.  The darker the color the higher the concentration of any selected characteristic by geography.  The first step is to choose the geography or Region for the map.   The Region can be selected based on enrollment or home address.  The Vintage can be selected next. […]

Options for creating a pie chart

Select the data to analyze in the slices area, selecting characteristics from the drop down.    The vintage area provides the option to select what year, month or scenario the data is coming from.  Output Options allow you to view the data by quantity or percentage.   Additional Filtering can be done in the filters area.  […]

Exporting Graphs for a Presentation

On the upper left hand corner of the screen is an Analysis section.  The bottom row has three buttons. The middle button is an Export Key that will provide the options to export the data or the images. Click Bar chart graphic to embed the graphs into a Powerpoint or other presentation software.    

Working with Optional Filters

After you have selected the Series and/or Group data to analyze, further refinement can happen with optional filters.  Select the pencil icon to reveal a drop down of options.  Select the characteristic and then click Finish.  The clipboard shows what filter settings have been selected.  

Grouping Data

To further define your analysis for a bar or line chart, group data by any number of characteristics.  Once you have selected your Series Data, then select Group and select the characteristic from the drop-down menu to group the data.  For example, if your Series is “Special Education” data and then you group by “Gender” […]

Analyzing Multiple Years – Longitudinal Data

Select Vintage in the “Series” menu.  Next, choose the vintage desired – school years, monthly or scenarios.  Any scenarios you have created in Planner will appear in this listing, allowing a comparison by year against a specific Planner Scenario.  If you need school years loaded, contact the customer experience team.  To select a specific school […]

Selecting the Series Data

If using a bar chart or line chart, the first step is to determine what data you want to analyze.  Select the primary data set to analyze in the series drop down. An image will appear in the visualization area once a series has been selected. This may answer the question or further analysis can […]