Today's Class 1/29/13

Don't forget you have your presentation today. We will start the class in B03 so you can do your presentations.

We will do a brief overview of some of the Excel functions then you will head to the lab to practice. We will send the next couple of weeks on Excel so today will only be a brief introduction.

Excel Database Activity Due Tuesday February 5, 2013 

Using your Excel database complete the following steps:

1.       Open an new Excel document

2.       Label the first column 1A - color

3.       Label the second column 1B - saying

4.       Label the third column 1C – total

5.       Label the forth column 1D percentage

6.       Insert a header (Conversation Hearts) and footer; the footer must include the date.

7.       Open you hearts and in column A record the color, in column B record the saying, and in column C record the number of occurrences of the color and the saying (most will only have 1).

8.       Once you have your data recorded complete the percentage column D.

9.       In column C format the column so it is set for percentage.

10.   Use the format button to make your auto fit your cell width.

11.   Make sure you have heading for each column, increase the font and make your titles bold.

12.   Use the sort function to sort by the percentage from highest to lowest.

13.   In column C use the formula function to calculate the total of candy hearts.

14.   In column D use the formula function to calculate the total percentage of candy hearts, your total should be 100%

15.   Go to the insert tab in the tool bar. Highlight columns B and C; insert a chart or table representing the total of conversations.

 

16.   Repeat the same steps as in 15 to insert a chart representing the total of each color.

17.   Spend some time experimenting with charts to find the one the best represents the data.

 

Presentations

We will meet in B03 for the first part of the class to look at a some things in Power Point. Today in class you will be working with a partner to complete the Let Me Try activity on page 82 in your textbook. One person will read the directions and the other person will work on the computer. Each of you will need to save a copy of the project.

For Tuesdays class you will need to prepare a minimum of 5 slide presentation using Power Point, Prezi, Google Docs or any other presentation tool. The theme of the presentation is technology in the classroom. Your presentation should include at least one hyperlink, a chart, and pictures. On Tuesday January 28 you will show your presentations to the class.

Update

Here is what is due.

Quiz - send score - January 24
Classroom Rules - January 29

What Do You Know?

Today's class is about seeing what you know. Select a partner or play by yourself. Click on the link and play a game of jeopardy. Jeopardy
Let's see what you know. Click on the ink and take the quiz. send me an e-mail to let me know your score. Quiz. Due January 24
Once you have that done try your luck at this game. Hangman and Terminology

Presentations

Prezi Presentation

Due Date: February 26

1.    Get signed up for Prezi http://prezi.com/

2.    Explore and Learn

3.    Prepare a presentation on “Using Technology in the Classroom”

4.    Present to the class on February 26

5.    If you complete the task and have made a concerted effort you will receive full points.

Class Today 1/22/13

Good Morning Everyone,

Today in class we will be reviewing Power Point, Prezi and other presentation tools. We will begin the class in B03 then move to the lab to work with the tools.

Tuesday's Class

Classroom Rules.
As part of your fictitious classroom responsibilities you must monitor and take care of the computer lab. There are some differences between the classroom and the lab. Create a set of rules for the students to follow in the computer lab.
Here is one example using an acrostic

AN ACROSTIC! Come to class with clean hands. Operate the equipment properly. Make sure you listen to directions. Push your chair in when you are done. Use your inside voice. Touch the keyboard lightly .Eat and drink outside the computer lab. Remember to take your printouts with you. Learn something new each time you come to the lab. Always work toward your best, not your neighbors' best. Be careful handling CD's. · Above is an example of classroom rules. Select a grade level and create your own rules. You do not need to use an acrostic

Today's Class

Good Morning Everyone,

 

I will not be in class today but you will still have class. You can work on your newsletter which is due on Tuesday January 22. When you complete your newsletter you can work on the organizational sites assignment found below. The organizational sites assignment is due on Thursday January 24 but we will spend time on the organizational sites on Tuesday if you are having problems.

 

You will need to e-mail me to let me know you are in class.
 

Organizational Sites

Check out my Diigo site Diigo. Then set up your own account. Take a few minutes to play with the tool and then right a brief paragraph describing how you would use it in the classroom. Make sure you add the site to your table, describe it and rate it.

Here is another site you could use in the classroom to help your students with their organization. Take a minute to explore this site Homework Tool. Write a brief review of the site and then add it to your table.

Third part of your assignment is to find another organizational tool, one that you use or one for the classroom. Come to class on Thursday prepared to share the site with your colleagues. In your presentation show the site and provide two or three uses and one thing that could be improved. Use the comment option in the blog to share the site

Newsletter Assignment

Use word to create a two page newsletter for your class. The newsletter must contain color, pictures and columns. I will give you more information in class and samples. Refer to rubric for more details about the assessment.
Newsletter - Due Tuesday January 22

Newsletter Rubric

Students' Names: ______________________________________________

Points	4	3	2	1
Articles - Supporting Details	The details in the articles are clear, effective, and vivid 80-100% of the time.	The details in the articles are clear and pertinent 90-100% of the time.	The details in the articles are clear and pertinent 75-89% of the time.	The details in more than 25% of the articles are neither clear nor pertinent.
Layout - Headlines & Captions	All articles have headlines that capture the reader's attention and accurately describe the content. All graphics have captions.	All articles have headlines that accurately describe the content. All articles have a byline. All graphics have captions.	Most articles have headlines that accurately describe the content. All articles have a byline. Most graphics have captions.	Articles are missing bylines OR many articles do not have adequate headlines OR many graphics do not have captions.
Graphics	Graphics are in focus, are well-cropped and are clearly related to the articles they accompany.	Graphics are in focus and are clearly related to the articles they accompany.	80-100% of the graphics are clearly related to the articles they accompany.	More than 20% of the graphics are not clearly related to the articles OR no graphics were used.
Use of Word	The newsletter incorporated at least 5 different features of word such as font changes, paragraphs, etc.	The newsletter incorporated at least 4 different features of word such as font changes, paragraphs, etc.	The newsletter incorporated at least3 different features of word such as font changes, paragraphs, etc.	The newsletter did not use word applications to improve the quality of the newsletter
Spelling and Proofreading	No or almost no spelling or grammar errors are in the newsletter	No more than a few of spelling, grammar errors are found in the newsletter.	Several spelling, lexical or grammar errors remain.	Lots of spelling, or grammar errors remain in the final copy of the newsletter.
TOTAL	____ / 20

Tuesday's Class

Good morning, hope everyone is checking the blog, make it a habit to check it. For class tomorrow we will be meeting in B03 to start and then we will spend the second part of class in the lab. We will be looking at "word" and the applications.
Please make sure your homework is either sent before class or brought to class to receive full credit. Being on time is also important.
We will be working on Newsletters in class and you will need to create one for your class. For this class you will be creating a fictitious class that you will use for all your assignments. So start thinking about your class. I will elaborate on this in class.

Homework

1. Read Chapters 1 and 2

2. Answer the folowing questions:

a. What is copyright?
b. What is UTTC's acceptable use policy (hint: student guide)
c. What does NETS stand for?
d. List the six standards.
e. What is the ribbon in Microsoft Office?

3. What is one thing you want to learn in this class?

Due: Tuesday January 15 by 9:00 a.m. (sent electronically)

Introductions

I want to learn a little more about you, but I want you to use technology to tell me. Go to the Wordle link and create a wordle. You can print this out or save it to the gallery and send me the URL.  Have fun with your creation. This will be due Tuesday January 15th.

http://www.wordle.net/create

Check out mine me

Tuesday's Class

Today in class we are going to review the syllabus and complete the syllabus quiz.
You will also need to become a follower of the blog, but before you do that I want you to create a google e-mail that you will use for this class. This is the e-mail you will use for all your assignments and memberships for this course.

The blog will provide you any information about this class you need. I will post all assignments, reminders, announcements, and any other information. You will receive a notice every time I post and it is your responsibility to check the post.

All assignments must be sent electronically unless otherwise indicated.You will also need a flash drive for this class which you will keep all your assignments. As part of the final project you will create an electronic portfolio and presentation so all your work will contribute to this assignment.

Welcome

Welcome to EDU 288 Technology in Education. This course will enable the you to facilitate learning with technology in the classroom setting.