Software 4 Schools - Engagement and Security

Welcome to our Knowledge Base

Uploading Multiple Voting Groups

  • The first step in creating multiple voting groups is to get a file that has all the data points that you want to use to separate out your voters. In this example, we are going to combine Gender and Grade so we can have 11th grade females in one group and 11th grade males in another.

In this article, you will learn how to upload multiple voting groups.
  • Create a new column (for example “combined”) and then put your curser in the first row of data and click the Function (fx) Icon.
  • Search for Concatenate and click enter.

  • For Text1 click the first cell (in my example D2 under grade) and for Text2 click the next cell (in my example E2 under gender) and click done.
  • You should now see the combined data in one cell in the new column. Next click the small square box in the bottom right corner and drag down the entire file so it copies the formula.
  • Highlight the entire column (F in my example), right click and select Copy.

  • Very important – We are now taking the formula and turning into raw data that can be imported. Fine a new blank column, click the header and select Paste Special and select Values and that will duplicate the data in a new column. The difference is that when you click on the data it will show in the formula cell and if you click on the original column (F) it shows the formula.

  • You can now delete the original columns (in my example Grade, Gender and Combined) and this will now leave me with just the new column that has the raw data. Be sure to keep the new combined data (in my example column I )

  • The best way to upload your file is to use a CSV file. So go Save As and choose the option CSV.

  • Next you go log into your voting account System Settings / Users / Students and Upload your file. Be sure to line up the columns by selecting the correct column in the drop down to match the fields. Learn more about uploading students