8th+Excel+Thanksgiving

8th Grade Thanksgiving Excel url}?f=print|print this page

__PA standards__ –
 * NETS.1.6-8: Students demonstrate creative thinking, construct knowledge, and develop innovative products and processes using technology.
 * NETS.2.6-8: Students use digital media and environments to communicate and work collaboratively, including at a distance, to support individual learning and contribute to the learning of others.
 * NETS.3.6-8: Students apply digital tools to gather, evaluate, and use information.
 * NETS.6.6-8: Students demonstrate a sound understanding of technology concepts, systems and operations.

__Objectives__ - __Warm up__ –Each class I will introduce a skill listed in the vocab section and demonstrate how to use it in Pages.
 * Workbook Skills
 * Working with toolbars
 * Working with the menus
 * Keyboard moves
 * Entering info in a spreadsheet
 * Using a template
 * Renaming an existing workbook || Borders and Styles
 * Using the borders button
 * Using the fill color button
 * Creating a style by example || Page Setup
 * Print preview and page set up
 * Creating headers and footers
 * Repeating row and column labels
 * Using page break preview ||
 * Objects, Pictures, and Diagrams
 * Inserting a draw object into a worksheet
 * Drawing a line or arrow in a worksheet
 * Formatting a drawing object
 * Resizing a drawing object
 * Adding text to a drawing object
 * Drawing a text box
 * Inserting a picture
 * Formatting a picture or a graphic || Formulas & Functions
 * Entering formulas
 * AutoSum and AutoSum list
 * Basic functions
 * Inserting functions in formulas
 * Editing functions
 * Drag down fill || Formatting Skills
 * Number formatting
 * Formatting using the toolbar
 * Formatting using the formatting palette
 * Cell alignment and spacing
 * Shrinking or wrapping text in a cell
 * Selecting columns and rows
 * Changing column width and row height
 * Inserting or deleting a column or row
 * Inserting or deleting selected cells
 * Using the merge and center button ||

__Tech lab__ #

__Evidence of best practice__ – students will be able to refer to the video and helpful tips on my wiki at anytime they get stuck, peer instruction

__Activity__ - After researching the cost of some Thanksgiving items make a graph and a chart using excel...

First go across row 1 and type in A1 – Items, B1- Quantity, C1 – Cost, D1- Total cost.

You are to make a list, in excel, of the items you need to purchase for a Thanksgiving night. Included in the list is…


 * 1) Turkey 20 lbs
 * 2) Stuffing (3 boxes)
 * 3) cranberry sauce (3 cans)
 * 4) sweet potatoes (3 lbs)
 * 5) pumpkin pie (1 pie)
 * 6) Cool whip (2)
 * 7) ice cream (3)
 * 8) green beans (3 lbs)
 * 9) butter (2 lbs)


 * 1) Go online and research the cost of these items – enter the data into your chart.
 * 2) Use MULTIPLICATION FORMULA to find the Quantity*Cost=total cost.
 * 3) REMEMBER each formula must start with an equal sign (=) -- Example - =B2*c2
 * 4) Once all your info is in the chart write TOTAL on the last row and total each column with the SUM tool.
 * 5) Resize the text and cells as necessary to make a nice presentation


 * WHERE TO GET PRICES -**
 * shoprite
 * walmart groceries
 * netgrocer

MAKING THE GRAPH – highlight only the columns with items names and total cost (DON’T include the total at the bottom). You can highlight to column not next to each other by highlighting one and then holding the COMMAND key and highlighting the other. Then choose your graph. A picture is always a nice addition


 * Scoring guide – (100 pts) **
 * Chart || Graph ||
 * ¨ ** All items in chart (all items, quantity column, cost column, total column) - 10 ** || ¨ ** Title - 10 ** ||
 * ¨ ** Cells and font sized appropriately - 10 ** || ¨ ** Horizontal labeled - 10 ** ||
 * ¨ ** Total in each column is using sum tool - 5 ** || ¨ ** Vertical labeled - 10 ** ||
 * ¨ ** Picture included (clear & Relevant)- 10 ** || ¨ ** All data is readable - 10 ** ||
 * ** - borders - 5 ** || ¨ ** food on one side and numbers on other – 10 ** ||
 * ¨ ** Saved correctly – LOSE 5 additional points ** ||  ||
 * ¨ ** Your name appears on the page - 5 ** ||  ||
 * ¨ ** One page only - 5 ** ||  ||
 * ¨ ** One page only - 5 ** ||  ||


 * Samples **

media type="custom" key="11320504"