Basic

1
Basic Advanced Reporting in TIMSNT Part One

2
How it is - Reporting in TIMS.nt

• Edulog wanted reporting in the new software to be
  more powerful and flexible.
• Rather than create their own software from
  scratch, they incorporated existing report
  software.
• They chose FoxPro Query Maker.

3
FoxPro Query Maker

• FoxPro is Microsoft database software
• Grandma of ACCESS
• Query Maker is FoxPros query builder and report
  writer that can be included royalty free in
  FoxPro applications.
• Thats why we have it - its free.

4
Edulog vs. FoxPro Tables

• The tables you edit in TIMS.nt are still in a
  format developed by Edulog.
• However, QueryMaker cant use the Edulog tables.
• So, the TIMS.nt uses FoxPro format tables for
  reporting.

5
Edulog vs. FoxPro Tables

• Because you are reporting from tables other than
  your Edulog data tables, changes made to your
  data are not immediately available in reporting.
• Changes made to the Edulog tables must be
  transferred to the FoxPro tables.
• In a nutshell, it works like this

6
How it Works. . .

• Changes you make to your Edulog data tables are
  also written to a set of text files.
• Internally, Edulognt checks these files every few
  minutes. It transfers what it finds in these
  files to your FoxPro tables.
• After that, your reports will show the changes
  you made.

7
Remember

• What you need to remember
• Generally, changes made to your data tables are
  not immediately available in reports. Give the
  software a few minutes to complete the transfer.

8
Edulogs Dumpall Utility

• Dumpall is a maintenance utility that is run
  through the Edulog Maintenance Utility (EMU).
  EMU is used for System Maintenance.
• Dumpall deletes the existing FoxPro tables,
  builds new ones, and fills them with all your
  transportation and student data.
• You will only need to run Dumpall under special
  circumstances.

9
Tradeoff A little more complexity, a lot more
control

• Reports Query maker gives you control over.
• Query Filters
• Data item selection
• Report appearance
• Selection and sorting available on new items like
  bus stop assignment, time at stop, distance to
  stop, etc.

10
New Capabilities and Control

• You have two options in Edulog.nt reporting
• Continue to use the reports you have always used
  and reports weve create for you.
• or
• Learn to make use of the more flexible,
  FoxPro-based reporting and modify existing
  reports to your own liking.

11
Getting Started
Report

• Start gt

Programs gt
Edulog.nt Client Software gt
Report
12
Overview of Report features
13
Overview of Report features Format

• Format
• Provides various options on how you want your
  reports to appear

14
Format
You can set global options for all reports or
set options for just standard reports. These are
the default settings
15
Overview of Report features Geographic Reports

• Geographic Reports
• Opens the Geographic Reports launch pad which
  provides access to the various reports which list
  information on your geographic data.
• Street Name Listing
• Overlapping Segments
• Traffic Listing
• Boundary Listing

16
Geographic Reports Window
17
Overview of Report features Student Counts

• Student Counts
• Produces reports listing the numbers of students
  at each of the schools in your system. You can
  produce student counts broken down by grade or by
  transportation eligibility code.

18
Student Counts

• Select Eligibility Code 0

• For output type, select landscape

19
Student Counts Sch/Grd Report

• Sch/Grd report shows enrollment

• Sch/Elg Report shows assignments

20
Student CountsSch/Grd Enrollment Report Example
21
Sch/Elg Report

• Setup Report fills fields for the report

22
Eligibility Report Example
23
Overview of Report featuresRoute Time Line

• Route Time Line
• Produces a time line report on routes in your
  system.

24
Route Timeline

• This screen gives you choices to customize your
  timeline

gt selects a single route
gtgt selects the whole list
25
Route Time Lines Report Example
26
Overview of Report features Deleted Students

• Deleted Students
• Produces a list of all students that have been
  deleted (flagged for deletion, but not yet
  purged) in edulog.nt.
• Useful during an upstu?

27
Deleted Students Report

• The first time you run it, you will need to name
  the query

28
Deleted Students

• Next, select Student Last Name as the field gt
  Next Step
• Under the Pick an Operator tab, select Is Not
  Empty
• You will also have to pick the fields you want in
  the report
• When you run the query, the list will include all
  deleted students

29
Overview of Report features Duplicated Students
Duplicate Students Produces a listing of all
students with duplicated information in the
student database. You can use this report to find
students that have the same first name, last
name, and address (an indication that a student
has been inadvertently entered into the system
more than once) or to find students that have
accidentally been given the same district ID
number. You can have Query Maker check any field
in student records for duplication.
30
Overview of Report features Utility Audit/Error
Utility Audit/Error Provides access to reports
produced by the various edulog maintenance
utilities. When you use Query Maker to examine
these reports, you can change the information
included in the report and the order in which it
is arranged.
31
Utility Audit / Error
Provides access to reports produced by the
various edulog maintenance utilities.
A bit complex. Not as useful as .aud .err
files from EMU.
32
Overview of Report featuresRR Crossing
RR Crossing Allows you to produce reports on
railroad crossings in your system.
33
Overview of Report features Standard Reports vs
User Defined Reports
Standard Reports vs User Defined
Reports Standard Structured menu system that
lets you select parameters for reports User
Defined Pre-prepared reports, ready to run as
they are or be customized.
34
Standard Reports

• Standard
• Easy to find report you want
• Simpler to use
• Partial control Can change search and sort
• Cant change field selection, field order, or
  format
• Adequate for many purposes

35
User Defined Reports

• User Defined
• Harder to find report you want
• Harder to use
• Full control over report change search, sort,
  field selection, field order, report appearance
• Use to create custom reports

36
Standard Reports PTSIII Reports
Selecting the check box in any of the reports
types will bring up sub menus for those reports
37
Standard ReportingExample Run Report
The resulting Run Report
38
Reporting Vocabulary

• Filter a set of conditions that indicate which
  records and fields from a database are to be
  included in your query results.
• A condition consists of
• a field name (such as Grade)
• a relational operator (such as Is equal to)
• a comparison value (such as 06).
• Example students in the sixth grade

39
Standard Reporting Change Filter Search
Further modifying your Search parameters..
Perhaps we desire the same run report but for
just ONE school.
40
Change Filter Search (continued)
Now you can edit, add to, or delete the
modifiable filters.
Non-Modifiable
Modifiable
41
Change Filter Search (continued)
Now well make the selections that locate all
RunIDs that begin with 306
42
Standard Reporting end notes

• The results will be a report that contains all
  Runs that begin with 306.
• The Standard Reports option is great for
  generating reports that require typical or
  general information.
• More complex data output will require the use of
  User Defined Reports

43
Basic Advanced Reporting in TIMSNT End of
Part One

• To Continue. . .
• Go back to the web page and click Basic
  Advanced Reporting in TIMSNT, Part Two