Day 2-CBA-Coleman

Elkins​ ​School​ ​District

Alternate​ ​Method​ ​of​ ​Instruction​ ​(AMI) AMI​ ​Day​ ​#_​_2​___ School​ ​Name

Elkins​ ​High​ ​School

Teacher​ ​Name

Amanda​ ​Coleman

Subject​ ​/​ ​Course​ ​Name

CBA

Assignment​ ​Description

ONLINE:​ ​Follow​ ​the​ ​directions​ ​on​ ​the​ ​second​ ​page.​ ​ ​You​ ​will upload​ ​to​ ​Google​ ​Classroom​ ​when​ ​finished. PAPER​ ​HARD-COPY:​ ​Follow​ ​the​ ​directions​ ​on​ ​the​ ​second​ ​page. You​ ​will​ ​save​ ​to​ ​your​ ​computer​ ​and​ ​upload​ ​when​ ​we​ ​get​ ​back​ ​to school.

Contact​ ​Information

PHONE/TEXT​:​ ​(if​ ​teacher​ ​wants​ ​to​ ​give​ ​out​ ​this​ ​information EMAIL​ ​ADDRESS:​ ​ ​[email protected] OTHER:​ ​ ​(maybe​ ​website,​ ​google,​ ​remind​ ​app,​ ​etc.)

Assignments​ ​will​ ​be​ ​graded​ ​and​ ​entered​ ​into​ ​the​ ​gradebook​ ​according​ ​to​ ​the​ ​teacher’s​ ​grading​ ​system. Attendance​ ​will​ ​be​ ​recorded​ ​based​ ​upon​ ​completion​ ​of​ ​the​ ​assignment.

CBA:​ ​ ​Excel​ ​Spreadsheet Krispy​ ​Crème​ ​Doughnuts​ ​Spreadsheet Directions: ● ● ● ● ● ● ● ● ● ● ● ● ● ● ● ●

Create​ ​the​ ​spreadsheet​ ​below Change​ ​the​ ​title​ ​font​ ​to​ ​Adobe​ ​Kaiti​ ​Std,​ ​22​ ​pt Merge​ ​and​ ​center​ ​the​ ​range​ ​A1:F1 Merge​ ​and​ ​Center​ ​the​ ​range​ ​A2:​ ​F2 Add​ ​a​ ​fill​ ​of​ ​“White,​ ​Background1,​ ​Darker​ ​5%”​ ​to​ ​the​ ​title Bold​ ​the​ ​title,​ ​main​ ​headings,​ ​and​ ​totals Format​ ​Cell​ ​alignment​ ​to​ ​angle​ ​counterclockwise​ ​to​ ​35%​ ​the​ ​subtitles​ ​(Name,​ ​Glazed,​ ​etc) Change​ ​the​ ​column​ ​widths​ ​of​ ​B​ ​through​ ​E​ ​to​ ​10 Change​ ​the​ ​column​ ​width​ ​of​ ​A​ ​and​ ​F​ ​to​ ​12 Center​ ​align​ ​column​ ​A Use​ ​a​ ​formula​ ​to​ ​total​ ​the​ ​boxes​ ​sold​ ​for​ ​each​ ​seller.​ ​ ​Use​ ​the​ ​auto​ ​fill​ ​handle​ ​(my​ ​favorite)​ ​to copy​ ​the​ ​formulas Total​ ​each​ ​column Multiply​ ​the​ ​Totals​ ​by​ ​the​ ​cost​ ​per​ ​box​ ​to​ ​find​ ​the​ ​cost​ ​totals.​ ​ ​Copy​ ​the​ ​formulas. Multiply​ ​the​ ​Totals​ ​by​ ​the​ ​profit​ ​per​ ​box​ ​for​ ​the​ ​Profit​ ​totals.​ ​ ​Copy​ ​the​ ​formulas. Sort​ ​the​ ​worksheet​ ​by​ ​column​ ​F​ ​(TOTAL​ ​BOXES​ ​SOLD)​ ​in​ ​descending​ ​order The​ ​spreadsheet​ ​should​ ​be​ ​in​ ​LANDSCAPE​​ ​and​ ​must​ ​fit​ ​on​ ​ONE​ ​page.