ABCDEFGHIJKLMNOPQRSTUVWXYZ
1
Notes
2
Run a Bi Report http://biportal.uw.edu/
Pulling Imported Students Canned Report
3
Report
Home, reports, Academics, All Applicants
Go to Reports
4
Year:Fall 2024
go to Canned Reports
5
Campus Seattle
Select Imported-Unregistered
6
College Select All Select Seattle
7
DepartmentSelect All
8
Requested Dept.Select All
Can choose specific departments.
9
Major Cohort Type
Requested Major
Can choose specific majors
10
Ethnicity Select All
11
Application Type
2YR Tranfer, 4YR Transfer, Freshman
12
Application Status
15,16
see description of status
13
Class Undergraduate
14
New, continuing, Returning Status
select ALL
15
Columns to Display
Select All
16
Output Report
17
18
Run Report
19
1. Download as a CSV File
20
2. Open, save as excel in folder _ G:\Shared drives\UAA FYP\Operations\Data and Queries\enrollment Tracking
21
2. Apply filter
22
3. Go to Assigned_Major_1- column AW
23
4. Select the following majors as a filter and then delete those row
4.1 Add in Preferred Name
24
ECE
Sort by Preferred First Name
25
ECFS O
Copy over First name into Preferred_First Name for blank items
26
HIHME
27
ISS O
28
MEDXD
4.2 International Students
29
MEDXC
International Students are in the "Intl" header as yes or no
30
NURS
31
XAUP
32
XA&S
33
XBSAD
34
XDENT
35
XENGR
36
XENV
37
XLAW
38
XLIS
39
XMED
40
XNURS
41
XPBAF
42
XPHAR
43
XPHCM
44
XSOCW
45
46
5. Run a pivot table and application by type_class (put in the values as count)- put the numbers in columns AA and AY
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