TSD file

                                        
    ID  Last name  First     Section   Score  Standard  Percent
                                              Score     Correct
                                          
341054320ALCOM       JOSE  A6  ? A01F  39      38       78
600000001BECHERT     ELZABETS 100A01F  45      53       90
457999992COOPER      RAY      100A01F  43      48       86
462222290DENA        ALEX   C 100A01F  33      23       66
639111110EARLEY      CLARK  L 100A01F  44      51       88
455555557FERRO       KATHY  S 100A01F  44      51       88
470000006GOLD        CHAD   M  ? A01F  49      64       98
438888889HANCOCK     EARL     100A01F  38      36       76
465555554HARRIS      BILLY  M 100A01F  42      46       84
509999995JOHNSON     PATRICKC 100A01F  46      56       92
449000600KERR        LAURA  P 100A01F  47      59       94
490000010LACEY       TOMMY  L 100A01F  45      53       90
563333303MAYER       JEFF   L 100A01F  44      51       88
464444444NELSON      LOUISE E 100A01F  44      51       88
457777777ODEN        KEVIN  M  ? A01F  35      28       70
462233444PETERSON    LISA   E  ? A01F  43      48       86
451111112QUIMBLY     JOHN   J 100A01F  42      46       84
456666666REYES       TEDDY  L 100A01F  46      56       92
451111115SANDERS     KIMBERLY 100A01F  49      64       98
467777776THOMAS      DAWN   L 100A01F  45      53       90
452222221UNDERWOOD   BOB    L 100A01F  42      46       84
453333337VINSON      LARY     100A01F  44      51       88
464444442WADE        KAREN  N 100A01F  48      61       96
455555554XU          WONSUK R 100A01F  48      61       96
455999999YANCY       JILL     100A01F  48      61       96
450000000ZINN        JASON  R 100A01F  42      46       84



This TSD file can be loaded with Microsoft Excel to select 
wanted data.



 

How to load by Microsoft Excel



Start-Program-Microsoft Excel
File-Open-31/2 Floppy (A:)
Choose Files of Type: All files
Choose FIle's name.TSD (double click)
When it shows Text Import Wizard-Step 1 of 3, click Next> 
When it shows Text Import Wizard-Step 2 of 3, click on number line
    to create column for the data (e.g. click on number line
    between last names and ID numbers)until finished, then click Next
When it shows Text Import Wizard-Step 3 of 3, click on top of the column
(at the word general) and click circle - Do not import column (skip) 
until finished, then click Finish


 

This example shows the tsd file has eliminated both section and standard score.


 ID          Last name   First     Score    Percent
                                            Correct

341054320 	ALCOM       JOSE   A	39	78
600000001	BECHERT     ELZABETS	45	90
457999992	COOPER      RAY		43      86
462222290	DENA        ALEX   C	33	66
639111110	EARLEY      CLARK  L	44	88
455555557	FERRO       KATHY  S	44	88
470000006	GOLD        CHAD   M	49	98
438888889	HANCOCK     EARL	38	76
465555554	HARRIS      BILLY  M	42	84
509999995	JOHNSON     PATRICKC	46	92
449000600	KERR        LAURA  P	47	94
490000010	LACEY       TOMMY  L	45	90
563333303	MAYER       JEFF   L	44	88
464444444	NELSON      LOUISE E	44	88
457777777	ODEN        KEVIN  M	35	70
462233444	PETERSON    LISA   E	43	86
451111112	QUIMBLY     JOHN   J	42	84
456666666	REYES       TEDDY  L	46	92
451111115	SANDERS     KIMBERLY	49	98
467777776	THOMAS      DAWN   L	45	90
452222221	UNDERWOOD   BOB    L	42	84
453333337	VINSON      LARY	44	88
464444442	WADE        KAREN  N	48	96
455555554	XU          WONSUK R	48	96
455999999	YANCY       JILL	48	96
450000000	ZINN        JASON  R	42	84

Back to the top

Back to HOME

Back to MARSHOME