Denver Public Schools
Infinite Campus Training
Reports


DPS IC Ad Hoc Library Catalog

Microsoft Mail Merge Labels QR Guide
Ad Hoc Filter QR Guide

Adhoc Library Query for Web Page 10-10-07
Location Name of Ad Hoc Comments Approved
m ES Ad Hoc Library Active Only All Grades Filter that lists up only active students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 00 Filter that lists up only Grade 00 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 01 Filter that lists up only Grade 01 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 02 Filter that lists up only Grade 02 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 03 Filter that lists up only Grade 03 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 04 Filter that lists up only Grade 04 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade 05 Filter that lists up only Grade 05 students in a school, excludes inactive students Yes
m ES Ad Hoc Library Active Only Grade EC Filter that lists up only Grade ECE students in a school, excludes inactive students Yes
m ES Ad Hoc Library Master List For Labels Export list used to create mailing labels using mail merge in Microsoft Word Yes
m ES Ad Hoc Library Student Registration Both Exports list that shows students information in the Student Verification Form Field and the Registration Date field on the School Owned tab Yes
m ES Ad Hoc Library Student Registration Form Export list that shows students information if they have information in the Student Verification form field on the School Owned tab. Yes
m ES Ad Hoc Library Student Registration Missing Export list that shows students who have no information in the Student Registration field on the School Owned tab Yes
m HS Ad Hoc Library HS Active Only All Grades Filter that lists up only active students in a school, or schedule structure, and excludes inactive students Yes
m HS Ad Hoc Library HS Active Only Grade 09 Filter that lists up only Grade 09 students in a school, excludes inactive students Yes
m HS Ad Hoc Library HS Active Only Grade 10 Filter that lists up only Grade 10 students in a school, excludes inactive students Yes
m HS Ad Hoc Library HS Active Only Grade 11 Filter that lists up only Grade11 students in a school, excludes inactive students Yes
m HS Ad Hoc Library HS Active Only Grade 12 Filter that lists up only Grade 12 students in a school, excludes inactive students Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = AB Filter for last names that begin with A and B Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = CD Filter for last names that begin with C and D Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = EF Filter for last names that begin with E and F Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = GH Filter for last names that begin with G and H Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = IJ Filter for last names that begin with I and J Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = KL Filter for last names that begin with K and L Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = MN Filter for last names that begin with M and N Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = OP Filter for last names that begin with O and P Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = QR Filter for last names that begin with Q and R Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = ST Filter for last names that begin with S and T Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = UV Filter for last names that begin with U and V Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = WX Filter for last names that begin with W and X Yes
m HS Ad Hoc Library HS Sched/RPT CRD Filter Last Name = YZ Filter for last names that begin with Y and Z Yes
m HS Ad Hoc Library Student Registration Both Exports list that shows students information in the October Count Student Verification Form Field and the Student Verification Date field on the School Owned tab Yes
m HS Ad Hoc Library Student Registration Form Export list that shows students information if they have information in the October Count Student Verification form field on the School Owned tab. Yes
m HS Ad Hoc Library Student Registration Missing Export list that shows students who have no information in the October Count Student Registration field on the School Owned tab Yes
m HS Ad Hoc Library Student Registration Date Export list that shows students who have information in the Student Verification Date field on the School Owned tab Yes
m ES Ad Hoc Library ES SB Report Card Label Export Export list of Students Lastname, Firstname, ID Number, Grade, Teacher Name, School Name, Homeroom Course for the purpose of creating Standards Based Report Card Labels. Yes
m ES Adhoc Library Student List w/Grade, Gender, Ethnic, DOB Export Ad Hoc that brings up a list of Students with ID#, Lastname, Firstname, Grade, Gender, Ethnicity, Date of Birth for the active only students. Yes
m ES Adhoc Library ES Directory Class List Export a list of the school's classes, room number, teacher name and each student's, ID, name, household phone number and address. Yes
m ES Adhoc Library ES Directory Info List Export list of student's ID name, grade, the student's guardian name, relationship, phone numbers, email and the household addres Yes
m ES Adhoc Library ES AdeqDocReport Export for all students End Dated with Codes 14, 15 and. The report will show the information that has been entered into the Adequate Documentation fields required for all students End Dated with Codes 14, 15 and 16. Yes
m MS Adhoc Library MS AdeqDocReport Export for all students End Dated with Codes 14, 15 and. The report will show the information that has been entered into the Adequate Documentation fields required for all students End Dated with Codes 14, 15 and 16. Yes
m HS Adhoc Library HS AdeqDocReport Export for all students End Dated with Codes 14, 15 and. The report will show the information that has been entered into the Adequate Documentation fields required for all students End Dated with Codes 14, 15 and 16. Yes
m ES Ad Hoc Library ES Un-Teamed Students Adhoc Export that lists the active students that are not assigned to a team. For Walkin Scheduling purposes. Yes
m ES Ad Hoc Library ES Student List with Correspondence language This export that lists the student number, Last name, First name, Gender, Ethnicity, Grade, Student Correspondence Language for communications to the home, Homeroom Teacher. This can be sorted in Excel by teacher to identify the language the student will get the Standards Based Report Card. Yes
m ES Ad Hoc Library ES First Time in US/CO Questions This export includes Student number, Last name, First name, Grade, US Entry Date, US Entry Grade, Most Recent time in any school in US, Most Recent Grade in any school in US, Most Recent time in a CO public school, Most Recent Grade in a CO Public School. Yes
m ES Ad Hoc Library ES Endstatus = 40 This export lists Student Number, Last name, First name, middle name, Gender, Birthdate, Contact information for students that have a End Status code of 40 (End Schooling, or Dropout). This list can be given to the Social Worker to research where the student is. Yes
m ES Ad Hoc Library Student Registration Date Export list that shows student who have information in the Student Registration field in the School Owned tab Yes
m ES Ad Hoc Library Active Only Filter that lists up only active students in a school, excludes inactive students Yes
m MS Ad Hoc Library MS Active Only All Grades Filter that lists up only active students in a school, excludes inactive students Yes
m MS Ad Hoc Library MS Active Only Grade 06 Filter that lists up only Grade 06 students in a school, excludes inactive students Yes
m MS Ad Hoc Library MS Active Only Grade 07 Filter that lists up only Grade 07 students in a school, excludes inactive students Yes
m MS Ad Hoc Library MS Active Only Grade 08 Filter that lists up only Grade 08 students in a school, excludes inactive students Yes
m MS Ad Hoc Library Student Registration Date Export list that shows students who have information in the Student Verification Date field on the School Owned tab Yes
m MS Ad Hoc Library Student Registration Form Export list that shows student who have information in the Student Registration field in the School Owned tab Yes
m MS Ad Hoc Library Student Registration Both Exports list that shows students information in the October Count Student Verification Form Field and the Student Verification Date field on the School Owned tab Yes
m MS Ad Hoc Library Student Registration Missing Export list that shows students who have no information in the October Count Student Registration field Yes