Sort+it+Out

> ==__Excel sheet directions: __== >> ==VIDEO 1 (for Excel or Calc) Direct link to the video == >> == ==
 * ==1. Download the following SortItOut.xls file, ==
 * ==2. Rename it to Party Playlist and add your name ==
 * ==3. Save it to 8th Grade Tech/ Party Playlist Folder ==
 * ==4. Open the file and watch Video 1 (for Excel or Calc). It might be helpful to look at the list while you watch, or pause it and try each step. ==

Excel Directions.pdf
> ==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. == >>

>>

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 ==

<span style="font-family: 'Comic Sans MS',cursive;">Here's what you will be doing:
> ==<span style="font-family: 'Comic Sans MS',cursive;">1. Create a new tab in your spreadsheet for your own list, and title it "Party playlist" == > ==<span style="font-family: 'Comic Sans MS',cursive;">2. Copy and paste the column headings onto your new list == > ==<span style="font-family: 'Comic Sans MS',cursive;">3. Begin copying your favorites and pasting them onto your Party playlist. == > ==<span style="font-family: 'Comic Sans MS',cursive;">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. == > ==<span style="font-family: 'Comic Sans MS',cursive;">5. When you are done, share your playlist or document with your teacher. == >> >> >> ==<span style="font-family: 'Comic Sans MS',cursive;">Part 2 Video for Excel Direct link to the video == >> >> == == >> >> >> >> == == >>