Celscan Information

Celscan is used to scan and score paper/pencil versions of the ESL CELSA tests

CELSCAN Information:

Most of the procedural help information is included
within the CELSCAN software. This document
is to help you get the software started and
begin preparing your CELSCAN software for your
specific school.

CELSCAN was designed to run on a Windows Operating
System (re: Win95-XP).

The files are located on our webpage


Select CAPP FTP Site
Select Celscan

Celscan Functions:


The Export function is used for exporting student records
to a file used for external reporting. The program will
create a delimited ASCII file with the student records that
you have selected (from the Master or Temporary database).
You can use this file to send to other institutions, create
personalized letters for the student or create reports in
other applications such as Microsoft Word or Excel.

From the Main Menu select the File menu and then select
Export from the drop down list.

After you select Export, you will receive an ATB Roster of students
listed in the Master Database (Multiple). You can sort these names
by Social Security number, Name, Test Date or Institution Code.
The Preview button (near the bottom) will show the specific records
you have selected for exporting. If you need additional search
criteria you can choose the Selection Tab. You will receive an
additional screen that lets you set a filter on what data you are
searching for (this filter can be saved for future searches).
See the Reports section for a more thorough explanation of Filters.
Additional Search options include:

Social Security, Last Name, First Name, Birthdate, Test Taken,
Test Date, Institution Code, Language Group, Ethnicity, Sex,
Test Form, Level, Exact or Partial matches where you can set
to case sensitive searches or sort the list in Alphabetical
or Logical order.


The Scan Menu is used when you are ready to scan the
Celsa forms. Note: It is a good practice to check the
scan forms before scanning into the computer. Check
Social Security numbers and that all the bubbles have
been filled in appropriately. You can edit these after
they have been scanned as well. Also, make sure the
timing tracks are in the correct position and that there
aren't any smudges or smears that would make the form
hard to read by the scanner.

Select Scan and then select Scan Forms.

You will get the Scanning Parameters Menu. This menu
allows you to enter the Test Date for the batch and the
Test Form used (re: Celsa Form 1 or Form 2). You may
also select the type of scoring, either Placement or
Ability to Benefit. Select OK when ready.
You will get the Scan CELSA Forms Menu
To start scanning, select the START SCANNING button.
Make sure the scan forms are in the tray and the
scanner is ready. You can configure the scanner by
selecting Configure and then Configure Scanner from the
drop down menu. In the configuration menu you can set
your scanner type, COM Port, Baud rate, Data Bits,
Parity and Stop Bits and Tray Stacker type.
Typically these fields should be kept at their defaults.
You may also run the diagnostics program to check your
scanner. Make sure there is a scan form with data in the
input tray. Select Configure and the select Diagnose
Scanner. The program will read the scan form and then
display the output in a graphical display that represents
how the program is interpreting the form read.


The Edit menu allows you to edit the student records that
you have scanned. Select Edit, and then choose from which
database you are working with (re: Temporary or Master).

Each listing will display the students in the current
database. You can sort these records by Name, Social
Security, or partial/full string matches in the Search box.
For each record there is a list of what tests were taken and
the actual responses given when they took the test. All
these fields can be edited here by double-clicking on the
field you want to change or selecting the Edit menu and
then selecting the field you want to edit. Student records
can also be deleted from this menu.


The Post function allows you to post the data from the
Temporary database to the Master database.
Note: You should make sure the data is correct before
posting it to the Master database. Though, you are able
to modify the student records after they have been sent
to the Master database. Select Post from the Main menu
and then select Post Temporary to Master. You will get
a verification message. Select Yes to confirm transferring
the files to the Master database.


There are two types of reports that can be produced from
either the Temporary or Master database.

1.) Roster displays a list of all the students in the database.
This is a summary of which tests and when the student took them.
2.) Letter is used to create a personalized letter for the student
explaining the test they took and their score(s).

You can choose either to print or preview the report. You can
also sort the student records by various fields (SSN, Name,
Test Date or Institution Code) or enter your own search
criteria in the blank box marked Search. You can also switch
databases or span over multiple databases for your report.

You can also create filters for specific searches and save them
for future reports.

To Set a Filter, select the SET Filter icon
Enter your search criteria and then select OK.

To Save a filter, Select the SAVE Filter icon
Confirm your settings and name the filter for later use.

To Clear a filter, select the Clear filter icon.
Confirm that you want to clear the current settings.

To Load a filter, select the Load filter icon.
Then select the filter that was saved earlier with
your specific search criteria.

To Delete a filter, select the Delete filter icon.
Select and confirm the deletion of the specific filter you
want to delete.

Select the specific filter for desired operation.
Each icon will display in text what their function is by holding
the mouse cursor over the specific icon.


The Login Menu allows you to login to the Celscan software
so you may add/modify or delete users you want to access
or restrict from the CELSCAN program. You can also set what
level of access each user has.

The Setting Menu allows you to view or change your school
information. The existing fields are Name of School, Email
Contacts (re: Test Administrator) and Scanner type
(re: Opscan or Scantron).

Count records is used to show how many records have already
been scanned into the program. The menu will list records in
both the Temporary and Master databases. It will break down
each by Name, Address, Assessment and Score records.

Reindex is used as a maintenance function for the databases.
The Celscan program checks for duplicate records and resets
flags in the program as needed. This function can be used as
a recovery routine if one of the indices are corrupted or has
invalid data.

Purge will allow you to delete all the records out of a selected
test period. You can purge the entire database or purge for
specific dates or records.

The icons listed below are on the Main Menu.
These icons are for quick access to various functions within
the CELSCAN software.

(from left to right on the CELSCAN Main Menu)

Export Data from Master
Backup Databases
Scan and Add Data to Temporary Database
Print Edit List
Edit Temporary
Browse/Edit Temporary
Post Temporary to Master
Print CELSA ATB Letter from Temporary
Print CELSA ATB Letter from Master
Print CELSA ATB Roster from Master

Additional Icons:

Select All
Unselect All


Help is available within the Celscan program.
Select 'HELP' from the Main menu and then 'HELP' again to start the
Celscan Help program.

   CAPP Technical SupportCAPP Associates, Inc.
   Phone_(805) 965-5870
   FAX _ (805) 965-5807

    Back to the CAPP Homepage