Liz Quigg

Fermi National Accelerator Laboratory • MS226 • Box 500 • Batavia, IL 60510 • 630 840-2631 • edreg@fnal.gov
Home Flash/Director Web Work Exhibits Databases/Lasso Interactive Video Bio

Databases / Lasso

I develop both web-based and network-based databases for the Education Office.


Web-based Databases

Many of the web pages on the Education Office website are created dynamically using a combination of web pages with Lasso, Lasso Middleware, Filemaker and Lasso MySQL databases. Here are some of them. All are Filemaker databases unless specifically noted as MySQL. The QuarkNet/Grid project uses PostgreSQL and Java Server Pages.

The lock icon indicates that these links are password protected.Lock


Program-Related
Programs

Programs

Users can search the database of Education Office programs on a number of critera and access a calendar generated dynamically from the database. Education Office staff update the content using web interfaces.

Science Adventures

Science Adventures

Users can search the database of Science Adventures, classes for kids provided by the Education Office. Calendars are generated dynamically. Staff can update content with web interfaces.

 

High-Energy Physics Education and Outreach
HEP Outreach

Outreach Activities

Users can search a database of activities provided by high-energy physics institutions around the country. Physicists can update the content with web interfaces.
 

ESPG Consortium

ESPG

ESPG Software Directory

Throughout the years, members of the Educational Software Preview Guide (ESPG) Consortium work with educators, library media specialists, professors, and education students as they study the use of educational software in the PreK-12 classroom. Each year the Consortium consolidates their software review information into the ESPG Directory.

Reviews from the TRC reviewers

Reviewers at the Teachers Resource Center at Lederman Science Center can enter reviews of software.

Reviews from Consortium members

Reviewers across the country enter their reviews using web interfaces. The editors consolidate these reviews for the annual directory.

 

Quarknet

These databases support the activities of the QuarkNet staff and teachers.

HEP Outreach

Follow-on Activities (MySQL)

This database includes activities for QuarkNet centers to use after teachers have completed the standard program.

Talks (MySQL)

A listing of all talks giving by QuarkNet staff and teachers. Summaries provide reports.

PhysicsShare (MySQL)

A database of activities and resources for teachers to share.

Classroom Activities
(MySQL)

A database of activities approved by the QuarkNet Staff.
 

Prairie-Related

• Background Information

These databases provide information for students participating in the various prairie programs including the Quadrat Study below.

Butterflies

Butterfly Information and Data

Tom Peterson monitors Fermilab's butterflies each year. Peterson's data is presented in a student-friendly format with information on each buttterfly species.

 

Bug

Insect Information and Data

Users can search a database of common insects found at Fermilab.

Plant Database

Fermilab Plants Database

Users can search a database of plants found at Fermilab.

Particles and Prairies

Particles and Prairies Slide Collection

All slides on the Particles and Prairies videodisc are available online.

 

•Quadrat Studies

These databases support the collection of student data from quadrats in the Fermilab prairie. A quadrat is 1 meter square. Students count the number of prairie plants and percent cover of these plants and enter it into the database for their study. A study covers a plot of land within a prairie. Prairies can be any place in the country.

Plants

Prairie Quadrat
Data Collection

Students can enter quadrat data with a web interface.

Data Summaries and Graphs

Students can look at summaries and graphs that consolidate quadrat data from all students.

Prairies Studies, Schools and
Prairie Experts

Students can search the databases of studies, schools and prairie experts enrolled in the project.

Preparing for Data Entry

To enter data in the system, contributors must complete a number of prelimary steps.

 

Fermilab Friends of Science Education
Online Store

Online Store of Logo Merchandise using PayPal

Fermilab Friends of Science Education sponsors this store.

 

Cosmic Ray e-Lab for I2U2
HEP Outreach

PostgreSQL Databases to Support Evaluation
and Login

The Cosmic Ray e-Lab is a large project involving students collecting cosmic ray data with detectors at schools. I was involved in the first version of the database needed to support users, entries in their logbooks, presurveys, and other constructs. We used Java Server Pages with SQL calls to interact with the PostgreSQL database. This database has been revised and now using Hibernate and JavaBeans to interact with the database. The project is a joint effort of many contributors. It is on a Tomcat Server at the University of Chicago. The database work also supported the CMS Testbeam e-Lab.

 

Network-based Databases

I have developed a number of relational databases to support the Education Office staff in the registration and administration of field trips, science adventures, and scientist visits to schools. The staff prefers to work with Filemaker and had developed a number of disparate databases that needed to be consolidated to use the same teacher, school, and participant databases. These databases are multi-user and reside on a Filemaker server.