Integrating educational technology

Project description
Textbook required:
Roblyer, M.D., & Doering, A.H. (2013). Integrating educational technology into teaching. (6th ed.). Boston: Pearson.
Print version: ISBN 13: 978-0-13-261225-8 or ISBN 10: 0-13-261225-9.

Assignment 1 Unit 2: (750 words)
Software Grant Budget and Proposal
(This assignment fulfills these NETS-T, InTASC, and CCTC Standards)

SCENARIO: Your school has been awarded a Department of Education Enhancing Education through Technology grant. A portion of the grant money will go specifically to purchase instructional software. The teachers with the best grant proposals will receive $10,000 to purchase software for their classrooms.
The grant proposal must contain an Excel spreadsheet which lists the software and costs, a written proposal that explains what software would be purchased, why it was chosen and how it would enhance and support learning in your classroom.
________________________________________
Assignment Instructions
This is a two-part assignment:
You will use Microsoft Excel to create a budget spreadsheet for the software you want for your classroom within the $10,000 budget.
You will use Microsoft Word to write a 2 page software proposal that explains what software would be purchased, why it was chosen and how it would enhance and support learning in your classroom.
________________________________________
Compile a Software List
Using your textbook and online resources, compile a list of instructional software that you want for your classroom.
You must choose software from all three main categories below, but you dont have to choose software from all of the bullet-pointed sub-categories. Page numbers provide examples of the software types, but you may need to do online research to find more examples in each category.
1.Instructional Software (Chapter 3)
odrill & practice (p. 81)
otutorial (p. 86)
osimulations (p. 90)
oinstructional games (p. 94)
oproblem-solving (p. 99)
2.Basic Software Suites (Chapter 4)
oWord processors (p. 115)
oSpreadsheets (p. 122)
oPresentation (p. 128)
3.Beyond the Basics (Chapter 5)
oMaterials generators (p. 143)
oData collection and analysis tools (p. 152)
oGraphics tools (p. 157)
oPlanning and organizing tools (p. 160)
oResearch and reference tools (p. 161)
oContent-area tools (p 163)
________________________________________
Excel Spreadsheet
You will create an Excel spreadsheet budget that lists your chosen software, the vendor, the category of software (see items 1-3 above) and the prices.
If the software will be used on more than one computer in your classroom, the price should include one copy of the software and then site licenses for the other computers that will use it. Note that many software companies provide educational pricing.
List software by the main three categories and then by sub-category, so the type of software is evident. Subtotal the category sections.
Demonstrate the use of the SUM function to total rows or columns and section subtotals, and use the Multiply (product) function to multiply more than one of the same item (such as site licenses).
Insert lines in your spreadsheet (the gray gridlines will not print lines when the spreadsheet is printed out, so you have to add the lines).
________________________________________
Software Proposal
Use Microsoft Word to write a 2 page proposal in business letter format (https://owl.english.purdue.edu/owl/resource/653/01/) to your school principal that includes:
The list of chosen software and their categories
Explanation of why the software was chosen.
Explanation of how the software will enhance and support learning in the classroom. Include brief examples of learning activities that would use the software.
ISTE NETS-S for Students (NETS-S) standards that the software will enable your students to achieve. http://www.iste.org/docs/pdfs/20-14_ISTE_Standards-S_PDF.pdf
ISTE NETS-T for Teachers (NETS-T) standards that you will achieve by using the software for productivity or student learning. http://www.iste.org/docs/pdfs/20-14_ISTE_Standards-T_PDF.pdf

Assignment 2 Unit 2: (500 words)
Class Newsletter
(This assignment fulfills these NETS-T, InTASC, and CCTC Standards)

In this assignment, you will use a Microsoft Word newsletter template to create a class newsletter to your students parents. If you are not yet teaching, assume that you are teaching your preferred grade level.
Using the information from your grant proposal, you will write a 2 page newsletter that will contain the following information:
1.Announce that your classroom has won the $10,000 software grant.
2.List the software your classroom will get.
3.Explain how the software will enhance and support learning in the classroom. Include brief examples of learning activities that would use the software.
Explain which ISTE NETS-S for Students(NETS-S) standards that the software will enable your students to achieve. http://www.iste.org/docs/pdfs/20-14_ISTE_Standards-S_PDF.pdf
To access Microsoft Word’s template files, see the following tutorials. Remember that you must use a NEWSLETTER template of your choice.
How to Find Installed Templates in Word 2010

https://support.office.com/en-us/article/Video-Create-a-Word-2010-document-from-a-template-9d31bcb2-266c-4f67-a935-6c0233f6b438?ui=en-US&rs=en-US&ad=US

How to Find Installed Templates in Word 2007

http://office.microsoft.com/en-us/word-help/find-installed-templates-RZ010223218.aspx?section=5

http://www.iste.org/docs/pdfs/20-14_ISTE_Standards-S_PDF.pdf