We may earn an affiliate commission when you visit our partners.
Omnya Khaled
في هذه الدورة، سنركز على هدفين تعلمين:
1. هتتعلم اساسيات اوراق جوجل و كيفية استخدام الدوال و المعادلات الشرطيةو المنطقية و التجميعية.
2.هتتعلم كيفية تنظيف البيانات و إنشاء تصور البيانات والبيانات الفئوية باستخدام: المخططات الدائرية والشريطية والخطية أو
العمودية.
في نهاية هذه الدورة التدريبية، هتتعلم الهدف و الدور لتحليل البيانات.
Register for this course and see more details by visiting:
OpenCourser.com/course/qwidyh/mqdm@
What's inside
Syllabus
ملخص المشروع
Good to know
Good to know
Know what's good ,
what to watch for , and
possible dealbreakers
دورة مناسبة لتعليم أساسيات اوراق جوجل وتنظيف البيانات وإنشاء تصور البيانات للمبتدئين
تعلم كيفية استخدام الدوال والمعادلات الشرطية والمنطقية والتجميعية في أوراق جوجل
تغطي الدورة مفاهيم أساسية في تحليل البيانات
المساق متاح من خلال مزود كورسيرا
Save this course
Save مقدمة لتحليل البيانات باستخدام جدول البيانات to your list so you can find it easily later:
Save
Save
Reviews summary
Straightforward guide to google sheets
This introductory course is a brief, but effective guide to getting started with Google Sheets. The instructor does a great job of making the fundamentals easy to understand. You'll learn how to use Google Sheets to clean and visualize data. You'll also learn the basics of spreadsheet formulas and functions.
Clear and easy to follow instructions.
Lots of helpful examples.
A great course for absolute beginners.
"thank you "
Activities
Be better prepared
before
your course. Deepen your understanding
during
and
after
it. Supplement your coursework and achieve mastery of the topics covered
in مقدمة لتحليل البيانات باستخدام جدول البيانات with these
activities:
Review Google Sheets basics
Show steps
Getting a refresher on the theoretical foundations underpinning this course will lay a solid groundwork for your success
Browse courses on
Google Sheets
Show steps
-
Review the official documentation for Google Sheets formulas
-
Watch a few tutorial videos on Google Sheets basics
-
Practice using basic Google Sheets formulas in a sandbox environment
Join a Google Sheets user group
Show steps
Engaging with other learners can greatly enrich your learning experience
Browse courses on
Google Sheets
Show steps
-
Find a Google Sheets user group online or in your local area
-
Join the group and participate in discussions
-
Share your knowledge and help others
Learn about data cleaning and visualization techniques
Show steps
Additional practice outside of class will greatly enhance your mastery of these key concepts
Browse courses on
Data Cleaning
Show steps
-
Find a tutorial on data cleaning and visualization techniques
-
Follow along with the tutorial and practice the techniques
-
Apply the techniques to a real-world dataset
Two other activities
Expand to see all activities and additional details
Show all five activities
Solve data analysis problems using Google Sheets
Show steps
Solving problems is the ultimate test of your understanding
Browse courses on
Data Analysis
Show steps
-
Find a set of data analysis problems
-
Solve the problems using Google Sheets
-
Check your solutions against the provided answers
Create a data visualization dashboard
Show steps
Creating a project is one of the most effective ways of testing your understanding and synthesizing your learning
Browse courses on
Data Visualization
Show steps
-
Choose a dataset and define the scope of your dashboard
-
Design the layout and structure of your dashboard
-
Create the visualizations and add them to your dashboard
-
Publish your dashboard and share it with others
Review Google Sheets basics
Show steps
Getting a refresher on the theoretical foundations underpinning this course will lay a solid groundwork for your success
Browse courses on
Google Sheets
Show steps
Show steps
Show steps
- Review the official documentation for Google Sheets formulas
- Watch a few tutorial videos on Google Sheets basics
- Practice using basic Google Sheets formulas in a sandbox environment
Join a Google Sheets user group
Show steps
Engaging with other learners can greatly enrich your learning experience
Browse courses on
Google Sheets
Show steps
Show steps
Show steps
- Find a Google Sheets user group online or in your local area
- Join the group and participate in discussions
- Share your knowledge and help others
Learn about data cleaning and visualization techniques
Show steps
Additional practice outside of class will greatly enhance your mastery of these key concepts
Browse courses on
Data Cleaning
Show steps
Show steps
Show steps
- Find a tutorial on data cleaning and visualization techniques
- Follow along with the tutorial and practice the techniques
- Apply the techniques to a real-world dataset
Two other activities
Expand to see all activities and additional details
Show all five activities
Solve data analysis problems using Google Sheets
Show steps
Solving problems is the ultimate test of your understanding
Browse courses on
Data Analysis
Show steps
Show steps
Show steps
- Find a set of data analysis problems
- Solve the problems using Google Sheets
- Check your solutions against the provided answers
Create a data visualization dashboard
Show steps
Creating a project is one of the most effective ways of testing your understanding and synthesizing your learning
Browse courses on
Data Visualization
Show steps
Show steps
Show steps
- Choose a dataset and define the scope of your dashboard
- Design the layout and structure of your dashboard
- Create the visualizations and add them to your dashboard
- Publish your dashboard and share it with others
Career center
Learners who complete مقدمة لتحليل البيانات باستخدام جدول البيانات will develop knowledge and skills
that may be useful to these careers:
Data Analyst
Data Analyst
Data analysts collect, clean, and analyze data to help businesses make better decisions. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for data analysts who want to learn more about using Google Sheets.
Business Analyst
Business Analyst
Business analysts use data to help businesses improve their operations. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for business analysts who want to learn more about using Google Sheets.
Financial Analyst
Financial Analyst
Financial analysts use data to assess the financial health of companies or other organizations. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for financial analysts who want to learn more about using Google Sheets.
Statistician
Statistician
Statisticians collect, analyze, and interpret data. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for statisticians who want to learn more about using Google Sheets.
Quantitative Analyst
Quantitative Analyst
Quantitative analysts use data to analyze financial markets. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for quantitative analysts who want to learn more about using Google Sheets.
Data Scientist
Data Scientist
Data scientists use data to build predictive models and solve complex problems. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for data scientists who want to learn more about using Google Sheets.
Market Researcher
Market Researcher
Market researchers use data to understand consumer behavior. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for market researchers who want to learn more about using Google Sheets.
Operations Research Analyst
Operations Research Analyst
Operations research analysts use data to improve the efficiency of business processes. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data, and how to create visualizations to present your findings. This course may also be helpful for operations research analysts who want to learn more about using Google Sheets.
Database Administrator
Database Administrator
Database administrators design, implement, and maintain databases. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for database administrators who want to learn more about using Google Sheets.
Web Developer
Web Developer
Web developers design and develop websites. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for web developers who want to learn more about using Google Sheets.
Data Engineer
Data Engineer
Data engineers build and maintain data pipelines. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for data engineers who want to learn more about using Google Sheets.
Software Engineer
Software Engineer
Software engineers design, develop, and maintain software systems. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for software engineers who want to learn more about using Google Sheets.
Machine Learning Engineer
Machine Learning Engineer
Machine learning engineers build and maintain machine learning models. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for machine learning engineers who want to learn more about using Google Sheets.
Computer Programmer
Computer Programmer
Computer programmers write code to create software applications. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for computer programmers who want to learn more about using Google Sheets.
Artificial Intelligence Engineer
Artificial Intelligence Engineer
Artificial intelligence engineers design and develop artificial intelligence systems. This course will help you learn the basics of data analysis, including how to use Google Sheets to clean and analyze data. This course may also be helpful for artificial intelligence engineers who want to learn more about using Google Sheets.
For more career information including salaries, visit:
OpenCourser.com/course/qwidyh/mqdm@
Reading list
We've selected 11 books
that we think will supplement your
learning. Use these to
develop background knowledge, enrich your coursework, and gain a
deeper understanding of the topics covered in
مقدمة لتحليل البيانات باستخدام جدول البيانات .
هذا الكتاب هو دليل شامل لتحليل البيانات باستخدام جداول البيانات. يغطي الكتاب الأساسيات، مثل كيفية استيراد البيانات وتنظيفها وتحليلها، بالإضافة إلى تقنيات أكثر تقدمًا، مثل التنبؤ والنمذجة.
هذا الكتاب هو دليل متقدم لجداول بيانات جوجل. يتناول الكتاب مواضيع مثل كيفية استخدام لغة برمجة جوجل Apps Script لتوسيع وظائف جداول البيانات، وكيفية استخدام جداول البيانات لتحليل البيانات وإنشاء الرسوم البيانية.
هذا الكتاب هو دليل شامل لدوال ووظائف Excel. يغطي الكتاب مجموعة واسعة من الدوال والوظائف، من الدوال الأساسية مثل SUM و AVERAGE إلى الدوال الأكثر تقدمًا مثل VLOOKUP و INDEX.
Save
هذا الكتاب هو دليل شامل ل جداول المحاور والمخططات في Excel. يغطي الكتاب كيفية إنشاء جداول المحاور والمخططات واستخدامها لتحليل البيانات.
هذا الكتاب هو مقدمة ممتازة لمكتبة بايثون باندا لتحليل البيانات. يغطي الكتاب كيفية تحميل البيانات وتنظيفها وتحليلها باستخدام باندا.
هذا الكتاب هو مقدمة ممتازة لمكتبة بايثون sklearn لتعلم الآلة. يغطي الكتاب كيفية بناء مجموعة متنوعة من نماذج التعلم الآلي باستخدام sklearn.
هذا الكتاب هو مقدمة ممتازة لمكتبة كيراس لتعلم الآلة العميق. يغطي الكتاب كيفية بناء مجموعة متنوعة من نماذج التعلم الآلي العميق باستخدام كيراس.
هذا الكتاب هو مقدمة ممتازة لمكتبة NLTK لمعالجة اللغات الطبيعية. يغطي الكتاب كيفية معالجة النص وتحليله باستخدام NLTK.
Save
هذا الكتاب هو مقدمة ممتازة لمكتبة OpenCV لرؤية الكمبيوتر. يغطي الكتاب كيفية معالجة الصور ومقاطع الفيديو وتحليلها باستخدام OpenCV.
هذا الكتاب هو مقدمة ممتازة لمكتبة ك لدي للتعرف على الكلام. يغطي الكتاب كيفية معالجة الصوت والتعرف عليه باستخدام ك لدي.
هذا الكتاب هو مقدمة ممتازة لمكتبة OpenGL لرسومات الكمبيوتر. يغطي الكتاب كيفية إنشاء مجموعة متنوعة من الرسومات باستخدام OpenGL.
For more information about how these books relate to this course, visit:
OpenCourser.com/course/qwidyh/mqdm@
Share
Similar courses
Here are nine courses similar to
مقدمة لتحليل البيانات باستخدام جدول البيانات .
تصميم قاعدة البيانات باستخدام SQL Server Management Studio
OpenCourser.com/course/p1soo3/tSmym
تصميم قاعدة البيانات باستخدام SQL Server Management...
Most relevant
أساسيات python: برمج لعبة تخمين الرقم من الصفر
OpenCourser.com/course/mzdk7u/'ssyt
أساسيات python: برمج لعبة تخمين الرقم من الصفر
Most relevant
الجمع بين أجزاء متعددة من البيانات في سيكويل
OpenCourser.com/course/qlzvqk/ljm`
الجمع بين أجزاء متعددة من البيانات في سيكويل
Most relevant
تحليل البيانات للإجابة عن الأسئلة
OpenCourser.com/course/2aaqqm/tHlyl
تحليل البيانات للإجابة عن الأسئلة
Most relevant
تعرَف على هياكل البيانات في بايثون من خلال التطبيق العملي
OpenCourser.com/course/e7nemw/t`raf
تعرَف على هياكل البيانات في بايثون من خلال التطبيق العملي
Most relevant
معالجة البيانات من غير نظيفة إلى نظيفة
OpenCourser.com/course/mocxkp/m`lj@
معالجة البيانات من غير نظيفة إلى نظيفة
Most relevant
تجهيز البيانات للاستكشاف
OpenCourser.com/course/txbg6f/tjhyz
تجهيز البيانات للاستكشاف
Most relevant
مشاركة البيانات من خلال فن مؤثرات عرض التصور
OpenCourser.com/course/4ubyf4/mshrk@
مشاركة البيانات من خلال فن مؤثرات عرض التصور
Most relevant
مقدمة عن قواعد البيانات
OpenCourser.com/course/4q3s1b/mqdm@
مقدمة عن قواعد البيانات
Most relevant
Effort
1 hour
Level
Introductory
Via
Coursera
Institution
Coursera Project Network
Instructor
Omnya Khaled
Language
العربية
Good to know
دورة مناسبة لتعليم أساسيات اوراق جوجل وتنظيف البيانات وإنشاء تصور البيانات للمبتدئين
تعلم كيفية استخدام الدوال والمعادلات الشرطية والمنطقية والتجميعية في أوراق جوجل
تغطي الدورة مفاهيم أساسية في تحليل البيانات
المساق متاح من خلال مزود كورسيرا
Our mission
OpenCourser helps millions of learners each year. People visit us to learn workspace skills, ace their exams, and nurture their curiosity.
Our extensive catalog contains over 50,000 courses and twice as many books. Browse by search, by topic, or even by career interests. We'll match you to the right resources quickly.
Find this site helpful? Tell a friend about us.
Affiliate disclosure
We're supported by our community of learners. When you purchase or subscribe to courses and programs or purchase books, we may earn a commission from our partners.
Your purchases help us maintain our catalog and keep our servers humming without ads.
Thank you for supporting OpenCourser.
© 2016 - 2024 OpenCourser