note to instructors i don’t really have “clicker” questions on the material in chapter 2 –...
TRANSCRIPT
![Page 1: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/1.jpg)
NOTE TO INSTRUCTORS
• I don’t really have “clicker” questions on the material in Chapter 2– Except to have them figure out how some of the
Excel features introduced actually have computing concepts embedded in how they are written/implemented
![Page 2: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/2.jpg)
What is a filter?
A. A means by which you can restrict the data shown in a table
B. A means by which you can sort the data stored in a table
C. A means by which you can remove (e.g. delete) the data in a table
D. A means by which you can graph the data in a table
![Page 3: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/3.jpg)
When might you choose to lock a cell?
A. When you want to make sure the value is within a certain range
B. When you want to make sure the value is of a certain type (e.g. Number, Text, etc.)
C. When you want to make sure the cell cannot be edited by others
![Page 4: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/4.jpg)
Starting with this, with sort below
![Page 5: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/5.jpg)
Chapter 2: Working with Large Worksheets and Tables
• A lot of this material is just “hands on” – How do I do that in Excel– You can do that in Excel?
• Figure it out now… you won’t remember it unless you use it regularly– Which you won’t– Google “How do I do XXX in Excel 2010”
• Critical:– If you didn’t have more data than fits on the screen,
you probably wouldn’t bother with Excel…
![Page 6: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/6.jpg)
Things Alice prepared you to do
• “Debug” how to freeze rows/columns– Who can remember when you highlight say row 5 and
select freeze panes• Will it keep rows 1-4 always visible or 1-5?• Try one, observe, know what to try next if it doesn’t go as you
want it…
• Lock cells:– Boolean condition attached to cell: property – on or off
(Alice had properties too!)• Abstraction (breaking big problems into smaller ones)– Excel file -> worksheets
![Page 7: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/7.jpg)
Find and Replace
• Question 32 was tricky. Anyone who got it wrong (0 points) should actually get 0.5 points
Not really!
![Page 8: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/8.jpg)
Excel’s find and replace command involves use of which of the following computing concepts?
If statements Looping ParametersA XB X XC X X XD X XE X X
![Page 9: NOTE TO INSTRUCTORS I don’t really have “clicker” questions on the material in Chapter 2 – Except to have them figure out how some of the Excel features](https://reader030.vdocuments.us/reader030/viewer/2022032805/56649ee65503460f94bf6d29/html5/thumbnails/9.jpg)
Which of the following Excel features involve conditional (if statement) actions?
A. Average ( =Average(A1:A30))B. Sorting Data (=Sort(A1:A30))C. AutoFilters (only show freshmen, female
flute players)D. More than one of the above