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

Loading in 2 Seconds...

play fullscreen
1 / 28

COMPUTER TECHNIQUES for Teachers - PowerPoint PPT Presentation

  • Uploaded on

COMPUTER TECHNIQUES for Teachers. Pablo Manalastas, PhD Dept of Info Systems & Computer Science Ateneo de Manila University 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.
Download Presentation

PowerPoint Slideshow about 'COMPUTER TECHNIQUES for Teachers' - luella

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.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 techniques for teachers
  • Pablo Manalastas, PhDDept of Info Systems & Computer ScienceAteneo de Manila
computerized class record
Computerized Class Record
  • One class record per section.
  • Students’ names.
  • Scores in quizzes, recitations, exams.
  • Miscellaneous notes and observations about each student.
  • Grade computation.
advantages of computerized class record
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.
simple average computation
Simple Average Computation
  • TotalF2: =SUM(B2:E2)
  • AverageG2: =F2/COUNT(B2:E2)
weighted average computation
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
Table Lookup Computations
  • AverageD2 =AVERAGE(B2:C2)
  • Letter GradeE2 =VLOOKUP(D2,$G$2:$H$8,2)
root guessing in algebra
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
advantages of root guessing using excel
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.
formulas for half interval search
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 guessing newton raphson method
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 for newton raphson method
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
creating your own webpage
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.
what can you publish on your webpage
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.
sample web page
Sample Web Page



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



<h1>Pablo’s Home Page</h1>

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

<h3>This site contains adult material</h3>


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




<html><head><title>Sample List</title></head>

<body><h1>My Christmas List</h1>


<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



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