11

20
351

36
335

27
417

15
345

23
237

30
348

1
313

9
418

3
315

5
455

45
339

101
332

21
339

18
418

61
454

30
345

45
348

19
434

24
558

15
358

5
344

99
332

Task 1
Task 2
Find longest song in playlist
Task 3
Task 4
Find all songs by a certain artist in a playlist
Task 5
Find songs that exist in both playlists
Longest song:
Artist
Length
Number of rows:
Find last row in playlist
Find least played song in playlist
Least played song:
See Sheet2
See Sheet3
List NetIDs:
NetID
Total Grade
Variable Naming
Itemized variable naming errors and use Option Explicit (10% of earned points deduction if you have any errors.)
Task 1:
Task 2:
Task 3:
Task 4:
Task 5:
Function works on datasets
Function is correctly declared
Cell A1 is written correctly
Sub-procedure works on datasets
Column A in Sheet2 is properly cleared before each run
Artists without songs are correctly handled
Playlists without common songs are correctly handled
Maroon 5
Gangnam Style
PSY
Beat It
Michael Jackson
International Love
Pitbull
Rihanna
Diamonds
Payphone
Lady Gaga
Bad Romance
Alejandro
Thriller
Poker Face
Never Gonna Give You Up
Rick Astley
Friday
Rebecca Black
Subprocedure is correctly declared
Cleared by grading script
Name
# of Plays
We Found Love
Smooth Criminal
I’m on a Boat
Call Me Maybe
Barbie Girl
Billie Jean
The Lonely Island
Carly Rae Jepsen
Aqua
mcerny2
PASSED
FAILED – Function fails for dataset 1
FAILED
0 out of 15
0 out of 10
5 out of 5
5/45.0
Songs By Micheal Jackson
0 out of 5
FAILED – Column A in Sheet3 was not cleared properly