Thespian Induction Point System (TIPS)

Thespian Induction Point System (TIPS) and FAQs 

05-18-2017 16:12

At EdTA we strive to deliver ever evolving services and technology to support our members. We are pleased to unveil the Thespian Induction Point System (TIPS) to help you keep an accurate record of students' accomplishments and progress toward earning induction into the International Thespian Society. This should be particularly helpful as troupe directors prepare for the new school year.

The Thespian Induction Point System (TIPS) is built in Microsoft Excel and will work on versions 2013 and newer. Please enable macros when using the tool.

Please refer to the FAQs document as a reference guide, should you have questions about the use or evolution of the tool. And, please submit comments or questions about the Thespian Induction Point System to info@schooltheatre.org.

Statistics
2 Favorited
2732 Views
2 Files
0 Shares
6385 Downloads
Attachment(s)
xlsm file
Thespian Induction Point System (TIPS)   810K   1 version
Uploaded - 05-18-2017
pdf file
TIPS FAQs   102K   1 version
Uploaded - 05-18-2017

Comments

7 days ago

Hello, 
I am using the spreadsheet but I get the following error when I go to Step 2 - Import Data to Log:
Microsoft Visual Basic
Run-time error '448':
Name argument not found

It gives me the option to abort or debug. If I select debug it shows me this:
Sub Select_Input()

'

' Select_Input Macro

'




'

   Sheets("STEP 1—ENTER DATA").Select

   Columns("o:o").Select

    Selection.Find(What:="", After:=ActiveCell, LookIn:=xlValues, LookAt _

        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _

        False, SearchFormat:=False).Activate

    ActiveCell.Select

    ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Activate

    ActiveCell.Select

    Range("A3:" & ActiveCell.Address).Select

End Sub

I really don't want to have to start all over or create my own spreadsheet from scratch. Anyone able to help?

09-13-2018 16:27

Hi, 
When I upload new data and hit refresh on the "Report by Grad Year" Tab, only some of the names come up. Sometimes the new names will come up and then disappear like a glitch. How do I get ALL the data imported there? For some of the names, it only shows their last name instead of their full name, even though the master log shows their full name. 
Thanks!

06-02-2018 14:13

Hello, 
I am using the spreadsheet but I get the following error when I go to Step 2 - Import Data to Log:
Microsoft Visual Basic
Run-time error '448':
Name argument not found

It gives me the option to abort or debug. If I select debug it shows me this:
Sub Select_Input()

'

' Select_Input Macro

'




'

   Sheets("STEP 1—ENTER DATA").Select

   Columns("o:o").Select

    Selection.Find(What:="", After:=ActiveCell, LookIn:=xlValues, LookAt _

        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _

        False, SearchFormat:=False).Activate

    ActiveCell.Select

    ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Activate

    ActiveCell.Select

    Range("A3:" & ActiveCell.Address).Select

End Sub

I have no clue what any of that means. Can someone help, this is such a great resource and I don't want to have to start over from the beginning.

05-24-2018 13:19

There have been a number of questions regarding passwords for the TIPS workbook.

Some password related questions are triggered by people clicking on the "Insert School Name Above" cell on the School ID worksheet. The instruction is literal--if you click on the cell ABOVE this one, you will be able to enter the relevant information and you will not be prompted for a password.

There are instructions for making corrections to the LOG sheet in the introductory video. This should be the only other time one might need a password. After reviewing the introductory video, your questions related to the LOG sheet should be answered.

If you have any other password related questions, please email me directly at bmonk@schooltheatre.org.

Thanks!

05-23-2018 08:00

How come no one is answering the question about the password?  In order to use this, it is asking for a password.  What is the password, please?

05-18-2018 12:40

How do you get the point system?  I put the school's name and the chapter # but never received anything with regards to the points.​

05-10-2018 12:49

Kimberly (and others),

A common issue that I am finding is that on the "School ID" where it asks you to "Insert School Name Above" and "Insert Troupe Name Above" it literally means that you need to click into the cell above the cell with those words. If you click ON the cell WITH the words, it will prompt you for a password.

No password is necessary.

05-09-2018 12:22

I am also getting the password prompt. How do we get it open?

04-26-2018 10:55

I opened the spreadsheet but in order switch off the protection to enable editing I have to enter a password. Do I require a password or am I missing a step?

03-12-2018 13:54

Hi, Joel

Recommended point awards tend to assume a standard production run of a one act or full length show -- one or two weekends. For productions with an extended life thanks to competitions, showcases, etc., you may award additional points for the additional work at your discretion. One way to do that is to calculate a rough number of hours spent on task. That is calculated at 1 Thespian point per 10 hours of quality work. Quality takes caliber of work and educational value of experience into account. Typically, that would not include travel time.

03-09-2018 08:02

Our one act was performed at our school for a full run, won regionals, and went to state.  Do our students get credit for each or do we just mark it at state.  Basically should there info be entered once for school, once for regions, once for state...Or once overall?

Related Entries and Links

No Related Resource entered.

Comments

7 days ago

Hello, 
I am using the spreadsheet but I get the following error when I go to Step 2 - Import Data to Log:
Microsoft Visual Basic
Run-time error '448':
Name argument not found

It gives me the option to abort or debug. If I select debug it shows me this:
Sub Select_Input()

'

' Select_Input Macro

'




'

   Sheets("STEP 1—ENTER DATA").Select

   Columns("o:o").Select

    Selection.Find(What:="", After:=ActiveCell, LookIn:=xlValues, LookAt _

        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _

        False, SearchFormat:=False).Activate

    ActiveCell.Select

    ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Activate

    ActiveCell.Select

    Range("A3:" & ActiveCell.Address).Select

End Sub

I really don't want to have to start all over or create my own spreadsheet from scratch. Anyone able to help?

09-13-2018 16:27

Hi, 
When I upload new data and hit refresh on the "Report by Grad Year" Tab, only some of the names come up. Sometimes the new names will come up and then disappear like a glitch. How do I get ALL the data imported there? For some of the names, it only shows their last name instead of their full name, even though the master log shows their full name. 
Thanks!

06-02-2018 14:13

Hello, 
I am using the spreadsheet but I get the following error when I go to Step 2 - Import Data to Log:
Microsoft Visual Basic
Run-time error '448':
Name argument not found

It gives me the option to abort or debug. If I select debug it shows me this:
Sub Select_Input()

'

' Select_Input Macro

'




'

   Sheets("STEP 1—ENTER DATA").Select

   Columns("o:o").Select

    Selection.Find(What:="", After:=ActiveCell, LookIn:=xlValues, LookAt _

        :=xlPart, SearchOrder:=xlByRows, SearchDirection:=xlNext, MatchCase:= _

        False, SearchFormat:=False).Activate

    ActiveCell.Select

    ActiveCell.Offset(rowOffset:=0, columnOffset:=0).Activate

    ActiveCell.Select

    Range("A3:" & ActiveCell.Address).Select

End Sub

I have no clue what any of that means. Can someone help, this is such a great resource and I don't want to have to start over from the beginning.

05-24-2018 13:19

There have been a number of questions regarding passwords for the TIPS workbook.

Some password related questions are triggered by people clicking on the "Insert School Name Above" cell on the School ID worksheet. The instruction is literal--if you click on the cell ABOVE this one, you will be able to enter the relevant information and you will not be prompted for a password.

There are instructions for making corrections to the LOG sheet in the introductory video. This should be the only other time one might need a password. After reviewing the introductory video, your questions related to the LOG sheet should be answered.

If you have any other password related questions, please email me directly at bmonk@schooltheatre.org.

Thanks!

05-23-2018 08:00

How come no one is answering the question about the password?  In order to use this, it is asking for a password.  What is the password, please?

05-18-2018 12:40

How do you get the point system?  I put the school's name and the chapter # but never received anything with regards to the points.​

05-10-2018 12:49

Kimberly (and others),

A common issue that I am finding is that on the "School ID" where it asks you to "Insert School Name Above" and "Insert Troupe Name Above" it literally means that you need to click into the cell above the cell with those words. If you click ON the cell WITH the words, it will prompt you for a password.

No password is necessary.

05-09-2018 12:22

I am also getting the password prompt. How do we get it open?

04-26-2018 10:55

I opened the spreadsheet but in order switch off the protection to enable editing I have to enter a password. Do I require a password or am I missing a step?

03-12-2018 13:54

Hi, Joel

Recommended point awards tend to assume a standard production run of a one act or full length show -- one or two weekends. For productions with an extended life thanks to competitions, showcases, etc., you may award additional points for the additional work at your discretion. One way to do that is to calculate a rough number of hours spent on task. That is calculated at 1 Thespian point per 10 hours of quality work. Quality takes caliber of work and educational value of experience into account. Typically, that would not include travel time.

03-09-2018 08:02

Our one act was performed at our school for a full run, won regionals, and went to state.  Do our students get credit for each or do we just mark it at state.  Basically should there info be entered once for school, once for regions, once for state...Or once overall?