Getting to know your Team Member
Academic
Attendance
Enrollment
Excel/SQL
100

Who has the biggest cat and how big is he?

Kelly and paxton is 21 lbs.

100

What is GCA's assessment completion goal?

95%

100

What is the name of the outside program we use for attendance?

Nucleus

100

Does GCA use a lottery system for registration?

YES

100

What is the single most important thing that teachers need to learn about accessing the k12 report (or any of our reports on the google drive)

RIGHT CLICK and DOWNLOAD

200

Who on our team used to be a special education teacher?

Mallory

200

How many periods are in GCA's schedule?

7

200

Nucleus reports can be found in what platform?

Power Bi - but make sure what you are pulling is less than 150,000
200

Every student needs a _____ to be considered active and on reports and have a schedule.

Line of Enrollment (LOE)

200

Name 2 out of the 4 types of joins in SQL.

Right, Inner, Left, Full Outer

300

Who lives in Newnan, GA?

Jen

300

What EOC are High School students required to take?

Algebra, Biology, US History, and American Lit

300

Does nucleus catch all watched recordings or do we still need to check behind them?

We still need to check, especially for LIFE students.

300

The busiest time of the enrollment period is called _______. 

Re-Registration

300

When do we need to password protect our spreadsheets/reports?

When emailing and attaching to zendesk. Posting on Google Drive is secure (no password needed)

400

Who got married at a 'Braves' ballpark?

Rachel

400

What EOGs are 5th graders required to take?

English, Math and Science

400

What is the report that the SAC team needs daily in order to send their notifications and communication with families about attendance?

SAC MM report

400

What are the age requirements for enrollment?

5 by 9/1 of the year entering KK and 21 unless SPED, then 22.

400

What does this excel error mean: The pivot table name is not valid. To create a PivotTable, you must use data that is organized as a list with labeled columns.

You have an unnamed column in the data that you selected to make a PivotTable from. 

500

Who is our 'in house' tax consultant?

Lauren T

500

WriteScore is given twice a school year. Are the two administrations measuring the same content?

No, one administration is persuasive writing and one is expository writing. 

500

What is the Attendance Board Report and how is it used? (there are two ways it is used)

It is a monthly report that shows the attendance rate per course for each student. We use it for the Board Report metrics and also for Compliance/Participation Grades in the academic part.

500

Who is the queen of enrollment? (and it isn't Christy P)

Zola

500

What is the difference between CHAR and VARCHAR2 in SQL?

Both Char and Varchar2 are used for characters datatype but varchar2 is used for character strings of variable length whereas Char is used for strings of fixed length.