Skyward Data to Excel

Skyward Data to Excel

2021 TSUG

Presenter : Maria Aguilar Galena Park ISD

maguilar@

Documentation by: Sue Pike Deer Park ISD

Skyward Data to Excel

Some basic data mining reports that I send to Excel include: ---checking the Advanced and Retained fields ---making sure the grad year fields match for 8th grade and below ---checking the Default Entity field ---checking the TX Honor Roll field at the junior highs

Excel thought ---auto-size the columns and use the Filter option

2

CY and NY fields I monitor these fields constantly during the spring semester to make sure that the NY status field reflects the correct next year status for that student at that entity. The excel thought is multiple filters

3

Replace All feature in Excel 4

Running a check against the Advisor field and Homeroom field....compared to the Schedule is a useful report that uses the SORTing feature Run the data mining report using the excel button......sort the file by CY Teacher and then by Advisor field Then scroll down the report to make sure those "chunks" of names match

5

Sorting information by CELL COLOR 6

You can also FILTER BY COLOR Similar to the Sort By Color idea but it uses the Filter feature instead Which one to use will depend on how you need to "see" your data at the end

7

Another data check task that I look at is the School Email field I check the school email field for incorrect email format.....not "@"

8

 ................
................

In order to avoid copyright disputes, this page is only a partial summary.

Google Online Preview   Download