CLLS: Final Report Guide

Modified on Wed, 3 Jul at 2:38 PM


CLLS Final Report
As the fiscal year comes to a close, we want to make sure you have everything you need to complete and submit your Final Report to CLLS. This guide will walk you through how to leverage your Impact Suite and use newly available AI technology (chatgpt.com) to complete your report. 


If you need help, a human is just a click away. Book a time with your Client Success Manager here.  


This guide does not include every datapoint required by CLLS, and is based off of the requirements from the 2022-23 CLLS Final Report. If you need help with a component that this guide doesn't cover, use the link above to book a time with your Client Success Manager.



TABLE OF CONTENTS


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. 

  • 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


Check out this article for the steps to run these reports.


Description of Programs and Activities

In this section, we'll review how to analyze the data extracted from your Impact Suite. 


Adult Learner Data

Data PointHow-To
Number of adult learners who continued from the prior reporting periodExcel Exports Needed from America Learns:
ChatGPT Prompt: Compare these two lists. Tell me the number of Learners who received tutoring in 2022-23 and 2023-24 and the number of Learners who only received tutoring in 2023-24.

InstructionsCopy and paste the prompt above and your Learner Names from each fiscal year (2022-23 and 2023-24) into ChatGPT.

Click here for a VIDEO of the steps!
Number of adult learners who began instruction this fiscal year
Total number of adult learners who received instructionExcel Export Needed from America Learns:
  • 2023-24 ALP Learner Report

Click here for a VIDEO of the steps!
Total number of adult learners with a library card
Total number of adult learner instruction hours at the end of this reporting period


Adult Learner Demographics

These data points can be easily found in the export of your 2023-24 ALP Learner Report data and including details from the Learner profile from the previous step. 


Here's a quick video to walk you through the steps.



Description of Volunteer Activities 

In this section, we'll review how to analyze the data extracted from your Impact Suite. 


Adult Literacy Services Volunteer Data

Data PointHow-To
Number of continuing adult literacy volunteer tutors instructing from prior reporting periodExcel Exports Needed from America Learns:ChatGPT Prompt: Compare these two lists. Tell me the number of Tutors who tutored in 2022-23 and 2023-24 and the number of Tutors who only tutored in 2023-24.

InstructionsCopy and paste the prompt above and your Tutor Names from each fiscal year (2022-23 and 2023-24) into ChatGPT.

Click here for a VIDEO of the steps!
Number of adult Literacy volunteer tutors who began instructing during this reporting period
Total adult literacy volunteer tutors who instructed during this reporting periodExcel Export Needed from America Learns:
  • 2023-24 ALP Tutor Report
Click here for a VIDEO of the steps!


Volunteer Hours

Data PointHow-To
Number of adult literacy volunteer tutor instructional hoursExcel Export Needed from America Learns:
  • 2023-24 ALP Tutor Report
Click here for a VIDEO of the steps!
Number of family literacy volunteer tutor instructional hoursFollow the steps (Tutor Exports) found in this article to pull data for your other volunteer hours
Number of ESL volunteer tutor instructional hours
Number of all other non-tutoring volunteer hours in literacy services
Total number of volunteer hours


Volunteer Demographics

These data points can be easily found in the export of your 2023-24 ALP Tutor Report data and including details from the Learner profile from the previous step. 


Here's a quick video to walk you through the steps.


Program Outcomes: Roles and Goals Report  

In this section we'll review how to extract data from your Impact Suite. 


Program Outcomes: Roles and Goals Report 

Data PointHow-To
Total number of adult learners and ESL learners who received instruction during this reporting periodHere you will combine your total number of Adult Learners and your total number of ESL Learners.

Alternatively, you can run a new report including all Learners.

Here are steps for running a full report of all learners (ALP and ESL) for 2023-24.
Total number of adult learners and ESL learners who set at least one goal during this periodVideo on how to read your Excel Export for this number.

Access our CLLS Percentage Calculator here!
Percentage of adult learners and ESL learners who set at least one goal during this period
Number of adult learners and ESL learners who made progress toward at least one goal in this period
Percentage of adult learners and ESL learners who made progress toward at least one goal
Total number of adult learners and ESL learners (not number of goals) who met at least one goal
Percentage of adult learners and ESL learners who met at least one goal


Roles and Goals Data

Let's learn how to extract data from your Impact suite and leverage AI (chatgpt.com) to quickly build the data you need to report to CLLS in the format required.


Excel Export Needed from America Learns:


ChatGPT Steps:

  1. Copy and paste this prompt into ChatGPT 

    "Help me create a report. I need to show some statics for each goal my Learners SetMade Progress, and Met. Please analyze the raw data below and create a table with the output like this example. 

    GoalTotal Number of Learners Who Set a GoalTotal Number of Learners Who Met a GoalPercentage of Learners Who Met a GoalTotal Number of Learners Who Made ProgressPercentage of Learners Who Made Progress Toward a Goal
    Read a Book462350%1328%

     
    Please create 4 tables one for each of the Roles: Life-long Learner, Family Member, Worker, Community Member/Citizen.

    RAW DATA"


  2. Copy and paste the raw data from the Set, Made Progress, and Met totals rows from your 2023-24 All Learner Data export.

  3. Let ChatGPT analyze your request.


Video of the above steps here!

 


Was this article helpful?

That’s Great!

Thank you for your feedback

Sorry! We couldn't be helpful

Thank you for your feedback

Let us know how can we improve this article!

Select at least one of the reasons
CAPTCHA verification is required.

Feedback sent

We appreciate your effort and will try to fix the article