This free survey is powered by
  1. Surveys
  2. 2015
  3. September
  4. W
  5. Where you at?
0%
Exit Survey
 
 
Hi class,

The way most courses are set up, we only learn how much students know, we don't know how much they learn. 

I am doing this pre-course assessment with the hope of finding out how much you know before we start. That way I will have some idea by the end of the course how much of a difference this course made in your knowledge. In other words, how much you actually learned. Please only take it one time ... I am counting on the results to be accurate.

This is not for a grade and the results are anonymous if you don't include your ID number at the end. But if you would please answer all of the questions with reasonable effort, and give your ID number at the end, you will be rewarded with a cookie. 

:-)

I am deliberately keeping it short so that you can do it quickly and easily. Please do not get help from any source (even by opening Excel) in order to provide me with accurate results.

Thank you for helping me assess my teaching.
 
 
 
* Have you taken a course where you learned how to use spreadsheets?
 
Yes
 
No
 
I don't remember
 
 
 
SUM, MIN, MAX, and AVERAGE are all examples in Excel of?
 
Keywords
 
Formulas
 
Functions
 
Activities
 
I never learned this.
 
I don't remember.
 
 
 
If an Excel cell contains the following ... =A1*B2
then that tells you that
 
that cell contains a formula that adds up the values in all the cells from A1 to B2
 
that cell contains a function that adds up the values in all the cells from A1 to B2
 
that cell contains a formula that adds up the values in the cells A1 and B2
 
that cell contains a formula that multiplies the values in the cells A1 and B2
 
that cell contains a function that adds up the values in the cells A1 and B2
 
that cell contains a function that multiplies the values in the cells A1 and B2
 
I never learned this.
 
I don't remember.
 
 
 
If you open a previous year's budget spreadsheet, make the changes for this year's budget, and want to save it under a new name for this year, how would you do it? (Type in "I don't know" or "I don't remember" if that is the real answer ... please do not just guess.)
   
 
 
 
If a cell is labeled B5, that means that it is located in ...
 
Column B and Row 5
 
Column 5 and Row B
 
The fifth cell over from Column B
 
The fifth cell below Column B
 
The fifth cell over from Row B.
 
I never learned this.
 
I don't remember.
 
 
 
To format text in Excel you can ...
 
Click on the cell that contains the text and click on the B icon in the Format ribbon
 
Click on the row that contains the text and click on the B icon in the Format ribbon
 
Click on the column that contains the text and click on the B icon in the Format ribbon
 
Click on the column that contains the text and press the Ctrl and b keys on the keyboard.
 
I never learned this.
 
I don't remember.

 
 
 
What formula or function is used in Excel to calculate Standard Deviation? (Type in "I don't know" or "I don't remember" if that is the real answer ... please do not just guess.)
   
 
 
 
To rename a worksheet tab in Excel, you should...
 
Right-click on the tab, choose "Rename" from the menu, and type in the new name.
 
Right-click on the worksheet itself, choose "Rename" from the menu, and type in the new name.
 
Choose "Rename Tab" in the format menu, type a new name in the dialog box, press Enter.
 
Choose "Worksheet setup" and change the worksheet name in the list. Press Enter.
 
I never learned this.
 
I don't remember.

 
 
 
To get your cookie, please enter your student ID here and then tell me one thing that you hope to learn from the course.
   
 
Share This Survey:          Online Survey Software Powered by  QuestionPro Survey Software