So, a year-end report on my project.
Well, I lost my spreadsheet a couple times due to the Windows 10 update and then the even weird clawback to Windows 7. So in the last month and a half, I have been rebuilding it. But instead I have refined it and gotten the thing to a more sensible storage situation. That is, I figured out how to build a database and devise the appropriate queries such that the only need for the spreadsheet is to do only the calculations. Songs are prorated for age, language and gender.
I've come up with a more decisive criteria model. The key concepts I use are the following.
- Familiarity - How has the song reached the intended audience.
- Relativity - How does the content of the song speak to the intended audience.
- Flexibility - How many roles, situations, and interpretations can the song fulfill.
- Identity - How does the song fulfill the roles that are required in Canadian society.
So far I have 100 songs entered. So I will let you compare the top 10% and the bottom 10%.
Top 10%:
1. Call Me Maybe - Call Me Maybe (Justin Bieber)
2. Barrett's Privateers - Stan Rogers (The Real Mckenzies, Alestorm)
3. Maple Sugar - Ward Allen (Andy DeJarlis, Don Messer)
4. YYZ - Rush (Foo Fighters)
5. Angel - Sarah Mclachlan (Josh Groban, Kelly Clarkson)
6. I'll Never Smile Again - Ruth Lowe (Frank Sinatra, Michael Bublé)
7. Which Way You Goin' Billy? - Poppy Family
8. Silence - Delerium & Sarah Mclachlan (DJ Tiësto, Airwave)
9. High School Confidential - Rough Trade
10. Log Driver's Waltz - Wade Hemsworth (Kate & Anna McGarrigle, Captain Tractor)
Bottom 10%
91. Push + Pull - July Talk
92. Internet Rebellion - Arion
93. Omega - Pascal Languirand
94. Psychological Warfare (Rock Em Sock Em Techno) - BKS & Don Cherry
95. Les gross torches Acadiennes - Mononc Serge
96. Pêcher aux Îles - Roger Poirier
97. Brun (le couleur de l'amour) - Bernard Adamus
98. Proud To Be Canadian - Arrogant Worms
99. Ye Girls of Old Ontario - Wade Hemsworth
100. Happy Birthday, Kid - Geoff Hughes
As you might notice, the top 10% is overwhelmingly female. This is a problem with having such a small sample base. As I keep on adding songs, a more equal representation should become more apparent.