{"text_format":"2","workbook":"xlsx","n_sheets":3,"sheets":["BEFORE ENTERING INFO","PII","SCHOOL TO STATE ENTRIES"],"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.)"]
["NOTE#","School Competition Leader: Please read these notes carefully. Only properly submitted entries can be considered. General info at https://esriurl.com/agoschoolcomp"]
[1.0,"This tab has important reminders about how to submit entries to the state competition. Schools must submit entries to the state using this spreadsheet."]
[2.0,"The \"School to State Entries\" tab is what schools need to fill out and send to the state. All cells in a row with an entry must be completed."]
[3.0,"Contents in yellow columns A-K of \"School to State Entries\" tab will be unique for each row of 5 entries. Contents in blue columns L-V will be the same for each row of 5 entries."]
[4.0,"An example entry is provided as \"School entry# 0\" in the pink row. Your entries should match this format."]
[5.0,"Each school is permitted a maximum of 5 entries (total, across both HS+MS) to the state level competition. If more are submitted, only entries 1-5 will be considered."]
[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 state competition and may be recognized as 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, \"https://arcg.is/(etc)\"."]
[11.0,"ShortURLs of the proper format can be created easily. See item \"V.5\" at \"https://esriurl.com/agoschoolcompinfo\". "]
[12.0,"Find LAT/LONG in decimal degree in an AGO map via the Measure tool (set to \"Location\") and moving the mouse to show the desired spot. (Or see https://arcg.is/1D9vMBe.)"]
[13.0,"In Rows 10 and 11, in Column A, input the total number of submissions received and considered by the school at HS and at MS levels. (Either or both numbers may exceed 5.)"]
[14.0,"ENTRY DEADLINE FOR Kentucky = 04/15/2021, 5:00PM CST"]
[15.0,"EMAIL COMPLETED SPREADSHEET TO \"kga@wku.edu\" AND COPY YOURSELF."]
[16.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."]

{"sheet":"PII","index":1,"n_rows":10,"n_cols":2,"rows_kept":10,"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 made public should be transferred to a \"showcase login\" in the Org."]
[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 guard against students 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 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)."]
[8.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."]
[9.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":"SCHOOL TO STATE ENTRIES","index":2,"n_rows":11,"n_cols":22,"rows_kept":11,"cut":false,"hidden":false,"merged":[]}
["School Entry#","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)","School LAT (dd.dddd)","School LONG (ddd.dddd)","Supporting Teacher FNAME","Supporting Teacher LNAME","Supporting Teacher EMAIL","Supporting Teacher PHONE"]
[0.0,"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",44.9263,-93.1725,"Charlie","Fitzpatrick","schools@esri.com","909-793-2853"]
[1.0,{"$nulls":8},"https://arcg.is/","https://arcg.is/"]
[2.0]
[3.0]
[4.0]
[5.0]
["Only 5 entries","Only 5 entries permitted above","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries permitted above","Only 5 entries","Only 5 entries permitted","Only 5 entries permitted above","Only 5 entries permitted above","Only 5 entries permitted above","Only 5 entries permitted","Only 5 entries permitted","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries","Only 5 entries"]
[]
[0.0,"TOTAL HS entries received  (may exceed 5)"]
[0.0,"TOTAL MS entries received   (may exceed 5)"]