Spreadsheet application class – census project 1 – due 10/3
Please see below and attached census spreadsheet/reflection assignment details and templates. Please be sure to use APA format and citations.
Part A – Census Spreadsheet
1. Create a new workbook and save it as Project1_Census.xlsx.
2. Identify three U.S. cities of your choice and enter the city and state names in cells A4, A5, and A6.
3. Open a web browser and navigate to the factfinder.census.gov website. Use the most recent census data to locate the population, median age, number of housing units, and median income for each city.
4. Enter the information into the respective cells in the worksheet, as shown in the image below but using cities of your own choosing. Note: If you are unable to locate the necessary data, either choose a different city or perform a search for another website containing the necessary data.
Part B – Reflection
a. Describe a situation in daily life when someone would use Microsoft Excel.
b. You made several decisions while creating the workbook for this assignment: how to lay out the data in the worksheet and which chart types to use. What was the rationale behind each of these decisions?
c. What issues or challenges did you face completing this project?