Login or register for free to remove ads.

Evaluating and Researching Video Enhanced Learning Environments PROCEEDINGS

, Waikato Institute of Technology, New Zealand ; , Shimane University, Japan

EdMedia: World Conference on Educational Media and Technology, in Toronto, Canada ISBN 978-1-880094-81-5 Publisher: Association for the Advancement of Computing in Education (AACE)

Abstract

The increased sophistication and decreasing costs of digital cameras, the ease of use of video editing software applications and the growing maturity of digital delivery platforms has led to a significant increase in the use of video to enhance digitally based learning environments. A key question to be addressed is, what are the impacts of this increased use of video on the educational experiences of learners? While it is possible to employ a number of methods to observe, investigate and report on the use of video in teaching and learning these studies can be time consuming, often expensive to conduct and the findings are not unproblematic. The purpose of this paper is to explore how video enhanced learning environments can be investigated in a reliable, efficient and economical way.

Citation

Clayton, J. & Iwata, J. (2010). Evaluating and Researching Video Enhanced Learning Environments. In J. Herrington & C. Montgomerie (Eds.), Proceedings of EdMedia: World Conference on Educational Media and Technology 2010 (pp. 3101-3106). 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 5:35 AM
Time Zone UCT
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.196.244.206
Host Name www.editlib.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
353 ms 353 ms 1 /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
316 ms 316 ms 1 /var/sites/railo.editlib.org/logger/act_logaccess.cfm
23.8 ms 23.8 ms 1 /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
10.3 ms 10.3 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
12.2 ms 4.06 ms 3 /var/sites/railo.editlib.org/models/sources/qry_source.cfm
8.03 ms 4.01 ms 2 /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
3.62 ms 3.62 ms 1 /var/sites/railo.editlib.org/layouts/lay_new_2014.cfm
6.85 ms 3.42 ms 2 /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
23.9 ms 3.42 ms 7 /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
6.56 ms 3.28 ms 2 /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
3.27 ms 3.27 ms 1 /var/sites/railo.editlib.org/models/papers/qry_references.cfm
3.25 ms 3.25 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
2.28 ms 1.14 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/cache.cfm
2.17 ms 1.08 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/ini2struct.cfm
1.07 ms 0.538 ms 2 /var/sites/railo.editlib.org/reader/inc_share.cfm
0.22 ms 0.22 ms 1 /var/sites/railo.editlib.org/Application.cfm
0.176 ms 0.176 ms 1 /var/sites/railo.editlib.org/models/papers/act_generatecitation.cfm
0.1 ms 0.1 ms 1 /var/sites/railo.editlib.org/models/sources/act_generatesourcetext.cfm
0.055 ms 0.055 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.081 ms 0.04 ms 2 /var/sites/railo.editlib.org/logger/act_readnavigationhistory.cfm
0.116 ms 0.038 ms 3 /var/sites/railo.editlib.org/security/act_identifyinstitution.cfm
0.067 ms 0.033 ms 2 /var/sites/railo.editlib.org/reader/inc_login.cfm
0.033 ms 0.033 ms 1 /var/sites/railo.editlib.org/reader/inc_collections.cfm
0.029 ms 0.029 ms 1 /var/sites/railo.editlib.org/security/act_determinesubscriptions.cfm
0.028 ms 0.028 ms 1 /var/sites/railo.editlib.org/reader/inc_breadcrumb.cfm
0.685 ms 0.027 ms 25 /var/sites/railo.editlib.org/fbx_Layouts.cfm
0.025 ms 0.025 ms 1 /var/sites/railo.editlib.org/logger/act_lognavigationhistory.cfm
0.621 ms 0.024 ms 25 /var/sites/railo.editlib.org/fbx_Settings.cfm
0.086 ms 0.021 ms 4 /var/sites/railo.editlib.org/logger/fbx_Switch.cfm
0.036 ms 0.012 ms 3 /var/sites/railo.editlib.org/security/fbx_Switch.cfm
0.291 ms 0.011 ms 25 /var/sites/railo.editlib.org/fbx_Circuits.cfm
0.081 ms 0.011 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Switch.cfm
0.044 ms 0.011 ms 4 /var/sites/railo.editlib.org/logger/fbx_Settings.cfm
0.038 ms 0.009 ms 4 /var/sites/railo.editlib.org/logger/fbx_Layouts.cfm
0.026 ms 0.008 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Switch.cfm
0.152 ms 0.008 ms 18 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/nonessential.cfm
0.19 ms 0.007 ms 25 /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm
0.021 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Layouts.cfm
0.143 ms 0.005 ms 25 /var/sites/railo.editlib.org/functions.cfm
0.03 ms 0.004 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.007 ms 0.002 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Settings.cfm
0.002 ms 0.002 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.013 ms 0.001 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Settings.cfm
0.012 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.899 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
14.4 ms  APPLICATION EXECUTION TIME
766 ms  QUERY EXECUTION TIME
781 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.96 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=35085
		
GetPapers (Datasource=aacepubs_readonly, Time=10.2 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=35085
					)
				
		
			
					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=3.97 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=35085
		
Source (Datasource=aacepubs, Time=4.11 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 = 35085
		
PaperTopics (Datasource=aacepubs, Time=3.24 ms, Records=0) 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 = 35085
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
Authors (Datasource=aacepubs, Time=3.43 ms, Records=2) 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=
					35085
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
Authors (Datasource=aacepubs, Time=3.34 ms, Records=2) 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=
					35085
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
PaperTopics (Datasource=aacepubs, Time=3.25 ms, Records=0) 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 = 35085
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
PaperTags (Datasource=aacepubs, Time=3.22 ms, Records=1) 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 = 35085
		
	ORDER BY
		tag_text
References (Datasource=aacepubs, Time=3.24 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 = 35085
	ORDER BY
		Paper_References.paperreference_order
PaperFiles (Datasource=aacepubs, Time=3.33 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=35085
		
		
			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.55 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 = 35085
		
Source (Datasource=aacepubs, Time=4.39 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 = 35085
		
PaperFiles (Datasource=aacepubs, Time=3.44 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=35085
		
		
			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.32 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=35085
		
		
			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.32 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=35085
		
		
			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.35 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=35085
		
		
			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.42 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=35085
		
		
			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.38 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=35085
		
		
			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=353 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 = 35085
			
		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=8.48 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=35085
	
Paper (Datasource=aacepubs, Time=12.6 ms, Records=2) 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=35085
	
Journal_Is_Free (Datasource=aacepubs, Time=2.4 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.066 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.71 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=313 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 05:35:53'},
			
				NULL
			,
			
				NULL
			,
			35085
			)
	


Scope Variables

Application Variables:
applicationname=editlib
INSTITUTION_IPS=Struct (49)
NON_INSTITUTION_IPS=Array (465)
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=35085
remote_addr=54.196.244.206
remote_host=54.196.244.206
remote_user=
request_method=GET
request_url=http://www.editlib.org/index.cfm?fuseaction=Reader.ViewAbstract&paper_id=35085
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=35085p
Request Variables:
_nonessential_code=false
_nonessential_content=
_nonessential_triggered=false
access_logged=true
addtoken=false
cache_code=35085p
cache_counter=1
cfroot=/editlib
checked_for_user=true
confdatasource=conference
current_path=/p/35085/
current_url=/p/35085/
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.196.244.206
org.apache.catalina.AccessLog.RemoteHost=54.196.244.206
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)
java=Struct (8)
os=Struct (7)
railo=Struct (7)
separator=Struct (3)
servlet=Struct (1)
URL Variables:
fuseaction=Reader.ViewAbstract
paper_id=35085
READER_CACHE=1
Debug Rendering Time: 0 ms