Excel Chapter One
First Things First:
Many of you are vaguely familiar with Excel and some of you are not. But even the people who use Excel are left scratching your head when I ask you “What is Excel used for?” One of the reasons it’s difficult for you to answer that question is that you know very little about the capabilities of Excel. But that’s ok: that is the reasons you are in this classroom and reading this. But first, I have an exercise that I want you to do. Some people are intimidated by new or unfamiliar applications. This exercise is designed for you to get acquainted to Excel and some of its features. So relax, and don’t worry, you cannot ruin the software or mess something up. Directions are on the right-side of this paragraph.
Do Not Use Your Books For These Assignments!
Make a spread sheet which displays a family budget. Put down all of your monthly expenses and forecast how much it will cost you a year. Make believe you are an adult and you have to pay for food, gas, doctor’s fees, telephone, utilities rent/mortgage, clothes, etc. Make sure the totals are added. Make a pie-chart of your monthly bill. Do not use your book at all for this exercise! It's more fun to figure it out for yourself, plus it helps you learn better. After you finish this assignment, work on Assignment 2
Now that you are an expert on Excel, I want you to make another chart. This time around, you will figure out how you spend your time in a 24 hour period. The time will be from 12:01 midnight to 12 noon the next day. For some ideas, think about how much time you spend doing the following activities; hanging with friends, sleeping, homework, watching television, wasting time on Facebook, playing video games, school, etc. Make a nice pie chart with the figures you are using. Do not use your book at all for this exercise! After you complete the two assignments, go on to the book and start doing the “Red Dot” exercises of Excel, Chapter 1
Excel Chapter 1: "Creating a Worksheet and an Embedded Chart"
Microsft Office Excel is a powerful spreadsheet program that allows users to organize data, complete calculations, make decisions, grapph data, develop profesional looking reports, publish organized data to the Web, and access real-time data from Web sites. The four major parts of Excel are:
For this chapter, you must complete the following:
- Red Dot Section
- Apply Your Knowledge
- Extend Your Knowledge
- Make It Right
- Lab 1, 2, and 3