1 / 28

COMPUTER TECHNIQUES for Teachers

COMPUTER TECHNIQUES for Teachers. Pablo Manalastas, PhD Dept of Info Systems & Computer Science Ateneo de Manila University pmana@admu.edu.ph. Computerized Class Record. One class record per section. Students’ names. Scores in quizzes, recitations, exams.

luella
Download Presentation

COMPUTER TECHNIQUES for Teachers

An Image/Link below is provided (as is) to download presentation Download Policy: Content on the Website is provided to you AS IS for your information and personal use and may not be sold / licensed / shared on other websites without getting consent from its author. Content is provided to you AS IS for your information and personal use only. Download presentation by click this link. While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server. During download, if you can't get a presentation, the file might be deleted by the publisher.

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

More Related