Hi Heiko and team, *Additional question recommendation*: Q: In what capacity do you use Calc? (Check all that apply) 1. Education/school 2. Professional 3. Personal (e.g. home office, accounting) Wording here is VERY rough, but I thought use cases could be valuable. (e.g. 82% of Calc users use it in a professional capacity).
Q: I do not know how to word/format this question, but I think it would be valuable to know why people don't use Calc more often. Example answers could be: workplace uses MS Office platform, lacks collaboration features, lacks a critical feature I need, etc... It is a bit of a free response question so I struggle with how it should be formatted and presented. A list of options with an 'other' free response at the end may be best. *Corrections*: Q9 - "Liner(sp) and non-linear" -> Linear and non-linear *Other comments/recommendations*: - *Scale*: I believe most professional surveyors recommend the Likert scale (1-5) instead of a 1-7 scale as there is more variance in larger scales. In my experience (limited as it is not being a professional surveyor) I find that if people have a given mental energy they dedicate to a survey, larger scales use more of that energy and therefore reduce the value of later answers (they get survey exhaustion and choose whatever) or they give up and do not complete the survey. As an example, what does it mean if someone chooses a 5 versus a 6 versus a 7 for Spell Check. If they pick a 6 does that mean they find 2/3 the value in spell check as compared to someone who chooses a 7? If someone chooses a 5, does that mean they don't care that much if we took spell check away? In a 5 point scale I would assume a 4 means it is a feature they sometimes use and 5 is a feature they use all the time which gives better clarity on the value of a feature. - *Number of items in 9*: Again on the point of survey exhaustion, I would recommend the list of items in 9 be reduced to the most valuable questions. Not to pick on Spell Check, but what value is that question to us? Would the team really spend more time on Spell Check versus other Calc features? I don't believe 7's on spell check translates to an actionable item of interest to users. It just indicates that users use spell check... To that end my recommended list of items to cut from 9 would be: -* Spell Check* - *Formulas and Calculations* - Lacks clarity on what feature enhancements would be desired, and as a core feature I can't imagine we would get valuable feedback - *Rows and columns manipulation?* - Undecided on this. What actions would be taken if people say they use this feature? I suppose new features could be added to support this functionality but I don't think the survey will tell us whether this is truly desired (just that people manipulate rows and columns which most users likely do). - *Number, percent, and Currency formatting *- similar logic to formulas and calculations above. With custom formatting power users can do whatever they want so actionable items here seem limited - I would *combine text and cell formatting *(I think together they address the functionality of interest) - *Cutting 'very' from question 13*: Some of the questions in 13 include 'very'. I think the nuance of 4 and 5 on a 5 point scale is the difference between no 'very' and a 'very' (aka 4 = hard to use, 5 = *very* hard to use). I would recommend cutting all the 'very's. *In response to others comments:* I support Q7 and would be very interested in the results although I think 'light' users of calc may be confused at first (the example is hard to find at the bottom). I wonder if it is more valuable to ask what the size is for users' largest data sets. I have huge data sets (100,000's of cells) but my average (mean, not median) would be small because I have tons of data sets with like <20 cells in them. I am ambivalent on Q3 clarifications; I think people will self-identify with the correct category for the most part. As for the 'select 6' question in Q9, I thought it was in there on purpose and I think we should keep that. It could say "Select 6 if you are not a robot" That would let us know if any surveys were filled out by bots. Just my opinion for what it is worth. Nice survey and hope it provides valuable information! Cheers, Jaron On Wed, Jun 30, 2021 at 12:36 PM Heiko Tietze < [email protected]> wrote: > First reply from Stuart (per direct mail): > > > "Two confusing entries on page 5 of the draft survey: > > Select 6 as your answer choice Select "No Answer" as your answer choice > > I think they need to go to have valid results (and force respondents to > > answer each question)." > > Yes, the 'Select "No Answer" as your answer' choice slipped accidentally > in. > Also the item 'Select 6 as your answer choice'. > > Second from Kompilainnen (on Telegram): > > > * Q1: Drop question about gender (answer has no value for the results) > > * Q3: Add description like 'Basic - typing data, simple functions like > SUM only', > > 'Intermediate - Basic + use Conditional formatting, Charts, more > functions, > > like VLOOKUP, AVERAGE, SUMPRODUCT, etc', and 'Advanced - Intermediate + > use > > many different functions, Pivot Table, write some macro, create work > > templates, etc' > > * Q4: same here, 'Never - 1 time per month - 1 time per week > > - 1 time per day - It's my main work tool' > > * Q7: doubt this result in data > > that can be evaluated; would rather ask both number of cells and size in > two > > questions > > * Q8: could benefit from a link to > > > https://wiki.documentfoundation.org/Documentation/Calc_Functions/List_of_Functions/en > > I agree with removing Q1, don't see why a gender should have an impact on > Calc > usage. But would keep the question a bit vague on Q3 and 4. Also looking > rather > forward to analyze Q7, the results from the Draw survey on "what size does > your > document have in average" [1,2] shows the different view on this topic. > Surely, > it's still open to challenge. > > [1] > > https://design.blog.documentfoundation.org/2016/04/01/the-many-faced-god-part-1-how-libreoffice-draw-is-being-utilized/ > [2] > > https://design.blog.documentfoundation.org/2016/04/01/the-many-faced-god-part-2-how-libreoffice-draw-is-expected-to-evolve/ > > > -- > To unsubscribe e-mail to: [email protected] > Problems? > https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ > Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette > List archive: https://listarchives.libreoffice.org/global/design/ > Privacy Policy: https://www.documentfoundation.org/privacy > -- To unsubscribe e-mail to: [email protected] Problems? https://www.libreoffice.org/get-help/mailing-lists/how-to-unsubscribe/ Posting guidelines + more: https://wiki.documentfoundation.org/Netiquette List archive: https://listarchives.libreoffice.org/global/design/ Privacy Policy: https://www.documentfoundation.org/privacy
