| This could be useful. |
Then I made a named range from the columns. Technically for this lookup, you only need two columns--however, you could also do this lookup from a much bigger table if you needed. The named range makes it easier to write the formula for looking up emails, and allows you to add or subtract staff members each year as people retire/get hired without having to go back and manually change every single formula.
You can look up any of these commands with the google help file and it explains pretty clearly all the options and parameters for each.| Typing our essays on student desktop, Chromebook, and hand written. |
![]() |
| Working on a Slide Presentation for Speaking and Listening Standards |
| Part of our class writing essays. |
![]() |
| Starting my first google Classrooms. |
J’s 12th grade co-teach class is going to do a unit on science fiction short stories and wanted a list of a few good ones. So I’m posting here to get some titles.It's that time of year again, so I've got a couple of students asking me for more suggestions. I emailed this same list to them and I'll again ask for suggestions this year so I can have a wider list every time I send it out.
I suggested Arthur C. Clarke’s Nine Billion Names of God and Asimov’s Nightfall. I also gave some authors: Zelasny, Heinlein, L. Niven, a couple others.
Nightfall is hardly short at 300+ pages but it fits the genre in other ways.
Any other suggestions from folks?
@techsavvyed hey tech dir., if you could tell us teachers one important thing to make tech run smooth, what would it be?
— Andrew Hyland (@AndrewHyland) March 4, 2015
Pretty vague and open. Ben and Pete both took a turn giving me an answer in his podcast. Skip ahead to 13:00 and listen to how well Pete and Ben interpret my vague wording and both give useful answers to help make working with tech in education a little less of the nightmare it can be on the worst days.Spelling suggestions as you typeAs you type, Docs automatically underlines in misspelled words in red. Right-click an underlined word to see the suggested correction and replace the misspelled word.You can turn off the spell-checker by unchecking Show spelling suggestions from the Viewdrop-down menuClick here for the full page.
Well, the wifi seemed to be fixed for good and the lunch line was practically zero on Day 2, so I can give CUE and ACHS some props for at least fixing some problems quickly. Peter and I had selected our sessions late last night--we were ready to rock and our shared GDoc filled up fast with notes through the day. Next time I think I'll pick a time to have an empty session to run by all the vendors and see what's up quickly. This time we needed to maximize the info-grab. But a person can only process so much and implement so much each school year.
I believe I have the script completed for the first half of my project. At least, I can make the computer fetch and use all the data in question. One bump at this stage is turning out to be triggering the script in such a way that it will run completely and automatically when a form is submitted. That might be a huge task if I end up having to make half of the data lookups happen inside the script instead of inside the spreadsheet.