During the Spring 2010 term, we were asked to use Microsoft Access 2007 to create a database to manage skating lessons, instructors, students, students’ progress throughout various levels, and much more. Each level requires that a student pass a variety of skills. Just for fun,we used the names of Vancouver Canucks players for the students. This project taught us how to properly set up relationships between various fields as well as build forms, reports, queries, switchboards, and more. The image above displays one of many screens in the database – this screen is meant for selecting a student and seeing which levels he/she has completed, as well as how much revenue has been generated by that student, and how many levels have been attended.
Information on the project requirements can be found here.
You may click the following download icon to take a look at the Microsoft Access database, and you may also read the documentation in PDF format here.
Please note: When you download the database, you will receive a .DOCX (Microsoft Word format file) instead of the expected .ACCDB (Microsoft Access format). Please rename the file extension to .accdb when reading it. This blog has security settings which do not allow an .accdb file to be upload, so the file extension had to be changed.
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.
Because BCIT is so team-oriented, one of the first projects we had to do as a team was design a Team Charter. The purpose of a team charter is to set expectations and ground rules within a group of people that are working together. This helps direct all members’ behaviour in a positive direction with the end result being an efficient team that works well together. A lot of the content in a team charter may seem like common sense to some, but it’s crucial to document that content so that everyone agrees to it, and so it can be referred to in the future. Above is an image from our Team Charter, and below, you will find a button to download it.
This project was one of the more challenging group projects we have endured, but it turned out very well. A Terms of Reference is a contract that is designed to define the scope, and various other details, of a project that is being planned. This is especially important in Operations Management. It allows the project management team and the client to come to an agreement about these details before the project is started so that everything is clearly outlined and the expectations are clear to both parties. We were given a case study which had to be picked apart carefully and then used to create this Terms of Reference. Above is an image of our Terms of Reference project, and below, you will find a download link.
In Marketing 1102, we were asked to do a case study on a fictional wall coverings manufacturer called Canty International. The general idea of the study was to design a pricing strategy for a new product which they created specifically for a large-scale hotel chain, but with the intent of continuing to offer the product to other customers afterwards. Above is an image of the cover page, and at the bottom of this post is a link which allows you to download the case study. Keep in mind that this is only the second case study we have done, so we are still learning, but we feel that we are on the right track!
For our BSYS1000 class, we had to design a PowerPoint presentation on why we chose BCIT to further our education. This was a great project as it gave us the knowledge that we needed to create effective PowerPoint presentations for the rest of our courses. At this point, that knowledge has become extremely valuable, and I’m sure we will be using PowerPoint for quite a long time. Part of the assignment was to convert the PowerPoint presentation into YouTube format to be viewable online – I have embedded the YouTube video in this post so that you can see it right away!
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.
This project was for our BSYS1000 class and gave us the opportunity to use various concepts we had learned about Microsoft Word 2007. We were to choose a computer-related topic, pull content from Wikipedia, and organize it into a report with proper headings, a table of contents, an index, and so on. Our topic was “Introduction to Facebook“. We then uploaded the project to Lulu.com where it can be purchased in PDF format for only $1.25! Above is an image of the cover page, and at the bottom of this post you will find a link to the page on Lulu.com where it can be purchased.