COMPUTER TECHNIQUES for Teachers

1 / 28

COMPUTER TECHNIQUES for Teachers - PowerPoint PPT Presentation

COMPUTER TECHNIQUES for Teachers. Pablo Manalastas, PhD Dept of Info Systems &amp; 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.

I am the owner, or an agent authorized to act on behalf of the owner, of the copyrighted work described.

PowerPoint Slideshow about 'COMPUTER TECHNIQUES for Teachers' - luella

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.While downloading, if for some reason you are not able to download a presentation, the publisher may have deleted the file from their server.

- - - - - - - - - - - - - - - - - - - - - - - - - - E N D - - - - - - - - - - - - - - - - - - - - - - - - - -
Presentation Transcript
COMPUTER TECHNIQUESfor Teachers
• Pablo Manalastas, PhDDept of Info Systems & Computer ScienceAteneo de Manila Universitypmana@admu.edu.ph
Computerized Class Record
• One class record per section.
• Students’ names.
• Scores in quizzes, recitations, exams.
• Miscellaneous notes and observations about each student.
• Each teacher can maintain own class record.
• Easy to maintain.
• Grade computation done by computer.
• Data can be exported to school-wide database.
Simple Average Computation
• TotalF2: =SUM(B2:E2)
• AverageG2: =F2/COUNT(B2:E2)
Weighted Average Computation
• TotalsF2: =SUM(B2:E2)F3: =\$B\$2*B3+\$C\$2*C3+\$D\$2*D3+\$E\$2*E3
• AverageG3: =F3/\$F\$2
Table Lookup Computations
• AverageD2 =AVERAGE(B2:C2)
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
• 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.
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
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)
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
• Information that you would like to be publicly known can be published through your personal webpage.
• Convenient, quick and economical method of distributing data.
What Can You Publishon Your Webpage?
• Teacher’s Resume.
• Your publications, writings, notes, etc.
Sample Web Page

<html>

<title>Sample Teacher’s Webpage</title>

<body>

<h2>Not for the weak of heart</h2>

<hr>

<p>While this sample page is quite trivial, it contains the most basic ingredients in a web page</p>

</body>

</html>

Lists

<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>

Tables