1 / 12

MS Excel: Classroom Tool for Learning

MS Excel: Classroom Tool for Learning. Brandon Dolce Erinn Edwards. Today’s Agenda. Understand the different spreadsheet charts and practice using them in various scenarios Understand Absolute/Relative Cells Use shortcuts to accomplish tasks quickly.

tashya-alvarado
Download Presentation

MS Excel: Classroom Tool for Learning

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. MS Excel: Classroom Tool for Learning Brandon Dolce Erinn Edwards

  2. Today’s Agenda Understand the different spreadsheet charts and practice using them in various scenarios Understand Absolute/Relative Cells Use shortcuts to accomplish tasks quickly. Provide Resources for additional support Q/A Session, Wrap-up

  3. Connecting Across Curriculum Health/PE Science Math And others…. Social Studies MS Excel can be integrated across all content areas.

  4. Spreadsheet Charts • One of the easiest ways to integrate spreadsheets into curriculum is using charts. • We will explore the 4 main types of charts in Excel: • Pie • Line • Bar • Scatter

  5. Your Assignment • Open MS Excel and complete the tasks given to create each chart type. • Look for ways that you can use charts in your instruction and be prepared to share with group. • Save your files for future reference!

  6. How Can You Use Spreadsheets? 5 Take 5 minutes to discuss

  7. Relative and Absolute Cells • Relative Cells are cells whose content will change when a formula or function is copied to other cells. • With absolute cells, the content stays the same, even when copied to other cells. • Example: Absolute cells are used when a value in a formula needs to remain constant. • Formula- C2*D2/C10 • Absolute Formula- C2*D2/$D$10 (Which cell is Absolute?)

  8. How to change a cell to Absolute? Simply add “$” to the Cell Address (D10 became $D$10) OR In formula window, go to part that needs to be absolute and hit F4 key.

  9. Excel Shortcuts • Save time by using various shortcuts: • Selecting/Highlighting Cells • Fill Button • Making a cell absolute • Etc…

  10. Additional Resources Atomic Learning: has extensive lessons on MS Excel Free Training Tutorial site: also has detailed lessons and practice activities. YouTube: have to search but there are some good videos if you like to be “talked” through an activity.

  11. Questions?

  12. More Questions?: Email erinnl.edwards@cms.k12.nc.us brandonl.dolce@cms.k12.nc.us

More Related