Excel
CPIN
Power Point
Miscellaneous
Ministry Standards
100

The tab that contains the "freeze cells" option?

What is the view tab

100

This record houses all the medical information for a CIC. 

What is the medical tab in the person record.

100

The New Slide command on the ribbon lets you choose what?

What is the slide layouts.

100

These are housed in Policy Tech

What are policies, procedures and process maps

100

This is when a child or youths rights and responsibilities have to be reviewed with them within the first year of their placement.

What is within 24 hours, within 30 days, within 90 days, within 180 day and every 180 days after that.


200

The formula used to count the total of unique character(s) in one column?

What is "=countif(range,"character(s)".

200

Where you see all the members of a case?

What is go to the family view.

200

If a co-worker doesn't have power point, and you want to share a power point presentation, what is the best way to ensure everyone will still be able to view the presentation?

What is export your file as a PDF.

200

Accountability and Strategic  Initiatives

What is the former name of the Strategic Data Intelligence Branch

200

After admission, this is the next time that a worker is responsible for visiting a child in care.

What is at 7 days after the placement date

300

How do you remove duplicates in a column?

What is: "go to the data tab, data tools, and select remove duplicates"

300

This is where saved Serious Occurrence reports can be found? 

What is the issues and proceedings tab in the person record.

300

True or false, you can set up a presentation to run automatically? 

What is True

300
SOR-RL

What is the secure site that we submit Serious Occurrence Reports to

300

This is the age when the Ministry standard expects that a child/youth needs to start seeing a dentist and eye doctor.

What is age 2.

400

What is conditional formatting?

What is: "Conditional formatting is a feature in many spreadsheet applications that allows you to apply specific formatting to cells that meet certain criteria. It is most often used as color-based formatting to highlight, emphasize, or differentiate among data and information stored in a spreadsheet"

400

This is where you locate the legal status of a child in care?

What is the Legal tab/legal status sub tab of the child welfare case

400

If you add background music and want it to continue playing for the entire presentation, which feature do you use?

What is "play across slides"

400

The three main service branches

What are AA, PACCB and Permanency

400

This assessment is required within 72 hours of a child or youth coming into care/new placement.

What is a medical admission.

500

To make a cell address "absolute", you add this:

What is adding the "$" before the cell reference.

500

This is where you would find a Child in Care's 'Ontario Education Number', 'Health Card Number'?

What is the identity tab, alternative ID's sub tab

500

What is a motion path?

What is an animation that moves an object along a path.

500

Brenda

Who is our fearless champion!

500

This is how often a social history needs to be completed.

What is within 60 days from admission and then every year after that.