Difference between revisions of "SoCal Meeting31 Jan 20, 2023"

From California PowerSchool User Group
Jump to: navigation, search
(Sponsor)
 
(19 intermediate revisions by 2 users not shown)
Line 12: Line 12:
 
1401 West Valencia Drive<br>
 
1401 West Valencia Drive<br>
 
Fullerton, CA 92833
 
Fullerton, CA 92833
 +
 +
While in-person attendance provides the best experience, if you can only attend virtually, that option is still available.
  
 
== RSVP ==
 
== RSVP ==
[https://forms.gle/V4FqB2Enq95gQc9k7 Please use this form to RSVP] by Tuesday, January 17, 2023 and make sure to select if you are going to be attending in person or virtually.
+
[https://forms.gle/ifJysE299BZ6Cr757 Please use this form to RSVP] by Tuesday, January 17, 2023, and make sure to select if you are going to be attending in person or virtually.
  
 
== Sponsor ==
 
== Sponsor ==
 
Sponsor: Marcia Brenner Associates
 
Sponsor: Marcia Brenner Associates
 
* [https://mba-link.com/ mba-link.com]
 
* [https://mba-link.com/ mba-link.com]
* MBA will share a variety of plugins they have for PowerSchool, including free plugins anyone can use
+
* Raelyn Wallock from MBA will share a variety of plugins they have for PowerSchool, including free plugins anyone can use
  
 
== Agenda ==
 
== Agenda ==
*'''Showcase the Cross-Site Scripting Error tool by Adam & Vance & others'''
 
** [https://support.powerschool.com/exchange/view.action?download.id=1195 Cross-Site Scripting Detector Plugin on PowerSource] - This free plugin by Adam Larsen at [https://www.auroraedtech.com Aurora Educational Technology] helps debug Cross-Site Scripting errors that commonly occur when saving changes to Object Reports, Form Letters, or Report Cards.
 
*'''Power Query DAT Tags'''
 
**The new PowerQuery DAT feature includes a new DAT for exporting email, and the ability for users to build their own DATs! We're going to be introducing this significant new tool, including how it can be used to generate multiple rows and help you build better reports.
 
***[[PowerQueries|PowerQuery DAT Resources]] Handout, link to the PSUG CAL built Grades and Attendance DAT, and other examples.
 
*'''PowerSchool Cybersecurity: Process Overview of  two factor authentication'''
 
**[[Media:Single_Sign-On_SSO_for_PowerSchool.pdf|SSO via OIDC through Google or Azure Handout]] - Overview of how SSO via OIDC with Microsoft Azure or Google works. Includes a query to identify students who need their Global ID updated.
 
**[[Media:SSO_Global_ID_Missing_Mismatched_sqlReport.txt.zip|sqlReport to find missing or mismatched Global IDs]] - unzip this file then open the txt contents and copy/paste in sqlReports setup to import this report that can help you keep your Global IDs up-to-date.
 
**Google or Azure
 
 
*'''CALPADS RoundTable'''
 
*'''CALPADS RoundTable'''
**Fall 1 changes
+
**Fall 2 changes/issues
**PowerSchool SSID Import Tool
+
**Transitional Kinder Grade Level
**MID Resolution
+
**New Attendance by Summary Grade Level Report
**SINF Import File Management
+
*'''MBA Plugins'''
*'''Schedule Next Meetings'''
+
**Raelyn Wallock from MBA will present plugins that enhance PowerSchool, including an amazing Report Creator, Alert Creator, and free plugins
 +
* '''PowerQuery DATs Part 2'''
 +
** Review PowerQuery DATs introduced in October (Current Grades and Attendance)
 +
** Introduce a new School Entry Date DAT
 +
** Take suggestions live for creating new ones
 +
** During our meeting we added a District Entry Date option. The updated plugin  [https://support.powerschool.com/exchange/view.action?download.id=1199 is now available on PowerSource]
 +
***''Note: The table format bug during the presentation was due to a line break. For the table tag to work, it must all be one one line!''
 +
*'''Misc Topics'''
 +
** How to mass delete Contacts with no associated students
 +
***[[Media:Delete_Contacts_with_no_associated_students.pdf|Mass Delete Student Contacts Handout]]
 +
** Uploading and maintaining documents in PowerSchool - the stock feature demonstrated and mention of alternatives
 +
***[[Media:PowerSchool_Document_Attachments.pdf|PowerSchool Document Attachments Handout]]
 +
** Preventing Duplicate Students with the Enable Duplicate Student Check setting
 +
***Helps prevent the creation of duplicate students through the UI, via import or even from API integrations
 +
***Not 100% perfect, sometimes parents will enter DOB or names differently. But greatly reduces duplicates.
 +
***District -> (District Information) Miscellaneous
 +
***Recommended settings:
 +
****Enable Duplicate Student Check: First Name, Middle Name, Last Name, Date of Birth, Gender
 +
****Enable Duplicate Student Check Strict Matching (all fields must match): OFF (not checked)
  
 
== Driving and Parking Instructions ==
 
== Driving and Parking Instructions ==

Latest revision as of 17:02, 20 January 2023

Join us at the Southern California PowerSchool User Group Meeting

Date and Time

Friday, January 20, 2023
9:00AM to 2:00PM PT
Continental Breakfast available at 8:30AM

Location

Fullerton School District
Educational Learning Center (ELC)
1401 West Valencia Drive
Fullerton, CA 92833

While in-person attendance provides the best experience, if you can only attend virtually, that option is still available.

RSVP

Please use this form to RSVP by Tuesday, January 17, 2023, and make sure to select if you are going to be attending in person or virtually.

Sponsor: Marcia Brenner Associates

  • mba-link.com
  • Raelyn Wallock from MBA will share a variety of plugins they have for PowerSchool, including free plugins anyone can use

Agenda

  • CALPADS RoundTable
    • Fall 2 changes/issues
    • Transitional Kinder Grade Level
    • New Attendance by Summary Grade Level Report
  • MBA Plugins
    • Raelyn Wallock from MBA will present plugins that enhance PowerSchool, including an amazing Report Creator, Alert Creator, and free plugins
  • PowerQuery DATs Part 2
    • Review PowerQuery DATs introduced in October (Current Grades and Attendance)
    • Introduce a new School Entry Date DAT
    • Take suggestions live for creating new ones
    • During our meeting we added a District Entry Date option. The updated plugin is now available on PowerSource
      • Note: The table format bug during the presentation was due to a line break. For the table tag to work, it must all be one one line!
  • Misc Topics
    • How to mass delete Contacts with no associated students
    • Uploading and maintaining documents in PowerSchool - the stock feature demonstrated and mention of alternatives
    • Preventing Duplicate Students with the Enable Duplicate Student Check setting
      • Helps prevent the creation of duplicate students through the UI, via import or even from API integrations
      • Not 100% perfect, sometimes parents will enter DOB or names differently. But greatly reduces duplicates.
      • District -> (District Information) Miscellaneous
      • Recommended settings:
        • Enable Duplicate Student Check: First Name, Middle Name, Last Name, Date of Birth, Gender
        • Enable Duplicate Student Check Strict Matching (all fields must match): OFF (not checked)

Driving and Parking Instructions

Click here for directions

Parking

All parking areas designated as "Parking" are open parking. The parking spaces directly in front of the main office entrance posted as visitor or limited-time parking should not be used.

Fullerton Parking Map