POINTERS TO REVIEW for COMPUTER 2

Pointers to Review

Lecture: ICT

Types of Network
Network Components
Network Categories

Internet
-History
-Functions
-Components
-Protocols
-Domain Names
-Free Internet Services

Lab: Ms Excel-Spreadsheet Application

History of Spreadsheet
MS-Excel Parts 03/07 Version
Ms Excel Functions
String Functions
-Proper
-Upper
-Lower
-Trim
Numerical Functions
-Sum
-Product
-Quotient
Statistical Functions
-min
-max
-average
Logical Functions
-If
Count Functions
-count
-counta
-countblank
-countif
Date and Time Functions
-Today ()
-Now()

www.vertex42.com For Free Excel Templates
www.techonthenet.com For reference on Excel Functions
http://www.top-windows-tutorials.com/#



Topics For Individual Performance Task (All Topics) Photo Essay Tutorials

1. PC Basics
2. XP Basics
3. Vista Basics
4. Working With Files
5. Make Your PC Faster
6. How to Beat Viruses
7. Smart Internet Surfing

Deadline of Submission of Individual Performance Task

Section 20-November 5
Section 21-November 4
Section 22-November 4
Section 23-November 5
Section 24-November 5

Schedule of Long Test and Practical Exam
Section 20-November 4 WEDNESDAY 8:00 - 9:30 AM HS LABORATORY
Section 21-October 27 TUESDAY Regular Double Period
Section 22-October 28 WEDNESDAY Regular Double Period
Section 23-November 6 FRIDAY 10:00-11:30 AM
Section 24-November 5 Thursday 10:00-11:30 AM

Photo Essay Tutorial Rubrics (Individual Performance Task)