ARRANGE AND DATA MANAGEMENT IN MS EXCEL.pptx

CREATIVE TECHNOLOGY 8

1. ARRANGE AND DATA MANAGEMENT IN MS EXCEL DAY 2 WEEK 1 Q2

2. LEARNING OBJECTIVES 2 Encode given data correctly in MS Excel. Apply sorting and filtering to organize data. Use basic formatting tools to make the spreadsheet clear and presentable. Explain the importance of arranging and managing data properly.

3. ENTERING DATA IN ROW AND COLUMNS 3 Rows run horizontally (left to right) and are numbered (1, 2, 3…). Columns run vertically (up and down) and are labeled with letters (A, B, C…).

4. Sorting Data (Alphabetical and Numerical) 4 Sorting means arranging information in order so it is easier to find patterns.

5. Filtering Data (Show Only Specific Entries) 5 Filtering allows us to temporarily hide other data and see only what we need. Filtering does not delete data, it only hides what you don’t need temporarily.

6. Formatting Data (Make It Neat and Presentable) 6 Formatting makes data easier to read and understand.

7. DATA SETS 7 NAME SECTION FAVORITE SUBJECT AGE Angela 7–Maple Math 12 Bryan 7–Oak English 13 Christine 7–Maple Science 12 David 7–Cedar Math 13 Ella 7–Oak Filipino 12 Francis 7–Cedar Science 13

8. INSTRUCTION: 8 Sort names (A–Z). Sort by age. Filter students by favorite subject. Filter students by section. Format the table (headings bold + shaded, borders applied).

9. GUIDE QUESTIONS: 9 Who is the youngest student? How many students like Science? Which section has the most entries? Why is sorting and filtering useful in data management?