1. education
2. school

5/7/2015
5/7/2015
Copyright Macro Connect, Inc.
1
Today’s Focus
•
•
•
•
Welcome and Introductions
Data Staging Area/Certified Reports
Unique Certified Reports
Bonus Slide
Please ask questions!
5/7/2015
Copyright Macro Connect, Inc.
2
1
5/7/2015
Log In Time
We encourage
you to log into
your MSDS
account and
follow along with
us
5/7/2015
https://cepi.state.mi.us/msds
Copyright Macro Connect, Inc.
3
MSDS Reports – The Data Staging Area (Where are they?)
Useful Reports:
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
•
5/7/2015
Alpha List (Pupil Membership) with
FTE > 0
Student Count By Grade or Setting
Gender Race Ethnicity Count
Grade or Setting with Age Data
Student Count by FTE Status
Missing Student Report
Special Education Summary Report
Student Count By Primary
Educational Setting
Primary Disability Count
Missing LEP and Special Ed. Data
Special Education Child Count PEPE
Report
Discipline and Consequence
Summary
Supplemental Nutrition Report
Student Attendance Summary
Report
Homeless Student Summary
Residency Status count
Exit Status Counts
Copyright Macro Connect, Inc.
4
2
5/7/2015
MSDS Reports - The Certified Reports Tab (Where is it?)
• Mostly the same
menu of reports as
found in the Data
Staging Area
• Use this tab for
reports once you
have certified your
data
• Not all reports will
be available in the
Data Staging Area
once you certify
• These reports
refresh overnight
(Report must be
certified by
midnight)
5/7/2015
Copyright Macro Connect, Inc.
5
Alpha List (Pupil Membership) with FTE > 0
•
•
•
This report must be turned in to most counties
Compare these totals with what is in your SIS for accuracy
Great resource to reference any issues that come up in your data
5/7/2015
Copyright Macro Connect, Inc.
6
3
5/7/2015
Alpha List (Pupil Membership) with FTE > 0
Summary Page
5/7/2015
Copyright Macro Connect, Inc.
7
Student Count by Grade or Setting
• Summary count of the
students who were
claimed by grade level by
building
• Grade level breakdown
available for district level
What could be wrong
with this picture?
(Round 1)
5/7/2015
Copyright Macro Connect, Inc.
8
4
5/7/2015
Gender/Race/Ethnicity Count
• Features a break down of
how many students were
coded with each gender
designation and cross
reference with their ethnicity
• Good data quality check to
make sure what was coded in
your district makes sense
• Could be useful when
creating additional reports or
reference for writing grant
proposals
5/7/2015
Copyright Macro Connect, Inc.
9
Grade or Setting with Age Data
This report offers a
breakdown of the age
range of the students in
the grade level that you
reported
What could be wrong
with this picture?
(Round 2)
5/7/2015
Copyright Macro Connect, Inc.
10
5
5/7/2015
Student Count by FTE Status
• Summary count
of students by
FTE status – Both
in Gen. Ed. and
Special Ed.
• Breakdown
available for
district level as
well as
building/grade
level
What could be
wrong with this
picture?
(Round 3)
5/7/2015
Copyright Macro Connect, Inc.
11
Missing Student Report
• These students were
reported as continuing
in a previous collection
and are now not in this
collection without
being exited
• Where did they go?
5/7/2015
Copyright Macro Connect, Inc.
12
6
5/7/2015
www.macroconnect.net
888-578-7976
@MacroConnectEd
Special Education Summary Report
XXXXXXX
David
Price
XXXXXXX
Justin
Verlander
XXXXXXX
Victor
Martinez
J.D.
Martinez
XXXXXXX
Important to Note!
5/7/2015
This Report displays the basic
information for the students
you reported by grade level
Copyright Macro Connect, Inc.
14
7
5/7/2015
Student Count by Primary Educational Setting
• Summary of the
number of Primary
Educational Settings
that were claimed for
Special Ed. students in
the collection
• Use this to confirm that
your data matches!
5/7/2015
Copyright Macro Connect, Inc.
15
Primary Disability Count
• The report
displays a count
of how many
students were
coded with
which
disabilities
• It is a good
report to share
with your SpEd.
Director to
confirm that
the numbers
are correct
5/7/2015
Copyright Macro Connect, Inc.
16
8
5/7/2015
Missing LEP and Special Ed Data
• This report is a summary of students who were previously reported as
receiving Special Ed. or LEP services, but were not coded as such in the
most recent collection
• Check on these students – potential errors exist
5/7/2015
Copyright Macro Connect, Inc.
17
Special Education Child Count PEPE Report
UIC
Student Last First
ID
Name Name
XXXXX
234
XXXXX
235
XXXXX
XXXXX
DOB
Also Reported Also Reported
Grade by District
by Building
PEPE District
J.L. Tech
02
Hockey town
Chelios
Chris 11/13/1999
J.L. Tech
10
Hockey town
236
Helm
Darren 11/14/1999
J.L. Tech
03
Hockey town
237
Probert
Bob
11/15/1999
J.L. Tech
06
Hockey town
XXXXX
238
Grimson
Stu
11/16/1999
J.L. Tech
01
Hockey town
XXXXX
239
Newman Karen 11/17/1999
J.L. Tech
04
Hockey town
XXXXX
240
J.L. Tech
10
Hockey town
5/7/2015
Yzerman Steve 11/12/1999
School
Lindsay
Ted
11/18/1999
Copyright Macro Connect, Inc.
• Primary Education
Providing Entity
(PEPE): An entity
that bears primary
accountability for
a student's
educational
outcomes; can be
a school or a
unique education
provider
• Verify that the
appropriate
districts/schools
that are reporting
these these
students
18
9
5/7/2015
Discipline and Consequence Summary
• Good comparison for
your SIS data
• Get totals for different
types of incidents
• Drill down function
allows you to see student
specifics
5/7/2015
Copyright Macro Connect, Inc.
19
5/7/2015
Copyright Macro Connect, Inc.
20
10
5/7/2015
Supplemental Nutrition Report
• Summary of
the students
who were
claimed as
eligible for
free and
reduced
lunch in this
collection
• Share this
with your
food service
coordinator
5/7/2015
Copyright Macro Connect, Inc.
21
Student Attendance Summary
66
• This report actually gives you two separate sets of data:
Attendance and Enrollment
• This report offers some great information especially if you
track it over a few years
5/7/2015
Copyright Macro Connect, Inc.
What could be
wrong with this
picture? (Round 4)
22
11
5/7/2015
Homeless Student Summary
• This report is a summary of the actual students who were coded as
homeless by building number and grade level
• It also offers a total number of students submitted by district
5/7/2015
Copyright Macro Connect, Inc.
23
Residency Status Count
• This report offers a
count of how many
students were coded
with which residency
codes
• Look for outliers – is
anyone coded in a way
that they shouldn’t be?
5/7/2015
Copyright Macro Connect, Inc.
24
12
5/7/2015
Exit Status Count
• Features a break down of
how many students were
coded with each of the
possible exit codes
• Good data quality check to
make sure what was coded
in your district makes
sense.
• Available as a drill down
report to see specific
students
What could be wrong with this
picture? (final round) hint: this is
a K-5 school
5/7/2015
Copyright Macro Connect, Inc.
25
5/7/2015
Copyright Macro Connect, Inc.
26
13
5/7/2015
Additional Certified Reports: Where are they?
Condensed:
5/7/2015
Expanded:
Copyright Macro Connect, Inc.
27
DS4061/DS4120
• Some of these reports typically due with MSDS
submissions
• Good summary of your submission data
• DS4061/DS4120 – What is the difference?
5/7/2015
Copyright Macro Connect, Inc.
28
14
5/7/2015
DS4061 Special Education Tab
• Provides a
summary of the
programs that you
reported and the
student FTE for
those programs
• This total should
match your
worksheet B
5/7/2015
Copyright Macro Connect, Inc.
29
DS4061 FTE in General Education Tab
Provides a grade level
summary of the
General Education
student FTE
5/7/2015
Copyright Macro Connect, Inc.
30
15
5/7/2015
DS4061
About the General Education and Special Education Tab
+
• After you certify your data,
it should be whole number
• If it is not, then a potential
error exists
5/7/2015
391.31
2.69
394.00
Copyright Macro Connect, Inc.
31
DS4061
Summary Tab
• Good Summary
of the data in
your collection
• Section 25 Net
Adjustments are
updated as
claims are
processed
5/7/2015
Copyright Macro Connect, Inc.
32
16
5/7/2015
FTE Comparison Report
• Provides and FTE comparison between collections
• How could this be useful to you?
5/7/2015
Copyright Macro Connect, Inc.
33
FTE Conflict Detection
• Keep an eye on
this page
following your
data
certification
• Confirm that
the kids who
show up here
are really yours
and not just a
similar named
student
• Work with
each other to
resolve these
issues
5/7/2015
Copyright Macro Connect, Inc.
34
17
5/7/2015
FTE Conflict Detection: Who you gonna call?
• MSDS keeps a list for
you!
• Some names may be
old, but most of the
phone numbers are
still good
5/7/2015
Copyright Macro Connect, Inc.
35
Cohort Summary by Year
This report is
useful for tracking
your graduation
cohort groups to
make sure they
have been
coded/exited
correctly
5/7/2015
Copyright Macro Connect, Inc.
36
18
5/7/2015
Direct Certification Student Status
Summary of all students who are directly certified
5/7/2015
Copyright Macro Connect, Inc.
37
Economically Disadvantaged
• Summary of what has been reported in your
building/district
• Maybe useful with grants and other reporting
5/7/2015
Copyright Macro Connect, Inc.
38
19
5/7/2015
Details for All Reports
(https://cepi.state.mi.us/msds)
5/7/2015
Copyright Macro Connect, Inc.
39
Bonus Material! Section 25 reports
• Keep tabs on the students that you claimed – make sure they
are processed correctly
• Just as important – keep tabs on the students others are
claiming:
• Did those students officially drop?
• Did they file the paperwork on time?
5/7/2015
Copyright Macro Connect, Inc.
40
20
5/7/2015
christian.anderson@macroconnect.net
paul.cameron@macroconnect.net
5/7/2015
Copyright Macro Connect, Inc.
41
21