1 / 17

A Statistical Tool in Classroom

A Statistical Tool in Classroom. Appreciate the features of MS Excel as a statistical tool in the classroom Use the available formulas and functions in spreadsheet program Produce a grading sheet and customized version of School Form 5 (SF5) . Basic Excel Skills.

livana
Télécharger la présentation

A Statistical Tool in Classroom

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

E N D

Presentation Transcript

  1. A Statistical Tool in Classroom

  2. Appreciate the features of MS Excel as a statistical tool in the classroom • Use the available formulas and functions in spreadsheet program • Produce a grading sheet and customized version of School Form 5 (SF5) ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  3. Basic Excel Skills 1. Open and close MS Excel program. 2. Create, save and close a workbook. 3. Save As an existing workbook. 4. Enter, edit, copy and delete a cell content. 5. Format text and numbers. 6. Apply cell borders and shading.

  4. Basic Excel Skills 7. Text wrap the cell content. 8. Use AutoFill feature. 9. Change row height and column width. 10. Insert and delete rows and columns. 11. Merge and unmerge cells.

  5. Basic Excel Skills 12. Hide and unhide columns and rows. 13. Insert, copy, move, rename and delete worksheet. 14. Freeze and unfreeze panes 15. Enter and edit basic formulas. 16. Use SUM, AVERAGE and IF functions.

  6. Basic Excel Skills 17. Preview worksheet in Page Break view. 18. Specify paper size, margins, orientation and page scaling.

  7. It is a software program produced by Microsoft Corporation that allow users to organize, format and calculate data with formulas using a spreadsheet system.  ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  8. A workbook can have two kinds of sheets: 1. Worksheet contains a grid of rows and columns into which user enters data 2. Chart sheet provides visual representation of data Cell reference identifies column/row location. A1 ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  9. Entering Cell Contents: • Text data • Combination of letters, numbers, and symbols • Number data • Numerical value to be used in a mathematical calculation ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  10. Cells and Ranges • Range reference indicates location and size of a cell range • (A1:G5) Adjacent • (A1:A5;F1:G5)Nonadjacent ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  11. Working with Formulas • Formula • self-defined instructions for performing calculations. ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  12. ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  13. Functions • Functions • pre-defined formulas in MS Excel. ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  14. Commonly Used Functions • Sum of values in column or row (SUM) • Average value in column or row (AVERAGE) • Total count of numeric values in column or row (COUNT) • Minimum value in column or row (MIN) • Maximum value in column or row (MAX) ICT Training-Workshop for Elementary Teachers of DCP E-Classroom Recipient Schools

  15. dcpoksiexcel@gmail.com

  16. Maria Teresa Morales-Capiral Teacher III/ICT Coordinator Lubang Integrated School

More Related