Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
PCR independent school management solution and website
Products
Admissions & Enrollment
After School Activities
API
Cafeteria & POS
School CRM
Data Analytics & AI
CMS
Donations
Enrollment Management System
Financial Aid Management
Finance & Accounting
Fundraising
Point of Sale
Scheduling
Student Information System
Summer School & Summer Camp
Solutions
K-12 Private and Independent Schools
K-12 Public Schools
Colleges & Universities
Medical Schools
Vocational and Technical Schools
International Schools
Dance and Theater Schools
Youth Programs
Why PCR Educator
Team
Knowledge Base
FAQ
Training and Support
Sign In
Demo
School CRM
Blog
DAT Webinar - Attendance
DAT Webinar - Attendance
DAT Webinar - Attendance
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, 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,
Course
s, 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
Daily Rotation
” table
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
DAT Results - Step 4
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
Course
s. Use the
DAT Functional Operator
“
School 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 Choice
s 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 Choice
s”
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
See also
DAT Fields - Step 2 - Customizing Display Fields Appearance
DAT Query - Step 1 - Selecting Display Fields
DAT Query - Step 1 - Choosing Initial Table
DAT - Check In / Check Out Data Structure
DAT Query - Step 1 - Adding Conditions
DAT Query - Step 1 - Connecting Tables
DAT - Lunch Choices Data Structure
DAT Fields - Step 2 - Aggregating
DAT Fields - Step 2 - Uniqueness
DAT - Attendance Data Structure
DAT Fields - Step 2 - Pivoting
DAT Fields - Step 2 - Sorting
DAT Parameterized Condition
DAT Column Order - Step 3
DAT Functional Operator
Creating New DAT Query
DAT Dashboard Element
DAT Results - Step 4
Accessing DAT Query
DAT Field Condition
DAT Fields - Step 2
DAT Query - Step 1
DAT Save - Step 6
DAT Key Id Field
School Division
Daily Rotation
Lunch Choice
Grade Level
DAT Filter
DAT Query
DAT Grid
Course
DAT
Linkedin
301-947-7380
sales@pcreducator.com
Schedule Demo
Please, make sure that all required fields (marked with *) are completed.
School Name
*
Relation to School
*
select
Administration - Database Manager
Administration - Head of School
Administration - Registrar
Development - Director of Development
Finance - Business Manager
Finance - CFO
IT - Director of Technology
Other - Parent
Other - Staff
Other - Volunteer
Last Name
*
Your First Name
*
Your Email
*
Your Phone #
*
Household
User
PCR Educator School Information System is an online database engineered for schools and universities to deliver the highest level of flexibility, unique experience, transparent communication and customized design.