Lovely Professional University, Punjab

Course Code Course Title Course Planner Lectures Tutorials Practicals Credits
CAP140 G SUITE FOUNDATION 18710::Navpreet Kaur 0 0 3 2
Course Weightage ATT: 5 CAP: 45 ETP: 50 Exam Category: X6: Mid Term Exam: Not Applicable – End Term Exam:
Practical

Course Outcomes :Through this course students should be able to

CO1 :: Learn the use of the google drive to share google docs, google sheets and google slide.
CO2 :: Understand how to create and access the google document from anywhere and also how to collaborate using google docs.
CO3 :: Visualize how the Gmail settings can be personalized.
CO4 :: Demonstrate how to schedule and launch a hangout meet.

TextBooks ( T )
Sr No Title Author Publisher Name
T-1 THE HYPERDOC HANDBOOK: LISA HIGHFILL, KELLY EDUCREATION PUBLISHING
DIGITAL LESSON DESIGN USING HILTON, SARAH
GOOGLE APPS LANDIS
Reference Books ( R )
Sr No Title Author Publisher Name
R-1 GOOGLE DRIVE AND DOCS IN 30 IAN LAMONT EDUCREATION PUBLISHING
MINUTES

Relevant Websites ( RW )
Sr No (Web address) (only if relevant to the course) Salient Features
RW-1 https://www.lynda.com/G-Suite-tutorials/11941-0.html Provided GSuit tutorial from Lynda

RW-2 https://support.google.com/a/users/?hl=en#topic=9393003 Provided GSuit tutorial from Google

RW-3 https://support.google.com/docs/answer/2763168?co=GENIE.Platform Using google slide

%3DDesktop&hl=en
RW-4 http://www.wikihow.com/Use-Google-Spreadsheets Using google sheets

RW-5 https://support.google.com/docs/answer/7068618?co=GENIE.Platform Using google documents

%3DDesktop&hl=en

An instruction plan is only a tentative plan. The teacher may make some changes in his/her teaching plan. The students are advised to use syllabus for preparation of all examinations. The students are expected to keep themselves
updated on the contemporary issues related to the course. Upto 20% of the questions in any examination/Academic tasks can be asked from such issues even if not explicitly mentioned in the instruction plan.
 RW-6 https://drive.google.com/file/d/0Bw8tVqONwIzyNHNEWGRPX3JqUnM/edit? Google drive and Google Docs
resourcekey=0-UeaZ4UiuZ4cKqmQVYjjb2A
Audio Visual Aids ( AV )
Sr No (AV aids) (only if relevant to the course) Salient Features
AV-1 https://www.youtube.com/watch?v=LW9gh2myDhA Google drive tutorial

Detailed Plan For Practicals

Practical No Broad topic Subtopic Other Readings Learning Outcomes

Practical 1 Working with Google Drive Creating and managing folders RW-1 Practical 1 : Introductory Lecture (Lecture Zero)
RW-2 Students will learn how to create and manage the
AV-1 files and folders on google drive

Working with Google Drive Managing files RW-1 Practical 1 : Introductory Lecture (Lecture Zero)
RW-2 Students will learn how to create and manage the
AV-1 files and folders on google drive

Practical 2 Working with Google Drive Locating files RW-6 Practical 2: Student will learn the basics of Google
DK-1 Drive and understand its working.

Working with Google Drive Changing display and settings RW-6 Practical 2: Student will learn the basics of Google
DK-1 Drive and understand its working.

Practical 3 Working with Google Drive Sharing files and folders RW-6 Practical 3: Student will able to learn about the
DK-1 sharing of files in google drive. Lab Evaluation 1

Practical 4 Working with Gmail Personalizing settings RW-1 Practical 4 : Student will able to use personalized
RW-6 setting, inbox and communication with contacts.

Working with Gmail Managing your inbox RW-1 Practical 4 : Student will able to use personalized
RW-6 setting, inbox and communication with contacts.

Working with Gmail Managing and communicating with RW-1 Practical 4 : Student will able to use personalized
contacts RW-6 setting, inbox and communication with contacts.

Practical 5 Working with Gmail Locating messages RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2
Working with Hangouts Meet Launching a Hangout RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2

An instruction plan is only a tentative plan. The teacher may make some changes in his/her teaching plan. The students are advised to use syllabus for preparation of all examinations. The students are expected to keep themselves
updated on the contemporary issues related to the course. Upto 20% of the questions in any examination/Academic tasks can be asked from such issues even if not explicitly mentioned in the instruction plan.
Practical 5 Working with Hangouts Meet Scheduling a Hangout RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2
Practical 6 Working with Hangouts Meet Scheduling a Hangout RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2
Working with Hangouts Meet Launching a Hangout RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2
Working with Gmail Locating messages RW-6 Practical 5 : Student will able to schedule and
DK-1 launch a hangout call. Practical 6 : Lab Evaluation
2
Practical 7 Working with Hangouts Meet Presenting your screen in a Hangout RW-2 Practical 7: Students will learn to present and
DK-1 manage a hangout meeting.

Working with Hangouts Meet Managing sound, video and bandwidth RW-2 Practical 7: Students will learn to present and
DK-1 manage a hangout meeting.

Working with Hangouts Meet Managing meetings with Hangouts RW-2 Practical 7: Students will learn to present and
DK-1 manage a hangout meeting.

Practical 8 Working with Google Docs Setting up pages RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Working with Google Docs Inserting non-text elements RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Working with Google Docs Changing text attributes RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Practical 9 Working with Google Docs Changing text attributes RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Working with Google Docs Inserting non-text elements RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Working with Google Docs Setting up pages RW-5 Practical 8 : Student will able to setup page and
RW-6 change attributes in google docs. Practical 9 : Lab
Evaluation 3
Practical 10 Working with Google Docs Formatting text blocks RW-5 Practical 10: Student will learn the formatting of
RW-6 text block and tables in docs.

Working with Google Docs Using content management tools RW-5 Practical 10: Student will learn the formatting of
RW-6 text block and tables in docs.

An instruction plan is only a tentative plan. The teacher may make some changes in his/her teaching plan. The students are advised to use syllabus for preparation of all examinations. The students are expected to keep themselves
updated on the contemporary issues related to the course. Upto 20% of the questions in any examination/Academic tasks can be asked from such issues even if not explicitly mentioned in the instruction plan.
Practical 10 Working with Google Docs Inserting and editing tables RW-5 Practical 10: Student will learn the formatting of
RW-6 text block and tables in docs.

Practical 11 Working with Google Docs Collaborating and sharing in Docs RW-5 Practical 11 : Students will learn to collaborate,
RW-6 share and download files in docs. Practical 12 : Lab
Evaluation 4
Working with Google Docs Download Options RW-5 Practical 11 : Students will learn to collaborate,
RW-6 share and download files in docs. Practical 12 : Lab
Evaluation 4
Practical 12 Working with Google Docs Download Options RW-5 Practical 11 : Students will learn to collaborate,
RW-6 share and download files in docs. Practical 12 : Lab
Evaluation 4
Working with Google Docs Collaborating and sharing in Docs RW-5 Practical 11 : Students will learn to collaborate,
RW-6 share and download files in docs. Practical 12 : Lab
Evaluation 4
Practical 13 Working with Google Sheets Managing values, rows, cells, or RW-4 Practical 13 : Student will learn the basics of
columns RW-6 Google sheets and understand its working.

Working with Google Sheets Formatting sheets and cells RW-4 Practical 13 : Student will learn the basics of
RW-6 Google sheets and understand its working.

Working with Google Sheets Inserting non-text elements RW-4 Practical 13 : Student will learn the basics of
RW-6 Google sheets and understand its working.

Working with Google Sheets Using functions RW-4 Practical 13 : Student will learn the basics of
RW-6 Google sheets and understand its working.

Working with Google Sheets Managing and transforming data RW-4 Practical 13 : Student will learn the basics of
RW-6 Google sheets and understand its working.

Working with Google Sheets Collaborating and sharing in Sheets RW-4 Practical 13 : Student will learn the basics of
RW-6 Google sheets and understand its working.

Working with Google Sheets Importing and converting from other RW-4 Practical 13 : Student will learn the basics of
file types RW-6 Google sheets and understand its working.

Practical 14 Working with Google Slides Building a presentation RW-3 Practical 14 : Student will learn the basics of
RW-6 Google slides and understand its working.

Working with Google Slides Working with text RW-3 Practical 14 : Student will learn the basics of
RW-6 Google slides and understand its working.

Working with Google Slides Working with non-text elements RW-3 Practical 14 : Student will learn the basics of
RW-6 Google slides and understand its working.

An instruction plan is only a tentative plan. The teacher may make some changes in his/her teaching plan. The students are advised to use syllabus for preparation of all examinations. The students are expected to keep themselves
updated on the contemporary issues related to the course. Upto 20% of the questions in any examination/Academic tasks can be asked from such issues even if not explicitly mentioned in the instruction plan.
Practical 14 Working with Google Slides Arranging objects RW-3 Practical 14 : Student will learn the basics of
RW-6 Google slides and understand its working.

Working with Google Slides Sharing a presentation RW-3 Practical 14 : Student will learn the basics of
RW-6 Google slides and understand its working.

SPILL OVER
Practical 15 Spill Over

An instruction plan is only a tentative plan. The teacher may make some changes in his/her teaching plan. The students are advised to use syllabus for preparation of all examinations. The students are expected to keep themselves
updated on the contemporary issues related to the course. Upto 20% of the questions in any examination/Academic tasks can be asked from such issues even if not explicitly mentioned in the instruction plan.