log onto reportnet add header to report create listing w/ basic student information add filter...
TRANSCRIPT
3
4
Introduction
5
1 Log onto ReportNet
Add header to report
Create Listing w/ Basic Student Information
Add filter
Organize data
ReportNet Training Program
2
Introduction This instructional unit was created in order
to aid in the education of the 5 novice ReportNet user currently employed in the Research and Evaluation department of the Harlingen Consolidated School District.
Goal Upon completion of the ReportNet
training program, Harlingen CISD Research and Evaluation Department employees will be able to generate custom ad hoc reports in Adobe Acrobat Portable Document Format (PDF).
Objectives Access ReportNet
Create Report Template
Apply criteria/filter
Add report header
Verify report data
1
2
3
4
5
Prerequisite Skills Basic Report Structures
Poor Report Layout Better Report Layout
Prerequisite Skills eSchoolPlus Database Structure
Example Attendance Table stores
Attendance Building Attendance Date Attendance Code Attendance Period
Prerequisite Skills Basic Computer Programming
Syntax Equal to (=) Greater Than (>) Less than (<) Not (<>) Contains Like
Task 1 Log into ReportNet1
Step 1 From within eSchoolplus. Click Cognos
Reporting
Step 2Type user name and password
Example
Username – pent\username
Password – type password
Step 3You are now in Cognos Connection
Click on Report Studio
Step 4Select Package
Click on eSchoolPlus
Wait for ReportNet to launch.
Task 1 Log into ReportNet1
Task 1 Assessments1
Short answer questions1.Where is the Cognos Reporting Link
Located?
2. What must be type before your username when logging in to ReportNet?
3. Which package must be selected when creating student reports?
1. Choose File, New from pull-down menu
2. Double Click List from the available types
3. Insertable ojects pane on the left hand side
4. Expand Folders a and Click on
Student Center
Task 2 Create New Report listing12
5. Insert the following fields Student Id,
Name, grade, birthdate, and gender
Production Note: This is a storyboard. The final product will be a
video illustrating how to insert the fields.
Task 2 Create New Report listing12
Task 2 Assessments1
Short answer questions1. How many available types of reports?
2. Where are the fields located?
3. How are fields inserted into the listing template?
2
Task 3 Add Filter/Criteria1
Step 1Single Click Filter button
Step 2Click on Criteria Button
3
Task 3 Add Filter/Criteria1
Step 3Select Criteria Field and insert into expression
definition by double clicking the field name
Step 4Example
Syntax (=) is demonstrated.
3
Production Note: This is a storyboard. The final product will be a video illustrating how to apply filter.
Task 3 Add Filter/Criteria133
Task 3 Assessments1
Short answer questions1. How do you insert filter?
2. How do you validate criteria?
3. The expression definition pane is used to insert filter? True / False
23
Task 5 Organize Data1
Step 1 Grouping Data1. First Select grouping field.
2. Single Click on the grouping Icon.
Step 2 Sorting Data1. First Select Sorting field.
2. Single Click on the sorting icon.
3. Choose Ascending or Descending
34
Production Note: This is a storyboard. The final product will be a video illustrating how to apply grouping and sorting.
Task 4 Organize Data1334
Task 4 Assessments1
Short answer questions1. Where is the grouping icon?
2. Where is the sorting icon?
3. The report designer must first select a data field from the report template in order to group or sort? True / False
234
Task 5 Add Header1
Step 1 Add Header1. Double Click on ‘Double click to edit text’.
2. Enter Report Title.
Step 2 Example
1. Report Title Inserted.
355
Task 5 Run Report1
Step 1 Run Report1. Click on the Run Report Icon.
Step 2 Example1. Select Run Report - PDF.
355
Task 5 Report Output 1
Step 2 Output Example
355
Task 5 Assessments1
Short answer questions1. What report naming coventions are
currently used in the district?
2. How is a report generated?
3. In what format must the report output be generated in?
2345
3
4
Summary
5
1 Log onto ReportNet
Add header to report
Create Listing w/ Basic Student Information
Add filter
Organize data
ReportNet Training Program Summary
2