Q4 Sort It Out
Direct link to video
Introduction
You have been asked to manage the music for the beginning of a party, before the DJ arrives. The party theme is top music from 2013. Your job is to put together a play list for the first 30 minutes. You have a list of music, descriptions, and play times (over two hours of music) in a spreadsheet to choose from.
Your task is to sort the list in several different ways, and create your own playlist.
Key Vocabulary:
genre: a particular type of literature, music or art
Party Playlist: a mix of everyone's song preferences
Steps:
Part 1
Google sheet directions:
If you will use the Google sheet version click this link 21t4s Sort It Out
1. Go to the File menu, select "Make a copy" and do not check the box to "share it with the same people".
2. Rename your spreadsheet to Party playlist and add your initials.
3. Watch Video 1 (for Google Sheets) below. It might be helpful to look at the list while you watch, or pause it and try each step.Video 2: Making pages
Google Sheets Directions.pdf
Part 1 Assignment:
Follow the directions and do the following sorts. Remember to watch the column headers and make sure they don't get sorted into the rest of the data.
a. Sort by Artist - how many artists have more than one entry?
b. Sort by Genre - how many different genre are there?
c. Sort by Song Title - are there some duplicates. Delete the duplicate you don't want in the list.
A quick review of what you accomplished in Part 1.
• Sorting a spreadsheet by different columns (variables)
• Freezing the top row (Google) or protect the headers (Excel)
• How to delete a row
• How to UNDO something you just did in the spreadsheet
Part 2
Decisions:
1. Create a new tab in your spreadsheet for your own list, and title it "Party playlist"
2. Copy and paste the column headings onto your new list
3. Begin copying your favorites and pasting them onto your Party playlist.
4. As you add new songs, you will need to add a formula for the computer to add up the minutes and seconds to make sure you are under or equal to 30 minutes.
5. When you are done, share your playlist or document with your teacher.
Part 2 Video for Google sheets Direct Link to the video
Part 1 Assignment:
Follow the directions and do the following sorts. Remember to watch the column headers and make sure they don't get sorted into the rest of the data.
a. Sort by Artist - how many artists have more than one entry?
b. Sort by Genre - how many different genre are there?
c. Sort by Song Title - are there some duplicates. Delete the duplicate you don't want in the list.
A quick review of what you accomplished in Part 1.
• Sorting a spreadsheet by different columns (variables)
• Freezing the top row (Google) or protect the headers (Excel)
• How to delete a row
• How to UNDO something you just did in the spreadsheet
Part 2
Decisions:
- Do you want a variety of Genre or categories of songs?
- Do you only want certain artists?
- What songs do you think other partiers will prefer?
- Remember: You can only have up to 30 minutes of music
1. Create a new tab in your spreadsheet for your own list, and title it "Party playlist"
2. Copy and paste the column headings onto your new list
3. Begin copying your favorites and pasting them onto your Party playlist.
4. As you add new songs, you will need to add a formula for the computer to add up the minutes and seconds to make sure you are under or equal to 30 minutes.
5. When you are done, share your playlist or document with your teacher.
Part 2 Video for Google sheets Direct Link to the video
Directions for Part 2 with google sheets.pdf
Completing this Quest
Share your 30 minute party playlist document with your teacher for credit. Great job!
[email protected]
READ THIS....PASSWORD FOR QUIZ IS dig21
ISTE Standards•S
5. Digital Citizenship
B. Exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity
C. Demonstrate personal responsibility for lifelong learning
6. Technology Operations and Concepts
A. Understand and use technology systems
B. Select and use applications effectively and productively
MP.5 Use appropriate tools strategically
MP.6 Attend to precision
5. Digital Citizenship
B. Exhibit a positive attitude toward using technology that supports collaboration, learning, and productivity
C. Demonstrate personal responsibility for lifelong learning
6. Technology Operations and Concepts
A. Understand and use technology systems
B. Select and use applications effectively and productively
MP.5 Use appropriate tools strategically
MP.6 Attend to precision