Embedded Files
On this page, you will find resources and lecture captures (where applicable) from each session at the Google in Practice event on 10th December 2019.
On this page, you will find resources and lecture captures (where applicable) from each session at the Google in Practice event on 10th December 2019.
Accessibility
Accessibility
Hanging out with Google Meet
Hanging out with Google Meet
Automate with Google
Automate with Google
'Introduction to coding' Digital Wednesday: - This introductory session is for anyone who is new to writing computer programs or learning coding languages. We will cover: How computers work and how this applies to programming What are programming languages? Key concepts in programming, such as variables, loops, and data types How to get started with learning programming.
'Essential Apps Script' Training course: With Google Apps Script you can extend the features of Google Sheets, Forms, and Documents. This course is a series of five workshop sessions with a combination of instruction, live coding, and project work. There is an expectation that you will need at least an hour outside of the workshop to consolidate learning and ensure you finish the week’s project. What can you do with Apps Script? Bulk create folders in Drive (including adding permissions and other files/folders as required) Have Google Forms send emails upon submission; Create Documents, Sheets, and/or Calendar events from Form or Spreadsheet data Manipulate spreadsheet data (including archiving, monitoring for changes)
Let's make a spreadsheet Advent calendar!
Let's make a spreadsheet Advent calendar!
'Let's make a spreadsheet Advent calendar!' resources
'Let's make a spreadsheet Advent calendar!' lecture capture
'Essential Spreadsheets' training course (currently full, but please do add your name to the waitlist (s) and we will do our best to provide additional training if required.)
Originally developed to manipulate numerical data, spreadsheets are now used to manipulate and interact with all kinds of data using a wide range of functions and features. In these sessions, held over 5 weeks, you will learn how to exploit the capabilities of both Excel and Google Sheets, including features that are particularly helpful when working collaboratively. The course takes place over four weeks with an optional question-and-answer / knowledge-sharing session on the fifth week. Prerequisites: IT Services username and password. We also ask that you have a go at the pre-session tutorial at https://sites.google.com/a/york.ac.uk/workingwithdata/spreadsheets/introducingspreadsheets before the first session.
Data visualisation
Data visualisation
'Data visualisation' lecture capture
'Data visualisaiton' online resource
'Data visualisation and infographics' Digital Wednesdays: How you present your data has a massive impact on audience understanding and engagement. Using different data visualisations can also provide you with new insights into your data findings. In this workshop we will cover the principles for working with data, from data cleaning to visualisation.
Making effective presentations
Making effective presentations
'Making effective presentations' slides
'Making effective presentations' lecture capture
'It's all in the presentation: creating and presenting your slides' workshop:
PowerPoint and Google Slides include many under-exploited features that can help you create more effective presentations and other resources. This session explores the principles of designing presentations, including templates, animation and working with media. We'll also look at how to source and evidence the information you include and how to convey your material to an audience.
Design a Wiki intranet
Design a Wiki intranet
'Design a Wiki intranet' resources
'Design a Wiki intranet' Bitesized session: Investigate the fundamentals of wiki building, while considering its benefits and challenges. This session is an opportunity to ensure you get the most out of a wiki intranet, which can really transform your department for the better. Feel free to bring your lunch along!
Organise yourself: Useful apps to help you keep on track
Organise yourself: Useful apps to help you keep on track
Digital department
Digital department
Permissions and sharing in Google Drive
Permissions and sharing in Google Drive
'Permissions and sharing' slides
'Permissions and sharing' lecture capture
'Permissions and sharing in Google Drive' bitesized session: Explore who can see a document, how to share files and folders with people in and outside of the University and lots more. This session will look at sharing permissions on Drive and Shared drive and answer questions about how to make sure the right people can see your document. Feel free to bring your lunch along!
Email: a double-edged sword
Email: a double-edged sword
Slack in a Nutshell
Slack in a Nutshell
Survey Tools
Survey Tools
'Google Forms' training course: In this session, we will look at using Google Forms and Sheet to collect and query data. We will look at the features available in Google Form to set up surveys to collect the right data. We will then explore the collaborative options for analysing this data available in Google Sheets, looking at filter views and query functions.
'Qualtrics' training course: In this session, we will look at using Qualtrics to collect and query data. We will look at the features available in Qualtrics to set up surveys to collect the right data, mechanisms for distributing surveys, and how to create reports from the responses we get. In the session we will consider the respective pros and cons of Google Forms and Qualtics from survey design through to analysis.
Gmail Tips
Gmail Tips
'Gmail Tips' bitesized training course: Uncover tips and tricks to get the most out of Gmail. Whether you’ve been using Gmail for a while, or it’s all new to you, this session will show you something you didn’t know or have long since forgotten. Feel free to bring your lunch along!
Using interactive tools in your presentations
Using interactive tools in your presentations
Google sites: communicating your project
Google sites: communicating your project
'Websites without coding' Digital Wednesdays: The opening to a three part series on web development. Want to create a website without HTML? In this session we'll cover how to design and create web pages using tools such as Google Sites, Blogger, and more, without needing to know any coding.
Using Google Apps for portfolios and student group work
Using Google Apps for portfolios and student group work
Google Calendar
Google Calendar
'Google Calendar' lecture capture
'Google Calendar' bitesized session: Explore how to get the most out of Google Calendar and discover lots of little features hiding inside which will help you get organised and see that it is more than a diary. Feel free to bring your lunch along!
Welcome Address
Welcome Address
Page updated
Report abuse