DAT-102: Introduction to Data Analytics (Fall 2021)

Step 1: Brainstorm a strip survey

Please develop a "strip survey" containing a categorical question and a opinion/spectrum question. Compose the tiny survey in a text document have your document handy when class starts. DO NOT adminster the survey to anybody. No need to up load it; we'll do it in class.

Step 2:

We'll be using google drive for sharing work. Please prepare to share a google account address with us next week. If you'd like to make an anonymous account for use in this class, you've got a week to do so.

TODO for Fall 2021

Create your template response in your google drive directory by Thursday, 16-SEP'21 at midnight

Complete ALL peer surveys by Monday, 20-SEP at Midnight

1. Log into your google account registered with Eric. Nav to drive.google.com
2. Click: shared with me and find the DAT102_fa21_masterShared directory
3. Then enter the directory: fa21_stripSurveys
4. Make a new folder whose name is your firstName_surveyTopic
5. Inside your subdirectory, create two more folders: 1) folder called "Admin" to store your template and analysis. 2) Folder called completed surveys
6. Inside your survey subdir make a template drawing: Click New >> More >> Google Drawings
7. Use the drawing tools (the text box tool, and the line drawing tool on the toolbar) to create your cateegorical question and your spectrum question. For the spectrum question create a horizontal line and label the end points with extreme values.
8. When you template is solid, right click in the drive >> Make A copy. Now that you have one copy, move your template to admin by clicking and dragging.
9. Duplicate your remaining drawing 23 times, once for each peer. Hint: you can hold down shift and select multiple drawings. You can "right click the entire list >> Make a copy" and this will multiply your copying rate.
10. The files probably have "copy of copy of..." at the start. Clean these up by right clicking >> rename and give each copy a unique ID number of your choosing. Could just be 1, 2, 3, 4, etc.
11. Double check you've got a folder called "completed surveys"
12. By Monday 20-SEP'21 @ midnight please have submitted responses for each of your peer's strip surveys in their respective directories. ALSO: take your own survey!!!
13. No need to do any entering of data into a spreadsheet until next week, as we'll do a brief overview of spreadsheet functionality in class.

For next week

1. Create a new spreadsheet in admin folder, name it without spaces in the ttle
2. Create a sheet (i.e. tab) for your raw data table, and a sheet for your data dictionary. Use Eric's sample inside his PAUL+LORETTA
3. Populate your raw data table sheet with responses from your peer surveys. Assume all folks have taken the surveys that want to by Midnight Tuesday
4. Remember to not pollute your columns with asymmetric data. Example: if your column is storing distances from left margin as a number, don't break the pattern and put a text note in a cell in that column. Keep the data values the same type in each column.

Wrap a bow on strip survey

1. Create a table in your analysis spreadsheet that summarizes the behavior of your unsliced quantitative variable (your spectrum percent) through its center (mean), spread (standard deviation), and box plot figures (median, q1, q4, min, max, and outliers).
2. Repeat the process of quantitative descriptions for any sliced groups (collapsing responses as you see fit)
3. Using your assemble data, respond to the following analysis question in large text in your spreadsheet: How do the responses to your spectrum question differ across sub-groups of our class (i.e. when sliced with your categorical responses)? To what degree do the data show these groups are distinct in their opinions about the topic at hand?
4. Transfer statistics and compute needed values for your record in our master tracker spreadsheet's strip survey tab. Feel free to try all columns, but only columns D-P are targeted for completion this week.

Task 1: Strip Survey Analysis

Please populate column D - P in our 'Strip_Survey' tab of our master tracker and please attempt Q through W which are based on standard deviation and box plot comparisons.

Complete all columns of analytics for your strip survey, including the beefy final column comparing your sliced groups.

Complete Column X in master tracker for strip survey

Wrap a bow on your strip survey analysis by writing a comparison of your sliced groups in column X of the master tracker's strip survey sheet (aka Tab)

Step 1: Study AJPH Articles from last week's homework and Prepare for socrative quiz on conf intervals

Step 2: Populate our master tracker Library_sampling sheet with your library data

Step 3: Familiarize yourself with American factfinder for next week's worktime and propse soe variables of interest to you

Start thinking about your final project

Begin final project

OPTIONAL Out of class:

Digest PGH Inquality report

Due to COVID-19 reorganiation, we will be unable to discuss the data and the sociology behind Pittsburgh's Inequality Across Gender and Race Report issued by the Pittsburgh Gender Equity Commission. As you desire, please engage with the report on your own and with others in your various circles. These discussion questions may be a guide for your discussion:

1. Review the study's aggregation of smaller racial subcategories into the "AMLON" category. What are the advantages of this statistical approach? Its limitations? Would there be other ways to aggregation races into smaller categries?
2. Review the Report's focus areas in the section called "Cultivating Livability." Which of these priorities do you believe are most salient at this time in Pittsburgh? Most data-based? Least data-based?
3. Carefully study the comparison methodology in Appendix A. Develop a thoughtful opinion of the author's assertion on page 72, third paragrah which starts: "When outcomes, like grade reten tion rates, are similar across cities they are likely to be driven more by national policies and factors...". Can you think of any indicator patterns which do not exhibit this behavior?

Undertake and document your final project for sharing next week. Create a sub-folder with your first name and your topic of study inside the directory in our shared drive called dat102_sp21_finalProjects

CCAC Requires final grades to be submitted to the Database by 10:00 am on 22-DEC'21; Please finish any mop up stuff by 0900h on this date. Please RING Eric at 412.894.3020 if you're submitting close to this absolute deadline to make sure your work gets reviewed.