# Presentation: 430436

## <footer>

- <date/time>

## Session 10

***Queries: Powerful and flexible tools that anyone can use.***

- Session 10-

**Notes:**
This session should be used with the provided database.  This database is a 6.3 database, and it contains ISIR records for 50 “dummy” students.  The user ID and password are both EAC.  The SYSADMIN password is also EAC.

## Queries Hands-On

- Who is this session geared for?
- Beginners
- Evaluations
- Questions
- Feel free to ask questions throughout the session.
- There will be time at the end for individual help.

- Session 10-

**Notes:**
The query function within EDExpress allows great flexibility for identifying records for printing and exporting.  Queries are available in all modules of EDExpress, and this session will focus on how to use the query function within each module to get the information you need in the form you need it.  This session will discuss pre-defined queries and walk users through creating their own queries.

## What is a query?

- A request for information from a database
*“**A query is a set of criteria that describes a particular student population. Queries are used in functions like Print, Package, and Export to select specific groups of student records from all the records in the database. Some queries have fixed values, or you can enter different values each time you use the query.” **	**	**	**	**	**	**	**EDExpress Help Text*

- Session 10-

## Session Overview

- Using predefined queries
- Creating your own queries
- Modifying existing queries
- The power of queries

- Session 10-

## Predefined QueriesHANDS ON

- Predefined queries in EDExpress

- Session 10-

**Notes:**
Have users go to Tools|Query, select the App Express tab (should be selected by default).  Click on the “Retrieve” button to review the predefined queries that are available.  May also have group look at the queries available in other modules.

## Predefined QueriesHANDS ON

- Printing List-Processed ISIRs using predefined query
- File|Print

- Session 10-

**Notes:**
Walk user through printing list-processed ISIRs using “selected for verification” criteria.

## Select report type “List-Processed ISIRs
Select destination “Screen”
Click on the Selection Criteria button

- Select destination “Screen”
- Click on the Selection Criteria button

- Session 10-

## Click on the ellipsis button

- Session 10-

## Choose the desired query

- Session 10-

## Notice that the name of the selected query fills the “Query Title” field
Click OK

- Click OK

- Session 10-

## Returns to the Print screen
Click OK

- Click OK

- Session 10-

## Slide 13

- Session 10-

## Creating your own query...

- Step 1: Decide what you want to query
**BE SPECIFIC**

**(Independent **_**and**_** EFC < 2500) **
_**or**_** (is Orphan)**

**Ind**

**EFC < 2500**

**Orphan**

- Session 10-

**Notes:**
You can’t get what you want until you know what you want.  :)

## Basic Query Rules

- Queries process left to right, AND before OR
- Parenthesis change the order of precedence
- (1+3) ÷ 2 = 2   	1 + (3 ÷ 2) = 2.5
- Difference between AND and OR

- Session 10-

**Notes:**
Sounds a lot like Algebra.

## Creating a QueryHANDS ON

- Query to find Auto Zero EFC students

- Session 10-

**Notes:**
Walk group through creating these queries.  Touch on the following points:
Prompt at execution--when it is appropriate/useful
Use operator “LIKE” for comment codes

## Slide 17

- Session 10-

## Creating a QueryHANDS ON

- Query to find Auto Zero EFC students
- Query to find students who are
- Independent AND
- EFC < 2500 AND
- Comment Code 053 (left “Drug Eligibility Question” blank

- Session 10-

**Notes:**
Walk group through creating these queries.  Touch on the following points:
Prompt at execution--when it is appropriate/useful
Use operator “LIKE” for comment codes

## Slide 19

- Session 10-

## Modifying Existing Query HANDS ON

- Modify C CODE query to choose students by dependency status

- Session 10-

**Notes:**
Modify sometimes referred to as “save-as” feature

## Change the title

- Session 10-

## Choose “Field” DEPENDENCY STATUS
Set “Operator” to =
Check “Prompt at Execution”

- Set “Operator” to =
- Check “Prompt at Execution”

- Session 10-

## Slide 23

- Session 10-

## Slide 24

- Session 10-

## Modifying Existing Query HANDS ON

- Modify C FLAG query to choose students by dependency status
- You can also modify user-defined queries

- Session 10-

**Notes:**
Modify sometimes referred to as “save-as” feature

## The Power of Using Queries

- Printing Reports
- Multiple Entry

- Session 10-

**Notes:**
Printing reports--we’ve already seen this example.
Multiple entry--talk about when this might be useful, like origination entry
Exporting with selection criteria is a seldom used option
If time, demonstrate for group creating a quick file format, exporting data using a query, and open the file in Excel.
If a school uses User Data, these fields are added into the fields available for queries.

## The Power of Using Queries

- Printing Reports
- Multiple Entry
- Exporting EAPS and CORR

- Session 10-

**Notes:**
Printing reports--we’ve already seen this example.
Multiple entry--talk about when this might be useful, like origination entry
Exporting with selection criteria is a seldom used option
If time, demonstrate for group creating a quick file format, exporting data using a query, and open the file in Excel.
If a school uses User Data, these fields are added into the fields available for queries.

## The Power of Using Queries

- Printing Reports
- Multiple Entry
- Exporting EAPS and CORR
- User Database fields
- Queries in combination with File Formats

- Session 10-

**Notes:**
Printing reports--we’ve already seen this example.
Multiple entry--talk about when this might be useful, like origination entry
Exporting with selection criteria is a seldom used option
If time, demonstrate for group creating a quick file format, exporting data using a query, and open the file in Excel.
If a school uses User Data, these fields are added into the fields available for queries.

## Slide 29

- Session 10-

## Slide 30

- Session 10-

## Slide 31

- Session 10-

## Session Review

- Using predefined queries
- Creating your own queries
- Modifying existing queries
- The power of queries

- Session 10-

## Further Assistance

- We appreciate your feedback and comments.
**CPS Customer Service**
- Phone: (800) 330-5947
- Fax: (319) 358-4260
- Email: <cps@ncs.com>
- TDD/TTY: (800) 511-5806
**SFATECH**
- http://www.ed.gov/offices/OSFAP/sfatech/index.html

- Session 10-

## Questions?

- Individual assistance available for remainder of this session.
- Visit the PC lab for more individual assistance.

- Session 10-

**Notes:**
First, see if there are questions of a general nature that it would beneifit the group to discuss.

 After this slide, go to next slide to show the CPS contact information.  Then make yourself available to individuals with questions.

## Slide 35