iAHEC

A way to download all data for a center and the program at once, rather than table by table, where you have redefine the time frame and center for each individual table?

When you download to Excel Spreadsheet, create a header row at the top identifying the report?

Reports that have subtotal and total fields, those fields don’t translate correctly when exported to Excel.

Can we format the reports to get column totals at the bottom as well as the Total Ethnicity and Total Rural/Urban?  See Reports: P1A, P2A, P4, D5A,

On the Activity Assessment form, and corresponding reports, what does “STUDENT-Not Applicable” mean?

The numbers for teacher /counselor reported on P1B are not the same as reported on P4.  Why is this?

Can we create a mechanism in iAHEC to collect the supplemental data required by the feds on CE events (participant cost, etc). 

• See DSCPH 6A

Custom reports:

• A way to view individual participants of all longitudinal HCP programs and/or individual longitudinal programs.  Something that identifies student name, contact info, program(s) attended.
• A report for community faculty that includes contact info (for mail, email purposes)
• A report for community faculty that identifies the number of students hosted and training hours supported, so that you don’t have to go into each faculty worksheet to pull this info.
• A report for student/residents that includes contact info (for mail, email purposes)

Is there a way to validate some fields to improve data entry accuracy.  For example:  On the P2 tables, the Total Ethnicity and Total Rural/Urban columns should equal the same number, but I’ve found instances where they don’t.  It would be helpful if the system would pop-up an error message so that this had to be fixed before the user could move on.  There are probably other instances where this feature would improve the integrity and reliability of our data. 

Re the great ISD debate
1. Ignore the instructions to add ISDs.  Turns out Mouyong turned off regular user access to enter new ISDs because we were getting a lot of duplicates which affected the reports.  Remember to always, always check for an org or person before you add them.  As of now, only administrators can enter ISDs, so send your new ones to Laura.  We'll re-visit this issue later.
2. The ISDs were added at the request of HCP coordinators.  They are not connected to fed reports, but Steve & Mary do use those numbers for advocacy and other initiatives. 
3. We do need to record the other types of schools.  We discussed adding these categories, but not sure just where/how yet.
4. How about these school categories - remember less is best
  public ISD
  public non-ISD
  private (includes faith-based)
  charter / magnet  (are they private/public, what's their difference, should they be separate or together?)

Methinks it's time for another training session for each workgroup, to orient new coordinators and refresh our veterans.  We'll get those set up soon.

Debbie

-----Original Message-----
From: Lori Millner
Sent: Tuesday, June 19, 2007 10:04 AM
Subject: Re: An iahec reminder

Just an FYI, but in some cases we go to private schools and they don't have ISDs, so some schools will be without districts.