Comments (0)

By jmalcolm, November 24, 2009 8:55 pm

In our BSYS1000 course, we were asked to create a business model with various requirements which can be viewed here.

We decided to create a model based on first-term Operations Management courses.  The user of this model is assumed to be the lucky parent of an Operations Management student who will be rewarded based on his/her grades.  The parent is to periodically deposit a certain amount of money into an investment for the student, for a period of 10 years.  This allows the student to see how much money he/she will have earned in 10 years, based on grades which can be entered manually.  You may download the model by clicking on the link below.

Comments (0)

By jmalcolm, November 7, 2009 10:51 pm

In BSYS1000 we are now learning how to use Microsoft Excel 2007.  I have had quite a lot of experience with Excel, both through personal use as well as having a father who taught Excel courses at BCIT in the past, so I am quite familiar with how to use its functions.  I am still learning a lot of new techniques and functions though, so I look forward to the rest of the material that we will be covering.  Below is a recent lab that involved building a spreadsheet that calculates various aspects of a mortgage such as interest, principle, monthly payments, and so on.  Above is an image of this spreadsheet.