J9WISE.NET
  • Home
  • Lab Works
    • Curriculum Overview
    • Coding Pathways
    • Makers
    • Digital Citizens
    • Project Standards >
      • Slide Presentation Impact
      • Video Tips & Best Practices
    • Grade 4 Activities (2019-20)
  • Cool Links
    • Ham Radio & Electronics >
      • Ham Radio Blog
      • AllStar
    • Trivia
    • Link-A-Day
    • New Tech
    • Study TIps
    • Grade 5 Podcasts
  • Meta-Learning
    • Troubleshooting Equipment >
      • Maintaining and Troubleshooting Computer Equipment
    • Building Guided Pathways
    • Learn Something New
    • For H.A.S. Parents (K-3)
    • For H.A.S. Parents (4-8)
  • Visuals
    • Images >
      • California Missions Map
    • Amusing Videos
    • Financial
    • Industrial Design
    • Learning >
      • Teaching
    • MAKE stuff >
      • Stop Motion
      • Hexaflexagons
      • Discovery Day Projects 2014 "Squash and Stretch"
      • Discovery Day 2016
    • New Tech
    • Sir Ken Robinson
    • State Podcasts (2015) >
      • State Podcasts (2018) (L-A)
      • State Podcasts (2018) (Y-M)

    Upload your finished assignments here:

    Max file size: 20MB
Click here after filling in all fields above

Class Matrix

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. 

RULES:
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.
Picture

California Missions List

Part 2

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.

Part 1

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.


HELPS:
  • Use the California Missions map to figure out the order of missions. (The map is under the Images tab at the top of this page)
  • To figure out founding dates, use the Missions timeline link on my Cool Links page.
Proudly powered by Weebly
  • Home
  • Lab Works
    • Curriculum Overview
    • Coding Pathways
    • Makers
    • Digital Citizens
    • Project Standards >
      • Slide Presentation Impact
      • Video Tips & Best Practices
    • Grade 4 Activities (2019-20)
  • Cool Links
    • Ham Radio & Electronics >
      • Ham Radio Blog
      • AllStar
    • Trivia
    • Link-A-Day
    • New Tech
    • Study TIps
    • Grade 5 Podcasts
  • Meta-Learning
    • Troubleshooting Equipment >
      • Maintaining and Troubleshooting Computer Equipment
    • Building Guided Pathways
    • Learn Something New
    • For H.A.S. Parents (K-3)
    • For H.A.S. Parents (4-8)
  • Visuals
    • Images >
      • California Missions Map
    • Amusing Videos
    • Financial
    • Industrial Design
    • Learning >
      • Teaching
    • MAKE stuff >
      • Stop Motion
      • Hexaflexagons
      • Discovery Day Projects 2014 "Squash and Stretch"
      • Discovery Day 2016
    • New Tech
    • Sir Ken Robinson
    • State Podcasts (2015) >
      • State Podcasts (2018) (L-A)
      • State Podcasts (2018) (Y-M)