Note that sometimes, particularly with Windows, Excel has a hard time performing calculations on the pivot table results.

profileClark1026
CIS220ClassSurveyFall20202.xlsx

Survey Data

How are you? Year From US US State Country Living Now Time Zone Difference Bus Major Bus Track Non-Bus Major Double Major Working alone? Industry Dream Job Grad School after UG Grad School Type Program? Prog Lang Favorite Company Favorite Music Stock Investor Hobbies Covid Activities Worked for start-up Like to work for start-up Start-up Description # Classes # Hybrid Classes Attend Hybrid Freq Prefer Online/Hybrid Make online better CIS 220 Discussion Board What Discussion Board CIS 220 Happy Hour
Good Sophomore Yes NY In the US, but not in Rochester Yes Business Analytics SART Yes Art Yes No Spotify Yes No No 5 1 Never Like both roughly the same No I don't think we should use a discussion board Yes
Good Senior No China In the US, but not in Rochester 1 Yes Doing the BA, so no track MTH No Consulting consultant Yes Ba/finance program No Apple Music No majiang taking extra online course No Yes 3 0 Never Hybrid give us more flexibility on assignment and exam Yes Blackboard Yes
Good Junior Yes California On campus Yes Marketing ECO Yes Consulting Consultant No No CBRE Apple Music No Netflix Nothing No No 6 3 Never Like both roughly the same No I don't think we should use a discussion board No
Very Good Senior Yes NY On campus No DSC No Consulting Owner of an MLB team No Yes Python Apple Spotify Yes Sports, video games, hanging out with friends. Workout No No 4 1 Rarely Like both roughly the same Be as accommodating as possible for all students. No I don't think we should use a discussion board Yes
Good Junior Yes New York On campus Yes Business Analytics Yes Not sure Opening my own business No Yes SQL Nike Apple Music Hiking, reading, drawing Worked, and also spent more time with my family Yes Yes Real estate company that turns old buildings into housing 4 3 Most of the time Hybrid Keeping students engaged and cameras on really helps No I don't think we should use a discussion board Yes
Good Senior No China On campus Yes Finance ECO No Private Equity and Investment Banking Teacher Not sure MBA Yes PYTHON Morgan Stanley and KKR None Yes Fencing, Cat, and Taekwondo Internship and interviews No Yes 5 5 Some of the time Hybrid Reachable material for review No I don't think we should use a discussion board Yes
Fair Junior No China On campus Yes Business Analytics PSY No Consulting Consultant Not sure Yes Python Amazon Apple Music Yes Swimming Working Yes Yes Making a server 5 2 Rarely Like both roughly the same Make it more interactive Yes Blackboard Yes
Very Good Junior China In Rochester, but off campus Yes Finance No Law investor Yes top 10 law school or Wharton Business School in real estate No Bloomberg Spotify Yes Table Tennis, Tennis, and golf practice table tennis and tennis with my boyfriend.And prepare for GRE test; Went racing cars with my friends Yes Yes 4 1 Most of the time Hybrid offer more time for students to discuss Yes Blackboard Yes
Fair Senior No Outside of the US 11 Yes Marketing No Marketing, Media, News & Television No Yes Python Netflix, Sephora Apple Music No Dancing, listening to music, watching youtube and reading novels Participating in clubs’ activities, taking dancing courses and fitness classes No No 5 0 Online - More available for help outside class - Can make use of a communication channel other than BlackBoard (slack) Yes Slack Yes
Excellent Junior No N/A Mexico On campus Yes Finance ECO No Investment Banking Investment Banking Analyst No N/A No N/A Spotify Spotify Yes Playing soccer, hanging out with my friends, watching Netflix, work out Work out, play soccer, watch Netflix No Yes N/A 5 3 All of the time Hybrid At least my professors, have made online teaching great and very efficient No I don't think we should use a discussion board Yes
Very Good Sophomore Yes NY On campus Yes Marketing PSYC No Organizational behavior Traveling with a firm and doing efficient work in business Not sure Business No Ultra Human Nootropics Spotify No Basketball, powerlifting, waterfall jumping, ping pong Lifting, basketball, waterfall jumping at home, and hanging out with friends Yes Yes Online fitness programming 4 0 Online Provide extra credit like this class. More importantly, Email updates said in class! No Email us more No
Good Junior Yes Massachusetts United States On campus 0 Yes Doing the BA, so no track CHM BIO No Dentistry Orthodontist / Oral Surgeon Yes Dental School Yes Python (only) Apple Spotify Yes Club field hockey, painting, fishing, hiking Tried to run more No No n/a 5 2 Some of the time Hybrid Try to get students to know each other or at least lecture live. One of my completely asynchronous classes doesn't feel "real" because there is no live interaction and it is all modules. No Discussion boards always turn into "I agree..." or "great point!" In other classes nobody really reads them it is just to get the participation points. I dont know if there is a way around that.
Fair Junior Yes NY On campus Yes Entrepreneurship No undecided Full-time musician Not sure No Porsche Spotify Yes Music, art nothing No No 5 1 All of the time Hybrid Keep classes synchronous instead of asynchronous. No I don't think we should use a discussion board Yes
Good Junior Yes Washington D.C. On campus Yes Business Analytics ECO No Sports Analytics General Manager for a sports franchise No Yes SQL Spotify Spotify Yes Watching/writing about sports, listening to music Learned how to DJ, worked No Yes 5 4 All of the time Hybrid Use polls and other engaging mechanisms No I don't think we should use a discussion board No
Good Junior No No China In China 12 Yes Finance No Bank Still not sure Yes master program in business school Yes Python Bank of China, I interned here Apple Music No Travel, Reading, Painting pass my GRE test and get 335, an remote working experience and a research Yes No 7 2 Never Online Recording is enough No I don't think we should use a discussion board
Good Junior No China In Rochester, but off campus Yes Business Analytics FMS No Consulting Consultant Yes Business school Yes Python EY Spotify No Play music instrument Internship and jobs No Yes 5 2 Some of the time Hybrid Be more moderate about due date and record each class Yes Slack Yes
Good Junior No Kazakhstan Kazakhstan 10 Yes Finance Yes Investment Banking Private Equity No Yes Python Apple Spotify Yes Soccer, Boxing Summer Internship No Yes 5 2 Never Online Upload class recordings on the day of the class No I don't think we should use a discussion board Yes
Excellent e5 Yes Puerto Rico In Rochester, but off campus No PHL PSY No medical Hospital Administrator/Physician Yes Medical School Yes java Airbnb Apple Music Yes workout Yes Yes healthcare informatics 6 2 Never Online Now that everything is online all classes are giving a larger amount of homework that could be overwhelming if not taken into consideration No I don't think we should use a discussion board Yes
Fair Senior No In the US, but not in Rochester 2 Yes Finance No Investment Banking, Corporate Banking Managing Director at a BB Bank, Investor Not sure Yes Python Berkshire Hathaway Spotify Yes Playing Golf, Cooking, Reading Worked on a startup, sent out job applications, watched Netflix Yes Yes 7 2 Some of the time Like both roughly the same Record your lectures – don't stream them, give really specific instructions on assignments, upload all assignments so students have the choice to start early if they're ahead Yes Facebook Groups -- This way, notifications won't get ignored because I'm sure everyone checks social media atleast a few times a day. Yes
Good Sophomore Yes Maryland In the US, but not in Rochester Yes Business Analytics No Product marketing or real estate Product marketing Not sure No Apple Spotify Yes Dance Blog Yes Yes Portable charger 4 0 Online Assignment Yes Blackboard Yes
Excellent Junior Yes Rhode Island In Rochester, but off campus Yes Finance Yes Finance Mutual Fund Manager Not sure No Apple Apple Music Yes Football, Golf, Poker Work No No 4 2 Most of the time Hybrid Be interactive No I don't think we should use a discussion board No
Fair Junior Yes NY In Rochester, but off campus Yes Doing the BA, so no track DSC No Technology Artificial intelligence Yes Data Science Program Yes Python Google NetEase Music No Play the cello, watch k-pop idol shows Take the GRE test, watch movies No Yes 6 6 Rarely Hybrid Go straight to the point, test the equipment and poll before recording No I don't think we should use a discussion board No
Good Junior Yes New York In Rochester, but off campus Yes Marketing No Medical Sales CMO Not sure Buisness School No Lululemon Spotify No Yoga, playing with my dog, working out, cooking Transferred schools, moved into my new apartment, worked at my internship fully remote Yes Yes Provides employee mental health and wellbeing benefits solutions 4 0 Online Require us to have the video on and post lecture notes and lecture content after class No I don't think we should use a discussion board Yes
Good Junior Yes New York NA. In Rochester, but off campus Yes Finance No Financial World Investment Banking on Wall Street! Not sure Yes Python Apple Spotify Yes Tennis, Skiing, Hiking, Weather, Cars, Technology, Money. Negotiating car leases for my family! No Yes 4 1 Never Online Engaging students through polls, discussions, break out rooms. Yes Slack Yes
Fair Junior No China In Rochester, but off campus Yes Finance No Finance Financial Analyst Yes The grad school that offers excellent finance program No Mckinsey&Co Apple Music No Playing basketball and working out Working out No Yes 7 2 Rarely Like both roughly the same Try to understand more about how students feel during the online learning/ Yes Blackboard Yes
Very Good Junior Yes Illinois On campus Yes Accounting No teaching- so probably a college prof Yes No Deciem Spotify Yes makeup, volleyball, embroidery No Yes 4 3 Most of the time Hybrid Yes
Good Junior Yes Rochester On campus Yes Finance No Finance Corporate Banking No No GS to work in Spotify Yes Event planning, stock market Working and interviews No Yes 4 1 Never Online Share PowerPoint slides as well as lecture recordings Yes Blackboard Yes
Excellent First Year Yes New York In the US, but not in Rochester No CSC Yes Semiconductor/Foundry Industry Computer and peripheral equipment manufacturing Not sure Yes Python IBM (International Business Machines Corporation) No. No Collect and watch mid 20th century films; read the Greeks; study of pre-modern history Stare down walls. No Yes 4 1 Never Online Provoke student participation as much as possible to retain attention/interest. Yes Blackboard Yes
Very Good Sophomore No Puerto Rico On campus Yes Marketing DMS Yes Social Media Digital Marketing Specialist No No Spotify No Rowing/Tennis/Reading Co-found a social media service company, explore Rochester, read Yes Yes social media marketing 5 0 Like both roughly the same Yes Blackboard Yes
Fair Junior No China In Rochester, but off campus Yes Accounting psy No cosmetics interior design Not sure No none Xiami music; NetEase music No entertainment No No 5 1 Never Online It's been organized pretty good for this class. No Yes
Fair Junior Yes New York In Rochester, but off campus Yes Accounting Yes Accounting CPA Not sure No Amazon Spotify No Tennis and video games Spend time with friends but through online. No No 4 2 Never Online I think surveys like these are helpful because professors can get feedback on what they're doing and students can provide insight on how to make the experience better. Personally, I am not sure what can be better. I feel like i am learning the same whether online or in person. But at least online, I can rewatch the lectures if I missed something. No I don't think we should use a discussion board No
Fair Junior No Nepal On campus Yes Accounting PHL No Banking / Finance N/A Not sure No Carvana Spotify No Cooking, Karaoke Summer job, Campus Clubs, Networking Yes Yes 6 5 Rarely Like both roughly the same Upload recordings quicker No I don't think we should use a discussion board Yes
Very Good Junior Yes New York On campus Yes Marketing PSC No International Relations Secretary of State No No Amazon Spotify Yes I like to take long walks and cook. I have cooked and baked. I have also maintained an internship. No Yes 5 1 Never Online Ensure that students are aware of testing and due dates. Yes Blackboard No
Very Good Junior No Tibet On campus Yes Marketing No Marketing CEO No No Apple Youtube Yes Reading Started Online business No Yes 4 0 Never Online Asking students to turn on their video No Yes
Good Junior No South Korea South Korea 13 Yes Business Analytics No Finance No Idea No Yes Python Goldman Sachs Spotify Yes Soccer Internship Yes Yes Yes, I am doing an internship at a statrup right now 4 3 Never Online Take into account the student's timezone Yes Blackboard Yes
Good First Year Yes New York On campus Yes Business Analytics MKT Yes No industry in particular in mind I don't have a dream job, just to be self employed to where i make my own hours and have multiple streams of income to retire at whatever age i please Yes Business school No Tesla Spotify Yes Playing handball (wallball), soccer, urban exploring Learn the stock market and learn to trade No Yes 4 2 All of the time Hybrid Make it more interactive No I don't think we should use a discussion board Yes
Good e5 Yes MA In the US, but not in Rochester 0 No BME Yes Medical Dentist Yes Business school Yes Python Thermofisher Spotify Yes Photography iGEM competition, an international synthetic biology competition Yes Yes medical device for monitoring physiological signals 6 4 Never Like both roughly the same some smaller sections? No slack Yes
Very Good Senior No Turkey In Rochester, but off campus Yes Finance APM Yes Finance Creating a trading team. No Yes Amazon Spotify Yes Soccer, Chess, and Contemplating Amazon FBA and getting supplies from Alibaba. Yes Yes Creating mobile applications. 5 2 Rarely Online Being straight forward. No I don't think we should use a discussion board Yes
Good Sophomore No China In Rochester, but off campus Yes Marketing No luxury marketing Yes MBA No LVMH Apple Music No travelling&reading workout No Yes 4 1 Rarely Online No I don't think we should use a discussion board Yes
Poor Senior Yes Virginia In Rochester, but off campus Yes Marketing No Music Business Spotify CMO Yes MA in Music Business No Spotify No Piano, drawing, hiking, thrifting Virtual internship No Yes 3 0 Like both roughly the same Interaction, understanding for missed deadlines Yes Twitter Yes
Good Junior Yes Ohio In the US, but not in Rochester Yes Business Analytics HIS Yes Still unsure at the moment Data Analytics of some kind, still figuring out the specifics Not sure Yes C++ Spotify Yes Reading, learning new languages, going to the gym My hobbies listed above No Yes 4 1 Never Hybrid Not sure at the moment, all of my current professors are doing an adequate to good job with online teaching Yes Blackboard Yes
Very Good Junior Yes New York N/a On campus Yes Marketing Yes Marketing or advertisement Chief marketing officer for Nike No No Nike Apple Music No Play basketball and help kids with disabilities Work for WCSA No Yes 4 1 Some of the time Like both roughly the same More interactive activities No No
Good Senior Yes New Jersey In Rochester, but off campus Yes Finance No Banking Not sure No NVIDIA Apple Music Yes Learned Portuguese No No 6 1 Some of the time Online Yes Blackboard Yes
Excellent Junior No Ghana On campus Yes Finance No An investment bank of an asset management firm Investment analyst in an investment bank No No Morgan Stanley Apple Music Yes Reading and listening to music Trading in the financial markets No Yes 4 1 Rarely Like both roughly the same I think it’s good. You guys are doing a good job Yes Blackboard Yes
Good Senior Yes New Jersey In Rochester, but off campus Yes Finance No Banking Not sure No NVIDIA Apple Music Yes Learned Portuguese No No 6 1 Some of the time Online Yes Blackboard Yes
Good Junior No China In Rochester, but off campus Yes Finance MTH No IDK illustrator Yes business school Yes JAVA&C++ Sony Spotify No art, music intership, summer school Yes Yes 6 2 Rarely Online record short pre-class videos to help st understand what we are going to learn No I don't think we should use a discussion board Yes
Fair Junior Yes California In the US, but not in Rochester 3 Yes Marketing ENG Yes Marketing/media Author Not sure No Spotify No Writing, yoga, hiking Internship, clubs, spending time w family No 5 0 Online Maybe more breakout rooms to take a pause from lectures No I don't think we should use a discussion board Yes
Good Junior No On campus Yes Business Analytics No Consulting Consultannt Not sure No Toyota Spotify No Watching Sports Work out at home No No 5 1 All of the time Hybrid No No
Very Good Junior Yes Connecticut In the US, but not in Rochester Yes Marketing Yes Marketing or Finance My dream job is to be a famous actor/singer or a game designer/working in a company that produces games I enjoy. No Yes Python Valve Corporation Spotify No Singing, acting, and gaming I spent more time connecting with my other friends online and talking to relatives more often. I also am pursuing how to play the piano. No Yes 4 0 Never Online Since mostly all classes have moved to an online setting, it helps to have the lectures recorded so that students can revisit material or watch a lecture that they may have missed. Having cameras on gives people a personal touch to the online classes which is nice. Finally, having the teacher be available online for office hours, aside from just emailing, helps a great deal as well. Yes Blackboard No
Good Senior No Australia Melbourne, Australia 14 Yes Marketing ECO Yes Consulting Development Consultant No No Rolex Spotify No Debating, Reading, Public Speaking Online debates, Reading groups No Yes 5 5 Never Online Although professors are being very considerate of time differences, it would be nice if more of them could understand the bandwidth issues many students face at home, and therefore mandate less videos being turned on during classes. No I don't think we should use a discussion board Yes
Fair e5 Yes Massachusetts In Rochester, but off campus No EES No Financial Activities Landscape Architect/GIS Specialist Not sure No Batker Consulting Spotify Yes Playing the piano, singing, gardening, geographic information systems walked, slept, applied for jobs to work concurrently with school Yes Yes 5 2 Never Online Apply soft deadlines. No I don't think we should use a discussion board Yes
Good Junior No China In China 12 Yes Finance No Yes No Apple Apple Music No Remote internship No Yes 4 0 Like both roughly the same Yes Blackboard Yes
Very Good Senior Yes Massachusetts N/A In Rochester, but off campus Yes Finance Yes Private Equity Partner at a Private Equity firm Not sure Either a masters in finance program or MBA program No Blackstone Apple Music Yes Golfing, hiking, reading Golfing, camping, hiking No Yes 4 2 Most of the time Hybrid Allow participation points in other ways than talking in class as sometimes my audio doesn’t work great. i.e. extra credit points like what Professor Jones does with these surveys. No I don't think we should use a discussion board No
Good Junior No United Kingdom United Kingdom 5 Yes Finance No Banking Investment Banker No No BlackRock Spotify No Economics, Pitching competitions and soccer Won the Charles and Janet Forbes Competition, raised investment from a leading conglomerate and now preparing to launch the business in Jan 2021 Yes Yes At Rent&Play we transform vacant rooftops of commercials buildings into sports arenas within the city hubs of Dhaka 5 5 Never Like both roughly the same I think structure and effective communication can be 2 areas that could be further improved No I don't think we should use a discussion board Yes
Good Junior No China In Rochester, but off campus Yes Business Analytics HIS No Business Analytics Business Analyst Yes Business School Yes Python Nvidia Apple Music Yes Play drums, hiking, photography took GRE exam, hike regularly , edit videos No Yes 4 1 Some of the time Online More personal activities to make online teaching less 'remote'. PS: I found out about the happy hour as I scroll down, which is a great example of my answer No I don't think we should use a discussion board Yes
Excellent Senior No 10 Yes Business Analytics CSC Yes Private Equity/Asset Management Not sure Yes Python Pioneer Spotify No No Yes 6 1 Never Online Yes Slack/Piazza Yes
Fair Junior No Taiwan Taiwan 8 Yes Doing the BA, so no track Eastman Violin's Performance No Marketer Have a business Not sure MBA No Amazon Spotify No Play the violin It does not really hit our country so my life does not change a lot during the covid except wearing mask. No Yes 5 1 Most of the time Online No I don't think we should use a discussion board Yes
Excellent Junior No China On campus Yes Business Analytics ENG No Strategy Consulting Strategic consultant Yes MIT Sloan (hopefully) Yes Python Boston Consulting Group Spotify Yes Yoga, watching films, reading, fencing, photography playing guitars, reading books No Yes 6 3 All of the time Like both roughly the same Turn on the video and ask questions to get students involved in the class. Yes Blackboard Yes
Very Good Senior Yes Massachusetts On campus Yes Entrepreneurship PSC Yes Law/Public Policy General Counsel Not sure Law School No Staples Spotify No Basketball, Twitter Helped Family with projects, organized family photo collection No No 5 0 Online Just ensure communication is clear and expectations are communicated No I don't think we should use a discussion board No
Good Junior No China In China 12 Yes Finance mth Yes business not sure yet Not sure Yes Java KPMG Apple Music No photography / go to the movies learning how to program / learning another language No Yes 4 1 Never Online make sure we have access to reach out for help Yes Blackboard No
Very Good Junior No China In China 12 Yes Business Analytics DCS No Business Consulting Yes MBA Yes Java Google Spotify No Travel Internship No Yes 5 3 Never Like both roughly the same Post students questions in the chat Yes Blackboard No
Very Good Junior No China In China 12 Yes Business Analytics DCS No Business Consulting Yes MBA Yes Java Google Spotify No Travel Internship No Yes 5 3 Never Like both roughly the same Post students questions in the chat Yes Blackboard No
Good Sophomore No China In China 12 Yes Finance psy No investment bankings travel blogger Yes with many sports activities No Alibaba Apple Music Yes watching movies. cooking. climbing. visiting grandparents. doing some workouts at home. losing weight. Yes Yes 4 0 Like both roughly the same nothing. Yes Blackboard No
Very Good Senior No China In China 12 Yes Business Analytics No Not sure Not sure Yes Business School Yes python Google Spotify No Cooking No Yes 4 0 Online Ensure high-quality recordings Yes Blackboard Yes
Good Sophomore Yes Georgia On campus Yes Entrepreneurship No Automobile Soccer player Not sure No Spotify No Soccer, German I was learning Excel basics. No Yes 5 2 All of the time Like both roughly the same I like the engagement between teacher and student. No I don't think we should use a discussion board Yes
Good Junior No On campus Yes Marketing DMS No Haven't decided yet Marketer Not sure No Apple Spotify No Photography Have worked as a graphic designer Yes Yes 6 0 Like both roughly the same To be good at digital tools/apps to prevent technical issues from happening very often. To structure the classes in a way that are very close to in-person class experience. No Yes
Good Sophomore Yes Virginia On campus Yes Marketing No unsure, possibly advertising Yes business school. Get my MBA No Apple Music Yes I play soccer safely, hang with friends No Yes 4 3 Most of the time Hybrid I think just being understanding of difficulties and focus issues of students when sitting in dorms No Blackboard Yes
Very Good Junior No Brazil On campus Yes Business Analytics ECO No Consulting or Analytics Chief Economist Not sure Yes Python Roku Spotify Yes Film, Fitness, Basketball, Snowboarding, Stock Market, Video Games, any outdoor activities. I took two Python for Financial Analytics classes, built my own stock portfolio using that knowledge, and wrote a brief report of the impact of the Federal Reserve's Coronavirus policies on the Stock Market. Yes Yes 4 2 Some of the time Like both roughly the same Some more individual contact could help. Yes Blackboard Yes
Very Good Junior No China In China 12 Yes Business Analytics No Finance Yes Business analytics Yes java Spotify Yes soccer No Yes 5 5 Some of the time Like both roughly the same No No
Good Junior No On campus No PSY BCS No Yes No Spotify No Watching movies, reading, listening to music work, movies, talk to friends Yes Yes 5 1 Some of the time Online No I don't think we should use a discussion board Yes
Fair Junior No Kazakhstan In Kazakhstan 11 Yes Finance No Consulting Business Consultant at a top firm No Yes Python Apple Spotify Yes Soccer, Movies/TV shows, classic and fantasy literature Read a lot of books, worked as an English teacher, watched a ridiculous amount of shows and movies, started preparing for internship recruiting Yes Yes Consulting recruiting + podcast and newsletter 4 1 Never Like both roughly the same If at all possible, post recorded lectures right after class because it helps with scheduling. More frequent communications would also be beneficial to stay in the loop and get to know the professor. Yes Slack Yes
Good Junior Yes New York In the US, but not in Rochester Yes Marketing No Beauty and Cosmetics L'Oreal Marketing Manager No No TikTok Spotify No Boxing, film, and reading I listened to music, read, and watched Tim Burton movies Yes No 4 1 Never Online No I don't think we should use a discussion board Yes
Good Sophomore No China In China 12 Yes Accounting Yes Banker Investor Yes Business School in American No Google Netease Cloud Music No Drawing and Design Got my driver license No Yes 4 1 Never Online Making the quality of recorded video better. No I don't think we should use a discussion board No
Good Sophomore No Canada In China 12 Yes Business Analytics No Bank Some job working at the bank Yes Harvard Yes Java Mcdonalds Spotify Yes Basketball Helping poor kids No Yes 4 4 Rarely Online Yes Blackboard Yes
Good Sophomore No China In China 12 Yes Marketing No I would like to have my own business, probably the estate industry. Marketing manager Not sure I would like to go to a Business school like Simon. No Apple Spotify Yes Traveling and listening to music I set up my own shop. Yes Yes 5 0 Never Like both roughly the same Maybe add some more discussion. Yes Blackboard Yes
Good Junior No China In China 12 Yes Finance STT No Finance Analyst Yes Normal university No Sorry, I don't have a favorite company right now Apple Music No Stay at home No Yes 4 0 Like both roughly the same Everything is great right now Yes Blackboard Yes
Very Good Senior No Vietnam Vietnam 11 Yes Finance ECO No No No Blackstone Spotify Yes Yes No 5 2 Never Online Yes Blackboard
Good Senior Yes Rhode Island In Rochester, but off campus Yes Accounting No Accounting Forensic Accountant Yes Master's No McDonald's Spotify Yes Golf, hiking, listening to music, betting on sports The hobbies listed above Yes Yes I interned at a CPA firm this summer that was <1 year old 5 2 Some of the time Online Actively engage students in ways that aren't discussion based. I like the use of polls No I don't think we should use a discussion board Yes
Fair Sophomore No Vietnam On campus Yes Finance CSC Yes FinTech and/or Investment/ Real Estate Something to do with Finance and Technology (Hence the 2nd major). Not sure Yes I'm currently learning Java Tesla Spotify No Music and Fashion I have a summer internship with KPMG in Vietnam, got to hang out sometimes with friends (things were quite normal then in Vietnam; there had been no new COVID-19 cases for a few months) No Yes 6 2 All of the time Like both roughly the same Hand out more materials. This is because teaching online gives students more flexibility to learn with their own methods, which might be more efficient if they have more materials to study from. No I don't think we should use a discussion board Yes
Very Good Senior Yes Alabama In the US, but not in Rochester 1 Yes Business Analytics Yes Environmental Economics/Big Data A Policymaking Economist No Yes Python Memphis Meats Spotify No Music production, woodworking, poetry I have worked a lot (construction), figured out how to socialize purely online, and kept my apartment the cleanest it has ever been or will be No Yes 4 2 Never Online This class' blackboard page is honestly the example I'd like to see used. I'm in another class that is an absolute labyrinth of nested modules and pages to get to new assignments and even then they're not always posted where one would expect. No I don't think we should use a discussion board Yes
Fair Junior No somewhere in a galaxy far far away Yes Finance Yes fund manager Not sure No Spotify Yes No Yes 4 0 Like both roughly the same No I don't think we should use a discussion board
Good Junior No California China In China 12 Yes Business Analytics No Investment Banking Amazon CEO No Yes Python Apple Wangyi Yes Tennis, Video Games Video Games, watching TV shows No Yes 4 2 Never Like both roughly the same More interaction, that's why CIS220 is better. Yes Blackboard Yes
Fair Junior No China In China 12 Yes Business Analytics MTH No Technology Not sure Yes python Apple Apple Music No Oil Painting Internship No Yes 5 2 Never Online Remember to share their screens Yes Blackboard No
Very Good Junior No China In China 12 Yes Finance Yes Finance, fund companies maybe Music business industry Yes Business No Airbnb Apple Music No Music, singing, traveling Doing interns No Yes 5 1 Never Online Make notes clearly to let students see Yes Blackboard Yes
Excellent Junior No China In Rochester, but off campus Yes Business Analytics CSC No Tech industry start my own business and be my own boss. But before that, product manager in tech or gaming industry No Yes Python Apple Spotify No cycling, outing, reading maps, listening to music Have been learning Unreal Engine 4 to develop my own game No Yes 5 2 Some of the time Hybrid I really like the break out rooms to discuss problem with other students in class Yes Blackboard Yes
Fair Junior Yes California On campus Yes Doing the BA, so no track CSC No Software Engineering Software Engineer at Google Yes One focused around computer science Yes Java Microsoft Spotify Yes Swimming and playing video games Swimming and playing video games No Yes 4 2 Most of the time Like both roughly the same Provide more examples to exercise problems to read that is relevant to tests or homework. Yes Blackboard Yes
Good Sophomore Yes NY In the US, but not in Rochester Yes Business Analytics SART Yes Art Yes No Spotify Yes No No 1 Never Like both roughly the same No I don't think we should use a discussion board Yes
Poor Sophomore No Canada Republic of Korea 13 No ECO Yes accounting accountant No No Deloitte none Yes sleeping when I can studying No Yes 4 0 Online more exam-focused Yes Blackboard Yes
Good Junior No China In Rochester, but off campus Yes Marketing No Glasses A entrepreneur Not sure No Alibaba Apple Music No Playing pingpong ball I am full time student No Yes 5 1 Some of the time Online A good notes and microphone Yes Blackboard No
Fair e5 Yes NY N/A In Rochester, but off campus 0 Yes Finance N/A N/A Yes Investment Banking CEO Not sure N/A Yes HTML Apple Spotify No Hiking reading traveling sightseeing Find more hobbies. No Yes N/A 6 1 Never Online Better mic Yes Blackboard Yes
Good Junior Yes Pennsylvania On campus Yes Finance MKT Yes Banking CFO at Goldman Sachs Not sure No J.P. Morgan Chase Apple Music Yes Xbox, sleep, basketball, boxing Sleep and collect unemployment No Yes 4 0 Hybrid Have tests follow the lectures/powerpoints Yes Blackboard Yes
Fair Junior No No China In Rochester, but off campus No DSC DMS No IT Program designer Not sure Yes Python Apple Spotify Yes Poker, Guitar internship No Yes 4 4 Some of the time Hybrid More contact with students Yes Blackboard Yes
Good Senior Yes New York On campus Yes Doing the BA, so no track DSC No Fintech Data Scientist No Yes Python Nike Spotify Yes Play basketball, go on runs and hikes Work for admissions office, apply for jobs No Yes 4 1 All of the time Hybrid Have all information during lectures be accessible in some readable way - i.e. complete powerpoint slides No I don't think we should use a discussion board No
Good Junior Yes New York In Rochester, but off campus Yes Doing the BA, so no track DSC Yes Data Analytics Data Analyst Not sure Yes Python IBM Spotify Yes Day Trading and Running Started day trading and running No Yes 5 1 Never Online More engagement No I don't think we should use a discussion board Yes
Excellent Junior Yes CA United States On campus Yes Finance No finance investor Yes mba, ms finance or ms real estate No tesla Apple Music Yes poker, drinking, stocks, lifting trade futures Yes Yes 4 2 Rarely Online No I don't think we should use a discussion board No
Good Sophomore Yes New York On campus Yes Business Analytics Financial Econ (couldn't find the character code) No Hedge Funds Hedge Fund Founder/CIO No Yes Java Patagonia Spotify Yes Hockey, Skiing, Investing Internship at Investment Bank, reading, hockey No Yes 4 3 Most of the time Like both roughly the same Just regularly check the chat because some teachers don't and will go 30 minutes without answering questions or realize there is a problem with the stream. No I don't think we should use a discussion board Yes
Good Junior Yes New York On campus Yes Business Analytics STT No Financial Industry Not sure Yes SQL Spotify No Dancing, Hiking Joined a bunch of new organizations on campus No No 4 1 All of the time Hybrid In general, just engaging students more over Zoom instead of just talking at them for over an hour. Yes Blackboard Yes
Excellent Sophomore Yes CALIFORNIA In the US, but not in Rochester 3 Yes Finance STT No Investment Financial Analyst No No Goldman Sachs Spotify Yes Playing games and basketball Exercise, spending more time babysitting my little sister No No 4 1 Never Hybrid He is doing great so far so I don't think there is any need for improment now Yes Blackboard Yes
Excellent Junior Yes Washington On campus Yes Accounting No Business Upper-level management Not sure No Nike Apple Music No Baseball and golf baseball, workout and golf No Yes 4 2 Most of the time Hybrid Yes Blackboard Yes
Good First Year No CA China On campus Yes Finance ECO No Sports industry or finance Sports Manager Yes Sports Management or Finance No Nvidia Spotify No workout, watching ports, gaming, wood crafting Tried to teach myself Python, and DJing. Yes Yes Stir-fry machine, self cooking pot 4 0 Hybrid Engaging with students, class discussion Yes Discord Yes
Good Junior No China In Rochester, but off campus Yes Accounting No Corporate Management Actuary Yes Simon, 4+1 MSA program No lockheed martin Spotify Yes Golf & race daydream No Yes 5 4 All of the time Like both roughly the same No Yes
Sophomore Yes New York On campus Yes No Entertainment CEO Not sure No N/A Spotify No Sports, exercising, and music Apply for internships, learn some stock market fundamentals No Yes 4 1 Some of the time Hybrid Implement more discussion or interactive elements into the classes Yes Blackboard Yes
Fair First Year Yes New York In the US, but not in Rochester Yes Finance Yes Banking Financial analyst No No JPMorgan Chase YouTube Music No reading, cooking, exercising, surfing the web exercising No Yes 4 0 Hybrid Add supplemental videos and articles to lectures Yes Blackboard Yes
Good Sophomore Yes Idaho In the US, but not in Rochester 2 Yes Doing the BA, so no track BCS Yes Artificial Intelligence Fashion Designer Not sure Python Apple Spotify Yes Art, Photography, Skateboard, Soccer, Tennis Started investing, working as a server, learning how to skateboard No Yes 5 1 Never Online I think it's not to bad so far. No I don't think we should use a discussion board Yes
Very Good Senior Yes New York In the US, but not in Rochester Yes Marketing PSY Yes No Yes Python Apple Spotify No Learned the guitar after 11 years of having one No Yes 6 1 Never Online Yes
Very Good Senior Yes Florida In Rochester, but off campus No DSC Yes Video Games Industry Esports Data Scientist No Yes Python Cloud9 Spotify No Golf, Video Games, Chess Learn to play chess No Yes 4 1 Rarely Like both roughly the same More use of breakout rooms No I don't think we should use a discussion board No
Good Junior No Malaysia Malaysia 12 Yes Finance PSY Yes Consulting No No Spotify No Running, Playing Piano Baking! No No 4 1 Never Online Send out administrative updates for the class via email (e.g remember we have this assignment due soon, we are covering this this week, exam is coming soon etc.) No No
Good Senior No Vietnam On campus Yes Business Analytics STT Yes Media Analyst No Yes R Apple Apple Music No Cooking Exercising No Yes 4 2 Some of the time Like both roughly the same Give more polls, tell a little bit about yourself on a weekly basis No I don't think we should use a discussion board Yes
Good Sophomore No Viet Nam Viet Nam 11 Yes Finance Yes finance - related, not too sure about the specifics N/A Not sure No N/A Spotify No Travelling, also love ziplining and high ropes course Internship in my home country and lots of travelling since it's pretty much no corona here Yes Yes not currently but I used to work for a start-up in the education industry 4 1 Online Actively engage with students in class and provide necessary help when needed Yes Blackboard Yes
Excellent First Year No China In China 12 Yes Finance No Investment A trader, or work with level 1 market that help business to IPO No No Google Spotify Yes Music, video games try to make money, and failed No Yes will join my dad's business soon 4 4 Never Online CIS 220 is pretty decent already. But writing down key points(by you) would help, since it's harder for being focused all the time for online classes. No I don't think we should use a discussion board No
Fair Junior No China In China 15 Yes Accounting SA No Business CFO or CEO Yes Business school No Alibaba NetEase Music hiking read books No Yes 6 5 Never Online Maybe let the students start the exam anytime between 8am-8pm. No Yes
Fair Sophomore No China In China 12 Yes Marketing DMS Yes Marketing, digital media and advertisement. Advertisement Not sure Yes Python and dart Samsung Spotify No Band, soccer Our band released an album, and I learnt Python by myself. No No 5 0 Never Online Having clear schedules are good enough for me. Yes Blackboard Yes
Excellent Junior No South Korea Seoul 14 Yes Entrepreneurship No Education Building Owner Not sure No Nike Youtube music No Working out Diet No Yes 5 2 Some of the time Like both roughly the same Update audio quality Yes Blackboard Yes
Good Sophomore No China In China 12 Yes Marketing STT Yes marketing Not sure No Amazon WangYiYun No dancing nothing No Yes 4 2 Never Hybrid No No
Good Sophomore No china In China 12 Yes Business Analytics DSC No investment bank Yes data science Yes python Hillhouse Capital Group Spotify Yes making money sleeping No Yes 4 2 Never Online less homework No I don't think we should use a discussion board No
Good Senior No China In China 12 Yes Finance MTH Yes Investment Professional Traveler Yes Business School No Alibaba QQ Music Yes Reading, Cooking, Photograghing, Diving, Ski, Violin, Ping-Pong, Travel, any adventure activity 5 books and met many new friends No Yes 4 1 Never Hybrid nope, already good No I don't think we should use a discussion board Yes
Fair Sophomore No China In China 12 Yes Business Analytics DMS No business or investing consulting Yes business school Yes python google wangyiyun No dancing internship in a bank Yes Yes 4 0 Like both roughly the same I feel its good enough so far No I don't think we should use a discussion board Yes
Fair Sophomore No China In China 12 Yes Marketing Yes Marketing, FMCG Marketer Not sure No PepsiCo Spotify Yes Soccer, movies Internship in PepsiCo Shanghai Yes Yes 4 0 Rarely Online Yes Blackboard Yes
Very Good Sophomore Yes Hawaii On campus Yes Finance No Finance Investment Banking No No The Coca-Cola Company Soundcloud Yes Painting, body boarding, hiking Read No Yes 5 3 Never Online Keep the class interactive with cameras and quizzes Yes Blackboard No
Good Junior Yes New Mexico On campus Yes Finance ECO No Unsure Chief economist at a fortune 500 company Not sure No Google Spotify Yes Flying (Private aviation), movies, hiking, basketball, soccer I took the time to learn about the stock market and investing No Yes 4 1 Rarely Hybrid Make assignments very visable in the online course module Yes Yellowdig Yes
Good Sophomore Yes New York In the US, but not in Rochester Yes Entrepreneurship DSC Yes Data Analytics High-level Executive position Not sure Yes Java Porsche Apple Music No Working on cars, cooking, filming Working out, Cooking, Film Yes Yes 5 5 Never Like both roughly the same Make materials accessible, and provide plenty of materials for practice No I don't think we should use a discussion board Yes
Fair Sophomore No China In Rochester, but off campus Yes Finance DSC No Law Corporate/Contract Law Yes Law School Yes R and Java Google Amazon Music Yes Car Enthusiasts Learn a new skill No Yes 4 1 Rarely Online Since it is hard for students to ask questions right after class, I think a faster email response time would help in answering questions No Yes
Excellent Senior No 10 Yes Business Analytics CSC Yes Private Equity/Asset Management Not sure Yes Python Pioneer Spotify No No Yes 6 1 Never Online Yes Slack/Piazza Yes
Good Junior Yes Colorado In Rochester, but off campus No Csc Yes Software Software developer No Yes Python Google Spotify No Golf Golf No No 4 0 Online No I don't think we should use a discussion board No
Good Sophomore No China On campus Yes Finance IRL Yes Academia in economics, finance, or accounting Professor Yes PhD or pre-doctoral program Yes Python Y Combinator I do not pay for music, I listen to music via YouTube Yes Badminton, basketball, hiking. Auditing internship No No 5 3 Most of the time Hybrid Organize after-class activities with students. No I don't think we should use a discussion board Yes
Very Good Senior Yes Massachusetts In Rochester, but off campus Yes Finance Yes Quantitative Hedge Funds CIO No Yes Python, MQL5 Neuralink Spotify Yes Developing automated currency futures trading algorithms, podcasts, mycology The above hobbies Yes Yes Private Equity Fund 4 1 Never Online No attendance No I don't think we should use a discussion board No
Good Senior Yes New Jersey United States On campus Yes Doing the BA, so no track ME Yes Automotive Automotive Engineer Yes Automotive Engineering Yes Python Tesla Apple Music Yes Music, Stock Investing Swing trade stock options Yes 6 4 Some of the time Like both roughly the same Engage with students outside of class Yes Microsoft Teams Yes
Fair Sophomore No China In China 12 Yes Business Analytics CSC Yes finance CEO Yes High ranked Yes JAVA Xiaomi Netease Yes computer games Quarantine No Yes 6 2 Never Online I think it is good enough now No I don't think we should use a discussion board No
Very Good Junior No china In China 12 Yes Finance Yes investment bank financial consultant Yes harvard No Blackstone Spotify Yes music/boxing/piano/speech.. I wrote an essay to illustrate how different countries react to Covid No Yes 4 4 Never Online I think it is good right now No I don't think we should use a discussion board Yes
Good Senior No Indonesia Indonesia 12 Yes Finance DSC No Consultant Consultant No Python BCG Spotify Yes Baking Baking Yes Yes Digital marketting 5 5 Rarely Hybrid All is good Yes Blackboard Yes

Answers

Note that it is very important when counting to count a field that has data for every record, e.g., Bus Major.
There should be a separate worksheet for each question showing how you came up with the answers below.
See Question 0 for an example.
Question 0: What year has the most students and how many students does it have?
Answer: Junior, 66
Question 1: For students majoring in business, what is the most popular track and how many have chosen that track?
Answer:
Question 2: Besides "Python" with 37, how many other unique answers (rows of the pivot table) have the word “Python” in upper or lower case in them?
Answer:
Question 3: What Industry is most popular?
Answer:
How many other pivot table rows have an answer that starts with the same first three letters as the most popular industry?
Answer:
Question 4: What percent of the class is planning to go to grad school when they graduate?
Answer:
Question 5: What percent of the class would like a CIS 220 Happy Hour?
Answer:
What percent of the class currently living in the US would?
Answer:
Question 6: Play with the dataset and tell me something else interesting you learned.
Answer:

Question 0

Row Labels Count of Year
e5 4
First Year 5
Junior 66
Senior 26
Sophomore 29
Grand Total 130