DESIGN PANEL WORKSHOPS 2 – 6 SEPTEMBER 2018

Workshop Test Drive Folders – 6 Sept 2018

CONTENTS:

  1. Get data Student’s from AIMS2000
  2. Login or Sign in to Google Account (using organization account ie.utm.my or mail.fkm.utm.my or gmail)
  3. Get to Google Application Services
  4. Spreadsheet : Query, Vlookup, Web Published, Hide and   Unhide Tab etc
  5. Google Form: Create form, Add Question : short, long  paragraph, radio button, list, File Upload etc.
  6. Use Google Add-Onn to create drop-down list: FormRanger
  7. Folder sharing links and permission setting.

SAMPLE TASKS SOLVED BY GOOGLE APPLICATIONS

1. Preparing Assignment Cover Sheet (Form)

2. Data Collecting and Publishing :

Annual Report Activity collections Form

Annual Report Activity collections Spreadsheet (Allow to View)

Annual Report Publications (Published to Web)

Database Example

3. Student documentation online submission form.

Get response view via spreadsheet

4. Project Assesment Design Rubrics

Project Rubrics Form

Project Rubrics (Response)

5. Google URL Shortener

Google Spreadsheet Functions Examples

QUERY

Examples:

=query(‘Form Responses 1’!A1:N117, “select B,C,D,E,F,G,H,I,J,K,L,M,N”,1)

=query

(‘Form Responses 1’!A1:N117, “select B,C,D,E,F,G,H,I,J,K,L,M,N where E=2016”,1)

=query(‘Form Responses 1′!A1:N117, “select B,C,D,E,F,G,H,I,J,K,L,M,N where C=’Department of Applied Mechanics & Design’ order by E Asc”,1)

 

SPLIT COLUMN

=iferror(split(M2,”,”),””)

if error, results as blank cell

if no error, result in M2 is split in column by looking ‘,’

VLOOKUP

=vlookup(E10,ProjectMarks,2,false)

E10: Reference Cell

ProjectMarks: Range Name

2: Lookup column no 2

false: select to closes value

IMPORTRANGE

=IMPORTRANGE(“https://docs.google.com/spreadsheets/d/1-HXZsQWhAV6kEktHS_l8rDxc7S7NzHIstSA45KCFUpQ/edit#gid=1555251998”, “GP04!ao1:av8”)

etc.

=section&”-“&A10  result: S1-10

=D9&” [“&H9&”]” result: AHMAD [S1-10]

 

Fixed Reference : F4  result:$A1