+ Reply to Thread
Results 1 to 6 of 6

Automate school class enrollment functions

  1. #1
    Registered User
    Join Date
    09-30-2016
    Location
    Detroit, MI
    MS-Off Ver
    Mac Office 2016
    Posts
    5

    Automate school class enrollment functions

    Hello everyone. I work for a school that uses a custom and very robust learning management system. In this management system, we have to enroll students to specific classes using a CSV Import. Each class as a unique class code that might look like MATH6-1. That class code would be comprised of the MATH course with class section being the Grade-Section 6-1 (SUBJECTGRADE-SECTION is the format we use). So each student is assigned to a specific section number and all of their classes maintain that grade-section number combination (MATH6-1, SCI6-1, SS6-1, ELA6-1). The issue is that it takes us a really long time to manually build the file that matches the student number with each of the class codes. See the attached file for an example of what the enrollments CSV look like.

    In our master student export, we have access the StudentNumber, Grade, and Section numbers. Is there a way to use the master student export to automatically create a row with the student number and class code for each subject?

    Any help or ideas would be greatly appreciated. Thanks!
    Attached Files Attached Files

  2. #2
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automate school class enrollment functions

    If that CSV is an example of the OUTPUT you need, then yes, that can be done. We would need your starting layout master students file, too.
    _________________
    Microsoft MVP 2010 - Excel
    Visit: Jerry Beaucaire's Excel Files & Macros

    If you've been given good help, use the icon below to give reputation feedback, it is appreciated.
    Always put your code between code tags. [CODE] your code here [/CODE]

    ?None of us is as good as all of us? - Ray Kroc
    ?Actually, I *am* a rocket scientist.? - JB (little ones count!)

  3. #3
    Registered User
    Join Date
    09-30-2016
    Location
    Detroit, MI
    MS-Off Ver
    Mac Office 2016
    Posts
    5

    Re: Automate school class enrollment functions

    This CSV is every student number, grade, section.

    Each student would need to be enrolled in a MATH, SCI, SS, ELA, ADV course.
    Attached Files Attached Files

  4. #4
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automate school class enrollment functions

    Ok, I've created a tool for you with the following macro installed. It uses the Master Course List found in this workbook, so you will need to keep it up to date before you run the Assignments macro.
    Please Login or Register  to view this content.
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    09-30-2016
    Location
    Detroit, MI
    MS-Off Ver
    Mac Office 2016
    Posts
    5

    Re: Automate school class enrollment functions

    I can not thank you enough for this tool. I am noticing as I use it for my other schools that it doesn't seem to accommodate grades higher than 8. Is there a way to change that so I can use it for my high school as well? Again, I thank you very much. You have saved me HOURS of labor.

  6. #6
    Forum Expert JBeaucaire's Avatar
    Join Date
    03-21-2004
    Location
    Bakersfield, CA
    MS-Off Ver
    2010, 2016, Office 365
    Posts
    33,492

    Re: Automate school class enrollment functions

    I don't recall building in any restrictions like that. The macro uses the Master Course List sheet to determine what classes apply. Perhaps you did not amend that sheet for our other needs?

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help - Public School Parent ...class list question
    By erinp1 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 06-20-2016, 02:20 PM
  2. How to assign Enrollment Numbers to Different Class?
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-12-2013, 07:00 PM
  3. Assign Enrollment Numbers to Different Class..
    By z-eighty2 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 07-11-2013, 08:14 PM
  4. daily count of course enrollment from master sheet
    By PLora in forum Excel General
    Replies: 4
    Last Post: 10-27-2011, 03:13 PM
  5. class functions
    By TheIrishThug in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 12-31-2005, 12:25 PM
  6. Automate cut/paste functions - Help!
    By Greg in forum Excel General
    Replies: 2
    Last Post: 06-13-2005, 03:05 PM
  7. VBA functions to automate pricelist
    By nosferer in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 04-27-2005, 08:58 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1