So many great suggestions, and of course, your question assumes you have the CHOICE of "which workshop" in your first week. Large Rotation Sunday Schools typically have to launch all their workshops on Week 1. Whereas, small programs which may only have 1 or 2 rotating classes, can choose which workshop to put in their first week of the rotation.
For those who can choose, here are some of my personal rules of rotation thumb:
1. Start with the workshop that gives the greatest overview of the story. Video often does this. But after that, it depends on the actual lesson plan for the workshops you have. Sometimes computer or drama cover the whole story.
Some Rotation programs combine grade groups for the first week's Video. So if you only have two grade groups rotating, combine them for the first week in Video. This also allows the video space to convert into another workshop in week 2.
2. A traditional "quiz-oriented" Game Workshop often works best later in the rotation because the kids know more. However, some Game Workshops are terrific at introducing new content too. Know your lesson plan.
3. The Art Workshop tends to "reflect" more on the story, so it may not be best in the first week if a majority of the time is spent actually being artistic.
4. Drama Workshops are often great at recapping the whole story too.
5. It is generally assumed that younger children need to see the "whole story" earlier, which makes Video a good choice in their first week.
6. Some lessons/workshops are easier for the teacher to prepare and learn how to teach the first week. For example: I think it's easier to teach younger children with drama in your first week, and then adapt it for older kids once you have a better handle how the drama will go. Conversely, it's usually easier to teach older children with software in the first week, because they need less help.
One of "Rotation's dirty little secrets" that the first week is a "dry run" for many of our volunteers, and the second week is where they really do better.
In summary:
It really depends on your set up, and what's actually IN the lesson plan or resource you are using. Some videos don't cover the whole story, and some software does. Some art projects illustrate the whole story, and some cooking workshops walk through the entire story with food.
This is one of the great things about Rotation: the ability to adjust to your needs and ideas.