In an effort to promote "easy and useful" ways to assess SLOs, the Office of Instruction is pleased to offer a series of Excel spreadsheets for tracking assessment data.
This tool produces Excel spreadsheets that organize a discipline's course assessment results. By combining information from the eSLOs database, the WCS database, and WebAdvisor, the work of building documents to tabulate assessment results is automated.
There are two different "section assessment forms" for tabulating section-by-section course SLO assessment results -- the "long form" and the "short form". Use the long form if you are collecting SLO assessment results student-by-student, outcome-by-outcome. But use the short form if your assessment method already produces class totals, and you do not need student-by-student tabulation.
Click here to download a long form for your section(s).
Click here to download a short form for your section(s).
Both forms include a few lines at the bottom that should be sent to your department chair for use in your discipline's course SLO assessments. Instructions for you and for the department chair are embedded in these forms.
Assessment methodology – how to assess an outcome
Whether assessments are based on instructor evaluation (using, e.g., final exam questions, performance on projects, overall performance,…), department standardized tests with rubrics, student self-evaluation surveys, or some other method that involves student-by-student results, this tool can be used to tabulate the results.
Privacy of results
The results are anonymous at the student level – only the totals for a section need to be reported by an instructor to the department chairman (usually in an email), and the instructor keeps his/her own assessment forms -- long or short. Anonymity in a department’s overall tabulation can be controlled by the department, by choosing which columns of the "discipline assessment spreadsheet" to keep and which to delete. The department chairman keeps his/her department’s assessment spreadsheets.
Click here to download a discipline assessment spreadsheet.
The assessment spreadsheet contains section-by-section tabulations for a discipline’s assessed courses. It is pre-filled with all of that discipline’s schedule for a selected semester, with the SLOs listed for each. It provides subtotals for multiple sections of the same course, and subtotals that distinguish day, evening, weekend, online, and SRC courses.
