EXPORT AND GRAPH LOG ENTRIES. Presented By Lynne McCoy Bryan County School District. CREATING THE EXPORT. Two Points of Access: Start Page>Special Functions>Search Log Entries Start Page>System>Direct Database Export(DDE) The simplest is Special Functions>Search Log Entries.
Bryan County School District
Two Points of Access:
Start Page>Special Functions>Search Log Entries
Start Page>System>Direct Database Export(DDE)
The simplest is Special Functions>Search Log Entries
Using consistent methods for entering log entries enables you to make better use of the specific search fields available on this screen. For example: if your subtype groups are only two categories – State Reportable and Non-State Reportable, this would allow you to pull only the state reportable log entries. If you want all log entries, use the date fields.
The log entry result screen will show you the number of log entries that meet the selected criteria and then provide options for what you want to do with that selection of records.
List Log entries will print to the screen all log entries and show the entry date, subtype code, student name (as a link), author’s name, title and contents of the Log Entry text box.
Print a report opens a print option screen for you to select the report you want to print, for which students and basic output options. The reports in this list are previously created object reports.
Click the Quick Export Link to open the Quick Export field entry box just as you find on every PowerSchool export screen. The “Fields” link is available, but unlike other field list, this list includes the fields which populate the log entry screen along with the student table fields.
The saved text file may be opened by right Clicking on the unopened file and choosing “Open With” and selecting excel.
Step 5 – The Create Pivot Table and Chart dialog box appear to indicate the range of data which has been selected and will be available in the chart; also provides the step to indicate where in the workbook you want to place the chart – on the same page as your source data or on another worksheet.
For Discipline Data Listing which contains much data, the chart is best viewed on a separate worksheet, which is the default settings for this dialog box.Click ok and a new sheet opens with the tools available to arrange your chart.
Select stuid for the values – and set value setting to “Count” – this will count the number of entries for each category
Click the box to add the fields you want in the table and then drag the fields to the areas below the field list to indicate where the field is to appear in your chart