Decision Support a Broward Public Schools by e7Yn2wA

VIEWS: 5 PAGES: 38

									                   Reporting
                   at
                   Broward Public Schools

Jeff Stanley                      Ray Santos
Director of School Applications   Sr. Rapid Application Development Analyst
Jeff.stanley@browardschools.com   Ray.santos@browardschools.com
From Data to Information



    Maintenance




                           2 of 38
Movement of Data


             2
                                             3
     Data Warehouse
                                    Virtual Counselor
      Data migrated
    real time or nightly            Reads DWH and
                                 Updates TERMS tables



                           1

                       TERMS

         Schools enter student information

                                                        External Sources

                                                                           3 of 38
UPDATES to DWH

   Real-Time                 Nightly
     Student                   All
                                   other student tables
     Master Schedule           HRMS
     Student Schedule          Maintenance
     Student Absence
     Course
     Assignment History
     Academic History
     School Staff
     Student Contact

                                                          4 of 38
Ways to Get Information
                              Live Reports




Input / Output



             Static Reports
                                         5 of 38
The Data Warehouse Web Site




             web/dwh/
                              6 of 38
DWH Reports




              7 of 38
DWH Reports

 Static Reports
 Provided by many departments to be
  reported to schools
 Some DWH reports that are needed ‘As Of’
  a specific date




                                         8 of 38
School Reports Menu Sign In




                              9 of 38
Group & Role Level Security




                              10 of 38
Signons to Virtual Counselor
         & School Reports Menu
   All SBBC personnel must be in the
    Broward Schools personnel file




                        BROWN, MARY




                                        11 of 38
Signons & Passwords

 Protect your signon and password
 Do NOT share your Signon
 Signons are available to everyone
  upon request to DWHMail
 You are associated with everything run
  under your Id



                                           12 of 38
School Reports




                 13 of 38
Different Folders

 Folders have different
  reports available
 Each Report has many
  variations




                           14 of 38
Specific Guidance Folder




                           15 of 38
Guidance Reports – GUII001




                             16 of 38
Detail Reports




                 17 of 38
Graphic Reports




                  18 of 38
Select Criteria




                  19 of 38
Summary Reports




          GARCIA, JUAN




          MILLER, JOANNE




          MOUSE, MICKEY




                           20 of 38
Virtual Counselor




                    21 of 38
Initial Search Options for Guidance


                  JOHN SMITH!




                                      22 of 38
SEARCH FOR GROUP OF STUDENTS
by GRADUATION INDICATORS




                               23 of 38
Select Teacher & Class




                         24 of 38
Select Guidance Intervention Input



               JONES, MARK




                                     25 of 38
Intervention Input




                     KENT, CLARK




                                   26 of 38
Select an Intervention Code




                              27 of 38
Interventions




                28 of 38
Intervention Codes to Submit




                               29 of 38
Check Students to Select




                   KENT, CLARK




                                 30 of 38
Virtual Counselor Web Interface
for Parents and Students




                                  31 of 38
High School Grades on the Web




                                32 of 38
AGP




      33 of 38
      Student Scheduling Overview
Online Course Scheduling
                    Define School Parameters                 Step 1: School defines course dictionary
                                                                     and scheduling parameters.
    Define School Course Dictionary Restrictions
                  a) by grade level
                     b) by pairs                             Step 2: Setup default course
    Define School Course Dictionary Restrictions                     recommendations for students.
                  a) by grade level
                     b) by pairs
      ETS Defaults Student Subject Area Level                Step 3: Teachers make modifications to
                                                                     recommendations.
                 Teacher Recommendations
           ETS Defaults Student Subject Area Level
                         a) by course
              b) by level (AP, Honors, Regular)
                                                             Step 4: Students complete online course
                 Teacher Recommendations
                                                                     request screen.
                         a) by course
           Students enter (AP, Honors, Regular)
              b) by level course selections online.          Step 5: Counselor approves student
                                                                     selections.
           Students enter course selections online.
                Guidance Counselor Approval schedules
                                        Student
                                                             Step 6: Course requests transferred to
Requests
 Student
 Course




                                          generated via
                                       scheduling program
                                      (BS0506U / BS0511U).           TERMS.
                                        Student schedules
Requests




                       AS400
 Student
 Course




                                          generated via
                                       scheduling program
                                                             Step 7: Reports and downloads
                        AS400
                                      (BS0506U / BS0511U).
                                                                     from School Reports Menu
                                                                                                  34 of 38
Help

   All problems should be directed to the
    Customer Service Desk: 754-321-0411
     Network
     Printing
     Passwords  & signons
     No Data to Process

   Requests for changes to reports or new
    reports should be directed to DWHMail

                                             35 of 38
FAQs




       36 of 38
Virtual Counselor Handout Available




  Download
   & Print

                                      37 of 38
                   Reporting
                   at
                   Broward Public Schools

Jeff Stanley                      Ray Santos
Director, School Applications     Sr. Rapid Application Development Analyst
Jeff.stanley@browardschools.com   Ray.santos@browardschools.com

								
To top