8th+Excel+Halloween

8th Grade Halloween Excel Chart and Graph project 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 Halloween items make a graph and a chart using excel...

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

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


 * 1) Costume (write what the costume is) (not over $30 because your graph will be messed up)
 * 2) M&M’s – 5 bags of snack size
 * 3) Snickers – 3 bags of snack size
 * 4) Resses – 2 bags of snack size
 * 5) Decorations – 3 items
 * 6) Candy Apples – 6 total apples
 * 7) 3 items of your own choice


 * 1) Go online and research the cost of these items – enter the data into your chart.
 * 2) <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">Use MULTIPLICATION FORUMLA to find the Quantity*Cost=total cost.
 * 3) <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">REMEMBER each formula must start with an equal sign (=) -- Example - =B2*c2
 * 4) <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">Once all your info is in the chart write TOTAL on the last row and total each column with the SUM tool.
 * 5) <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">Resize the text and cells as necessary to make a nice presentation

<span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;"> 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. <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">A picture is always a nice addition

<span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">**Scoring guide – (100 pts)** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **All items in chart (all items, quantity column, cost column, total column) - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Cells and font sized appropriately - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Total in each column is using sum tool - 5** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Picture included - 5** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Saved correctly – LOSE 5 additional points** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Your name appears on the page - 5** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **One page only - 5** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">**Graph includes:** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Title - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Horizontal labeled - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Vertical labeled - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **All data is readable - 10** <span style="font-family: Arial,Helvetica,sans-serif; font-size: 110%;">¨ **Candy on one side and numbers on other – 10**

**Sample:**