Penn Computing

Penn Computing

Computing Menu Computing A-Z
Computing Home Information Systems & Computing Penn

 
  UPDATES
Current Load Status
Regular Availability
 
  INFORMATION
FAQs & Tips
Password Changer
Support services
Security
About the Data Warehouse
Data Administration
 
  DATA COLLECTIONS
Advancement
Assets
BBR
BRIM
Express Mail
Facilities
Faculty
GAR
General Ledger
Infrastructure
ISSS-iOffice
Learning Management
Position Inventory
Research-PennERA Proposals
Research Inventory
Salary Management
Student
Travel Expense Management
Tuition Distribution
World Travel
Cross-Collection

This lesson should take about 40 minutes to complete. After completing this lesson, you should be able to identify at least five methods you can use to determine whether your query results are correct.

Lesson 5. Evaluating Query Results

· prerequisites  · using this tutorial  · data training

Activity 1

Read the document "Verifying Query Results" and then complete Activity 2. (After completing the reading, use your browser's back to return to this lesson.)

Activity 2

After reading "Verifying Query Results," please answer the following questions:

  1. To help you evaluate query results, what can you ask the person who requested the report?
  2. What is the advantage of developing a query that involves only one to two record selection conditions?
  3. What are other reliable sources of information in which you can compare the accuracy of your query results?
  4. Name an activity you can participate in to continue to become familiar and knowlegeable about Univeristy data.
  5. What is meant by the term "perform sanity checking?"

Activity 2 Answers

  1. Ask the person requesting the report what results they expect to get. Or ask if the person can suggest another existing report that you can use to check to see if your results are at least in the ballpark.
  2. You can look at how the results change as you add each condition thereby insuring that you are only getting the data that you want.
  3. Other sources of information in which you can compare your query results include such items as BEN Financials or other source system screens or reports.
  4. You can continue to become familiar with and knowledgeable about University data by participating in the data collection listservs.
  5. The term means to check your query results by simply asking yourself if the information you have obtained is a reasonable answer.
Additional Lessons
Lesson 1. Security, Etiquette, and Ethics
Lesson 2. Salary Management Data Diagrams
Lesson 3. Table and Data Element Documentation
Lesson 4. Questions to Ask Before Writing a Salary Management Query
Lesson 6. Getting Salary Management Help

top

Information Systems and Computing
University of Pennsylvania
Comments & Questions


Penn Computing University of Pennsylvania
Information Systems and Computing, University of Pennsylvania