tbierwirth

SELECT items.name AS item_name, categories.name AS category_name FROM items INNER JOIN item_categories ON item_categories.item_id = items.id INNER JOIN categories ON item_categories.category_id = categories.id WHERE items.name='arugula salad';

SELECT students.name AS student, classes.name AS class FROM students INNER JOIN enrollments ON enrollments.student_id = students.id INNER JOIN classes ON classes.id = enrollments.class_id;

SELECT students.name AS name, enrollments.grade AS grade FROM students INNER JOIN enrollments on enrollments.student_id = students.id;

SELECT students.name AS name, AVG(enrollments.grade) AS grade FROM students INNER JOIN enrollments on enrollments.student_id = students.id GROUP BY students.name;

SELECT students.name AS name, COUNT(enrollments.class_id) AS classes FROM students INNER JOIN enrollments on enrollments.student_id = students.id GROUP BY students.name;

tbierwirth

DTR: Define the Relationship

Use this template to when conducting DTR with your project partners. It's recommended that you copy/paste this template into your own gist each time you conduct a DTR to take notes on the conversation.

Guiding Questions to Define The Relationship:

• What are each of our learning goals for this project? What drives us in this project?
• What is your collaboration style? How do you feel about pair programming vs. divide-and-conquer approaches?
• How do you communicate best? How do you appreciate receiving communication from others?
• How would you describe your work style?

tbierwirth

HTML

1. What is HTML?

• HTML (Hyper Text Markup Language) is a coding language used to structure and design webpages.

1. What is an HTML element?

• Building blocks of an HTML webpage that the browser uses to determines what is displayed and how it is displayed.

1. What is an HTML attribute?

• An attribute provides additional information to an element. For example: a link to an image, height/width of an object, or color/font/size of text.

tbierwirth

DTR: Define the Relationship

Use this template to when conducting DTR with your project partners. It's recommended that you copy/paste this template into your own gist each time you conduct a DTR to take notes on the conversation.

Guiding Questions to Define The Relationship:

• What are each of our learning goals for this project? What drives us in this project?
• What is your collaboration style? How do you feel about pair programming vs. divide-and-conquer approaches?
• How do you communicate best? How do you appreciate receiving communication from others?
• How would you describe your work style?

tbierwirth

Project: Battleship

Group Member Names: Kelly and Tyler

Goals and Expectations for the Project (What does each group member hope to get out of this project? What do we want to achieve as a team? How will we know that we're successful?):

• Kelly would like to learn more of the Ruby methods and how to implement them. Tyler would like to find more efficient ways to use methods, especially enumerables.
• We would both like to achieve 3's on all parts of the rubric and feel confident with the code we have written.

Team strengths & collaboration styles (consider discussing your Pairin qualities here):

• Kelly is an optimistic and creative partner and will help with motivation if things start to feel overwhelming.

tbierwirth

What role does empathy play in your life and how has it helped you?

Empathy allows me to connect with the world in a deeper and more meaningful way. Not just being able to understand how people feel, but to feel how they feel gives insight into how to make real and lasting positive change. With that being said, I believe acting and thinking with empathy expands outside of the human species and into the diversity of life and even our environment and ultimately our planet Earth. It has helped me think of the bigger picture and humbled me into believing that there is more to life than just taking care of myself and interests, it's about improving the lives of the people (and critters) around me and the generations that have yet to come.

How does empathy help you build better software?

Developing software empathetically allows you to design in a more thoughtful way. Coming up with solutions to improve the user's experience, potentially in ways that they hadn't even realized, is a path toward high qualit

tbierwirth

What is your greatest strength and how do you know?

My ability to care for others and act with empathy is one of my greatest strengths. I know this because of how emotionally charged I get when I see a friend or family member deal with a traumatic incident or part of their life, watch someone being rude or disrespectful to other people, and even when I'm watching a powerful scene of a movie or show with quality character development. This characteristic has allowed me to form strong and meaningful relationships with people throughout my life which I attribute to being able to have deep conversations. While I believe this to be a unique part of my personality, it has been a blessing and a curse as over the years I have come to understand that some people are simply not comfortable, or are even incapable, with being as open as I am.

How do you work best?

I generally work best under a little bit of pressure in a comfortable environment. Starting a project or homework immediately when there is plenty of ti

tbierwirth

Checklist/Rubric

Part I: Creating Directories and Files; Initializing Git and Pushing to GitHub

• I named my directories correctly.
• I named my files correctly.
• I structured my files and directories correctly.
• I made one initial commit.
• I pushed my initial commit to GitHub.

tbierwirth

Git Terminal Commands

• git init
  • Creates an empty Git repository or reinitializes an existing one.
• git add
  • Adds a file to the staging area to prepare it for a commit.
• git commit
  • Create a new commit and records changes into the repository.
• git push
  • Push changes made to the remote master branch of a repository.

tbierwirth

Session 4 Readings and Responses

The readings and responses listed here should take you approximately 50 minutes total.

To start this assignment:

1. Click the button in the upper right-hand corner that says Fork. This is now your copy of this document.
2. Click the Edit button when you're ready to start adding your answers.
3. To save your work, click the green button in the bottom right-hand corner. You can always come back and re-edit your gist.