Tips and Tricks

1
Tips and Tricks
By Mike DeGregorio

2
Hot Keys
Enter Query - F11 Execute Query - Control
F11 Clear Field - F5 Print Screen - Control
P List of Values - Control L Exit Screen - F4
If you prefer using the keyboard over a mouse Use
these shortcut keys directly from the keyboard
instead of clicking icons with your mouse.
3
Tab Pages
Keyboard click - F2
4
My Favorites
Navigate to the screen you would like to add into
your Favorites area. Then on the Task menu click
the Add to favorites link.
5
User Fields in Reports

• Temporarily populate user field to run reports
  for an individual/group of students.

From student school record
Enter values from student record on
reports/screens that dont offer student ID
fields
6
Short Cuts
From student lookup screen
From report screens
If there are certain queries, routines, or
reports you run often, use these options to
reduce duplicate work
7
What is this?
This will help you determine which table to
include in Advanced Query
While in a field in Star_Student click
Help Menu properties
Shows table and column name
8
Speed Things Up
To rollover a validation table to all schools in
the district use
9
Pick and Choose individual students to resubmit
from portal gradebook

Re-calculate button vs.
10

Put it in here
Then it comes out here
11
Coming Soon
Bus number/bus information has been placed on
student summary screens
Original Summary Screen from student lookup
New Summary Screen from Find Tab
To prepare for the new change, all districts
should populate the busing tables utilizing
the bus number and
bus route. Then, when a bus information
changes just change the bus number in the bus
table. Code will send updated 045
audit records for the change in the bus number.
12
New Auto-populate ID
Auto-populate reports/routines when student is
queried up on new lookup screen
13
Class Period Attendance
Effective date enter will now be the first day
that the student will start in the new class
14
Address Audit Log
Find the student, then contact and address tabs
show how the information was stored before the
changes
15
Daily/Class Attendance Audit
Will keep track of Daily and Class Period changes
16
EIS Changes for 2008
Addition of a state honors class flag to the
section table.
(Set this value to Y or N)
17
Discipline Changes
You will need to reassign the state code in the
Infraction validation table for the 2008-09
school year.
WARNING Schools must go in and re-assign state
disposition codes to the locally defined
disposition codes.
18
EIS Changes (cont.)
Student Disability Codes available to see in
Star_Student.