NotesFAQContact Us
Search Tips
Peer reviewed Peer reviewed
Direct linkDirect link
ERIC Number: EJ1061625
Record Type: Journal
Publication Date: 2013-Apr
Pages: 10
Abstractor: As Provided
Reference Count: N/A
ISSN: ISSN-1540-4595
Improving Students' Data Analysis and Presentation Skills: The Ocean State Circuits, Inc. Forecasting Project
Kroes, James R.; Chen, Yuwen; Mangiameli, Paul
Decision Sciences Journal of Innovative Education, v11 n2 p165-174 Apr 2013
Many potential employers expect that newly hired students will arrive on-the-job with the ability to analyze data, utilize spreadsheets, and communicate findings and recommendations. We designed the Ocean State Circuits, Inc. Forecasting Project to address these gaps in our students' knowledge of analytical tools (such as the "vlookup()" function and pivot tables), their ability to write mathematical formulas in a spreadsheet, their understanding of more advanced data analysis features (e.g., regression, correlation), and their ability to communicate and present managerial conclusions. The exercise requires student teams to act as "consultants" and utilize spreadsheets to analyze and forecast the demand for a hypothetical set of products and then communicate their findings to "management" in a professionally formatted report document. A survey of students that have completed the exercise indicates that their knowledge level of the tools used in the project increased significantly from before to after they completed the case. Similarly, anecdotal feedback from employers suggests that students that have completed the exercise seem more capable of dissecting data when investigating business issues.
Wiley-Blackwell. 350 Main Street, Malden, MA 02148. Tel: 800-835-6770; Tel: 781-388-8598; Fax: 781-388-8232; e-mail:; Web site:
Publication Type: Journal Articles; Reports - Evaluative
Education Level: Higher Education; Postsecondary Education
Audience: N/A
Language: English
Sponsor: N/A
Authoring Institution: N/A