COMPUTER TECHNIQUES for Teachers - PowerPoint PPT Presentation

computer techniques for teachers n.
Download
Skip this Video
Loading SlideShow in 5 Seconds..
COMPUTER TECHNIQUES for Teachers PowerPoint Presentation
Download Presentation
COMPUTER TECHNIQUES for Teachers

play fullscreen
1 / 28
COMPUTER TECHNIQUES for Teachers
87 Views
Download Presentation
luella
Download Presentation

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

  8. Grade EquivalentTable Lookup

  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

  23. Tables • <html><head><title>Sample Table</title></head><body><h1>Table of Items to Buy</h1><table><tr><td><b>Description</b></td><td><b>No</b></td><td><b>Unit Price</b></td></tr><tr><td>Blue jeans</td><td>2</td><td>1200.00</td></tr><tr><td>Polo shirt</td><td>2</td><td>800.00</td></tr><tr><td>Leather shoes</td><td>1</td><td>1500.00</td></tr><tr><td>Unmentionables</td><td>4</td><td>200.00</td></tr><tr><td>Bath accessories</td><td>1</td><td>80.00</td></tr></table></body></html>

  24. Table Display

  25. Frames • <html><head><title>Nested Frames</title></head><frameset cols="40%,*"> <frameset rows="50%,*"> <frame src="frame1.html"> <frame src="frame1.html"> </frameset> <frameset rows="20%,40%,*"> <frame src="frame1.html"> <frame src="frame1.html"> <frame src="frame1.html"> </frameset></frameset></html>

  26. Frames Display

  27. Forms • <html><head><title>Sample Form</title></head><body><h1>Sample Survey Form</h1><p>Please enter your personal data</p><hr><form action="mailto:pmana@localhost" method="post"> Your name: <input type="text" name="name" size=30 maxlength=80><br><br> Sex: <input type=radio name=sex value="male">male <input type=radio name=sex value="female"> female<br><br> Currently enrolled? <input type=checkbox name=enrolled value="off"><br><br> <input type=submit value="submit form"></form><hr></body></html>

  28. Form Display