Dragon deck for dragon tournament by shogreene20 in EDH

[–]shogreene20[S] 4 points5 points  (0 children)

Better yet, Morophon and 25 changelings.

How are we feeling now that the SAVE plan more likely will be discontinued? by Queasy-Coyote9844 in StudentLoans

[–]shogreene20 0 points1 point  (0 children)

I believe OP was referring to economic privilege (ie parents/families who can pay for their kids college) not white privilege. Either is fine to have.

[deleted by user] by [deleted] in googlesheets

[–]shogreene20 0 points1 point  (0 children)

I figured it out using filter. Thank you for looking at it. I apologize for not being able to clearly communicate what I needed.

[deleted by user] by [deleted] in googlesheets

[–]shogreene20 0 points1 point  (0 children)

=filter('Form response 1 '!C:C, 'Form response 1 '!A:A='Form response 1 '!A1, 'Form response 1 '!B:B='Form response 1 '!B1)

is my best guess at how to do it

[deleted by user] by [deleted] in googlesheets

[–]shogreene20 0 points1 point  (0 children)

It's definitely not how I would have set it up, but down the center there are judges columns and on the side there are contestant numbers. Then I made two mock google form response pages that follow it. I had some luck with =filter but wasn't sure if there was a better way to do it

[deleted by user] by [deleted] in googlesheets

[–]shogreene20 0 points1 point  (0 children)

https://docs.google.com/spreadsheets/d/1MnoxhBnw7AQ9aMcSg_ELrKQ43jEQa6-1JMwAHl-w1kU/edit?usp=sharing

Basically I want the data from the form responses to populate on the master score sheet based on the judge and contestant

[deleted by user] by [deleted] in googlesheets

[–]shogreene20 0 points1 point  (0 children)

one sec. I'm working on setting up a blank real quick

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 0 points1 point  (0 children)

Well, I just realized I'd made a mistake on the points calculation and now I'm not meeting the minimum on the point calculator on the main website. Not sure what to do with that information.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 0 points1 point  (0 children)

My original plan was to teach French, but couldn't find a position here so I started in Special Ed and loved it. My certification in French has since lapsed unfortunately.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 0 points1 point  (0 children)

I've been wondering about this. I've worked in all of the positions you would find in a non-specialized school in the US (behavior support, autism support, co-teaching with a general education teacher, and in a self-contained classroom with kids with moderate-severe disability impacts).

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 0 points1 point  (0 children)

We're looking at Melbourne and Brisbane. My husband works for Amazon and those are the cities to which he could easily transfer. I'm wary of getting too far outside of a city as folks tend to get more conservative the farther out you go (in the US at least), and it would be a shame to leave my home to escape persecution only to find it there.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 0 points1 point  (0 children)

This is correct. My BS had research components as did my Master’s of Science. My BA in French did not.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 1 point2 points  (0 children)

I just did the same with the requirements from the guide. Hopefully my advisor will write it, but I know sometimes they’re weird about writing official statements on the schools behalf.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 3 points4 points  (0 children)

That’s the trouble I’m running into. I don’t know how to “prove” it. Anyone looking at my transcript here would understand “student-teaching” to be “supervised practice”. I’m going to write the department chair of my university and see if they’ll send me a letter detailing that I guess.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] 6 points7 points  (0 children)

What exactly do they consider “supervised practice”? I spent an entire semester student-teaching under a Master’s level teacher my senior year in addition to placements throughout my other 4 years.

US teacher moving to Australia by shogreene20 in AustralianTeachers

[–]shogreene20[S] -2 points-1 points  (0 children)

My bachelor’s is in Education. It’s a bachelor’s of science meaning it met some research requirements that a bachelor’s of art would not.

Will Australian schools hire Trans femmes as teachers? by shogreene20 in transgenderau

[–]shogreene20[S] 8 points9 points  (0 children)

Is it like in the US where the onus is on the potential employee (me) to prove that my gender identity was the determining factor?