Excel project This unique project will meet the needs of the students’ individual interests The requirements include curating or creating sample data to demonstrate effectiveness of the well-designed Excel project. The project should have purpose to the student and utilize key elements that highlight data effectively. Leveraging conditional formatting, data validation, template design, macros for automation, dynamic pivot tables and charts to showcase data in a dashboard format. Students can link to external data and analyze the information depending on their level of curiosity. A good example of data, presented in a dashboard format is featured in the following: https://powerbi.microsoft.com Students are not expected to master so complicated an information display as the Microsoft Business Intelligence Demo but, it leaves quite a favorable impression on a business audience. • Each element will be assessed for completeness, efficiency, and visual clarity as well as the ability to scale and stay dynamic. Points will also be given for originality and creativity. The breakdown for this grading will follow the final presentation rubric. Final Project Data Step 1 SHOW INSTRUCTOR THE DATA Pick a topic that you would like to research and find out more information by analyzing a specific data set in that area. Begin preliminary research to see if you can find data that you have access to and would be able to work with in Excel. Final Project Data Step 2 Now that you have an idea of what you want to pursue, make sure you have data that you can work with. Consider assembling four, or five charts in a "Data Dashboard" type display. You may recall the classroom example of "Business Intelligence Tools" from Microsoft: https://powerbi.microsoft.com/ No one can duplicate the very busy "Data Dashboard" on the website but, it can be fun and educational to develop our own display/dashboard of Charts! Many Students in the past have used the following sites with good results: https://catalog.data.gov/dataset http://education.state.mn.us/MDE/Data/ The librarians can help you out as well. If you can't meet with one here are some detailed steps to follow. http://research.library.gsu.edu/c.php?g=115466&p=4929607 1. Government and political data Data.gov: This is the go-to resource for government-related data. It claims to have up to 400,000 data sets, both raw data and geo spatial, in a variety of formats. The only caveat in using the data sets is you have to make sure you clean them, since many have missing values and characters. Socrata is another good place to explore government-related data. One great thing about Socrata is they have some visualization tools that make exploring the data easier. City-specific government data: Some cities have their own data portals setup to browse through city-related data. For example, at San Francisco Data you can browse through everything from crime statistics to parking spot available in the city. The UN and UN-related sites like UNICEF and the World Health Organization are rich with all kinds of data, from mortality rates to world hunger statistics. The Census Bureau houses a ton of information about our lives around income, race, education, population and business. 2. Data aggregators These are the places that house data from all kinds of sources. Sometimes it’s easier to find something here related to a specific category. Programmable Web: A really useful resource to explore API’s and also mashups of different API’s. Infochimps have a data marketplace that offers thousands of public and propietary data sets for download and API access, in a wide range of categories, from historical Twitter and OK Cupid data, to geo locations data, in different formats. You can even upload you own data if you like. Data Market is a good place to explore data related to economics, healthcare, food and agriculture, and the automotive industry. Google Public data explorer houses a lot of data from world development indicators, OECD and human development indicators, mostly related to economics data and the world. Junar is a great data scraping service that also houses data feeds. Buzzdata is a social data sharing service that allows you to upload your own data and connect and follow others who are uploading their own data. 3. Social data Usually, the best place to get social data for an API is the site itself: Instagram, GetGlue, Foursquare, pretty much all social media sites have their own API’s. Here are more details on the most popular ones. Twitter: Access to the Twitter API for historical uses is fairly limited, to 3200 tweets. For more, check out PeopleBrowsr, Gnip (also offers historical access to the WP Automattic data feed), DataSift, Infochimps, Topsy. Foursquare: They have their own API and you can get it through Infochimps, as well. Facebook: The Facebook graph API is the best resource for Facebook. Face.com: A great tool for facial recognition data. 4. Weather data Wunderground has detailed weather information and also let’s you search historical data by zip code or city. It gives temperature, wind, precipitation and hourly observations for that day. Weatherbase has detailed weather stats on temperature, rain and humidity of nearly 27,000 cities. 5. Sports data These three sites have comprehensive information on teams, players coaches and leaders by season. Football Baseball Basketball ESPN recently came up with its own API, too. You have to be a partner to get access to their data. 6. Universities and research Searching the work of academics who specialize in a particular area is always a great place to find some interesting data. If you come across specific data that you would like to use, say, in a research paper, the best way to go is to contact the professor directly. (That is how we got the data for our What are the Odds piece, which is one of the most-viewed infographics on the web.) One university that makes some of the datasets used in its courses publicly available is UCLA. 7. News data The New York Times has a great API and a really good explorer to access any article in the publication. The data is returned in json format. The Guardian Data Blog regularly posts visualizations and makes data available through a Google docs format. The great thing about this is that that the data has already been cleaned. Rubric for submitted Projects. NOTE: Final Project Points changed to 450 Points possible; 50 Points possible for First Draft. RC Demonstration Rubric Levels of Achievement Criteria: Organization Weight 33.00% Novice 0% Did not submit project Appropriate 0% Terminology Did not submit project Weight 34.00% Not Competent Some Effort Somewhat Proficient Proficient 25% 50% 75% 90 – 100% Jumps around various steps, no perceived outline being followed, no introduction or summary. Not following a coherent or logical plan. Made effort to produce correct letter or project but, In incorrect order or not following any discernable business rules Demonstrates majority of directions followed, shows good effort to complete correctly but, omits some transitional steps or jumps toward conclusion. May not have correct letter format or correct data file included. Contains evidence of necessary step completion, directions carefully followed, logical flow including every necessary step of the process. Includes detailed intro and summary of steps taken which leave the audience with few questions. Logical flow is in evidence. 25% 50% 75% 90 - 100% Uses some of own terminology or unrecognized incorrect terms Uses non-standard letter format and/or nonstandard data file. Some mistakes on terminology but, still understandable with some effort and examination by the audience. Uses consistent and appropriate terminology for steps taken. Descriptions are accurate and match what the audience sees when viewing the Pivot Table/Chart. Unusual or not readily available format. Accuracy 0% 25% 50% 75% 90 - 100% Weight 33.00% Did not submit project. Missed Project First Draft or Final Deadline. Steps do not reproduce data file or display correctly or be readily interpretable by a business audience. Does not display in understandable form as demonstrated in class. Steps do not reproduce the results shown in the Answer Key or in-class examples of successful Projects. Minor changes needed to get the results displayed in demonstration. May be partially formatted or incorrectly formatted but, results and intentions are understandable. Easily understandable results and conclusions formatted and display correctly. File will open and display on multiple devices. Project Presentation
Purchase answer to see full attachment