Skip to content Skip to navigation Skip to login

Tech Integration Project
Lesson Accelerator: Project Launcher

Media Moments
Platform: PC
Application:

Description

The process for creating the sample spreadsheet in Microsoft® Excel® 2010 is described below. The Completed Project Movie shows you what the example project might look like. The tutorial movies that follow demonstrate, step-by-step, how to create the spreadsheet and charts using the sample data provided. This project can be easily modified in order to create a spreadsheet and manipulate data relevant to any subject under study. For a complete project description, including goals, objectives, and materials needed, see the Project Overview.

The Example Project

The Completed Project movie will show you what the completed example project looks like.
expand  Completed Project Movie
Tutorial Number Availability Status Tutorial Title Key # Length
1. preview What the example project looks like 95002 01m:42s
Subscribers have access to download the resource materials for this project, which includes all example files, an assessment rubric, and information about adapting and extending the example project.

Creating Your Own Project

We'll begin by creating a new document in Microsoft® Excel® 2010. The tutorial movies will demonstrate how to set up column and row labels, enter formulas, and enter data into your spreadsheet. We'll also learn how to create and format a 3-D pie chart and a 3-D area chart.

Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Entering column and row labels 95003 02m:39s
2. locked Formatting cell contents 95004 01m:37s
3. locked Adjusting column widths 95005 01m:46s
4. locked Entering the daily total formula 95006 03m:26s
5. locked Entering the total media type formula 95007 01m:28s
6. locked Saving your spreadsheet 95008 01m:08s
7. locked Entering the daily media data 95009 02m:09s
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D pie chart of total media types 95010 01m:50s
2. locked Adding category labels to the chart legend 95011 02m:15s
3. locked Formatting the chart title 95012 02m:20s
4. locked Labeling the pie with percentages 95013 01m:55s
5. locked Changing the 3-D view 95014 01m:29s
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Creating a 3-D area chart from daily data 95015 02m:49s
2. locked Formatting the category axis 95016 01m:41s
3. locked Formatting the value axis 95017 01m:53s
Tutorial Number Availability Status Tutorial Title Key # Length
1. locked Changing the color representing a series 95018 02m:15s
2. locked Changing the size of the plot area 95019 01m:27s
3. locked Printing your charts and sheets 95020 02m:28s
Tutorial series by Robert Norgon
©2013 Atomic Learning, Inc.   All rights reserved.