In the files
#idfirstlastgradyearyearhouse 1200Harry Potter20196Gryffindor 2201HermioneGranger20196Gryffindor 3202RonaldWeasley20196Gryffindor 4203DracoMalfoy20196Slytherin 5100KatieBell20187Gryffindor 6204LavenderBrown20196Gryffindor 7205SeamusFinnigan20196Gryffindor 8206NevilleLongbottom20196Gryffindor 9300LunaLovegood20205Ravenclaw 10207ErnieMacMillan20196Hufflepuff 11101CormacMcLaggen20187Gryffindor 12208PansyParkinson20196Slytherin 13500JimmyPeakes20223Gryffindor 14209DemelzaRobins20196Gryffindor 15210ZachariasSmith20196Hufflepuff 16211DeanThomas20196Gryffindor 17400RomildaVane20214Gryffindor 18301GinnyWeasley20205Gryffindor 19212BlaiseZabini20196Slytherin IDLastFirstGradYearGradTermDegreeProgram 101010LeeShane2019SpringMSA 101020ZhangEve2019SummerMSSD 101030AnthonyDaisy2020FallMSBA 101040WareTyson2019SpringMSGF 101050SheaMarley2019SummerMSIT 101060DukeMatteo2019FallMSM 101070BlackwellSavannah2020SpringMSMI 101080EstradaRose2021SummerMSMM 101090LewisAlexis2021FallMSGF 101100ReevesReagan2021SpringMST 101110ObrienJovan2020SummerMSSC 101120BrennanHaylie2019FallMSBA 101130ProctorReagan2020SpringMSBA 101140WalkerYesenia2020SummerMSBA 101150FletcherCraig2021FallMSGF 101160MillsBraedon2021SpringMSGF 101170CookNaima2019SummerMSGF 101180CruzNyla2019FallMBA 101190PollardKaleigh2020SpringMBA 101200LarsonDaniela2019SummerMSSD 101210HerreraRichard2019FallMSBA 101220StewartMarshall2019SpringMSGF 101230CampbellAmiyah2020SummerMSSD 101240SmithMichaela2021FallMSBA 101250JoyceIzabella2020SpringMSGF 101260HollandCyrus2021SummerMSA 101270SharpAdrian2020FallMSSD 101280GentryAnnalise2019SpringMSBA 101290FinleyKelsey2020SummerMSGF 101300FoxGia2020FallMSIT 101310DuarteSteven2021SpringMSM 101320SchultzJacob2020SummerMSMI 101330WileyHazel2019FallMSMM 101340CastanedaRonin2019SpringMSGF 101350VillanuevaJace2020SummerMST 101360CantuMara2019FallMSSC 101370MoranMike2019SpringMBA 101380SingletonRiley2019SummerMBAP 101390BaxterXzavier2020FallMBAE 101400NewmanCristina2021SpringMSBA 101410YuAlejandra2021SummerMSGF 101420BennettTony2021FallMSIT 101430PhamAlan2020SpringMSM 101440CrawfordEmilio2019SummerMSMI 101450MeltonAbbey2020FallMSMM 101460DiazClarissa2020SpringMSGF 101470BlakePedro2021SummerMST 101480JimenezMikayla2020FallMSSC 101490JuarezMyla2019SpringMBA 101500MayoJazmyn2019SummerMBAP 101510SaundersIreland2020FallMBAE 101520HendersonJakob2019SpringMSA 101530IbarraMelissa2019SummerMSSD 101540JarvisDavid2019SpringMSBA 101550HouseDennis2020SummerMSGF 101560KelleyNikolas2021SpringMSIT 101570CordovaRiley2020SummerMSM 101580PooleMorgan2021FallMSMI 101590HoodMakhi2020SpringMSMM 101600OdonnellMarlene2019SummerMSGF 101610ComptonJoshua2020FallMST 101620CraneChance2020SpringMSSC 101630PalmerWalter2021SummerMSBA 101640PrestonHadley2020FallMSBA 101650MarshDavian2019SpringMSBA 101660SpenceKenny2019SummerMSGF 101670MorrisHaleigh2020FallMSGF 101680HarringtonMila2019SpringMSGF 101690LaraRaul2019SummerMBA 101700CooleyMaria2019FallMBA 101710OrrOrion2020SpringMSSD 101720RiceMaritza2021SummerMSBA 101730ReynoldsJordan2019FallMSGF 101740ChaseTatum2021SpringMSSD 101750HoffmanAddison2020SummerMSBA 101760NovakBraylon2019FallMSGF 101770RasmussenEmanuel2020SpringMSA 101780HaasAlfred2020SummerMSSD 101790NicholsonCarlos2021FallMSBA 101800WatsonMarco2019SpringMSGF 101810ForbesDillan2019SummerMSIT 101820MorseEmmett2019FallMSM 101830RichmondCruz2020SpringMSMI 101840RomanZaiden2019SummerMSMM 101850SinghJulius2019FallMSGF 101860CamachoJamya2019SpringMST 101870FranklinDexter2020SummerMSSC 101880BooneRaegan2021FallMBA 101890MeyerEfrain2019SpringMBAP 101900KeithAaron2021SummerMBAE 101910HoJoaquin2020FallMSBA 101920DuffyJett2019SpringMSGF 101930KnoxDaniel2020SummerMSIT 101940VillarrealFelicity2020FallMSM 101950SawyerZion2021SpringMSMI 101960BanksMariam2019SummerMSMM 101970PughSamuel2019FallMSGF 101980AyersTaniya2019SpringMST 101990CherryGage2020SummerMSSC 102000AdkinsDavon2019FallMBA Microsoft Word - INSY3436 Project Assignment.docx INSY3436–ProgrammingwithPython Fall2019 GroupProjectAssignment–StudentQueryTool(SQT) SUMMARY TheoverallgoalofyourSQTprogramistoreadstudentrecordsfromafile,andlet theuserenterqueriesinordertoseeadetailorsummaryreport.Theprojectuses manyofthetopicscoveredinclass,includingprimitives,datastructures,control statements,consoleinput/output,exceptions,files,parsing,andformatting. INTERIMDELIVERABLES Therearetwointerimdeliverablesfortheproject.Thefirstdeliverable(Design)isa shortdescriptionoftheproposeddatastructuresandfunctions/methods.The seconddeliverable(Prototype)isPythoncodethatimplementssomeorallofthe project'srequiredfunctionality. TIMING Step E01 R01 DesignDue 11/12 11/14 PrototypeDue 11/26 11/26 FinalProgramDue 12/3 12/5 Groupswillmeetoutsideofclasstime.Youshouldallowforadequatetimeto discuss,design,code,assemble,refine,andtestyourprogram. PROGRAMINPUTS Thestudentinputfilehasthefollowingfields: StudentID# Lastname Firstname Graduatingyear(e.g,2019) Graduatingterm(Fall,Spring,Summer) Degreeprogram(e.g.,MSBA,MBA,etc.) Thisinputfilehasaheaderrecord(afirstlinedescribingthefieldsinthefile).Each fieldisseparatedbyatab.Examplefilestouse(e.g,students.txt)willbepostedon Blackboard. PROGRAMPROCESSING Yourprogramshouldreadeachrecordofthefileonceintoadatastructure(e.g.,list, dictionaryorclass).Theprogramshouldkeeptheinstanceofthedatainmemory forthedurationoftheprogram,i.e.,itshouldnotre-readthedatafromthefilefor eachuserquery. Yourprogramshouldallowqueriestobeentered,regardingthestudentlist.Types ofqueriesinclude: Displayallstudentrecords Displaystudentswhoselastnamebeginswithacertainstring(caseinsensitive) Displayallrecordsforstudentswhosegraduatingyearisacertainyear Extracredit:Displayasummaryreportofnumberandpercentofstudentsin eachprogram,forstudentsgraduatingon/afteracertainyear Theexactwaytogetuserinputanddisplaytheresultswillbedecidedbythegroup. Theuserinterfaceshouldbeviatheconsole(screenandkeyboard). Theprogramshouldanticipateandhandleanumberofpotentialerrorsrelatedto userinputorthefiledata. Optionally,anadditionalfunctionalitythatyouchoosecanbeaddedtothesystem. However,groupsshouldaimforabasicworkingsystembeforeenhancingit. GROUPS Eachstudentcanoptionallyrequest(viaaQualtricssurvey)astudentthatthey wouldliketohaveintheirgroup.Basedonthisfeedback,theinstructorwillform groupsof2-3people.Studentrequestswillbeconsideredwhenforminggroups, howevernotallrequestsmaybemet. GRADING Allgroupmembersofthegroupwillreceivethesamegrade,whichwillbebasedon: Qualityofthedesign Qualityofthecode(includinglogic,errorhandling,commenting) Abilitytomeettherequirements Yourfinal.pyfile(s)fortheprogramwillbesubmittedtoBlackBoard.