Results 1 to 6 of 6

Automate school class enrollment functions

Threaded View

  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

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. [SOLVED] 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