Out Of Sight…Out of Mind…

The flow chart above is hilarious! Unfortunately, the feedback we have received over the years is that this, although funny,  accurately reflects the current flow of an email received from Innovation Technology and Education (ITE) or Systems Education and Analysis (SEA).

We recognize that numerous emails can be a time drain that deter you from “important” work; however, it is critical that you are able to recognize the emails from your inbox that will assist you with that “important work”.

ITE and SEA use email as one way to share timely and “important” system information such as the roll out of new programs, enhancements and modifications to existing programs, and critical information related to network security.

Can we get a “WOOHOO!!”?

Online Registration Coming Soon!

  that Advance/CDIStiller courses are moving to online registration in MyLearning?  Well hang on… just not quite yet.

So – help us, help you!

To help the Innovative Technology and Education (ITE) team to keep the ball moving towards our launch date (which is soon), you can help us by continuing to submit your Advance access and training requests by the same process as you have used previously – through the Advance Access & Training Request form (located in My Reference of Advance).

Doing so will help our team to be prepared for any learner that registers for training so that they have all of the necessary rights in Advance on the day of their training as granting access takes time and should be done prior to the start of a training.  This will ensure that learners can follow along and have the best learning experience and use of their time as possible.

This is important to know! Once MyLearning registration rolls out for Advance training, we will still require an Advance Access and Training Request form as the first step to registration versus going straight to MyLearning so that we are notified of a registered learner. We want to be prepared and aware for any learner that comes through our door for training and avoid a surprise on the day of training.

As always – if there are any questions about this request, please don’t hesitate to contact ADV Request.

Kate Coskrey

On the Average…

ADVANCE is a powerful tool we use to generate data to analyze our various constituencies, but how are we able to leverage that data to determine averages on a particular data point?

For example, what is the average age of our alumni members? What is the average Engagement Index of recent attendees to an event?  What is the average age of our Computer Science alumni?

…you can use your Statistical Analysis format to help get the answers to these questions? All you need is your Ad-Hoc report and a blank Excel document.

Let’s walk through an example.  Imagine you were recently asked to pull the average Engagement Index (EI) of graduates from a particular department, but this Ad-Hoc report yields a total of over 5,000 alumni! The Statistical Analysis format has the “CSU – Engagement Index” data point, but this simply shows us the number of alumni for each score. So how can we calculate the average based on the way this data is presented?

To calculate the average:

1. Retrieve your report as a Statistical Analysis with “CSU – Engagement Index” selected.
2. Open a blank Excel worksheet.
3. Copy and paste your Statistical Analysis “CSU – Engagement Index” table into Excel and delete the column with percentages in Column C (we will re-purpose this column).
   • Column A will show all the various EI scores for all qualified alumni.
   • Column B will show the number of alumni per score.
4. Now, let’s calculate Column C. In cell C1, multiply A1*B1.

*Try this formula:  =SUM(A1*B1)

5. You can now carry this formula down the remainder of Column C using the cross icon in the lower right corner of that cell:

  (To learn more about this function, click here or search the web for “How to  copy a formula down a column”)

6. You should now have values in column C for all EI scores.
7. Calculate the SUM of Columns B and C (column B is going to be the total number of entities on your report).
8. To determine the average, divide the total of Column C by the total of Column B.

You can now easily see the average Engagement Index for our department graduates is 325.

We can track their EI score at this point in time and use it for comparison purposes in the future to determine exactly how our recent outreach initiatives may have impacted their engagement with CSU.

You easily can apply this process for determining the average age of a population as well.

Linda Paule – Systems Education & Analysis