Aeries.net Student Information System Query – User Manual April 29
Contents
1. Query User Manual2. eagle aeries SOFTWARE Student Information System Aeries net Student Information System Query User Manual April 29 2009 The Aeries net Query option enables you to create queries from data stored within the database tables This process generates a query statement and collects the data which will allow you to create a report or excel spreadsheet The following documentation will provide you with information on some of the general functions available to you through Query WHAT IS A A query is a statement that gets entered onto the Query screen The QUERY statement will contain a Command that will instruct Aeries net to pull specific data from tables entered into the query statement WHATIS A A table is a file that stores certain data entered into the Student TABLE Information System aeries net 2008 2009 Screaming Eagle High School My Options LIST STU COMMANDS TABLES FIELDS SPECIAL LIST Display Output Student Data STU NM Full Name TOTAL Display Totals Activities and Awards Student STU MI SKIP Assertive Discipline Last Name 7 is KEEP Academic Plan Log First Name BARCODE Attendance Notes Middle Name l SORT Attendance Data MATH Authorizations Prohibitior E Seal and Waivers R ade er STs The Query form above displays some of the tables that are contained within Aeries net Please be aware that Eagle Software s objective is to provide their users with documented procedures su
3. Last Name First Name Middle Name ID Sex Grade Birthdate Parent guardian Mailing Address City State Zip code Extn Home Phone Fathers work Extn Mothers work Extn Testi Test2 Test3 Test4 C include Inactive Students SPECIAL Full Name Middle Initial New Line BARCODE Stop Math Open Parenth Close Parenth My Options After a table is selected only related tables will display Query User Manual Page 6 Aeries net Student Information System aeries net LIST STU COMMANDS LIST Display Output Display Totals Bypass Records Select Records SORT BY Sort By COMPARISON Not Equal gt Greater Than Less Than Contains Not Contains aeries net A listing will display of all FIELDS that are available A 2 or 3 character field name will display on the left under the Fields heading The Field Name will display to the right of the Field column 2008 2009 Screaming Eagle High School TABLES Student Data Acti s and Awards Assertive Discipline Academic Plan Log Attendance Notes Attendance Data Authorizations Prohibitior and Waivers Billing Course Attendance Recor Conference Contacts College Requests California Special Educati Data Content Standard Scores College Test Scores Daily Attendance Class Sheets Discipline Data District Supplemental Enrollment History Enrollment History Free and Reduced Cran sand Nadina M FI
4. A 1576975153 Abrego Alice g 1576069673 Adame Mambia 11 1576074533 Adragna Stefanie Sheena 10 15707 05093 Aguayo Taunie 10 mal aa aa a a a Query User Manual Page 34 Aeries net Student Information System ACCESSING DATA USING KEEP AChICS RCL l NAVIGATION nee ARE BEING SKIPPED a Student Flags Close the results screen by clicking the Red X in the upper right corner of the result window At the bottom right of the Query screen the Keep Skip History will display the KEEP statement generated Keep Skip History Hik EER STU IF SA F UNDO LAST KEEP SKIP Any further queries or access to student data will only be for female students To give you an example of how a KEEP statement can also work when accessing data click the mouse on the Navigation Tree Select Student Data then Demographics node H NAVIGATION STUDENT RECORDS ARE BEING SKIPPED a Student Flags g My Favorites 0 Student Data Supplanental The Student Data Demographics form will display only female students 2008 2009 Screaming Eagle High School My Options Flags Middle Name __ Suffix Sux Grd Age Birthdate A 9 15 FN Alias MN Alias Birth Yerif Status Active Student Data 1 Student Data 2 The Navigation Tree will display STUDENT RECORDS ARE BEING SKIPPED Query User Manual Page 35 Aeries net Student Information System RESET SKIP When you are finished running
5. 2009 6 45 AM NOTE Please be advised that labels are only formatted to be printed on only AVERY 5160 laser printer labels Query User Manual Page 27 Aeries net Student Information System SAVE QUERY Once you have created a query statement you can save the query STATEMENTS and access this query for later use aenes net 2008 2009 Screaming Eagle High School My Options LIST STU STU NM AD CY ST ZC New Excel Report Labels Cl include Inactive Students COMMANDS TABLES FIELDS SPECIAL LIST Display Output Student Data STU NM Full Name TOTAL Display Totals Activities and Awards STUM SKIP Assertive Discipline aah KEEP Academic Plan Log i BARCODE Attendance Notes SORT Attendance Data BY Sort By Authorizations Prohibitior PAER AAA and Waivers To save a query you must first generate the Query using the RUN button Click the mouse on the SAVE button The following text box will display Type a descriptive name for the query to assist you in locating your query after being saved Click the mouse on the SAVE button Query Name Labels flailing Address The following message will display when the query has been saved Microsoft Internet Explorer Eg A Ouery Saved LOADING To LOAD a saved Query statement click the LOAD button on the SAVED right side of the form QUERIES Startup Query User Manual Page 28 Aeries net Student Information System The follow
6. queries and or reports you must OR KEEP RESET query Drag the mouse over the message STUDENT RECORDS ARE BEING SKIPPED at the top of the Navigation Tree Click the mouse on the RESET button aeries net 2008 2009 Screaming Eagle High School My Options Bij NAVIGATION E 4 F g S ARE BEING SKIPPED LN Alias FN Alias MN Alias al Q Student Flags Birth Yerif Status Alley Active Student Records Are Being Skipped will no longer display Any further queries or accessing data will now include all students If Reset is not performed the only data accessible will be the NOTE data entered in the KEEP command Query User Manual Page 36 Aeries net Student Information System TOTAL The TOTAL command can be utilized to add up a specific series of COMMAND students to create a running total on the screen For example to determine the number of male and female students for each grade type the following TOTAL query Seres ner 2008 2009 Screaming Eagle High School My Options TOTAL STU SX GR BY SX GR C include Inactive Students Take note to the SORT order selected BY SX GR These fields must be selected in the TOTAL query statement Click the mouse on the RUN button The following calculation will be generated and will display A report can be created and printed out with the Query results F Query Display A rotatlsxjcr J aall I 12 10 0 LE 16 1l
7. ELDS School Student Last Name First Name Middle Name IDF Sex Grade Birthdate Parent guardian Mailing Address City State Zip code Extn Home Phone Fathers work Extn Mothers work Extn Testi Test2 Test3 Test4 C include Inactive Students SPECIAL Full Name Middle Initial BARCODE Start Math My Options Report Labels Letters Envelope To File Change Save Load Startup Reset Tables Click the mouse on the fields selected and the field name will display to the right of the table in the text box 2008 2009 Screaming Eagie High School LIST STU SN LN FN MN ID 5X GR COMMANDS LIST Display Output Display Totals Bypass Records Select Records SORT BY Sort By TABLES Student Data Activities and Awards Assertive Discipline Academic Plan Log Attendance Notes Attendance Data Authorizations Prohibitior and Waivers FIELDS Student Last Name First Name Middle Name Clinclude Inactive Students SPECIAL Full Name Middle Initial BARCODE MATH Stop Math My Options Report Labels Letters Envelope To File Change Save Load Startup When clicking the mouse on the fields a space will automatically be placed in between each field Query User Manual Page 7 Aeries net Student Information System TO SORT A A query can also be sorted in order by a particular field To sort the QUERY query click the mouse on the BY o
8. GREENBRIAR When this query is RUN only students that Contains GREENBRIAR in the address field will display as in the example below aeries net 2008 2009 Screaming Ea LIST STU STU NMN AD IF aD GREENBRIAR a Query Display Microsoft Internet Explorer Student Name Mailing Address Abel Sydney 1118 Greenbriar Ave Abel Sydney 1118 Greenbriar Ave Bohnett James 1214 Greenbriar Awe Bohnett James 1214 Greenbriar Ave Page 11 Aeries net Student Information System Query User Manual The query listed below displays IF PG LN When this query is RUN only students that Contains the students Last Name in the Parent Guardian field will display as in the example below aeries net LIST STU 5M LN FM PG IF PG 2008 2009 Screaming Ea LH E Query Display Microsoft Internet Explorer Student 24555 Abbott Alice A4bdelnour Alice Abdo Alice Abejan Tanya Abel Sydney Abel Sydney Abelar Ariel Abesamis Tatiana Parent guardian MM A Abbott MYM A Abdelnour MM A Abdo M M 4 Abejon Abel Karin 4bel Karin Mr Abelar MYM A Abesamis The query listed below displays IF PG LN When this query is RUN only students that does NOT Contain the students Last Name in the Parent Guardian field will display as in the example below aeries net LIST STU SN LW FN PG IF PG 2008 2009 Screaming Eagle Hi LN E Query Display Microsoft Internet Explorer Student 7469 4bateneh Kaleab 5260 Abbott A S261 Ab
9. ISON Data Extn Content Standard Scores Herne Phare Not Contains College Test Scores Fathare work s Daily Attendance Class Click the mouse on a field for specific record selection Type the criteria necessary to select specific records EXAMPLE For a listing of only female students type IF SX F Query User Manual Page 8 Aeries net Student Information System COMPARISONS Different Comparisons can be used when adding IF to your query statement A Comparison box displays on the left side of the screen Examples are given of how these comparisons can be used COMPARISON Mot Egual Greater Than z Mot Contains The following are query examples that utilize these comparisons The query listed below displays IF FN ALLEN When this query is RUN only the students that their first name is Equal to ALLEN will display as in the example below aeries net 2008 2009 Screaming Eag LIST STU SN LN FN IF FN ALLEN a Query Display Microsoft Internet Explorer Student Last Name 5261 Abbott Allen 5262 Abbotte Allen 6307 Muema Allen Query User Manual Page 9 Aeries net Student Information System The query listed below displays IF HP When this query is RUN any student record that is Not Equal to a blank in the Health Problem field will display as in the example below aeries net 2008 2009 Screaming Eag LIST STU 5M FN LN HF IF HR E Query Display Microsof
10. STU MED using two tables student and medical data STU SN student number from the STU table STU LN student last name from the STU table STU FN student first name from the STU table MED CD medical code from the MED table MED CO medical comment from the MED table IF MED CD if the medical code is not blank This Query will display the student number last name first name medical code and any medical comments for students with a medical condition Query User Manual Page 16 Aeries net Student Information System After the RUN button is clicked and the query is generated the screen will display the data selected Compare the data and verify it meets the standards of the query that you are interested in Click the mouse on the Red X to close A Query Display Microsoft Internet Explorer fala 2555 Abbott TE L Eye Ice Class 2555 Abbott Alice T99 Home 2555 Abbott Alice L Knee C B Class 2555 Abbott Alice L Thumb C B Class 2555 Abbott Alice L EarfIce Class 2555 Abbott Alice Class 2555 Abbott Alice T100 Home 2555 Abbott Alice Poked In R Eye Ice Class 2555 Abbott Alice R Leg Ice Class 2555 Abbott Alice R Hand W Ball Ice Class 2555 Abbott Alice Tooth Hit Stu Head Ice Class 2555 Abbott Alice Ball Hit L Eye Ice Class 2555 Abbott Alice Pinched Ice Class 2555 Abbott Alice 2555 Abbott Alice lft mid finger c b Fell while playing soccer Severe abrasion to hip 2 Abdelnour Alice Cleaned BA Called parent for
11. Stefanie S Taunie Jennifer M Allan Catherine M Alice Linda Arturo Neal Jesus Jesse R Clarisa Berdine Jocelyn William Tracy Ariane Christina Rudy William Shannon M Jennifer Jo Melissa R Joshua P heena 9 10 10 9 9 10 10 10 9 10 9 9 10 9 10 9 10 10 9 04 13 1994 07 21 1994 04 28 1992 02 26 1993 11 16 1993 12 01 1994 01 22 1993 06 18 1993 06 23 1992 07 25 1994 08 27 1993 11 10 1993 09 20 1994 10 09 1991 07 28 1993 05 04 1993 06 29 1994 07 30 1993 04 09 1993 10 17 1993 05 23 1994 01 22 1994 11 03 1993 02 10 1994 06 26 1994 Close this screen by clicking the X in the upper right hand corner of the result window At the bottom right of the Query screen the Keep Skip History will display the SKIP statement generated Keep Skip History 1 SKIP STU IF GR gt 10 UNDO LAST KEEPS SKIP Any further queries or access to student data will skip all grades greater than grade 10 Query User Manual Page 32 Aeries net Student Information System RUN QUERY To give you an example of how a SKIP statement works now type USING SKIP the following query statement LIST STU SN LN FN GR BY GR Click the mouse on the RUN button aeries net 2008 2009 Screaming Eaal righ School My Options K 421 LIST STU SN LN FN GR BY GH Cl include Inactive Students Notice there is no IF in the query statement When the Query results displays click the mouse on the End of Fil
12. arch Folders E Address C eagle Excel x 2 Folders x Name Size Type Date Modified Date Picture Taken Dimensic 3 eagle A Bl Student Medical List xls 3KB Microsoft Excel Wor 4 27 2009 6 45 4M 2004 2005 Query User Manual Page 19 Aeries net Student Information System CREATING A After generating your query statement a formal looking report can be REPORT created by clicking the mouse on the REPORT buiton slo slot NCE 2008 2009 Screaming Eagle High School My Options LIST STU MED STU SN STU LN STU FN MED CD MED CO IF MED CD Cltnclude Inactive Students COMMANDS j TABLES FIELDS SPECIAL The following report options will display In the Report Title type the Title to be printed at the top of the report Select the report line Spacing Single Double or Triple spaced Select the Report Orientation Automatic Portrait or Landscape Click the mouse on the Run Report button Print Query Report Report Options Report Title o Line Spacing Single Spacing Double Spacing Triple Spacing Report Orientation Automatic Portrait O Landscape Run Report Query User Manual Page 20 Aeries net Student Information System A PDF File will be generated and the option will display to Open or Save the file File Download Do you want to open or save this file aps Name PrintQueryReport_ 20090478 090653_4 pdF iaie Type Adobe Acrobat Document 5 51 KB Fram vro
13. arston 1023 N Barston 22260 E Nubia St 21260 Nubia C e a e a a a a Pesce pesca a a a a a becom a Wesco a a Remco peer coe Peers ae Rock CA Campbell CA Eagle Rock CA Eagle Point CA Eagle Point CA Eagle Point CA Eagle Point CA Eagle Point CA Eagle Point CA san Jose CA san Jose CA Eagle Point CA Eagle Point CA Eagle Point CA Eagle Point CA San Jose CA San Jose CA San Jose CA Eagle Point CA Covina TA Covina TA Covina TA Eagle Rock CA Covina TA _ EEN 95994 19999 19999 99995 99995 99995 99998 99998 95128 99998 99995 99995 99995 95128 g5i 4 99998 91724 91724 91724 19999 91724 The backslashes entered into the query create their own column for each student record The VY column is read by query and forces the program to drop down one line when printing labels After you RUN the query statement close the result window then click the mouse on the LABELS button aeries net LIST STU STU NM AD CY ST ZC E 2008 2009 Screaming Eagle High School My Options Clitnclude Inactive Students COMMANDS TABLES FIELDS SPECIAL Query User Manual Page 24 Aeries net Student Information System A PDF File will be generated and the option will display to Open or Save the file File Download Do you want to open or save this file ps Name PrintQueryLabels 20090427 083154 5 pdf abe Type Adobe Acrobat Document 353 KB F
14. bott Allen p262 4bbotte Allen 747l Genesis 3101 Genesis 2765 Josie 2786 Liza Parent quardian 4dane Yeswilek james kelly MM Abrahim MM A Ablaza Leyva Nora Leyva Nora Abreo Leyva Abreo Leyva Abreu Adan efor gogn Adilovic Aquiera Dzemila Slew Page 12 Aeries net Student Information System SPECIAL CHARACTERS Query User Manual There are Special Characters that can be utilized within a query statement that will provide shortcuts to the final query generated These characters are displayed on the right hand side of the form under Special SPECIAL Full Name Middle Initial e STU NM will join LN with a comma and the FN for example Abbott Lori e STU MI will only display the first letter of the MN e forces the print line to drop down one line e Barcode will generate a number into a scanning barcode ona label The following is an example of a query utilizing the STU NM and STU MI Special Characters listed above aeries net 2008 2009 Scre LIST sTU 3TU NM STU MI Query Display Microsoft Internet Explorer z minl Student Name MIZI Sbateneh Kaleab Abbott 4 Abbott Alice Abbott Allen Abbotte Allen 4Hdelnour Alice Abdo Alice Abejon Tanya Page 13 Aeries net Student Information System TO GENERATE Once the query statement is entered click the mouse on the RUN A QUERY button and the query will begin to process aeries net 2008 2009 Screaming Eagle High Scho
15. ch as the one that follows in an attempt to expedite the steps necessary to accomplish certain tasks within Aeries However Eagle Software recognizes that each school and district using Aeries has established their own unique guidelines and policies By using these procedures you assume full responsibility for the appropriate application the results of their use any impact upon your database and conforming to all guidelines and policies that have been established by your school or district Page 2 Aeries net Student Information System HOWISA The form displayed below is the Teachers form When you click on TABLE the Add button the screen allows you to enter specific data about a CREATED teacher aeries net 2008 2009 Screaming Eagle High School My Options Teacher Data NCLB Core Elec Tag Email Address e v v v abbott aeries com Hiighly Qlfd Highly Qlfd Staff ID 3 Tchr 3 12345678 Photo File ii p Search Sort Options fo fh Porc CON aa After you have typed information into the different fields and clicked on Insert a record is created and saved in the TCH table As you keep entering teachers a new record is created for each teacher After the first record is created essentially you have created the TCH table WHY IS Instead of creating one large table that contains all of the student s THERE MORE data smaller tables are created Having multiple tables increase
16. d Center C Choose Paper Source by POF page size Print to file Units Inches Zoom Db Print color as black 1 183 1 To save the file click the mouse on the Save button File Download Do you want to open or save this file ps Name PrintQueryLabels 20090427 063154 5 pdF eae Type Adobe Acrobat Document 353 KB From vin eagle two While files from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file What s the nek Query User Manual Page 26 Aeries net Student Information System The Save As box will display Select the folder where the file will be saved Enter the File Name Click the mouse on the Save button Save As Save in Excel and PDF v ce EP Ei My Recent Documents a Desktop My Documents 49 hy Computer k Ene PrintOuerLabels 20090427 085023 7 pdf tt My Network Save as type Adobe Acrobat 7 0 Document The file will now be saved in the folder selected C eagle Excel and PDF Sees a File Edit Yiew Favorites Tools Help Bak O B A seach Folders E Address C eagle Excel and PDF vi Go Folders x Name Size Type Date Modified Date Picture Taken Dimensic eagle a PrintQueryLabels_20090427_ 354KB Adobe Acrobat Doc 4 27 2009 8 37 AM 2004 2005 BS Student Medical List xls 3KB Microsoft Excel Wor 4 27
17. e button The highest grade to be displayed will be the students up to grade 10 2291 George 2293 Richard 094a Yang Newton 6946 Zacarias Kelsey 2302 zagala Ronald 6948 Zakhia Kevin 6949 Zalbra Tala 000 All query statements will utilize the SKIP statement until RESET Query User Manual Page 33 Aeries net Student Information System RESET SKIP When you are finished running queries and or reports you must RESET query by clicking the RESET button The Keep Skip History will NO LONGER display at the bottom right corner yt NOTE If you do not perform reset the only data accessible will be the data entered in the SKIP command KEEP The KEEP command will give access to only the students selected In COMMAND the query text box type KEEP STU IF SX F and click the mouse on the RUN button aeries net 2008 2009 Screaming Eagle High School My Options KEEP STU IF 5X F SES Cinciude inactive Students Notice that the only students displayed are Female students Any query statement or program will only look at these students E Query Display Microsoft Internet Explorer Q eum E ER Lemel te Nemolticl bemalravolos laiimk ilar 1576852322 erate na PEETA 1576373523 Abdo Alice 077 2171994 02 26 1993 11 16 1993 12 01 1994 12 23 1991 01 22 1993 06 18 1993 gJ 10 th 1576835063 Abejon Tanya 4 1576077973 Abesamis Tatiana J g th
18. eriod then the field name such as MED SN This is to make sure query pulls the right data from the right table Two tables could have a field with the same name but each holds different data aeries net 2008 2009 Screaming Eagle High School My Options LIST STU MED STU SN STU LN STU FN MED CD MED CO IF MED CD New Excel Report Labels Cltnclude Inactive Students COMMANDS TABLES FIELDS SPECIAL LIST Display Output Student Data School STU NM Full Name TOTAL Display Totals Medical Events Student I f STUM SKIP Activities and Awards f Code ER New Line KEEP Assertive Discipline Date BARCODE Barcode lt i Academic Plan Log Comments SORT Attendance Notes Starting date BY Sort By Attendance Data 3 Ending date A Authorizations Prohibitior Status and Waivers Start Time Billing End time Course Attendance Recor Billing Code ICD 9 Conference Initials Contacts Billing Units College Requests j Results California Special Educati i Seq Data School Not Contains Content Standard Scores School College Test Scores Student Daily Attendance Class Sheets Discipline Data District Supplemental Enrollment History Sex Enrollment History ee ee eee Grade Hit Lil COMPARISON Last Name First Name Middle Name IDF Aeries Version 2 9 4 23 Copyright 2009 Eagle Software All Rights Reserved The following is the definition for this Query LIST display on the screen
19. i eagle bywo ae Cancel While iles from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file whats the risk To open the file click the mouse on the Open button The PDF file will display To print the report click the mouse on the Printer icon bs PrintQueryReport_20090428 090653 _4 1 pdf Adobe Acrobat Professional cle File Edit View Document Comments Forms Tools Advanced mrd Seaee MO eee 120i 1 p Create PDF 7 d Combine Files Export 7 Start Meeting Secure 7 VA Sign g Forms 7 amp Review amp Comment Y Screaming Eagle High School 4 28 2009 Student LastName FirstName Code Comments 2555 Abbott Alice 05 L Eye Ice Class 2555 Abbott Alice 29 T99 Home 2555 Abboit Alice 01 L Knee C B Class 2555 Abbott Alice 10 L Thumb C B Class Query User Manual Page 21 Aeries net Student Information System To save the file click the mouse on the Save button File Download Do you want to open or save this file aps Name PrintQueryReport 20090428 091342_5 pdF iek Type Adobe Acrobat Document 5 51 KB From vm eagle two While files from the Interet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file What s the risk The Save As box will display Select the folder where the file will be saved Enter the File Name Click the mouse on the Sa
20. ing form will display The saved queries can be displayed by the name of the Query or by the Author s name Sort By Query Name Filter hs Author Filter as 3 FIENT eS 11th Grade Students Demo LIST STU FN LN PG IF GR 11 2nd period student list Oth Grade Student Enrollment Academic Team Roster Admin drop list ADS SUS TOTAL LIST STU LN FN GRIF GR 9 LIST STU GRD CRS STU SN STU NM STU U8 GRD CN CRS CO CRS NA GRD M3 IF CRS NA N LIST STU SEC MST CRS TCH STU SN STU LN STU FN STU MN TCH TE MST PD CRS CO STU GR IF MST CN 0982 LIST STU ADS ADS SN A4DS CD ADS DS ADS DT ADS DY BY ADS DT IF ADS DS SUS AND ADS DT gt 09 04 00 List STi SEC Msi ThA ces Sith STU FA TCR TE LJ MST RM MST PD IF MST PD 2 KEEP STU IF FN KEEP STU IF LN LIST STU GRD CRS STU NM GRD M2 IF GRD CN 0625 LIST STU ATT STU NM ATT AL ATT DT IF ATT AL S OR ATT AL W OR ATT AL U AND ATT DT gt 1 11 1999 AND ATT DT lt 3 5 1999 List STU SEC MST CRS TENSIONS LA STEN STU GR CRS CN CRS CO MST PD TCH TE IF MST CN 0090 LIST STU ATT STU SN STU LN STU FN STU GR STU PG STU TL STU FW STU MW ATT A2 IF ATT A2 a AND ATT DY 91 AND ATT AS a ATT Absence Letter List LIST STU SN LN FN GR LT BY LT IF LT 0 ATT Tardy Letter List LIST STU SN LN FN GR L2 BY L2 IF L2 0 Chanae querv Demo CHANGE STU SUP LF TO LIF SUP LP F AND TG ai ADS ID photo by FN ADS ID Photo by Last Name Algebra grades All day truancies w date Athletics lis
21. lass Hand AW Ball lce Class ooth Hit Stu Head lce Class 43 2555 Abbott Alice all Hit L Eye lce Class Alice 2665 Abbatt_ Alice 9 ft_mid finger c b Fell while playing soccer Severe abrasion to hip Cleaned BA Called parent for 17 2 Abdelnour Alice 1 permission for student to return to class 3313 Garcia Milo 4 1317 Marchesano Kristie _43fCalled parent Allergic to pollen Wentolin in health office 21 1317 hlarchesano Kristie 2iReturned to class el i i inched Ice Class L Query User Manual Page 18 Aeries net Student Information System To save the file click the mouse on the Save button File Download Do you want to open or save this file Name QueryResults xls HHI Type Microsoft Excel Worksheet 2 17 KB From vin eagle byyo Always ask before opening this type of file While files from the Internet can be useful some files can potentially harm Your computer IF you do not trust the source do not open or save this file What s the risk The Save As box will display Select the folder where the file will be saved Enter the File Name Click the mouse on the Save button Save fis Savei O f o m My Recent Documents File name Student Medical List w Save My Network Save as type Microsoft Excel Worksheet The file will now be saved in the folder selected C eagle Excel fe lx ar Fie Edit view Favorites Tools Help 3 Qpak A Se
22. lect data to display STU using the student data table STU NM students full name from the STU table drops down to the next line AD students address from the STU table drops down to the next line CY Students city from the STU table ST students state from the STU table ZC students zip code from the STU table Query User Manual Page 23 Aeries net Student Information System To generate the query statement click the mouse on the RUN button The following query result will display a Query Display Microsoft Internet Explorer O Q Student Name Mailing Address A4bateneh Kaleab Abbott A Abbott Alice Abbott Allen Abbotte Allen Abdelnour Alice Abdo Alice Abejon Tanya Abel Sydney Abel Sydney Abelar Ariel Abesamis Tatiana Abrahim vei Ju Abrego Alice Abrego Jennifer i i i K i i i i i i i i i Abreo Leyva Genesis 5 Abreo Leyva Genesis 5 Abreu Josie Abruzzese Alice Abujohn Joshua Abujohn Joshua Abujohn Joshua Aceves Joemar Aceves Valerie G Q i 975 Sharmen Palms Ln Apt T 550 E Claraday St 9 1881 Mitchell 134 663 N Ride Road 22210 E Arrow Hwy 119 PO Box 90239 4475 N Castleview 112 W Callaman Dr 1118 Greenbriar Ave 1118 Greenbriar Ave 500 Manzanita 663 N Reeder Ave 115 W Norgate St 1111 Camino Del Sur 701 Menker Ave Apt 3 701 Menker Ave Apt 3 1771 Nelson Way 1103 N Stephora Ave 1023 N Barston 1023 N B
23. ol My Options LIST STU SN LN FN MN ID 5X GR BY GR IF 5X F O include Inactive Students The following is the definition for this query LIST select data to display STU from the Student Data table SN the student Number LN the students Last Name FN the students First Name MN the students Middle Name ID the permanent ID SX the sex GR the current grade BY GR In the order of grade IF SX F only include female students After the query is generated the screen will display the data selected Compare the data and verify it meets the standards of the query that you are interested in Click the mouse on the Red X to close E Query Display Microsoft Internet Explorer Ef Student Last Name First Name Middle Name _ID _ Sex Grade 6921 wiliamson lori 75547541F 7470 Abel Sydney 7548089 F 3100 Abel Sydney 7543720 F 2784 Abelar Ariel Kristina 7543404 F adoi Abreo Leyva Genesis 7543721F 7471 Abreo Leyva Genesis 7548090 F 2785 Abreu Josie 7543405 F 2786 Adan Liza 7543406 F 2787 Adilovic Dzemila 7543407 F 3102 Aguada Lilibeth 7543722 F 7472 Aguada Lilibeth 7548091 F 2791 Alaimo Anna 7543411F 3105 Alaniz Esparza Nancy 7543725 F 7475 Alaniz Esparza Nancy 7548094 F 2792 Albers Paige N 7543412 F 2793 Alcocer Jennifer L 7543413 F 2795 Alderese Jaclyn Caroline 7543415 F 3109 Allen Krystal MI 7543729F 7479 Allen Krystal M 7548098 F 7480 Almash Meghan 7548099 F 3110 Almash Meghan 7543730 F zalalal Al
24. ourse Attendance Recor Course History Institution Conference Code Table Colleges Danta abe FIELDS New i Report Cl include Inactive Students SPECIAL Full Name Middle Initial Envelope T Barcode Labels Letters Change Startup Open Parenth Close Parenth Reset Tables Page 4 Aeries net Student Information System The commands available are e LIST performs a display function e TOTAL will calculate a total amount of specific records e SKIP will bypass specific records e KEEP will select specific records A text box is displayed at the top of the form This area is where the query will be entered Below the text box messages display indicating the steps to be performed ale Aa Cr 2008 2009 Screaming Eagle Hich School My Options Cl include Inactive Students COMMANDS i TABLES FIELDS SPECIAL TO CREATE Click the mouse on the Command selected The command will A QUERY display in the text box at the top of the form AChHCS NCL 2008 2009 Screaming Eagle High School My Options Cl include Inactive Students COMMANDS TABLES FIELDS SPECIAL LIST Display Output STU Student Data a TOTAYDisplay Totals ABS Absence Codes Middle Initial d Query User Manual Page 5 Aeries net Student Information System aeries net COMMANDS LIST Display Output Select Records aeries net A message will display below the text box to Enter Table Code A listing will displa
25. permission for student to return to class Garcia Milo Macias Leydi Marchesano Kristie Called parent Marchesano Kristie Allergic to pollen Ventolin in health office Returned to class CREATE EXCEL After generating your query statement an Excel spreadsheet can SPREADSHEET _ be created by clicking the mouse on the EXCEL button slo jiek E 2008 2009 Screaming Eagle High School My Options z LIST STU MED STU SN STU LN STU FN MED CD MED CO IF MED CD lt mra kid CLON Query User Manual Page 17 Aeries net Student Information System The option will display to Open or Save the file File Download Do you want to open or save this file Name QueryResults xls HI Type Microsoft Excel Worksheet 2 17 KB From vin eagle byyo Always ask before opening this type of file harm Your computer IF you do not trust the source do not open or 2 While files from the Internet can be useful some files can potentially save this file What s the risk To open the file click the mouse on the Open button The Spreadsheet will display hitp ym eagle two faeries net OueryDisplayCS aspx Microsoft Internet Explorer E x Reo 1 Kw amp A ee A re Ss ae eae Eye lce Class Tag Home L Knee C B Class L Thumb C B Class E 2565 Abbott Alice 3 L Earflce Class Class E 2666 Abbott Alice S1 J T100 Home 3 3555 Abbott Alice 5 Poked In R Eye lce Class Leg ce C
26. ption under SORT sol gio NEL 2008 2009 Screaming Eagle High School My Options COMMANDS TABLES SPECIAL LIST Display Output Student Data STU NM Full Name TOTAL Display Totals Activities and Awards STU MI SKIP Assertive Discipline KEEP Academic Plan Log i BARCODE Attendance Notes i Attendance Data MATH Authorizations Prohibitior and Waivers Stop Math Determine the order that you want this query to be sorted and click the mouse on the field selected The field will display to the right of the BY statement For example BY GR will sort the query in order of grade level TO SELECT For this query to utilize only specific records click the mouse on the SPECIFIC IF option and IF will display at the end of the query RECORDS acnes Ner 2008 2009 Screaming Eagle High School My Options Z LIST STU SN LN FN MN ID 5X GR BY GR IF oO S F z Cl include Inactive Students COMMANDS TABLES FIELDS SPECIAL LIST Display Output Student Data School STU NM Full Name TOTAL Display Totals Activities and Awards Student STU MI SKIP Assertive Discipline Last Name KEEP Academic Plan Log First Name BARCODE Attendance Notes Middle Name SORT Attendance Data ID BY Sort By Authorizations Prohibitior Sex es and Waivers Grade Billing J Birthdate Course Attendance Recor Parent quardian Conference Mailing Address Contacts City College Requests State Greater Than California Special Educati Zip code E COMPAR
27. rnet Explorer Hi j Are you sure you want to delete this record To exit the LOAD screen click the mouse on the CLOSE button Query User Manual Page 30 Aeries net Student Information System SKIP OR KEEP COMMANDS The SKIP and KEEP commands are used to create temporary tables that will only contain certain groups of data such as a particular grade For example a QUERY using SKIP to NOT include students in grades 11 and 12 would be SKIP STU IF GR gt 10 aeries net 2008 2009 Screaming Eagle High School SKIP STU IF GR gt 10 Clinclude Inactive Students My Options COMMANDS LIST Display Output TOTAL Display Totals SKIP KEEP SORT BY Sort By Reverse Sort COMPARISON Contains Not Contains TABLES Student Data Activities and S4wards Assertive Discipline Academic Plan Log Attendance Notes Attendance Data Authorizations Prohibitior and Waivers Billing Course Attendance Recor Conference Contacts College Requests California Special Educati Data Content Standard Scores College Test Scores Daily Attendance Class Sheets Discipline Data Dental District Supplemental Enrollment History Enrollment History Cran and Madian Hilt FIELDS School Student Last Name First Name Middle Name IDF Sex Grade Birthdate Parent quardian Mailing Address City State Zip code Extn Home Phone Fathers work Extn Mothers work Extn Te
28. rom 9 vin eagle bwo While files from the Internet can be useful some files can potentially harm your computer IF you do not trust the source do not open or save this file What s the nek To open the file click the mouse on the Open button The PDF file will display To print the labels click the mouse on the Printer icon PrintQueryLabels_20090427_083154_5 1 pdf Adobe Acrobat P ssessional efx gt jit GSD QO Ali pe ey Fin oaly d Combine Files 6 Export fe Start Meeting ia Secure 7 A Sign 3 Forms m4 Review amp Comment Y Abbott Alice Abbott Allen Abbotte Allen 1881 Mitchell 134 663 N Ride Road 22210 E Arrow Hwy 119 Eagle Point CA 99999 Eagle Point CA 99998 Eagle Point CA 99998 Abdelnour Alice Abdo Alice Abejon Tanya PO Box 90239 4475 N Castleview 112 W Callaman Dr Eagle Point CA 99998 Eagle Point CA 99998 Eagle Point CA 99998 Query User Manual Page 25 Aeries net Student Information System The Print options will display Set up the labels to print and click the mouse on the OK button Print Printer Name HIP LaserJet 2200 Series PCL 6 from LORI Status Ready Comments and Forms Type HP Lasenet 2200 Seres PCL Document and Markups ka Print Range All Current view Current page O Pages 1 188 S Subset Freview Composite Reverse pages Page Handling Copies Collate Page Scaling Fit to Printable Area wt Auto Fotate an
29. s THAN ONE processing time that allows you to pull data from specific tables instead TABLE of one large table To access information from various tables a field has been flagged that will create a link between the tables For instance the MED and STU tables both contain the student number SN field which creates a link that allows you to pull data from both tables Query User Manual Page 3 Aeries net Student Information System QUERY PROCESS To begin the query process click the mouse on the Query node from the Navigation Tree aeries net I NAVIGATION 2 Gy Student Flags My Favorites 0 Student Data Attendance See Grade Reporting Scheduling School Info View All Reports View All Forms The following screen will display Various commands can be selected by using the mouse or you can type the query by hand aeries net 2078 2009 Screaming Eagle High School My Options COMMANDS LIST Display Output Display Totals Bypass Records Select Records BY Sort By Reverse Sort COMPARISON Not Equal Query User Manual TABLES Student Data Absence Codes Attendance Create Log Activities and Awards Name and Address Assertive Discipline Academic Plan Course Requests Academic Plan Log Attendance Submit Log ABI Attendance Notes Attendance Data Authorizations Prohibitior and Waivers Bell Schedule Billing Bell Schedule Definition Bell Schedule Times C
30. sti Test2 Test3 Test4 SPECIAL STU NM Full Name STU MI Middle Initial BARCODE This will allow you to run queries and access student data for students who are currently in grades less than grade 11 SKIP COMMAND Using the SKIP command the query or student data will not access the students selected In the query option type SKIP STU IF GR gt 10 Click the mouse on the RUN button aeries net 2008 2009 Screaming Eagle High School My Options SKIP STU IF GR gt 10 SE Clinciide inactive students Pt Query User Manual Page 31 Aeries net Student Information System The following Query results will display Take note that the grade level of the students displayed is only for grades 9 and 10 All other grade levels above grade 10 are skipped E Query Display Microsoft Internet Explorer G Q puus else ie allel tunz A a Mets deals I able aisia 1576852322 Abdelnour Alice 1576373523 Abdo 1576834093 allinson 1576835063 Abejon 1576077973 Abesamis 1576975153 Abrego 1576074533 Adragna 1576765693 Aquayo 1576079633 Aguiar 1576086153 Aguilar 1576378573 Alcala 1576972773 Alegria 1576764013 Alejandro 1575864703 Allen 1576073593 Almada 1576074123 Alonzo 1576381033 Alvarado 1576764823 Alvarado 1590143873 Alyunan 1576373413 Amaya 1576088713 Ancheta 1576377433 Ancheta 1576078553 Anderson 1575878613 Anderson 1577071343 Apodaca Alice A daniel A Tanya Tatiana J Alice A
31. t ATT A by pd If many Query statements have been saved you may want to Sort By Author s name to have all personal Queries listed together A filter can also be added for the Query Name or Author to help locate specific queries Once the query is located click the mouse on the Query Sort oy Query Name Filter label Author Filter a Query Name Author Query prs pee Ratu Nae ers STU ZC IF SUP OT 0 B E A Course STULST STU ZC IF CRS CN 0331 reer as lon LIST STU STU NM AD CY ST ZC The Query statement will now display on the main Query form and can be generated by clicking the mouse on RUN aeries net 2008 2009 Screaming Eagle High School My Options LIST STU STU NM AD CY ST ZC New Kono i j Clinclude Inactive Students Query User Manual Page 29 Aeries net Student Information System Make sure when saving queries that you only save the queries that were hard to create Queries can be deleted but you can only delete the queries that you created To delete a query click the mouse on the X to the left of the query statement Query Name Filter Author Filter IDT labels Derma HST ETU sv Sr STOFNA a UPG TU ADA ST e a UST S22 IF SURET i T Labels Mailing lori List STU STUN an cys 2c f Address te gee ety ere MCT ene CTL DC CTL AMA OTIL AGS oTILey The following message will display Click the mouse on the OK button and the query will be deleted Microsoft Inte
32. t Internet Explorer Student First NamelLast Name Health Problem oo Claudia 4kanna ea ae Shannon Ancheta Takes Medication Joshua Apodaca Takes Medication Allan Aguila MA Kenneth Aguna Takes Medication Emanuel Arellano MA Rachel Arredondo Takes Medication Rhiannon Auten Takes Medication Elisabeth Avila Proventil Andrew Barillas Mr A Darlene Baroni MIA The query listed below displays IF GR gt 12 When this query is RUN only students in a grade Greater Than 12 will display as in the example below aeries net 2008 2009 Scre LIST STU STU NWM GR IF GR gt le E Query Display Microsoft Internet Explore Student Name Abbott A 15 Abbotte Allen 17 4brahim Wel Ju 18 Acosta Samantha 16 Acosta Samantha 16 Acosta Samantha 16 Acosta Samantha 16 Acosta Samantha 16 Acosta Samantha 16 Query User Manual Page 10 Aeries net Student Information System Query User Manual The query listed below displays IF GR lt 9 When this query is RUN only students in a grade Less Than 9 will display as in the example below aeries net 2008 2009 Scre LIST STU STU NM GR IF GR lt 9 Que ry Display Microsoft Internet Explorer O Q Student Name Grade Abateneh Kaleab Abel Sydney Abel Sydney Abelar Ariel Abreo Leyva Genesis Sbreo Leyva Genesis Abreu Josie Abujohn Joshua Abujohn Joshua A4bujohn Joshua OF 0 OOF OF Oo oO The query listed below displays IF AD
33. varado Evelyn 7543731F 7481 Alvarado Evelyn 7548100 F 7483 Amara Janet 7548102 F apale Amara Janet 7543733 F O Q 0000 0 0000 foal feel ech eal foul fool ool a0 a a ool ool Query User Manual Page 14 Aeries net Student Information System ADDITIONAL There are buttons in a column on the right side of the QUERY FUNCTIONS screen These buttons are used to generate reports labels excel spreadsheets etc after the query statement has been generated The following are the ADDITIONAL FUNCTIONS available e NEW will clear the text box area of any query displayed to enter a new query statement e RUN will generate the query statement and display the data e EXCEL will generate an excel spreadsheet e REPORT will generate a formatted report from the data displayed e LABELS will generate formatted labels from the data displayed e SAVE allows you to save the query for later use e LOAD will allow you to re load a query previously saved Query User Manual Page 15 Aeries net Student Information System CREATING A A Multiple Table Query uses more than one table to access MULTIPLE different information For example the query below will create a list TABLE QUERY students having a medical condition by accessing data from the STU and MED tables The link between these two tables is the Student Number SN When two tables are selected notice the change in the field names They now contain the table name first a p
34. ve button Save itr Excel and PDF ae Excel and POF E Fi gt E M PrintQueryLabels_20090427_083517_1 pdf My Recent Documents T Desktop My Documents 8 My Computer File name Medical Listing ka My Network nave ag type Adobe Acrobat 7 0 Document t Query User Manual Page 22 Aeries net Student Information System The file will now be saved in the folder selected C eagle Excel and PDF File Edit view Favorites Tools Help 3 Q pak E B A Search le Folders E Address C eagle Excel and PDF 4 Go Folders x Name Size Type Date Modified Date Picture Taken Dimensic E Desktop P S PrintQueryLabels 20090427 _ aC 354KB Adobe Acrobat Doc 4 27 2009 8 37 AM E a My Documents a E Student Medical List xls 3KB Microsoft Excel Wor 4 27 2009 6 45 4M My Computer Se Local Disk C LABELS After generating a query statement the LABELS button will allow you BUTTON to create labels such as mailing labels student folder labels etc Listed below is an example of a Query to print mailing labels To create mailing labels or any label containing more than one line you must use the V in your query statement aeries net 2008 2009 Screaming Eagle High School My Options LIST STU STU NM AD CY ST ZC This will force the query to drop down to the next line when printing the label The following is the definition for the above query LIST se
35. y of all TABLES available and will be outlined with a yellow border A 3 character code will display under the TABLES heading The Table Name will display to the right Use the up and down arrows or the scroll bar to locate the table Click the mouse on the Table selected 2008 2009 Screaming Eagle High School TABLES Student Data Absence Codes Attendance Create Log Activities and Awards Name and Address Assertive Discipline FIELDS O include Inactive Students SPECIAL Full Name Middle Initial BARCODE Barcode My Options Report Labels Letters Envelope To File Change Save The 3 letter code for the table selected will display in the text box after the command selected The next available steps that can be performed will display below the text box 2008 2009 Screaming Eagle High School Display Totals Bypass Records Select Records BY Sort By Reverse Sort COMPARISON NOTE TABLES Student Data Acti s and Awards Assertive Discipline Academic Plan Log Attendance Notes Attendance Data Authorizations Prohibitior and Waivers Billing Course Attendance Recor Conference Contacts College Requests California Special Educati Data Content Standard Scores College Test Scores Daily Attendance Class Sheets Discipline Data District Supplemental Enrollment History Enrollment History Free and Reduced Cran and Madina iii FIELDS School Student
Download Pdf Manuals
Related Search