Develop a spreadsheet for a small building surveying company to include income and expenditure with charts and formulas.

Should follow the Rubric (Instructions/criteria) given in pic 2.

BSBWRT401 - Write Complex Documents ASS-:- Create a scacs et S.",2ECC. Introduction A spread sheet tracks and records all of a business' day-to-day financial transactions. In turn, providing information relating to business growth, cash flow and profit margins. All of this can help you make more informed decisions about spending, keep your financial books in orde tax season and give you essential data on seasonal trends. Instructions for Student: Students are to develop a spread sheet for a small building surveying company to include: Income Expenditure The spreadsheet must also include a chart and formulas . Submission Document to submit: 26th November 2020 Submission to be via Moodle no later than the due date specified. This assessment will be graded in accordance with Rubric; see attached Rubric for Spreadsheet Criteria Exemplary 4 Accomplished Developing Beginning 3 Yes 2 1 Yes, but No, but No All required & A few minor additional applicable elements of required & information beyond applicable content are Information/Content requirements is entered & all instructions are followed are missing. completely Several required content elements are missing. Most instructions are not Tollowed. Organization Format Information is very O ting wel organized' by using appropriate advanced formatting, including shading, alignment tools. labels and bolding, borders, special fonts, appropriate labels, appropriate column/row height & width Most of the required content is entered, although missing & minor instructions applicable content above recuirements is missing. lo stinstructions are followed completely. Information Information organization is godal, using organization is appropriate standard falr, using standard formatting tools, such as formatting tools. Some labels or other important forr natting tools are missing irrottau n is poorly organized Appropriate formatting such as appropriate labels & column/row widths & height are not used. Several errors. Some required data may be missing. No formulas are used Data Entry, Computations, & Formulas o All data required is D All data required entered witn 100% data is entered correctly. accuracy. 100% use of Minor errors in correct correct applicable formulas formulas used. as required Some data required is missing. Several errors in formula calculations Visual Appearance & Output Spreadsheet is attractive, easy to read & all required information printed Coathing cut off Spreadsheet is Spreadsheet is Spreadsheet clear & easy to read. Minor sonnewhat difficult to is VERY difficult to information has been cut off read. A few pieces of read & find johen neinted important information are information. Major omitted. information has been omitted. Chart(s) - IF APPLICABLE Chart is complete Chart is complete & Chart is missing & shows ALL required shows all required data, sonne data. Chart may be data. Best choice of chart Selection of chart type is missing type is used. Labels, titles appropriate. Includes labels, titles, labels, or a legend. & legend are included, title, & legend along with corative use of color & enhanced labelling to clarify meaning Chart is missing significant pieces of data & or legend BSBWRT401 - Write Complex Documents ASS-:- Create a scacs et S.",2ECC. Introduction A spread sheet tracks and records all of a business' day-to-day financial transactions. In turn, providing information relating to business growth, cash flow and profit margins. All of this can help you make more informed decisions about spending, keep your financial books in orde tax season and give you essential data on seasonal trends. Instructions for Student: Students are to develop a spread sheet for a small building surveying company to include: Income Expenditure The spreadsheet must also include a chart and formulas . Submission Document to submit: 26th November 2020 Submission to be via Moodle no later than the due date specified. This assessment will be graded in accordance with Rubric; see attached Rubric for Spreadsheet Criteria Exemplary 4 Accomplished Developing Beginning 3 Yes 2 1 Yes, but No, but No All required & A few minor additional applicable elements of required & information beyond applicable content are Information/Content requirements is entered & all instructions are followed are missing. completely Several required content elements are missing. Most instructions are not Tollowed. Organization Format Information is very O ting wel organized' by using appropriate advanced formatting, including shading, alignment tools. labels and bolding, borders, special fonts, appropriate labels, appropriate column/row height & width Most of the required content is entered, although missing & minor instructions applicable content above recuirements is missing. lo stinstructions are followed completely. Information Information organization is godal, using organization is appropriate standard falr, using standard formatting tools, such as formatting tools. Some labels or other important forr natting tools are missing irrottau n is poorly organized Appropriate formatting such as appropriate labels & column/row widths & height are not used. Several errors. Some required data may be missing. No formulas are used Data Entry, Computations, & Formulas o All data required is D All data required entered witn 100% data is entered correctly. accuracy. 100% use of Minor errors in correct correct applicable formulas formulas used. as required Some data required is missing. Several errors in formula calculations Visual Appearance & Output Spreadsheet is attractive, easy to read & all required information printed Coathing cut off Spreadsheet is Spreadsheet is Spreadsheet clear & easy to read. Minor sonnewhat difficult to is VERY difficult to information has been cut off read. A few pieces of read & find johen neinted important information are information. Major omitted. information has been omitted. Chart(s) - IF APPLICABLE Chart is complete Chart is complete & Chart is missing & shows ALL required shows all required data, sonne data. Chart may be data. Best choice of chart Selection of chart type is missing type is used. Labels, titles appropriate. Includes labels, titles, labels, or a legend. & legend are included, title, & legend along with corative use of color & enhanced labelling to clarify meaning Chart is missing significant pieces of data & or legend