week6b

=Week 8: Office Productivity=

__Gaining Students' Attention__
Heard this story on Saturday Morning Edition, [|What Do We Need Algebra For?] It discusses that the evolution of tools available to us encourages different thinking; the interviewee specifically discusses spreadsheets. (Gungoll)

__Objectives and NETS-T Standards Addressed__

 * **3.** || **Model Digital-Age Work and Learning** ||
 * || Teachers exhibit knowledge, skills, and work processes representative of an innovative professional in a global and digital society. Teachers: ||
 * c. || communicate relevant information and ideas effectively to students, parents, and peers using a variety of digital-age media and formats. ||  ||   ||
 * d. || model and facilitate effective use of current and emerging digital tools to locate, analyze, evaluate, and use information resources to support research and learning. ||  ||

__Recall of Prior Learning__
The last couple of weeks we've been very creative with PowerPoint, Glogster, and Animoto. This week we'll focus on efficient and effective work as an instructor.

__Presentation of Material__
Discuss office productivity software. When would you use word processing rather than spreadsheet? What's the difference between a spreadsheet and a database program?

Walk through a test drive of an online student information system: http://www.trackmygrades.com/testdrive.aspx Discuss the reality that all school districts in Oklahoma (and many other states) are required to have a SIF-compliant Student Information System. One of the most popular is PowerSchool ([|http://powerschool.com]) One of the challenges we have had as a school district is the difference between SIF compliant SIS and a working SIF agent. With the State of Oklahoma mandating THE WAVE be operational last year, all students should now have a unique State Student ID which will be used in coordination with the online testing that will occur this spring. If the SIF agent has not received the correct State ID (which populates the SIS), we are not sure how the student will take the mandated tests. (Todd)

I think that I am going to do something to demonstrated Wordle here as it seems like the most appropriate place. (Gungoll)

__Discovery Learning and Performance__
Go through the //Do Vampires Really Exist?// Excel activity: http://www.mth.pdx.edu/~ediger/490590projects/Do%20Vampires%20Really%20Exist.htm

__Assignments and Assessment__
Did we decide not to have the U.S. Presidents' assignment anymore? I like that one better in learning how to use Excel in the classroom than these two. Other thoughts? (Gungoll) I still use it for in class discussion and in-class grade. (Borland) The code for the auto-state count is here: =COUNTIF($H$6:$H$48,A56) (This will look in H6 thorugh H48 for any matches to A56. In this case A56 is Arkansas)

Also, I was asked about the code for the gradebook to check the Letter grade. Here it is in case anyone needs it: =IF(K2>89%,"A",IF(K2>79%,"B",IF(K2>69%,"C",IF(K2>59%,"D","F")))) Obviously, K2 is the cell with the calculated grade. (Borland)

Input the [|following] into a spreadsheet and do the appropriate calculations. Here's a link to a clear explanation for the IF,THEN statement in step 4: []. Scroll down to Complex Formulas.
 * Assignment 1:** Gradebook
 * All quizzes are worth 10 points
 * All homework assignments are worth 50 points
 * Total and average the grades
 * Use the help menu to find the formula to assign a letter grade for a number.
 * Insert a pie chart of the final grades.
 * Format the spreadsheet. Change the font size and color, use your background color, etc.

Use Microsoft Word and [|this template] to generate progress reports based on the data from the [|gradebook] that you designed earlier. This is an in-class assignment. (Look up "mail merge manager" in Help)
 * Assignment 3:** Progress Report (based on Assn. 2 Gradebook)


 * Assignment 4:** Chapter 5 Quiz

__Retention/Transference__
Now that you're more familiar with Excel, try setting up a personal finance budgeting system in a spreadsheet using formulas to automatically update your data.

__Additional Items For Online Sections__
The days of hand-calculating student grades are over (at least they should be!). Also, the days of keeping what's going on in a teacher's gradebook a mystery is also over. Web-based student management systems are quickly becoming the norm in schools of all sizes. These systems not only keep grades, attendance, and lots more instantly in sync between teachers and the central office, they also offer students and parents online access to this information, just like loggin into a bank account online.

Previous Week Next Week Back to Main Course Page