# COMPUTER TECHNIQUES for Teachers - PowerPoint PPT Presentation

COMPUTER TECHNIQUES for Teachers

1 / 28
COMPUTER TECHNIQUES for Teachers

## COMPUTER TECHNIQUES for Teachers

- - - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - - -
##### Presentation Transcript

1. COMPUTER TECHNIQUESfor Teachers • Pablo Manalastas, PhDDept of Info Systems & Computer ScienceAteneo de Manila Universitypmana@admu.edu.ph

2. Computerized Class Record • One class record per section. • Students’ names. • Scores in quizzes, recitations, exams. • Miscellaneous notes and observations about each student. • Grade computation.

3. Advantages of ComputerizedClass Record • Each teacher can maintain own class record. • Easy to maintain. • Grade computation done by computer. • Data can be exported to school-wide database.

4. Sample Class RecordSimple Average

5. Simple Average Computation • TotalF2: =SUM(B2:E2) • AverageG2: =F2/COUNT(B2:E2)

6. Sample Class RecordWeighted Average

7. Weighted Average Computation • TotalsF2: =SUM(B2:E2)F3: =\$B\$2*B3+\$C\$2*C3+\$D\$2*D3+\$E\$2*E3 • AverageG3: =F3/\$F\$2

9. Table Lookup Computations • AverageD2 =AVERAGE(B2:C2) • Letter GradeE2 =VLOOKUP(D2,\$G\$2:\$H\$8,2)

10. Root Guessing in Algebra • Linear and quadratic equations are easy to solve manually. • Equations of degree three or higher are difficult to solve. • Example: find roots ofx^4 +x^3 –x^2 –3x –6= 0

11. Advantages of Root GuessingUsing Excel • Unlike manual computations, Excel computations are easy and without errors. • Many guesses can be quickly tried and either accepted or discarded. • Even difficult problems become easy.

12. Root GuessingHalf-Interval Search

13. Formulas forHalf-Interval Search • Midpoint GuessB5: =(B4+B6)/2 • Function ValuesF(X)=X^4 + X^3 - X^2 - 3X – 6 =(((X+1)*X-1)*X-3)*X –6C4: =(((B4+1)*B4-1)*B4-3)*B4-6

14. Root GuessingNewton Raphson Method • Objective:Solve the equation f(x) = 0 • Get formula for derivative f ‘(x) • Make initial guess x0 • Compute next guessx1 = x0 – f(x0) / f ‘ (x0)

15. Root GuessingNewton Raphson Method

16. Formulas forNewton Raphson Method • Function valueF(X)=X^4 + X^3 – X^2 – 3X – 6 =(((X+1)*X-1)*X-3)*X-6C4: =(((B4+1)*B4-1)*B4-3)*B4-6 • DerivativeF’(X)=4X^3 + 3X^2 – 2X – 3D4: =((4*B4+3)*B4-2)*B4-3 • Second GuessB5: =B4 – C4/D4

17. Creating Your OwnWebpage • Information that you would like to be publicly known can be published through your personal webpage. • Convenient, quick and economical method of distributing data.

18. What Can You Publishon Your Webpage? • Teacher’s Resume. • Stuff for your students: assignments, extra readings, review questions, grade reports, etc. • Your publications, writings, notes, etc.

19. Sample Web Page <html> <head> <title>Sample Teacher’s Webpage</title> </head> <body> <h1>Pablo’s Home Page</h1> <h2>Not for the weak of heart</h2> <h3>This site contains adult material</h3> <hr> <p>While this sample page is quite trivial, it contains the most basic ingredients in a web page</p> </body> </html>

20. Sample Webpage Display

21. Lists <html><head><title>Sample List</title></head> <body><h1>My Christmas List</h1> <ul> <li>New house at Forbes Park <li>Mercedes Benz SLK 180 <li>Sony Digital Camera 4.1M pixels <li>Nokia 9850 Mobile Phone <li>Angelina Jones </ul> </body></html>

22. List Display