spread sheet

as this project gets underway its clear that keeping tabs on everything will be a difficult feat to do mentally so by using google spread sheets im able to easily keep track of everything going on. by also using a google app i can share it within my team and they’re also able to update a live version to everyone to see, this is a huge help as it means everyone is on the same page and everyone knows whats happening

starting off simple to begin with i knew i needed to see a list of artists that were being featured, i would update this as i got responses from recruitment email, from here i started to add green highlighting to the panels that were completed, separating them out to clearly label the submitted text and images on the artist’s side and the double page spread on our side

from here we got more responses from 1st years and a few 2nd and 3rd years and added them to our mailing list and facebook group chat, i also added a column for consent forms and asked my team which artist’s work they would like to undertake, giving them this first response to what they wanted to do might have helped encourage them to complete this work load. i also though about how we’d need a front cover, a contents, and an acknowledgements page

from here i added a numbering system to indicate how man artists we had along with roman numerals ( i, ii, iii ) to indicate additional pages needed to form a cohesive magazine and properly credit the artist’s work used

i then color coded everything along with a key to indicate the progression of our work, the artist’s submissions of work, and any extensions granted. you can see on consent form there have been some issues highlighted with muses signatures as a few of the artists have forgotten to add this information meaning we would be unable to use their likeness in the publication without their consent

i also added a section for key dates and notes for team meetings so everyone would be in the same page and know what is going on, what has happened, and the coming events. this would also give my team the opportunity to add to this and bring up any points they wanted to make during our meetings as i made a habit of updating these a week in advance.

i also noted a small space to show the division of work, helping make it an even work load for everyone, 4(team members) / 21(artists) =5.25(page division), rounded up everyone needs to do 6 pages each, at the moment it shows both Josh and Phoebe are under the required number and need to be assigned pages