Project 2

Q.5 Import first 1500 rows of tables (College_A_HS, College_A_SE, College_A_SJ, College_B_HS, College_B_SE, College_B_SJ) into MS Excel.

1.College_a_hs

2.College_a_se

3.college_a_sj

4.college_b_hs

5.College_b_se

6.college_b_sj

Q.13 Import the created views (College_A_HS_V, College_A_SE_V, College_A_SJ_V, College_B_HS_V, College_B_SE_V, College_B_SJ_V) into MS Excel and make pivot chart for location of Alumni.

1.college_a_hs_v

2.college_a_hs_v_chart

3.college_a_se_v

4.college_a_se_v_chart

5.college_a_sj_v

6.college_a_sj_v_chart

7.college_b_hs_v

8.college_b_hs_v_chart

9.college_b_se_v

10.college_b_se_v_chart

11.college_b_sj_v

12.college_b_sj_v_chart