Part A - Excel Spreadsheet Practical Test Essays - Spreadsheet

Part A - Excel Spreadsheet Practical Test Essays - Spreadsheet Part A - Excel Spreadsheet Practical Test The World Famous Web Shopping Experience You are lucky enough to win $2,000,000 dollars in a lottery that allows you to go on a web shopping spree. You can search the Internet for all the things you would love to buy but couldn't because your allowance just wasn't big enough. INSTRUCTIONS 1. Open a new Microsoft Excel document and name it as - Excel Shopping Spree. Email this work to me. 2. In cell A1 write the title of the worksheet: SHOPPING SPREE; bold, 12 point. 3. Create the following headings beginning in column A at cell A3. Format them to bold. Adjust column widths to display headings in full. |ITEM PURCHASED|PRICE | |/ 5 C |pie graph is well-formatted | | |includes a title | | |corresponding labels on each pie slice | | |percentage amounts on each slice | |/ 5 C |paragraph is well-written | | |proper spelling and grammar | | |paragraph sufficiently answers WHY particular items | | |were chosen | |/ 5 TI |spreadsheet is easy to read/scan | | |use of colour, fill, borders, etc. compliments the | | |overall document | Total: ______________ /25 Part B: Creating Stationary for your Business TASK ONE - Flyer Create a flyer advertising the opening of your business. It should tell the world about your business and the date you will open. It should be attractive, in full colour, and fit onto one page. Use Publisher. Rubric - Creating Stationary Assignment | |Needs more |Getting there |Good |Excellent! | | |Level 1 |Level 2 |Level 3 |Level 4 | |Task 1 | | | | | |Required Content|the publications |the |the |Level 3 AND | | |contain few of |publications |publications |publications | |Knowledge |the required |contain some of|contain most |are detailed | | |elements; or two |the required |of the |and creatively| | |publications are |elements; or |required |formatted | | |missing |one publication|elements; all | | | | |is missing |publications | | | | | |are complete | | |Task 1 | | | | | |Software Usage |several features |many features |the required |Level 3 AND | |Application |of the software |of the software|features of |advanced | | |have been |have been |the software |features of | | |correctly used in|correctly used |have been |the software | | |creating the |in creating the|correctly used|were | | |publications |publications |in creating |successfully | | | | |the |applied | | | | |publications | | |Task 1 | | | | | |Format |the correct |the correct |the correct |Level 3 AND an| |Graphics |format (e.g. |format (e.g. |format (e.g. |attempt is | |Communication |business letter, |business |business |made to engage| | |business card, |letter, |letter, |the reader by | | |etc.) is |business card, |business card,|creatively | | |sometimes used |etc.) is used |etc.) is used |extending the | | | |in most |in all |format with | | | |documents |documents |additional | | | | | |graphics and | | | |some attention |attention has |other details | | | |has been given |been given to | | | | |to make the |make the | | | | |document neat |document neat | | | | |and attractive |and attractive| | | | | | | | |Task 1 | | | | | |Written |the errors in |there are |there are few |Level 3 AND | |Communication |language |several errors |errors in |there is | |Communication |interferes with |in written |written |evidence of | | |communication |communication |communication |proof-reading | | | | | |and | | | | | |spell-checking| | | | | |to ensure a | | | | | |professional | | | | | |product | Comments: