Here is my final project for Course 1. There are a few qualifications I feel the need to add.
First, I modified the UbD format. I had to make my UbD unit more functional for me, a tool that worked for me day-to-day in the classroom. I kept the standard boxes that Wiggins & Tighe have, but expanded the end to more of an outline format. I also included a place for reflection, which I find to be a necessary component to sound teaching practices. I use this format at my school, and I think our curriculum director is lukewarm to my changes.
Second, this was a work in progress. I finished this unit a couple weeks ago, and wanted to build it up as my final project for this class.
Unit Title: Utilizing MS Excel
Grade Level: High school (9-12)
Subject/Topic Areas: Math / Problem solving skills
Time Frame: Two weeks maximum
Stage 1 – Identify Desired Results
Established Goals
| NETS Standards Met:Students will:
1.a: apply existing knowledge to generate new ideas, products, or processes
1.c: use models and simulations to explore complex systems and issues
1.d: identify trends and forecast possibilities
4.a: identify and define authentic problems and significant questions for investigation
Common Core Standards Met:
F-BF.1: write a function that describes a relationship between two quantities
S-ID.1: represent data with plots on the real number line (dot plots, histograms, and box plots) |
| What understandings are desired? |
What essential questions will be considered? |
| Tapping into the power of MS Excel can be a powerful tool to handle repeated simple and complex formulas.By inputting data and then interpreting trends, students can begin to problem-solve in a more efficient way. |
How can we utilize MS Excel to display and manipulate data?What can I do to make my life easier through the use of this tool? |
What key knowledge and skill will students acquire as a result of this unit?
Students will know….
- How to set up a spreadsheet with data
- How to use technology in useful and innovative ways
- How to interpret and display data
|
Students will be able to….
- Create a fictitious gradebook to see how teachers arrive at a final grade
- Examine said gradebook and look for trends
- Apply ideas gained from data entry and display to solve other problems
|
Stage 2 – Determine Acceptable Evidence
What evidence will show that students understand?
| Performance Tasks:Demonstrate knowledge and ability through computer lab activities that require use of MS Excel.
GRASP Task:
Goal: Utilize the power of MS Excel, specifically to display data and input equations
Role: Teacher
Audience: Students
Situation: College preparatory, private international school
Product:
- Manipulation of the order of operations as it applies in MS Excel
- Implement skills gained from introductory activities to problem solve the final project
|
What other evidence needs to be collected in light of Stage 1 Desired Results?
| Other Evidence: (e.g., tests, quizzes, prompts, work samples, observations)Daily warmup activities; Excel prompts when we’re not in the computer lab; quizzes; ICW (In Class Work) |
Student Self-Assessment and Reflection:
| As students complete their sample gradebooks, I will ask them to reflect upon a single student and prepare evidence that shows weaknesses or strengths of a particular, fictitious student.For the final project, I again ask students to reflect upon their answers to see if they are similar to classmates and if answers seem to make sense. |
Stage 3 – Plan Learning Experiences
What sequence of teaching and learning experiences will equip students to engage with, develop, and demonstrate the desired understandings? Use the following sheet to list the key teaching and learning activities in sequence.
(At this point, I have forgone the final box and put in an outline. I have also included a portion for my own self reflection, and restated the essential question because I need to keep students focused on the bigger picture. Some of these boxes are filled in by hand, but after finishing this unit a couple weeks ago I typed some of the reflections.)
Essential Question: How can we utilize MS Excel to display and manipulate data?
|
Dates:
Start 2/19 End 3/1
Quizzes One (3/1)
Test (project only)
Estimated classes: 5 to 6
|
Teacher reflection
- § For next year I will:
- § Require printed names on anything that’s submitted.
- § Set up an option for emailing work to me.
- § Require any printed materials to fit on the smallest number of pages.
- § Other adjustments I will make:
|
Formulas: Basic 4 operations +, -, *, /
Play KRYPTO; review PEMDAS (BEDMAS)
ICW: Can you find the locations within MS Excel?
Activity – Use Excel for showing PEMDAS parts only
HW: Complete activity; print and show answers for each
Other formulas: Average, Percent, Sum, and multi-step
Activity – Sample gradebook; directions
HW: Complete activity; print and show answers for each
Data displays in Excel: pie charts, histograms, line graphs
By hand first (proportions for pie charts;
stem-and-leaf plots for histograms;
graph points for line graphs)
Show how to do in MS Excel
HW: Use gradebook data file to create charts
Data displays day 2
Warmup: How to find my gas mileage given this data.
Finish by hand, do in Excel
Quiz on Excel parts
Introduction to final gas project
Data sheets (& answers); reflection sheet
Adapted (and modified) from Wiggins, Grant and Jay McTighe Understanding by Design, 2nd Edition, ASCD, Alexandria, VA, 2005.