Senior III "A" ICT - 2009

Next Friday November 20th Test

2009-11-16T02:59:00.000-08:00

Please, remember, next friday November 20th test.
Visual Basic and Excel.

The contents are the same of the work done in class during the last weeks.

Here is the link.

http://docs.google.com/Doc?docid=0Ab4BbyC37KqPZGdtdDY3ajdfMTNkNDVydGI&hl=es

Any questions, come and ask.

Remember, study....

Califications up to now

2009-09-03T09:38:00.000-07:00

Blog desing

2009-09-03T09:04:00.000-07:00

Sing in using Weblog or Blogspot
Remember to keep you username, project name and password.

Blog contents
Main title: Keeping data secure

1. What is data?
2. What is meant by:
3. Security of data
4. Data Integrity
5. Privacy of data

6. What is meant by Physical security?
7. What is Software security?

8. What are the most common security procedures?

9. What is a firewall?
10. In virus detection, what are the most common policies.

11. What are encryption messages?

12. What is a backup?

13. What are the most common ways to keep or maintain integrity of data?

14. What are individual rights referring to computers.

Mail para consultas

2009-07-03T11:50:00.001-07:00

Para cualquier consulta enviar mail a
vdssenioriii@gmail.com

Some questions to answer

2009-07-03T10:18:00.000-07:00

Here you have some theoric questions.

and here is the database

Questions to answer

2009-07-03T05:01:00.001-07:00

Database for exercises.

SQL language

2009-06-11T05:51:00.000-07:00

Read this:
SEÑOR III A
RELATIONAL DATABASE SQL LANGUAGE
GROUP:

What is SQL?
SQL (pronounced "ess-que-el") stands for Structured Query Language. SQL is used to communicate with a database. According to ANSI (American National Standards Institute), it is the standard language for relational database management systems. SQL statements are used to perform tasks such as update data on a database, or retrieve data from a database. Some common relational database management systems that use SQL are: Oracle, Sybase, Microsoft SQL Server, Access, Ingres, etc. Although most database systems use SQL, most of them also have their own additional proprietary extensions that are usually only used on their system. However, the standard SQL commands such as "Select", "Insert", "Update", "Delete", "Create", and "Drop" can be used to accomplish almost everything that one needs to do with a database. This tutorial will provide you with the instruction on the basics of each of these commands as well as allow you to put them to practice using the SQL Interpreter.
Table Basics
Weather
city state high low
Phoenix Arizona 105 90
Tucson Arizona 101 92
Flagstaff Arizona 88 69
San Diego California 77 60
Albuquerque New Mexico 80 72

A relational database system contains one or more objects called tables. The data or information for the database are stored in these tables. Tables are uniquely identified by their names and are comprised of columns and rows. Columns contain the column name, data type, and any other attributes for the column. Rows contain the records or data for the columns. Here is a sample table called "weather".
city, state, high, and low are the columns. The rows contain the data for this table:

Selecting Data
The select statement is used to query the database and retrieve selected data that match the criteria that you specify. Here is the format of a simple select statement:
select "column1"
[,"column2",etc]
from "tablename"
[where "condition"];
[] = optional
The column names that follow the select keyword determine which columns will be returned in the results. You can select as many column names that you'd like, or you can use a "*" to select all columns.
The table name that follows the keyword from specifies the table that will be queried to retrieve the desired results.
The where clause (optional) specifies which data values or rows will be returned or displayed, based on the criteria described after the keyword where.
Conditional selections used in the where clause:
= Equal
> Greater than
< Less than
>= Greater than or equal
<= Less than or equal
<> Not equal to
LIKE *See note below
The LIKE pattern matching operator can also be used in the conditional selection of the where clause. Like is a very powerful operator that allows you to select only rows that are "like" what you specify. The percent sign "%" can be used as a wild card to match any possible character that might appear before or after the characters specified. For example:
select first, last, city
from empinfo
where first LIKE 'Er%';
This SQL statement will match any first names that start with 'Er'. Strings must be in single quotes.
Or you can specify,
select first, last
from empinfo
where last LIKE '%s';
This statement will match any last names that end in a 's'.
select * from empinfo
where first = 'Eric';
This will only select rows where the first name equals 'Eric' exactly.
Sample Table: empinfo
first last id age city state
John Jones 99980 45 Payson Arizona
Mary Jones 99982 25 Payson Arizona
Eric Edwards 88232 32 San Diego California
Mary Ann Edwards 88233 32 Phoenix Arizona
Ginger Howell 98002 42 Cottonwood Arizona
Sebastian Smith 92001 23 Gila Bend Arizona
Gus Gray 22322 35 Bagdad Arizona
Mary Ann May 32326 52 Tucson Arizona
Erica Williams 32327 60 Show Low Arizona
Leroy Brown 32380 22 Pinetop Arizona
Elroy Cleaver 32382 22 Globe Arizona
Enter the following sample select statements in the SQL Interpreter Form at the bottom of this page. Before you press "submit", write down your expected results. Press "submit", and compare the results.
select first, last, city from empinfo;

select last, city, age from empinfo
where age > 30;

select first, last, city, state from empinfo
where first LIKE 'J%';

select * from empinfo;

select first, last, from empinfo
where last LIKE '%s';

select first, last, age from empinfo
where last LIKE '%illia%';

select * from empinfo where first = 'Eric';

Select statement exercises
Enter select statements to:
1. Display the first name and age for everyone that's in the table.
2. Display the first name, last name, and city for everyone that's not from Payson.
3. Display all columns for everyone that is over 40 years old.
4. Display the first and last names for everyone whose last name ends in an "ay".
5. Display all columns for everyone whose first name equals "Mary".
6. Display all columns for everyone whose first name contains "Mary".

Data Manipulation Work

2009-05-22T06:30:00.001-07:00

Download the following file.

http://www.4shared.com/file/107038509/fb3aa2ad/KUROKI.html

Work for note

2009-05-15T12:14:00.001-07:00

1. 7
2. 7
3. 10
4. 10
5. 7
6. 9
7. 9
8. 9
9. 4
10. 7
11. 10
12. 10
13. 10
14. 8
15. 9
16. 4
17. 10

Friday May 8th

2009-05-11T10:06:00.000-07:00

Today´s work.

Create your own spreadsheet.
Write the purpose of your spreadsheet (problem that solves)
Cell types to be used: Text, Integer, Money, Date
Functions to be used: Esblanco(), Si(), elegir(), Aleatorio.entre(), Contar, Contar.Si, Sumar, Sumar.Si, Frecuencia(), BuscarV
You must use at least 2 graphs.

Remember: Put Header and Footer (Name, computer number, Senior IIIA)

On friday 22nd Spreadsheet Test

Unit 1 Test

2009-04-17T09:47:00.000-07:00

Califications

1. 8.5
2. 9.5
3. 9.5
4. 9.5
5. 7.5
6. 8.5
7. 7.5
8. 10
9. 9
10. 9.5
11. 10
12. 7
13. 7.5
14. 9.5
15. 7
16. 10
17. 9.5

Exercise 3 Spreadsheet

2009-04-16T12:05:00.000-07:00

This are the instructionsyou are going to use and here is the link to the spreadsheet.

Friday april 3rd

2009-04-06T07:06:00.000-07:00

We worked with Unit 1 Hardware, Software and Devices.
Make a PowerPoint Presentation.

Test date using these material.

File Link available at:

Unit Schemes to work

Word 2nd work

2009-03-26T10:55:00.000-07:00

Instructions

Mouse image

Cabinet image

Document to download Personal computer hardware

Word Document

2009-03-26T04:59:00.001-07:00

Download document

Information Technology 1st class

2009-03-26T04:58:00.001-07:00

Today we worked in a Diagnosis Exercise.

Exercise 1

2009-03-23T03:51:00.001-07:00

About our bibliography...

2009-03-19T03:51:00.000-07:00

Title: IGCSE and O Level - Computer Studies and Information Technology
Author: Chris Leadbetter and Stewart Wainwright
Cambridge University Press
ISBN 9 780521 545402
We need the book on 17 April.