JU Announcement

Computer Skills

— Dear all , your Mid-term exam will be held on 24/11/2022
Exam Material :
◊ problem Solving.
◊ Microsoft Excel (Sorting to Test Measurements)

your Final exam will be held on 10/1/2023
Exam Material :
◊ All Material 
     Good Luck!

📢 Join Studying group on Telegram, so you don’t miss any important news! : CLICK HERE 

تمنياتنا لكم بالتوفيق – لجان الدفعات

  1. Syllabus
    1. Syllabus
    2. Installing Office 365 (Steps)
  2. Dr.Lama Files - Problem Solving
    1. Problem solving - part 1
    2. Problem solving - part 2A
    3. Problem solving - part 2B
    4. problem solving - part 2B Solved
    5. Problem solving (Extra Examples) - part 1
    6. Problem solving ( Extra Examples) - part 2
  3. Dr.Lama Files - Excel
    1. Sorting &Filtering
    2. Advanced Filtering
    3. Chart & Pie Chart
    4. Central Tendency
    5. Relationship among variables (Correlation & Covariance)
    6. Test Measurements
    7. Test Measurements (presentation ~ For Enjoy 🙂)
    8. Inter Rater Reliability (Percent Agreement for Two Raters & Kappa)
  4. Dr.Lama Files - Excel Training File
    1. Sorting, Chart, Pie Chart, Filtering, CountIF, IF Function & Vlookup
    2. Additional File - Filtering
    3. Central Tendency, Dispersion & Relationship among variables (Correlation & Covariance)
    4. Excel Training File 1 (021) - Subtotal Not Required
    5. Excel Training File 2 (021) - Subtotal Not Required
  5. Dr.Lama Files - Access
    1. Access Notes
    2. Access Sheet & Solutions
  6. Dr.Lama Files - Access Training File
    1. Access Training File
    2. Sheet (Access)
  7. Dr.Lama Files - Health Informatics
    1. Health Informatics Notes
  8. Dr.Lama Files - powerpoint presentation
    1. powerpoint presentation Notes
    2. powerpoint presentation Sheet & Solutions
  9. Dr.Lama Files - powerpoint presentation Training File
    1. powerpoint presentation Training File
    2. Sheet (powerpoint presentation)
  10. Lectures
    1. Lecture 0 - Introduction
    2. Lecture 1 - problem solving part 1
    3. Lecture 2 - problem solving part 2
    4. Lecture 3 - problem solving part 3
    5. Lecture 4 - problem solving part 4
    6. Lecture 5 - problem solving part 5
    7. Lecture 6 - problem solving Examples
    8. Additional Lecture - problem solving Revision
    9. Lecture 7 Excel - Sorting and Filtering (Subtotal Not Required)
    10. Additional Lecture - Filtering (Auto & Advanced )
    11. Lecture 8A Excel - IF Function
    12. Lecture 8B Excel - CountIF Function
    13. Lecture 8C Excel - VLookup Function
    14. Lecture 9 Excel - Chart & Pie Chart
    15. Additional Lecture - Chart & Pie Chart
    16. Lecture 10&11 Excel - Central Tendency, Dispersion & Relationship among variables (Correlation & Covariance)
    17. Lecture 12 Excel - test measurements 1
    18. Lecture 13 Excel - test measurements 2
    19. Lecture 14 Excel - test measurements 3 & Kappa
    20. Lecture 15 Access - Access tables ~ (Input mask - Not Required)
    21. Lecture 16 Access - Access Reports
    22. Lecture 17 Access - Access Relations
    23. Lecture 18 Access - Access Forms
    24. Lecture 19 Access - Access Queries
    25. Additional - Tables A
    26. Additional - Tables B
    27. Additional - Reports
    28. Additional - Forms
    29. Additional - Querirs 1
    30. Additional - Querirs 2
    31. Additional - Querirs 3
    32. Additional - Querirs 4
    33. Lecture 20 - Health Informatics 1
    34. Lecture 21 - Health Informatics 2
    35. Lecture 22 - Health Informatics 3
    36. Lecture 23 - powerpoint presentation & Review for Health Informatics & Access ( Very Important (pt.1))
    37. Lecture 23 - powerpoint presentation & Review for Health Informatics & Access ( Very Important (pt.2))
    38. Lecture 24 - Access Worksheet
    39. Lecture 25 - PowerPoint Worksheet
    40. Lecture 26 - The Last Lecture
  11. Supporting Videos - Excel
    1. Sorting one & two Columns
    2. Auto Filter
    3. Advanced Filter
    4. IF Function
    5. VLookup Function
    6. CountIF Function
    7. Charts & pie Chart
    8. Central Tendency & Dispersion
    9. Relationship among variables (Correlation & Covariance)
    10. Test Measurements (Pivot Table)
    11. Descriptive Statisitics Using Excel Data Analysis Tool
    12. Calculating the Correlation By using Excel Data Analysis Tool
    13. Creating A Histogram by Using Excel Data Analysis Tool
    14. IRR (Percent Agreement in Excel )
    15. Kappa
    16. Kappa Statistics
  12. Supporting Videos - Access
    1. Reports
    2. Forms
    3. Query - Data & Sort
    4. Query - Simple & And Or
    5. Query - Sum Max Min.. etc
  13. Assignment & Tasks
    1. Explaining - JUExam
    2. Assignment 1 & Solutions - problem solving
    3. Additional Assignment 1 & Solutions - problem solving
    4. Filtering (Excel) ~Task 1
    5. Task 1A & Solutions - Filtering
    6. Task 1B & Solutions - Filtering
    7. Chart & pie Chart (Excel) - Task 2
    8. Task 2 & Solutions ~ Chart & pie Chart
    9. Assignment 2 (Excel) - Microsoft Excel
    10. Assignment 2 -& Solutions - Microsoft Excel
    11. Additional Task & Solution - Test Measurements
    12. Kappa Statistics (Excel) - Task 4
    13. Task 4 & Solutions ~ Kappa Statistics
    14. Information (Access) - Assignment 3
    15. Assignment 3 & Solutions - Microsoft Access
    16. Information.accdb (Access) - Makeup Task
    17. Makeup Task & Solutions - Microsoft Access
    18. Task 5 & Solutions - Health Informatics
    19. Creativity (powerpoint presentation ) - Task 6
    20. Task 6 & Solutions - powerpoint presentation
  14. Summaries
    1. Summary by Majed Ghlailat ~ All Mid-term Material
    2. Summary ~ Test Measurements
  15. Test Bank
    1. Test Bank (Pt.1) - Problem Solving & Health Informatics
    2. Excel 1
    3. Excel 2
    4. Test Bank (Pt.2) - Problem Solving & Health Informatics & Excel
    5. Test Bank (Pt.3) - Excel & Access

الدعاء بالرحمة للزميل عمر عطية المرابي

اللَّهُمَّ، اغْفِرْ له وَارْحَمْهُ، وَاعْفُ عنْه وَعَافِهِ، وَأَكْرِمْ نُزُلَهُ، وَوَسِّعْ مُدْخَلَهُ، وَاغْسِلْهُ بمَاءٍ وَثَلْجٍ وَبَرَدٍ، وَنَقِّهِ مِنَ الخَطَايَا كما يُنَقَّى الثَّوْبُ الأبْيَضُ مِنَ الدَّنَسِ.