Thursday's Class

Today is the final work day for your midterm project. If you are done bring something to work on during the class. If you do not bring anything to work on I will find you a project.

If you have not presented your family tree you need to do so in class today.

Midterm Thursday March 8 - Study Guide

Midterm Quiz Study Guide

As you are all well aware next week is midterms. You have a midterm assignment which will make up the greatest percentage of your midterm grade. We will also have a midterm quiz on Thursday March 8 which will cover the five chapters in your book. Here is the study guide for the quiz

Study Guide

Terminology:

1.     Acceptable Use Policy

2.     Folder

3.     Copyright

4.     Function

5.     Formula

6.     Formatting

7.     Ribbon

8.     Slide

9.     Taskbar

10.  Home

11.  Table

12.  Chart

13.  Hyperlink

14.  Design Template

15.  Office Button

16.  Right Click

17.  Cell

18.  Row

19.  Column

20.  Dragging

21.  Template

22.  Header

23.  Footer

24.  Font

25.  Text box

Programs:

1.     Word Documents

o   Tables

o   Organizational charts

2.     Power Point

o   Create slides and change layout

3.     Excel Database

o   Set up simple database and use a function and insert a chart

Format:

Matching: 20 definitions from the above list of terms.

Open Microsoft Office programs in Word, Excel, and PowerPoint and perform a list of tasks which are identified above.

Family Tree

Just a reminder that your Family Tree Power Point and presentation is due Tuesday February 28. You need to have a minimum and 5 slides and use hyperlinks.

Thursday's Class

For class on Thursday we will meet in B03 to review hyperlinks in your family tree presentations. We will also be working on mail merge in Access. The last part of the class will be work time for your midterm projects and family tree Power Points.

Family Tree

Just a reminder your Family Tree Power Point is due next Tuesday, February 28. You will present your Family Trees to the class.

Midterm Assignment

Midterms begin in two weeks, I am giving you your assignment today so you can get started. The assignment is due on Tuesday March 4.

Field Trip Assignment

Due: March 6, 2012

You are taking your class on a field trip to Medora for their year-end celebration. You need to be organized for the trip. There are five things you need to do in the planning process. You will prepare the five components and present them to your peers on March 6.

1.    Letter to Parents

·         Using a letter template in Word write a letter to the parents letting them know about the dates and location of the field trip. Let them know that they will receive a brochure with more details. Your letter should also include a request for volunteers.

2.    Budget

·         You will need to prepare a budget for your class trip. You can use Access or Excel, there are a number of templates you can use or make your own. Your budget needs to include transportation, accommodations, activities (minimum 3), and food for 15 students, 3 chaperones, and yourself. You can include other items in your budget.

3.    Brochure

·         Create a brochure to create excitement for your students and also to provide parents with the itinerary for the trip. You should include dates, locations, activities, what to bring, where are we staying and other details. The brochure must contain pictures. You can use a template in Word or Publisher or create your own.

4.    Activity

·         To build excitement and prepare students for the field trip you need to plan an activity. You can make a scavenger hunt, crossword puzzle, word search , fill in the blanks, game (Power Point or Excel) or any other activity that will prepare students.

5.    Rubric

·         Using a rubric maker (we will look at some examples in class) make a rubric for your activity.

Task Stream Portfolios

Just a reminder that if you have not yet met with Tivona about your Task Stream portfolio you need to no later than Wednesday February 22. If you have questions please contact Tivona.

Rubrics

You have all seen several rubrics during your educational career at UTTC and other places. A rubric serves as a standardized assessment tool. As part of your midterm assignment you are asked to create a rubric for an activity. To get you started there are some websites that can help with the set up.
Rubistar,
Rubrics
Rubric Maker

Rubric

Class Today 2/16/12

For class today we will using Access to create a database and a report. You will receive a handout with the assingment.

Assignment due Tuesday Feb. 21, 2012
Let Me Try: Number Patterns, page 115 and 116. You will followng the directions to create an Excel database for students to work on number patterns.

Thursday February 16

Remember your scavenger hunt and engrade paragraph are due no later than 9:00 a.m. today to receive full credit.

Class Today

Happy Valentine's Day!
Write a poem for valentine's day. Use this site to help write an acrostic poem. Poem

We are going to play with Excel today.
Today you are the teacher and you will be reviewing a lesson using Excel and Valentine's Day.

Grade Tracking Programs

There are a number of programs available to track your grades without creating your own. Sign up for a free membership for Engrade. Make sure to add this to your chart. Write a paragraph describing engrade, what you like, changes you would like to see, and some advantages to creating your own gradebook. Due Thursday February 16. http://www.engrade.com/

Terminology Time

Below is a list of terminology that we have used to date in this class. You need to know what each of these terms mean, there might be a test! Rather than just write the definitions Lets make a crossword puzzle. Here are links to get you started, pick a format and make a puzzle. All the definitions are in your text book. Puzzle Maker, Puzzle Maker2, Puzzle Maker 3, Puzzle Maker 4

Due: Tuesday February 14

1.     Acceptable Use Policy

2.     Folder

3.     Copyright

4.     Function

5.     Formula

6.     Formatting

7.     Ribbon

8.     Slide

9.     Taskbar

10.  Home

11.  Table

12.  Hyperlink

13.  Design Template

14.  Office Button

15.  Right Click

16.  Cell

17.  Row

18.  Column

19.  Dragging

20.  Template

21.  Header

22.  Footer

23.  Font

24.  Text box

Scavenger Hunt

You can create your scavenger hunt in word and use hyperlinks. You can text or e-mail me with questions.

Class Today 2/7/12

Excel Database

You need to have your databases completed by class on Thursday. Remember they need to include names (first and last), addresses, grades (5 assignments), 1 weeks attendance. If you are having problems with graphs we will work on them on Thursday. We will be using your database in class on Thursday so make sure you have it done.

Scavenger Hunts!
Today's Class

Scavenger hunts are fun ways to get students using the Internet to search for information. You will chose a theme and create a scavenger hunt based on the theme. You will ask the students questions and then provide links to sites where they can find the answers. Your scavenger hunt must have a minimum of 10 questions and links. It should also be fun and grade level appropriate. You will also need to prepare an answer key for the scavenger hunt and suggest one additional activity for students related to the theme using the Internet or a computer application. This will be due on 2/16/12. Happy Hunting??
How To Create a Scavenger Hunt
More Help
Cyberhunt Example

Tuesday February 7

Remember a graph should be informative. You may have set up your attendance or your grades in a way that making a graph does not give you any valuable information. When you try making a graph and you find it doesn't make any sense. Do not change your database just write a brief justification.

Happy Groundhog Day

I am a Little Groundhog?

Groundhog Day 2012

Thursday's Class

Did the groundhog see his shadow?

Take a quick Quiz 

Today we will continue to explore Excel looking at a few more options and tools.
Assignment - Thursday February 9 (sent electronically prior to class)
Use excel to set up your database for your class.

     Class List: you should have a minimum of 15 students in the class (you make up the names or use names from placement). For each fictitious student you need to have a first and last name as well as a student number. You will also need to create an address for each student which will be use to create mailing labels in access for the next chapter.

2.      In the database you should include attendance for a week and a minimum of five assignments.
         You should represent your attendance for the week using a  graph. Your grades must include the
        class average for each assignment as well as a grade for each student. You will also need to 
         represent the class assignment data visually.