Riipen
Log in Sign up

Computer Applications for Business (Section 20)

BCO118
Closed
Sault College
Sault College
Sault Ste. Marie, Ontario, Canada
Barb Bringleson (she/her)
Barb Bringleson (she/her)
Professor, School of Business
(5)
5
Timeline
  • October 2, 2022
    Experience start
  • October 5, 2022
    Project Scope Meeting
  • December 3, 2022
    Experience end
General
  • Undergraduate; 1st year
  • 30 learners; teams of 5
  • 8 hours per learner
  • Dates set by experience
  • Learners self-assign
Preferred companies
  • 1/1 project matches
  • Anywhere
  • Academic experience
  • Any
  • Any industries
Categories
Data visualization Data analysis Communications Operations Competitive analysis
Skills
online communication
Project timeline
  • October 2, 2022
    Experience start
  • October 5, 2022
    Project Scope Meeting
  • December 3, 2022
    Experience end
Overview
Learner goals and capabilities

Looking to elevate your organization, and bring it to the next level? Bring on students from Sault College to be your student-consultants, in a project-based experience. Students will work on one main project over the course of the semester, connecting with you as needed with virtual communication tools.

Expected outcomes and deliverables

Deliverables are negotiable, and will seek to align the needs of the students and the organization.

Some final project deliverables might include:

  1. Perform fundamental tasks involving the operation of a spreadsheet package, recognizing that many of the same functions are found as in other spreadsheet productions.
  2. Format a worksheet and work with formulas and functions.
  3. Create and enhance the representation of financial information with an Excel chart.
  4. Organize data to provide better financial information to interested users within the organization.
  5. Manage multiple worksheets and workbooks.
  6. Develop an excel application.
  7. Work with financial tools and functions.
  8. Perform what-if analysis.
Project Examples

In this course, students will have exposure to a comprehensive Windows-based financial spreadsheet package to enhance their problem solving abilities. The package used will be Microsoft Excel 2016 for Windows. The student will use this as a tool to prepare various reports and presentations, and applications which can be transferred in work commonly performed in the modern office. Students will gain hands-on experience in learning and understanding the software, as well as creating and developing spreadsheet applications. Students can complete projects that utilize Microsoft Excel to develop and enhance spreadsheets, charts, data lists, tables, macros and perform what-if analysis, and financial reporting.

Students in groups of 3-5 will work with your company to identify your needs and provide actionable recommendations, based on their in-depth research and analysis.

Project activities that students can complete using Microsoft Excel may include, but are not limited to:

  1. prepare various reports and presentations
  2. applications to offload work commonly performed in the modern office
  3. creating and developing spreadsheet applications
  4. develop and enhance spreadsheet tables, macros, and what-if analyses
  5. financial reporting
Additional company criteria

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

Provide an opportunity for students to present their work and receive feedback.

Provide a dedicated contact person who is available for weekly/bi-weekly drop-ins to address students’ questions as well as periodic messages over the duration of the project.

How is your project relevant to the course?

Provide relevant information/data as needed for the project.

Be available for a quick phone/virtual call with the instructor to initiate your relationship and confirm your scope is an appropriate fit for the course.