PLC Guiding Questions:
- What is it we want our students to learn?
- How will we know if each student has learned it?
- How will we respond when some students do not learn it?
- How can extend and enrich the learning for students who have demonstrated proficiency?
- Compare and contrast the uses of Word, PowerPoint and Excel.
- Excel is primarily used for analyzing and manipulating data.
Worksheet = a row-and-column matrix sheet on which you work
Spreadsheet = this type of computer application
Workbook = the book of pages that is the standard Excel document.
Cell = The workbook is made up of cells. There is a cell at the intersection of each row
and column. A cell can contain a value, a formula, or a text entry.
Task 1: Entering and Formatting Data
a. typing specific data in cells (data from Bell Work document)
b. changing cell size using the data that was just entered
c. making text bold using the data that was just entered
Task 2: Using a Formula
a. "average" formula will be used with test scores-row 3
b. copy formula for remaining students
Task 3: Adding and Copying Pages
a. add a page to workbook
b. rename the page (sheet)
c. copy and paste data from bell work document into new page (sheet)
Task 4: Filtering and Sorting
a. sort A-Z
b. custom sort, add levels
c. filter data; sort by criterian
***Look at School Templates (optional)--In Excel, click 'New'. In the search line,
type in "School" to see the different templates available in Excel.
Closure: Go to this Padlet and answer each of the questions at the top of the board.