Please use this article as a supplemental resource for this DAT Webinar:
https://youtu.be/O6-Hk12ZG0Y
  
1. Intro
    a.  Discuss the basics of building Attendance queries.  Send emails to support@pcreducator.com for suggestions.   link
    b.  The Data Analytics Tool (DAT) is a comprehensive system for creating on-the-fly filters, exports, dashboards, mail merges, emailing, queries and reports supporting advanced database concepts with left joins, logical conditions, aliasing, aggregates, pivots, predefined reports, parameterization, and flexible security access. link
    c.  DAT Query considerations link
        i. Plan what information will be extracted. 
        ii. Plan a workflow on what tables to use in the DAT - Attendance Data Structure  link
            a. Tables in the DAT - Attendance Data Structure 
                i.  Primary Tables: Students, Courses, Teachers link
                ii.  Supporting Tables  link
                iii. Red box / key fields explanation to avoid DAT Filter Common Mistakes link
                        - School Id field link
                        - Record Type field link
                        - School Year field link
            b. Tables in the DAT - Check In / Check Out Data Structure link
            c. Tables in the DAT - Lunch Choices Data Structure link
            d. Student “Statuses by Division” DAT Filter Common Mistakes link
            e.  Finding School Id on the Home page link
2.  Modify "[Admin] Attendance Details" to show: all students who were absent in the past week link
    a. “PCR Imported” category standard reports link
    b. Accessing DAT Query "[Admin] Attendance Details" link
        i. Review the report DAT Query - Step 1 link
        ii. Review the DAT - Attendance Data Structure link
        iii.  Add a DAT Field Condition on school id for Daily Attendance link
            a. Plus vs Link link
            b. School Division DAT Functional Operator link
            c.  Add school id as a DAT Parameterized Condition link
        v.  View Results.  Demonstrate changing parameter on DAT Results - Step 4 link
        vi.  Remove “Grade Level” table link
        vii. DAT Fields - Step 2 - Sorting link
        viii. DAT Column Order - Step 3  link
        ix. Remove “Grade Level Int” on DAT Query - Step 1 - Selecting Display Fields link
        x. DAT Results - Step 4  link
        xi. Change school id parameter link
        xii. Change report to show Occurrence Date in The Last 7 Days link
            a. Add DAT Functional Operator condition for The Last 7 days link
        xiv. Reorder results by date on DAT Fields - Step 2 - Sorting link
        xiii. DAT Results - Step 4 link
   c. DAT Save - Step 6 saving a standard query link
        i. Choose a different query group link
        ii.  Choose roles for the query link
            a. Role considerations for query link
3.  Teachers who haven't taken period attendance yet (today) link
    a. Accessing DAT Query "[Admin] Period Attendance Not Taken" link
        i. Review the report on DAT Query - Step 1 link
            a. Explanation of “With or Without” in DAT Query - Step 1 - Connecting Tables link
        ii. Review the DAT - Attendance Data Structure link
        iii.  Add a DAT Field Condition for Courses.  Use the DAT Functional OperatorSchool Division” to specify Upper School.  link
        iv.  Add a DAT Field Condition on rotation date using DAT Functional Operator “Today” link
        v. DAT Results - Step 4  link
        vii. Change date display format on DAT Fields - Step 2 - Customizing Display Fields Appearance link
        viii. DAT Results - Step 4 link
   b. DAT Save - Step 6 saving a standard query link
        i.  Choose roles for the query link
        ii. Name the query link
        iii. Choose a different query group link
        iv. Optional query description link
    c. Add DAT Dashboard Element using a DAT Grid widget link
    d. Change report to show how many times teachers haven’t taken period attendance link
        i. Edit report DAT Query - Step 1 link
        ii. Change rotation date condition using the DAT Functional Operator “The Next” 0 Days. link
        iii. Remove unnecessary tables and columns. link
            a. Keep link to courses but include no columns  link
        iv. DAT Results - Step 4 link
        vi. DAT Fields - Step 2 link
            a.  Count Distinct on Rotation Date using DAT Fields - Step 2 - Aggregating  link
            b.  Alias to Total on Rotation Date using DAT Fields - Step 2 - Customizing Display Fields Appearance link
            c. Why Count Distinct instead of Count?  link
        vi. Change sort order for descending total DAT Fields - Step 2 - Sorting link
        vii. DAT Results - Step 4 link
            a. Value of including DAT Key Id Field columns: teacher id link
                i. View Dashboard link
                ii. Select All link
        viii. DAT Column Order - Step 3 versus DAT Fields - Step 2 - Sorting order link
   d. DAT Save - Step 6 saving a standard query   link
        i. Update versus Save New link
3.  Creating New DAT Query “Discipline point totals per student” link
    a. Review the DAT - Attendance Data Structure link
        i. Add Student Info and student fields using DAT Query - Step 1 - Connecting Tables and  DAT Query - Step 1 - Selecting Display Fields link
        ii. DAT Query - Step 1 - Connecting Tables Periods Attendance and Discipline link
        iii. DAT Results - Step 4 link
            a. Discussion on Discipline Points and how they may be used link
            b. Discussion on totalling link
        iv. Remove the unnecessary fields DAT Query - Step 1 - Selecting Display Fields link
        v. Add sum DAT Fields - Step 2 - Aggregating link
        vi. DAT Column Order - Step 3  link
        vii. DAT Results - Step 4 link
        viii. DAT Query - Step 1 - Adding Conditions, limit students using Status By Division DAT Filter Common Mistakes link
4. New Report “Discipline points by month” - statistics report.  A demonstration of data mining statistics. link
    a. Creating New DAT Query link
        i. Review the DAT - Attendance Data Structure link
        ii. DAT Query - Step 1 - Choosing Initial Table Period Attendance and Discipline  link
            a. DAT Query - Step 1 - Selecting Display Fields link
        iii. DAT Results - Step 4 link
        iv. Discussion of Unique Rows versus All Rows on DAT Fields - Step 2 - Uniqueness link
        v. DAT Query - Step 1 link
            a. Add multi-select condition for all 12 months.  Only months where data actually appears can be added in the condition.  DAT Query - Step 1 - Adding Conditions link
            b. DAT Query - Step 1 - Adding Conditions for discipline points <> 0.  link
            c. Remove unnecessary columns DAT Query - Step 1 - Selecting Display Fields link
        vi. DAT Fields - Step 2 - Pivoting for the Sum of Discipline Points. link
        vii. Discuss DAT Results - Step 4  link
    b. Discussion of other possible variations of the report link
5. Creating New DAT Query “Lunch Choices for Today” link
    a. Overview of the DAT - Lunch Choices Data Structure  link
    b. Creating New DAT Query link
        i. Review  the DAT - Lunch Choices Data Structure link
        ii. DAT Query - Step 1 - Choosing Initial Table “Lunch Choices” link
        iii. DAT Query - Step 1 - Connecting Tables “Lunch Choice Options” link
            a. Remove automatic DAT Field Condition for School Id link
        iv. DAT Query - Step 1 - Connecting Tables “With or Without” to “Student Info” link
        v. DAT Query - Step 1 - Connecting Tables “With or Without” to “Teachers” link
        vi. DAT Results - Step 4 link
        vii. DAT Fields - Step 2 - Customizing Display Fields Appearance link
    c. Change report to “Lunch Choice Counts for Today” link
        i. DAT Query - Step 1, remove links Student Info and Teachers link
        ii. DAT Fields - Step 2 - Aggregating count of the Lunch Choice Option Id link
        iii. DAT Fields - Step 2 - Sorting and DAT Column Order - Step 3 link
        iv. Discuss DAT Results - Step 4 link
6. Creating New DAT Query “Checked In but not Checked Out” link
    a. Overview of the DAT - Check In / Check Out Data Structure  link
    b. Creating New DAT Query  link
        i. DAT Query - Step 1 - Choosing Initial Table “Student Info”  link
        ii. DAT Query - Step 1 - Connecting Tables “Check In / Check Out” link
            a. DAT Query - Step 1 - Adding Conditions for Check In Time (a mistake, should be Check Out Time) using the DAT Functional Operator “Is Blank” link
            b. Add condition for Program Type link
            c. Correct the condition to use Check Out Time link
        iii. DAT Results - Step 4 link
        iv. DAT Fields - Step 2 - Customizing Display Fields Appearance for the date link
        v. DAT Column Order - Step 3  link
        vi. DAT Results - Step 4 link
        iv. DAT Fields - Step 2 - Customizing Display Fields Appearance for the time link
        v. DAT Results - Step 4 link
        vi. DAT Save - Step 6 link
7. Webinar Summary link
 
PCR Educator K-12 School Information System is an online database engineered for independent and private schools to deliver the highest level of flexibility, unique experience, transparent communication and customized design. Being a complete cloud-based solution, PCR Educator system guarantees convenient access anytime, anywhere.