Top

Excel File Support Print or save as PDF

Filling out the Confident Learners Foundations excel file can be confusing, so we have prepared this article containing all the information you will need to know in order to fill out the excel spreadsheet for your upcoming session.

This article outlines how to properly fill out the excel file for your upcoming implementation. Filling out this file properly is very important to ensure a successful implementation.

Please note that all columns highlighted in blue are optional while columns in red are mandatory

The excel file is divided into two spreadsheets. Let’s discuss the first sheet, which is the Student Data

Let's start with the Student Data Information.

Students Information
The student data contains three sections that you need to fill out. We have the Students' Information, the Teachers' details, and lastly, the School's Information.  

Students' Information

The first two columns are the Unique and Alternate IDs. These fields are both optional. If your district or school is keeping track of the students' ID information, these rows could be populated.

Unique ID (Optional): is a permanent unique identifier for each child that does not change from year to year (e.g. Student Number that will stay with the child for their entire academic career). This is usually the Student Record Number (SRN) of the student.

Alternate ID (Optional): this is the school ID and is issued at the school level. 

Student’s Name - Please do not use any special characters when entering the children’s name. 

  • Last Name (Required): Student’s surname
  • First Name (Required): Student's given name.
  • Middle Name (Optional): Student's middle name(s).

Gender (Required): this refers to the student's gender (e.g., M, F or Male, Female). 

Date of Birth (Required): Please ensure that the day and month are placed in the appropriate column, the format is (dd/mm/yyyy).

The next section is the Teachers' Information. When the file is uploaded to the system, teachers are automatically added to their designated classrooms.

 

Teachers' Information
This section is for data regarding the teacher(s) and class(es). 

  • Last Name (Required): Teacher's Surname. 
  • First Name (Required): Teacher's given name. 
  • Email (Required): This is simply the Teacher's work email address. 

Please ensure that the spelling within the provided email address is correct, otherwise, users will not receive their login information once the session is opened.


Classroom Name (Required): The name of the classroom (e.g., K3, AM/PM). Please ensure that the classroom names are unique within each school in the system.

 

School's Information
This section is for data regarding the school and jurisdiction(s). 
  • School Name (Required): We highly recommend adding the school’s full name and not the abbreviation. This ensures all naming conventions are consistent on a year-over-year basis, as well as making it easier to support teachers/evaluators. 
  • System Name (Required): The name of the district/division/network/etc. that the school(s) belong to.

Please note that the school name entered here needs to match the name we already have in the application, if applicable. We highly recommend addressing the school by its full name and not an abbreviation.

 

 

Next, is the Additional Personnel Information: This is where you will enter the information details for the users that would require access to the application aside from the teacher's being listed from the student data. 

Personnel Information
First Name, Last Name, and Email Address (Required): Please fill out the additional tab at the bottom of the file, this will need to be filled out with any Additional Personnel that will require access to school reports, as well as allow them to enter assessment data where applicable. Please add the names and email addresses of the additional users (Principals, Assistant Principals, Learning Specialists, Data Coordinators, and Consultants) that would require them to have access to and monitor the progress of their school. 

Please note that we require this to be filled out for every new session.


Level of Access Information

  • School Names (Required): Please indicate the name of the school that this user would require to have access to.

    Please note that the school's name must not be abbreviated. 

     

    • Role (Optional): Please indicate the person's job title or role in this section.
    • Enter Scores (Required):  Please indicate here whether they will be assisting in entering student scores or not. The answers are (Yes/No).

    Please note that you do not need to include the names of the classroom teacher(s) as their access has already been indicated in the Student Data File. Only add additional teachers here if they require access to the school's report. 

Submitting your finished Data File
Please review all the collated data prior to submitting it to The Learning Bar. If you are ready to submit, please use the secured link that was provided to you in the email to transmit the data. The upload is easy and the delivery team will be notified right away. The link is usually embedded in the mail sent to you or otherwise, you may contact your Client Success Manager or the support team.

 

Excel File Do's and Don'ts: Common mistakes

dos_and_donts_updasted.png

 

 

Please sign in to leave a comment.