Forum Replies Created
-
Posts
-
The yellow highlighting is there because the data for each of those columns is using a formula to populate the cells for that attribute. You can eliminate the highlighting by clicking on the attribute name and selecting “Delete formula (keeping values)”. If you do this for all of those merged columns you can then delete the other table. In fact, it might be preferable to delete that other table if you have the geoJSON boundary definitions in both tables, as the maps will plot both sets of duplicate boundaries.
FYI, there is this nice help page on joining tables:
https://codap.concord.org/help/work-tables/join-two-tablesDefinitely sounds strange. I’ve imported GeoJSON files with no issue in the past into existing documents. The other thing to try would be to import the GeoJSON into a new CODAP doc and then drag in the other dataset. If you sent both files to Bill via email he can try to report back on what he found as well.
Are you saying the entire CODAP document disappears and the browser opens your GeoJSON file?
You should be able to import any number of datasets into a single CODAP document. Once you have two (or more) tables, you can drag an attribute from one table to a matching attribute on the other table to merge data between tables.
If you haven’t tried it, perhaps try using the “Import” option from the CODAP menu on the upper left of the CODAP window.
All of the imported tables should be available in the “tables” menu on the CODAP toolbar.
Here’s a link to a video about how to set your own colors and also to the document in the video.
Video: https://somup.com/c0QrqvBfjb
Do these functions work to calculate quartiles in the way you would like? Click on the Q1 or Q3 attributes and select “edit formula” to see how they were written. You can also experiment with changing the list of values to explore varying results calculated from different lists of numbers.
Samet seemed to be having an issue posting in the form so he sent this to me directly: https://codap.concord.org/app/static/dg/en/cert/index.html#shared=https%3A%2F%2Fcfm-shared.concord.org%2FZ3PGluDSt9u4QU7pI6Ma%2Ffile.json
Samet, I opened the doc and changed the “values” attribute on the right table to the one you said you wanted and it worked for me, changing the graph axis as well. See image.
Attachments:
Hi Samet,
Can you create a share link to your document and post that? It’s not clear what is going on here. If both graphs are of the same “value” column, then why do they have different numbers of values?
It looks like you are using two spinners, so I thought perhaps there might be two data tables. You can check for that in the tables menu (the table button in the toolbar).
I tried to reproduce but could not, so being able to look at the shared CODAP doc would help with figuring this out.
Ideally, someone has already created a GeoJSON file (or something that could be converted to that format) for the regions you are interested in. I’d start by googling “[name of regions] GeoJSON” to see what comes up. For example if I were interested in the different counties in Massachusetts I would google “Massachusetts counties GeoJSON.”
You can even create your own regions by using a tool like: https://support.planet.com/hc/en-us/articles/360016337117-Creating-a-GeoJSON-file
Once you have the GeoJSON file of the regions you want, you can drag that into CODAP and when you open a map those regions will be displayed.
If you have added data to your table with the regions (additional columns that contain data for each region), then you can drag one of those column headers to the map and the regions will be colored by that attribute (column header).
When I first click on a shared link – before I open the document – it still says “Untitled document” – so if I’m trying to see what dataset I’m opening, I actually have to open it, rather than just clicking on the link for a preview. Any chance that can be changed?
I’m not sure we can fix this. The way the link works for opening a document in CODAP is to first open CODAP (with the default title of the webpage being “untitled document – CODAP”) and then passing in a key (the rest of the URL) which specifies what CODAP document to load after CODAP has been launched and loaded. So the preview link doesn’t know anything about what document will be loaded and can only show you the default web page title for CODAP before any doc is loaded.
I was confused about your answer to my last question: I thought that a student could just save a shared file to Google Drive (using Save) and the teacher could look at it – rather than having to create another shared file. Am I wrong about that?
So there’s sharing using CODAP share links, and sharing using Google Drive’s file sharing feature. We need to be clear about which sharing we are talking about. If you open a CODAP document that you did not author (via CODAP share link or one of the built-in examples) then you basically have a new copy of the document to play with and modify. This “new” document will not have CODAP sharing enabled and thus no share link to share with others (unless the user enables sharing).
However, if we are talking about Google Drive sharing privileges, then yes, once you share using Google Drive’s sharing then there is only one file, not a share link to a copy of the original. For this reason we generally discourage people from sharing original docs this way because there can be problems if more than one person opens the doc from Google Drive at the same time and both have Google Drive edit privileges. The most likely scenario is that whoever modified the file last will overwrite whatever the other person did. The worst case scenario when two people separately have the document open and are editing it is that the file gets corrupted.
So, to be safe, we generally suggest sharing via the CODAP sharing mechanism which always provides the person who clicked on the share link with their own copy. Using Google Classroom the Google Drive privileges are managed by the Classroom assignment mechanism. Once the student clicks “turn in” then they go from having edit to read only access to their doc, so there is no worry about two people having shared edit access to the same Google Drive file.
When I open a shared link, the document is called Untitled Document. Is there any way to change that?
That was a bug that has been fixed. If you make a new shared document now it will have the same title as the original doc that has sharing enabled.
When I open a shared link, the resulting document does not have sharing enabled. (Correct? That would just be if I wanted to change the document and shared the updated version.)
When you open a shared link is it like opening a new document or one of the built in example docs. So, yes, sharing is not enabled. The user always has to explicitly turn on sharing for a document. Once that is done and the document is saved, the document they are working on will have sharing enabled.
Is there any way to tell when one opens a link whether that document is a shared copy or not? (If I can see the link and it has “shared” in it, I know it’s a shared copy – but if I can’t see the link, is there a way to know?)
The only way clicking on a link would NOT open a shared document is if they had a link to the original document saved on Google Drive. In that case they would be asked to log into Google Drive to open it, and they would only be able to open it if they have access to it. You are correct that if you can see the URL, then it will have “shared” in it somewhere.
And just to be sure – once students have a shared link, they can just save a copy to share with a teacher without making a new shared link, right?
If they open a share link and modify that document, they will need to enable sharing and use the link to their shared document if they want to share back the changes. This all assumes they are not using Google Classroom to assign and work on documents. Here’s a video we plan to post soon on this: https://drive.google.com/file/d/1uhpm7SuBLtBBFK90B55J5PM0HQArxEF2/view?usp=sharing
There is also a new help page coming soon with info about sharing in a classroom setting using Google Classroom and the technique you have been using/describing above which works with any system for sharing links.For univariate distributions you can add a moveable value and see counts (and/or percentages) of data points on either side of the value. See screencast.
By default CODAP will try to determine the if an attribute is categorical or numeric. If any cell has a non-numeric value then the attribute is assumed to be categorical for graphs. However, you can click on the attribute, “Edit Attribute Properties…” and set it to be numeric. In that case the graph will only include numeric cells.
Regarding formulas that require numerical inputs, most will ignore non-numeric cells when calculating values. For, example, the mean of a set of values with mixed numerical and non-numerical cells will just include the numerical cells. See example below:
