Sunday, April 5, 2015

Building dynamic exhibition schedule.



School-wide exhibitions... that amazing experience of students presenting evidence of their progress to a diverse group of peers, family and mentors... is a transformative experience and is one of the few examples of truly authentic summative assessment in high school.

But... It can be an absolute nightmare to manage students when a school has exhibitions - the week-long presentations that are attended by parent, mentors and kids from throughout the school. How do we track what students are in which rooms for what times? How do you manage kids signing up for their own presentations... in a way that does not give the advisor the added job title of 'Master Scheduler' on top of his/her already full list of responsibilities.

Here is a way to use Google Sheets to streamline the logistics of pulling off school-wide presentations. I will admit that this may seem confusing if you are not comfortable with Google Sheets. I am very happy to work with you to set up a template specifically for your school! (You can even take all of the super-hero credit!)

For this process, we are going to create two types of documents, the 1st is a class-specific exhibition scheduling document. This document will pull the schedule form the school-wide document, and it will send the individual advisor schedule to the master schedule so the office and admin can have a central location to view the overall schedule.

The second is a school-wide exhibition schedule. This document will do three jobs. It will set the master schedule for exhibitions, it will allow advisors to place panelists and track attendance, and lastly, it will provide a simplified format for posting the daily schedule on a large projector or flat-screen monitor.

OK... so this stuff is tricky but getting these systems in place will make you a super-hero for any school the struggles to manage real exhibitions.

Step 1: Create advisory schedule documents.

Use this template.

You will copy this document FOR EACH ADVISORY. If you have 10 advisories, you should create 10 documents. This will be the place where advisors (or students) actually schedule for exhibitions. Share each document with editing privileges to each advisor. Note that the dates and times for this document will give you that "#REF!" or "N/A" indication because we have not told this spreadsheet where to look to get the master schedule.
As an advanced part of this step you can also Protect Range for the parts of the document (like the dates and times) that you do not want the advisor or student to alter.

As you can see form this document, once the advisor adds kids to the roster on the right hand, those names will appear as pull down options on the left side. This allows students to schedule themselves and for the advisor to have an automated accounting system to ensure that every kid get's scheduled.


Step 2: Create a master schedule document. 

Use this template.

The next sheet that you will see is the master data. This included the date and timing of exhibitions (EX) and Gateways (GW).  This data fills in the master schedule as well as the individual schedules for each advisor (more on that later). If you only need one set of times, you can clear out the GW cells. Fill in the dates and times for your exhibitions (you can change them whenever you want and it will sync up with the advisor schedules - no worries.) You might notice that the tabs for the days of the exhibitions will contain cells that say "#REF!" of "N/A". Don't worry about that for now. This master schedule is trying to look up advisor schedules but does not know where to look yet.





Step 3: Link 'em up!

Now we need to link the master schedule with all of the advisory schedules. On the advisor schedule there is a tab named "KEY DATA". In that tab cut and paste the Google Document Key from the Master Schedule. This will enable the advisor schedule to pull dates and times for exhibitions from one central location (The Master Document).


Next... take the document key from each Advisor Schedule and plug it into the "Data Collection" tab on the master schedule. This will tell the master schedule where to pull all of the schools' schedules from. You will need to do this for each advisory.


This all may seem confusing... especially if you have not worked a lot with Google Document... but I promise it will create a system for managing exhibitions that will be error-free, easy to manage and clear for students. Check out all three videos... but also feel free to get in touch with me if you would like me to set this up for your Big Picture School.


 

Just remember... if you encounter any problems or find me crazy-confusing... just email me and we can set up a Google Hangout session. david@bigpicturelearning.org







24 comments:

Masood said...

Thank you for such a well written article. It’s full of insightful information and entertaining descriptions. Your point of view is the best among many. exhibition stand production companies

Daviner said...

Good progress !! we can explain. Young people began to be interested in process automation and cyber science. I recently read an article on eSports and esports betting sites. Simple sport has ceased to interest the majority of people. People started playing computer games on gaming platforms and making money.

ujoyjulia said...

Go online for help. Nearly every game has its own legion of dedicated fans, many of which spend countless hours crafting detailed maps and guides.More Info

reginald surict said...

Hi there! Here are some good recommendations on how to write a good web developer resume.

steve smith said...

This is HP Error Code 13.20.00 and HP Printer Error Code b8047a26 as well this is best type of HP Printer Error Code 13.20.00 and last one that is all about HP Error Code 13.20.00 and last one HP Error Code 13.20.00

Larry said...

nice post

Brother Printer Drivers Support

brother printer drivers download

update brother printer driver

brother drivers printer

----------------------------

Brother Printer Support Assistant

brother printer software

steve smith said...

This is HP Error Code b8047a26 and HP Printer Error Code b8047a26 as well this is best type of HP Printer Error Code b8047a26 and last one that is all about HP Error Code b8047a26 and last one HP Error Code b8047a26

steve smith said...

This is HP Error Code 388 and HP Printer Error Code 388 as well this is best type of HP Printer Error Code 388 and last one that is all about HP Error Code 388 and last one HP Error Code 388

steve smith said...

This is HP Error Code b0605 and HP Printer Error Code b0605 as well this is best type of HP Printer Error Code b0605 and last one that is all about HP Error Code b0605 and last one HP Error Code b0605

Larry said...

Brother Printer Troubleshooting Guide

brother printer troubleshooting

-----------------------------

Brother Printer Wireless Setup

brother printer wireless setup wizard
---------------------------------

Brother Printer Offline Fix

brother printer offline fix windows 10

---------------------------------------

Brother Airprint Printer Not Found

brother printer airprint not working

Larry said...


brother printer error code 30
brother printer error 30


brother printer error code CC4-205
brother error code CC4-205
brother printer error CC4-205

Larry said...


brother printer error code 32
brother printer error 32
brother printer 32 error



brother printer error code 50
brother printer error 50

Larry said...


epson printer error code 0xe5
epson error code 0xe5
epson printer error 0xe5

epson printer error code 0xea
epson error code 0xea

Larry said...

epson printer error code 0xf3 & epson error code 0xf3


epson printer error code 00041
epson error code 00041
Epson Error Code 1073

Larry said...

epson printer error code 0x9a
epson error code 0x9a wf-3640
epson code 0x9a

Larry said...

Epson Printer Error Code e1460-b305
epson error code e1460-b305
error e1460-b305
e1460-b305

Larry said...


Epson Printer Error Code 00044
epson error 000044
epson printer error 000044

VISIT ME said...

What’s Taking place i’m new to this, I stumbled upon this I’ve found It absolutely useful and it has aided me out loads. I hope to give a contribution & aid other
customers like its aided me. Great job. 메이저사이트


VISIT ME said...

It’s awesome to pay a visit this web page and reading the views of all colleagues concerning
this piece of writing, while I am also zealous of getting knowledge. 경마사이트

VISIT ME said...

Very nice post. I just stumbled upon your weblog and wanted to say that I have really enjoyed browsing your blog posts. In any case I will be subscribing to your feed and I hope you write again very soon! 카지노사이트

VISIT ME said...

I need to to thank you for this fantastic read!! I definitely loved every little bit of it. I’ve got you saved as a favorite to look at new stuff you post… 토토

Offer n Codes said...

thanks for sharing this valuable information i never expect like this from you. Discount Codes

Ruth K. Alba said...

Great information! if you are having issues with your TWC Login, then we are here to help you out.

Eric Clark said...

One of the most well known and reliable Assignment Writing Service in the United Kingdom. The Academic Papers offer a wide spectrum of writing services with excellent quality.