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







50 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.

Unknown said...

I was very pleased to find this page. I wanted to thank you for your time due to this wonderful read!! I definitely loved every part of it and I have you bookmarked to check out new information on your blog. Feel free to visit my website;
야설

Unknown said...

Positive site, where did u come up with the information on this posting?I have read a few of the articles on your website now, and I really like your style. Thanks a million and please keep up the effective work. Feel free to visit my website; 한국야동

Unknown said...

Everything is very open with a precise clarification of the issues. It was really informative. Your site is very helpful. Thanks for sharing! Feel free to visit my website; 국산야동

Unknown said...

I’m truly enjoying the design and layout of your site. It’s a very easy on the eyes which makes it much more enjoyable for me to come here and visit more often. Did you hire out a designer to create your theme? Exceptional work! Feel free to visit my website; 일본야동


Unknown said...

Thank you so much for this excellent blog article. Your writing style and the way you have presented your content is awesome. Now I am pretty clear on this topic, keep it up! Feel free to visit my website; 일본야동

Unknown said...

I like the helpful info you provide in your articles. I’ll bookmark your blog and check again here frequently. 사설토토

Unknown said...

Your weblog is definitely worth a read if anyone comes throughout it. 파워볼게임

머니상 said...

I think it's a website with a lot of good contents. I think I accumulate a lot of knowledge.
Please come to my website and give me a lot of advice.
It's my website.

머니상

Unknown said...

It's a very good content.
I'm so happy that I learned these good things.
Please come to my website and give me a lot of advice.
It's my website address.

온라인홀덤

baccaratsite.top said...

Well I truly enjoyed reading it. This subject offered by you is very helpful and accurate.
바카라사이트

sportstotozone.com said...

Your blog is really nice. Its sound really good
토토사이트

Unknown said...

It's amazing. I want to learn your writing skills. In fact, I also have a website. If you are okay, please visit once and leave your opinion. Thank you. 바카라게임사이트

Unknown said...

Hello, I am one of the most impressed people in your article. 토토사이트순위 I'm very curious about how you write such a good article. Are you an expert on this subject? I think so. Thank you again for allowing me to read these posts, and have a nice day today. Thank you.

Unknown said...

Your article has answered the question I was wondering about! I would like to write a thesis on this subject, but I would like you to give your opinion once :D 꽁머니

aditya said...

Very wonderful informative article. I appreciated looking at your article. Very wonderful reveal. I would like to twit this on my followers. Many thanks!

stoichiometry calculator
slope intercept form
double integral calculator
substitution property of equality
alternate interior angles
identity vs role confusion
ser conjugation
repetir conjugation
cancellous bone
additive inverse property

Business Services said...

Your Content is amazing and I am glad to read them. If you are familiar with SEO, you already know how important Links Building. If a link relation is given as dofollow, then you will get a good boost over SERP and Boost your Ranking Buy Services From it 24/7
SEO dofollow backlinks

dofollow profile backlinks
top rated classified website Ads
forum posting backlinks
US UK canada dofollow backlinks
USA forum backlinks

Business Services said...

Your Content is amazing and I am glad to read them. Thanks for sharing the Blog.this blog is very helpful information for every one.

seo experts in lahore
rellenar solicitud de empleo
papas 2.0

Unknown said...

Which is some inspirational stuff. Never knew that opinions might be this varied. Thank you for all the enthusiasm to provide such helpful information here. 온라인바카라

Will Kolson said...

There are many ways to build a dynamic exhibition schedule. One way is to use social media to post about upcoming exhibitions and ask for feedback from the public. You can also build your academic essay writing skills with the help of expert writers of Law essay writing service UK.

Unknown said...

You made some good points there. I did a Google search about the topic and found most people will believe your blog. 먹튀검증

Hotregreg55 said...

바카라사이트 Thanks for sharing your info. I truly appreciate your efforts and I will be
waiting for your further post thank you once again.

Hotregreg55 said...

스포츠토토 Loved this blog. Such blogs should be made more often. Huge kudos to u

Hotregreg55 said...

스포츠토토티비 Thanks for every other great article. The place else could anybody get that kind of information in such an ideal approach of writing?
I've a presentation subsequent week, and I am on the search for such information.

Ngocanhday said...

슬롯커뮤니티

badugisite18 said...

Your article is very interesting. I think this article has a lot of information needed, looking forward to your new posts. 바둑이사이트

Christian Baker said...

The name Do My Homework is heard often on the lips of students nowadays. The popularity of this website has increased tremendously over the past few years. The tutors from these websites help out students to finish their homework at their own pace. The content provided by these guys is also of top quality. One can therefore get really high quality help with english assignments and projects during tight schedules and deadlines done from these guys.

The tutors here believe that the process of learning should be fun rather than being barricaded by deadlines. Students can also enjoy themselves a bit knowing that their assignments are in safe hands.

The entire process of learning should never be boring. This is taken care of by the experts here. The fundamentals of each subject should be firmly within the grasps of the students. This is something that the tutors at Domyhomework.co firmly believe in. The content being offered by them is highly engaging and students can learn a lot from them too. With the help being offered by the tutors at Domyhomework.co, students can also look forward to participating in other activities and hobbies.