Objective: هدف:
The objective of this project is to create a comprehensive digital platform that showcases tourist places in Egypt.
الهدف من هذا المشروع هو إنشاء منصة رقمية شاملة تعرض الأماكن السياحية في مصر.
This platform will include:
ستشمل هذه المنصة:
- A Google Sheet to organize information about various tourist spots.
ورقة جوجل لتنظيم المعلومات حول المواقع السياحية المختلفة.
- A Google Slides presentation to highlight key details of selected places.
عرض تقديمي من Google Slides لتسليط الضوء على التفاصيل الأساسية للأماكن المحددة.
- A Wireframe.cc to design the pages before creating them on a MIT App Inventor application to provide an interactive experience for users by incorporating images and audio narration.
Wireframe.cc لتصميم الصفحات قبل إنشائها على تطبيق MIT App Inventor لتوفير تجربة تفاعلية للمستخدمين من خلال دمج الصور والسرد الصوتي.
Task 1: Google Sheet for Tourist Places in Egypt
المهمة 1: ورقة جوجل للأماكن السياحية في مصر
Task Details: تفاصيل المهمة:
1- Name of file: use the naming convention: (Student ID-Egypt).
1- اسم الملف: استخدم اصطلاح التسمية: (هوية الطالب - مصر).
2- Create a Google Sheet file titled: “Travel to Egypt”.
2- إنشاء ملف Google Sheet بعنوان: "السفر إلى مصر".
3- Add columns for the name of the tourist place, the government where it is located, ticket price and any additional information such as government regulations or historical significance or visiting hours.
3- إضافة أعمدة لاسم المكان السياحي والحكومة التي يقع فيها وسعر التذكرة وأي معلومات إضافية مثل اللوائح الحكومية أو الأهمية التاريخية أو ساعات الزيارة.
4- Research and fill the Google Sheet with information about at least 20 tourist places in Egypt, ensuring accuracy and relevance.
4- البحث واملأ ورقة Google بمعلومات حول ما لا يقل عن 20 مكانا سياحيا في مصر ، مما يضمن الدقة والملاءمة.
5- Use sorting to sort places according to site location and ticket price (from low to high).
5- استخدم الفرز لفرز الأماكن حسب موقع الموقع وسعر التذكرة (من الأقل إلى الأعلى).
6 - Use conditional formatting to highlight ticket price categorized as: Low (Ticket < 100) - Medium ( 100 < Ticket < 500) - High (Ticket > 500).
6 - استخدم التنسيق الشرطي لإبراز سعر التذكرة المصنف على النحو التالي: منخفض (تذكرة ٪3C 100) - متوسط (تذكرة 100٪ 3C تذكرة ٪ 3C 500) - مرتفع (تذكرة ٪ 3E 500).
7- Share the Google Sheet for review and feedback and consider protecting your data.
7- شارك جدول بيانات Google للمراجعة والملاحظات وفكر في حماية بياناتك.
Evaluation Criteria: معايير التقييم:
| Task مهمة |
Instructions تعليمات |
Passing Criteria معايير النجاح |
Create a Google Sheet for touristic sites located in Egypt
قم بإنشاء جدول بيانات Google للمواقع السياحية الموجودة في مصر |
- إنشاء ملف "جداول بيانات Google". - تأكد من تسمية الورقة بشكل صحيح.
| - Create Google Sheets file. |
| - Ensure the sheet is properly named. |
- Create Google Sheets file.
- Ensure the sheet is properly named.| - Create Google Sheets file. |
| :--- |
| - Ensure the sheet is properly named. | |
- تطابق تسمية الملف مع اصطلاح التسمية المطلوب (الهوية الطلابية - مصر). - استخدام جداول بيانات Google فقط كما هو مطلوب. لا يتم استخدام أي أداة أخرى. - إعادة تسمية الورقة إلى اسم مناسب يمثل بوضوح محتوى الورقة.
| - File naming matches the naming convention required (Student ID-Egypt). |
| - Using only Google Sheets as required. No other tool is used. |
| - Renaming the sheet to a suitable name that clearly represents the content of the sheet. |
- File naming matches the naming convention required (Student ID-Egypt).
- Using only Google Sheets as required. No other tool is used.
- Renaming the sheet to a suitable name that clearly represents the content of the sheet.| - File naming matches the naming convention required (Student ID-Egypt). |
| :--- |
| - Using only Google Sheets as required. No other tool is used. |
| - Renaming the sheet to a suitable name that clearly represents the content of the sheet. | |
أضف أعمدة تمثل كل عنصر من عناصر البيانات التالية: - اسم الموقع السياحي - موقع الموقع السياحي - سعر التذكرة - أي معلومات إضافية مثل اللوائح الحكومية أو الأهمية التاريخية (المتعلقة بالموقع).
| Add columns that represents each of the following data elements: |
| - Touristic site name |
| - Touristic site location |
| - Ticket price |
| - Any additional information such as government regulations or historical significance (related to the site). |
Add columns that represents each of the following data elements:
- Touristic site name
- Touristic site location
- Ticket price
- Any additional information such as government regulations or historical significance (related to the site).| Add columns that represents each of the following data elements: |
| :--- |
| - Touristic site name |
| - Touristic site location |
| - Ticket price |
| - Any additional information such as government regulations or historical significance (related to the site). | |
- أضف أعمدة لكل عنصر. - تأكد من تنظيم الورقة بشكل صحيح مع الأعمدة والبيانات لكل عنصر بيانات مطلوب.
| - Add columns for each item. |
| - Ensure the sheet is properly structured with columns and data for each required data element. |
- Add columns for each item.
- Ensure the sheet is properly structured with columns and data for each required data element.| - Add columns for each item. |
| :--- |
| - Ensure the sheet is properly structured with columns and data for each required data element. | |
- استخدام جداول بيانات Google فقط كما هو مطلوب. لا يتم استخدام أي أداة أخرى. - إنشاء وتسمية 4 أعمدة منفصلة تمثل كل عنصر من عناصر البيانات المطلوبة. - يمثل اسم كل عمود بوضوح الغرض من كل عنصر بيانات.
| - Using only Google Sheets as required. No other tool is used. |
| - Creation and naming 4 separate columns that represent each of the required data elements. |
| - The name of each column clearly represents the purpose of each data element. |
- Using only Google Sheets as required. No other tool is used.
- Creation and naming 4 separate columns that represent each of the required data elements.
- The name of each column clearly represents the purpose of each data element.| - Using only Google Sheets as required. No other tool is used. |
| :--- |
| - Creation and naming 4 separate columns that represent each of the required data elements. |
| - The name of each column clearly represents the purpose of each data element. | |
Do research and fill the Google Sheet with information about each touristic site.
قم بإجراء بحث واملأ ورقة Google بمعلومات حول كل موقع سياحي. |
- تعبئة البيانات - تنظيم البيانات
| - Fill in data |
| - Organize data |
- Fill in data
- Organize data| - Fill in data |
| :--- |
| - Organize data | |
- تم سرد 20 موقعا سياحيا بالضبط. - يجب أن تكون جميع المواقع السياحية موجودة في مصر. لا يتم قبول أي مواقع خارج مصر. - يتم تنظيم البيانات بشكل صحيح ؛ يتم سرد كل بيانات في العمود المقابل لها في الورقة.
| - Providing exactly 20 touristic sites are listed. |
| - All touristic sites must be located in Egypt. Any sites outside Egypt are not accepted. |
| - Data is organized correctly; each data is listed in its corresponding column in the sheet. |
- Providing exactly 20 touristic sites are listed.
- All touristic sites must be located in Egypt. Any sites outside Egypt are not accepted.
- Data is organized correctly; each data is listed in its corresponding column in the sheet.| - Providing exactly 20 touristic sites are listed. |
| :--- |
| - All touristic sites must be located in Egypt. Any sites outside Egypt are not accepted. |
| - Data is organized correctly; each data is listed in its corresponding column in the sheet. | |
Task Instructions Passing Criteria
Create a Google Sheet for touristic sites located in Egypt "- Create Google Sheets file.
- Ensure the sheet is properly named." "- File naming matches the naming convention required (Student ID-Egypt).
- Using only Google Sheets as required. No other tool is used.
- Renaming the sheet to a suitable name that clearly represents the content of the sheet."
"Add columns that represents each of the following data elements:
- Touristic site name
- Touristic site location
- Ticket price
- Any additional information such as government regulations or historical significance (related to the site)." "- Add columns for each item.
- Ensure the sheet is properly structured with columns and data for each required data element." "- Using only Google Sheets as required. No other tool is used.
- Creation and naming 4 separate columns that represent each of the required data elements.
- The name of each column clearly represents the purpose of each data element."
Do research and fill the Google Sheet with information about each touristic site. "- Fill in data
- Organize data" "- Providing exactly 20 touristic sites are listed.
- All touristic sites must be located in Egypt. Any sites outside Egypt are not accepted.
- Data is organized correctly; each data is listed in its corresponding column in the sheet."| Task | Instructions | Passing Criteria |
| :--- | :--- | :--- |
| Create a Google Sheet for touristic sites located in Egypt | - Create Google Sheets file. <br> - Ensure the sheet is properly named. | - File naming matches the naming convention required (Student ID-Egypt). <br> - Using only Google Sheets as required. No other tool is used. <br> - Renaming the sheet to a suitable name that clearly represents the content of the sheet. |
| Add columns that represents each of the following data elements: <br> - Touristic site name <br> - Touristic site location <br> - Ticket price <br> - Any additional information such as government regulations or historical significance (related to the site). | - Add columns for each item. <br> - Ensure the sheet is properly structured with columns and data for each required data element. | - Using only Google Sheets as required. No other tool is used. <br> - Creation and naming 4 separate columns that represent each of the required data elements. <br> - The name of each column clearly represents the purpose of each data element. |
| Do research and fill the Google Sheet with information about each touristic site. | - Fill in data <br> - Organize data | - Providing exactly 20 touristic sites are listed. <br> - All touristic sites must be located in Egypt. Any sites outside Egypt are not accepted. <br> - Data is organized correctly; each data is listed in its corresponding column in the sheet. |
| Data formatting تنسيق البيانات |
قم بفرز كل صف وقدم لونا مختلفا لما يلي: - سعر التذكرة (منخفض - متوسط - مرتفع). - مواقع لها نفس الموقع والمحافظة. - إلغاء فرز البيانات
| Sort each row and provide different color for the following: |
| - Ticket price (Low - Medium - High). |
| - Sites with the same location and governorate. |
| - Unsort data |
Sort each row and provide different color for the following:
- Ticket price (Low - Medium - High).
- Sites with the same location and governorate.
- Unsort data| Sort each row and provide different color for the following: |
| :--- |
| - Ticket price (Low - Medium - High). |
| - Sites with the same location and governorate. |
| - Unsort data | |
- يتم تطبيق فرز البيانات كما هو مطلوب باستخدام جداول بيانات Google. - تم تطبيق التنسيق الشرطي للألوان كما هو مطلوب باستخدام جداول بيانات Google.
| - Sorting of data is applied as required using Google Sheets. |
| - Color conditional formatting was applied as required using Google Sheets. |
- Sorting of data is applied as required using Google Sheets.
- Color conditional formatting was applied as required using Google Sheets.| - Sorting of data is applied as required using Google Sheets. |
| :--- |
| - Color conditional formatting was applied as required using Google Sheets. | |
| Sharing the Google Sheet مشاركة جدول بيانات Google |
Apply sharing option. تطبيق خيار المشاركة. |
- Providing a shareable link (access with anyone "can view").
- توفير رابط قابل للمشاركة (الوصول مع أي شخص "يمكنه المشاهدة"). |
Data formatting "Sort each row and provide different color for the following:
- Ticket price (Low - Medium - High).
- Sites with the same location and governorate.
- Unsort data" "- Sorting of data is applied as required using Google Sheets.
- Color conditional formatting was applied as required using Google Sheets."
Sharing the Google Sheet Apply sharing option. - Providing a shareable link (access with anyone "can view").| Data formatting | Sort each row and provide different color for the following: <br> - Ticket price (Low - Medium - High). <br> - Sites with the same location and governorate. <br> - Unsort data | - Sorting of data is applied as required using Google Sheets. <br> - Color conditional formatting was applied as required using Google Sheets. |
| :--- | :--- | :--- |
| Sharing the Google Sheet | Apply sharing option. | - Providing a shareable link (access with anyone "can view"). |