WV Contest Registration 2018
 Share
The version of the browser you are using is no longer supported. Please upgrade to a supported browser.Dismiss

 
View only
 
 
ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
DIRECTIONS FOR CONTEST REGISTRATION
2
1)
Read these directions carefully and study the Sample Registration Form (see sheet tabs below).
3
4
5
2)On the Blank Registration sheet below, copy and paste your membership list (Last Name in cell D3 and First Name in cell E3). Then copy and paste the membership list a second time in the row immediately under the first copied list. The select all the names in column D and E and sort by Last Name then First Name.
6
7
3)Enter the two letter abbreviation for your school in cells F3: NC, NN, MV, NV, WV. Use the fill handle to enter your school abbreviation all the way down Column F.
8
9
4)Enter the competitive event #s for the first member in cells G3 and G4 . The lookup table will automatically include the event name in cells H3 and H4. Repeat for all members. This will eliminate some possible entry mistakes and unify the contest name for all of us. Please verify that the event # you type results in the competitive event name that the student has chosen. You may want to print the Lookup Table on the Registration worksheet for an in hand reference.
10
11
5)For the team events, use your school initials followed by a team number. For example, a “WV1” in column I (team #) for all Team 1 members from Waubonsie Valley, or a “WV2” in column I for all Team 2 members from Waubonsie Valley, etc. Even if you have only one team in that event, use the number “WV1” to clarify your intentions. Any clerical errors on either end of the process will be found more quickly this way.
12
13
6)Use the Save As feature to save the file with your school name included.
14
15
7)E-mail the renamed Excel file as an attachment to “jeff_graham@ipsd.org”.
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
33
34
35
36
37
38
39
40
41
42
43
44
45
46
47
48
49
50
51
52
53
54
55
56
57
58
59
60
61
62
63
64
65
66
67
68
69
70
71
72
73
74
75
76
77
78
79
80
81
82
83
84
85
86
87
88
89
90
91
92
93
94
95
96
97
98
99
100
Loading...
Main menu