Data Sets

THIS ASSIGNEMENT IS THE CONTINUATION OF ATTACHED ASSIGNMENT BELOW NAMED: MY Final Project Proposal Continue this workbook. TELL A STORY OF THE DATA SET INFORMATION IN ATTACHED WORKBOOK ABOUT Contiguous U.S. June – August Average Temperature Anomaly (degrees F)

Final Project Content 

At this point, students will present a “work-in-progress draft.” Excel workbook that should consists of a tab (with some data, not all data at this stage) for each of the following:  

-All data – best displayed as Excel Spreadsheets making up ONE Excel Woorkbook. 

-PIVOT Table Pivot Charts/Graphs (3-5) 

-Data Dashboard – best example is Business Intelligence Tools : https://powerbi.microsoft.com/en-us/ 

-A form with Lookup Functions – these may be live clicks or hyperlinks to other data, other spreadsheets, etc. 

-At least one MACRO function – a basic MACRO function may be a “button” that brings the discussion to another data page or source.

This “Rough Draft” is recognizably a work-in-progress – a presentation that helps organize and work toward the final presentation. The Excel workbook will be used as the base to build your presentation. You will use it as a basis to tell a story about your data.  I INCLUDED AN EXAMPLE OF ANOTHER CLASSMATES: Final Project proposal example.

Potential Outline for the Presentation:

-Cover Slide Agenda Slide (table of contents if you will – what will you be discussing?)

-One slide for each visualization/lookup function, macro, etc… (Approximately 12-15) 

-Closing slide (wrap up your presentation, tell them what you told them, and discuss any future potential data analysis that may develop from this presentation. 

-Questions slide (Any questions? Provide contact info for those viewing the presentation later) 

-References slide (List in APA format – at least 4-5 scholarly references, one should be your textbook)