[go: up one dir, main page]
Scribd
Upload
280 views1 page

ICF 7 TOS - 3rd Quarter

The document provides a table of specifications for a Grade 7 test in ICF 7 for the third quarter of the 2022-2023 school year. The test will have 35 total items worth 35 total points, assessing students on their knowledge of Microsoft Excel. It will include 21 items testing students' remembering abilities, 7 items on understanding, and 7 items on applying knowledge. The test covers topics like the basic Excel environment, creating and sharing workbooks, Excel formulas and functions, and creating and troubleshooting basic formulas. It was prepared by Teacher III Sheine N. Matos and approved by Principal II Gerry E. Llimit.

Uploaded by

Sheine Nasayao Matos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
280 views1 page

ICF 7 TOS - 3rd Quarter

The document provides a table of specifications for a Grade 7 test in ICF 7 for the third quarter of the 2022-2023 school year. The test will have 35 total items worth 35 total points, assessing students on their knowledge of Microsoft Excel. It will include 21 items testing students' remembering abilities, 7 items on understanding, and 7 items on applying knowledge. The test covers topics like the basic Excel environment, creating and sharing workbooks, Excel formulas and functions, and creating and troubleshooting basic formulas. It was prepared by Teacher III Sheine N. Matos and approved by Principal II Gerry E. Llimit.

Uploaded by

Sheine Nasayao Matos
Copyright
© © All Rights Reserved
We take content rights seriously. If you suspect this is your content, claim it here.
Available Formats
Download as XLSX, PDF, TXT or read online on Scribd
You are on page 1/ 1

TABLE OF SPECIFICATIONS

School Year 2022-2023

Quarter Third Learning Area ICF 7


Test Date April 19-20, 2023 Grade Level Grade 7
Total Items 35 Total Points 35 Curriculum K to 12 - STVEP

No. of LEVEL OF ASSESSMENT


Knowledge Process Understanding

UNDERSTANDING
MOST ESSENTIAL

REMEMBERING
LEARNING Time Total No. Test

EVALUATING
CONTENT

ANALYZING
Spent

CREATING
COMPETENCY/IES or of Items Type

APPLYING
Items
OBJECTIVES (hrs/
mins)

60% 20% 20%


ITEM PLACEMENT/ALLOCATION
1. Define Microsoft Excel
2 4 1 4 15 2 4 MC
Learning the Basic of
2. Label the Microsoft Excel Microsoft Excel
Environment; 3 7 7 10 12 3 5 6 11 7 MC

3. Identify ways to create,


open, save and share 2 4 13 14 8 22 4 MC
workbooks;
Creating, Opening,
Saving & Sharing
4. Perform creating new,
Workbooks
opening existing, saving 2 4 23 35 17 33 4 MC
and sharing workbooks

5. Know the Excel formula


and common functions. 3 7 9 16 30 24 25 20 21 7 MC
Formulas and
6. Create and troubleshoot a Functions
basic formula and 4 9 26 27 28 29 31 32 18 19 34 9 MC
functions.

TOTAL 16 35 21 7 7 35

Prepared by: Noted by:

SHEINE N. MATOS EMETERIA D. LOREN


Teacher III HT-II/Academic Department Head

Checked and Approved by:

GERRY E. LLIMIT, PhD


Principal II

You might also like