From the main Filter Designer screen, select the first radio button Query Wizard. You can eliminate the steps above by saving your query to a folder when you first create the query. If you have existing filters that you want to move into one of these folders, highlight the name of the filter and click on EDIT and then scroll to the bottom of the screen and just under the SAVE TO: User Account it says Folder/ with a drop down menu where you can choose which of the two folders that you created to save the query. 3Ĥ Now you will see that you ve got 2 choices of where to place grade level queries. If you want to create a folder within a folder, you would create the main (parent folder) first and the create a new folder and name the new folder and choose the Parent Folder you wish to put it in. From the main Filter Designer screen, select Create a new Folder. You can then make any changes you want and the original filter will remain available for others in the district to copy. This will save the filter to your user account. On this screen, scroll to the bottom and click on SAVE. On the next screen, take out the words Copy of and either name the filter something different or leave the rest of the name and scroll to the bottom right and click on next. Then, with the new filter still highlighted, click on edit. Click OK when the message appears that the filter has been copied. To copy a filter, select the filter in the list and click Copy. A user may copy a filter as the starting point of a new query, or to modify that existing query. The bottom of this window will have shared filters- Ad hoc queries that have been created and saved to a particular user group. The first filters on the list will be the user s personal Ad hoc Filters. Existing Ad hoc filters will list in the Saved Filters window. From the Index, expand the Ad Hoc Reporting and select the Filter Designer option. These fields will then form a filter or selection of fields. The fields (information) you need are the student s gender, first name, last name, grade, screening name and screening status. Now that you know what the query (question) is you can put together the fields (information) you need.
You can create a query (ask a question) in Campus to get this information. Ad Hoc Vocabulary Explained The nurse stopped by the office and said she needs a list of all 11th grade girls who had a questionable scoliosis screening or were referred after their first screening. Column - Each field that is selected will get a column on the table such as a column listing the birthdates of all of the students. Think of this as the answer to your question (query). Table - The data that is collected by the query is organized into a table made up of rows and columns. For example, the grade field will only populate with the grade level nothing else. Field - It will return data that is specific to the information that has been populated in that field elsewhere in campus. For example, I am inquiring about all of the 11th grade girls who have birthdays after the 15th of March. Query - Think of it as a question or an inquiry about a specific topic. Basic Ad Hoc Vocabulary Filter - A selection of fields used to generate other custom reports like mailing labels, etc. In addition, a tool is available in the Ad hoc module to create form letters and complete a mail merge using fields from the Campus database. These queries may be exported from Campus or used to filter canned reports throughout the product. Ad hoc queries may be used to find data relating to students, staff, all people and courses. 1 Infinite Campus Ad Hoc Reporting Basics May,Ģ Overview The Ad hoc Reporting module allows a user to create reports and run queries for various types of data in Campus.
0 kommentar(er)
