B | C | D | E | F | G | H | I | J | K | L | M | N | O | P | Q | R | S | T | U | V | W | X | Y | Z | |
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
1 | ID# | DESCRIPTION (for each item below use YOUR column on the right and the TRIANGLE to indicate GOT IT or NEED HELP or NOT SURE) | A | D | F | H | J | L | R | S | | HOW DID I GET THE LETTERS VERTiCAL ON THE LEFT? HOW DID I GET THE TRIANGLE PULL DOWNS BELOW? Please put onto your "ASK STEVE" list for our next one on one conversation | |||||||||||||
2 | 1 | Name each of the modules of GD and state one interesting unique feature about each one? | got it | got it | got it | got it | *** | got it | got it | got it | *** | SKILLS 21 to 47 ARE PART OF LESSON 5 | |||||||||||||
3 | 2 | What are the steps for sharing a file in GD? What are 3 different privilege levels you can give each user? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
4 | 3 | How can you share a GD file with a large number of users using a GROUP of EMAILS? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
5 | 4 | What are the steps to making a GD file to be public to anyone with the link and how does TINYURL.COM work to help us with this? What is the disadvantage of using this approach? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
6 | 5 | What does it mean to "object oriented" vs "bit-mapped" in terms of drawing? Which one is GD Drawing? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
7 | 6 | What is the formula in a GD spreadsheet to add up the cells in a range such as D2 to D9? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
8 | 7 | What is the rationale for requiring all your students in a class to use a standard file saving name? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
9 | 8 | What is the feature called under the TOOLS menu that lets you instantly look up information or pictures on the web to pull into a GD file? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
10 | 9 | How do you change the citation style in GD from MLA to APA to Chicago? | got it | got it | got it | got it | *** | got it | *** | got it | *** | ||||||||||||||
11 | 10 | How do you convert a Microsoft Word file into a GD file? | got it | got it | got it | got it | *** | got it | *** | got it | *** | ||||||||||||||
12 | 11 | How do you convert a GD file into a Microsoft file? | got it | got it | got it | got it | *** | got it | *** | got it | *** | ||||||||||||||
13 | 12 | Demonstrate how to insert 1 picture and 1 quote into a GD using the RESEARCH TOOL creating 2 footnotes and using a certain citation style (MLA, APA, Chicago). | got it | got it | got it | got it | *** | got it | *** | got it | *** | ||||||||||||||
14 | 13 | Explain how to use GD to find pictures that are copyright free. | got it | got it | got it | got it | *** | got it | *** | *** | *** | ||||||||||||||
15 | 14 | What is the preferred technique of sharing a large group of files with several contacts? | got it | got it | got it | got it | *** | got it | *** | got it | *** | ||||||||||||||
16 | 15 | How many owners can a document have? Is it possible to make someone else the owner? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
17 | 16 | Demonstrate how to use the "magic spot fill down technique" and explain why some times we highlight one cell and other times we highlight two cells? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
18 | 17 | How do you make numbers look like currency? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
19 | 18 | What formula do we use to calculate percent increase? For example if you have a number in cell E3 and you want to type into E4 a formula to calculate 9% increase, what exactly would you type? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
20 | 19 | What are the names for the two ways text in a WP document can interact with a graphic, e.g. the graphic is called ______ or _____________ . Demonstrate an example of each in a GD WP document. | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
21 | 20 | How we do create separate worksheets in one GD spreadsheet? How do you name or rename each one? | got it | got it | got it | got it | *** | got it | got it | got it | *** | ||||||||||||||
22 | 21 | What are the various data types you can use for each question in a GD Survey Form? | *** | got it | *** | got it | *** | *** | *** | *** | *** | QUESTIONS 21 - 47 are related to Lesson 5 | |||||||||||||
23 | 22 | Which GD Survey Form data type allows the user to click on more than one choice? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
24 | 23 | Is it possible to change the order of your questions in a Google Survey Form? If so, demonstrate or explain how. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
25 | 24 | What are the 2-3 different ways you can see and maintain the data from those people who have completed your survey form? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
26 | 25 | What is meant by DATA VALIDATION in a GD Survey Form? What are some examples for using this? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
27 | 26 | What type of question in a survey form do you use if you want the user to check off items within a rectangle that is 2 x 5? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
28 | 27 | What type of question in a survey form do you use if you want the user to indicate a number from 1 to 5? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
29 | 28 | What is the grading program that works with GD and helps to grade the student answers? F L _ _ _ _ O O? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
30 | 29 | What are the steps for creating a chart on GD? What should be in the first row of the SS? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
31 | 30 | What is the symbol used on a GD spreadsheet to achieve absolute reference? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
32 | 31 | What is the exact formula we use if we to multiply B4 by the amount that is entered into A1 and we want A1 to be an absolute reference sacred item? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
33 | 32 | What is the rule of 72 in terms of money increasing in a bank at certain percentages? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
34 | 33 | How many parameters ("chunks") within the IF formula on a GD SS? What does each one stand for? Give an example. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
35 | 34 | What is the ICON called that is used frequently on webpages to make sure that a human being is entering the info and not an automatic computer doing it? Bonus? What does it stand for? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
36 | 35 | What module of Google allows you to make a web site? What is the URL for that area of the Google world? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
37 | 36 | What is the name of the add-on to GD that allows you to add voice comments to a GD WP document? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
38 | 37 | When you have a Google WP document and you want to open it with Kaizena, what do you choose after right mouse clicking on the document -- not OPEN but rather O _ _ _ W _ _ _ ? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
39 | 38 | What add-on to GD allows you to take a 2 column SS (with proper headings) and turns the items below into flash cards? F_ _ _ _ _ t y . And yes. this is .net not .com as a website! | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
40 | 39 | To avoid hassles, all users should always make their first few Google sites _________ instead of using a template. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
41 | 40 | To add a page to your Google site, you click the _____ | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
42 | 41 | Demonstrate how to make a new Google site and then change the color scheme. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
43 | 42 | What command symbol in GD spreadsheets lets you join two cells together, e.g. what would you type into D3 so that B3 and C3 would be joined into one word? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
44 | 43 | What do you choose on a GD spreadsheet if you want to see all formulas? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
45 | 44 | How would you help a colleague who sorted a spreadsheet and discovered that the top line with labels got alphabetized into the body of the spreadsheet? | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
46 | 45 | Is it possible to take a spreadsheet where all data has been entered in the form of Doe, Jane and turn this column into 2 columns with first name and last name separated? Demonstrate how to do so. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
47 | 46 | How do you take a sentence on a GD spreadsheet and have it span 5 contiguous columns and 2 rows so that it is occupying those 5 columns and 2 rows with no dividers? Demonstrate how to do this and make sure your sentence is centered up/down and left/right when done. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
48 | 47 | Do you know how to hide rows and columns? Notice how I hid rows 2 to 20 for the first batch of questions. Also notice how I hid columns I and N for two people in our original group of 15 who have had to drop the course for personal reasons. | *** | got it | *** | got it | *** | *** | *** | got it | *** | ||||||||||||||
49 | |||||||||||||||||||||||||
50 | |||||||||||||||||||||||||
51 | |||||||||||||||||||||||||
52 | |||||||||||||||||||||||||
53 | |||||||||||||||||||||||||
54 | |||||||||||||||||||||||||
55 | |||||||||||||||||||||||||
56 | |||||||||||||||||||||||||
57 | |||||||||||||||||||||||||
58 | |||||||||||||||||||||||||
59 | |||||||||||||||||||||||||
60 | |||||||||||||||||||||||||
61 | |||||||||||||||||||||||||
62 | |||||||||||||||||||||||||
63 | |||||||||||||||||||||||||
64 | |||||||||||||||||||||||||
65 | |||||||||||||||||||||||||
66 | |||||||||||||||||||||||||
67 | |||||||||||||||||||||||||
68 | |||||||||||||||||||||||||
69 | |||||||||||||||||||||||||
70 | |||||||||||||||||||||||||
71 | |||||||||||||||||||||||||
72 | |||||||||||||||||||||||||
73 | |||||||||||||||||||||||||
74 | |||||||||||||||||||||||||
75 | |||||||||||||||||||||||||
76 | |||||||||||||||||||||||||
77 | |||||||||||||||||||||||||
78 | |||||||||||||||||||||||||
79 | |||||||||||||||||||||||||
80 | |||||||||||||||||||||||||
81 | |||||||||||||||||||||||||
82 | |||||||||||||||||||||||||
83 | |||||||||||||||||||||||||
84 | |||||||||||||||||||||||||
85 | |||||||||||||||||||||||||
86 | |||||||||||||||||||||||||
87 | |||||||||||||||||||||||||
88 | |||||||||||||||||||||||||
89 | |||||||||||||||||||||||||
90 | |||||||||||||||||||||||||
91 | |||||||||||||||||||||||||
92 | |||||||||||||||||||||||||
93 | |||||||||||||||||||||||||
94 | |||||||||||||||||||||||||
95 | |||||||||||||||||||||||||
96 | |||||||||||||||||||||||||
97 | |||||||||||||||||||||||||
98 | |||||||||||||||||||||||||
99 | |||||||||||||||||||||||||
100 | ANN | DENNIS | FARRAH | HANNAH | JESSICA | LISA | REGINALD | SHEN |