Welcome to Forums Sign in | Join | Help | Forums
in Search


Forums » Internal Forums » Registrar's Office » How to run a Query of average from FA Web

How to run a Query of average from FA Web

Last post 10-07-2008 11:19 AM by Norm Dunkin. 1 replies.
Page 1 of 1 (2 items)
Sort Posts: Previous Next

  • 10-07-2008 11:08 AM

    • Kathy Moore
    • Not Ranked
    • Posts 10
    • Organization: All Saints Episcopal School

    How to run a Query of average from FA Web

    Reply Contact

     

    We just went through the migration project of Admission and Registrar to Education Edge / FA Web / NetClassroom and still learning our way around.

    Does anyone know how to run a query of averages in FA Web that meet the criteria of <70?

    Thank you in advance for any input!!
    Filed under:

  • 10-07-2008 11:19 AM In reply to

    • Norm Dunkin
    • Top 75 Contributor
    • User Since: 1998
    • Posts 94
    • Organization: Landmark Christian School
    • Products:  Accounting for Nonprofits, Blackbaud NetCommunity, The Education Edge, The Financial Edge, The Raiser's Edge, The Researcher's Edge

    Re: How to run a Query of average from FA Web

    Reply Contact
    Kathy, There is a report in Reports -> Grade Report that will do this for you very easily. For a query, here is my setup for this. Student Query In Criteria, select the following: Academic Year AND Marking Column AND School AND Grade "between 2 AND 75". Note: I selected 2 because "0" and "1" didn't work. "1" got confused with 100 for some reason. Output is: Last Name, First Name, , Course ID, Teacher, Marking Column, and Grade (the grade in the Marking column). Teachers and Administrators can also run a Progress Report in FAWeb to do the same thing. Hope this helps.
    Norm Dunkin
    Registrar & Database Administrator
    Landmark Christian School
    Fairburn, GA USA
    www.landmarkchristianschool.org
Page 1 of 1 (2 items)