OMS Example for Course Evaluations

[Jason Vander Weele]

Hello,

I have searched and been unsuccessful in finding a walk through or an
example pertaining to my needs.

I am looking to use OMS for course and instructor evaluation reports. We
typically run about 500 reports for various instructors that end up being
individual PDF files showing only each instructor's results.

It seems like OMS is a solution for this, but I'm open to suggestions.

If anyone has specific sites or examples I can use to better understand how
to do this, I'd love to see them. I've read through a lot of what searches
have brought up, but they have been very general, and I'm a newbie to OMS.

If anyone knows of a YouTube video that clearly walks through OMS, I'd
really enjoy seeing it.

Thanks for the help, in advance.

Jason

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Maguin, Eugene]

Jason,
OMS seems daunting but it's not (or at least it's not as I use it). In terms of the reports, I'd guess that you are using custom tables to generate a summary table for each instructor. Maybe a mean, median and frequency distribution for each item and then scale totals. If you were not using OMS (and just exporting the output to a pdf) you might do something like.

Split file by instructor.
Ctables .....

With OMS, you'll have

OMS /SELECT TABLES/IF COMMANDS=['CTABLES] SUBTYPES=['CUSTOM TABLES']/
   DESTINATION FORMAT=PDF OUTFILE='... .pdf'.
SPLIT FILES BY INSTRUCTOR.
CTABLES ....
OMSEND.

Try something like this out. I'd guess that you want to have one, maybe two, pages for each instructor. So you have to be able to control paging. I've never needed to do that and I don't know that it's possible in command syntax (or as part of the ctables command. I can't comment since I don't have ctables.). Probably it is and perhaps others will jump in with the 'how'.

Gene Maguin





-----Original Message-----
From: SPSSX(r) Discussion [mailto:[hidden email]] On Behalf Of Jason Vander Weele
Sent: Tuesday, February 26, 2013 9:41 AM
To: [hidden email]
Subject: OMS Example for Course Evaluations

Hello,

I have searched and been unsuccessful in finding a walk through or an example pertaining to my needs.

I am looking to use OMS for course and instructor evaluation reports. We typically run about 500 reports for various instructors that end up being individual PDF files showing only each instructor's results.

It seems like OMS is a solution for this, but I'm open to suggestions.

If anyone has specific sites or examples I can use to better understand how to do this, I'd love to see them. I've read through a lot of what searches have brought up, but they have been very general, and I'm a newbie to OMS.

If anyone knows of a YouTube video that clearly walks through OMS, I'd really enjoy seeing it.

Thanks for the help, in advance.

Jason

=====================
To manage your subscription to SPSSX-L, send a message to [hidden email] (not to SPSSX-L), with no body text except the command. To leave the list, send the command SIGNOFF SPSSX-L For a list of commands to manage subscriptions, send the command INFO REFCARD

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Albert-Jan Roskam]

----- Original Message -----

> From: "Maguin, Eugene" <[hidden email]>
> To: [hidden email]
> Cc:
> Sent: Tuesday, February 26, 2013 5:02 PM
> Subject: Re: [SPSSX-L] OMS Example for Course Evaluations
>
> Jason,
> OMS seems daunting but it's not (or at least it's not as I use it). In
> terms of the reports, I'd guess that you are using custom tables to generate
> a summary table for each instructor. Maybe a mean, median and frequency
> distribution for each item and then scale totals. If you were not using OMS (and
> just exporting the output to a pdf) you might do something like.
>
> Split file by instructor.
> Ctables .....
>
> With OMS, you'll have
>
> OMS /SELECT TABLES/IF COMMANDS=['CTABLES] SUBTYPES=['CUSTOM
> TABLES']/
>   DESTINATION FORMAT=PDF OUTFILE='... .pdf'.
> SPLIT FILES BY INSTRUCTOR.
> CTABLES ....
> OMSEND.

But how will you give a unique name to each pdf? Output export and split dataset followed by process files might also work.


I did this a while ago with xls files (it now spits out one pdf for each OMS subtype):

# -*- coding: cp1252 -*-
import sys
import os
import SpssClient
def _pivots2pdfs(fileloc, targets, pdfPrefix):
    OutputDoc = SpssClient.GetDesignatedOutputDoc()
    OutputItems = OutputDoc.GetOutputItems()
    setOutputOpts = OutputDoc.SetOutputOptions
    exportOpt = SpssClient.DocExportOption
    nTargets = 0
    OutputDoc.ClearSelection()
    for index in range(OutputItems.Size()):
        OutputItem = OutputItems.GetItemAt(index)

        isPivotTable = OutputItem.GetType() == SpssClient.OutputItemType.PIVOT
        proc = OutputItem.GetProcedureName()
        isTarget = True if targets is None else proc in targets
        if isinstance(targets, dict):
            subProc = OutputItem.GetSubType()
            hasSubProc = targets.get(proc) and subProc in targets.get(proc)
            isSubTarget = True if hasSubProc else False
        else:
            isSubTarget = True
        if isPivotTable and isTarget and isSubTarget:
            print ".",
            nTargets += 1
            OutputItem.SetSelected(True)
            try:
                selection = SpssClient.SpssExportSubset.SpssSelected
                fmt = SpssClient.DocExportFormat.SpssFormatPdf
                f = os.path.join(fileloc, pdfPrefix + str(nTargets).zfill(3) + ".pdf")
                OutputDoc.ExportDocument(selection, f, fmt)
            except:
                print "ERROR: %s" % sys.exc_info()[1]
            OutputDoc.ClearSelection()
    if nTargets:
        return True
    print "No pivot tables found that match criteria"
    return False
def pivots2pdfs(fileloc=os.getenv("TEMP"), targets=None, pdfPrefix="report_"):
    try:
        SpssClient.StartClient()
        _pivots2pdfs(fileloc, targets, pdfPrefix)
    finally:
        SpssClient.StopClient()
if __name__ == "__main__":
    #pivots2pdfs(r'C:\TEMP\USER', ('Frequencies'))
    pivots2pdfs(r'C:\TEMP\USER', {'Frequencies': ('Statistics', 'Frequencies')})
    #pivots2pdfs()

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jon K Peck]

Start with the topic on OMS available from Help > Topics.  But a common scenario that might be similar to  your situation is one where each report requires running a number of commands and taking the entire Viewer output or a subset of it and exporting to a separate file.  The SPLIT FILES capability can iterate over different subsets of the data, but it iterates within each procedure, so the output contents may not be suitable.

For this kind of problem, the extension commands SPSSINC SPLIT DATASET and SPSSINC PROCESS FILES provide a generalization of SPLIT FILES.  The first command breaks the data into separate files according to a set of splitting variables, and the second command iterates over each data file running a batch of syntax on each.  The syntax could include exporting output or OMS commands, among others.

If that fits your situation,  you can get these commands and the Python Essentials that they also require from the SPSS Community website at www.ibm.com/developerworks/spssdevcentral.

If you already have separate datasets for each instructor, you can start with the second command or use programmability or Basic scripting to run syntax over all the individual files.

HTH,


Jon Peck (no "h") aka Kim
Senior Software Engineer, IBM
[hidden email]
new phone: [phone]




From:        Jason Vander Weele <[hidden email]>
To:        [hidden email],
Date:        02/26/2013 07:46 AM
Subject:        [SPSSX-L] OMS Example for Course Evaluations
Sent by:        "SPSSX(r) Discussion" <[hidden email]>

---

Hello,

I have searched and been unsuccessful in finding a walk through or an
example pertaining to my needs.

I am looking to use OMS for course and instructor evaluation reports. We
typically run about 500 reports for various instructors that end up being
individual PDF files showing only each instructor's results.

It seems like OMS is a solution for this, but I'm open to suggestions.

If anyone has specific sites or examples I can use to better understand how
to do this, I'd love to see them. I've read through a lot of what searches
have brought up, but they have been very general, and I'm a newbie to OMS.

If anyone knows of a YouTube video that clearly walks through OMS, I'd
really enjoy seeing it.

Thanks for the help, in advance.

Jason

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

As some other responses have suggested, it would be helpful to know what command(s) you are using to generate the 500 reports.  Can you post the syntax?

Jason Vander Weele wrote

Hello,

I have searched and been unsuccessful in finding a walk through or an
example pertaining to my needs.

I am looking to use OMS for course and instructor evaluation reports. We
typically run about 500 reports for various instructors that end up being
individual PDF files showing only each instructor's results.

It seems like OMS is a solution for this, but I'm open to suggestions.

If anyone has specific sites or examples I can use to better understand how
to do this, I'd love to see them. I've read through a lot of what searches
have brought up, but they have been very general, and I'm a newbie to OMS.

If anyone knows of a YouTube video that clearly walks through OMS, I'd
really enjoy seeing it.

Thanks for the help, in advance.

Jason

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jason Vander Weele]

Thanks for all the help everyone. Bruce, I'm not sure if you are asking about my present state. If you are, we currently have no syntax to produce the reports. They are done by copying/pasting/saving - 500 times. This is what I'm looking to change. Once I work through the information given to me here, I'll be sure to post the syntax I end up using.

Thank you,

Jason

Jason Vander Weele

Institutional Research and Planning Analyst

gotoltc.edu

Lakeshore Technical College

1290 North Avenue

Cleveland, WI  53015

[hidden email]

[phone]

On Tue, Feb 26, 2013 at 3:27 PM, Bruce Weaver <[hidden email]> wrote:

As some other responses have suggested, it would be helpful to know what
command(s) you are using to generate the 500 reports.  Can you post the
syntax?




Jason Vander Weele wrote

> Hello,
>
> I have searched and been unsuccessful in finding a walk through or an
> example pertaining to my needs.
>
> I am looking to use OMS for course and instructor evaluation reports. We
> typically run about 500 reports for various instructors that end up being
> individual PDF files showing only each instructor's results.
>
> It seems like OMS is a solution for this, but I'm open to suggestions.
>
> If anyone has specific sites or examples I can use to better understand
> how
> to do this, I'd love to see them. I've read through a lot of what searches
> have brought up, but they have been very general, and I'm a newbie to OMS.
>
> If anyone knows of a YouTube video that clearly walks through OMS, I'd
> really enjoy seeing it.
>
> Thanks for the help, in advance.
>
> Jason
>

> =====================
> To manage your subscription to SPSSX-L, send a message to

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD

-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--
View this message in context: http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718266.html
Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[David Marso]

You are entering the world of chicken/egg mayhem!
If you don't have any existing syntax to generate a given report then any query re OMS is seriously premature!  Describe how the data are shaped and the contents of the desired report.
copy/paste/save (500 times?)
Certainly a madness to that method and bound to be RSI downstream!
Really difficult to suggest any sort of automation solution when the required outcome is unstructured, nebulous!
---

Jason Vander Weele wrote

Thanks for all the help everyone. Bruce, I'm not sure if you are asking
about my present state. If you are, we currently have no syntax to produce
the reports. They are done by copying/pasting/saving - 500 times. This is
what I'm looking to change. Once I work through the information given to me
here, I'll be sure to post the syntax I end up using.

Thank you,
Jason
*
*
*Jason Vander Weele*
*Institutional Research and Planning Analyst*
*gotoltc.edu*
*Lakeshore Technical College*
*1290 North Avenue*
*Cleveland, WI  53015*
*[hidden email]*
*[phone]*


On Tue, Feb 26, 2013 at 3:27 PM, Bruce Weaver <[hidden email]>wrote:

> As some other responses have suggested, it would be helpful to know what
> command(s) you are using to generate the 500 reports.  Can you post the
> syntax?
>
>
>
>
> Jason Vander Weele wrote
> > Hello,
> >
> > I have searched and been unsuccessful in finding a walk through or an
> > example pertaining to my needs.
> >
> > I am looking to use OMS for course and instructor evaluation reports. We
> > typically run about 500 reports for various instructors that end up being
> > individual PDF files showing only each instructor's results.
> >
> > It seems like OMS is a solution for this, but I'm open to suggestions.
> >
> > If anyone has specific sites or examples I can use to better understand
> > how
> > to do this, I'd love to see them. I've read through a lot of what
> searches
> > have brought up, but they have been very general, and I'm a newbie to
> OMS.
> >
> > If anyone knows of a YouTube video that clearly walks through OMS, I'd
> > really enjoy seeing it.
> >
> > Thanks for the help, in advance.
> >
> > Jason
> >
> > =====================
> > To manage your subscription to SPSSX-L, send a message to
>
> > LISTSERV@.UGA
>
> >  (not to SPSSX-L), with no body text except the
> > command. To leave the list, send the command
> > SIGNOFF SPSSX-L
> > For a list of commands to manage subscriptions, send the command
> > INFO REFCARD
>
>
>
>
>
> -----
> --
> Bruce Weaver
> [hidden email]
> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718266.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>

[Bruce Weaver]

Let me try again.  If your data file contained data for only one course-instructor combination, how would you generate the desired report for that one case?  Do you have syntax for that?

Cheers,
Bruce

Jason Vander Weele wrote

Thanks for all the help everyone. Bruce, I'm not sure if you are asking
about my present state. If you are, we currently have no syntax to produce
the reports. They are done by copying/pasting/saving - 500 times. This is
what I'm looking to change. Once I work through the information given to me
here, I'll be sure to post the syntax I end up using.

Thank you,
Jason
*
*
*Jason Vander Weele*
*Institutional Research and Planning Analyst*
*gotoltc.edu*
*Lakeshore Technical College*
*1290 North Avenue*
*Cleveland, WI  53015*
*[hidden email]*
*[phone]*


On Tue, Feb 26, 2013 at 3:27 PM, Bruce Weaver <[hidden email]>wrote:

> As some other responses have suggested, it would be helpful to know what
> command(s) you are using to generate the 500 reports.  Can you post the
> syntax?
>
>
>
>
> Jason Vander Weele wrote
> > Hello,
> >
> > I have searched and been unsuccessful in finding a walk through or an
> > example pertaining to my needs.
> >
> > I am looking to use OMS for course and instructor evaluation reports. We
> > typically run about 500 reports for various instructors that end up being
> > individual PDF files showing only each instructor's results.
> >
> > It seems like OMS is a solution for this, but I'm open to suggestions.
> >
> > If anyone has specific sites or examples I can use to better understand
> > how
> > to do this, I'd love to see them. I've read through a lot of what
> searches
> > have brought up, but they have been very general, and I'm a newbie to
> OMS.
> >
> > If anyone knows of a YouTube video that clearly walks through OMS, I'd
> > really enjoy seeing it.
> >
> > Thanks for the help, in advance.
> >
> > Jason
> >
> > =====================
> > To manage your subscription to SPSSX-L, send a message to
>
> > LISTSERV@.UGA
>
> >  (not to SPSSX-L), with no body text except the
> > command. To leave the list, send the command
> > SIGNOFF SPSSX-L
> > For a list of commands to manage subscriptions, send the command
> > INFO REFCARD
>
>
>
>
>
> -----
> --
> Bruce Weaver
> [hidden email]
> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718266.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>

[Albert-Jan Roskam]

>Let me try again.  If your data file contained data for only *one*
>course-instructor combination, how would you generate the desired report for
>that one case?  Do you have syntax for that?

Yes, I'm also curious what it looks like. Do you have a dummy report, ie. a report with just empty tables and boilerplate/template text? 500 manually crafted reports... this begs for automation! OdfWeave (R, see e.g. http://datamining.togaware.com/survivor/ooorg_weave_example03.png, http://datamining.togaware.com/survivor/Getting_Started0.html) and IPython Notebook (http://ipython.org/notebook.html) are two cool ways of doing this.

Albert-Jan

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Jason Vander Weele]

Bruce,

Now I see what you are looking for. It is really just a custom table, maybe two if we include other questions:

USE ALL.

COMPUTE filter_$=(rInstructor=7).

VARIABLE LABELS filter_$ 'rInstructor=7 (FILTER)'.

VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.

FORMATS filter_$ (f1.0).

FILTER BY filter_$.

EXECUTE.

* Custom Tables.

CTABLES

  /VLABELS VARIABLES=Instructor Class_Title Class_Number Q1_1ThinkCritically Q1_2Time Q1_3Apply 

    Q1_4SatisfiedOverall Q2_1Clear Q2_2Knowledgeable Q2_3Prepared Q2_4Organized Q2_5Timely 

    Q2_6Available Q2_7Activities Q2_8Professional Q2_9Expecting Q2_10Helping Q2_11Encouraging 

    Q2_12Satisfied Q3 Q4 

    DISPLAY=DEFAULT

  /TABLE Instructor [C] > Class_Title [C] > Class_Number [C][COUNT F40.0] + Q1_1ThinkCritically 

    [S][MEAN F40.2] + Q1_2Time [S][MEAN F40.2] + Q1_3Apply [S][MEAN F40.2] + Q1_4SatisfiedOverall 

    [S][MEAN F40.2] + Q2_1Clear [S][MEAN F40.2] + Q2_2Knowledgeable [S][MEAN F40.2] + Q2_3Prepared 

    [S][MEAN F40.2] + Q2_4Organized [S][MEAN F40.2] + Q2_5Timely [S][MEAN F40.2] + Q2_6Available 

    [S][MEAN F40.2] + Q2_7Activities [S][MEAN F40.2] + Q2_8Professional [S][MEAN F40.2] + Q2_9Expecting 

    [S][MEAN F40.2] + Q2_10Helping [S][MEAN F40.2] + Q2_11Encouraging [S][MEAN F40.2] + Q2_12Satisfied 

    [S][MEAN F40.2] + Q3 [C][COUNT F40.0] + Q4 [C][COUNT F40.0]

  /CATEGORIES VARIABLES=Instructor Class_Title Class_Number Q3 Q4 ORDER=A KEY=VALUE EMPTY=EXCLUDE.

Thank you,

Jason

Jason Vander Weele

Institutional Research and Planning Analyst

gotoltc.edu

Lakeshore Technical College

1290 North Avenue

Cleveland, WI  53015

[hidden email]

[phone]

On Thu, Feb 28, 2013 at 2:38 PM, Bruce Weaver <[hidden email]> wrote:

Let me try again.  If your data file contained data for only *one*
course-instructor combination, how would you generate the desired report for
that one case?  Do you have syntax for that?

Cheers,
Bruce



Jason Vander Weele wrote

> Thanks for all the help everyone. Bruce, I'm not sure if you are asking
> about my present state. If you are, we currently have no syntax to produce
> the reports. They are done by copying/pasting/saving - 500 times. This is
> what I'm looking to change. Once I work through the information given to
> me
> here, I'll be sure to post the syntax I end up using.
>
> Thank you,
> Jason

> *
> *
> *Jason Vander Weele*
> *Institutional Research and Planning Analyst*
> *gotoltc.edu*
> *Lakeshore Technical College*
> *1290 North Avenue*
> *Cleveland, WI  53015*
> *

> jason.vanderweele@

> *
> *<a href="tel:%28920%29%20693-1288" value="[phone]">[phone]*
>
>

> On Tue, Feb 26, 2013 at 3:27 PM, Bruce Weaver <

> bruce.weaver@

> >wrote:
>
>> As some other responses have suggested, it would be helpful to know what
>> command(s) you are using to generate the 500 reports.  Can you post the
>> syntax?
>>
>>
>>
>>
>> Jason Vander Weele wrote
>> > Hello,
>> >
>> > I have searched and been unsuccessful in finding a walk through or an
>> > example pertaining to my needs.
>> >
>> > I am looking to use OMS for course and instructor evaluation reports.
>> We
>> > typically run about 500 reports for various instructors that end up
>> being
>> > individual PDF files showing only each instructor's results.
>> >
>> > It seems like OMS is a solution for this, but I'm open to suggestions.
>> >
>> > If anyone has specific sites or examples I can use to better understand
>> > how
>> > to do this, I'd love to see them. I've read through a lot of what
>> searches
>> > have brought up, but they have been very general, and I'm a newbie to
>> OMS.
>> >
>> > If anyone knows of a YouTube video that clearly walks through OMS, I'd
>> > really enjoy seeing it.
>> >
>> > Thanks for the help, in advance.
>> >
>> > Jason
>> >
>> > =====================
>> > To manage your subscription to SPSSX-L, send a message to
>>
>> > LISTSERV@.UGA
>>
>> >  (not to SPSSX-L), with no body text except the
>> > command. To leave the list, send the command
>> > SIGNOFF SPSSX-L
>> > For a list of commands to manage subscriptions, send the command
>> > INFO REFCARD
>>
>>
>>
>>
>>
>> -----
>> --
>> Bruce Weaver
>>

> bweaver@

>> http://sites.google.com/a/lakeheadu.ca/bweaver/
>>
>> "When all else fails, RTFM."
>>
>> NOTE: My Hotmail account is not monitored regularly.
>> To send me an e-mail, please use the address shown above.
>>
>> --
>> View this message in context:
>> http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718266.html
>> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>>
>> =====================
>> To manage your subscription to SPSSX-L, send a message to
>>

> LISTSERV@.UGA

>  (not to SPSSX-L), with no body text except the
>> command. To leave the list, send the command
>> SIGNOFF SPSSX-L
>> For a list of commands to manage subscriptions, send the command
>> INFO REFCARD
>>





-----
--
Bruce Weaver
[hidden email]
http://sites.google.com/a/lakeheadu.ca/bweaver/

"When all else fails, RTFM."

NOTE: My Hotmail account is not monitored regularly.
To send me an e-mail, please use the address shown above.

--

View this message in context: http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718313.html

Sent from the SPSSX Discussion mailing list archive at Nabble.com.

=====================
To manage your subscription to SPSSX-L, send a message to
[hidden email] (not to SPSSX-L), with no body text except the
command. To leave the list, send the command
SIGNOFF SPSSX-L
For a list of commands to manage subscriptions, send the command
INFO REFCARD

[Bruce Weaver]

I don't use CTABLES much, but I expect you could do something like this.

* OMS command to send CTABLES output to a new dataset --
* you can generate this via Utilities -> OMS Control Panel.

sort cases by rInstructor.
split file by rInstructor.

* Your CTABLES command here.

OMSend.
split file off.
dataset activate CTAB_Output.

* Do any necessary data management.
split file by rInstructor.

* Use REPORT or SUMMARIZE to generate a report for each value of rInstructor.

split file off.

HTH.

Jason Vander Weele wrote

Bruce,

Now I see what you are looking for. It is really just a custom table, maybe
two if we include other questions:

USE ALL.
COMPUTE filter_$=(rInstructor=7).
VARIABLE LABELS filter_$ 'rInstructor=7 (FILTER)'.
VALUE LABELS filter_$ 0 'Not Selected' 1 'Selected'.
FORMATS filter_$ (f1.0).
FILTER BY filter_$.
EXECUTE.


* Custom Tables.
CTABLES
  /VLABELS VARIABLES=Instructor Class_Title Class_Number
Q1_1ThinkCritically Q1_2Time Q1_3Apply
    Q1_4SatisfiedOverall Q2_1Clear Q2_2Knowledgeable Q2_3Prepared
Q2_4Organized Q2_5Timely
    Q2_6Available Q2_7Activities Q2_8Professional Q2_9Expecting
Q2_10Helping Q2_11Encouraging
    Q2_12Satisfied Q3 Q4
    DISPLAY=DEFAULT
  /TABLE Instructor [C] > Class_Title [C] > Class_Number [C][COUNT F40.0] +
Q1_1ThinkCritically
    [S][MEAN F40.2] + Q1_2Time [S][MEAN F40.2] + Q1_3Apply [S][MEAN F40.2]
+ Q1_4SatisfiedOverall
    [S][MEAN F40.2] + Q2_1Clear [S][MEAN F40.2] + Q2_2Knowledgeable
[S][MEAN F40.2] + Q2_3Prepared
    [S][MEAN F40.2] + Q2_4Organized [S][MEAN F40.2] + Q2_5Timely [S][MEAN
F40.2] + Q2_6Available
    [S][MEAN F40.2] + Q2_7Activities [S][MEAN F40.2] + Q2_8Professional
[S][MEAN F40.2] + Q2_9Expecting
    [S][MEAN F40.2] + Q2_10Helping [S][MEAN F40.2] + Q2_11Encouraging
[S][MEAN F40.2] + Q2_12Satisfied
    [S][MEAN F40.2] + Q3 [C][COUNT F40.0] + Q4 [C][COUNT F40.0]
  /CATEGORIES VARIABLES=Instructor Class_Title Class_Number Q3 Q4 ORDER=A
KEY=VALUE EMPTY=EXCLUDE.

*
*
Thank you,
Jason
*
*
*Jason Vander Weele*
*Institutional Research and Planning Analyst*
*gotoltc.edu*
*Lakeshore Technical College*
*1290 North Avenue*
*Cleveland, WI  53015*
*[hidden email]*
*[phone]*


On Thu, Feb 28, 2013 at 2:38 PM, Bruce Weaver <[hidden email]>wrote:

> Let me try again.  If your data file contained data for only *one*
> course-instructor combination, how would you generate the desired report
> for
> that one case?  Do you have syntax for that?
>
> Cheers,
> Bruce
>
>
>
> Jason Vander Weele wrote
> > Thanks for all the help everyone. Bruce, I'm not sure if you are asking
> > about my present state. If you are, we currently have no syntax to
> produce
> > the reports. They are done by copying/pasting/saving - 500 times. This is
> > what I'm looking to change. Once I work through the information given to
> > me
> > here, I'll be sure to post the syntax I end up using.
> >
> > Thank you,
> > Jason
> > *
> > *
> > *Jason Vander Weele*
> > *Institutional Research and Planning Analyst*
> > *gotoltc.edu*
> > *Lakeshore Technical College*
> > *1290 North Avenue*
> > *Cleveland, WI  53015*
> > *
>
> > jason.vanderweele@
>
> > *
> > *[phone]*
> >
> >
> > On Tue, Feb 26, 2013 at 3:27 PM, Bruce Weaver <
>
> > bruce.weaver@
>
> > >wrote:
> >
> >> As some other responses have suggested, it would be helpful to know what
> >> command(s) you are using to generate the 500 reports.  Can you post the
> >> syntax?
> >>
> >>
> >>
> >>
> >> Jason Vander Weele wrote
> >> > Hello,
> >> >
> >> > I have searched and been unsuccessful in finding a walk through or an
> >> > example pertaining to my needs.
> >> >
> >> > I am looking to use OMS for course and instructor evaluation reports.
> >> We
> >> > typically run about 500 reports for various instructors that end up
> >> being
> >> > individual PDF files showing only each instructor's results.
> >> >
> >> > It seems like OMS is a solution for this, but I'm open to suggestions.
> >> >
> >> > If anyone has specific sites or examples I can use to better
> understand
> >> > how
> >> > to do this, I'd love to see them. I've read through a lot of what
> >> searches
> >> > have brought up, but they have been very general, and I'm a newbie to
> >> OMS.
> >> >
> >> > If anyone knows of a YouTube video that clearly walks through OMS, I'd
> >> > really enjoy seeing it.
> >> >
> >> > Thanks for the help, in advance.
> >> >
> >> > Jason
> >> >
> >> > =====================
> >> > To manage your subscription to SPSSX-L, send a message to
> >>
> >> > LISTSERV@.UGA
> >>
> >> >  (not to SPSSX-L), with no body text except the
> >> > command. To leave the list, send the command
> >> > SIGNOFF SPSSX-L
> >> > For a list of commands to manage subscriptions, send the command
> >> > INFO REFCARD
> >>
> >>
> >>
> >>
> >>
> >> -----
> >> --
> >> Bruce Weaver
> >>
>
> > bweaver@
>
> >> http://sites.google.com/a/lakeheadu.ca/bweaver/
> >>
> >> "When all else fails, RTFM."
> >>
> >> NOTE: My Hotmail account is not monitored regularly.
> >> To send me an e-mail, please use the address shown above.
> >>
> >> --
> >> View this message in context:
> >>
> http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718266.html
> >> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
> >>
> >> =====================
> >> To manage your subscription to SPSSX-L, send a message to
> >>
>
> > LISTSERV@.UGA
>
> >  (not to SPSSX-L), with no body text except the
> >> command. To leave the list, send the command
> >> SIGNOFF SPSSX-L
> >> For a list of commands to manage subscriptions, send the command
> >> INFO REFCARD
> >>
>
>
>
>
>
> -----
> --
> Bruce Weaver
> [hidden email]
> http://sites.google.com/a/lakeheadu.ca/bweaver/
>
> "When all else fails, RTFM."
>
> NOTE: My Hotmail account is not monitored regularly.
> To send me an e-mail, please use the address shown above.
>
> --
> View this message in context:
> http://spssx-discussion.1045642.n5.nabble.com/OMS-Example-for-Course-Evaluations-tp5718255p5718313.html
> Sent from the SPSSX Discussion mailing list archive at Nabble.com.
>
> =====================
> To manage your subscription to SPSSX-L, send a message to
> [hidden email] (not to SPSSX-L), with no body text except the
> command. To leave the list, send the command
> SIGNOFF SPSSX-L
> For a list of commands to manage subscriptions, send the command
> INFO REFCARD
>