Colorado Higher-Education Interdisciplinary Program - Colorado State University GK-12 Program: A multi-disciplinary research and teaching program in biomedical engineering for discovery and understanding of cell communication

Journal Entries Administration

Email Journal Reminder

Your journal entry is due #week#. Please follow the appropriate link below to complete the entry.

Fellow:
http://csu-gk12.engr.colostate.edu/team_only/journals/fellow/index.cfm

Teacher:
http://csu-gk12.engr.colostate.edu/team_only/journals/teacher/index.cfm

Email Sent:

To: #Session.email#

Bcc: #form.addresses#

From: #Session.displayname# < #Session.email# >

Subject: Reminder - GK-12 Journal entries are due #week#

Your journal entry due #week# is overdue. Please follow the appropriate link below to complete the entry.

Fellow:
http://csu-gk12.engr.colostate.edu/team_only/journals/fellow/index.cfm

Teacher:
http://csu-gk12.engr.colostate.edu/team_only/journals/teacher/index.cfm

Email Journal Results for #week# (Week #form.weekID#)

SELECT * FROM gk12_journal_fellows WHERE weekID = "#form.weekID#" AND date_submitted > "2012-06-01"

Created file fellows_week#form.weekID#.csv

SELECT * FROM gk12_journal_teachers WHERE weekID = "#form.weekID#" AND date_submitted > "2012-06-01"

Created file teachers_week#form.weekID#.csv

Results of the journal entries for #form.week# (Week #form.weekID#).

Created file teachers_week#form.weekID#.csv

Created file fellows_week#form.weekID#.csv

Emailed Results files to #Session.displayname# < #Session.email#>

Journal Entries for Week #url.weekID# - Due #week#

Fellows
SELECT firstname, lastname, email, ID FROM gk12_participants WHERE type = "fellow" AND isvalid = 1 ORDER BY lastname, firstname SELECT ID, week, name, weekID, gk12_participants FROM gk12_journal_fellows WHERE weekID = AND date_submitted > "2012-06-01"
Fellow Name Journal Status
#fellows.lastname#, #fellows.firstname# SELECT ID, week, weekID FROM fellowjournals WHERE gk12_participants = #fellows.ID# View not submitted
Teachers
SELECT firstname, lastname, email, ID FROM gk12_participants WHERE type = "teacher" AND isvalid = 1 ORDER BY lastname, firstname SELECT ID, week, name, weekID, gk12_participants FROM gk12_journal_teachers WHERE weekID = AND date_submitted > "2012-06-01"
Teacher Name Journal Status
#teachers.lastname#, #teachers.firstname# SELECT ID, week, weekID FROM teacherjournals WHERE gk12_participants = #teachers.ID# View not submitted
  

Return to Journal Administration Home page

You must include a week ID as a parameter for this page. Please return to Journal Administration Home.