Login or register for free to remove ads.

More than code: The significance of social interactions in young people's development as interactive media creators PROCEEDINGS

, MIT Media Lab, United States ; , , Harvard University, United States ; , , MIT Media Lab, United States

AACE Award

EdMedia: World Conference on Educational Media and Technology, in Lisbon, Portugal ISBN 978-1-880094-89-1 Publisher: Association for the Advancement of Computing in Education (AACE)

Abstract

Being able to design interactive media is an important capacity for young people to develop in order to understand and negotiate our modern media landscape. Scratch (http://scratch.mit.edu) is a programming environment that enables young people to create their own interactive media and share their creations within an online community. In this paper, we describe the ways in which young people’s development as creators of interactive media is supported by others, using the context of the Scratch online community. Through a series of six case studies, we focus on the social nature of young people’s participation, and the shifting and unexpected roles that they take on in the community. We discuss what the case studies have in common (opportunities to imagine, program, and share) and we suggest making similar opportunities available to young people situated in other learning environments.

Citation

Brennan, K., Valverde, A., Prempeh, J., Roque, R. & Chung, M. (2011). More than code: The significance of social interactions in young people's development as interactive media creators. In T. Bastiaens & M. Ebner (Eds.), Proceedings of EdMedia: World Conference on Educational Media and Technology 2011 (pp. 2147-2156). 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 11, 2016 11:33 PM
Time Zone UCT
Locale English (us)
User Agent CCBot/2.0 (http://commoncrawl.org/faq/)
Remote IP 54.160.221.82
Host Name www.editlib.org
Architecture 64bit


Execution Time

Total Time Avg Time Count Template
612 ms 612 ms 1 /var/sites/railo.editlib.org/logger/qry_alsoaccessedpapers.cfm
167 ms 167 ms 1 /var/sites/railo.editlib.org/logger/act_logaccess.cfm
21.9 ms 21.9 ms 1 /var/sites/railo.editlib.org/security/act_checkforpaperaccess.cfm
10.8 ms 10.8 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papers.cfm
18 ms 6.01 ms 3 /var/sites/railo.editlib.org/models/sources/qry_source.cfm
10.4 ms 5.2 ms 2 /var/sites/railo.editlib.org/models/papers/qry_paper.cfm
7.12 ms 3.56 ms 2 /var/sites/railo.editlib.org/models/papers/qry_authors.cfm
24.7 ms 3.53 ms 7 /var/sites/railo.editlib.org/models/paperfiles/qry_paperfiles.cfm
3.48 ms 3.48 ms 1 /var/sites/railo.editlib.org/models/papers/qry_papertags.cfm
6.89 ms 3.44 ms 2 /var/sites/railo.editlib.org/models/papers/qry_papertopics.cfm
3.36 ms 3.36 ms 1 /var/sites/railo.editlib.org/models/papers/qry_references.cfm
1.45 ms 1.45 ms 1 /var/sites/railo.editlib.org/layouts/lay_new_2014.cfm
2.45 ms 1.22 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/cache.cfm
2.24 ms 1.12 ms 2 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/ini2struct.cfm
1.46 ms 0.733 ms 2 /var/sites/railo.editlib.org/reader/inc_share.cfm
0.218 ms 0.218 ms 1 /var/sites/railo.editlib.org/Application.cfm
0.199 ms 0.199 ms 1 /var/sites/railo.editlib.org/models/papers/act_generatecitation.cfm
0.117 ms 0.117 ms 1 /var/sites/railo.editlib.org/models/sources/act_generatesourcetext.cfm
0.056 ms 0.056 ms 1 /var/sites/railo.editlib.org/OnRequestEnd.cfm
0.152 ms 0.05 ms 3 /var/sites/railo.editlib.org/security/act_identifyinstitution.cfm
0.047 ms 0.047 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.034 ms 0.034 ms 1 /var/sites/railo.editlib.org/logger/act_lognavigationhistory.cfm
0.033 ms 0.033 ms 1 /var/sites/railo.editlib.org/security/act_determinesubscriptions.cfm
0.033 ms 0.033 ms 1 /var/sites/railo.editlib.org/reader/inc_collections.cfm
0.063 ms 0.031 ms 2 /var/sites/railo.editlib.org/reader/inc_login.cfm
0.693 ms 0.027 ms 25 /var/sites/railo.editlib.org/fbx_Layouts.cfm
0.027 ms 0.027 ms 1 /var/sites/railo.editlib.org/reader/inc_breadcrumb.cfm
0.659 ms 0.026 ms 25 /var/sites/railo.editlib.org/fbx_Settings.cfm
0.089 ms 0.022 ms 4 /var/sites/railo.editlib.org/logger/fbx_Switch.cfm
0.048 ms 0.012 ms 4 /var/sites/railo.editlib.org/logger/fbx_Settings.cfm
0.283 ms 0.011 ms 25 /var/sites/railo.editlib.org/fbx_Circuits.cfm
0.077 ms 0.011 ms 7 /var/sites/railo.editlib.org/models/papers/fbx_Switch.cfm
0.191 ms 0.01 ms 18 /var/sites/railo.editlib.org/WEB-INF/railo/customtags/nonessential.cfm
0.037 ms 0.009 ms 4 /var/sites/railo.editlib.org/logger/fbx_Layouts.cfm
0.025 ms 0.008 ms 3 /var/sites/railo.editlib.org/models/sources/fbx_Switch.cfm
0.024 ms 0.008 ms 3 /var/sites/railo.editlib.org/security/fbx_Settings.cfm
0.022 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Layouts.cfm
0.022 ms 0.007 ms 3 /var/sites/railo.editlib.org/security/fbx_Switch.cfm
0.159 ms 0.006 ms 25 /var/sites/railo.editlib.org/fbx_fusebox30_CF50_nix.cfm
0.153 ms 0.006 ms 25 /var/sites/railo.editlib.org/functions.cfm
0.032 ms 0.004 ms 7 /var/sites/railo.editlib.org/models/paperfiles/fbx_Switch.cfm
0.004 ms 0.004 ms 1 /var/sites/railo.editlib.org/reader/fbx_Layouts.cfm
0.02 ms 0.002 ms 7 /var/sites/railo.editlib.org/models/papers/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/models/sources/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_Settings.cfm
0 ms 0 ms 1 /var/sites/railo.editlib.org/reader/fbx_Switch.cfm
0.917 ms  STARTUP, PARSING, COMPILING, LOADING, & SHUTDOWN
13.2 ms  APPLICATION EXECUTION TIME
884 ms  QUERY EXECUTION TIME
899 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=6.71 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=38158
		
GetPapers (Datasource=aacepubs_readonly, Time=10.7 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=38158
					)
				
		
			
					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.6 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=38158
		
Source (Datasource=aacepubs, Time=3.87 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 = 38158
		
PaperTopics (Datasource=aacepubs, Time=3.44 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 = 38158
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
Authors (Datasource=aacepubs, Time=3.55 ms, Records=5) 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=
					38158
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
Authors (Datasource=aacepubs, Time=3.47 ms, Records=5) 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=
					38158
			
		
	ORDER BY
		
		
				Authors.author_order, Authors.author_id, Authors.last_name, Authors.first_name
			
PaperTopics (Datasource=aacepubs, Time=3.36 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 = 38158
		
		
			AND Topics.topic_is_public=1
		
	ORDER BY
		category_name, topic_order, topic_name
PaperTags (Datasource=aacepubs, Time=3.44 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 = 38158
		
	ORDER BY
		tag_text
References (Datasource=aacepubs, Time=3.33 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 = 38158
	ORDER BY
		Paper_References.paperreference_order
PaperFiles (Datasource=aacepubs, Time=3.36 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=38158
		
		
			AND PaperFiles.date_deleted IS NULL
		
		
		
		
			AND PaperFiles.paperfile_name > ''
		
		
			AND PaperFiles.paperfile_hidden = 0
		
		
	ORDER BY
		
		
				date_created DESC
			
Source (Datasource=aacepubs, Time=6.35 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 = 38158
		
Source (Datasource=aacepubs, Time=7.7 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 = 38158
		
PaperFiles (Datasource=aacepubs, Time=3.42 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=38158
		
		
			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.47 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=38158
		
		
			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.69 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=38158
		
		
			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.53 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=38158
		
		
			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=38158
		
		
			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.42 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=38158
		
		
			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=612 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 = 38158
			
		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.09 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=38158
	
Paper (Datasource=aacepubs, Time=11.7 ms, Records=5) 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=38158
	
Journal_Is_Free (Datasource=aacepubs, Time=1.77 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.112 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.74 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=164 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-11 23:33:49'},
			
				NULL
			,
			
				NULL
			,
			38158
			)
	


Scope Variables

Application Variables:
applicationname=editlib
INSTITUTION_IPS=Struct (9)
NON_INSTITUTION_IPS=Array (74)
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=38158
remote_addr=54.160.221.82
remote_host=54.160.221.82
remote_user=
request_method=GET
request_url=http://www.editlib.org/index.cfm?fuseaction=Reader.ViewAbstract&paper_id=38158
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=38158p
Request Variables:
_nonessential_code=false
_nonessential_content=
_nonessential_triggered=false
access_logged=true
addtoken=false
cache_code=38158p
cache_counter=1
cfroot=/editlib
checked_for_user=true
confdatasource=conference
current_path=/p/38158/
current_url=/p/38158/
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.160.221.82
org.apache.catalina.AccessLog.RemoteHost=54.160.221.82
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=38158
READER_CACHE=1
Debug Rendering Time: 0 ms