exports you need to run for your final CLLS report

Modified on Wed, 3 Jul at 2:37 PM

TABLE OF CONTENTS

Adult Learners and Tutors Run Your Reports
Exporting Your 2022-23 Learner Data
Exporting Your 2023-24 Learner Data
Exporting Your 2022-23 Tutor Data
Exporting Your 2023-24 Tutor Data

Adult Learners and Tutors Run Your Reports

If you've used America Learns since July 2022 you'll be able to get all of the data you need by running four sets of reports and exporting the data to Excel.

You'll need these exports for other portions of your final report, too! So, once you export the data, make sure to rename them and save them somewhere you can easily find it.

2022-23 for ALP Learners (you only need a list of names)
2023-24 for ALP Learners
2022-23 for ALP Tutors (you only need a list of names)
2023-24 for ALP Tutors

Exporting Your 2022-23 Learner Data
See a WALKTHROUGH of these steps here!

On the left, in your Mission Control, click Report Data.
On the right, click the last option under Additional Reports, Group data.
Step 1: What would you like to do?
Select Export to Excel, then click Set.
Step 2: Select Groups
Check the box next to your ALP Learner Group, then click Set.
Step 3: Select Identifier to Include
Select All identifiers with data.
Under Show, select All active learners AND All archived learners.

If you collected ALP and ELP data in your Impact Suite, use the Sort by One Field option.
Select a field that will help you distinguish ALP from ELP Learners.

Find your ALP Learners, then, click Select All.
You might want to uncheck any test Learners to avoid inflated numbers.
Click Set.
Step 4: Select a Date Range
Select reporting periods for 2022-23 for ALP reports.
Optional: Use the Select specific reports from this period to narrow down the data to export using the table.
Click Set.
Step 5: Select Data to Include
Keep All Data selected, then click Set.
Step 6: Export Options
Click Customize.
Under Worksheets to Include, select Pre-formatted Sheets.
Select Quantifiable Totals for the Entire Period.
Click Set.
Finally, click Export to Excel.
This will generate your 2022-23 ALP Learner list.

RECOMMEDATION: Once you've exported this report, save it on your device with an easy to identify name like:
2022-23 ALP Learner Report.

Exporting Your 2023-24 Learner Data

See a WALKTHROUGH of these steps here!

On the left, in your Mission Control, click Report Data.
On the right, click the last option under Additional Reports, Group data.
Step 1: What would you like to do?
Select Export to Excel, then click Set.
Step 2: Select Groups
Check the box next to your ALP Learner Group, then click Set.
Step 3: Select Identifier to Include
Select All identifiers with data.
Under Show, select All active learners AND All archived learners.

If you collected ALP and ELP data in your Impact Suite, use the Sort by One Field option.
Select a field that will help you distinguish ALP from ELP Learners.

Find your ALP Learners, then, click Select All.
You might want to uncheck any test Learners to avoid inflated numbers.
Click Set.
Step 4: Select a Date Range
Select reporting periods for 2023-24 for ALP reports.
Optional: Use the Select specific reports from this period to narrow down the data to export using the table.
**Be sure to include reporting periods where you collected Roles & Goals data.
Click Set.
Step 5: Select Data to Include
Keep All Data selected, then click Set.
Step 6: Export Options
Click Customize.
Under Worksheets to Include, select Pre-formatted Sheets.
Select Quantifiable Totals for the Entire Period.

IMPORTANT: For your 2023-24 data you will want to include your Learner Demographic, incarceration, and library card data.
To do this find the Identifier Field Options section.
Select Include Identifier Fields on Pre-formatted worksheets.
Open your Group by checking the box.
Then open any panels and subpanels to find and select all relevant fields for your Learners.

Click Set.
Finally, click Export to Excel.
This will generate your 2023-24 ALP Learner list and most of the Learner data you need to for your CLLS Final Report.

RECOMMEDATION: Once you've exported this report, save it on your device with an easy to identify name like:
2023-24 ALP Learner Report.

Exporting Your 2022-23 Tutor Data

See a quick video on how to export this data here!

On the left, in your Mission Control, click Report Data.
On the right, click the first option under Additional Reports, Tutor data.
Step 1: Select a Date Range
Select reporting periods for 2022-23 for ALP reports.
Optional: Use the Select specific reports from this period to narrow down the data to export using the table.
Click Set.
Step 2: Select Data to Include
Keep All Data selected, then click Set.
Step 3: Included Tutors
Select All Tutors.
IMPORTANT: UncheckInclude tutors with no data (rows will be highlighted).
Click Set.
Step 4: Export Options
Click Customize.
Under Worksheets to Include, select Pre-formatted Sheets.
Select Quantifiable Totals for the Entire Period.
Click Set.
Finally, click Export to Excel.
This will generate your 2022-23 ALP Tutor list.

RECOMMEDATION: Once you've exported this report, save it on your device with an easy to identify name like:
2022-23 ALP Tutor Report.

Exporting Your 2023-24 Tutor Data