Re: [libreoffice-design] Re: Calc Survey

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 <
heiko.tietze@documentfoundation.org> 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: design+unsubscribe@global.libreoffice.org
> 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: design+unsubscribe@global.libreoffice.org
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