![\"\"](\"https:\/\/wordpress-projects.wolfware.ncsu.edu\/ncsuereseng\/wp-content\/uploads\/sites\/389\/2025\/06\/e-REF-Logo-V-2-12.png\"){kind=logo}
<\/figure>\n\n\n\nOverview<\/h2>\n<\/div>\n\n\n\n\nNavigation<\/strong><\/p>\n\n\n\n\n- Downloading Datasets<\/a><\/li>\n\n\n\n
- Datacleaning in Spreadsheet Softwares<\/a><\/li>\n\n\n\n
- Exploratory Data Analysis<\/a><\/li>\n\n\n\n
- Python<\/a><\/li>\n<\/ul>\n<\/div>\n<\/div>\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
Manipulating datasets in spreadsheet software is essential for transforming raw data into actionable insights. It supports informed decision-making, improves efficiency through automation, organizes data for clarity, and uncovers trends for problem-solving. Spreadsheet manipulation enhances communication by making visualizations and summaries more interpretable. Spreadsheet\u2019s versatility across industries highlights their critical role in ensuring accurate analysis and better outcomes.<\/p>\n\n\n\n
<\/div>\n\n\n\nLearning Outcomes<\/h2>\n\n\n\n\n- Modify open access data <\/strong>in spreadsheet softwares for data evaluation<\/li>\n\n\n\n
- Prepare the dataset content<\/strong> in spreadsheet softwares for data visualization<\/li>\n\n\n\n
- Present preliminary relationships<\/strong> with the data using spreadsheet softwares<\/li>\n<\/ul>\n\n\n\n<\/div>\n\n\n\n
Downloading Datasets<\/h2>\n\n\n\n<\/div>\n\n\n\n
\n\n\n\nA common access point for large datasets is an online database. Often, an online database will provide a search interface that allows users to filter a dataset and access or download only the data they need for their research. <\/p>\n\n\n\n
Download one or more of the datasets below in order to become familiar with the process.<\/p>\n\n\n\n
<\/div>\n\n\n\nElectric vehicle population data: <\/strong>https:\/\/catalog.data.gov\/dataset\/electric-vehicle-population-data<\/a><\/p>\n\n\n\nEnergy Hourly consumption data:<\/strong> https:\/\/www.kaggle.com\/datasets\/robikscube\/hourly-energy-consumption<\/a><\/p>\n\n\n\nGreenhouse gas emissions data: <\/strong>https:\/\/www.kaggle.com\/datasets\/unitednations\/international-greenhouse-gas-emissions<\/a><\/p>\n\n\n\n
Navigation<\/strong><\/p>\n\n\n\n Manipulating datasets in spreadsheet software is essential for transforming raw data into actionable insights. It supports informed decision-making, improves efficiency through automation, organizes data for clarity, and uncovers trends for problem-solving. Spreadsheet manipulation enhances communication by making visualizations and summaries more interpretable. Spreadsheet\u2019s versatility across industries highlights their critical role in ensuring accurate analysis and better outcomes.<\/p>\n\n\n\n A common access point for large datasets is an online database. Often, an online database will provide a search interface that allows users to filter a dataset and access or download only the data they need for their research. <\/p>\n\n\n\n Download one or more of the datasets below in order to become familiar with the process.<\/p>\n\n\n\n Electric vehicle population data: <\/strong>https:\/\/catalog.data.gov\/dataset\/electric-vehicle-population-data<\/a><\/p>\n\n\n\n Energy Hourly consumption data:<\/strong> https:\/\/www.kaggle.com\/datasets\/robikscube\/hourly-energy-consumption<\/a><\/p>\n\n\n\n Greenhouse gas emissions data: <\/strong>https:\/\/www.kaggle.com\/datasets\/unitednations\/international-greenhouse-gas-emissions<\/a><\/p>\n\n\n\n\n
\n\n\n\nSummary<\/h2>\n\n\n\n
Learning Outcomes<\/h2>\n\n\n\n
\n
Downloading Datasets<\/h2>\n\n\n\n
\n\n\n\n