Why Selection Sets?
There Oughta Be A Selection Set for That!
Brenda Hicks Southwestern College 4 Year Private
Agenda •
Why Selection Sets?
•
Sprechen Sie Boolean
•
Reference Tools
•
Let’s Write!
•
Get Organized
Why Selection Sets? •
From the PowerFAIDS User Guide: •
Retrieve and view records
•
Require and apply tracking documents
•
Assigning budgets
•
Packaging aid awards
•
Generating reports
•
Batch processes (letters, posting, fund disbursement, loan/pell processing, AND MORE)
Sprechen Sie Boolean?
P Q
P AND Q
F
F
F
F
T
F
T
F
F
T
T
T
P Q
P OR Q
F
F
F
F
T
T
T
F
T
T
T
T
P
Not P
F
T
T
F
Reference Tools •
PowerFAIDS Conference Archive •
“Selection Sets – The Basics” by Malina Chang
•
“PowerFAIDS Fundamentals I – Selection Sets and the Data Dictionary” by Kevin Jensen
•
“Developing Selection Sets that Work” by Mary Beth Sommers
•
PowerFAIDS User Guide, Chapter 6: Queries: Selection Sets and Advanced Search
•
Constructing Selection Sets – Online Training 7/28/2014
Let’s Write! The Scene:
Slippery Rock College has been asked by it’s auditor to produce a list of students who were selected for verification in the previous fiscal year.
Step 1: Gather Your Ingredients What fields in the student record contain the data I need? •
Mnemonics
•
Data Dictionary
Step 2: Write the Instructions
Step 2a: One-to-Many
Step 3: Test and Problem Solve
Get Organized
Session Evaluation Using the Session Number, please complete the session evaluation by: 1.
Scanning the QR code and submitting the online evaluation:
2.
Submitting the online evaluation at: https://www.surveymonkey.com/s/2014PFConf Session
3.
Returning the paper evaluation
Trademarks College Board, CSS/Financial Aid PROFILE, INAS, PowerFAIDS and the acorn logo are registered trademarks of the College Board. inspiring minds is a trademark owned by the College Board. Microsoft, Windows, Windows Server, Word, Excel, and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names may be trademarks of their respective owners. Screen shot(s) reprinted by permission from Microsoft Corporation. Copyright © 2014 by The College Board. All rights reserved. The College Board has prepared this document for use only by personnel, licensees, and customers. The information contained herein is protected by copyright. No part of this document may be reproduced, translated, or transmitted in any form or by any means, electronically or mechanically, without prior written permission from the College Board. THE COLLEGE BOARD SHALL NOT BE LIABLE FOR TECHNICAL OR EDITORIAL ERRORS OR OMISSIONS CONTAINED HEREIN; NOR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. This publication contains material related to the Federal Title IV student aid programs. While we believe that the information contained herein is accurate and factual, this publication has not been reviewed or approved by the U.S. Department of Education. The College Board reserves the right to revise this document and/or change product features or specifications without advance notice.
Brenda Hicks Southwestern College 4 Year Private
Agenda •
Why Selection Sets?
•
Sprechen Sie Boolean
•
Reference Tools
•
Let’s Write!
•
Get Organized
Why Selection Sets? •
From the PowerFAIDS User Guide: •
Retrieve and view records
•
Require and apply tracking documents
•
Assigning budgets
•
Packaging aid awards
•
Generating reports
•
Batch processes (letters, posting, fund disbursement, loan/pell processing, AND MORE)
Sprechen Sie Boolean?
P Q
P AND Q
F
F
F
F
T
F
T
F
F
T
T
T
P Q
P OR Q
F
F
F
F
T
T
T
F
T
T
T
T
P
Not P
F
T
T
F
Reference Tools •
PowerFAIDS Conference Archive •
“Selection Sets – The Basics” by Malina Chang
•
“PowerFAIDS Fundamentals I – Selection Sets and the Data Dictionary” by Kevin Jensen
•
“Developing Selection Sets that Work” by Mary Beth Sommers
•
PowerFAIDS User Guide, Chapter 6: Queries: Selection Sets and Advanced Search
•
Constructing Selection Sets – Online Training 7/28/2014
Let’s Write! The Scene:
Slippery Rock College has been asked by it’s auditor to produce a list of students who were selected for verification in the previous fiscal year.
Step 1: Gather Your Ingredients What fields in the student record contain the data I need? •
Mnemonics
•
Data Dictionary
Step 2: Write the Instructions
Step 2a: One-to-Many
Step 3: Test and Problem Solve
Get Organized
Session Evaluation Using the Session Number, please complete the session evaluation by: 1.
Scanning the QR code and submitting the online evaluation:
2.
Submitting the online evaluation at: https://www.surveymonkey.com/s/2014PFConf Session
3.
Returning the paper evaluation
Trademarks College Board, CSS/Financial Aid PROFILE, INAS, PowerFAIDS and the acorn logo are registered trademarks of the College Board. inspiring minds is a trademark owned by the College Board. Microsoft, Windows, Windows Server, Word, Excel, and SQL Server are either registered trademarks or trademarks of Microsoft Corporation in the United States and/or other countries. All other company and product names may be trademarks of their respective owners. Screen shot(s) reprinted by permission from Microsoft Corporation. Copyright © 2014 by The College Board. All rights reserved. The College Board has prepared this document for use only by personnel, licensees, and customers. The information contained herein is protected by copyright. No part of this document may be reproduced, translated, or transmitted in any form or by any means, electronically or mechanically, without prior written permission from the College Board. THE COLLEGE BOARD SHALL NOT BE LIABLE FOR TECHNICAL OR EDITORIAL ERRORS OR OMISSIONS CONTAINED HEREIN; NOR FOR INCIDENTAL OR CONSEQUENTIAL DAMAGES RESULTING FROM THE FURNISHING, PERFORMANCE, OR USE OF THIS MATERIAL. This publication contains material related to the Federal Title IV student aid programs. While we believe that the information contained herein is accurate and factual, this publication has not been reviewed or approved by the U.S. Department of Education. The College Board reserves the right to revise this document and/or change product features or specifications without advance notice.
