Tutor summary, 2 September 2016

What you did or learnt, session 8 (Apps!)

Google sheets exercise 3

  1. Saved a CSV format data file (Corporate volunteers by month) from your email to the ‘data’ Drive folder.
  2. Opened the data file in Google Sheets.
  3. Changed the display format of the ‘Month’ column.
  4. Edited the appearance of the colum headings.
  5. Used a function to sum the total number of volunteers since April 2014.
  6. Created a bar chart of volunteer count against month.
  7. Edited the chart to optimise online display.
  8. Shared the chart with everyone in the Bold social enterprise (view option only).
  9. Created a snapshot image of the chart.
  10. Saved the image to the ‘images’ Drive folder, and to your course flash drive.

Blog exercise A

  1. Made a blog post about what you just did.
  2. Inserted the snapshot image below the blog text
  3. Added an image caption, ‘alt text’ and ‘screen reader description’.

Google forms

  • Completed your course evaluation in an online form (responses saved automatically in a spreadsheet).

Blog exercise B

  • Made a final blog post about the course as a whole.

Output

Resources used

  • Course flash drives.
  • Google Apps for Work Drive, Email, Docs, Forms and Sheets (bold.org.uk custom version).
  • WordPress blog (this one).

Tutor summary, 26 August 2016

What you did or learnt, session 7 (Apps!)

Google sheets exercise 1

You edited a spreadsheet (in Google Sheets) to simulate making a simplified business decision.

Your mission was

You have been given responsibility for organising a computer course for clients who can afford to pay for it. Given real data about training room hire and other costs – how much would you charge individual clients

  • To break even?
  • To make a profit of £1000?
  • To ensure that clients would not have to pay more than £150 for the course?

The mission was successful.

Google sheets exercise 2

  • Used a shared Google Sheet to record your attendance at these classes.

Blog exercise

  • Made a blog post about what you did or learnt during the session.

Resources used

  • Course flash drives.
  • Google Apps for Work Drive, Email and Sheets (bold.org.uk custom version).
  • WordPress blog (this one).

Tutor summary, 05 August 2016

What you did or learnt, session 6 (Apps!)

Blog exercise A

  1. Saved a photo (the parrot) from your email to your course flash drive and your Google Drive.
  2. Moved the photo to the ‘images’ Drive folder.
  3. Posted the photo on this course blog.

Google sheets exercise

  1. Dragged a csv format data file (London JSA claimants 2014) to the ‘data’ Drive folder.
  2. Opened the data file in Google Sheets, and continued the exercise as a spreadsheet taster
  3. Added column headings and new columns to the spreadsheet.
  4. Created formulae for total number and percentage of JSA claimants in each London borough.
  5. Sorted the spreadsheet on population % (lowest to highest).
  6. Created a column chart to help visualise the data.
  7. Edited the chart to improve presentation.
  8. Downloaded the spreadsheet to your course flash drive in MS Excel format.
  9. Shared the spreadsheet with everyone else with a bold.org.uk account.
  10. Used Google Docs to embed the chart in a document (this is where we discovered one of the limitations of the Google Apps).

Blog exercise B

  • Made a blog post about what you did or learnt during the session.

Output

Resources used

  • Course flash drives.
  • Google Apps for Work Drive, Email, Docs and Sheets (bold.org.uk custom version).
  • WordPress blog (this one).

Tutor summary, 29 July 2016

What you did or learnt, session 5 (Apps!)

Blog exercise A

  1. Decided whether to make your video posts (from the previous week) public or private.
  2. Made a blog post about your hopes and expectations for the employability project.

Google Docs exercise

  1. Used Google Docs to make an A5 flyer for the employability project – illustrated with the stock portrait photo that you had saved to Google Drive the previous week.
  2. Downloaded the flyer to your course flash drive in MS Word and PDF formats.

Blog exercise B

  • Made a blog post about what you did or learnt during the session.

Output

Resources used

  • Course flash drives.
  • Google Apps for Work Docs and Email (bold.org.uk custom version).
  • Commercial stock photos.
  • WordPress blog (this one).

Tutor summary, 22 July 2016

What you did or learnt, session 4 (Apps!)

Photo exercise

  1. Downloaded a photo attachment from your email to your course flash drive.
  2. Saved the photo on your Apps for Work cloud drive.
  3. Posted the photo on the course blog.
  4. Downloaded your own ‘peppers’ still-life photo from the cloud drive to your course flash drive.
  5. Posted it on the course blog.

Video exercise

  1. Made a short video on a tablet.
  2. Uploaded the video to your course Vimeo account.

Resources used

  • HUDL 2 Android tablets.
  • Course flash drives.
  • Google Apps for Work Drive and Email (bold.org.uk custom version).
  • Commercial stock photos.
  • Android camera and gallery apps.
  • Vimeo Android app and web site.
  • WordPress blog (this one).

Comments

  • The short videos you made at the end of the last session are on the blog – but the blog posts are flagged Private. That means only logged-in users can see them. You have to decide whether your video should be public, or stay private, or be deleted from the blog.

Tutor summary, 8 July 2016

What you did or learnt, session 3 (Apps!)

Media consent forms

  1. Principles of media consent for an enterprise that wants to be taken seriously.
  2. Some learners completed media consent forms that permit their image or voice to be used in photos and videos made by the group.

Photo exercise

  1. Used Android tablet apps to make and resize a photo.
  2. Saved the photo from the tablet to your bold.org.uk Apps for Work Drive.

Video exercise

  1. Used Android tablet apps to make a one-minute video – an interview with people at Kingsland Hub who have signed a media consent form.
  2. Uploaded the video to your course Vimeo account.
  3. Shared your new online video to the course blog – category Video posts (two videos that included an identifiable voice not covered by the consent form have been set to private – visible only to course learners who are signed in).

Resources used

  • HUDL 2 Android tablets.
  • Google Apps for Work Drive (bold.org.uk custom version).
  • Commercial stock photos.
  • Android camera and gallery apps.
  • Vimeo Android app and web site.
  • WordPress blog (this one).

Comments

  1. The still-life photos will be used in a later session.
  2. The point of the video exercise was to demonstrate how easy it is to make a short video on a budget tablet, save it, share it, etc. The videos are not BBC production quality, but none of the defects were your fault. There was a lot of background noise, the lighting was not perfect, and you were using a handheld gadget with a weak microphone. If you had been using a classier tablet on a tripod in a quiet space, the results would have been noticeably better.
  3. It’s normal to edit a video after making it, or at least to want to edit it. Our experimental interview videos are not very suitable for video editing training, but we might build it into a future course – soon – if we can.