Docstoc

DataSheet - Excel

Document Sample
DataSheet - Excel Powered By Docstoc
					Identifier LocalID

VenueName

VenueNameEng

VenueNameTranslated

TranslatedLanguage

Venue Name VenueNameTranslated

TranslatedLanguage

VenueStartDate

Venue Physical A VenueFutureStartDate VenueCloseDate BuildingName Street County

Venue Physical Address / Location StateProvince City Country

Venue Cont Postalcode Region1 Region2 Building

Venue Contact Address (if different from physical address) Street County StateProvince City Country

Postalcode

VenuePhone

Venue direct Contact information VenueFax VenueEmail VenueFax VenueVOIP VenueWebsite

VenueContact

VenueContactRole

VenueContactPhone

VenueContactFax

VenueContactEmail

VenueContactVOIP

VenueContactWebsite

Venue Contact P VenueContactOrg

Venue Contact Person VenueContactBuilding

VenueContactStreet

VenueContactCounty

VenueContactStateProvince

VenueContactCity

VeneuContactCountry

VeneuContactPostalcode

Ownership

Global Taxonomy BusinessMode AccessFee VenueType

Mobility

LocalLevel1

Local Taxonomy LocalLevel2 LocalLevel3 LocalLevel4

LocalLevel5

Presence of ICTs at the venue (yes or no)

Other Venue Information Program1 Program2 Tags

Source of Entry SourceOfInformation LastVerifyDate

Comments/Notes

Entry Category

Database Field

Identifier LocalID

Description This is a local identifier/ID which allows for linking the IPAI inventory record back to the country research teams' local data systems. This identifier can be any combination letters and numbers, and is not used within IPAI other than to provide a link back to the source record during data extraction. It is primarily used for CRTs to keep track of their data sources.

VenueName VenueNameEng VenueNameTranslated

Venue Name

VenueTranslatedLanguage VenueNameTranslated

VenueTranslatedLanguage VenueStartDate VenueFutureStartDate VenueCloseDate BuildingName Street County StateProvince City

The name of the venue recorded in the local langauge as the venue is known. Translation of the venue name from the local language to English (ENG). If desired, additional venue name translation to Spanish (ESP) or French (FRA). ISO 3 character code of the language venue name translated to. Choose from ESP (Spanish) and FRA (French) as necessary. If desired, additional venue name translation to Spanish (ESP) or French (FRA). ISO 3 character code of the language venue name translated to. Choose from ESP (Spanish) and FRA (French) as necessary. Date (if known) the venue first became operational If venue is planned but has not yet opened, the future date the venue is expected to become operational Date (if known) the venue stopped operation Name of the building in which the venue is located Street name of the venue, including building number and suite/unit number County or similar administrative subdivision State or province or similar administrative subdivision City, town, or township where venue is located

Venue Physical Address/Location

Venue Physical Address/Location

Country Postalcode Region1 Region2 BuildingName Street County StateProvince City Country Postalcode

Country code of the location of the venue, using standard 2 character ISO country code Postal or other delivery code Other regional grouping or administrative subdivision name Other regional grouping or administrative subdivision name Name of the building Street name, including building number and suite/uint number County or similar administrative subdivision State or province or similar administrative subdivision City, town, or township where venue is located Country code of the location, using standard 2 character ISO country code Postal or other delivery code Main phone number at venue location for general information inquiries Main FAX number at venue General E-mail for direct venue contact/general information inquiries General VOIP based access code and providor for general information inquiries General informative website for the venue Name of primary venue contact person Role the contact person plays, for example Director, Manager, Trainer, Volunteer etc Phone number(s) to reach the person Fax number(s) to reach the person E-mail address to reach the person VOIP access code and provider to reach the person

Venue Contact Address (if different)

Venue Direct Contact Information

VenuePhone VenueFax VenueEmail VenueVOIP VenueWebsite VenueContact VenueContactRole VenueContactPhone VenueContactFax VenueContactEmail VenueContactVOIP

VenueContactWebsite

If known/available, a specific website or webpage for the contact person If the person belongs to/is employed by on organization other then that operating the venue, the organization name

VenueContactOrg If the person belongs to/is employed by on organization other then that operating the venue, name of the building in VenueContactBuilding which the venue is located If the person belongs to/is employed by on organization other then that operating the venue, street name of the organization, including building number, and suite/unit VenueContactStreet number If the person belongs to/is employed by on organization other then that operating the venue, county or similar VenueContactCounty administrative subdivision of the organization If the person belongs to/is employed by on organization other then that operating the venue, state or province or VenueContactStateProvince similar administrative subdivision of the organization If the person belongs to/is employed by on organization other then that operating the venue, city, town, township VenueContactCity where venue is located of the organization If the person belongs to/is employed by on organization other then that operating the venue, country code of the location of the organization, using standard 2 character ISO country code If the person belongs to/is employed by on organization other then that operating the venue, postal or other delivery code of the organization Ownership category using IPAI Global Taxonomy: 1.1 Private 1.2 Public 1.3 NGO 1.4 Other

Venue Contact Person

VenueContactCountry

VenueContactPostalcode

Ownership

BusinessMode

AccessFee Global Taxonomy

Businessmode category using IPAI Global Taxonomy: 2.1 For-profit 2.2 Not-for-profit Accessfee category using IPAI Global Taxonomy: 3.1 Free 3.2 Paid 3.3 Not Applicable Venue type category using IPAI Global Taxonomy: 4.1 Library 4.2 School 4.3 Stand-alone facility (i.e., telecenters and cybercafés) 4.4 Other public access location 4.4.1 Government building 4.4.2 Post office 4.4.3 Religious institution 4.4.4 Other Mobility category category using IPAI Global Taxonomy: 5.1 Fixed 5.2 Mobile First level of the 5 level local taxonomy Second level of the 5 level local taxonomy Third level of the 5 level local taxonomy Fourth level of the 5 level local taxonomy Fifth level of the 5 level local taxonomy

VenueType

Mobility LocalLevel1 LocalLevel2 LocalLevel3 LocalLevel4 LocalLevel5

Local Taxonomy

Presence of ICTs at the venue

Serves as a confirmation that the venue has ICTs

Program1 Other Venue Informaiton Program2

Local country specific program venue maybe classifed by Local country specific program venue maybe classifed by

Other Venue Informaiton Tags Set of local tags which here comma (,) separated to allow for segementing of IPAI sites according to local needs. Local text field to record where the listing information was obtained from If known, the last time the exisitence of the location was verified

Source of Entry

SourceOfInformation LastVerifydate

Comments/Notes

Any general notes or comments about the venue

NOTES:

(1) -- Global Taxonomy should be entered using the numerical scheme as shown in attached Global Taxonomy document (2) -- Local Taxonomy consists up to a 5 levels deep schema, which must be pre-defined by the local country team and then consitently applied (see separate sample local taxonomy schema document).

Example

Required by CRTs

Notes

BIB-001

Liceo Jose Antonio Carvajal

Yes

Jose Antonio Carvajal Middle School Yes Collège Jose Antonio Carvajal

FRA

2009-09-01 2009-12-04 2010-01-01 IBM Building AVENIDA HENRIQUEZ Nº 198 Provincia Copiap COPIAPÓ Yes

Yes

CL

Yes

Región de Atacama

Willem Scholten Manager (206)-555-1212, (206)-444-1212 (Mobile) (206)-555-1213 wscholten@mac.com

this set of fields MAY BE repeated to list more then one key contact. This should however NOT be everyone you know who maybe associated with the venu, but rather key personel which may need to be contacted to obtain permission for surveys, or otherwise are important for the IPAI project to interact with the venue. When adding multiple contacts - use more rows for a IPAI center and make sure that the LocalID repeats for those rows. (See ExampleDataSheet)

who maybe associated with the venu, but rather key personel which may need to be contacted to obtain permission for surveys, or otherwise are important for the IPAI project to interact with the venue. When adding multiple contacts - use more rows for a IPAI center and make sure that the LocalID repeats for those rows. (See ExampleDataSheet)

Access For Children

Categories within the global taxonomy fields should be inputted as numbers that correspond to each category, as is provided in the final memo, Appendix I. Yes

Categories within the global taxonomy fields should be inputted as numbers that correspond to each category, as is provided in the final memo, Appendix I.

Yes

Yes

Yes

Yes

Yes

Yes this is used to consistently identify up to two national/regional programs a venue maybe part of, these are locally defined programme names/categories within each country inventory. As to tags, these are a set of lcoal defined tags -- similar as used in blogs and wikis, to categorize the venue. It is recommended that a list is maintaned with a general definition and use of the tag.

Biblioredes

pc, satelite internet, solar powered National Library Directory 2006 Edition Spring 2007, site visit

this is used to consistently identify up to two national/regional programs a venue maybe part of, these are locally defined programme names/categories within each country inventory. As to tags, these are a set of lcoal defined tags -- similar as used in blogs and wikis, to categorize the venue. It is recommended that a list is maintaned with a general definition and use of the tag.

Yes

Site is hard to reach, located in a mountain area where users walk on average 1 hour to reach facility

wn in attached Global Taxonomy document re-defined by the local country team and then

Identifier LocalID Example using Chile Data: PAI1 PAI2 PAI956 PAI957 PAI958

VenueName

VenueNameEng

ALFREDO WORMALD CRUZ TARAPACÁ ORIENTE COLEGIO JESUS SERVIDOR COLEGIO PARTICULAR ANDARES DE LA FLORIDA Casa de la Cultura

Example using Lituania Data:

2 Akmenės district savivaldybės Public Library 2 3 Alytaus Jurgio Kunčino Public Library 3 5 VšĮ Alytaus jaunimo centras 5 4 Alytaus Jurgio Kunčino Public Library 4

VenueNameTranslated

Venue Name TranslatedLanguage VenueNameTranslated

TranslatedLanguage

VenueStartDate

VenueFutureStartDate

VenueCloseDate

2003

2003

2003

2003

BuildingName

Street

Venue Physical Address / Location County StateProvince

Baquedano N° 094 Loa N° 2250 LITORAL 5787 GARCIA HURTADO DE MENDOZA N. 7541 Manuel Montt 295

V. Kudirkos g. 3/41

Šiauliai

Volungės g. 25

Alytus

Tvirtovės g. 3

Alytus

Jiezno g. 2

Alytus

l Address / Location City

Venue Contact Ad Country Postalcode Region1 Region2 Building

Arica Arica PEÑALOLÉN LA FLORIDA Carahue

CL CL CL CL CL

Arica y Parinacota Arica y Parinacota Metropolitana Metropolitana

Akmenės rajono Naujoji Akmenė LT 85146

Alytaus miesto Alytus LT 63175

Alytus

LT

62116

Alytaus miesto

Alytus miesto Alytus LT 62212

Venue Contact Address (if different from physical address) Street County StateProvince City Country

Postalcode

VenuePhone

Venue direct Contact information VenueFax VenueEmail VenueVOIP VenueWebsite

58-206368 58-262214 3159740 45-651873

b212bc1@abretumundo.cl b212bp1@abretumundo.cl jgalecio@educaceas.cl dario_andares@vtr.net bioro20@hotmail.com

VenueContact

VenueContactRole

VenueContactPhone

VenueContactFax

Zita Sinkevičienė Stakeholder Aurelija Gerulskienė Giedrė Bulgakovienė Marytė Molderienė Regina Vilkelienė Regina Vilkelienė Giedrė Bulgakovienė Angelė Jakimonienė Coordinator

8 425 47011 8 425 56396 8 315 31698 Stakeholder Coordinator Stakeholder Coordinator 8 315 31698 Stakeholder Coordinator 8 315 72775 8 315 32989 8 315 25915

8 425 47011

8 315 73102

8 315 25918 8 315 25915 8 315 73102

VenueContactEmail

VenueContactVOIP

VenueContactWebsite

Venue Contact Pers VenueContactOrg

zitcit@delfi.lt bibliotekele@langasiat eiti.lt giedreb@alytus.mvb.lt volungfil@freemail.lt ajc@ajc.lt ajc@ajc.lt giedreb@alytus.mvb.lt pirmvb@alytus.mvb.lt

Akmenės district savivaldybės Public Library

Alytaus Jurgio Kunčino Public Library

VšĮ Alytaus jaunimo centras

Alytaus Jurgio Kunčino Public Library

Venue Contact Person VenueContactBuilding

VenueContactStreet

VenueContactCounty

Nepriklausomybės a. 15A

Ligoninės g. 1C / Seirijų g. 2

Tvirtovės g. 3

Ligoninės g. 1C / Seirijų g. 2

VenueContactStateProvince

VenueContactCity

VeneuContactPostalcode

Naujoji Akmenė

85128

Alytus

62114

Alytus

62116

Alytus

62114

VeneuContactCountry

Ownership

BusinessMode

Global Taxonomy INternetAccessFee

LT

LT

LT

LT

nomy VenueType Mobility LocalLevel1

Local Taxonomy LocalLevel2 LocalLevel3 LocalLevel4

LocalLevel5

Presence of ICTs at the venue (yes or no) yes yes yes yes yes yes yes yes yes yes yes

Other Venue Information Program1 Program2

Biblioredes Biblioredes E&C E&C Red Comunitaria

LĮA yes yes LĮA yes yes yes yes LĮA yes yes Public Library LĮA Public Library Public Library

ue Information Tags

VenueContact

VenueContactRole VenueContactPhone

VenueContactFax

VenueContactEmail

VenueContactVOIP

VenueContactWebsite

VenueContactOrg

Venue Contact Person VenueContactBuilding

ontact Person VenueContactStreet

VenueContactCounty

VenueContactStateProvince

VenueContactCity

VeneuContactCountry

Source of Entry VeneuContactPostalcode SourceOfInformation LastVerifyDate

Comments/Notes


				
DOCUMENT INFO
Shared By:
Tags: DataS, heet
Stats:
views:88
posted:11/28/2009
language:English
pages:45
Description: DataSheet