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.
After that, we're going to create Venn Diagrams that show how our categories overlap.
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.
Grade 4 Activities
Page Layout Using Excel, PowerPoint, and Publisher
Our next project involves simple page layout. We will be writing a news story to fit onto a front page of a newspaper, along with a lead headline, a sidebar story and headline, and a picture with caption.
These will be placed under a banner that includes an edition, date, and a nameplate. These elements of a front page will be tried out in three different applications: PowerPoint, Excel, and Publisher.
Methods of how each application organizes this kind of information will be compared so that you can see the advantages of each of these programs, as well as the challenges.
But first - WRITE THE STORIES: The stories will be about one of the missions, or about a major event in California history, and will be written with historical accuracy but as if You Were There. You'll have to find a real event for your Lead Story, especially when talking about one of the missions, and the date of your newspaper will have to match the date of the real event (or be the day after). Be sure to include the WHAT, WHEN, WHERE, WHO and HOW (and WHY) information in the Lead Story, and any other details that add more accuracy and interest to the story.
The Sidebar Story is something you can make up that goes along with the real story. You could make up a short interview with someone (real or imaginary) who experienced the real event, or who was directly affected by it, or you could talk about the long term effects, how things may change as a result of the event, and so on. It all needs to be based in facts, but doesn't have to focus on them. Write these stories first using a word processor, such as Google Docs.
Your picture should be one that shows the event or the mission around the date of the real event. These will likely be paintings, right? (Remember, practical photography wasn't around before the 1840's, so if your event took place before then, such as the founding of the missions, there is no chance you'll find any real photographs of it from those times.) If you can find a picture showing the event itself (or if it's recent enough to find a photo), try to use that! Your caption describes what is shown in the picture, possibly pointing out specific details.
Headlines should summarize in an interesting way what the story is about. Try to keep them to one line apiece.
Name your newspaper in the Nameplate in 2-3 words. Your Edition should read "Evening Edition" or "Late Edition" and the Date should match the date of your Lead Story event (or be the day after). Remember, these are the only dates you can use: the exact date of the event or the day after.
MISSIONS: Part 2 (First assignment due in Trimester III)
After you've completed Part 1, which fills in the first three columns, you will label three more columns (start in Column D):
Population | Area (sq. mi.) | Density
Using the information found on the Counties in California page (look under Explorers on the Cool Links page), fill in columns D and E with the necessary information.
The third column (F) is slightly trickier: You're going to use a formula that looks like this: =D2/E2 This tells your spreadsheet to figure out the quotient when you divide what is in D2 by what is in E2, or when you divide Population by Area. The result is the number of people per square mile in the county, which is its population density.
Write that formula ( =D2/E2 ) in the first cell of the last column (including the equal sign!). This should be in cell F2. Then copy that cell into the remaining cells beneath it. (You can drag the copy box, or use Copy and Paste) After you've copied the formula into all the other cells, you will have to reformat the resulting numbers down to a number that shows exactly 1 decimal place to make it easier to work with. Click the button on the toolbar that shows a .0 with a left arrow under it called Decrease Decimal Places to get rid of the extra decimal places. It's usually next to the percent sign ( % ).
Once you have all the numbers entered, and the Density values look correct, answer these remaining questions BELOW the table in complete sentences, and below the answers you wrote for Part 1:
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, share your file or send it to me by uploading it to me. If you shared it before with me for Part 1 using Sheets, don't change the filename. I should see the changes you've made to the file. If you used Excel, you'll have to upload your changed file first, and then share it again with me.
MISSIONS: Part 1 (Last Assignment due for Trimester II)
We're going to use a Google Spreadsheet to lay out a table of California missions with specific characteristics about each mission. For our first part of the assignment, you'll create a Google spreadsheet 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 in complete sentences on your worksheet below the table.
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: Share your spreadsheet with me. Make sure you show that I "Can Edit" your file. I will look at it and highlight anything that needs correcting.