Zfair Integration

 

Click on column heading to sort in that order.  Click on ID to expand/edit               Include closed issues  (check and then click submit)  Green=closed
                                                                                                                                                                  Zfairs Ticket System
Click here to add new record
 
ID Priority
1=hi
9=low
Module DataBase
Mods
Short Issue Expanded Explanation Resolution Notes  

1

 2

 All  None  Export of all tables. Need an easy way to export all key data files to digital media for use in external word processing/merges. Essential tables needed include: (Students, Teachers, Schools, Judges, Volunteers, Scores, Awards (description, amount, organization, etc)  Export can be in Excel (one tab per table), Access, SQL, or comma delimited flat files. Photos would NOT need to be exported. Abstract, Research Plan, Bibliography, etc, along with an unique id number for each key table are needed.  test2  test3  

7

 4

 Schools  Minor  Additional info needed: Type_Of_School Expand current school types  we need to report to SSP the nuimber of: Home Schools, public schools, private schools, titleI schools, Charter schools, etc Current implementation does not provide for Home Schools or title 1 schools      

10

 2

 Judges  Minor  Additional Info needed: Judging commitments for current year  Judges stay in the database. We clear this field every year. A judge needs to sign in and simply indicate that they WILL be judging (and their desired 3 choices) and time commitments. We also asked if they can judge virtually      

11

 8

 Student Archive    Need a searchable student archive by any number of fields (first name, last name, school name, teacher, partial title, award, etc) with filters by year (or ranges)  This function is heavily used by our students/teachers to get ideas for their projects. We go back 30+ years and it amazing to see how many 'which battery is the best' project. But also interesting to see the project on 'cold nuclear fusion'      

12

 3

 Judges  Minor  Additional info needed: Type of judge (Category or professional organization) and if professional organization - which one  With 300 judges each year, we need an accurate count. However, the judges that are with a specific organization are not available for the overall judging pool for categories (but still need to be credentialled)    Trent to add - C=Category, P=Professional/Special, B=Both for type of judge  

13

 3

 Students  Minor  Need a quick way to add multiple team members rather than having each team member register. Store all names in a field 'CertificateName' Cumbersome to deal with other team members. Not reasonable to have 10 3rd graders all enter team info and a 50 character string to tie them to team leader.  We simply ask for all the members of the team and store the info (first name and last name) in two fields. Then on the post of the page, construct a field 'Certificatename" which is proper(firstname) & " " & Proper(lastname) with teammember1 and teammember2, teammember3, etc This certificate name is used on all reports instead of the student name. For an indivual, the certificate name is the same as the student name      

16

 1

 Display/Safety  yes  Display and Safety checks. Need to review all material submitted by students before judges can see it  We currently have a team of 25-30 volunteers that inspect each and every display board as it would be set up the day before competition. Typically about 10% of the project boards need to be modified before competition. Our system allows for Display and Safety inspectors to reviews each of the documents and either approve or reject the document (if a document is rejected, an email is automatically sent to the teacher and student). When done, the D&S volunteer indicates if the project is approved for competition or not (certain photos may be disqualified, but the project may still be approved). All actions by each D&S volunteer is logged. Refer to: http://www.sefmd.org/Zoom/DS.mp4      

17

 2

 Teachers/Judges  Minor  Provide system option to prohibit or allow teachers to be judges  A good source of our judges come from judges. But with 1500 kids, we need a lot of judges! Detroit Public Schools provides a number of its teachers professional development and encourages them to judge the projects. We need to allow teachers to also be judges (using the same id)    Trent to implement  

19

 4

 Students  No  Provide a real time indicator of the number of words typed in by the student on certain fields (research plan, abstract) and prohibit verbose entries  Implemented by setting a max word count in system parameters when the field ResearchPlan and/or Abstract is selected. If max word count=0, then unlimited. ISEF limits abstract to 500 words or less      

20

 3

 calendar  Minor  Provide extra deadlines/events in calendar  Fairs may have several deadlines. For example, projects that need prior SRC approval have a deadline (for us) of December 1. After that date, senior division projects that would need prior approval will not be permitted. We have a deadline date and then a 'revision deadline date' and 'upload deadline date'. Basically on Feb 5, all entries need to be in. However, abstract and photos/video links, etc can still be updated/modified up to 10 days prior to the fair. Most fields are locked from editting (but we do allow upload of info and abstract changes)      

22

 7

 main page  No  How to embed twitter and facebook icons/javacode in main page  Need a way of dropping the javacode in the main page for all major services (instagram, twitter, facebook, snapchat, etc)      

24

 2

 Students  Minor  automatically pre-scan title, research plan, abstract to alert of possible issues by setting a flag in the student profile for 'Possible_SRC_Alert'  The title, research plan, and abstract are searched for one of 18 key works (like fish, cells, animal, survey,,,). If any of these key works are detected, the project is flagged indicating that a live person would need to read the application to determine if the project is acceptable or not. With 1500 students, not all projects are examined when they are submitted. This test enables a reduction of the initial review to less than 20%.      

27

 4

 Schedule  Y  Different deadlines and fair dates by division.  We host the elementary fair on a different date than the Junior and Senior Division. With that, different deadlines are used for the different divisions.    set up two fairs, one for elementary and one for Jr/Sr?? (taf)  

34

 2

 Student Registration    Set Elementary Division with following
NO to 'this division uplosdd pperweork
YES to show in online judging
NO to 'this division follows the ISEF Rules
YES to override the ISEF...
 however, isef forms still appear in upload info and on dashboard      

39

 3

 students, judges, vo    Need export in excel of info to generate certificates. Current certificates on zfairs do not work for us. Students export needs the category award and all professional awards (with descriptions). No excel export found for judges, volunteers, schools  We use Microsoft Word with Adobe Acrobat to merge in our certificate template (with watermark seal and signatures) automatically into a PDF file and it gets emailed to the recipient - all automatically. Professional award certificates are all different and on custom stock. We generate over 250 professional award certificates - need way of getting info exported to handle this task      

41

 1

 Judging  Yes  Need additional fields to do background check  Michigan State police has authorized SEFMD to access their system to do background checks for free. The following information is needed to do a background check. Name, Address, Date of Birth, Gender, Race (new fields would be DOB, Gender, Race)  added via api