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