Priority for service
MSIS reports
Excel Basic
Formulas & Functions
100

Migratory children need to make a qualifying move within what time period?

1 year 

100

This report list migrant children who are failing, or most at risk of failing, to meet the state challenging state academic content standards and challenging state student academic achievement standards, and whose education has been interrupted during the regular school year

What is Priority for Service Student List 

100

This type of cell entry can contain letters and symbols, not just numbers.

What is text?

100

This function adds up a range of numbers.

What is SUM?

200

According to Criterion 2, MEP children can qualify as PFS if they?

Are failing, or most at risk of failing to meet state challenging academic standards or dropped out of school 
200

This report provides data results for the identified risk factors used to determine Priority for Service (PFS)

What is Student Needs Assessment List 

200

You can use this tool to arrange your data in alphabetical or numerical order.

What is the Sort function?

200

This function finds the average of a range.

What is AVERAGE?

300

True of false, a student will qualify as PFS if there attendance is less than 75% of days enrolled 

False, a student will qualify as PFS if attendance is less than 90% of days enrolled. 

300

This report shows the courses offered in a district and the number of migrant students that did not pass each course.

What is the Commonly Failed Course Report 

300

This feature allows you to view only the rows that meet certain criteria.

What is Filter?

300

This function counts the number of cells that contain numbers.

What is COUNT?

400

True or false, the student will qualify as PFS if they are not grade age compatible and does not match the acceptable range for grade level placement within 1 year

False,  Grade Age Compatible (Over Age for Grade)-age does not match acceptable range for grade level placement within 2 years.

400

This report summarizes supplemental services by student 

What is the Student Supplemental Service Report 

400

You can summarize totals by category using this feature.

What is a PivotTable or Subtotal?

400

This function checks whether a condition is true or false.

What is IF?

500

A student will qualify for PFS if the total days enrolled in a WA state school is fewer than?

What is 90 days

500

This report lists all migrant student services provided to a student

What is MGS & MSA Online Service Report 

500

You can use this feature to visually represent trends and comparisons in data.

What is a chart or graph?

500

This Excel tool can be used to create interactive visual dashboards using slicers and pivot charts.

What is a PivotTable?

M
e
n
u