AB
1
A guide to adding advisor dataA guide to adding student data
2
1) Columns with a * are the required fields we need to create an advisor's account and must be filled in.

Note: for Role*, please select Advisor (full access to BridgeU) or Report Writer (only able to write a reference report).

2) Please add all required details for each advisor that you assign to a student in the 'Students' sheet.

3) To complete the student data, click on the sheet called 'Students' at the bottom of this column.		1) Columns with a * are the required fields we need to create a student's account. Any columns without a * can be left blank.

2) All fields can be updated/edited once uploaded to BridgeU, so if a student's assigned advisor is not known, please input the main advisor's email address.

3) The School Student ID column is for the ID you have for your students in your MIS (i.e. iSAMS) or in your LMS (i.e. ManageBac).

4) You can add one or multiple custom labels for each student in the Labels column. To add multiple labels please separate the label names with a semicolon. Custom label examples: tutor group name, subject interest (e.g. Medicine) or application deadlines (e.g. Early Decision).

5) Graduation Year is the year a student will leave your school.

6) Date of Birth is required for submitting application documents via BridgeU but can also be added at a later date. The format should be YYYY-MM-DD.

7) For the correct way to enter the country of birth in the Country column, please select from the drop down menu.

8) Gender column input formats should be either Male, Female or Neither.

9) Parent details should only be included here if you want parents to receive their own accounts for their child's BridgeU account. Please leave blank otherwise. Parents can be given access at a later date if necessary.

3
- If the data is valid, the first column of the row will be green- If the data is valid, the first column of the row will be green
4
- If the data is not valid, the first column of the row will be red and the message will explain why the data isn't valid.
- The cells that are causing the problem will also be red.
- A count of rows that are erroring will be shown at the top of the column		- If the data is not valid, the first column of the row will be red and the message will explain why the data isn't valid.
- The cells that are causing the problem will also be red.
- A count of rows that are erroring will be shown at the top of the column
5
6
7
8
9
10
11
12
13
14
15
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