Login or register for free to remove ads.

Creating and Collaborating in the Early Childhood Classroom PROCEEDINGS

, Columbia College Chicago, Early Childhood Education, United States ; , Columbia College Chicago, Early Childhood Education Program, United States ; , University of Chicago Lab School, United States

EdMedia: World Conference on Educational Media and Technology, in Orlando, FL USA ISBN 978-1-880094-60-0 Publisher: Association for the Advancement of Computing in Education (AACE)

Abstract

This presentation focuses on the work produced in one classroom of four-year-olds that is part of a larger collaboration exploring how technology can be used to significantly enhance the learning of young children. Our work moves beyond introducing available software in early childhood classrooms in order to provide an additional context in which students might explore skills that can be developed without technology. Rather, we are designing the means for integrating interactive authoring environments into preprimary and primary classrooms. Our goal is to provide an infrastructure, via technology, from which young children can make previously unexpected cognitive leaps. While some might argue that this goal has merit enough in and of itself to drive a research agenda, an additional motivator of our work has been the ongoing demands that technology be implemented in classrooms for young children (Bewick & Kostelnik, 2004) with little consideration as to the appropriateness of its typical uses.

Citation

Stowe, C.A., Scarlata, V. & Stowe-Grant, E. (2006). Creating and Collaborating in the Early Childhood Classroom. In E. Pearson & P. Bohman (Eds.), Proceedings of EdMedia: World Conference on Educational Media and Technology 2006 (pp. 218-222). Association for the Advancement of Computing in Education (AACE).

Keywords


Feedback and Suggestions please email info@editlib.org or use our online feedback form.


Debugging Information
Railo (Togo) Os FINAL 4.2.1.008 (CFML Version 10,0,0,0)
Template /index.cfm (/var/sites/railo.editlib.org/index.cfm)
Time Stamp Feb 12, 2016 4:08 PM
Time Zone UCT
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.82.49.125
Host Name www.editlib.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
333 ms 333 ms 1 /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
99.8 ms 99.8 ms 1 /var/sites/railo.editlib.org/logger/act_logaccess.cfm
24.6 ms 24.6 ms 1 /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
10 ms 10 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
4.14 ms 4.14 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
8.25 ms 4.12 ms 2 /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
11.1 ms 3.71 ms 3 /var/sites/railo.editlib.org/models/sources/qry_source.cfm
7.11 ms 3.55 ms 2 /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
24.6 ms 3.51 ms 7 /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
6.91 ms 3.45 ms 2 /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
3.41 ms 3.41 ms 1 /var/sites/railo.editlib.org/models/papers/qry_references.cfm
1.36 ms 1.36 ms 1 /var/sites/railo.editlib.org/layouts/lay_new_2014.cfm
2.63 ms 1.31 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/ini2struct.cfm
2.15 ms 1.07 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/cache.cfm
1.05 ms 0.527 ms 2 /var/sites/railo.editlib.org/reader/inc_share.cfm
0.215 ms 0.215 ms 1 /var/sites/railo.editlib.org/Application.cfm
0.147 ms 0.147 ms 1 /var/sites/railo.editlib.org/models/papers/act_generatecitation.cfm
0.077 ms 0.077 ms 1 /var/sites/railo.editlib.org/models/sources/act_generatesourcetext.cfm
0.057 ms 0.057 ms 1 /var/sites/railo.editlib.org/OnRequestEnd.cfm
0.042 ms 0.042 ms 1 /var/sites/railo.editlib.org/reader/inc_tools.cfm
0.038 ms 0.038 ms 1 /var/sites/railo.editlib.org/reader/inc_collections.cfm
0.115 ms 0.038 ms 3 /var/sites/railo.editlib.org/security/act_identifyinstitution.cfm
0.076 ms 0.038 ms 2 /var/sites/railo.editlib.org/logger/act_readnavigationhistory.cfm
0.073 ms 0.036 ms 2 /var/sites/railo.editlib.org/reader/inc_login.cfm
0.033 ms 0.033 ms 1 /var/sites/railo.editlib.org/logger/act_lognavigationhistory.cfm
0.03 ms 0.03 ms 1 /var/sites/railo.editlib.org/security/act_determinesubscriptions.cfm
0.029 ms 0.029 ms 1 /var/sites/railo.editlib.org/reader/inc_breadcrumb.cfm
0.687 ms 0.027 ms 25 /var/sites/railo.editlib.org/fbx_Layouts.cfm
0.617 ms 0.024 ms 25 /var/sites/railo.editlib.org/fbx_Settings.cfm
0.091 ms 0.022 ms 4 /var/sites/railo.editlib.org/logger/fbx_Switch.cfm
0.045 ms 0.011 ms 4 /var/sites/railo.editlib.org/logger/fbx_Settings.cfm
0.274 ms 0.01 ms 25 /var/sites/railo.editlib.org/fbx_Circuits.cfm
0.036 ms 0.009 ms 4 /var/sites/railo.editlib.org/logger/fbx_Layouts.cfm
0.156 ms 0.008 ms 18 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/nonessential.cfm
0.06 ms 0.008 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Switch.cfm
0.024 ms 0.008 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Switch.cfm
0.203 ms 0.008 ms 25 /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm
0.022 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Layouts.cfm
0.019 ms 0.006 ms 3 /var/sites/railo.editlib.org/security/fbx_Switch.cfm
0.148 ms 0.005 ms 25 /var/sites/railo.editlib.org/functions.cfm
0.027 ms 0.003 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Switch.cfm
0.003 ms 0.003 ms 1 /var/sites/railo.editlib.org/reader/fbx_Layouts.cfm
0.003 ms 0.003 ms 1 /var/sites/railo.editlib.org/layouts/inc_jquery_cdn.cfm
0.006 ms 0.002 ms 3 /var/sites/railo.editlib.org/security/fbx_Settings.cfm
0.005 ms 0.001 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Settings.cfm
0.012 ms 0.001 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Settings.cfm
0.01 ms 0.001 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Settings.cfm
0 ms 0 ms 25 /var/sites/railo.editlib.org/index.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/lay_new.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Switch.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Settings.cfm
0.931 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
12.4 ms  APPLICATION EXECUTION TIME
531 ms  QUERY EXECUTION TIME
544 ms  TOTAL EXECUTION TIME
red = over 250 ms average execution time


Caught Exceptions

Type Message Detail Template
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/papers/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/papers/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/sources/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/sources/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277
missinginclude Page /models/paperfiles/fbx_Layouts.cfm [/var/sites/railo.editlib.org/models/paperfiles/fbx_Layouts.cfm] not found /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm:277


SQL Queries

GetPaper (Datasource=aacepubs, Time=3.91 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=23018
		
GetPapers (Datasource=aacepubs_readonly, Time=9.89 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
	SELECT
		Papers.paper_id, Papers.paper_code, Papers.paper_title, Paper_Status.paper_status_name AS status_name, 
		Papers.paper_is_locked, Papers.date_created, Papers.date_modified, Papers.paper_type,

		Papers.paper_page_start, Papers.paper_page_end,

		Papers.paper_abstract, Papers.paper_comments,

		Papers.paper_decision, Papers.paper_status, 

		People.email AS contact_email,
		People.first_name AS contact_first, People.last_name AS contact_last,
		People.organization AS contact_organization, Countries.country_name AS contact_country,

		Sources.source_code, Sources.source_issn, Sources.source_type, Sources.source_title, Sources.source_abbr, Sources.source_id, Sources.source_authors,
		Sources.source_image,
		Sources.source_description, Sources.source_location,
		Sources.source_date, 
		SourceIssues.sourceissue_id, 
		SourceIssues.sourceissue_volume, SourceIssues.sourceissue_number, SourceIssues.sourceissue_title, SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_image,
		SourceIssues.sourceissue_date, 

		COALESCE(Publishers.publisher_name, Sources.source_publisher) as publisher_name,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date,

		(SELECT
			MIN(FullText.paperfile_name)
			FROM
				PaperFiles AS FullText
			WHERE
				FullText.paperfile_paper=Papers.paper_id
				AND FullText.date_deleted IS NULL AND FullText.paperfile_name > ''
				AND FullText.paperfile_hidden = 0 AND FullText.paperfile_type = 'PAPER'
		) AS fulltext_file,

		Authors.author_id,
		Authors.first_name AS author_first,
		Authors.last_name AS author_last,
		Authors.organization AS author_organization,
		AuthorCountries.country_name AS author_country,
		Authors.email AS author_email,
		Thumbnail.paperfile_name AS paper_thumbnail,
		Papers.paper_sourceissue,
		CAST(SourceIssues.sourceissue_volume AS varchar) + ':' + CAST(SourceIssues.sourceissue_number AS VARCHAR) AS issue_string
		

	FROM
		((((((((Papers 
		LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper AND 
		(Authors.author_type IS NULL OR Authors.author_type <> 'C')
		)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code)
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id)
		LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Paper_Status ON Papers.paper_status=Paper_Status.paper_status_code)
		)
		LEFT JOIN Countries ON People.country=Countries.country_code)
		LEFT JOIN Countries AS AuthorCountries ON Authors.country=AuthorCountries.country_code
		LEFT JOIN PaperFiles AS Thumbnail ON Papers.paper_id = Thumbnail.paperfile_paper AND Thumbnail.paperfile_type = 'THUMBNAIL'
		
	WHERE
		
		
			Papers.date_deleted IS NULL
		

		

		

		

		

		

		

		

		

		

		

		
		
			
					AND Papers.paper_type='Chapter'
					AND EXISTS (
						SELECT *
						FROM
							Sources
						WHERE
							Papers.paper_source=Sources.source_id AND
							Sources.source_paper=23018
					)
				
		
			
					AND Papers.date_added IS NOT NULL
					AND 
					(
						Papers.paper_status='DL_PUBLISH'
						
					)
				
		

		

	ORDER BY
	
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		Papers.paper_page_start,
		Papers.paper_page_end
	 
GetPaper (Datasource=aacepubs, Time=4.23 ms, Records=1) in /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
	SELECT
		Papers.paper_id, 
		Papers.paper_oldid,
		Papers.paper_is_locked,
		Papers.paper_code,
		Papers.paper_title, 
		Papers.paper_type,
		Papers.paper_abstract,
		Papers.paper_description,
		Papers.paper_page_start,
		Papers.paper_page_end,
		Papers.paper_awards,
		Papers.paper_file,
		Papers.paper_is_free,
		Papers.free_for_member,
		Papers.paper_free_until,
		Papers.date_of_publication,
		Papers.paper_status,
		Papers.paper_version,
		Papers.paper_contact_person,
		Papers.paper_price,
		Papers.date_imported,
		Papers.date_indexed,
		ContentPartners.contentpartner_name,
		ContentPartners.contentpartner_code,
		
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title, 
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_volume, 
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_location, 
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_eissn,
		Sources.source_id,
		Sources.source_type,
		Sources.source_title,
		Sources.source_abbr,
		Sources.source_code,
		Sources.source_publisher,
		Sources.source_image,
		Sources.source_description,
		COALESCE(Papers.paper_copyright, SourceIssues.sourceissue_copyright, Sources.source_copyright) AS copyright,
		Publishers.publisher_name,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_url,
		Sources.source_location,
		Sources.source_date,
		Sources.source_paper,
		People.person_code,
		People.email AS contact_email,
		People.first_name AS contact_first,
		People.last_name AS contact_last,
		People.organization AS contact_organization,
		COALESCE(Papers.date_of_publication, SourceIssues.sourceissue_date, Sources.source_date) AS paper_date
	FROM
		((Papers LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id)
		LEFT JOIN Sources ON Papers.paper_source=Sources.source_id)
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
		LEFT JOIN People ON Papers.paper_contact_person=People.person_id
		LEFT JOIN ContentPartners ON ContentPartners.contentpartner_id=Papers.paper_contentpartner
	WHERE
		
			Papers.date_deleted IS NULL AND
		
		
			Papers.paper_id=23018
		
Source (Datasource=aacepubs, Time=3.83 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 23018
		
PaperTopics (Datasource=aacepubs, Time=3.44 ms, Records=4) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 23018
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
Authors (Datasource=aacepubs, Time=3.54 ms, Records=3) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					23018
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
Authors (Datasource=aacepubs, Time=3.49 ms, Records=3) in /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
	SELECT
		Authors.author_id, People.person_id AS author_person, Authors.first_name, Authors.last_name, 
		Authors.organization, Authors.country, Countries.country_name, 
		Authors.email, Authors.author_order, Authors.author_type,
		People.person_photo

	FROM
		((Authors INNER JOIN Papers ON Authors.author_paper=Papers.paper_id)
		LEFT JOIN Countries ON Authors.country=Countries.country_code)
		LEFT JOIN People ON Authors.author_person=People.person_id
	WHERE
		
			Papers.date_deleted IS NULL
		

		
			AND Authors.author_type <> 'C'
		

		
		

		
		
			
				AND Authors.author_paper=
					23018
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
PaperTopics (Datasource=aacepubs, Time=3.4 ms, Records=4) in /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
	SELECT
		Topics.topic_id, Topics.topic_name, Categories.category_id, Categories.category_name
	FROM
		(Topics LEFT JOIN Paper_Topics ON Topics.topic_id=Paper_Topics.topic_id )
		LEFT JOIN Categories ON Topics.topic_category=Categories.category_id
	WHERE
		
			Paper_Topics.paper_id = 23018
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
PaperTags (Datasource=aacepubs, Time=4.1 ms, Records=3) in /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
	SELECT
		Tags.tag_id, Tags.tag_text
	FROM
		(Tags LEFT JOIN Paper_Tags ON Tags.tag_id=Paper_Tags.tag_id )
	WHERE
		
			Paper_Tags.paper_id = 23018
		
	ORDER BY
		tag_text
References (Datasource=aacepubs, Time=3.37 ms, Records=0) in /var/sites/railo.editlib.org/models/papers/qry_references.cfm
	SELECT
		Paper_References.paperreference_id,
		Paper_References.paperreference_content,
		Paper_References.paperreference_authors,
		Paper_References.paperreference_doi,
		Paper_References.paperreference_date
	FROM
		Paper_References
	WHERE
		Paper_References.paperreference_paper = 23018
	ORDER BY
		Paper_References.paperreference_order
PaperFiles (Datasource=aacepubs, Time=3.34 ms, Records=1) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
Source (Datasource=aacepubs, Time=3.57 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 23018
		
Source (Datasource=aacepubs, Time=3.62 ms, Records=1) in /var/sites/railo.editlib.org/models/sources/qry_source.cfm
	SELECT
		Sources.source_id,
		Sources.source_title,
		Sources.source_type,
		Sources.source_abbr,
		Sources.source_issn,
		Sources.source_eissn,
		Sources.source_image,
		Sources.source_url,
		Sources.source_publisher,
		Sources.source_location,
		Sources.source_date,
		Sources.source_authors,
		Sources.source_serial,
		Sources.source_description,
		Sources.source_code,
		Sources.date_confirmed,
		Sources.confirmed_by,
		SourceIssues.sourceissue_id,
		SourceIssues.sourceissue_title,
		SourceIssues.sourceissue_location,
		SourceIssues.sourceissue_volume,
		SourceIssues.sourceissue_number,
		SourceIssues.sourceissue_authors,
		SourceIssues.sourceissue_date,
		SourceIssues.sourceissue_issn,
		SourceIssues.sourceissue_image,
		Journals.journal_accepts_submissions,
		COALESCE(Publishers.publisher_name, Sources.source_publisher) AS publisher_name,
		Publishers.publisher_url
	FROM
		(
			Sources LEFT JOIN SourceIssues 
			ON Sources.source_id=SourceIssues.sourceissue_source
			
		)
		
			INNER JOIN Papers on 
				(Papers.paper_source = Sources.source_id)
				AND (
					Papers.paper_sourceissue is null OR 
					Papers.paper_sourceissue = SourceIssues.sourceissue_id
				)
		
		LEFT JOIN Journals ON Sources.source_code=Journals.journal_code
		LEFT JOIN Publishers ON Sources.source_publisher=Publishers.publisher_code
	WHERE
		
			Sources.date_deleted IS NULL AND
			SourceIssues.date_deleted IS NULL
		
		
		
		
		
			AND Papers.paper_id = 23018
		
PaperFiles (Datasource=aacepubs, Time=3.43 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Presentations
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
				AND PaperFiles.paperfile_is_presentation=1
			
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.45 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Videos
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'video'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.71 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Slides
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
			
			
				AND paperfile_is_presentation = 1
				AND (
					paperfile_type IS NULL OR
					(paperfile_type <> 'paper' AND paperfile_type <> 'press')
				)
				AND (
					paperfile_format IS NULL OR
					paperfile_format <> 'FULL'
				)
				AND (
						PaperFiles.paperfile_name LIKE '%.ppt' OR
						PaperFiles.paperfile_name LIKE '%.pptx' OR
						PaperFiles.paperfile_name LIKE '%.pdf'
				)
			
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.4 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> MP3s
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
			AND 
			(
			
			
				
				PaperFiles.paperfile_name LIKE '%.mp3'
			
			)
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.44 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> URLs
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'url'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
PaperFiles (Datasource=aacepubs, Time=3.44 ms, Records=0) in /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
	
		-- PaperFiles --> Recordings
	
	SELECT
		paperfile_id, paperfile_name, paperfile_label, date_created, paperfile_type, paperfile_format, paperfile_mimetype, paperfile_paper, paperfile_is_presentation, paperfile_hidden
	FROM
		PaperFiles
	WHERE
		
			PaperFiles.paperfile_paper=23018
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
			AND lower(PaperFiles.paperfile_type)
				
					= 'recording'
				
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
AlsoAccessedPapers (Datasource=aacepubs, Time=333 ms, Records=25) in /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
	SELECT TOP 25
		Papers.paper_id AS related_paper, Papers.paper_title AS related_title, COUNT(*) AS number_of_accesses 
	FROM
		Access_Log AS Other_Papers_Accessed
		INNER JOIN Access_Log AS This_Paper ON 
			Other_Papers_Accessed.person_id=This_Paper.person_id AND 
			This_Paper.paper_id <> Other_Papers_Accessed.paper_id AND
			This_Paper.paper_id = 23018
			
		INNER JOIN Papers ON Other_Papers_Accessed.paper_id=Papers.paper_id
	WHERE
		Papers.date_deleted IS NULL AND
		Papers.date_added > '1970-01-01' AND
		Papers.paper_status='DL_PUBLISH'
	GROUP BY Papers.paper_id, Papers.paper_title
	ORDER BY 3 DESC
Paper_GetSource (Datasource=aacepubs, Time=9.56 ms, Records=1) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT source_type, source_code, sourceissue_date, sourceissue_volume, sourceissue_number, paper_status
		FROM
			(Sources INNER JOIN Papers ON Sources.source_id=Papers.paper_source)
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=23018
	
Paper (Datasource=aacepubs, Time=12.9 ms, Records=3) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
		SELECT 
			coalesce(paper_is_free,0) | coalesce(source_is_free,0) | coalesce(sourceissue_is_free,0) as paper_is_free, 
			paper_free_until, free_for_member, person_code, Authors.email
		FROM 
			Papers LEFT JOIN People ON Papers.paper_contact_person=People.person_id
			LEFT JOIN Authors ON Papers.paper_id=Authors.author_paper
			LEFT JOIN Sources ON Papers.paper_source=Sources.source_id
			LEFT JOIN SourceIssues ON Papers.paper_sourceissue=SourceIssues.sourceissue_id
		WHERE
			Papers.paper_id=23018
	
Journal_Is_Free (Datasource=aacepubs, Time=1.79 ms, Records=0) in /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
			SELECT journal_is_free
			FROM
				Journals
			WHERE
				journal_is_free=1 AND
				journal_code='EDMEDIA'
		
RecordedPresentations (Datasource=, Time=0.062 ms, Records=0) in /var/sites/railo.editlib.org/reader/dsp_abstract2014.cfm
		SELECT *
		FROM
			Presentations
		WHERE
			upper(Presentations.paperfile_format) = 'RECORDEDPRESENTATION'
	
GetActions (Datasource=aacepubs, Time=1.75 ms, Records=4) in /var/sites/railo.editlib.org/logger/act_logaccess.cfm
		SELECT accessaction_id, accessaction_name
		FROM
			Access_Actions
	
FullText_Log_INSERT (Datasource=aacepubs, Time=97.4 ms, Records=0) in /var/sites/railo.editlib.org/logger/act_logaccess.cfm
		INSERT INTO Access_Log ( action, access_action, date_accessed, institution_id, person_id, paper_id )
		VALUES (
			'VIEW',
			2,
			{ts '2016-02-12 16:08:14'},
			
				NULL
			,
			
				NULL
			,
			23018
			)
	


Scope Variables

Application Variables:
applicationname=editlib
INSTITUTION_IPS=Struct (89)
NON_INSTITUTION_IPS=Array (1144)
STRIPE=Component (editlib.classes.Stripe)
STRIPEAPIKEY=pk_live_2f49ME5ticd7g4iciQjG53Zh
CGI Variables:
auth_password=
auth_type=
auth_user=
cert_cookie=
cert_flags=
cert_issuer=
cert_keysize=
cert_secretkeysize=
cert_serialnumber=
cert_server_issuer=
cert_server_subject=
cert_subject=
cf_template_path=/var/sites/railo.editlib.org/index.cfm
content_length=
content_type=
context_path=
gateway_interface=
http_accept=text/html,application/xhtml+xml,application/xml;q=0.9,*/*;q=0.8
http_accept_encoding=x-gzip, gzip, deflate
http_accept_language=en-us,en-gb,en;q=0.7,*;q=0.3
http_connection=close
http_cookie=
http_host=www.editlib.org
http_referer=
http_user_agent=CCBot/2.0 (http://commoncrawl.org/faq/)
https=
https_keysize=
https_secretkeysize=
https_server_issuer=
https_server_subject=
local_addr=172.31.28.109
local_host=ip-172-31-28-109
path_info=
path_translated=/var/sites/railo.editlib.org/index.cfm
query_string=fuseaction=Reader.ViewAbstract&paper_id=23018
remote_addr=54.82.49.125
remote_host=54.82.49.125
remote_user=
request_method=GET
request_url=http://www.editlib.org/index.cfm?fuseaction=Reader.ViewAbstract&paper_id=23018
script_name=/index.cfm
server_name=www.editlib.org
server_port=80
server_port_secure=0
server_protocol=HTTP/1.0
server_software=
web_server_api=
Form Variables:
CACHE_CODE=23018p
Request Variables:
_nonessential_code=false
_nonessential_content=
_nonessential_triggered=false
access_logged=true
addtoken=false
cache_code=23018p
cache_counter=1
cfroot=/editlib
checked_for_user=true
confdatasource=conference
current_path=/p/23018/
current_url=/p/23018/
development_ips=63.172.201.5,82.111.242.163,71.48.156.102,65.41.111.68,71.53.208.41,71.53.210.238,196.205.118.231,41.196.180.26
domain=www.editlib.org
file_delimiter=/
fileroot=/var/sites/railo.editlib.org/
is_ajax=false
is_spider=true
layout=2014
login_javascript=
		
		
		
	
logindatasource=conference
loginpath=/login/
mailinglist_address=listserv@listserv.uh.edu
mailinglist_name=eductech
mailinglist_owner=jdprice@genesis.coe.uh.edu
mailinglist_password=bookstairs
maindatasource=aacepubs
maindatasource_ro=aacepubs_readonly
navigationhistory=Struct (2)
org.apache.catalina.AccessLog.Protocol=HTTP/1.0
org.apache.catalina.AccessLog.RemoteAddr=54.82.49.125
org.apache.catalina.AccessLog.RemoteHost=54.82.49.125
org.apache.catalina.AccessLog.ServerPort=80
page=Struct (13)
page_timeout=10
publications_scope=AACE
pubsdatasource=aacepubs
self=/
settings=Struct (47)
share_js=





site_name=EdITLib
stop_addtoken=true
webroot=/
Server Variables:
A0608BEC-0AEB-B46A-0E1E1EC5F3CE7C9C.1.1=Complex type
coldfusion=Struct (9)
IdentityTables=Struct (3)
java=Struct (8)
os=Struct (7)
railo=Struct (7)
separator=Struct (3)
servlet=Struct (1)
URL Variables:
fuseaction=Reader.ViewAbstract
paper_id=23018
READER_CACHE=1
Debug Rendering Time: 0 ms