Computer Fundamentals (Laboratory)

At the end of the lesson, students will be able to do the following:

1. Create labels in Gmail;

2. Change settings of labels, like their color; and

3. Demonstrate how to tag emails from a specific email address using the Filter feature.

Video Lesson: https://youtu.be/odex3_UYbeA

At the end of the lesson, students will be able to do the following:

1. Show how to block shares from another user;

2. Demonstrate how to block and unblock people in Google Drive.

Video Lesson: https://youtu.be/QDL8LinZHiA

At the end of the lesson, students will be able to do the following:

1. Differentiate the 3 document modes in Google Docs, namely: editing, suggesting, and viewing modes; and

2. Demonstrate how to use each document mode.

Video Lesson: https://youtu.be/RYkFxnq06Ao

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to use the Table of Contents feature of Google Docs; and

2. Show how to change the format of sections in a document to include in the Table of Contents.

Video Lesson: https://youtu.be/SlwTfHX2mSQ

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to add sources to Citation sidebar of Google Docs;

2. Use different types of citations, such as MLA, APA, and Chicago.

3. Add an in-text citation in a file;

4. Insert a bibliography in a file.

Video Lesson: https://youtu.be/xIgaow2HHAI

At the end of the lesson, students will be able to do the following:

1. Share a Google file directly with people or groups;

2. Be able to change the Share with people settings;

3. Assign a user to have viewer, commenter, or editor access;

4. Make another user the new owner of a file; and

5. Get the shareable link and give anyone with the link have viewer, commenter, or editor permission.

Video Lesson: https://youtu.be/1iS3Nd5uLuE

At the end of the lesson, students will be able to do the following:

1. Show how to add images onto Google Slides using these different ways: upload from the computer, search the web, and insert from Google Drive, Google Photos, URL, and Camera;

2. Be able to use the tools to format an image, like the Border color, Border weight, Border dash, and Format options.

3. Manipulate images using the Animate, Reset image, Replace image, Crop, Mask image, and Insert link.

Video Lesson: https://youtu.be/L1GXQeb2EM4

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to edit a Google Slides template;

2. Create slide templates, themes, or layouts using the Slide Master view (UPDATE: Slide Master is now called Theme Builder);

3. Import a slide from another presentation.

Video Lesson: https://youtu.be/DZ8uFsvwoSE

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to insert charts in Google Slides; and

2. Show how to edit charts.

Video Lesson: https://youtu.be/UXG7Sh-xx6g

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to insert diagrams in Google Slides; and

2. Show how to edit diagrams.

Video Lesson: https://youtu.be/7CEj3QqRMRU

At the end of the lesson, students will be able to do the following:

1. Explain what is Publish to the Web feature of Google Slides;

2. Discuss things to remember when using Publish to the Web feature; and

3. Demonstrate how to use it.

Video Lesson: https://youtu.be/5mdfN6ASZ98

At the end of the lesson, students will be able to do the following:

1. Identify operators and determine their precedence;

2. Compare and contrast formulas and functions;

3. Create formulas and use functions;

4. Describe, create, edit and delete Named ranges;

5. Use Named ranges in a function;

6. Define different types of cell references; and

7. Create relative reference, absolute reference, and mixed reference.

Video Lesson: https://youtu.be/VXYZuC1IL4g

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to use the following logical functions: IF, SUMIF, AVERAGEIF, COUNTIF, and IFS;

2. Utilize AND and OR logical operators; and

3. Show how to use conditional formatting to create format rules.

Video Lesson: https://youtu.be/hrtnv-h_exY

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to use the LOOKUP function in Google Sheets;

2. Show how to use the HLOOKUP function in Google Sheets;

3. Discuss how to use the VLOOKUP function in Google Sheets;

Video Lesson: https://youtu.be/4W_zJiRqWG4

At the end of the lesson, students will be able to do the following:

1. Use the different criteria to create rules when validating data in a cell; and

2. Demonstrate how to create an in-cell dropdown list.

Video Lesson: https://youtu.be/XSoGCBO3zeI

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to create the following graphical representation of tabular data:

   • Organizational Chart

   • Bar Chart and Column Chart

   • Line Chart

   • Pie Chart

   • Scatter Chart

   • Bubble Chart

Video Lesson: https://youtu.be/Nz40IxmXotM

At the end of the lesson, students will be able to do the following:

1. Show how to use pivot table in Google Sheets; and

2. Create a sheet with pivot table data.

Video Lesson: https://youtu.be/YLd9-5rEb6I

At the end of the lesson, students will be able to do the following:

1. Demonstrate how to create a pivot table in Google Sheets; and

2. Show how to filter pivot table using the Slicer tool.

Video Lesson: https://youtu.be/h50--Yq0sXo