Comments (3)
It looks like Google Sheets has a similar functionality with its validation rules (not sure if this is a recommended program or not). Testing it out, the cell will be flagged with a warning if data validation rules are applied after entry.
I have been testing out LibreOffice to see if it will flag already entered values if validation is added later, but I am not currently having success there. This could be good information to mention while showing learners how to validate their data after its been entered.
from spreadsheets-socialsci.
One of the challenges with this lesson in particular is that (a) the different spreadsheet apps have slightly different functionality and (b) they continue to evolve. We aren't necessarily consistent in directing folks to particular apps, but I'd like to get there. Thanks for the info @angela-li and @jacquelyneneal!
from spreadsheets-socialsci.
Also, the same section states that "Instead, if a particular cell would fail the validation check a triangle is placed in the top left corner of the cell as a warning." which is incorrect.
from spreadsheets-socialsci.
Related Issues (20)
- re-style episode titles
- suggestion for changing episode #2 description
- Explicitly introduce tidy data principles
- Lesson Contribution - Naming Consistency
- Dates as Data Lesson: Dates stored as integers section 404 link HOT 1
- Lesson Contribution - SAFI subset
- Lesson Contribution - Dates as Data & Exporting Data Episodes HOT 1
- 02-common-mistakes link to "Nine simple ways to make it easier to (re)use your data" broken HOT 1
- Add speaker note to Instructor Notes
- Need jump lists (anchors) for headings HOT 1
- Accessibility: replace screenshot of table with HTML table HOT 1
- Lesson Contribution - Formatting Cells/Data
- MONTH and DAY formulas function differently than lesson shows
- Transition To Workbench in May HOT 6
- Headings in episode 2 show anchors
- Table in episode 2 is rendered incorrectly HOT 1
- Broken link to lesson discussion HOT 2
- Links need to be fixed in CONTRIBUTING.md HOT 1
- Outdated reference material for Excel
- Typos and wording HOT 2
Recommend Projects
-
React
A declarative, efficient, and flexible JavaScript library for building user interfaces.
-
Vue.js
🖖 Vue.js is a progressive, incrementally-adoptable JavaScript framework for building UI on the web.
-
Typescript
TypeScript is a superset of JavaScript that compiles to clean JavaScript output.
-
TensorFlow
An Open Source Machine Learning Framework for Everyone
-
Django
The Web framework for perfectionists with deadlines.
-
Laravel
A PHP framework for web artisans
-
D3
Bring data to life with SVG, Canvas and HTML. 📊📈🎉
-
Recommend Topics
-
javascript
JavaScript (JS) is a lightweight interpreted programming language with first-class functions.
-
web
Some thing interesting about web. New door for the world.
-
server
A server is a program made to process requests and deliver data to clients.
-
Machine learning
Machine learning is a way of modeling and interpreting data that allows a piece of software to respond intelligently.
-
Visualization
Some thing interesting about visualization, use data art
-
Game
Some thing interesting about game, make everyone happy.
Recommend Org
-
Facebook
We are working to build community through open source technology. NB: members must have two-factor auth.
-
Microsoft
Open source projects and samples from Microsoft.
-
Google
Google ❤️ Open Source for everyone.
-
Alibaba
Alibaba Open Source for everyone
-
D3
Data-Driven Documents codes.
-
Tencent
China tencent open source team.
from spreadsheets-socialsci.