{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["BEFORE ENTERING INFO","PII","StuTeamToSchool"],"not_rendered":{"charts":0,"images":0,"macros":0,"external_links":0,"defined_names":0,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"run_cost":"one","rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"BEFORE ENTERING INFO","index":0,"n_rows":19,"n_cols":2,"rows_kept":19,"cut":false,"hidden":false,"merged":[]}
[null,"COLORS OF CELLS IN COLUMN A OF THIS SHEET CORRESPOND TO COLORS OF TABS IN THIS WORKBOOK. (You can safely delete this row if desired.)"]
[null,"Esri 2021 ArcGIS Online Competition for US High Schools and Middle Schools (https://esriurl.com/agoschoolcomp)"]
["NOTE#","Students/Parents/Guardians/Mentors: Please read these notes carefully. They deal with submission process, not the content of the creation."]
[null,"((school leader: Substitute your/state's info for the red text below before distributing this doc to students.))"]
[1.0,"This tab has important reminders to students about how to submit entries to the school competition. Schools must submit entries to the state using the info identified in this spreadsheet."]
[2.0,"The \"StuTeamToSchool\" tab is what students must provide to the school. All info in columns B-P must be provided."]
[3.0,"Contents in yellow columns A-K of \"StuTeamToSchool\" tab describe the entry. Contents in blue columns L-P describe the school to which the entry is going."]
[4.0,"An example entry is provided in the pink row. Students' entries should match this format."]
[5.0,"Each student may participate in only one entry. Student teams may have only 1 or 2 students."]
[6.0,"This event calls students in grades 9-12 \"HS\" and students in grades 4-8 \"MS\". In \"Entry Level\" (column C) enter the highest level student in this entry."]
[7.0,"In \"STU# name\" (columns E and H), indicate whether a student's name used will be \"real\" or \"generic\". (This helps minimize personally identifiable info. See the \"PII\" tab.)"]
[8.0,"Only real names may be submitted as state nominees to the national competition, but generic names may be used in school or state competition and could be state award winners. "]
[9.0,"If submitting \"generic names,\" use the format \"[ST]_[SchoolName]_[EntryNumber]\" (and append \"a\" and \"b\" if the entry is from 2 students)."]
[10.0,"Columns J-K are for hyperlink entries for the \"Item Details\" page and the actual App/StoryMap. Both should be in shortURL format such as \"https://arcg.is/1a2b3c4d\"."]
[11.0,"ShortURLs of the proper format can be created easily. See item \"V.5\" at \"https://esriurl.com/agoschoolcompinfo\". "]
[12.0,"ENTRY DEADLINE FOR _[school]_ = MM/DD/2021, HH:MM _[timezone]_"]
[13.0,"STUDENTS: PROVIDE COMPLETED SPREADSHEET TO \"[teacher_email_address]\" AND KEEP A COPY FOR YOURSELF."]
[14.0,"More info about the Kentucky Map Competition is available at http://www.kgalliance.org/2021-arcgis-online-competition-for-us-hsms-students.html ."]
[null,"If the school submits real names or other personally identifiable information of any students, the school must obtain written consent from the student (or the student's parent if the student is a minor) to transfer that information to Esri for the purposes of evaulating and processing entries, selecting winners, and contacting students, schools, and sponsors for purposes related to the contest. See the \"PERMISSION AND RELEASE FORM,\" which addresses content, authorship, permissions, and student name, words, and likeness, in case of selection as awardee."]

{"sheet":"PII","index":1,"n_rows":11,"n_cols":2,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["Note#","Personally Identifiable Information = PII"]
[1.0,"PII is a concern for many students, families, schools, districts, and general citizens. Esri seeks to minimize the PII in this competition."]
[2.0,"Esri's document \"ArcGIS Online Orgs for K12 Schools\" (https://esriurl.com/agoorgsforschools) provides strategies for minimizing use of PII."]
[3.0,"AGO Org admins are encouraged to use generic usernames, profiles, and emails. Content to be made public can be transferred to a \"showcase login\" in the Org, as noted in the doc above."]
[4.0,"In this competition, teachers should help students avoid exposing their own PII in logins, profiles, map layers, map products, and documentation."]
[5.0,"Teachers should also help students guard against sharing inappropriately any PII of other people, in map layers, photos, popups, and so forth. "]
[6.0,"Esri seeks from states only the names of the 1HS+1MS entries to the national level challenge. All other entries going from state to Esri will be identified generically."]
[7.0,"In submitting entries by students to school, students should use generic identifiers unless you have signed approval by the student (or, if a minor, by the student's parent/guardian)."]
[8.0,"In submitting entries from school to state, schools should use generic identifiers unless you have signed approval by the student (or, if a minor, by the student's parent/guardian)."]
[9.0,"Students should be listed as \"[ST]_[SchoolName]_EntryCode\" unless an appropriate permission slip is provided. Schools should keep any such permissions safely on file."]
[10.0,"Esri is providing an example permission slip; schools and states may devise your own, as long as it is it includes all the information found in Esri's example."]

{"sheet":"StuTeamToSchool","index":2,"n_rows":3,"n_cols":16,"rows_kept":3,"cut":false,"hidden":false,"merged":[]}
["School Entry Data","Entry Title","Entry Level (MS-HS)","STU#1 grade","STU#1 name choice (real or generic)","STU#1 name (Use \"Fname Lname\" or \"[ST]_[School]_[#]\")","(if 2) STU#2 grade","(if 2) STU#2 name choice (real or generic)","(if 2) STU#2 name (Use \"Fname Lname\" or \"[ST]_[School]_[#]\")","ShortURL for Entry's Item_Details Page","ShortURL for actual App/StoryMap","School Name","School Street Address","School City","School State Abbr","School ZIP (5)"]
["example","My Community, My Home","HS",9.0,"real","Jane Doe",8.0,"generic","MN_TheMercatorSchool_0b","https://arcg.is/1abc9xyz","https://arcg.is/1A2b3C4d","The Mercator School","1712 Randolph Ave","St. Paul","MN","01234"]
["Actual Entry"]