How do I do the project assignment?

The following steps will guide you through the process of completing your project assignment.

$$ Select a company

o Each group will get to select a company on a first$-$come$-$first$-$serve basis

$$ Collect relevant current data and examine the data

$$ Design the user interface $($the worksheets$)$

$$ Develop the worksheets

$$ Test and debug the completed application

$$ Submit your work through the Canvas $$ Submissions to be made only by the group coordinator

Specifications for your workbooks$/$worksheets

$1.$ Include at least $8$ worksheets, $2$ marks per worksheet $\_\_/16$

o $2$ worksheet per person $($individual grades will be affected for the worksheets that are not up to the mark$)$

$2.$ For each worksheet, include a $$purpose$$ and $$conclusion$\_\_/4$

$3.$ Include a cover$/$table of content and a reference$/$citation worksheet $\_\_/2$

o Make sure to mention the names & student IDs of all the group members on the cover worksheet

o Each student must mention their names on the worksheets that they worked on in the top$-$left corner of each sheet.

$$ For example: If Shivangi worked on Sheet $1$ and Sheet $2,$ her name will be put in cell A$1$ of both the sheets. $($this will help in individual grading$).$

$4.$ Include at least $15$ Excel techniques$/$functions learned in class. i$.$e$.,1$ mark per application $\_\_/15$

$5.$ Overall presentation $($formatting$,$ degree of difficulty, appropriateness of techniques used, etc.$)\_\_/10$

$6.$ Submission of project topic by due date $\_\_/3$

Examples of Excel techniques$/$features include the following $($they are NOT limited to only these, this only an example$)$:

$$ Include $4$ different type of charts $($module $1)$

$$ Include $3$ complex calculations using multiple operations and parentheses $($module $2)$

$$ Use SUM, AVERAGE, MAX, MIN and COUNT functions $($module $2)$

$$ Conditional formatting $($module $2)$

$$ What if analysis $($module $3)$

$$ Goal seek $($module $3)$

$$ Freeze rows$/$columns $($module $3)$

$$ IF functions $($module $3)$

$$ Data table $($module $4)$

$$ Use a FINANCIAL FUNCTION, i$.$e$.,$ PV$,$ FV or PMT etc. $($module $4)$

$$ Amortization table $($module $4)$

$$ Protecting worksheet with