CTE Assessment

CTE Teachers Support for ExamView,Moodle, Elements,
Study Guides, and Test Banks

Using Access to Report VoCATS

We can take a complete VoCATS export from Clarity of all our test scores.  We can then merge them with a DOS command, copy *.* all.dat.  After which we can import the file into Access with the name off All as a table. See the table in the draft database below:

VoCATS DATABASE SAMPLE Download

VoCATS DATABASE SAMPLE Download  This is the same database but renamed as a .doc to by pass Outlook filers.  You will have to rename the file with the extension .mdb after downloading.

All the data has been modified and changed.  The Database reports by school, by program area, by completer course, by teacher and compares the scores to last year's NC Average 2004-05.

 

The other table in the data is named tblCountyNCHistoricScores.  A sample is below, where we will keep the course name, program area and completerCourse and county wide average scores.  The VoCATS information can link to this table and it can be used in calculations. If you take the sample you can use the table and just enter your County Averages.

 

tblCountyNCHistoricScores
CourseNumber Course Name CompleterCourse ProgramArea NC0405 County04-5 County0506 StudentsTested CountyProf0506 CountyProf0405 County99-00 County00-01 County01-02 County02-03 County03-04 2005NCNCSD 2005NCNSD
6412 Computer App. II Completer Business & Information Technology 74.48 76 64.52 27 59.3% 85.0% 78 63 73 73 70 11.58 9
7962 Arch. Draft II Completer Trade & Industrial
77 77.30 39 84.6% 88.5% 70 59 65 67 67

6312 Accounting II Completer Business & Information Technology 62.23 68 39.33 3 0.0%





15.1 7.8
7902 Sci. Vis. II Completer Trade & Industrial









56

7812 Cosmetology II Completer Trade & Industrial
69



64 55 60 72 70

6416 eCommerce II Completer Business & Information Technology 68.52 57




62 74 74 59 13.59 8.5
7722 Construction II Completer Trade & Industrial
62


32.9% 39 52 59 53 57

7046 Foods II Advanced Completer Family & Consumere Sciences
65 63.06 35 40.0%







6622 Marketing Mngt. Completer Marketing 61.44 62 68.00 1 100.0% 41.5% 57 61 61
63 12.67 6.5
6832 Ag. Engineering II Completer Agriculture 65.06 66


61.5%


70 73 12.04 6.8
7712 Masonry II Completer Trade & Industrial
66


61.9% 50 56 50 48 71

7122 Culinary Arts II Completer Family & Consumere Sciences 66.86 70 60.20 6 33.3% 75.8% 61 59 67 69 68 12.38 7.4
6225 Business Mngt. Completer Business & Information Technology 64.88 56 55.64 14 21.4%
60 59 55 62 62 11.11 6.3
7512 NATEF-Brakes Completer Trade & Industrial 69.14 71 62.60 47 48.9% 79.7%

46 59 66 13.61 8.5
7212 Health Science II Completer Health Occupations 72.46 72 71.40 35 80.0% 85.5% 70 68 70 70 66 10.05 7
7112 E Childhood Ed II Completer Family & Consumere Sciences 73.25 70 74.30 4 100.0% 66.7% 75

79 72 11.31 8.4
6826 Equine Science II Completer Agriculture
86










7999 Trade and Industry Advanced Studies Completer Trade & Industrial












6699 Marketing Advanced Studies Completer Marketing












6599 Business Advanced Studies Completer Business & Information Technology












7196 F&C Appr Methods Completer Family & Consumere Sciences












7199 F&C Advanced Studies Completer Family & Consumere Sciences












6899 Agriculture Advanced Studies Completer Agriculture












6842 Horticulture II Completer Agriculture 61.92 70 72.73 40 85.0% 67.6% 49 45 61 70 69 14.61 7.5
6852 Env. Nat. Res. II Completer Agriculture 67.3 67


59.1%


64
16.11 9.8
8012 Prin. of Tech II Completer Technology 56.92 55 39.50 2 0.0% 22.2% 50 53 57 62 54 16.26 7.5
6882 Landscape Gardening Completer Agriculture 62.75 65


58.3%


54 69 14.26 7.5
7992 Comp Eng. Tech II Completer Trade & Industrial
56



59 60 55 57 53

6825 Equine Science I Area Study Agriculture 82.99 94 92.00 11 100.0% 100.0%



85 12.47 14
6645 Travel/Tourism Area Study Marketing 69.04 68




70
65 67 13.3 8.2
6621 Marketing Area Study Marketing 64.4 65 67.71 69 63.8% 52.3% 72 55 62 62 66 13.45 7.5
6514 Digital Comm. Sys. Area Study Business & Information Technology
64 65.34 154 51.9%







6535 Business Comm. Area Study Business & Information Technology 64.27 55


28.6%



69 15.23 8.2
6411 Computer App. I Area Study Business & Information Technology 70.43 70


73.6% 78 73 76 76 65 13.42 9
6810 Agriscience Area Study Agriculture 74.1 78 71.77 13 69.2% 83.0% 52 54 63 73 76 15.18 11.5
6831 Ag. Engineering I Area Study Agriculture 67.07 77





76 76 79 13.77 8
7123 Culinary Arts III Area Study Family & Consumere Sciences












7018 Exploring Life Skills Area Study MS F&C












6898 Agr Intership Area Study Agriculture












7298 Health Careers Internship Area Study Health Occupations












7399 CC Hlth/Human Services Area Study Health Occupations












6430 IB Information Technologh Area Study Business & Information Technology












6158 Exploring Career Decisions Area Study MS Career












6200 Principles of Bus Area Study Business & Information Technology 64.84 64 61.32 71 47.2% 44.4% 67 72 68 70 59 13.65 7.5
6598 Business Internship Area Study Business & Information Technology












6311 Accounting I Area Study Business & Information Technology 63.99 67 41.76 25 0.0%
75 69 70 70 67 15.32 8.2
8108 Exploring Technolgy Area Study MS Technology












7980 Networking I Area Study Trade & Industrial












7813 Cosmetology III Area Study Trade & Industrial












8005 Technology Studies Area Study Technology












7998 Trade & Industries Internship Area Study Trade & Industrial












6145 Career Decisions Area Study Career Development 65.55 65 66.78 58 62.7% 57.6% 62 62 65 60 72 16.05 9
6215 Business Law Area Study Business & Information Technology 69.51 55 65.28 25 56.0% 29.9% 48 27 59 55 59 15.87 10
6999 Principals of Marketing Area Study Marketing












7991 Comp Eng. Tech I Area Study Trade & Industrial
69 70.10 13 57.1%
65 67 61 60 65

7723 Construction III Area Study Trade & Industrial
65



40
57 51 63

7811 Cosmetology I Area Study Trade & Industrial
68



61 62 63 72 70

7901 Sci. Vis. I Area Study Trade & Industrial
45





51 58 59

7921 Intro to Drafting Area Study Trade & Industrial
69 62.90 81 51.9% 64.0% 65 60 62 65 61

7963 Arch. Draft III Area Study Trade & Industrial
53 62.50 13 38.5% 12.5%
55 71 55 59

7055 Interior Design Area Study Family & Consumere Sciences 61.97 65


56.1%


59
14.43 7.5
7981 Networking II Area Study Trade & Industrial
82










7711 Masonry I Area Study Trade & Industrial
65 60.60 42 33.0% 48.7% 54 47 52 55 65

8011 Prin. of Tech I Area Study Technology 61.49 67 71.20 61 75.4% 53.3% 57 68 71 69 63 16.74 8.5
8110 Fund. of Technology Area Study Technology 62.71 68 62.30 71 45.1% 66.8% 63 64 64 67 68 15.23 8
6400 MS-Business Computer Technology Area Study MS Business & Information Technology

52.40
20.0%







6511 MS-Keyboarding Area Study MS Business & Information Technology

48.90 334 10.5%







6415 eCommerce Area Study Business & Information Technology

48.90 6 16.7%







7999 Advanced Studies Area Study Business & Information Technology












7981 Networking I Area Study Trade & Industrial
80










7111 E Childhood Ed I Area Study Family & Consumere Sciences 77.59 76 82.10 30 96.7% 92.9% 77 74 72 70 78 10.49 9
6843 Turf Grass Area Study Agriculture 64.61 69


66.7%



63 12.36 6.8
6851 Env. Nat. Res. I Area Study Agriculture 63.34 72 66.10 21 47.6%
50 55
53 63 15.83 8.5
7015 Teen Living Area Study Family & Consumere Sciences 71.79 77 74.93 134 80.0%
73 70 69 67 71 12.33 8.5
7045 Foods I Fund. Area Study Family & Consumere Sciences 58.74 62 64.86 148 51.7% 43.9% 65 58 51 58 61 13.73 6.5
8999 Advanced Studies Area Study Business & Information Technology












7065 Parenting Area Study Family & Consumere Sciences 78.39 77 80.74 85 92.9% 88.6% 69 72 72 79 80 11.2 10
7721 Construction I Area Study Trade & Industrial
74 70.10 75 72.0% 88.2% 64 62 61 63 67

7085 Life Management Area Study Family & Consumere Sciences 74.5 75


82.4% 75 68 81 76 67 13.1 10
7713 Masonry III Area Study Trade & Industrial
57










7121 Culinary Arts I Area Study Family & Consumere Sciences 68.36 64 74.10 10 100.0% 50.0% 67 60 70 64 73 13.19 8
7210 Health Team Relat. Area Study Health Occupations 71.71 82 77.40 60 88.3% 93.3% 80 75 77 79 82 13.25 9
7211 Health Science I Area Study Health Occupations 64.86 67 61.20 31 38.7% 65.1% 74 63 61 57 65 14.23 8
7511 Intro to Auto Tech Area Study Trade & Industrial
68 62.40 127 47.2%
70 60 61 65 66

7513 NATEF-Electrical Area Study Trade & Industrial 65.64 80 58.80 13 46.2% 86.1%

66 59 57 13.61 7.8
6841 Horticulture I Area Study Agriculture 64.82 76 69.22 97 61.6% 76.1% 49 44 56 62 61 17.33 9.5