{"text_format":"1","workbook":"xlsx","n_sheets":5,"sheets":["MA","AMP","Grad point","Sheet3","Sheet1"],"not_rendered":{"charts":0,"images":0,"macros":1,"external_links":0,"defined_names":2,"comments":0,"pivot_tables":0},"unopened":[],"bounds":{"document_bytes":16777216,"sheet_cells":100000,"rows_first":2000,"rows_last":500,"rows_between":2000,"halvings":0,"cell_chars":16384,"cell_head_chars":4096},"cells_cut":0,"cells_raw":0,"read":"whole","date_system":"1900"}

{"sheet":"MA","index":0,"n_rows":44,"n_cols":27,"rows_kept":44,"cut":false,"hidden":false,"merged":[[26,2,26,9],[2,3,2,6],[2,9,2,10]]}
[null,"Rev 10/10/2015"]
[]
[null,null,"Student:",null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MA Biological Sciences",null,null,null,"Units",30]
[]
[null,"CR/NC","Units Taken",null,"Graded Units Grad","Units","Letter Grade","Units graded","Grade Pt","GPU",null,"UG Graded","Units","Letter Grade","Units Graded","Grade Pt","GPU"]
[null,"BIOL 201",null,null,"BIOL 202*",null,null,{"$f":"IF(G9<>\"\",F9,\"\")","v":""},{"$f":"IF(G9<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G9,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G9<>\"\",(I9*F9),\"\")","v":""},null,"BIOL 107",null,null,{"$f":"IF(N9<>\"\",M9,\"\")","v":""},{"$f":"IF(N9<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N9,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N9<>\"\",(P9*M9),\"\")","v":""}]
[null,"BIOL 201",null,null,"CHOOSE",null,null,{"$f":"IF(G10<>\"\",F10,\"\")","v":""},{"$f":"IF(G10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G10<>\"\",(I10*F10),\"\")","v":""},null,null,null,null,{"$f":"IF(N10<>\"\",M10,\"\")","v":""},{"$f":"IF(N10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N10<>\"\",(P10*M10),\"\")","v":""}]
[null,"BIOL 284",null,null,null,null,null,"",{"$f":"IF(G11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G11<>\"\",(I11*F11),\"\")","v":""},null,null,null,null,"",{"$f":"IF(N11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N11<>\"\",(P11*M11),\"\")","v":""}]
[null,"BIOL 284",null,null,null,null,null,"",{"$f":"IF(G12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 284",null,null,null,null,null,"",{"$f":"IF(G13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(N13<>\"\",M13,\"\")","v":""},{"$f":"IF(N13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N13<>\"\",(P13*M13),\"\")","v":""}]
[null,"BIOL 284",null,null,null,null,null,null,{"$f":"IF(G14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N14<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N14,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 280",null,null,null,null,null,null,{"$f":"IF(G15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N15<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N15,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 280",null,null,null,null,null,null,{"$f":"IF(G16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N16<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N16,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 280",null,null,null,null,null,"",{"$f":"IF(G17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N17<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N17,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!G21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(MA!N21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,{"$f":"SUM(C9:C21)","v":0},null,null,{"$f":"SUM(F9:F21)","v":0},{"$f":"COUNTA(G9:G21)","v":0},{"$f":"SUM(H9:H21)","v":0},{"$f":"SUM(I9:I21)","v":0},{"$f":"SUM(J9:J21)","v":0},null,null,{"$f":"SUM(M9:M21)","v":0},null,{"$f":"SUM(O9:O21)","v":0},{"$f":"SUM(P9:P21)","v":0},{"$f":"SUM(Q9:Q21)","v":0}]
[]
[null,null,null,"Culminating Experience"]
[]
[]
[null,null,"CRITERIA      "]
[null,null,null,null,"Units for"]
[null,null,null,null,"BIOL 201",{"$f":"IF(($C9+$C10)>0, \"OK\",\"Need\")","v":"Need"},"Must be>=0.5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 units"]
[null,null,null,null,"BIOL 202",{"$f":"IF(F9=3,IF(H9<>\"\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be =3",null,"* Must be completed BEFORE turning in Candidacy form"]
[null,null,null,null,"BIOL 284",{"$f":"IF(SUM(C11:C14)>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,null,"BIOL 201+284",{"$f":"IF(SUM(C9:C14)>=2,\"OK\",\"Need\")","v":"Need"},"Must be >=2"]
[null,null,null,null,"BIOL 280",{"$f":"IF(Sheet3!F$9=2, IF(SUM(C15:C17)>=3,\"OK\",\"Need\"),\"\")","v":""},"if project, must be >=3"]
[null,null,null,null,"BIOL 255",{"$f":"IF(F10>0,\"OK\",\"Need\")","v":"Need"},"Must be>=1"]
[null,null,null,null,"Units of Grad courses graded",{"$f":"F22","v":0}]
[null,null,null,null,"Units of Undergraduate courses graded",{"$f":"M22","v":0}]
[null,null,null,null,"Total units graded",{"$f":"F35+F36","v":0}]
[null,null,null,null,"Graduate units",{"$f":"C22+F22","v":0},null,null,"Required","Required"]
[null,null,null,"Percent Graduate Units",{"$f":"IF(E41>0,F38/E41,\"\")","v":""},{"$f":"IF(E41>0, IF(E39>=I39,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.5,{"$f":"I39*H$6","v":15},"units"]
[null,null,null,"Percent Graded Units",{"$f":"IF(E41>0,F37/E41,\"\")","v":""},{"$f":"IF(E41>0, IF(E40>=I40,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=",null,0.6,{"$f":"I40*H$6","v":18},"units"]
[null,null,null,"TOTAL UNITS",{"$f":"C22+F22+M22","v":0},{"$f":"IF(E41<>I41, IF(E41>I41, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",null,{"$f":"H6","v":30}]
[null,null,null,"GPA",{"$f":"IF((J22+Q22)>0,(J22+Q22)/(H22+O22),0)","v":0},{"$f":"IF(E42>0,IF(E42>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=3.0"]
[null,null,null,null,"Culm Exp Selected",{"$f":"IF(Sheet3!F$9=1, \"Do exams\",\"Do report and presentation\")","v":"Do exams"}]
[null,null,null,"Culmination Experience",null,{"$f":"IF(Sheet3!D9=2, \"OK\", \"To Do\")","v":"To Do"}]

{"sheet":"AMP","index":1,"n_rows":43,"n_cols":27,"rows_kept":43,"cut":false,"hidden":true,"merged":[[7,11,7,16],[27,2,27,9],[2,3,2,6],[2,9,2,10],[7,4,7,9],[7,1,7,2]]}
[]
[]
[null,null,"Student:",null,null,null,null,null,"SID:"]
[]
[null,null,"Determining if Candidacy Requirements have been met for:"]
[null,null,"MA - Biological Sciences - Alternate",null,null,null,null,null,"Units",30]
[]
[null,"Courses - CR/NC",null,null,"Graduate Courses - Graded\n",null,null,null,null,null,null,"Undergraduate Courses - Graded"]
[null,"Course","Units",null,"Course","Units","Letter Grade","Units graded","Grade Pt","GPU",null,"Course","Units","Letter Grade","Units Graded","Grade Pt","GPU"]
[null,"BIOL 201",null,null,"BIOL 202*",null,null,{"$f":"IF(G10<>\"\",F10,\"\")","v":""},{"$f":"IF(G10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(G10<>\"\",(I10*F10),\"\")","v":""},null,null,null,null,{"$f":"IF(N10<>\"\",M10,\"\")","v":""},{"$f":"IF(N10<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N10,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},{"$f":"IF(N10<>\"\",(P10*M10),\"\")","v":""}]
[null,"BIOL 280",null,null,"BIOL 255",null,null,{"$f":"IF(G11<>\"\",F11,\"\")","v":""},{"$f":"IF(G11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,{"$f":"IF(N11<>\"\",M11,\"\")","v":""},{"$f":"IF(N11<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N11,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 284",null,null,null,null,null,"",{"$f":"IF(G12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N12<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N12,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"BIOL 299",null,null,null,null,null,"",{"$f":"IF(G13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N13<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N13,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[]
[]
[]
[]
[null,null,null,null,null,null,null,"",{"$f":"IF(G18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N18<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N18,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N19<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N19,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N20<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N20,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N21<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N21,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,null,null,null,null,null,null,"",{"$f":"IF(G22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!G22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},"",null,null,null,null,"",{"$f":"IF(N22<>\"\",INDEX('Grad point'!$E$4:$E$15,MATCH(AMP!N22,'Grad point'!$D$4:$D$15,0)),\"\")","v":""},""]
[null,"TOTAL",{"$f":"SUM(C10:C22)","v":0},null,"TOTAL",{"$f":"SUM(F10:F22)","v":0},null,{"$f":"SUM(H10:H22)","v":0},{"$f":"SUM(I10:I22)","v":0},{"$f":"SUM(J10:J22)","v":0},null,"TOTAL",{"$f":"SUM(M10:M22)","v":0},null,{"$f":"SUM(O10:O22)","v":0},{"$f":"SUM(P10:P22)","v":0},{"$f":"SUM(Q10:Q22)","v":0}]
[]
[null,null,null,"Type of culminating Experience:",null,null,null,null,null,null,null,"Culminating Experience"]
[]
[]
[null,null,"CRITERIA      "]
[null,null,null,null,"Units for"]
[null,null,null,null,"BIOL 201",{"$f":"IF($C10>0, \"OK\",\"Need\")","v":"Need"},"Must be>=0.5",null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,null,"6 units"]
[null,null,null,null,"BIOL 202",{"$f":"IF(F10=3,IF(H10<>\"\",\"OK\",\"Need\"),\"Need\")","v":"Need"},"Must be=3",null,null,null,"* Must be completed BEFORE turning in Candidacy form"]
[null,null,null,null,"BIOL 255",{"$f":"IF(F11>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,null,"BIOL 284",{"$f":"IF(C12>0,\"OK\",\"Need\")","v":"Need"},"Must be >0"]
[null,null,null,"Units of Grad courses graded",{"$f":"C11+F23","v":0}]
[null,null,null,"Units of Undergraduate courses graded",{"$f":"M23","v":0}]
[null,null,null,"Total units graded",{"$f":"E34+E35","v":0}]
[null,null,null,"Graduate units",{"$f":"C23+F23","v":0},null,null,null,"Required","Required"]
[null,null,null,"Percent Graduate Units",{"$f":"IF(E42>0,E37/E42,\"\")","v":""},{"$f":"IF(E38>0, IF(E38>=I38,\"OK\",\"Too Low\"),\"Too Low\")","v":"OK"},"Must be >= ",null,0.5,15,"units"]
[null,null,null,"Percent Graded Units",{"$f":"IF(E42>0,E36/E42,\"\")","v":""},{"$f":"IF(E39>0, IF(E39>=I39,\"OK\",\"Too Low\"),\"Too Low\")","v":"OK"},"Must be >=",null,0.6,{"$f":"0.4*30","v":12},"units"]
[null,null,null,"9 units of 201, 202. 255 and 284",{"$f":"C10+C12+F10+F11","v":0},{"$f":"IF(E40>=9, \"OK\", \"Too Low\")","v":"Too Low"},"Must be >=9"]
[null,null,"Culminating Experience",null,null,{"$f":"IF(Sheet3!D10=2,\"OK\",\"To Do\")","v":"To Do"}]
[null,null,null,"TOTAL UNITS",{"$f":"C23+F23+M23","v":0},{"$f":"IF(E42<>30, IF(E42>30, \"Too High\",\"Too Low\"),\"OK\")","v":"Too Low"},"Must be = ",null,{"$f":"J6","v":30}]
[null,null,null,"GPA",{"$f":"IF((J23+Q23)>0,(J23+Q23)/(H23+O23),0)","v":0},{"$f":"IF(E43>0,IF(E43>=3,\"OK\",\"Too Low\"),\"Too Low\")","v":"Too Low"},"Must be >=3.0"]

{"sheet":"Grad point","index":2,"n_rows":15,"n_cols":5,"rows_kept":15,"cut":false,"hidden":true,"merged":[]}
[]
[]
[null,null,null,"Grade","Grad Pt."]
[null,null,null,"A",4]
[null,null,null,"A-",3.7]
[null,null,null,"A+",4]
[null,null,null,"B-",2.7]
[null,null,null,"B",3]
[null,null,null,"B+",3.3]
[null,null,null,"C",2]
[null,null,null,"C-",1.7]
[null,null,null,"C+",2.2999999999999998]
[null,null,null,"D",1]
[null,null,null,"D+",1.3]
[null,null,null,"F",0]

{"sheet":"Sheet3","index":3,"n_rows":9,"n_cols":8,"rows_kept":9,"cut":false,"hidden":true,"merged":[]}
[]
[null,null,null,"GRE Score",null,null,null,"CHOOSE"]
[null,null,null,"Internship",null,null,null,"BIOL 255E"]
[null,null,null,"TA",null,null,null,"BIOL 255M"]
[null,null,null,2,null,null,null,"BIOL 255P"]
[null,null,null,null,null,null,null,"BIOL 255L"]
[null,null,null,"Not Complete",null,"Exams"]
[null,null,null,"Complete",null,"Project"]
[null,null,null,1,null,1]

{"sheet":"Sheet1","index":4,"n_rows":0,"n_cols":0,"rows_kept":0,"cut":false,"hidden":true,"merged":[]}