3. Smart Sheet Video Tutorials

This project will be a deep dive into Google Sheets, Libre/Open Office Cal, Excel, or other types of spreadsheets that students can use for cheminformatic processes. The idea is to develop new and novel sheets connecting to different APIs in different ways, and making YouTube videos on how these are done.

Rating:

No votes yet

Join the conversation.

Comments 9

Introduction

Hey, My name is Cody, and I am a student at South Dakota State University. I am interested in this project because I would really like to develop my skills using applications like Excel and Google Sheets. I have been new to many of the things that we have done with google sheets in the previous modules, so I was hoping to learn more of the uses. I was hoping to join this project, and possibly learn a little bit more about how it is going to be done. Thanks, Cody

Great Cody,

Great Cody, I think there is a lot of potential here. Please let Dr. Gupta know, and have her subscribe to comments, as she is the one grading you, and you need to be sure she is happy with what you do. I have a couple of quick questions. Do you have any programming skills? It is not necessary at all, but I am trying to get a bearing. Second, do you have a bearing on what you want to do when you graduate? You should pick a project that helps you, both now, and after you graduate. Module 7 deals with APIs and Dr. Kim is following comments on this module. So my suggestion is that we build up a project off of module 7 that uses PubChem. So what we need, is to figure out what we want our "Smart Spreadsheet" to do. I also will have a student at UALR who can probably work on this too. Cheers, Bob

This course is the deepest I

This course is the deepest I have ever gotten into programming, so I would say my programming skills are minimal. Being better with Excel, and programs like it, is something I have felt would be very beneficial to me in the future, and this module seemed like a great opportunity to learn something. I am a double major in biology and biochemistry, and I am hoping to pursue optometry school after I graduate. Right now I am helping in a lab that focuses on using microscopy to learn about various processes on the microscopic level. If you have any ideas I would be glad to hear them, since my knowledge of how these sheets can be used is minimal and its hard to imagine what all can be done. Thanks, Cody

Introduction

My name is Emily Choate. I am a graduate student at University of Arkansas at Little Rock. I would like to work on this project. I have some minor skills with Excel and Sheets. Emily

Google Sheets Projects

Emily and Cody, I am assuming you are both doing module 7, which should help with background skills. I think one of the challenges is that a smart spreadsheets are effectively cognitive tools that help you perform a task, and what you are doing is developing the skills to make that tool. Part of the challenge with a project like this is picking the "task" you would like to perform. So for example, in module 3 I wanted to be able to pull spectra images and data from the NIST Webbook, and did that with the sheet Name2Spectra. So what I suggest you two do, is start writing down ideas of the types of data you would like to be able to pull into a spreadsheet. Dr. Kim has already done some of these, but you can expand. For example, being able to pull an image of any molecule by writing its name, would be cool, or a mol file, that could then be loaded into JSmol. Dr. Kim already got the image to work, but can you break it? That is, can you use a common name or synonym? And then, is there a way you can get the synonym to work? Or how many ways can you do a task? And then compare them? (using PubChem, Chemspider, Opsin, NCI Chemical Resolver,...). But I think step one is to find something to do that you think is cool. Cheers, Cheers, Bob

Project Idea

In the lab I work with, we use antibodies a lot for tagging many different target molecules. One idea I've had is using a smart sheet that can produce information about antibodies (or targets) that I search. There are various websites such as Santa Cruz Biotech, Abcam, Abnovex, and Biocompare.com so it may be cool to have smart sheet that could search more than one site at a time, so that data could be compared. Thanks, Cody

Project Idea

My idea is if we had a list of 50 unknown chemicals could we get the names from the properties. This would be useful for analytical labs to help them with a lab where they have to identify the chemicals given to them. Emily

so you are saying, if you

so you are saying, if you have an unknown, and you make measurements, like a boiling point, molar mass, melting point, could you put those into a spreadsheet, and pull out of PubChem all molecules that cover that range? And also, limit it to a defined set of molecules? That is, sort of like an "AND" Boolean functions. [List of Molecules] AND [mp -01:01] AND [bp 99:101] AMD [MS 17:19].... Or just get a list of all molecules with a given boiling point?

Answer

Yes sir. That is what I was thinking. Emily

Comments 9

Annotations