{"id":715,"date":"2019-08-27T16:21:37","date_gmt":"2019-08-27T16:21:37","guid":{"rendered":"https:\/\/www.spriglearning.com\/support\/?post_type=ht_kb&p=715"},"modified":"2020-01-03T16:47:35","modified_gmt":"2020-01-03T16:47:35","slug":"how-do-i-upload-my-school-and-classroom-data","status":"publish","type":"ht_kb","link":"https:\/\/support.staging.spriglearning.com\/?ht_kb=how-do-i-upload-my-school-and-classroom-data","title":{"rendered":"1. How do I upload my school and classroom data?"},"content":{"rendered":"

Once you have received your account information from the Sprig team, you will need to sign into your admin account to create user accounts, schools and classrooms. This article is intended for new clients to the platform and is broken up into four steps that will guide you throughout the creation of accounts, schools and classrooms:<\/p>\n

    \n
  1. Generate Data Template<\/strong> – In this step you will create the schools and classrooms participating in the program and generate the template you will use to upload your school\/classroom data.<\/li>\n
  2. Enter School\/Classroom Data<\/strong> – In this step you will download your generated template and populate it with real school\/classroom data .<\/li>\n
  3. Upload School\/Classroom Data<\/strong> – In this step you will upload the completed data template and resolve errors if any are found in the template.<\/li>\n
  4. Review Data in Portal<\/strong>\u00a0– In this step you will review your uploaded school and classroom data in the portal.<\/li>\n<\/ol>\n

    1. Generate Data Template<\/strong><\/h3>\n
    1.1 Add School<\/strong><\/h5>\n

    Click\u00a0+Add School\u00a0<\/strong>to create a new school.<\/p>\n

    \"\"<\/p>\n

    Enter the name of the school joining the program, click\u00a0Save.<\/strong><\/p>\n

    \"\"<\/p>\n

    You now have now added a school to your template. To add another school, click\u00a0+Add School\u00a0<\/strong>and repeat the step above.<\/p>\n

    \"\"<\/p>\n

    To edit<\/strong> or delete<\/strong>\u00a0the school, click on the corresponding icons next to the school name.<\/p>\n

    \"\"<\/p>\n

    1.2 Add Classroom<\/strong><\/h5>\n

    Click\u00a0+Add Classroom\u00a0<\/strong>to create a new classroom.<\/p>\n

    \"\"<\/p>\n

    Enter a name for the classroom that will be used to identify it throughout the academic term, click\u00a0Save.<\/strong><\/p>\n

    \"\"<\/p>\n

    You now have now added a classroom to a school in your template. To add another classroom, click\u00a0+Add Classroom\u00a0<\/strong>and repeat the step above.<\/p>\n

    \"\"<\/p>\n

    1.3 Generate Template<\/strong><\/h5>\n

    Once you have added your schools and classrooms, generate your data template by clicking Generate Template.<\/strong><\/p>\n

    \"\"<\/p>\n

    If you have created all of your schools and classrooms, click Yes, Generate Template.\u00a0<\/strong><\/p>\n

    \"\"<\/p>\n

    2. Enter School\/Classroom Data<\/strong><\/h3>\n
    2.1 Download Template<\/strong><\/h5>\n

    Click Download Template\u00a0<\/strong>to download the template containing your schools and classrooms.<\/p>\n

    \"\"<\/p>\n

    Open\u00a0Sprig Data Template.xlsx<\/strong>.<\/p>\n

    \"\"<\/p>\n

    2.2 Data Template<\/strong><\/h5>\n

    Your template will be used to upload school\/classroom data. The template contains three types of worksheets:<\/p>\n

      \n
    • Schools<\/strong> – A snapshot of the schools and classrooms in the template.<\/li>\n
    • Classroom<\/strong> – This is where you enter classroom specific data (Students\/Teacher).<\/li>\n
    • Administration<\/strong> –\u00a0This is where you enter client specific data (Administrators\/Principals\/Additional Teachers).<\/li>\n<\/ul>\n

      \"\"<\/p>\n

      2.3 Data Template (Classroom Sheet)<\/strong><\/h5>\n

      Every classroom created when generating your template will have a corresponding Classroom Sheet<\/strong>. You will use this sheet to add student and teacher data to a classroom. Classroom sheets contain two editable tables\u00a0 :<\/p>\n

        \n
      • Student Information<\/strong> -This is where you enter information for the students in the classroom.<\/li>\n
      • Teacher Information<\/strong> -This is where you enter information for the teacher(s) in the classroom.<\/li>\n<\/ul>\n

        \"\"<\/p>\n

        2.3.1 Data Template (Classroom Sheet\/Student Information)<\/strong><\/h5>\n

        Using the first entry as an example in the Student Information<\/strong> table, enter information for all of the students in the classroom. The table asks for the following fields:<\/p>\n

          \n
        • First Name<\/strong><\/li>\n
        • Last Name<\/strong><\/li>\n
        • Date of Birth (Optional)<\/strong><\/li>\n
        • Grade<\/strong><\/li>\n
        • Gender (Optional)<\/strong><\/li>\n
        • Indigenous Identity? (Optional)<\/strong><\/li>\n<\/ul>\n

          * Grade<\/strong>, Gender<\/strong> & Indigenous Identity?<\/strong> all contain pre-defined options.<\/p>\n

          \"\"<\/p>\n

          2.3.2 Data Template (Classroom Sheet\/Teacher Information)<\/strong><\/h5>\n

          Using the first entry as an example in the Teacher Information<\/strong> table, enter information for all of the teachers in the classroom. The table asks for the following fields:<\/p>\n

            \n
          • First Name<\/strong><\/li>\n
          • Last Name<\/strong><\/li>\n
          • Email<\/strong><\/li>\n<\/ul>\n

            \"\"<\/p>\n

            2.4 Data Template (Administration Sheet)<\/strong><\/h5>\n

            Your template will also contain an Administration Sheet<\/strong>.\u00a0You will use this sheet to add directors, superintendents, principals and additional teachers to the program. The administration sheet contains three editable tables\u00a0 :<\/p>\n

              \n
            • Administration Information<\/strong> -This is where you enter information for directors and superintendents participating in the program.<\/li>\n
            • Principal Information<\/strong> -This is where you enter information for principals participating in the program.<\/li>\n
            • Additional Teacher Information<\/strong> -This is where you enter information for additional teachers participating in the program but haven’t been added to classroom yet.<\/li>\n<\/ul>\n

              \"\"<\/p>\n

              2.4.1 Data Template (Administration Sheet\/Administrator Information)<\/strong><\/h5>\n

              Using the first entry as an example in the\u00a0Administrator<\/strong>\u00a0Information<\/strong> table, enter information for any directors or superintendents participating in the program. The table asks for the following fields:<\/p>\n

                \n
              • First Name<\/strong><\/li>\n
              • Last Name<\/strong><\/li>\n
              • Email<\/strong><\/li>\n
              • Role<\/strong><\/li>\n<\/ul>\n

                * Role<\/strong> contains pre-defined options (Director\/Superintendent).<\/p>\n

                \"\"<\/p>\n

                2.4.2 Data Template (Administration Sheet\/Principal Information)<\/strong><\/h5>\n

                Using the first entry as an example in the\u00a0Principal<\/strong>\u00a0Information<\/strong> table, enter information for any principals participating in the program. The table asks for the following fields:<\/p>\n

                  \n
                • First Name<\/strong><\/li>\n
                • Last Name<\/strong><\/li>\n
                • Email<\/strong><\/li>\n
                • School<\/strong><\/li>\n<\/ul>\n

                  * School<\/strong> contains pre-defined options.<\/p>\n

                  \"\"<\/p>\n

                  2.4.3 Data Template (Administration Sheet\/Additional Teacher Information)<\/strong><\/h5>\n

                  Using the first entry as an example in the\u00a0Additional Teacher<\/strong>\u00a0Information<\/strong> table, enter information for any additional teachers participating in the program but haven’t been added to classroom yet. The table asks for the following fields:<\/p>\n

                    \n
                  • First Name<\/strong><\/li>\n
                  • Last Name<\/strong><\/li>\n
                  • Email<\/strong><\/li>\n<\/ul>\n

                    \"\"<\/p>\n

                    Once you have finished entering all of your school\/classroom data in your template, save<\/strong> the file and return to the Upload School\/Classroom Data<\/strong> page in the portal.<\/p>\n

                    3. Upload School\/Classroom Data<\/strong><\/h3>\n
                    3.1 Select\/Upload Data<\/strong><\/h5>\n

                    Click the box below File Selected:\u00a0<\/strong>to select and attach your data template. You can also drag ‘n’ drop your file over the box.<\/p>\n

                    \"\"<\/p>\n

                    Once you have selected your template, click Upload File<\/strong>. The app will then check your template for any data errors, if errors are found you will have to resolve them before you can successfully upload your data.<\/p>\n

                    \"\"<\/p>\n

                    If your template produced errors continue to the next step, if no errors were produced skip to section\u00a03.3 Upload Success<\/strong>.<\/p>\n

                    3.2 Upload Error(s)<\/strong><\/h5>\n

                    If your template produced errors you will need to resolve them, save your template and re-upload it. An error contains the following three pieces of information:<\/p>\n

                      \n
                    • Sheet Name –\u00a0<\/strong>The sheet where the error is found.<\/li>\n
                    • Cell –\u00a0<\/strong>The cell in the sheet where the error is found.<\/li>\n
                    • Error Message –\u00a0<\/strong>A description of the error.<\/li>\n<\/ul>\n

                      \"\"<\/p>\n

                      Identify the sheet and cell in which the error is found. Re-open your data template and locate the error. Using the Error Message\u00a0<\/strong>description resolve the error(s) and save the template.<\/p>\n

                      \"\"<\/p>\n

                      Re-upload your data template.<\/p>\n

                      \"\"<\/p>\n

                      Once you have selected your template, click Upload.<\/strong><\/p>\n

                      \"\"<\/p>\n

                      If your template continues to produce errors, re-open the template file, attempt to resolve the errors and upload it again until no errors are produced. If the file no longer produces any errors move onto the next step.<\/p>\n

                      3.3 Upload Success<\/strong><\/h5>\n

                      Once you have successfully uploaded your school\/classroom data, click Submit.\u00a0<\/strong>This action will create all of the user accounts, schools and classrooms defined in your data template.<\/p>\n

                      \"\"<\/p>\n

                      4.<\/strong>Review Data in Portal<\/strong><\/h3>\n

                      Once you have created all of the user accounts, schools and classrooms for your client, it is important to review the data in the portal to ensure all schools and classrooms contain correct data.<\/p>\n

                      4.1 Users<\/strong><\/h5>\n

                      The Users\u00a0<\/strong>page in the portal will contain a list of all the users generated from your template.<\/p>\n

                      \"\"<\/p>\n

                      4.2 Schools<\/strong><\/h5>\n

                      The Schools\u00a0<\/strong>page in the portal will contain a list of all the schools generated from your template. Click View School\u00a0<\/strong>to view the school’s classrooms.<\/p>\n

                      \"\"<\/p>\n

                      Click the down arrow\u00a0<\/strong>to open a classroom and view its contents.<\/p>\n

                      \"\"<\/p>\n

                      Review the classroom to ensure the correct teachers\/students have been added to it.<\/p>\n

                      \"\"<\/p>\n

                      Teachers, Principals, Directors and Superintendents added to the platform will be notified by email of their accounts creation and can begin using the Sprig platform!<\/p>\n","protected":false},"excerpt":{"rendered":"

                      Once you have received your account information from the Sprig team, you will need to sign into your admin account to create user accounts, schools and classrooms. This article is intended for new clients to the platform and is broken up into four steps that will guide you throughout the…<\/p>\n","protected":false},"author":4,"comment_status":"open","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[39],"ht-kb-tag":[],"_links":{"self":[{"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/715"}],"collection":[{"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/users\/4"}],"replies":[{"embeddable":true,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=715"}],"version-history":[{"count":9,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/715\/revisions"}],"predecessor-version":[{"id":814,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=\/wp\/v2\/ht-kb\/715\/revisions\/814"}],"wp:attachment":[{"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=715"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-category&post=715"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/support.staging.spriglearning.com\/index.php?rest_route=%2Fwp%2Fv2%2Fht-kb-tag&post=715"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}