Tech 10 Project: Excel

Goal               

Create a spreadsheet.

Objective

This project shows you how to use Microsoft Excel (a popular spreadsheet application) to enter some data, format the data, perform some basic calculations on the data, and to present it to a user.

Subject Line for submission

Excel

The Assignment

• For this assignment, you will teach yourself to use Excel using the manual and internet resources, because it is important to learn to use these tools when using new software.
• I will show you some basics about Excel and I will tell you the elements that you are required to have for your Excel assignment, but you will need to find out how to perform those particular tasks.
• There are many Excel tutorials available on the internet. The one at: http://www.usd.edu/trio/tut/excel/ is particularly helpful and includes a short self-evaluation quiz at the end.

The rubric below tells you what you will be required to include in the work you submit.

Step	Required Element in your Excel Assignment	Point value
1	Select cells A1, B1, C1, and D1 and merge the cells using the merge button . Enter your name into the merged cells.	5
2	Repeat the cell merging exercise on worksheets 2, 3, and 4	5
3	Below your name, in the first column, enter a column of 15 numbers – they can be in any order and have any values you choose.	2
4	Above this data, enter the title – “Dataset 1” (you will likely have to “Insert” a new, blank row between your name and the column on numbers)	2
5	Adjust the column width to fit the whole title	2
6	In the second column, enter the title – “Dataset 2”	2
7	Enter 15 different values under “Dataset 2”	2
8	Change the formatting of all the numbers, so it represents money (ie the data should look like $4.00)	2
9	Under either column of numbers, enter a formula to add up the data (Sum formula)	5
10	Under the sum formula, enter a formula to find the average of the dataset (NOTE- make sure it does not including the sum value in the average)	5
11	Under the average formula, enter a formula to find the Maximum value of just the first 10 data points	5
12	In between your data and the sum function, add a blank row	2
13	Copy the three functions you just defined and paste them under the other dataset, so that they now perform their calculations on the other dataset.	2
14	Copy all of the content on this worksheet, and paste it onto sheet 2	2
15	On sheet two, change the formatting (font, column/row size, add titles, etc ) to make it look more professional than sheet 1	5
16	Create a bar chart to compare the two columns of data, and add it to sheet 2	5
17	Create a line graph to compare the two columns of data and add it to sheet 1	5
18	On a third worksheet, enter some new data that you can create a pie chart from. Create one column as a list of at least 4 “Category Labels”	5
19	In the next column enter a corresponding value for each label.	2
20	Create a Pie Chart from this data, making sure you identify the values and labels properly.	5
21	You will have noticed that Microsoft Excel and Microsoft Word have a lot in common when formatting the “look” of your data. On a 4^th datasheet, make a list of 5 formatting tasks that you used while completing the Word assignments (e.g., insert diagram, insert border, change font, etc . . . ).	5
22	Now demonstrate each formatting task on the actual text in the cell in which you listed it.	5
23	Elsewhere on sheet 4, explain what a ‘reference’ in Excel means	5
24	Elsewhere on sheet 4, explain when you would use a spreadsheet (in school and in life)	5
	Total point value	90

For extra work regarding the Pie Chart on Sheet 3, click here.