| SDE311 Project |
| 60 Marks / 20% |
| Assignment Summary |
| You are to create a spreadsheet in Excel 2016, which includes the features you see below. The idea here is knowing how to create a spreadsheet from scratch, using your data, and your organizational skills, while fitting in various formulas and functions, and a graph, along the way. |
| Assignment Details |
| Create a spreadsheet based on the scenario below: |
| Car dealership. Data you need to include: |
| At least twenty (20) cars that you’re selling. This means you’ll need to include things like the model, make, year, mileage (in KM), and warranty. You’ll need to have the price or cost to you, the retail price, and if a car is sold, the date it was sold on, and the profit you made. |
| Expenses for rent, heating, hydro, phone, and salaries (for at least a manager and a salesperson). |
| Excel Requirements |
| Please refer to the rubric for the complete list of requirements. |
| Formulas. Include formulas where necessary. For sure, there will be multiplication. |
| Functions. Use the SUM function and other functions such as AVERAGE, MAX, etc. |
| IF Statement. There should be an IF statement somewhere. You will figure out the cell(s) you’re testing, the condition, what to do if true, and what to do if false. |
| Cell Styles. Use one or more Cell Styles in the places you think they belong. |
| Conditional Formatting. Choose a range of cells and apply conditional formatting of your choice. |
| Number Formatting. Use Currency and Number formatting where necessary throughout the worksheets and be consistent with these formats. |
| Column Widths. Make sure you set column widths for ‘best fit’. This means every column will be a different width, depending on what’s in it. |
| Page Formatting. Change to Landscape, centre the page both horizontally and vertically, and fit to one page. |
| Multiple Worksheets. Include data that will require you to create a workbook with multiple worksheets. Your file should also allow for a consolidated worksheet (module 5) |
| Header/Footer. Include a header that includes Your Name in the left area, Company Name in the Centre area, and the date code in the right area. Include a footer that shows the table/sheet code in the left area, and the Page # in the right area. |
| Graph. You have lots of different choices for graphing. Make sure the graph is on a Sheet by itself, that it has a title, that it shows a legend (if necessary), and that it has data labels. |
| Handing in the Assignment |
| Review all the requirements for this project and the marks associated on the rubric. |
| Upload your file in Blackboard where indicated. |
| *Late penalty will be applied for late project submission |