This week you’re working with your discussion group!
To give you all time to work with your discussion groups, I have cleared this week’s schedule to give you time to read, meet, and record your discussion starter.
This week we will
- Learn some basics about data and spreadsheets
- Work with our discussion groups
Start | Meet | Post |
Feb 8 | Feb 10 | Feb 12 |
Module Outline
- Module Outline
- Tasks
- Wednesday agenda
- Reading
- Lesson: Data Filtering
- Assignment: Working with Data
- Discussion Starters
Tasks
You have two sets of tasks this week. For your discussion starter you should:
- See my overview email for this week if you missed it
- Read all the materials in your team’s assigned module
- Coordinate a time to meet via Zoom or other means to record a discussion with your team
- Record your team’s discussion (details below)
- One person should share (via email or a shareable link) the recording with me by 11:59PM Saturday February 13 this week so that I can post all the discussion starters for upcoming weeks
To get us started learning some data basics, you should:
- Do the Working with Data assignment
Wednesday agenda
At Wednesday’s optional meeting, we’ll troubleshoot the Working with Data assignment and any issues or questions with the Discussion Starter video/audio assignment.
Reading
There is no assigned reading this week. Consult the discussion roster for your assigned week and read/watch/listen to all of the material for your assigned week.
Lesson: Data Filtering
Your first step in working with new data is getting to know it.
Assignment: Working with Data
In this assignment we’ll start learning how to read and work with data. For this assignment you’ll need to be logged into a Google account and be prepared to suffer through some 8th grade algebra.
Open this spreadsheet of Sir William Johnson’s expenses during the Seven Years’ War. Johnson was the British Superintendant of Indian Affairs for what is now New York in the 1750s and 1760s, and we’ll be working with his list of expenses for Indian diplomacy. Read through the spreadsheet before beginning the assignment to get a basic idea of the kinds of things you’ll be dealing with. The items Johnson listed were expenses he sought reimbursement for from the British government; think of it as an itemized credit card bill. These expenses were tracked in pounds sterling; on the spreadsheet I’ve split the expenses into pre-decimalized pounds, shillings, and pence (think of this as one column for dollars and one for cents).
Start with the first sheet, “1: Basic Functions.” Then watch the video below to walk through the assignment. The slides here are the same as the slides shown in the video for your reference (the links are clickable and the text is selectable)
When you’re done with this assignment, comment below with a link to your spreadsheet! Remember to use the skills from our HTML assignment to make <a href=””>a pretty link!</a>
Below are some helpful hotkeys that will make your life easier working with spreadsheets. If you’re on Mac, Cmd is the Command button to either side of the space bar; if you’re on PC, use the Control button in place of command. Any capital letter is the letter key on your keyboard; anything connected by dashes should be depressed all at the same time. You may not need all of these for this assignment, but I provide them here to make your life easier for future assignments. Many of these hotkeys, like undo (Cmd-Z) work in other programs like Tableau and Colabs as well.
Copy | Cmd-C |
Cut | Cmd-X |
Paste | Cmd-V |
Paste without formatting | Cmd-shift-V |
Go to the next empty cell | Cmd-down (or up, left, or right) |
Highlight all cells in a row from the cell currently selected | Cmd-shift-down (or up, left, or right) |
Unselect one cell from a range of selected cells | Cmd-click |
Select multiple non-continuous cells or ranges | Cmd-click |
Copy a formula down | Select the source cell and drag the small square icon in the lower right of the cell through the target range |
Select column | Ctrl-Space |
Select row | Shift-Space |
Select all | Ctrl-A Ctrl-Shift-Space |
Undo | Cmd-Z |
Redo | Cmd-Y Cmd-shift-Z |
Find | Ctrl-F |
Fill range | Ctrl-Enter |
Fill down | Ctrl-D |
Fill right | Ctrl-R |
Watch: Working With Data
Watch: Average vs Median
Discussion Starters
For your discussion starter, I will group you into a small team (2-3 people depending on our enrollment) to frame a group of readings for the larger class’s discussion. Discussion starters should frame the readings and prompt classmates to think critically or differently about what they read. Do not summarize! Assume that your audience has read and understood all the assigned material.
Format: I want your small group discussion to actually feel like a discussion – not just a series of reports or static forum posts. Therefore, I’m asking discussion starters to record themselves having a brief conversation about the reading. Conversations should be between 17-20 minutes and each group member should contribute. Please make sure to have each group member introduce themselves by name at the beginning, since we haven’t all met in person (first names only or course blog username only is ok if you prefer to not have your name in a public video). Work out with all group members ahead of recording if you will be posting publicly toYoutube or privately to Blackboard and who is responsible for uploading the video.
To guide your discussion, I want you to use the TQE method: thoughts, questions, epiphanies.
Using this method, group members should first share with each other some of their overall thoughts and reactions to the reading and what it is trying to do. Wherever possible, please refer to direct evidence in the texts in the form of quotes, arguments, or examples.
From there, students should share any questions they have – for example, what didn’t you understand? What do you want to know more about? What would you like your classmates to discuss? You may have other kinds of questions and that’s great, just make sure they are questions that open up, rather than shut down discussion.
Finally, conversations should close with each group member sharing an epiphany that they had while reading/watching. An epiphany is a sudden revelation, a lightning bolt of insight where something you hadn’t understood suddenly becomes clear – or where something you once assumed or believed suddenly shifts. Epiphanies can be mind-blowing moments or quieter realizations, but they should nonetheless demonstrate how your thinking or understanding has grown.
Submission: Recordings may be in video or audio format and will be shared with the entire class. You can record video or audio on Zoom or on another platform of your choosing as long as you coordinate with all group members. You do not need to show your face on video but you will need to record audio unless you make other arrangements with me for accommodation purposes.
You are also welcome to play with other tools or formats as needed, as long as there is a discussion-like tone — we want to avoid having individual TQEs just spliced together. You are also welcome to be creative with it (think TikTok or YouTube vlog-style editing), but it’s not required. I strongly recommend at least some light editing to trim out awkward dead space at the start of the conversation or between sections.
Submissions will be sent to me (Prof. Kane) by midnight on Saturday February 13. If all members of the group are comfortable with the video being posted publicly, you can post to YouTube as an “unlisted” video, which will not show up in search results. You can then share the link with me and I’ll embed it on the blog and on Slack. If anyone in the group prefers for the video to be private, you can submit it on Blackboard via the “Video Submissions” assignment link, or share a Dropbox link with me and I will post it to Blackboard. Please let me know by email where to expect your video or audio submission. I will review and post the video for the rest of the class in the relevant module.
Adapted from an assignment by Anna Lauren Hoffman.
33 replies on “1: Discussion Starter”
[…] that is not flexible is the group discussion starter video due at midnight Saturday February 6. Please see next week’s module page for details. I will assign groups by email this […]
Here is my assignment 2.
Assignment 2
Looks good!
[…] the Module 1 page for further details on structuring and editing your discussion. It’s often very helpful to […]
Here’s my “Working with Data” link!:
https://docs.google.com/spreadsheets/d/1rcWIAtYWe1HOLRBbhAMB03s_tAZWJdE4na6qejWYDP0/edit#gid=229788000
Here is my Module One assignment.
Looks good!
Module1
Here is my Module 1 link
https://docs.google.com/spreadsheets/d/1Q3VtEK-nU4GfV2VSJfc7qttNeUXRknVq_QOE7UGbWMk/edit?usp=sharing
I left a comment on your sheet with a minor FYI 🙂
Here’s my assignment!
https://docs.google.com/spreadsheets/d/1XWvfnAic1ja806f0SrBtL3KK27PnXVsPNxbgblwv16A/edit?usp=sharing
Looks good!
Here’s my spreadsheet!
Looks good!
Here’s my assignment!
Looks good!
https://docs.google.com/spreadsheets/d/1riDMkGNKCUaEutG7G_S6hMN9h3658i6ZFaTYFWu-E7E/edit?usp=sharing
https://docs.google.com/spreadsheets/d/1riDMkGNKCUaEutG7G_S6hMN9h3658i6ZFaTYFWu-E7E/edit?usp=sharing
I tried a pretty link which did not work. Here is the real link.
Left an FYI comment for you 🙂
there is no chance this is going to work
And yet it did! Left an FYI comment for you 🙂
Here is the link to the Google spreadsheet assignment.
https://docs.google.com/spreadsheets/d/1LLQK5my76aBer1ieNj3m84WwNh6G57Iih6UhHzPDuzw/edit?usp=sharing
Looks good!
Here’s my assignment!
https://docs.google.com/spreadsheets/d/14pzU92U1nQSWbsSoykUYru9h0Wx2emxt2Pxvii5lhMM/edit#gid=1649248902
Looks good, I DM’d you an FYI comment on Slack
https://docs.google.com/spreadsheets/d/1BRW1ilmlmIs-Vn-rRRgTALvvrxULbqN7rI4e6fzywuE/edit#gid=1649248902
My assignment!
Looks good! I DM’d you an FYI comment on Slack
Here’s my spreadsheet!
Here is my assignment.
https://docs.google.com/spreadsheets/d/1JwSD6YTl1bWeSi4ZKu9u-e5ly5h1L219KoXee3Jo8lU/edit#gid=229788000
assignment link
module 1 assignment
trying again
https://docs.google.com/spreadsheets/d/1h3tclBGvt2ZxDAIvjje1Sp-Odj_apDC9qzNRsPabF2o/edit?usp=sharing
[…] is the same video on recording and editing video you saw in Module 1. I provide it here in case you need a refresher on how to edit your video, but feel free to reach […]