Gary contacted me today and assigned my task. It was related to creating a database of all the schools that offer soccer programs for men and women. I had this this activity in the first couple of weeks as this was resource was important in this line of work which was media and communications. Gary was content with my work and the organized manner in which the filed were created. He stressed the need for including as many states as possible in the list so that we have ready data available when we need to contact a list of institutions. So, I added Illinois and Michigan to the list with all the schools offering soccer programs. In addition, I was required to shortlist all the youth soccer clubs in all the states that I have covered. Since the International Soccer Network is involved with various teams of all levels and the media relations and communications, the maintenance of a database of these youth soccer clubs was crucial for a reaching out for future events and scouting.
0 Comments
Today, I continued with gathering the numbers for all the social media pages for each team in the South region. The southern region had four conferences in it; South Atlantic, Southeast, Sunshine and South Central conference. There are 24 teams in this conference collectively with varying numbers in their fan following across its social media.
I received the assignment for this week. Gary emailed me explaining what was to be done. This week's activity was to create a spreadsheet for all the social media handles of the NPSL teams. The league was divided into different regions and each region had its various conferences. In order to effectively create a database for the social media (Facebook, Twitter and Instagram) statistics for each team, I was required to visit the social media pages of each team. There were some teams that haven't made their presence on all three platforms but for most of the teams, the numbers demonstrated a strong fan base in its respective regions.
I began organizing the information for all the regions and conferences in different sheets so that any party using this information would be clear in navigating through the spreadsheet. Today, I stared with the Northeast region which had three conferences in it; Mid Atlantic, North Atlantic and Keystone Conference. Last week had ended on a positive note. Gary had opened me up to some of the duties and responsibilities that were directly related with the NPSL. I was motivated to see my progress each week through the daily and weekly tasks that were assigned to me. I called Gary to ask about my next assignment for this week. I spoke to him for a brief moment and he told me that he would let me know by the end of the day. In the meanwhile, I checked my Dropbox to see if there were any updates of game reports. Now that the spreadsheets for all games was updated with the available information, It was important that I kept checking for reports of games that took place recently. I skimmed through my files in the Dropbox and found several new posts. So, I went ahead and did my job of updating the logs.
I had emailed Gary the spreadsheet for the 500s yesterday evening and today, I got an email from Cindy Spera, the Director of the National Premier Soccer League. She wanted to talk about the logs for the various games that needed to be updated and also about some discrepancies that I encountered with some of the game reports while I was compiling the statistics.
I called her in the evening but she was on her way home. She did tell me about some of the things that I should send her via email and Dropbox and that she would review the 500s log that was newly created. So, I uploaded the 500s log in Dropbox and shared it with her and also sent her via email. After this, I continued to work on the logs for 700s, 800s and the 1000s. I had to keep monitoring my Dropbox if the reports for the missing games has been updated so that I can compile the stats for those games. There were a few reports that were posted today and I worked on those reports with the available information I had. I continued to work on updating the compiling the statistics for the games. I had completed filling out the statistics for the 700s and 800s. Today, I moved on to handling the games under the 900s. There were not many missing games so it took me relatively lesser time to get it done. In the middle of the work, I got a call from Gary and he told me the game reports of the games under 500s was up and insisted that I start working on it immediately. All the spreadsheets that was shared with me that required to be updated was already created and I had to fill in for the missing games whenever the reports for those games were available. But the spreadsheet for the 500s was not created at all so I had to make one following the same format as the other spreadsheets.
So, I began reviewing the reports and extracted the numbers for each game in a new spreadsheet. I made sure this was done at the soonest because Gary told me that this is priority. It was a lengthy task but I enjoyed the work since it was something new to me and was related to the administration task of the NPSL. I was getting to learn new things and furthermore, I was now working, in part, for the NPSL, besides my mentor, Gary. After having done a quick skim of the National Premier Soccer League, I opened the Dropbox files of the game reports under the 700s. Gary told me that there were some reports missing for certain games and that I had monitor the Dropbox files if it has been added. If so, then I had to complete filling out the statistics for those games so that the spreadsheets for all games was updated. However, I saw that it was still missing so I could not work on those game spreadsheets. But I found out that the reports fr other games were submitted in the Dropbox and I went ahead and completed the compilation for those games.
The only challenge of this task was that the game reports from which I had to compile the statistics were all handwritten except maybe a couple. Accuracy of the numbers was key in this task so I had to take my time making sure that I enter the right numbers. This made it a little time consuming but I got it started and kept a steady momentum. I was given my next assignment for the week and it had to do with the National Premier Soccer League (NPSL). I did a background research about the league to have a fair understanding of my assignment since it was directly related. There were several spreadsheets and game reports of various games of the NPSL. It was a Dropbox file that was shared between me and other parties. One of them was Cindy Spera, the Director of the league. All the games were listed as 100s, 200s, 300s and so forth till 1000s. We were in charge for updating the game statistics from the post game reports for games in the 500s to the 1000s.
My task was to review the game reports for the games in 700s, 800s, 900s and 1000s and update the statistics in the respective spreadsheets. The objective of compiling this statistics was to ascertain the players with the highest numbers under various categories such as goals scored and assists. This will enable the league management to determine the most deserving player of the award that is to be given out. I spent much of my time finishing up with the spreadsheets for the list of schools in the Midwest region. Gary had assigned me the task of creating a database throughout the week with focus on the schools in this region. I successfully executed this task by creating separate spreadsheets for every school the its soccer programs for both men and women. As I have highlighted the significance of this database for the International Soccer Network in my previous blogs, this task also extends the reach of the organization in terms of exposure of athletes to various programs across the region.
Overall, the week has been productive in terms of getting major work done and enhancing my organizing and data mining skills. I was able to grasp some key lessons pertaining to soccer leagues and communications with various schools and coaches. |
AuthorI am Jason Salam, MBA - Sports Management student at Tiffin University, Ohio. I have a background in business administration, particularly in marketing. Blogger and sports enthusiast! Archives
December 2015
Categories |