This software will help you score and record marks for multiple-choice tests.  The scanner is available in the 4B Mailroom or 1B Mailroom, while you can download and install the software on your own PC.

Order the Bubble Sheets

To order bubble sheets for test scoring, fill out an IT Services Equipment Order Form.  Alternatively, these may also be obtained from your department's administrative support personnel. Use the Conestoga Staff directory to search for their contact information.

Get Started

Consult the DataLink Connect User Guide for any questions.

  1. To begin, open the DataLink Connect software on the desktop of the computer.  If you do not see it on the desktop, search for it in the Start Menu
  2. When the software opens, exit any tutorial windows
  3. Leave the software running while you create your key and scan the test responses.

datalink connect icon    

Download a Class List

This step should be completed at your desk.

To begin this, you can use a Class List, with student names and ID numbers.  This can be downloaded from the Employee Portal

First, log into the Employee Portal. Choose the Faculty tab, and choose the Class list button. 

employee portal faculty tab, class list button 

In the drop-down menu, choose the appropriate semester for your course.  From the list below, choose the course you would like to administer the test in.  Courses can only be selected one at a time. 

choose semester and course 

Scroll to the bottom, and under Output Types, choose Excel Report.  Choose the Class List as CSV to download the list. 

class list as csv option 

Choose to Open the class list.  It will pop open in Excel.  Go into the File menu and choose Save as.  Save the file to your OneDrive, or G: Drive.  Rename the file to a more appropriate format, such as "Coursecode# Class List".

Build a Student Database

In order to get set up for your semester using multiple-choice tests, you will first need to set up a Student Database. 

Next, open DataLink connect from your computer's Start Menu. (If it is already open, then skip this step.)  If it does not appear, download and install the DataLink software from the F: Drive.  Open the File menu and choose Student Database

file menu, student database option 

In the window that opens, choose Import Students. 

Import students 

This will open another window, leading you through two steps.  In Step One, click Choose FileSelect the CSV file you just downloaded from the Employee Portal. It may be titled "Coursecode# Class List", or you may have left it the default file name, in the format "Semester Year - Coursecode#-Sec#.csv". 

import students step 1 

In Step Two, verify that the correct drop-down options are as follows: First Name should be Column 3, Last Name should be Column 2, and ID number should be Column 1.  Select Import to complete the process.  

import students step 2 

You will now see the Student Database window populated with the names and ID numbers of the students in your course. 

 

Repeat this process for each course you will be administering the tests in.  Once completed, click OK.

After the Test

Create your Answer Key

You will need one extra blank bubble sheet, in order to create your answer key. 

To create your answer key, fill in a blank bubble sheet with the correct answers.  Do not enter a Student ID number.  Instead, fill in the bubble next to Key, at the top of the bubble sheet.

 blank scantron sheet with correct answers

Place the key face up in the scanner and press the green Scan/Pause button.  It will quickly scan. 

key face up in scanner 

Printed next to each question, there will be the correct answer, written in red ink.  Verify these are correct. Printed at the bottom right of the bubble sheet, you will now see the word Key and a number, indicating the total number of questions on your test, in red ink. 

key answers printed next to each question 

The Key results will appear in the DataLink Connect software. 

 key in Datalink connect software

Once your Key is complete, you are ready to start scanning the students' test responses.

Scan the Tests

  1. Place the stack of test response sheets on the DataLink scanner, face up. The students' names and ID numbers should be closest to the green Scan/Pause button.  Make sure the sheets are pushed up against the rollers for the scanner. 
  2. Press the green Scan/Pause button. The tests will be scanned and will come out the other side. 
  3. The bubble sheets will now be marked. Incorrect answers will have a red vertical line to the right of the question.  Correct responses will appear unmarked. At the bottom right of the bubble sheet, the total number of correct responses and the student's score in percentage format will be marked in red ink.

scan the test results 

From here you can choose to either manually input your grades into eConestoga, or export grades and results as Excel reports.

Match Test Results Students' Names

In the DataLink Connect software, the results will now appear following the Key.  The student's ID number and total score will appear as the second and third fields, followed by the individual correct or incorrect responses. Incorrect responses will be highlighted in yellow.  The first field, Student Name will be blank.  You will want to match the right test results to the right students. 

datalink software test results 

To match your Student Database against this test, go to the Session menu, and choose Merge Names with Student Database.  The names will now appear next to the student's ID number. 

match test results to students' names 

Save the Results

To save the results of this test, click File, then Save as... Choose to save the file in your OneDrive or G: DriveMake sure to rename the file into a better format, such as CourseCode # Test #. 

save the results 

When done scanning, press the Reset Options button on the scanner to reset it for the next person.

Generate Excel Reports with the Results

To do this, make sure you have followed the instructions in Save the Test Results. Use DataLink Connect software to create Excel reports tracking your students' performance on specific questions, and determine your class's averages and medians. 

There are several reports you can generate, using the Excel Export button.  This section gives a brief overview of each.  Click the drop-down arrow next to Excel Report to see all the reports you can generate.

excel export menu 

Results Grid

This report resembles the results shown in the DataLink software.  It shows a complete list of the students' names, ID numbers, and responses.  Incorrect responses are highlighted in yellow.

results grid 

Compact Item Analysis

This report shows the performance of students on individual questions.  The red, italicized text indicates the correct response, followed by the percentage of students who chose this.  It can help illustrate concepts that students are not yet acquiring, and point out topics that may need to be revisited in class.  It may also indicate which questions were confusing or complexly worded.

compact item analysis 

Class Roster

A class roster report shows a snapshot of this particular test, and the class's average and median performance.  It shows a list of student names, ID numbers, Score (on this test), Percentage, and Letter Grade. This is the best format to save in order to submit grades to eConestoga.

class roster 

Detailed Item Analysis

This type of report shows the students' performance on each individual question, in a more expanded view.  It can help illustrate concepts that students are not yet acquiring, and point out topics that may need to be revisited in class.  It may also indicate which questions were confusing or complexly worded.

detailed item analysis 

Survey Mean Statistic

This type of report shows the students' performance on each individual question, organized by question.  It can help illustrate the frequency of errors, and may also indicate which questions were confusing or complexly worded.

survey mean statistic 

Test Results

This short report gives you a snapshot of the questions that students performed well or poorly on.  Questions with poor performance will be highlighted yellow and contain an asterisk (*), while questions with average or better performance will be marked with a plus sign (+).

test results 

Full Report

With one click, generate all of the above reports into one Excel file with multiple sheets.

full report 

Submit the Results to eConestoga

When done scanning, press Reset Options on the scanner to reset it for the next person.  Log off the DataLink scanner computer, so that others can scan their tests, and return to your own computer.

To submit the results to eConestoga, use the results printed on the bubble sheets to add grades to your eConestoga course.  You can also copy and paste results from Excel files into eConestoga.  To do so, follow the steps in Generate Results as Excel Reports, and use the Class Roster report type.

Use this online tutorial to learn how to input grades into eConestoga.

GradeBook (Employee Portal Version)

To create the GradeBook Template

  1. Click File -> Flat file export Manager -> this will open the following dialog box -> Click Create New
  2. Enter GradeBook as the name for your template
  3. Uncheck both Include header row and Include keys
  4. Click the second tab called Fields and Counts
  5. Click ID Number and Score
  6. This will create the template which only has to be created once.

*Create the GradeBook template (one time only) 

Create a CSV file

Since the template has been created, you can create a CSV file by

  1. Clicking File -> Flat File Export Manager -> GradeBook
  2. Save the file to your OneDrive or G: Drive.

Login onto the Faculty/Employee Portal

  1. Click on GradeBook  
  2. Click on Scantron/Update
  3. Choose the file you had saved previously
  4. Choose Assignment
  5. Unclick First Row is Header
  6. Click on Preview (get grades)
  7. After previewing the data click Save & Close

Download DataLink on your Desktop PC

Open your computer's File Explorer.

file explorer 

Choose the My Computer or This PC option. Double click the Apps (F:) Drive to open it up. 

F drive 

  1. Locate the folder called ITS and double click it to open it. 
  2. Find the folder called Datalink and double click to open it. 
  3. Choose the file called Setup.exe and double click to open it.
  4. A window will appear with the text "Do you want this app from an unknown publisher to make changes to your PC?" Choose Yes. 
  5. The DataLink Connect Setup Wizard will begin.  Click Next to continue.
  6. Choose to Install just for me, and click Next
  7. Accept the default destination folder by clicking Next.
  8. Accept the Start Menu default location by clicking Next.
  9. Once this is completed, click Next.
  10. Complete the setup by clicking Finish.
  11. DataLink Connect will automatically open. 
  12. Proceed to Get Started with DataLink Connect, or to Submit Results to eConestoga.

Need Help?

Contact the IT Service Desk, or call 519.748.5220 ext. 3444.