ࡱ> UXT] bjbjjj 7J)b)b ,D&& &&&&&&&$I(*B&s"B&[W&///.&/&//R~#%|'4.r$&m&0&$+++<%%&+@%/B&B&&+B Z: College Spreadsheet Project Your next assessment for the Excel unit will require you to conduct research and create a spreadsheet of your researched results. Convince me that your choice was the best choice for you. Your spreadsheets should be well planned and should look attractive. You should add graphics to enhance the appearance. Use shading, colors, font changes, and any other formatting changes that might add to the appearance of your spreadsheet. Remember to make your spreadsheets and charts easy to understand and attractive to look at. COLLEGES: You can use the Internet to find information about colleges and universities that you could possibly and realistically attend. Many college sites consist of hundreds of pages containing information about courses, prerequisites, professors, student groups, costs, and even dormitory accommodations. Some pages even allow you to register online. Determine where you would like to attend college and the type of program that interests you Take notes on your research including: tuition, fees, room and board, and number of students that attend each college. Design a rough draft of your information gathered and what your spreadsheet will look like Next, set up a table in Excel that lists the information in the categories displayed below You will research six (6) colleges/universities of your choice, using the internet, Post-high school center, catalogs or view books, gathering financial information (costs) regarding each of the schools and then create your own spreadsheet with the information researched. Requirements:Points:6 Colleges including: Tuition per semester Books per semester Room and board per semester Fees per semester Miscellaneous costs per semester (?) Total undergraduate enrollment (number of students that attend) Arrangement (HINT: arrange your spreadsheet so that the college titles are the row headings and the costs are the column headings)  60 pointsFormulas to calculate: Total cost, per semester, and per year--per college Average cost of books of the colleges you chose Maximum cost of tuition of the colleges you chose Use an IF function to determine if the colleges are affordable for you to consider. ie: the total cost of 4 years is greater than $45,000, then no, if not yes. Chart: Create a column chart to compare the total costs of each school. Label the chart to help the reader understand your chart 60 pointsRough Draft & Notes: Submit the notes you took on all of the colleges and universities that you researched. Submit your rough draft. 30 pointsPrint & Email: 1 copy with your data (landscape or portrait?) Fits on one page? 1 copy showing your formulas (landscape or portrait?) Fits on one page? Print the chart with appropriate labels, titles, and legend. E-mail Mr. Philip your Excel spreadsheet. Total points 150 Hint: Read all of the instructions and your rubric before you begin. Be detailed in your information and demonstrate your knowledge of Excel through this project.  &Yauvw' . W - . 8 ɽɽlWB(hh1m5B*CJOJQJaJph(hhou.5B*CJOJQJaJph3f%hhou.B*CJ,OJQJaJ,ph3fhh1m5>*OJQJ#hhG=5>*B*OJQJph#hhC5>*B*OJQJphhhG=5OJQJhh1m5OJQJhh85OJQJhh1m5CJOJQJhh1m5CJ OJQJhh85CJ OJQJ- . 8 9 g  /=E $$Ifa$$If & Fgd"R & Fgdou.$a$ g   ! . 5 L q /<=EFG^eٿٴthٴZhZhhhy.5CJOJQJhhy.5OJQJhh"yOJQJh,5OJQJhhy.OJQJhhqMOJQJhh("OJQJhh>OJQJhh1mOJQJhh1m5CJOJQJhh"y5OJQJhh1m5OJQJhh("5>*OJQJhh("5OJQJ#EF^s&mg]]P]]]] & F$Ifgdy. & F$If$Ifkd$$Ifl40t"-" 0l-4 laf4pyt"R erx&',deȺpg[hhpRF5OJQJh,5OJQJ+jhhD*5OJQJUmHnHuhh85OJQJhh("5OJQJhh?`5>*OJQJhhy.5>*OJQJhh>5>*OJQJhhy.5OJQJhh("OJQJhh5} OJQJhhy.OJQJhh}ZOJQJ& $$Ifa$$If $Ifgd?` -_ke[[[[R $Ifgd?` & F$If$Ifkd$$Ifl4` 0t"-" 0l-4 laf4pyt"R =E_ 'GHIOY˿˿˴˿˒ˇ{ofZhhpRF5OJQJh,5OJQJhh*t5OJQJhh("5OJQJhh>OJQJhh?`OJQJhh?`5OJQJhh~IOJQJhh"OJQJhhy.>*OJQJhhy.OJQJhhy.5OJQJ hh>5B*OJQJphhh>5OJQJI $$Ifa$ & F h$If^hgd?` &mgVVggJ $$Ifa$gdD* & F h$If^hgdD*$Ifkd$$Ifl40t"-" 0l-4 laf4pyt"R%'56GKv&()79:;<B󴣒ppeY̴eLjhDqh,<UhhpRF5OJQJhhy.OJQJ hh5B*OJQJph hh"y5B*OJQJph hhD*5B*OJQJph hhy.5B*OJQJphhhy.5OJQJhD*hD*5OJQJh,5OJQJhhD*OJQJhD*hD*OJQJhD*OJQJhhD*5OJQJ&'6w&'(mg]]PPgg & F$Ifgd(" & F$If$IfkdY$$Ifl40t"-" 0l-4 laf4pyt"R():;<Bd___gd"Rkd$$Ifl40t"-" 0l-4 laf4pyt"R $$Ifa$21:p("/ =!"# $% @=cYfV4,>0 PM (x\ U?2 f[$2٢Ec Im[JCRJkZjJ%c_QzC>{Ǔz<{9{;Dԙi kC1(yN%0~ M2+ F!JZ4)^"Ptӧs-/z i=BX!I1wEmPmz v[~ӒGgW˓PӦ h]{^RoާMèb(.dUu-U7܇]Z't}^un;_ELHKhԊ1W&*.Nfz?%Q ؠq Fh8tmݺV\I- >}:M8(55RRR(99(66)22ҳ.AY4`N4;`9bˌJ5Rt ~ Ev@Bl hL:@1I1'%M'J@sQzQ&ȳBm't-`T4R02 ON,(6%UMXJ.O)QAtƻA0^<ƫ(WY`[ Ƌ(:vΠ`lz:c'Q6&O'@*݈F_ޘmݐ6WZqXoTrY3!|)a)+ً{t[Xz8z]5O>\˫QRG8VjRKTbu#ԑ+uMTURURRE_Je DH%hG(WGwN`lK`X>KL`!xx  3g'DQ`<0<F#a=``p'W@W]\Ew@[-n4:q@-5k*\[We9N_ut)8^07Ǎt7֊ 5'%`GCbqT{0ww^e`2ᡒ]Fy$L Fqz751os. Yk`.M0W=Ri?$uuOIo)HIWJk$R1כ!xq_>oIUU̕2KJT)R^2I*H_\5,Ctnw^ʽT2_1+xZQFqgH}_Ez]tApu4cҔGJdK9|ba{iMdה0i xT1 OUK< o$WSgi %`yM(^xHv3\#n_!v &wROμT[o {KiHyRu2<(*wh|=5QN@{UR:-TPhI 5+sGexW)ByCT'. @ [k7oU}qEVW+U=[˽ آjFe\>FYj4Oƪ|'=۹$ AZe\OW(-Cٮ*?Ç^?OUU̸/W1LUWghOQx?QcYnT z|㮀֗s~o|hI? c$Cnt‘**׫HIV0i䨗Z^j_/nqGĢ<.+ G t! @A:ޭ DϟC[ـraWz` JTIfk=lV{6μ 8nQuAK=9:D@fAUM̛ȵYUGv,VW,kWF NM_%Z7Ƴ$V5m@@_aFvS]@>vaR%O`"+&\ofb)Qdk WEյRT.x_VMAUJY bh qF^og^~p^_Epbn;xwV oh獠GxĘx hWvn'fw~>{=G1 g-,ᢑAƞYDZ"_k,.A*!W*$rbȟ |;I.,>/ηa8`opb42-Dk9;\%M!%/(FbTkpkkgpY1*x< JU hs^+y2zM() r˹jȺXyC&bʟ=P^)5Z|&y-gqzM(=ʧ)49(9w;pvfVyT>Q^RBKt){a5|%)ҍ| T!ޒS,Rz/ֻNSVVNG0-`EekH!dhs~ZsZx s6t{5g\WFǎ GYeU'" UAU9k2?.\kvUXU~t{:q.Cr2,G'gkx,Ͱ~!O}I؃&O#ks/py>gװ͆6@M%zܯ]c,Fl:_!;'u~ c!ygȍ߄~6_CT:[[ F|%IOW,u#soܒ R>{}ڻ8E|'xYh{r۫^k9h5ϻ kpzBpl7޹n<AQއC>G:O+|?0>NnL~c=gd?M/b'Ga&k&p~ՆyK'M>*c?^o^3u&K~mh)tWF%t%Ghg ˣ&٣kED V0.?` Ӻw5x$SX(/*\UXWk׻YqvݗWs+ k^}Z0bl?"`v,e_? rZ /<5SN֯LV2(gmm[Ucoџ'Y&>s7/{iypkDtoBԋv] R5q;_hm7Z!^,Ś_Us@[wKUaƜj/X[Ƭ[?Yn>hb`UaٸƢ6.]ah-MRkNzTǮ>tG_џ&Л-ƭ,W'hd$ٹ1U;ھv\$NVͬL11}޳3^w갬=f?2Ԣt7ۿ?>Ō0_n7鏪Y1ctvmc=[X~od M5윍<⥓[kfvʯܨ9fמ!pY_Q/|)ﶾG1î۬FZc;^'(U΅;Ts}Z[P }C0=ZNϐ3f_V}WPata6.qw]#oq0 0+D; r{]4xF(*!'j\-CP%ur3K(G24#͢gouGNg,$ Rdtm$3֟.(%7B{J#.쭓_da}#Yd1KY[5W3̸0~MwBx&GOgE`cJ=kx;/;Rggmkx]?xYu|<5U@[: ƠsLsW~;}WCT߸hiA4-XnKj4w!yB]&''r:4\FG:0?]X:mkL_;s4sи2Goi\]g7Wk槹ܙK?%>&OjsԜMC{5:׮9: ͍`|ո2:^7ǫj1WϮsX]j~&TGK4Uڮիz2WsoCL=?q}~9IdwX̘Z |ǼsUƼgsiB~>|Ytf_qUg* ,>l@i\U/ѸJsYE/$ZݒխfFoՕɫL{ih9t|ᵏNfByp?WXC-t4K&{ck)/V;γnﰺxŽc>&#./TƳ:c(tyҾ;W}nnVq߻nwGM&QB;7zSPh֊Oc|354Q($ ߭2?S bb4;W-χ)`i\?{L44c4U{}ҸӳiUqU|{_z>?r ic:E3v@P~Ds |w<v . e E&&( l  ,"$cYfV4,>0 4.@|(  D   A"?B S  ? ( t_PictureBullets 6 9 ) : 3/245FG  % % 7 9 ; /245FG  % % 7 9 ;  OL%  > x x^'b/|VG. Oj6-v3 /R Y_Xed?>#hb/|V6i [kq CDkvZ! hh^h`OJQJo( hh^h`OJQJo(hh^h`.hh^h`o(. hh^h`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH hh^h`OJQJo("88^8`B*CJOJQJo(phhH^`OJQJ^Jo(hHopp^p`OJQJo(hH@ @ ^@ `OJQJo(hH^`OJQJ^Jo(hHo^`OJQJo(hH^`OJQJo(hH^`OJQJ^Jo(hHoPP^P`OJQJo(hHhh^h`o(.hh^h`. hh^h`OJQJo(h^`OJQJo(hHh^`OJQJ^Jo(hHohp^p`OJQJo(hHh@ ^@ `OJQJo(hHh^`OJQJ^Jo(hHoh^`OJQJo(hHh^`OJQJo(hHh^`OJQJ^Jo(hHohP^P`OJQJo(hH 3 /R[kq >x^'>#hG.OL%6ixY_XOj6CDkv          <|                 LsC [p,+qM5} ("uG=#C8m&D*~#.ou.y.BCpRFnF~I}Z?`cQ[)+AS1m,3uv"0)?@ABCEFGHIJKMNOPQRSVWZRoot Entry F(4Y@Data &1Table.+WordDocument 7JSummaryInformation(DDocumentSummaryInformation8LMsoDataStore0k&4|'4JFETSQANOMBHA==20k&4|'4Item  PropertiesUCompObj r   F Microsoft Word 97-2003 Document MSWordDocWord.Document.89q