JU Announcement

Computer skills

– Dear All , your First Exam will be held on  3/12/2023

Exam Topics : ◊ Problem Solving ◊ Microsoft excel with all the related training files ,supporting videos, tasks and assignments.

Notes :-
A) IRR: (Percent Agreement)+(Kappa Statistic)are NOT included in the exam (Excluded).
B) ONLY the Pie chart & Column Chart elements Properties mentioned in the Charts Supporting Video are needed for the Exam regarding the Chart Topic.

📢 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. Schedule
    1. Calendar for the lectures (SUN, TUE & THU)
    2. Calendar for the lectures (MON & WED)
  3. Dr.Lama Files (pdf)
    1. Problem solving pt.1
    2. Problem solving pt.2A
    3. Problem solving pt.2B
    4. Problem solving pt.2B (Solution)
    5. Problem solving (Extra Examples pt.1)
    6. Problem solving (Extra Examples pt.2)
    7. Excel (Sorting & Filtering)
    8. Excel (Advanced Filtering)
    9. Excel (Chart & Pie Chart)
    10. Excel (Central Tendency)
    11. Excel (Relationship between Variables)
    12. Excel (Test Mesurements pt.1)
    13. Excel (Test Measurement pt.2)
    14. Excel (Inter Rater Reliability - percent Agreement for Two Raters & Kappa)
    15. Access Notes
    16. Access Sheet & Solutions
    17. Health Informatics Notes
    18. powerPoint presentation Notes
    19. powerpoint presentation Sheets & Solutions
  4. Dr.Lama Files
    1. Excel Training File 1 - Sorting, Filtering, Chart, Pie chart, IF function, Count IF, VLOOKUP
    2. Excel Training File - Filtering
    3. Excel Training File 2 - Central tendency, Dispersion, Relationship among variables, Test Mesurements
    4. Access Training File
    5. Access File - Sheet
    6. powerpoint presentation Training File
    7. powerpoint presentation File - Sheet
  5. Lectures
    1. Introduction
    2. Problem Solving 1
    3. Problem Solving 2
    4. Problem Solving 3
    5. Problem Solving 4
    6. Problem Solving 5
    7. Problem Solving - Examples
    8. Problem Solving Revision ( Additional )
    9. Excel - Sorting and Filtering (Subtotal Not Required)
    10. Excel - Filtering ( Auto + Advanced ) ( Additional )
    11. Excel - IF Function
    12. Excel - CountIF Function
    13. Excel - VLOOKUP Function
    14. Excel - Chart and Pie chart
    15. Excel - Chart and Pie chart ( Additional )
    16. Excel - Central tendency, Dispersion & Relationship among variables
    17. Excel - Test measurements 1
    18. Excel - Test measurements 2
    19. Excel - Test measurements 3 (0:00-25:11 Only Required)
    20. Excel - Inter Rater Reliability - percent Agreement for Two Raters & Kappa
    21. Access - Tables
    22. Access - Reports
    23. Access - Relations
    24. Access - Forms
    25. Access - Queries
    26. Access - Tables A (Additional)
    27. Access - Tables B (Additional)
    28. Access - Reports (Additional)
    29. Access - Forms (Additional)
    30. Access - Queries 1 (Additional)
    31. Access- Queries 2 (Additional)
    32. Access- Queries 3 (Additional)
    33. Access- Queries 4 (Additional)
    34. Health Informatics 1
    35. Health Informatics 2
    36. Health Informatics 3
    37. Powerpoint & Review for Health Informatics and Access (pt.1)
    38. Powerpoint & Review for Health Informatics and Access (pt.2)
    39. Access worksheet
    40. Powepoint worksheet
    41. Last Lecture
  6. Supporting Videos
    1. Excel - Sorting One Column + Two Columns
    2. Excel - AutoFilter
    3. Excel - Advanced Filter
    4. Excel - IF function
    5. Excel - VLookup Function
    6. Excel - CountIF Function
    7. Excel - Creating Charts
    8. Excel - Formatting Chart Elements
    9. Excel - Central Tendency + Dispersion Functions
    10. Excel - Correlation + Covariance
    11. Excel - Test Measurements Pivot Table
    12. Excel - Descriptive Statistics in Excel Using the Data Analysis Tool
    13. Excel - How to find correlation in Excel with the Data Analysis Toolpak
    14. Excel - Creating Histogram from Data set Using Data Analysis ToolPack MS Excel
    15. Excel - Calculating Inter Rater Reliability/Agreement in Excel
    16. Excel - Kappa Statistics
    17. Access - Reports
    18. Access - Forms
    19. Access - Query - Data and Sort
    20. Access - Query - Simple, And, Or
    21. Access - Query - Sum, Max, Min....etc
  7. Assignment and Tasks 2023
    1. Explaining - Ju Exam
    2. https://juexams.com/moodle/
    3. Assignment 1 - Problem Solving & Solution
    4. Assignment 2 - Microsoft Excel Except Kappa Statistic
    5. Assignment 2_Excel.xlsx (Excel File)
  8. Test Banks
    1. Testbank ~ problem solving
    2. Testbank ~ Microsoft Excel Except Kappa Statistic
    3. Examl.xlsx (Excel File)
    4. Chart.xlsx (Excel File)
    5. Test.xlsx (Excel File)
    6. Assignment2.xlsx (Excel File)
    7. Testbank ~ Kappa Statistics
    8. Task4.xlsx (Excel File)
    9. Testbank - Microsoft Access
    10. Information.accdb (Access File)
    11. Testbank ~ Health Informatics
    12. Testbank - powerpoint presentation
    13. Creativity.pptx (powerpoint presentation File )