In this class Excel project, we will create a two-dimensional table (a matrix) that summarizes different visible traits of students to see which traits are most and least common in 4th Grade. We'll also make different graphs to see which show the information most clearly, and which don't.
If we're lucky, we might even be able to determine if any students possess all the most common traits at the same time. Stay tuned!
Excel Tube Mazes
We are building Tube Mazes (no shared walls) using Excel borders.
a. No shared walls!
b. Each tube is one cell across.
c. Your start area has to have three separate branches, one of which begins the correct pathway.
d. The distance between tubes cannot be more than two cells in any direction.
e. The correct path must be the longest path through the maze.
f. Your final maze will have two pages: one page is the clean finished maze and the other is the finished maze showing the correct path through it.
California Missions List
After you've completed Part 1, which fills in the first three columns, you will add three more columns labeled:
Population | Area (sq. mi.) | Density
Using the information found on the Counties page, fill in the first two columns. The third column is a formula that looks like this: =D2/E2
Write that formula in the first cell of the last column, and then copy it into the remaining cells beneath it. You will have to reformat the result down to a number with 1 decimal place.
Once you have all the numbers entered, and the Density values look correct, answer these questions BELOW the table:
4. The counties with the largest population and smallest population (with numbers)
5. The counties with the largest area and smallest area (with numbers)
6. The counties with the largest density and smallest density (with numbers)
When you have finished all of this, submit your file by uploading it to me.
We're going to use Excel to lay out a table of California missions with specific characteristics about each mission. For our first part of the assignment, you'll create an Excel worksheet that has three columns labeled:
Mission | Year Founded | County
The proper name of each mission (without using the word Mission) goes in the first column. You will list the missions in order from north to south, based on their locations along El Camino Real.
The year the mission was founded goes in the second column.
The name of the modern California county that currently holds the mission goes in the third column.
After you have filled in all three columns, answer these three questions on your worksheet below the list.
Question 1: How many years separate the founding of the first mission and the founding of the last mission?
Question 2: How many years did it take to start half (11) of the 21 missions, and how many years did it take to start the remaining 10?
Question 3: How many counties have more than one mission, and which counties hold the most missions?
WHEN YOU ARE FINISHED: Type your name in an open area of your spreadsheet that is visible when you print it, and then print out the spreadsheet and turn it in.