RBC Future Launch
RBC Future Launch
Log in Sign up

Spreadsheet Modelling for Business Decisions

COMM 393.3 (01 & 03)
Closed
University of Saskatchewan
University of Saskatchewan
Saskatoon, Saskatchewan, Canada
Mehran Hojati
Associate Professor
1
Timeline
  • November 19, 2021
    Experience start
  • November 27, 2021
    Project Scope Meeting
  • December 12, 2021
    Experience end
Experience
1 projects wanted
Dates set by experience
Preferred companies
Canada
Any
Any industries

Experience scope

Categories
Data analysis Operations Project management
Skills
business analytics data analysis research
Learner goals and capabilities

In this course, students have gained a deep understanding in using Excel to model business problems to help managers make better decisions, regardless of their functional areas. Students have been introduced to the use of optimization (linear programming, network models, integer programming, and nonlinear programming) and simulation. To do this, students will use the Solver add-in.

The entire course is made of workshops (i.e., no lectures). The first two weeks will be dedicated to a complete review of Excel, preparing them to work on a project with your organization.

Learners

Learners
Undergraduate
Any level
6 learners
Project
20 hours per learner
Learners self-assign
Individual projects
Expected outcomes and deliverables

Students will submit a 5-page report and dashboard in Excel with data analysis and recommendations. There is also an additional option to have the teams make a presentation.

Project timeline
  • November 19, 2021
    Experience start
  • November 27, 2021
    Project Scope Meeting
  • December 12, 2021
    Experience end

Project Examples

Requirements

Working in small groups, University of Saskatchewan students will tackle a question designed by you to guide their exploration of the data provided. Among other things, the students will organize and consolidate the data in multiple worksheets, perform visual analysis, apply logical operators and formulas, create dashboards and data summaries.

As a partnering organization, you will provide the students with a central question that you face, and the students will create meaningful spreadsheets to analyze, manage and communicate data, as well as provide recommendations.

Project objectives include, but are not limited to: analyzing data, constructing dashboards in Excel, and providing an analysis of data based on provided criteria.

Possible project examples include, but are not limited to:

  • Anything that requires a spreadsheet
  • Determining optimal inventory levels, production planning, transport planning, location planning
  • Determining optimal financial portfolios
  • Simulating risks and showing its effects

Additional company criteria

Companies must answer the following questions to submit a match request to this experience:

A representative of the company will be available to answer questions from students in a timely manner for the duration of the project.

A representative of the company will be available for a pre-selection discussion with the administrator of the course to review the project scope.