MABS 101 - Spreadsheets for Business - Excel - Stage 3 - Terrence Corbie

Assessment

Assessment Methods
  • Analysis of exam, quiz, or homework items linked to specific SLOs
  • Assignments based on rubrics (such as essays, projects, and performances)
  • Direct observation of performances, practical exams, group work
  • Student self-assessments (such as reflective journals and surveys)
  • Online discussions
Assessment DescriptionStudent assessments included:

• self-paced, hands-on project assignments

• one-on-one online discussions

• anonymous student surveys

• Direct observation in classroom
Learning OutcomesALL
Number of Sections5
Number of Instructors3
Number of Students~100

Data Analysis

Data Shared With
  • Instructors of the same course (at CCSF)
  • Faculty and staff within our department
Data Sharing Methods

Face-to-face meetings

Data Summary91% of the students were able to design a spreadsheet using simple, fundamental functions such as SUM, MAX, MIN, AVERAGE, COUNT

97% of the students were able to create charts for a worksheet

81% of students were able to easily use the absolute cell address.

83% of students were able to create a spreadsheet to solve a common business problem.
Analysis SummaryThe majority of students were able to achieve all 4 outcomes by completing weekly projects designed to match the SLOs. The SLOs were assessed more than once, as midterm and final projects were cumulative, and tested all past material. However the assessment here only includes the first time the SLOs were assessed.

Interestingly, the student anonymous survey indicated that although not all students performed remarkably well on difficult tasks, almost all students displayed a high level of confidence in their capabilities.
Next Steps PlannedMore projects that isolate specific outcomes.
Learning OutcomesALL

Changes

DetailsInstituted an anonymous student survey to assess personal opinion on comfort level of various functions.

Shortened some projects to focus on fewer outcomes at a time.
Learning OutcomesALL

Tentative Future Plans

TermFall 2013
Activities
  • Assessment (measurement) of outcomes
  • Analysis and discussion of assessment data and next steps
More Details• Continue to survey students at the midpoint and the final, to assess their feelings about their proficiency with the tested tasks.

• Increase collaboration and discussion with instructors in and out of the department.

SLO Details Storage Location

ELECTRONIC COPY - In my electronic filing system (hard drive or web server)

Additional Highlights

A feeling of camaraderie and an environment of collegiality was very evident early on. The more we engaged in the process, the more social it became, and the more academically enlightening. We learned that sharing information and experiences with other faculty in completely different subject areas and across campuses, is as valuable to our personal growth and to our college, as sharing within the department.

Terry

Back to Department Overview