📄 النص الكامل للصفحة
{
"language": "ar",
"direction": "rtl",
"page_context": {
"page_title": "تطبيق التحقق من صحة البيانات في إكسل",
"page_type": "lesson_content",
"main_topics": [
"التحقق من صحة البيانات في إكسل",
"رسالة الإدخال",
"تنبيه إلى الخطأ"
],
"headers": [
"لتطبيق التحقق من صحة البحث والتواجد في إكسل",
"لتعيين رسالة إدخال",
"لتعيين رسالة خطأ"
],
"has_questions": false,
"has_formulas": false,
"has_examples": true,
"has_visual_elements": true
},
"sections": [
{
"order": 1,
"type": "header",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "لتطبيق التحقق من صحة البحث والتواجد في إكسل:"
},
{
"order": 2,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "1",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "من نافذة تحقق من صحة البيانات (Data Validation)،"
},
{
"order": 3,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "2",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "اختر علامة التبويب إعدادات (Settings)."
},
{
"order": 4,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "3",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "من مربع السماح (Allow)، اختر قائمة (List)."
},
{
"order": 5,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "4",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "من مربع المصدر (Source)، اكتب أسماء الأشهر وافصل بين كل واحد والآخر بفاصلة منقوطة "؛"."
},
{
"order": 6,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "5",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "ألغ تحديد خيار تجاهل الفراغ (Ignore Blank)."
},
{
"order": 7,
"type": "sidebar",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "من المهم جداً منع المستخدم من إدخال نوع خاص من البيانات، ولهذا الغرض تضع رسائل تنبيه إلى الخطأ وإدخال غير صالح لتذكير المستخدم أثناء عملية إدخال البيانات."
},
{
"order": 8,
"type": "sidebar",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "لإدخال قائمة الشهور باللغة العربية مفصولة بفاصلة منقوطة، عليك أن تقوم بإدخال الأشهر باللغة العربية وتحويل اللغة إلى اللغة الإنجليزية عند إدخال الفاصلة المنقوطة."
},
{
"order": 9,
"type": "main_content",
"content_classification": "FIGURE_REFERENCE",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"title": "الشكل 2.22",
"content": "الشكل 2.22: تطبيق التحقق من صحة التواجد والبحث في إكسل",
"associated_visual_elements": [
0
]
},
{
"order": 10,
"type": "main_content",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "يتم التحقق من التواجد عندما تلقي تحديد الخيار تجاهل الفراغ (Ignore Blank)."
},
{
"order": 11,
"type": "main_content",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "يتم التحقق من التواجد عندما تضيف أسماء الأشهر في مربع المصدر (Source)."
},
{
"order": 12,
"type": "header",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "لتعيين رسالة إدخال:"
},
{
"order": 13,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "1",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "من نافذة تحقق من صحة البيانات (Data Validation)"
},
{
"order": 14,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "2",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "اختر علامة التبويب رسالة إدخال (Input Message)."
},
{
"order": 15,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "3",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "في مربع العنوان: (Title)، اكتب "إرشادات إدخال البيانات"."
},
{
"order": 16,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "4",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "في مربع رسالة إدخال (Input message)، اكتب "اختر أحد الأشهر من القائمة"."
},
{
"order": 17,
"type": "main_content",
"content_classification": "FIGURE_REFERENCE",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"title": "الشكل 2.23",
"content": "الشكل 2.23: تعيين رسالة إدخال غير صالح",
"associated_visual_elements": [
1
]
},
{
"order": 18,
"type": "header",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "لتعيين رسالة خطأ:"
},
{
"order": 19,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "1",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "من نافذة تحقق من صحة البيانات (Data Validation)"
},
{
"order": 20,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "2",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "اختر علامة التبويب تنبيه إلى خطأ (Error Alert)."
},
{
"order": 21,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "3",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "من مربع النمط (Style)، اختر إيقاف (Stop)."
},
{
"order": 22,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "4",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "في مربع العنوان: (Title)، اكتب "المدخلات غير صالحة"."
},
{
"order": 23,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "5",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "في مربع رسالة خطأ (Error message)، اكتب "يجب أن تختار أحد الأشهر من القائمة"."
},
{
"order": 24,
"type": "exercise",
"content_classification": "EDUCATIONAL_CONTENT",
"question_indicators": {
"has_question_words": false,
"has_numbering": true,
"question_number": "6",
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": true
},
"content": "اضغط على موافق (OK)."
},
{
"order": 25,
"type": "main_content",
"content_classification": "FIGURE_REFERENCE",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"title": "الشكل 2.24",
"content": "الشكل 2.24: تعيين رسالة تنبيه إلى الخطأ",
"associated_visual_elements": [
2
]
},
{
"order": 26,
"type": "main_content",
"content_classification": "METADATA",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "وزارة التعليم\nMinistry of Education\n2025 - 1447"
},
{
"order": 27,
"type": "main_content",
"content_classification": "METADATA",
"question_indicators": {
"has_question_words": false,
"has_numbering": false,
"has_multiple_choice": false,
"has_fill_in_blank": false,
"has_instruction_words": false
},
"content": "70"
}
],
"visual_elements": [
{
"index": 0,
"label": "الشكل 2.22",
"question_number": "2.22",
"type": "figure",
"location": "top-center of page",
"title": "تحقق من صحة البيانات",
"description": "A screenshot of an Excel 'Data Validation' dialog box, specifically the 'Settings' tab. The dialog title is 'تحقق من صحة البيانات' (Data Validation). It has three tabs: 'إعدادات' (Settings), 'رسالة إدخال' (Input Message), and 'تنبيه إلى الخطأ' (Error Alert). The 'إعدادات' tab is active. Under 'معيار التحقق من الصحة' (Validation criteria), the 'السماح:' (Allow:) dropdown is set to 'قائمة' (List). The 'البيانات:' (Data:) dropdown is also set to 'قائمة'. The 'المصدر:' (Source:) text box contains a semicolon-separated list of Arabic month names: 'يناير؛فبراير؛مارس؛أبريل؛مايو؛يونيو؛يوليو؛أغسطس؛سبتمبر؛أكتوبر؛نوفمبر؛ديسمبر'. The 'تجاهل الفراغ' (Ignore Blank) checkbox is unchecked. There is another checkbox labeled 'تطبيق هذه التغييرات على كافة الخلايا الأخرى ذات الإعدادات المشابهة' (Apply these changes to all other cells with similar settings). The dialog has 'موافق' (OK), 'إلغاء الأمر' (Cancel), and 'مسح الكل' (Clear All) buttons. Numbered callouts point to: 1) The dialog title, 2) The tabs, 3) The 'السماح' dropdown, 4) The 'المصدر' text box, 5) The 'تجاهل الفراغ' checkbox.",
"educational_context": "Illustrates the steps for setting up data validation with a list of months in Excel, as described in the preceding numbered instructions."
},
{
"index": 1,
"label": "الشكل 2.23",
"question_number": "2.23",
"type": "figure",
"location": "middle-center of page",
"title": "تحقق من صحة البيانات",
"description": "A screenshot of an Excel 'Data Validation' dialog box, specifically the 'Input Message' tab. The dialog title is 'تحقق من صحة البيانات' (Data Validation). It has three tabs: 'إعدادات' (Settings), 'رسالة إدخال' (Input Message), and 'تنبيه إلى الخطأ' (Error Alert). The 'رسالة إدخال' tab is active. The checkbox 'إظهار رسالة الإدخال عند تحديد الخلية' (Show input message when cell is selected) is checked. The 'العنوان:' (Title:) text box contains 'إرشادات إدخال البيانات' (Data Input Guidelines). The 'رسالة الإدخال:' (Input message:) text box contains 'اختر أحد الأشهر من القائمة' (Choose one of the months from the list). The dialog has 'موافق' (OK), 'إلغاء الأمر' (Cancel), and 'مسح الكل' (Clear All) buttons. Numbered callouts point to: 1) The dialog title, 2) The tabs, 3) The 'العنوان' text box, 4) The 'رسالة الإدخال' text box.",
"educational_context": "Illustrates the steps for configuring an input message that appears when a cell with data validation is selected, as described in the preceding numbered instructions."
},
{
"index": 2,
"label": "الشكل 2.24",
"question_number": "2.24",
"type": "figure",
"location": "bottom-center of page",
"title": "تحقق من صحة البيانات",
"description": "A screenshot of an Excel 'Data Validation' dialog box, specifically the 'Error Alert' tab. The dialog title is 'تحقق من صحة البيانات' (Data Validation). It has three tabs: 'إعدادات' (Settings), 'رسالة إدخال' (Input Message), and 'تنبيه إلى الخطأ' (Error Alert). The 'تنبيه إلى الخطأ' tab is active. The checkbox 'إظهار التنبيه إلى الخطأ بعد إدخال بيانات غير صحيحة' (Show error alert after invalid data is entered) is checked. The 'النمط:' (Style:) dropdown is set to 'إيقاف' (Stop), indicated by a red 'X' icon. The 'العنوان:' (Title:) text box contains 'المدخلات غير صالحة' (Invalid Inputs). The 'رسالة خطأ:' (Error message:) text box contains 'يجب أن تختار أحد الأشهر من القائمة' (You must choose one of the months from the list). The dialog has 'موافق' (OK), 'إلغاء الأمر' (Cancel), and 'مسح الكل' (Clear All) buttons. Numbered callouts point to: 1) The dialog title, 2) The tabs, 3) The 'النمط' dropdown, 4) The 'العنوان' text box, 5) The 'رسالة خطأ' text box, 6) The 'موافق' button.",
"educational_context": "Illustrates the steps for configuring an error alert message that appears when a user enters invalid data into a cell with data validation, as described in the preceding numbered instructions."
}
]
}