+ Post New Thread
Results 1 to 3 of 3
MIS Systems Thread, SIMS Attendance by class code in Technical; Good afternoon, I am required to analyse the attendance of last years booster classes. I have tried to create my ...
  1. #1

    Join Date
    Aug 2013
    Location
    United Kingdom
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0

    SIMS Attendance by class code

    Good afternoon,

    I am required to analyse the attendance of last years booster classes. I have tried to create my own report but cannot seem to do it successfully. Then I saw the SIMS report called "Lesson Attendance by Classes" located via Reports > Lesson Monitor > Whole Group Student Reports.

    The problem with this report is I cannot output it to Excel so that I can create a pivot table.

    Any advice will be hugely appreciated.

    Kind regards

  2. #2

    vikpaw's Avatar
    Join Date
    Sep 2006
    Location
    Saudi Arabia
    Posts
    5,779
    Thank Post
    714
    Thanked 1,437 Times in 1,190 Posts
    Rep Power
    359
    When you print, instead of the default choose to save as a file, and choose type .xml - it's not excel-ified, but you can force it to open in Excel if you suppress the errors and it's not bad.
    Or, accept the default output to webpage then copy and paste the data to Excel, usually works well with only minor adjustments needed.

  3. #3

    Join Date
    Aug 2013
    Location
    United Kingdom
    Posts
    15
    Thank Post
    0
    Thanked 0 Times in 0 Posts
    Rep Power
    0
    Quote Originally Posted by vikpaw View Post
    When you print, instead of the default choose to save as a file, and choose type .xml - it's not excel-ified, but you can force it to open in Excel if you suppress the errors and it's not bad.
    Or, accept the default output to webpage then copy and paste the data to Excel, usually works well with only minor adjustments needed.
    I tried the copy and paste but unfortunately it needs a lot of editing. I will try the XML version

    Thanks

SHARE:
+ Post New Thread

Similar Threads

  1. [SIMS] SIMS Attendance Marks
    By DSapseid in forum MIS Systems
    Replies: 9
    Last Post: 5th June 2014, 07:54 AM
  2. [SIMS] Class Details - Non-Class Codes
    By apeo in forum MIS Systems
    Replies: 4
    Last Post: 3rd November 2012, 06:11 AM
  3. [SIMS] SIMs attendance reports per lesson
    By syc in forum MIS Systems
    Replies: 17
    Last Post: 3rd October 2012, 06:49 PM
  4. [SIMS] Sims attendance report
    By ful56_uk in forum MIS Systems
    Replies: 1
    Last Post: 3rd October 2012, 08:14 AM
  5. [SIMS] SIMS Attendance for recording after school care
    By imiddleton25 in forum MIS Systems
    Replies: 22
    Last Post: 10th January 2011, 02:13 PM

Thread Information

Users Browsing this Thread

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

Posting Permissions

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