Uploaded image for project: 'Moodle'
  1. Moodle
  2. MDL-75349

Create "Groups" custom report source

    XMLWordPrintable

Details

    • MOODLE_401_STABLE
    • MOODLE_401_STABLE
    • Hide

      Create groups

      1. Log in as admin
      2. Create 3 new users (User 1 ... User 3)
      3. Create a new course
      4. Enrol all 3 users as students
      5. Navigate to course group settings
      6. Create 2 new groups:
        • Group 1 (members: User 1/User 2)
        • Group 2 (members: User 2/User 3)
        • Group 3 (no members)
      7. Create 1 new grouping:
        • My grouping (groups: Group 1/Group 2)

      Groups report

      1. Navigate to Reports in user menu
      2. Create new report from Groups report source
        • Ensure Include default setup is checked
      3. Confirm presence and accuracy of following report columns:
        • Course full name with link
        • Group name
        • User full name
      4. In report editor, add the following columns:
        • Grouping > Name
        • Group member > Time added
      5. Confirm grouping is shown in report for Group 1 and Group 2
      6. Confirm group member time added shows time each user was added to group
      7. Remove the column Group member > Time added
      8. Set User > Full name column aggregation to Comma separated values
      9. Confirm report shows for each group, a list of users in the Full name column
      10. Open report conditions
      11. Set Group > Name to the following:
        • Is equal to: Group 2
      12. Apply conditions
      13. Confirm only Group 2 is listed in the report

      Course participants report

      1. Navigate to Reports in user menu
      2. Create new report from Course participants report source
        • Ensure Include default setup is checked
      3. In report editor, add the following columns:
        • Group > Name
      4. Confirm groups are shown for each participant
      5. Set Group > Name column aggregation to Comma separated values
      6. Confirm report shows for each participant, a list of groups in the Name column
      7. Open conditions, add Group > Name as follows:
        • Is equal to: Group 2
      8. Apply conditions
      9. Confirm only Group 2 participants are listed in the report
      Show
      Create groups Log in as admin Create 3 new users ( User 1 ... User 3 ) Create a new course Enrol all 3 users as students Navigate to course group settings Create 2 new groups: Group 1 (members: User 1/User 2) Group 2 (members: User 2/User 3) Group 3 (no members) Create 1 new grouping: My grouping (groups: Group 1/Group 2) Groups report Navigate to Reports in user menu Create new report from Groups report source Ensure Include default setup is checked Confirm presence and accuracy of following report columns: Course full name with link Group name User full name In report editor, add the following columns: Grouping > Name Group member > Time added Confirm grouping is shown in report for Group 1 and Group 2 Confirm group member time added shows time each user was added to group Remove the column Group member > Time added Set User > Full name column aggregation to Comma separated values Confirm report shows for each group, a list of users in the Full name column Open report conditions Set Group > Name to the following: Is equal to: Group 2 Apply conditions Confirm only Group 2 is listed in the report Course participants report Navigate to Reports in user menu Create new report from Course participants report source Ensure Include default setup is checked In report editor, add the following columns: Group > Name Confirm groups are shown for each participant Set Group > Name column aggregation to Comma separated values Confirm report shows for each participant, a list of groups in the Name column Open conditions, add Group > Name as follows: Is equal to: Group 2 Apply conditions Confirm only Group 2 participants are listed in the report

    Description

      The purpose of this report source is to allow flexible reporting on groups, members and groupings across the site (and introduce related entities that will be required for further course reporting)

      Columns

      1. Course
        • <everything from course entity>
      2. Group
        • Name
        • ID number
        • Description
        • Enrolment key
        • Picture
        • Time created
        • Time modified
      3. Grouping
        • Name
        • ID number
        • Description
        • Time created
        • Time modified
      4. Group member
        • Time added
        • Component
      5. User
        • <everything from user entity>

      Conditions/filters

      1. Course
        • <everything from course entity>
      2. Group
        • Name
        • ID number
        • Time created
      3. Grouping
        • Name
        • ID number
        • Time created
      4. Group member
        • Time added
      5. User
        • <everything from user entity>

      Attachments

        Issue Links

          Activity

            People

              pholden Paul Holden
              pholden Paul Holden
              David Carrillo David Carrillo
              Sara Arjona (@sarjona) Sara Arjona (@sarjona)
              John Edward Pedregosa John Edward Pedregosa
              Votes:
              2 Vote for this issue
              Watchers:
              10 Start watching this issue

              Dates

                Created:
                Updated:
                Resolved:
                28/Nov/22

                Time Tracking

                  Estimated:
                  Original Estimate - 0 minutes
                  0m
                  Remaining:
                  Remaining Estimate - 0 minutes
                  0m
                  Logged:
                  Time Spent - 6 hours, 25 minutes
                  6h 25m