• Data table for figure 3

    Post-use survey responses to 'Which of the following best describes your sentiment about Copilot after having used it?', by APS classification.

    SentimentVery pessimisticSlightly pessimisticNeutralSlightly optimisticVery optimistic
    APS 3-6 (n=305)1%6%20%42%31%
    EL1 (n=268)1%9%10%44%35%
    EL2 (n=155)*1%6%14%45%35%
    SES (n=43)*2%2%2%58%35%

    *Margin of error at a 95% confidence level > 0.05. Totals may amount to less or more than 100% due to rounding.

    Off
  • Data table for figure 4

    Post-use survey responses to 'Which of the following best describes your sentiment about Copilot after having used it?', by APS classification.

    SentimentStrongly disagreeDisagreeNeutralAgreeStrongly agree
    APS 3-6 (n=305)1%4%11%38%46%
    EL1 (n=268)0%3%9%40%48%
    EL2 (n=155)*1%3%12%39%46%
    SES (n=43)*5%0%2%40%53%

    *Margin of error at a 95% confidence level > 0.05. Totals may amount to less or more than 100% due to rounding.

    Off
  • SES survey respondents in the post-use survey mainly referenced productivity benefits, both for themselves and their team. SES noted that Copilot appeared to be driving a reduction in time staff spent in creating briefing materials and lifted the general professionalism of written documents. On an individual level, it was seen as a tool for saving time through summarising meetings, email conversations and documents. SES survey respondents also viewed the trial as a positive step for the APS in embracing new technology. 

    Of the job families, trial participants in the Corporate grouping were particularly positive about Copilot with 86% of post-use survey respondents indicating they would like to continue to use Copilot after the trial as indicated in Figure 6.

    Figure 5. The data contained within this graph is available in the 'Data table for figure 5' below.
    Figure 5 | Post-use survey responses to 'Which of the following best describes your sentiment about Copilot after having used it?', by APS job family
  • Data table for figure 5

    Post-use survey responses to 'Which of the following best describes your sentiment about Copilot after having used it?', by APS job family.

    SentimentVery pessimisticSlightly pessimisticNeutralSlightly optimisticVery optimistic
    Technical (n=164)0%11%10%43%*36%*
    Policy and program management (n=215)1%9%17%40%*32%*
    ICT and digital solutions (n=185)2%6%16%45%*31%*
    Corporate (n=233)2%5%12%45%36%

    *Margin of error at a 95% confidence level > 0.05 for combined ‘slightly’ and ‘very optimistic’. Totals may amount to less or more than 100% due to rounding.

    Off
  • Figure 6. The data in this graph can be viewed in 'Data table for figure 6'.
    Figure 6 | Post-use survey responses to 'What extent do you agree with the following statement: I want to continue to use Copilot after the trial', by APS job family
  • Data table for figure 6

    Post-use survey responses to 'What extent do you agree with the following statement: I want to continue to use Copilot after the trial', by APS job family.

    SentimentStrongly disagreeDisagreeNeutralAgreeStrongly agree
    Technical (n=164)0%4%12%33%52%
    Policy and program management (n=215)1%5%10%34%50%
    ICT and digital solutions (n=185)1%3%9%48%40%
    Corporate (n=233)2%3%8%43%44%

    Totals may amount to less or more than 100% due to rounding.

    Off
  • Data table for figure 7

    Pulse survey responses to 'How little or how much do you agree with the following statement: Copilot has met my expectations', by Microsoft product (n=1,141).

    SentimentDisagreeSomewhat disagreeNeutralSomewhat agreeAgree
    Teams2%5%21%38%34%
    Word4%7%19%42%28%
    Outlook9%8%39%31%13%
    Powerpoint6%11%48%24%11%
    Excel14%14%55%11%5%

    Totals may amount to less or more than 100% due to rounding.

    Off
  • Many focus group participants and post-use survey respondents found it difficult to prepare data in Excel for effective prompting, in particular the need for data to be structured in tables. In addition, focus group participants noted that Copilot often either could not complete the requested action or would not fully perform the function it was asked (for example only returning the suggested formula for users to enter rather than automatically performing the analysis).

    There were also issues with accessing Copilot functionality in MS Outlook. Copilot features in Outlook were only available through either the newest Outlook desktop application or the web version of Copilot. Focus group participants noted that it was unlikely that trial participants had the newest versions of Outlook and were therefore unable to access Copilot features in Outlook. To work around this accessibility barrier, several post-use survey respondents and focus group participants noted they copied content from Outlook into Word or Teams to then prompt Copilot for assistance. The inability to access Copilot in Outlook likely weighed down participant sentiment for this product.

    There has been a reduction in positive sentiment across all activities that trial participants had expected Copilot to assist with. 

    Trial participants who completed both the pre-use and post-use survey recorded a reduction in positive sentiment across most activities Copilot was expected to support. As shown in Figure 8, although the sentiment remains positive for most of these categories, their initial expectations of Copilot were unmet. 

    The first of 2 graphs comparing participants’ expectations and post-trial experience of Copilot, by different work activities. Each activity experienced a slight overall decline from pre-trial expectation.
    The second of 2 graphs comparing participants’ expectations and post-trial experience of Copilot, by different work activities. Only one activity, ‘improved the quality of my work’, experienced a small increase upon expectation.

    Figure 8 | Comparison of combined 'somewhat agree', 'agree' and 'strongly agree' responses to pre-use survey statement 'I believe Copilot will…' and post-use survey statement 'Using Copilot has…', by type of observation (n=330)

  • Data table for figure 8

    Comparison of combined 'somewhat agree', 'agree' and 'strongly agree' responses to pre-use survey statement 'I believe Copilot will…' and post-use survey statement 'Using Copilot has…', by type of observation (n=330).

    SentimentPre-trial expectation, agreedPost-trial experience, agreed
    Help me spend less mental effort on tedious or mundane tasks*84%73%
    Be a net positive on my work78%76%
    Improve the speed at which I complete tasks75%74%
    Make valuable suggestion to enhance my work*75%71%
    Allow me to quickly find the information I am looking for*72%64%
    Free up more focus time for important work*61%55%
    Improve the quality of my work62%63%
    Allow me to spend less time in emails*43%30%
    Allow me to reduce task switching29%28%
    Allow me to attend fewer meetings*25%12%

    *Statistically significant change (p-value < 0.05)

    Off
  • It is likely that trial participants expectations were heightened prior to the commencement of the trial. During consultations, it was noted that the features of Copilot (and generative AI more broadly) were marketed as being able to significantly save participants’ time, thereby heightening participants expectations. These expectations appear to have been tempered following Copilot’s use.

    Of note, the most significant reductions in positive sentiment were observed in activities where survey respondents had the lowest expectations. There was a 32% decrease in the positive belief that Copilot allowed participants to ‘spend less time in emails’ and a 54% reduction in the belief that it would allow them to ‘attend fewer meetings.’ Even with low expectations, survey respondents did not perceive Copilot was able to assist in these activities. 

    Other generative AI tools may be more effective at meeting bespoke users’ needs than Copilot 

    The small proportion of trial participants who use other generative AI products in a work capacity found those tools met their needs slightly better than Copilot.

    Of the post-use survey respondents, 16% reported that they use other generative AI products to support their role. Post-use survey respondents reported using the following tools: 

    • Versatile LLMs – ChatGPT, Gemini, Claude, Amazon Q, Meta AI
    • Development tools – Github Copilot, Azure 
    • Image generators/editors – Midjourney, Dall-E 2, Adobe, Canva

    As shown in Table 2, 44% of post-use respondents who used other generative AI tools viewed that other tools met their needs more than Copilot.

    Table 2. Post-use survey responses to 'How does Microsoft 365 Copilot compare to other generative AI products you have used?'
    SentimentResponse (%)
    Other generative AI products meet my needs significantly more than Copilot13%
    Other generative AI products meet my needs slightly more than Copilot31%
    Copilot and other generative AI products meet my needs to the same extent32%
    Copilot meets my needs slightly more than other generative AI products13%
    Copilot meets my needs significantly more than other generative AI products11%

    Copilot offers general functionality, matching most features of other publicly available generative AI products, but it may not offer an equivalent level of sophistication or depth across all these features. Post-use survey respondents noted that generative AI products were used for discrete use cases where Copilot was considered less advanced such as: writing and reviewing code, producing more complex written documents, generating images for internal presentations and searching research databases. 

    Despite the positive sentiment, the actual use of Copilot is moderate

    A third of post-use survey respondents used Copilot daily.

    While survey respondents were generally positive towards Copilot, the majority of survey respondents did not frequently use Copilot. As shown in Table 3, only a third of post-use survey respondents used Copilot on a daily basis. 

    Table 3. Post-use survey responses to 'How frequently did you use Copilot for Microsoft 365 during the trial?' (n=811)
    How frequently did you use Copilot for Microsoft 365 during the trial?Responses (%)
    Not at all1%
    A few times a month21%
    A few times a week46%
    A few times a day26%
    Most of the day6%

    The moderate frequency of usage was broadly consistent across APS classifications and job families. There was variance, however, across cohorts relating to the features used. For example, a higher proportion of SES and EL2s used the Teams meeting summarisation compared to other APS classifications. This could reflect the higher number of meetings these cohorts needed to attend, and therefore the higher usage and potential benefits in meeting summaries for the SES and EL2 classifications.

    Post-use survey respondents who only used Copilot a few times a month highlighted that they stopped using Copilot because they had a poor first experience with the tool or that it took more time to verify and edit outputs than it would take to create them otherwise. Similarly, other post-use survey respondents remarked they did not feel confident using the tool and couldn’t find time for training among other work commitments and time pressures. 

    Focus groups with trial participants also remarked that they often forgot Copilot was embedded into Microsoft 365 applications as it was not obviously apparent in the user interface. Consequently they neglected to use features, including forgetting to record meetings for transcription and summarisation. Commonwealth Scientific and Industrial Research Organisation (CSIRO) identified through internal research with CSIRO trial participants that the user interface at times made it difficult to find features (CSIRO 2024:28). Given one of the arguable advantages of Copilot is its current integration with existing MS workflows, its reported lack of visibility amongst users largely diminishes its greatest value-add.

    Overall, the usage of Copilot is in its infancy within the APS. Due to a combination of user capability, user interface, perceived benefit of the tool and convenience, Copilot is yet to be ingrained in the daily habits of APS staff. 

    Copilot was predominantly used to summarise and re-write content

    Copilot use is concentrated in MS Teams and Word.

    While Copilot provides support in a range of activities, the use of Copilot amongst trial participants was concentrated in a few activities. As shown in Figure 9, over 70% of post-use survey respondents used Copilot in Teams to summarise meetings, and in Word to summarise documents or to re-write content.

    A graph showing how many participants used Copilot chat features, the most used being ‘general enquiries’ by 58% of respondents.
    A graph showing how many participants used Copilot features in Excel, the most used being ‘data analysis’ by 20% of respondents.
    A graph showing how many participants used Copilot features in Loop, the most used being ‘summarisation’ by 3% of respondents.
    A graph showing how many participants used Copilot features in OneNote, the most used being ‘summarisation’ by 6% of respondents.
    A graph showing how many participants used Copilot features in Outlook, the most used being ‘drafting assistance’ by 43% of respondents.
    A graph showing how many participants used Copilot features in PowerPoint, the most used being ‘content creation’ by 33% of respondents.
    A graph showing how many participants used Copilot features in Teams, the most used being ‘meeting summaries’ by 72% of respondents.
    A graph showing how many participants used Copilot features in Whiteboard, the most used being ‘content summarisation’ by 3% of respondents.
    A graph showing how many participants used Copilot features in Word, the most used being ‘summarisation’ and ‘rewrite suggestions’, each used by 71% of respondents.

    Figure 9 | Post-use survey responses, grouped by Microsoft application, to 'How frequently did you use the following features?' of ‘a few times a month’ or more frequent

  • Data table for figure 9

    Post-use survey responses, grouped by Microsoft application, to 'How frequently did you use the following features?' of ‘a few times a month’ or more frequent.

    FeatureUsed at least onceMicrosoft application
    General queries58%Copilot chat
    Interface with other Microsoft products49%Copilot chat
    Document search/retrieval46%Copilot chat
    Data analysis20%Excel
    Formula assistance19%Excel
    Insight generation16%Excel
    Summarisation3%Loop
    Draft page content3%Loop
    Content editing2%Loop
    Idea generation2%Loop
    Summarisation9%OneNote
    Content generation6%OneNote
    Task management6%OneNote
    Collaboration enhancement3%OneNote
    Drafting assistance43%Outlook
    Email summarisation41%Outlook
    Meeting follow-up23%Outlook
    Content creation33%PowerPoint
    Design suggestions29%PowerPoint
    Summarisation26%PowerPoint
    Meeting summaries72%Teams
    Real-time answers54%Teams
    Task management39%Teams
    Content summarisation3%Whiteboard
    Content organisation2%Whiteboard
    Idea generation2%Whiteboard
    Interactive collaboration2%Whiteboard
    Summarisation71%Word
    Rewrite suggestions71%Word
    Tone adjustments52%Word
    Formatting assistance47%Word
    Off
  • Data table for figure 10

    Post-use survey responses to 'Do you agree with the following statement: I feel confident in my skills and abilities to use Copilot', by amount of training received (n=810).

    SentimentNot at all confidentNot very confidentModerately confidentFairly confidentVery confident
    Overall (n=810)2%13%35%35%14%
    One form of training (n=276)4%23%35%28%10%
    Two forms of training (n=282)1%13%40%34%12%
    Three or more forms of training (n=252)0%4%31%44%21%
    Off
  • The general sentiment among focus group participants who were involved in their agency’s implementation (namely chief technology officers (CTOs)/chief information officers (CIOs) and Copilot Champions) was that training requirements were greater than anticipated. 

    Complicating this is the diverse digital literacy and maturity of staff. Some agencies were better positioned to manage this than others but the positive relationship between perceived capability and amount of training suggests that a concerted, material and ongoing effort is needed to build confidence. A one-off session is unlikely to have a lasting impact on a user’s skills and abilities.

    Trial participants broadly found Copilot training useful but noted areas for improvement.

    The majority of post-use survey respondents (76%) who attended either agency or Microsoft-led training found the sessions useful. Anecdotal evidence from focus groups, however, suggested that more could be done to personalise training, particularly the training delivered by Microsoft.

    Focus group participants believed that Microsoft training was too focused on the features of Copilot, rather than its applications and use cases. Participants also noted that some Microsoft trainers did not understand the APS context and could not answer targeted questions. 

    To supplement Microsoft-led sessions, almost all agencies that participated in the evaluation offered some form of training. The quality and exhaustiveness of this training, however, varied according to the time and resource constraints of agencies. Some focus group participants had dedicated resources to lead the training effort, while others were encouraged to learn Copilot through hands-on use.

    Training was most effective when tailored to APS and agency context.

    One focus group participant found Microsoft’s industry specific advice and prompt library a useful aid to upskilling, others expressed a similar desire for cheat sheets with tailored prompts aligned to their roles. Several focus group participants remarked that they gained the most knowledge on impactful use cases through forums their agency created, such as ‘lunch and learns’, webinars, ‘promptathons’ or similar.

    A more flexible, community of practice approach was also seen as an effective training method as it provided a means to identify and propagate highly relevant use cases for Copilot. In general, there appears to be a strong demand for training even amongst trial participants who had a high proportion of individuals who were already experienced in generative AI. This included a desire for a wide range of training and information sources supplemented by opportunities to share use cases and broad skills in generative AI.

    There are opportunities to further explore use cases in the APS

    There were a few novel use cases for Copilot in the APS.

    Some trial participants identified a few novel use cases which were highly specific to the roles of participants but highlight the potential of Copilot to support higher order and more bespoke activities. These included:

    • Writing and reviewing PowerShell script (for task automation)
    • Assessing documents against a rubric or criteria
    • Converting technical documentation into plain language (to distribute to a broader audience)
    • Drafting content for internal exercises e.g. phishing simulations
    • Drafting content for business cases and Cabinet Submissions
    • Converting information into standard forms and templates (for processing and assessment).

    The presence of novel use cases highlights that there are opportunities to innovatively use Copilot beyond its summarisation, information search and content drafting features.

    References

    1. Commonwealth Scientific and Industrial Research Organisation (2024)Copilot for Microsoft 365; Data and Insights’, Commonwealth Scientific and Industrial Research Organisation, Canberra, ACT, 28.
    2. Department of Industry, Science and Resources (2024) ‘DISR Internal Mid-Trial Survey Insights’, Department of Industry, Science and Resources, Canberra, ACT, 2.
  • The main use cases are an illustration of the current perceived strengths of Copilot’s predictive engine - it is adept at natural language processing and synthesis, where it can output human-like text in response to provided information and prompts. 

    Of note, the use of Copilot within Whiteboard and Loop were particularly low. This is not unsurprising when compared with the usage trends before the trial. It is also interesting to note the relatively lower use of Copilot to create content and ideas relative to summarisation of information. 

    There was a positive relationship between the provision of training and capability to use Copilot.

    There was no standard approach undertaken to train trial participants on how to use Copilot. Participants adopted a combination of methods based on their perceived capability and resources provided to them. The 4 main training options available to trial participants were:

    • accessing Copilot resources on the Internet
    • hands-on experimentation with Copilot
    • attending agency-facilitated Copilot training
    • attending Microsoft-led Copilot training.

    Almost half of all post-use survey respondents felt fairly or very confident in their skills and abilities to use Copilot. As depicted in Figure 10, the proportion of ‘fairly’ and ‘very confident’ responses combined is 16 percentage points higher when post-use survey respondents accessed 3 or more forms of training compared to overall. This indicates a positive correlation between the amount of training participants received and their ability to use Copilot. The importance of training was also highlighted in the CSIRO’s evaluation which reported that trial participants needed additional training and/or resources that would support advanced features and usage (CSIRO 2024:11).

    A graph demonstrating that participants’ confidence using Copilot increased significantly if they received a higher amount of training.
    Figure 10 | Post-use survey responses to 'Do you agree with the following statement: I feel confident in my skills and abilities to use Copilot', by amount of training received (n=810)
  • This section outlines the impact of Microsoft 365 Copilot on trial participants’ perceived productivity in terms of both efficiency and quality.

  • Key insights

    The majority of survey respondents (69% of post-use survey respondents) agreed that Copilot improved the speed at which they could complete tasks and uplifted the quality of their work (61% of post-use survey respondents).

    Approximately 65% of the managers in the post-use survey found that Copilot had a positive impact on the quality and efficiency of their team members in particular in assisting team members to quickly produce briefing materials and uplifting the quality of written outputs.

    Copilot contributed the most perceived time savings in tasks related to summarisation, information searches and preparing first drafts with an estimated time savings of around an hour a day for those tasks.

    The ICT and Digital Solution job family perceived the most efficiency gains of around one hour a day across summarisation activities and preparing first drafts of documents. Across APS classifications, APS3-6 and EL1s perceived the similar time savings of an hour a day in summarisation tasks and creating first drafts.

    40% of trial participants reported being able to reallocate their time to higher value activities. Trial participants also remarked on the ability to spend more time on face-to-face activities such as staff engagement, culture building and mentoring, and taking more time to build relationships with end users and stakeholders.

    The quality of Copilot’s output limited the scale of productivity benefits. Overall, Copilot’s improvements to work quality were more subdued than improvements to work efficiency. While the majority of trial participants viewed that Copilot was effective at developing first drafts of documents and lifting overall quality, editing was almost always needed to tailor content for the audience or context thereby reducing total efficiency gains. Copilot is perceived to improve the efficiency and quality of outputs.

    Copilot is perceived to improve the efficiency and quality of outputs

    The majority of post-use survey respondents perceived that Copilot positively affected their productivity.

    Trial participants generally perceived that Copilot had a positive impact on 2 key measures of productivity – efficiency and quality. As shown in Figure 11, the majority of post-use survey respondents agreed that Copilot improved the speed at which they could complete tasks (69%) and uplifted the quality of their work (61%).

    A graph showing that participants were slightly more likely to report Copilot improved the speed at which they complete tasks than it improved the quality of their work.
    Figure 11 | Post-use responses to 'What extent do you agree with the following statements: using Copilot has improved the…', from respondents who completed both pre- and post-use surveys (n=330)
  • Data table for figure 11

    Post-use responses to 'What extent do you agree with the following statements: using Copilot has improved the…', from respondents who completed both pre- and post-use surveys (n=330).

    SentimentStrongly disagreeDisagreeSomewhat disagreeNeutralSomewhat agreeAgreeStrongly agree
    speed at which I complete tasks4%5%7%16%26%26%17%
    quality of my work4%6%7%22%26%24%11%

    Totals may amount to less or more than 100% due to rounding.

    Off

Connect with the digital community

Share, build or learn digital experience and skills with training and events, and collaborate with peers across government.