SCAD Animation Studios recruits students to work on a project that reflects the studio experience by collaborating with students from a variety of majors.
This project takes on the challenge of creating an animated series to teach preschool-aged children how bread is made.
For this project, I used a mixture of Google Sheets and ShotGrid. Google Sheets was mainly used for tracking assets and shot completion. ShotGrid was mainly used for dailies and tracking notes and versions. *Please note that ShotGrid was down for our school during the pre-production period.
ALL ART IS OWNED BY SCAD ANIMATION STUDIOS
For shot lists, I followed the naming conventions that the Technical Director requested them to be.
My executive producer requested that the layout of the shot list should show all
departments from start to finish.
At the end of production we dedicated an entire day to rendering. To keep track of what shots were being rendered, who is rendering, and when it began and finished I created this spreadsheet to keep track of all progress during the day.
Specifically I made functions that would calculate:
- percentage of shots completed
- number of shots left rendering
- timestamp for started and completed time
To help keep track of those who are enrolled in the class and/or actively participating in the production, I created a detailed roster to help keep track of crew members activity.
This was the first sheet I created for the project. This allowed me gain an understanding of the following standard tools:
- conditional formating
- data validation
- freezing roles