Webinar on the IPCRF Data Collection

System for SY 2019-2020

IPCRF E-Tool SY 2019-2020

1
 ABOUT THE TOOL

Microsoft Excel Macro-Enabled Workbook File (.xlsm)

IPCRF Parts 1-4 Templates

Part 1: COT & IPCRF ratings data collection

Part 2: Core Behavioral Competencies data collection

DEPARTMENT OF EDUCATION
 ROLES

RATER RATEE

DEPARTMENT OF EDUCATION 3
 Simplified Flowchart
RATER RATEE

1. Downloads the IPCRF e-tool

2. Encodes ratees’ data
3. Encodes Part 1 (COT & QET
ratings)
4. Encodes Part 2 & 4
5. Uploads file to submission
system (for School Heads)

DEPARTMENT OF EDUCATION 4
 Rater

DEPARTMENT OF EDUCATION 5
 Step 1. Download IPCRF e-Tool
1. Download from the official Google Drive link
2. Extract from the ZIP file

DEPARTMENT OF EDUCATION 6
 1.1 Download
deped.in/IPCRFEncode20192020

DEPARTMENT OF EDUCATION
 1.1 Download
deped.in/IPCRFEncode20192020

DEPARTMENT OF EDUCATION
 1.1 Download
deped.in/IPCRFEncode20192020

DEPARTMENT OF EDUCATION
1.2 Extract (Unzip)
• DO NOT OPEN THE
IPCRF EXCEL TOOL
WITHOUT FIRST
EXTRACTING IT
FROM THE ZIP FILE

DEPARTMENT OF EDUCATION 10
1.2 Extract (Unzip, Method A)

Right-click

DEPARTMENT OF EDUCATION 11
 1.2 Extract (Unzip, Method A)

click

DEPARTMENT OF EDUCATION 12
1.2 Extract (Unzip, Method A)

click
DEPARTMENT OF EDUCATION 13
1.2 Extract (Unzip, Method A)

DEPARTMENT OF EDUCATION 14
1.2 Extract (Unzip, Method B)

Double-click

DEPARTMENT OF EDUCATION 15
1.2 Extract (Unzip, Method B)

Drag-and-drop
to Desktop

DEPARTMENT OF EDUCATION 16
 Progress
RATER RATEE

1. Downloads the IPCRF e-tool

2. Encodes ratees’ data
3. Encodes Part 1 (COT &
IPCRF ratings)
4. Encodes Part 2 & 4
5. Uploads file to submission
system (for School Heads)

DEPARTMENT OF EDUCATION 17
 Step 2. Encode Ratee’s Data
1. Open the Excel IPCRF e-Tool
2. Enable Editing
3. Enable Macros
4. Encode School’s Data
5. Encode Rater’s Data
6. Make Copies
7. Encode Ratee’s Data

DEPARTMENT OF EDUCATION 18
 2.1 Open
DO DON’T

Mobile phones
Laptops / Tablets (Android, iOS)
(Windows, macOS X)

Tablets
(Android, iPadOS, Windows RT)

Desktop PCs
(Windows, macOS X) Chromebooks /
Windows RT

DEPARTMENT OF EDUCATION 19
 2.1 Open
DO DON’T
Numbers

MS Office Excel 2008

MS Office Excel 2011

Microsoft Office Excel (Desktop): Google Sheets

• 2010
• 2013
• 2016 + WPS Office Spreadsheet
• 2019 +
• 365 +
LibreOffice Calc

OpenOffice Calc
DEPARTMENT OF EDUCATION 20
2.2 Enable Editing

DEPARTMENT OF EDUCATION 21
2.2 Enable Editing

DEPARTMENT OF EDUCATION 22
2.2 Enable Editing

DEPARTMENT OF EDUCATION 23
2.3.a Enable Content (Macros)

DEPARTMENT OF EDUCATION 24
2.3.a Enable Content (Macros)

DEPARTMENT OF EDUCATION 25
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 26
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 27
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 28
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 29
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 30
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 31
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 32
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 33
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 34
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 35
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 36
2.3.b Enable Content (Macros)

DEPARTMENT OF EDUCATION 37
2.3.b Enable Content (Macros)

Close ALL open Excel Workbooks & Restart Excel

DEPARTMENT OF EDUCATION 38
2.4 Encode Ratee/Rater’s Data

DEPARTMENT OF EDUCATION 39
Tabs/Sheets

DEPARTMENT OF EDUCATION 40
 Tabs/Sheets
Properties
Encoding Part 1 Part 2 Part 3 Part 4

Editable

Protected

Printable

DEPARTMENT OF EDUCATION 41
Encoding tab

DEPARTMENT OF EDUCATION 42
Encoding tab

DEPARTMENT OF EDUCATION 43
Encoding tab

DEPARTMENT OF EDUCATION 44
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 45
2.4 Encode School’s Data

Options depend on selected

DEPARTMENT OF EDUCATION 46
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 47
2.4 Encode School’s Data

Accepts only valid DepEd 6-digit School IDs from 100000 to 699999

DEPARTMENT OF EDUCATION 48
2.4 Encode School’s Data

Complete & proper name of school

DEPARTMENT OF EDUCATION 49
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 50
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 51
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 52
2.4 Encode School’s Data

DEPARTMENT OF EDUCATION 53
2.5 Encode Rater’s Data

DEPARTMENT OF EDUCATION 54
2.5 Encode Rater’s Data

Name of rater
Format: Last, First M.I.

DEPARTMENT OF EDUCATION 55
2.5 Encode Rater’s Data

DEPARTMENT OF EDUCATION 56
 2.5 Encode Rater’s Data

Date of review
Accepts dates from Feb. 2020 onwards
Save the file (ctrl + s) then close the workbook
Format: yyyy-mm-dd

DEPARTMENT OF EDUCATION 57
2.6 Make copies

Include name of RATEE in the filename

DEPARTMENT OF EDUCATION 58
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 59
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 60
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 61
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 62
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 63
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 64
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 65
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 66
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 67
 2.7 Encode Ratee’s Data

Options depend on selected Curricular Classification

DEPARTMENT OF EDUCATION 68
 2.7 Encode Ratee’s Data

Options depend on selected Level Taught

Selecting ALS in the Subject Taught

disables this field

DEPARTMENT OF EDUCATION 69
 2.7 Encode Ratee’s Data

Selecting SHS in Level Taught

changes this to Strand

DEPARTMENT OF EDUCATION 70
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 71
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 72
2.7 Encode Ratee’s Data

DEPARTMENT OF EDUCATION 73
 Progress
RATER RATEE

1. Downloads the IPCRF e-tool

2. Encodes ratees’ data
3. Encodes Part 1 (COT &
IPCRF ratings)
4. Encodes Part 2 & 4
5. Uploads file to submission
system (for School Heads)

DEPARTMENT OF EDUCATION 74
 Step 3. Encode Ratings
1. Encode COT ratings
2. Encode QET ratings
3. Finalize Part 1

DEPARTMENT OF EDUCATION 75
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 76
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 77
 3.1 Encode COT ratings

Rating: RPMS 5-pt Scale:

Proficient = 3-7 Automatically populated
Highly Proficient = 4-8 based on Rating input

Date of observation:
Format: yyyy-mm-dd
Accepts dates beginning June 3, 2019
DEPARTMENT OF EDUCATION 78
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 79
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 80
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 81
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 82
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 83
3.1 Encode COT ratings

DEPARTMENT OF EDUCATION 84
3.2 Encode QET ratings

DEPARTMENT OF EDUCATION 85
3.2 Encode QET ratings

QET Numerical Ratings:

Accepts whole numbers 1-5

DEPARTMENT OF EDUCATION 86
3.3 Finalize Part 1

DEPARTMENT OF EDUCATION 87
3.3 Finalize Part 1

DEPARTMENT OF EDUCATION 88
3.3 Finalize Part 1

DEPARTMENT OF EDUCATION 89
 TRANSFER

RATER RATEE

DEPARTMENT OF EDUCATION 90
 Progress
RATER RATEE

1. Downloads the IPCRF e-tool

2. Encodes ratees’ data
3. Encodes Part 1 (COT &
IPCRF ratings)
4. Encodes Part 2 & 4
5. Uploads file to submission
system (for School Heads)

DEPARTMENT OF EDUCATION 91
 Step 4. Encode Parts 2 & 4
1. Finalize Part 2
2. Finalize Part 4

DEPARTMENT OF EDUCATION 92
4.1 Finalize Part 2

DEPARTMENT OF EDUCATION 93
4.1 Finalize Part 2

DEPARTMENT OF EDUCATION 94
4.2 Finalize Part 4

DEPARTMENT OF EDUCATION 95
4.2 Finalize Part 4

DEPARTMENT OF EDUCATION 96
 Progress
RATER RATEE

1. Downloads the IPCRF e-tool

2. Encodes ratees’ data
3. Encodes Part 1 (COT &
IPCRF ratings)
4. Encodes Part 2 & 4
5. Uploads file to submission
system (for School Heads)

DEPARTMENT OF EDUCATION 97
 TRANSFER

RATER RATEE

DEPARTMENT OF EDUCATION 98
THANK YOU!

DEPARTMENT OF EDUCATION 99