SKYWARD. Data Mining. Quick Reference Guide

®

Table of Contents

Data Mining

How to Get to Data Mining 1

Filter Reports - All Reports 2

Filter Reports - All My Reports 3

How to Get to Data Mining

From the Skyward Home Page

1. Click the Students button.

2. Click the Student Data Mining button. 3. If the fi lter menu appears:

a. Select All Reports to view all reports in the system.

b. Select All My Reports to view only those reports you have created. c. Click the Apply Filter button.

Filter Reports

All Reports

Lists all reports currently in the system.

1. If All Reports is currently not selected: a. Click the Filter Options button located on the right side of the screen.

b. Select All Reports to view all reports in the system. c. Click the Apply Filter button. 2. You cannot delete or edit someone else’s

report (those buttons are grayed out when you’ve selected someone else’s report). 3. You may clone someone else’s report and

edit it (see pages 11-12 for steps on how to clone a report).

Filter Reports

All My Reports

Lists only those reports you have created.

1. If All My Reports is currently not selected: a. Click the Add Filter button located

on the right side of the screen. b. Select All My Reports to view only

those reports you have created. c. Click the Apply Filter button.

Run an Existing Report

1. Select a report from the list.

2. To preview only the fi rst 10 records of a report, click the Preview First 10 Records button. This is a good way to test before running the entire report.

a. Wait for the report to fi nish processing, and then click the Display Report button.

Note: You’ll get a note on the report noting

that it was aborted. This is normal. 3. To open the report in PDF format, click

the Print button:

a. Wait for the report to fi nish processing, and then click the Display Report button. 4. To open the report in Excel, click the

Excel button:

a. Wait for the report to fi nish processing, and then click the Display Report button. b. Click the Open button.

Create a New Report

1. Click the Add button. 2. Report Information tab:

a. In the Report Name fi eld, type a name for your report. This is the name that shows up in the report list.

Note: Be sure to begin the report name with

your your 3-digit campus number. If you do not do this your report may be deleted.

b. In the Report Title fi eld, type a title for your report. This is the title that shows up on the report heading.

c. Select portrait or landscape for report orientation.

Note: If you create a report with enough

data in it to make a line that’s too long for portrait, it will switch to landscape.

Create a New Report

adding fi elds to a report: Field selection and Field Search.

a. Field Selection button: 1. Select a fi eld area.

2. Double-click the fi eld you would like to add to the report.

Note: Items with a highlighted background

break down into additional fi elds. 3. Repeat steps 1-2 to add all

desired fi elds to the report. b. Field Search button:

1. In the Field Lookup box, type a keyword pertaining to the fi eld you are looking for. Ex. “grade.” 2. This returns a list of all fi elds

that match the keyword. 3. Double-click the fi eld you would

like to add to the report. 4. Repeat steps 1-3 to add all

desired fi elds to the report. c. The fi elds you selected appear in

Create a New Report

continued

d. When fi nished, click the Save and Back button.

4. Ranges tab (optional):

a. Click the Ranges tab located on the left side of the screen. b. Click the Edit button.

c. Set ranges for any of the fi elds chosen for your report.

d. You can uncheck the Print Field on Report button if you want to use a fi eld for selection/sorting, but not print it on the report.

e. When fi nished, click the Save button.

5. Sorting tab (optional):

a. Click the Sorting tab located on the left side of the screen. b. Click the Edit button.

c. In the Selected Fields box, double-click the fi elds you would like to sort by.

Create a New Report

type of break you would like to have between each fi eld. You may choose a different type of break for each fi eld.

f. Place a check in the Count box if you would like to include a total of each value that appears in a particular fi eld.

g. When fi nished, click the Save and Back button.

6. Selected Students tab (optional): a. Click the Selected Students tab

located on the left side of the screen.

b. Click the Edit button. c. In the Student fi eld, type the

Skyward alphakey for a student you would like to include on the report.

d. Click the student’s name once it appears in the list.

Create a New Report

enter.

f. Repeat these steps to add as many students as you wish.

g. When fi nished, click the Save and Back button.

7. Running the Report:

a. Click the Preview First 10 Records button to run only the fi rst 10 records of the report. This is a good way to test before running the entire report.

Note: You’ll get a note on the report noting

that it was aborted. This is normal. b. Click the Print button to run the entire report. Wait for the report to fi nish processing, and then click the Display Report button. c. Click the Excel button to open

the report in Excel. Wait for the report to fi nish processing, and

Edit a Report

You may edit a report you have created. 1. Select a report you have created. 2. Click the Edit button located on the right

side of the screen.

3. You may make changes to any area(s) of the report. Click on the appropriate button (Report Information, Fields, Ranges, Sorting, or Selected Students) to access that particular area.

4. Click the Edit button on the screen where you will be making changes.

5. Click the Save (or Save and Back) button on each screen where changes are made.

Clone an Existing Report

1. Select the report you would like to clone. 2. Click the Clone button located on the

right side of the screen. 3. Report Information tab:

a. In the Report Name fi eld, type a name for your report. This is the name that shows up in the report list.

Note: Be sure to begin the report name with

your your 3-digit campus number. If you do not do this your report may be deleted.

b. In the Report Title fi eld, type a title for your report. This is the title that shows up on the report heading.

c. Select portrait or landscape for report orientation.

Note: If you create a report with enough

data in it to make a line that’s too long for portrait, it will switch to

Clone an Existing Report

continued

4. Ranges tab:

a. Click the Edit button.

b. Change ranges for any of the fi elds chosen for your report.

c. You can uncheck the Print Field on Report button if you want to use a fi eld for selection/sorting, but not print it on the report.

d. When fi nished, click the Save button.

5. Running the Report:

a. Click the Preview First 10 Records button to run only the fi rst 10 records of the report. This is a good way to test before running the entire report.

Note: You’ll get a note on the report noting

that it was aborted. This is normal. b. Click the Print button to run the entire report. Wait for the report

Clone an Existing Report

continued

c. Click the Excel button to open the report in Excel. Wait for the report to fi nish processing, and then click the Display Report button. Click the Open button.

Delete Your Unwanted

Reports

1. To delete unwanted reports you have created or cloned:

2. If All My Reports is not selected a. Click the Filter Options button. b. Select All My Reports.

c. Click the Apply Filter button. 3. Highlight the report you would like to

delete.

4. Click the Delete button on the right side of the screen.

5. Click Yes on the warning message. 6. You cannot delete or alter a report

created by someone else, only those you have created.

Search for a Report

1. There are several ways to search for a report.

a. Click the arrow buttons located in the bottom left corner of the screen to move to next set of records. Keep doing this until you see the report you are looking for. b. Click the letter/number that the

name of the report begins with. The list of letters and numbers is located at the bottom of the screen. If you still do not see the report in the list, click the right arrow button to advance the screen to the next set of records. c. Type the name of the report in

the Report Name fi eld, and then press Enter. If you still do not see the report in the list, click the right arrow button to advance the screen to the next set of records.