TRICK OR TREAT?

2. TRICK OR TREAT? Learning to use Excel

3. Assessment and Awareness • Student Prior Knowledge: • How to gather information to be put into a table. • Basic layout of table with columns and rows. • Basic knowledge of graphs.

4. Such as how to create a graph with paper and pencil. • How to read a graph. • How to understand a graph. • Location of the Excel Program on the computer. • How to use a Smart Program. • Basic Social Skills. • Basic Counting • Basic Writing Skills

6. Learning Objectives • Career Connections: • Life Skills • Math • Technology • Students will : • Verbal expression • Cooperative Learning • Team Building behavior. • represent data to convey results at a glance using concrete objects, pictures and numbers.

8. Students using concrete objects, pictures and numbers. • Students using spatial skills. • Students increase their self confidence when using technology.

9. Formulate questions they want to investigate. • Collect data using observations, measurements, surveys, and or experiments. • Students use graphs to analyze data.

10. Materials: • Student Activity Sheet • Excel Template • Students Halloween Candy, • Simple Gathering Grid, • Spreadsheet Program • Pencil, paper • Computers for students • Containers for Halloween Candy

11. Introduction to Excel

12. Excel Vocabulary • Active Cell– This is the cell in a spreadsheet where information will be placed. It is the cell that has been selected. • Ascending Decimals– Function that allows the user to increase decimals places of a number typed in a cell. • AutoSum– Function that automatically adds selected cells. • Cell – This is the place where information is held in a spreadsheet.

13. EXCEL • Cell Address– Use this to know the exact location of a specific cell. Noting the intersection of the column and row forms it. The last cell address on a worksheet is IV65,536. • Column– In a spreadsheet, these are the vertical spaces. Columns are headed with letters. There are a total of 256 columns on one worksheet. The last column is IV.

14. EXCEL • Descending Decimals- Function that allows the user to decrease decimals places of a number typed in a cell. • Dollar Symbol– Function that changed the contents of a cell to currency. Adds a dollar sign and decimal places • Equation – A mathematical equation typed into a cell.

15. EXCEL • Entry/Formula Bar– The toolbar on the Microsoft Excel window that shows the text or equations assigned to cells • Merge and Center– Function allowing the user to select a number of cells to create one large cell with the information centered within the large cell. • Microsoft Excel– A spreadsheet application tool that analyzes data in a table format using formulas.

16. EXCEL • Name box– Displays the cell reference, which is the location of the active cell in the worksheet. It is located on the left side of the formula bar. • Percent– Function that allows the user to change the value of a cell to a percent. • Row– In a spreadsheet, the row is the horizontal group of cells. Rows are named with numbers, i.e.1, 2, 3. There are a total of 65,536 rows on a worksheet.

17. EXCEL • Sheet tabs– Labels located at the bottom of the workbook window indicating the worksheets. • Spreadsheet – A document that is used to crunch numbers and formulas. • Sort – In a database, this function puts the records into a specific order.

18. EXCEL • Workbook – An Excel document which contains three worksheets by default but can have more than three. • Worksheet – A single sheet contained in an Excel workbook.

20. ASSIGNMENT Chose a treat bag. Activity sheet. Writing Utensil. Gather information from peers. Place information on Excel. Make a bar and web graph.

21. Final Assessment • Students will have a working knowledge of Excel • Excel vocabulary used in sentences and conversation • Students will be involved in Cooperative Learning and • Team Building Activity • The Students will show the ability to use Excel Excel reviewed often in Class