1 . ASTU LastName FirstName MiddleName if LastName = 'smith'
To find the last name of students with a particular last name
2. ASTU LastName FirstName MiddleName if LastName |- sm
If you only have part of a the name or you know it starts with
3. ASTU LastName FirstName MiddleName Grade MailAddr if MailAddr : 'san pablo'
When looking for students who have the same street address name will list in numerical order for address
4. ASTU LastName FirstName MiddleName Grade AttPrmCode AttPrmDate IF AttPrmCode > ' '
Students who have an attendance permit Remember the codes have to inputted inorder to get them queried out. This is very helpful in finding out who is on a caregiver affidavit, Declaration of Residence or Transfer.
5. ASTU LastName FirstName MiddleName Grade Gifted if Gifted = X
To find the students who are tagged as a gifted students
Changing the word Gifted to Retained, Autodial, Homeless, PEWaiver will give who has been tagged with this information.
6. ASTU LastName FirstName MiddleName Grade MiltryServ IF MiltryServ = Y
or ASTU LastName FirstName MiddleName Grade MiltryServ IF MiltryServ >
Lists students who have been tagged with giving the services information on themselves.
The filename MiltryServ can be substituted with EmerCard, Alert, CompAUP to find out who has information in these areas.
7. ASTU LastName FirstName MiddleName Grade IF FirstName : Joe
Will list any student whose name contains Joe in it.
8. ASTU LastName FirstName MiddleName Grade InstSet if InstSet = 'N'
Will give a listing of students tagged NSH Substituting the N with S will give the SH students.
9. ASTU LastName FirstName MiddleName Grade RSP if RSP = Y
Will give a listing of students tagged RSP
10. ASTU LN FN GR BD IF BD = 010101
Gives you all the kids with this birthdate.
11. ASTU LN FN GR BD IF BD > 010101 AND BD < 050401
Give you all the kids with a birthdate in the date range.
ASTU ATCH PermNum 1,LastName 1,FirstName 1,MiddleName Birthdate 1,Gender Grade 1,Telephone MailAddr City State ZipCode ResAddr ResCity ResState ResZipCode OrigYrGrad AbbrevName
Data information on students
12. TOTAL ASTU IF ETHNICCODE = A AND GENDER = M AND GRADE = 09
To get the total for an ethnic code for certain gender and grade level.
13. ASTU AENR EFFDATE PERMNUM LASTNAME FIRSTNAME IF EFFDATE = ' '
To find students without an effective date.
Fee Queries:
1. PRINT ASTU AFEE LastName \ FirstName Grade FeeDesc FeeAmount $ Balance IF Balance > ' '
This has to be used as a PRINT then click on preview above the DO button to see the results.
Will give you a listing of Students what they owe and how much they owe.
This is only for active students Clicking the inactive button will include those who are no longer active at your site.
2. ASTU AFEE ACLS AMST ID UF LN FN GR BALANCE ROOM BEGPERIOD IF BEGPERIOD = 06 AND BALANCE > '0.01' BY ROOM
Another query that will list students by a certain period and they have a balance greater than a penny.
3. ASTU AFEE id ln fn gr feebal if grade = 12 and feebal > 0
Who has a fee balance
1. Change ASTU NextSchool = 123 IF Grade < 06
This will mass change all the students in your site to your school code for the next school year except the 6th graders. This can be used at high school and middle also just change the grade to 12 or 08.
Then you can go back and change those few that will not be returning to your site.
2. Change ASTU NextGrade = '08' IF Grade = '07'
This will mass change all the students in your site to the grade level for the next school year.
3. ASTU LastName FirstName Grade MailAddr City NextSchool IF Grade = '05' SORT City
List the 5th graders and the site for next year
4.
CHANGE - ASTU
NextSchool = '500' if Grade < 12
This
change query will change the entire school except the last grade level in your
school.
Replace
the 500 with your site number
Replace
the 12 with the highest grade level in your school.
5.
CHANGE
- ASTU NextSchool = '500' if Grade
= 06
This
change query will change just this grade level to that school number for next
year.
Replace
the 500 with your site number
Replace
the 06 with a grade level in your school.
REMEMBER DO NOT CHANGE THE NEXTSCHOOL OR NEXTGRADE
FOR 12th graders.
6.
CHANGE
- ASTU
NextGrade = 11 IF GRADE = 10
This
change query will change the tenth graders to eleventh graders in the nextgrade
field only.
Replace
the numbers to represent the correct
grade level s for the various grades.
7. Display - ASTU LastName FirstName Grade NEXTSCHOOL IF NEXTSCHOOL =
This Query will give you a listing of students who are not marked with a next school of attendance.
This Query will give you a listing of students who do not have a next grade marked.
9. Display - ASTU LastName FirstName Grade NEXTSCHOOL IF NEXTSCHOOL = XXX
This Query will give you a listing of students who have been tagged for a particular school. Enter the appropriate school code in place of the XXX.
10. Display - ASTU LastName FirstName Grade NEXTGRADE IF NEXTGRADE = XX
This query will give you a list of students with the requested grade level. To select a grade level replace the XX with the two-digit grade level desired.
You may print, keep, skip or export the resulting query information in
addition to displaying it.
Basic Scheduling Queries
1. DISPAY ASTU ACLS AMST 1,StuLink LastName FirstName IF BegPeriod < 01 AND BegPeriod <> 00
Click SHOW EMPTY RECORDS on bottom left
This query will list students who do not have a schedule
2. ASTU ASCH ACLS AMST LN FN COURSE CRSTITLE BEGPERIOD ROOM TCHNAME SCHOOLNUM NAME IF COURSE IN [51000, 15000, 15170, 91500, 91000]
List of students who have taken one of the courses in the brackets. These are math courses.
3 ASTU ACLS AMST ID LN FN GR CRSTITLE BegPeriod TchName Room IF Course > '6200' AND COURSE < 6559 by tchname begperiod
List of students in a particular course area with teacher and period and room number. This is a great one for Picture people.
4. ASTU ACRS ID EC GN GR ENGPROF Title IF TITLE : 'ALG 1' AND GR = 09 SORT by GN EC Engprof
Who is enrolled in Algebra 1 and in grade 9 with English Prof., Ethnic code and gender sorted by each area
5. ASTU AENR 2,Status LN UF FN GR EnterDate LeaveDate TransYear IF TransYear : 03 AND EnterDate > 082701
Who enrolled after a certain date in a certain school year. And whether the student is active or not.
6. ASTU AENR ACLS AMST ID UF LN FN GR Room TchName 2,TchNum IF TRANSYEAR = '03
7. ASTU ACLS AMST LastName FirstName GR ID TCHNAME BEGPERIOD IF CRSTITLE : PHYS SORT BEGPERIOD SORT TCHNAME
LIST
TO FIND ALL KIDS BY PERIOD BY TEACHER and a course with PHYS in the title.
8. ASTU ACLS AMST LASTNAME FIRSTNAME GRADE SECTIONID COURSE CRSTITLE \\ TCHNUM TCHNAME ROOM IF CRSTITLE :'ENG' AND GRADE = 10 AND TCHNAME = 'BUFORD'
9. ASTU AENR 2,SchoolNum TransYear GR OrigEntDt LeaveDate ID LN FN IF 2,SCHOOLNUM = 360 SORT GR OrigEntDt LeaveDate
10. SKIP ASTU ACLS AMST IF BEGPER : 01 AND TERMCODE IN [YR.S1]
Skipping students who have a 1st period in order to find out who doesnt
Period Attendance
6 ASTU AATP ID PERIODDATE ALLDAYABS $2 IF ALLDAYABS : 'C' AND $2 > '5'
7 PRINT ASTU AATP PermNum PeriodDate AllDayAbs $2 IF AllDayAbs : 'C' AND $2 > '5'
Who has more than 5 days of Cut or Unexcused absences.
8 ASTU AATP ID AbsDate AbsCode1 IF AbsDate = 121203 AND ABSCODE1 = 'A'
Who has an unverified absence on Dec 12, 2003.
9 Display ASHA STARTDATE STOPDATE SHEETNUM PERIOD COURSE TCHNUM IF STARTDATE > DATE (DATE RANGE YOU NEED 050101)
To find the sheet numbers for attendance in a specific date range.
10 ASTU AATP LastName FirstName Grade AbsDate AbsCode1 IF AbsDate > 083003 AND AbsDate < 100103 AND AbsCode1 = 'S'
Who was suspended during the month of September.
Daily Attendance
11. ASTU AATD AATR \ PERMNUM LASTNAME FIRSTNAME ABSDATE CODE ABBREV IF ABBREV = C
Replace the C with the code you need. The \ puts a line break after each different perm number.
12. ASTU AATP ID AbsDate AbsCode1 IF AbsDate = 121203 AND ABSCODE1 = 'A'
Who has an unverified absence on Dec 12, 2003.
13. ASTU AATP LastName FirstName Grade AbsDate AbsCode1 IF AbsDate > 083003 AND AbsDate < 100103 AND AbsCode1 = 'S'
Who was suspended during the month of September.
1. ASTU ACHS ID UF Course CRSTITLE Mark 2,CredEarned 2,Grade IF 2,Grade > 08 AND 2,Grade < 11 AND Course = 5240 AND MARK < D
Students who have earned a grade high than a D for a particular course. Also, shows their credit earned.
2. ASTU ACHS ACRS \ 1,PermNum LastName FirstName EthnicCode Gender CrsTitle CollArea1 $ 2,CredEarned Mark if CollArea1 in [A..F] and LeaveCode = W6 and Mark < "D" sort EthnicCode sort Gender sort LastName sort CollArea1
Students who have graduated and have a mark higher than a D with the College area 1 and their credit earned.sorted.
3. ASTU ACHS 2,CredEarned = '2.50' IF MARK = 'F+' AND SCHLYEAR = '2003' AND CALMONTH = 1
Changing the credit earned for a student who earned an F+ in a course.
3. ASTU AGRD AGRL ID UF COURSE MARK IF COURSE : '5100' AND MARK < 'C' AND GR = 09 AND MARK <> ' '
Who received a C or better in Algebra that is in the 9th grade.
4. ASTU AGRD AGRL ATCH 1,StuLink ID LN FN COURSE MARKNUM MARK TCHNUM AbbrevName IF MARKNUM IN [0,1,2..3] AND 2,SQ = 3,SQ SORT TCHNUM
Shows all marks so a comparison can be made.
5. ASTU ACLH INCLGRADE = 'NO' IF INCLGRADE > ' '
Change query for those students who have dropped a course and do not need to be included in a grade reporting period. Should be ran before setting the deck for report cards/progress reports.
12. ASTU PERMNUM LASTNAME FIRSTNAME GRADE CURGPA1 IF CURGPA1 > 3.99
Who has a GPA of higher than 3.99 for 1st quarter.
1. CHANGE APRF Pass/Fail = P if Testlink =
(the number you need to change) and stulink = (ie 14371)
To change a student from F to P in the Profiency area.
2. ASTU APRF APRD ID LN FN GR 2,TestLink PassFail IF PASSFAIL = ' ' AND 2,TestLink = 7
Who passed a certain test
4. ASTU ADIS ADPO LN FN REPORTDATE 3,DISCODE DISPDAYS IF DISDAYS < 1
Who has a discipline action.
5.
ASTU
ADIS ADPO PermNum LastName FirstName
Grade 3,DispCode 3,DispStrtDt 3,DispEndDt
3,ActionBy 3,DispDays IF 3,DispCode |- 'S-' AND 3,DispStrtDt > 090102 AND 3,DispStrtDt < 100102
Remember to click inactive at the bottom
Lists who has a Suspension in the system what for, who did it and when
6. ASTU ADIS ADPO PermNum LastName FirstName Grade ReferredBy ReferDate 3,DispDesc SORT ReferredBy
Course
History
1. AMST LowGrdRest HiGrdRest SC BegPeriod SectionID \ course TermCode CrsTitle $ TotStus[0] MaxClassSz IF LOWGrdRest > 08 AND SchoolNum IN [352,354,360,362,364,211] AND TermCode <> 'S1' SORT COURSE
Changing Credit in Course History atom if incorrect.
2. ASTU ACHS 2,CredAtmpt = 5.00 IF 2,CredAtmpt = 2.50 AND CalYear = 2004
3 ASTU ACHS 2,CredEarned = 5.00 IF 2,CredEarned = 2.50 AND CalYear = 2004
4 ASTU ACHS 2,CredEarned = 2.50 IF 2,CredEarned = 1.25 AND CalYear = 2004
5 ASTU ACHS 2,CredAtmpt = 2.50 IF 2,CredAtmpt = 1.25 AND CalYear = 2004
Key Code
ID = PERMNUM
LN = LASTNAME
FN = FIRSTNAME
GR = GRADE
EC = ETHNIC CODE
GN = GENDER
BD = BIRTHDATE
NS = NEXT SCHOOL
NG = NEXT GRADE
UF = UNIQUE FIELD
SC = SCHOOL NUMBER
LD = LEAVE DATE