# PRDV208: Information Management and Processing

This unit should take approximately 3.25 hours to complete.

☐    Subunit 6.1: 0.25 hours

☐    Subunit 6.2: 0.75 hours

☐    Subunit 6.4: 0.5 hours

☐    Subunit 6.5: 1 hour

☐    Subunit 6.6: 0.25 hours

☐    Subunit 6.7: 0.5 hours

Unit6 Learning Outcomes

`````` Instructions: Please click on the link above and view this video
for an overview of Microsoft Excel 2007. This video also covers the
topic outlined in subunit 6.3.

Watching this video and pausing to take notes should take
approximately 15 minutes.

displayed on the webpage above.
``````

`````` Instructions: Please click on the link above and watch this video
tutorial for information on features of the Microsoft Excel 2007

Watching this video and pausing to take notes should take
approximately 20 minutes.

displayed on the webpage above.
``````

Instructions: Please click on the link above and view this video for an overview of how to create a basic spreadsheet.

Watching this video and pausing to take notes should take approximately 25 minutes.

6.3 How Is a Spreadsheet Used in a Business Environment?   Note: This topic is covered by the video in subunit 6.1. The first part of the video explains how spreadsheets are used in the business environment.

6.4 Applying Formulas and Functions in a Spreadsheet   6.4.1 What Is a Formula?   - Web Media: YouTube: DemoTrainer’s “Excel 2007: Use Simple Formulas to Do the Math” Link: YouTube: DemoTrainer’s “Excel 2007: Use Simple Formulas to Do the Math” (YouTube)

`````` Instructions: Please click on the link above and view this video
for an overview of how formulas are applied in a spreadsheet
application.

Watching this video and pausing to take notes should take
approximately 15 minutes.

displayed on the webpage above.
``````

6.4.2 What Is a Function?   - Web Media: YouTube: Ralph Phillips’ “Basic Functions in Excel” Link: YouTube: Ralph Phillips’ “Basic Functions in Excel” (YouTube)

`````` Instructions: Please click on the link above and view this video
for an overview of how functions are applied in a spreadsheet
application.

Watching this video and pausing to take notes should take
approximately 15 minutes.

displayed on the webpage above.
``````

`````` Instructions: Please click on the link above and watch this video
application.

Watching this video and pausing to take notes should take
approximately 10 minutes.

displayed on the webpage above.
``````

Instructions: Please click on the link above and watch this video for an overview of how to create a business forms using a spreadsheet application.

Watching this video and pausing to take notes should take approximately 5 minutes.

6.5.2 How to Create a Business Chart   - Web Media: YouTube: ExcellsFun’s “Charts Basics: Pie, Column, Bar, Line and X-Y Scatter” Link: YouTube: ExcellsFun’s “Charts Basics: Pie, Column, Bar, Line and X-Y Scatter” (YouTube)

`````` Instructions: Please click on the link above and watch this video
for an overview of how business charts are applied in a spreadsheet
application.

Watching this video and pausing to take notes should take
approximately 45 minutes.

displayed on the webpage above.
``````

6.5.3 How to Create a Business Form Using Functions and Formulas   Note: This topic is covered by the video in sub-subunit 6.5.1. The first part of the video explains how to create a business form using functions and formulas.

6.6 Structured vs. Unstructured Data   - Web Media: YouTube: Robert Primmer’s “Structured vs. Unstructured Data” Link: YouTube: Robert Primmer’s “Structured vs. Unstructured Data” (YouTube)

`````` Instructions: Please click on the link above and watch this video
for an overview of structured and unstructured data.

Watching this video and pausing to take notes should take
approximately 15 minutes.

displayed on the webpage above.
``````

6.7 Creating Datasets and Tables   6.7.1 What Is a Dataset?   - Web Media: YouTube: ExcellsFun’s “Data Sets, Excel Tables for Formulas & Charts” Link: YouTube: ExcellsFun’s “Data Sets, Excel Tables for Formulas & Charts” (YouTube)

`````` Instructions: Please click on the link above and watch this video
for an overview of datasets, tables, and how to create a business
form by using data sets and tables. This video also covers the
topics outlined in sub-subunits 6.7.2 and 6.7.3.

Watching this video and pausing to take notes should take
approximately 30 minutes.