1) c
2) control unit
3) b
4) 1024
5) a
---
1) a
2) RAM
3) d
4) nothing. it is a fossilized marine animal.
5) b
-----
1) b
2) b
3) 1023
4) graphical user interface
5) a
6) d
_____________
1) a
2) a
3) 210, or (n + 1) * (n/2) with n =20
4) a code of storing characters
5) c
6) a
------
1) b
2) a
3) 51 * 25
4) 16
5) c
6) b
----
1) you can seek for multiple values in cells
2) b
3) stealing bandwidth by referencing an image located on someone else's website
4) a
5) lets you see what cells this current cell relies on
6) chase-banking.com
----
New:
1) b
2) b
3) 3rd party cookies can be used to track your behavior and history on the web
4) d
5) c
6) d
7) b
8) a value in one table, corresponds to primary key of other table
9) c
Wednesday, May 18, 2011
list of homeworks
Homeworks:
HW: make a macro, any macro
HW: make a UDF, any UDF
defined here:
http://qccs12.blogspot.com/2011/04/ipmt-ppmt-find-out-is-lab-instructor.html
HW:
lecture book, review questions at end of ch 1
lecture book, exercises in ch 2
lecture book, review questions at end of ch 3
HW:
1) Convert these numbers to binary:
7
14
103
2) Convert these binary numbers to decimal:
11001
110
11
1101
3) Convert those numbers in part 2 to octal.
4) Convert those numbers in part 2 to hexadecimal.
HW: make a macro, any macro
HW: make a UDF, any UDF
defined here:
http://qccs12.blogspot.com/2011/04/ipmt-ppmt-find-out-is-lab-instructor.html
HW:
lecture book, review questions at end of ch 1
lecture book, exercises in ch 2
lecture book, review questions at end of ch 3
HW:
1) Convert these numbers to binary:
7
14
103
2) Convert these binary numbers to decimal:
11001
110
11
1101
3) Convert those numbers in part 2 to octal.
4) Convert those numbers in part 2 to hexadecimal.
Previous Quiz Questions
1) Convert this binary number to decimal:
10101
a) 19
b) 20
c) 21
d) 22
2) The CPU contains the ALU and the ________
3) Which of the following is an example of long-term memory?
a) CPU registers
b) CD-ROM
c) CD-RAM
d) RAM
4) One kilobyte = how many bytes?
5) Which will be faster, a compiled language or an interpreted language?
a) compiled
b) interpreted
c) same speed
d) neither, because there is no such thing
---------------
1) Convert this decimal number to binary:
25
a) 11001
b) 10001
c) 11011
d) 11000
2) The fetch-execute cycle fetches instructions from ________
3) Which of the following is an example of volatile memory?
a) hard disk drive
b) CD-ROM
c) CD-RAM
d) RAM
4) One trilobite = how many bytes?
5) C++ is an example of a
a) low-level language
b) high-level language
c) interpreted language
d) none of the above
---------------
1) The collection of HTML documents, linked together, across many countries is best called:
a) the Internet
b) the World Wide Web
c) the Intertubes
d) CSS
2) The HTML document you view on your web browser usually initially comes from
a) a web client
b) a web server
c) an http
d) Microsoft Word
3) Using the party trick I discussed in class, using your ten fingers, you could count up to:
______________
4) A GUI is _____________________________
5) A 256 color bitmap can store a pixel in how many bytes?
a) 1
b) 2
c) 3
b) 4
6) If I tried to solve the traveling salesman problem for 100 cities, using the algorithm I described,
and started it now, it would finish:
a) in one minute
b) in one hour
c) in one day
d) in more than a trillion years
--------------------
1) If I used my algorithm for traveling salesman for five cities, my program
would finish executing in:
a) less than an hour
b) a day
c) a year
d) more than a trillion years
2) A web page will typically be in the following format:
a) HTML
b) HTTP
c) FTP
d) DOC
3) The sum of the numbers 1 through 20 is:
______________
4) ASCII is:
5) Which is likely the smallest of images?
a) a BMP bitmap
b) a JPEG image
c) an SVG vector graphics image
6) If a collection of numbers are sorted, then I can use binary search
a) true
b) false
-------------------------------
1) The Internet is a synonym for the World Wide Web:
a) true
b) false
2) A web page will typically be in the following format:
a) HTML
b) HTTP
c) FTP
d) DOC
3) The sum of the numbers 1 through 50 is:
______________
4) A hexadecimal digit is in base: ________________
5) A "true-color" bitmap can store a pixel in how many bytes?
a) 1
b) 2
c) 3
b) 4
6) Linear search through a collection is faster than binary search, on average:
a) true
b) false
---------------------------
1) Give one way in which Solver is better than Goal seek.
2) If I want to figure out how much to deposit now in order to
retire with a million bucks, I would use the _______ function.
a) FV
b) PV
c) PMT
d) RATE
3) What is hotlinking?
4) Which of the following is a relative reference?
a) A1
b) $A$1
c) $A1
d) R1C1
5) What does the trace precedents tool do?
what is the domain?
----------------------------
New:
1) Which of the following is used for client-side scripting?
a) C++
b) JavaScript
c) Python
d) PHP
2) In CSS, the level which takes highest cascading precedence is:
a) internal
b) inline
c) external
d) web browser settings
3) Give one reason cookies are bad:
_______________________
4) In CSS, we can target:
a) a tag
b) a bunch of related items, by class
c) one individual item, by id
d) all of the above
5) Really, dates and times are stored in Excel and Access as:
a) text
b) dates
c) whole numbers and fractional numbers
d) none of the above
6) The following text will be matched by h??lo
a) hOOOLO
b) bkjlo
c) helo
d) hello
7) Descartes walked into a bar. When he turned down a drink:
a) he appeared
b) he disappeared
c) he reappeared
d) all of the above
8) A foreign key is: ______________________
9) A record is a collection of:
a) records
b) rows
c) fields
d) views
Monday, May 16, 2011
we did some simple PHP.
AJAX - asychronous JavaScript and XML
Web 2.0
ajax is really just the combination of JavaScript on the client side with e.g. PHP on the server side, communicating with each other asynchronously via XML
Open source software
http://en.wikipedia.org/wiki/Open-source_software
Linux -- a free, open source Operating System
OpenOffice - a free office clone
openoffice.org
talk next time briefly about google docs
AJAX - asychronous JavaScript and XML
Web 2.0
ajax is really just the combination of JavaScript on the client side with e.g. PHP on the server side, communicating with each other asynchronously via XML
Open source software
http://en.wikipedia.org/wiki/Open-source_software
Linux -- a free, open source Operating System
OpenOffice - a free office clone
openoffice.org
talk next time briefly about google docs
Wednesday, May 11, 2011
lecture
<html>
<head>
<link rel="stylesheet" type="text/css"
href="first.css" />
</head>
<body>
<p>This is all about my friends!</p>
<hr/>
<p>They are nice.</p>
</body>
</html>
for the web site, use an external style sheet on at least one web page.
client side scripting vs. server-side scripting
web server sends info to the web browser (which is the client)
Javascript -- carried out on the client's machine
javascript is event-driven.
as opposed to procedural-based programming.
Javascript can write cookies.
drawbacks of cookies.
stays only on that machine.
third-party cookies.
both site A and site B get their ads from site Z. site Z is the third party.
third-party cookies can be used to track users.
Amazon obviously does NOT use simple cookies to keep track of your order.
they use server-side scripting. examples of lanugages that support it: PHP, vbscript meaning ASP, ASPX.
often, hooked up to a database.
next up, AJAX.
<head>
<link rel="stylesheet" type="text/css"
href="first.css" />
</head>
<body>
<p>This is all about my friends!</p>
<hr/>
<p>They are nice.</p>
</body>
</html>
for the web site, use an external style sheet on at least one web page.
client side scripting vs. server-side scripting
web server sends info to the web browser (which is the client)
Javascript -- carried out on the client's machine
javascript is event-driven.
as opposed to procedural-based programming.
Javascript can write cookies.
drawbacks of cookies.
stays only on that machine.
third-party cookies.
both site A and site B get their ads from site Z. site Z is the third party.
third-party cookies can be used to track users.
Amazon obviously does NOT use simple cookies to keep track of your order.
they use server-side scripting. examples of lanugages that support it: PHP, vbscript meaning ASP, ASPX.
often, hooked up to a database.
next up, AJAX.
Monday, May 9, 2011
index.html is a special name
http://eniac.cs.qc.edu/~svitak/index.html
every folder has two special subfolders
help you navigate
one is called . (yourself)
the other is called .. (one level up)
the PATH is a list of folders to look in when trying to execute a program
<img src="./pictures/chicken-picture1.gif"
height="100" width="100"/>
http://www.w3schools.com/css/default.asp
we discussed CSS.
what does sytle mean?
what does cascading mean? how does it work.
The id Selector
proof:
0 = 1
0 + 1 = 1 + 1
1 = 2
clearly, the pope and i are two
therefore, the pope and i are one
therefore, i am the pope
we got to id and class selectors
<html>
<head>
<style type="text/css">
.argument
{
text-align:left;
color:green;
}
.summary
{
text-align:right;
color:red;
}
.center
{
text-align:center;
}
</style>
</head>
<body>
<h1 class="center">Center-aligned heading</h1>
<p class="center">Center-aligned paragraph.</p>
<p class="argument">
proof:</p>
<p class="argument">0 = 1</p>
<p class="argument">0 + 1 = 1 + 1
1 = 2
clearly, the pope and i are two
therefore, the pope and i are one
therefore, i am the pope</p>
<p class="summary">Proof by contradiction
</p>
</body>
</html>
http://eniac.cs.qc.edu/~svitak/index.html
every folder has two special subfolders
help you navigate
one is called . (yourself)
the other is called .. (one level up)
the PATH is a list of folders to look in when trying to execute a program
<img src="./pictures/chicken-picture1.gif"
height="100" width="100"/>
http://www.w3schools.com/css/default.asp
we discussed CSS.
what does sytle mean?
what does cascading mean? how does it work.
The id Selector
proof:
0 = 1
0 + 1 = 1 + 1
1 = 2
clearly, the pope and i are two
therefore, the pope and i are one
therefore, i am the pope
we got to id and class selectors
<html>
<head>
<style type="text/css">
.argument
{
text-align:left;
color:green;
}
.summary
{
text-align:right;
color:red;
}
.center
{
text-align:center;
}
</style>
</head>
<body>
<h1 class="center">Center-aligned heading</h1>
<p class="center">Center-aligned paragraph.</p>
<p class="argument">
proof:</p>
<p class="argument">0 = 1</p>
<p class="argument">0 + 1 = 1 + 1
1 = 2
clearly, the pope and i are two
therefore, the pope and i are one
therefore, i am the pope</p>
<p class="summary">Proof by contradiction
</p>
</body>
</html>
Wednesday, May 4, 2011
dates / times are stored in Excel and Access as serial numbers.
date and time arithmetic
SELECT Book.Title, Book.PublDate, Book.Copyright, Author.LastName, Publisher.PubName, Date()-60 AS Expr1
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE Book.PublDate>Date()-60;
we want:
SELECT Book.Title, Book.PublDate, Book.Copyright, Author.LastName, Publisher.PubName, Date()-60 AS Expr1
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE (((Book.PublDate) Between Date()-60 And Date()));
SELECT Book.Title, Book.EDITION, Author.LastName, Publisher.PubName
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE (((Book.EDITION) Is Null));
more about wildcards
* match anything, including nothing
? match exactly one character
begins with G
G*
turned it into
Like "G*"
where the title contains Excel
*Excel*
date and time arithmetic
SELECT Book.Title, Book.PublDate, Book.Copyright, Author.LastName, Publisher.PubName, Date()-60 AS Expr1
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE Book.PublDate>Date()-60;
we want:
SELECT Book.Title, Book.PublDate, Book.Copyright, Author.LastName, Publisher.PubName, Date()-60 AS Expr1
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE (((Book.PublDate) Between Date()-60 And Date()));
SELECT Book.Title, Book.EDITION, Author.LastName, Publisher.PubName
FROM Publisher INNER JOIN (Author INNER JOIN Book ON Author.[AuthorID] = Book.[AuthorCode]) ON Publisher.[PUBID] = Book.[PubID]
WHERE (((Book.EDITION) Is Null));
more about wildcards
* match anything, including nothing
? match exactly one character
begins with G
G*
turned it into
Like "G*"
where the title contains Excel
*Excel*
Monday, May 2, 2011
relational databases
two problems with non-relational, non-normalized databases.
primary key: field that uniquely identifies a record
foreign key: points to the primary key of a different (thus foreign) table
SQL statement:
SELECT Customers.First, Customers.Last, ItemDescription From Customers, Orders
will give me the Cartesian product of the two tables
SELECT Customers.First, Customers.Last, ItemDescription From Customers, Orders
WHERE Customers.CusId = Orders.CusID
called an INNER JOIN ON Customers.CusId = Orders.CusID
two problems with non-relational, non-normalized databases.
primary key: field that uniquely identifies a record
foreign key: points to the primary key of a different (thus foreign) table
SQL statement:
SELECT Customers.First, Customers.Last, ItemDescription From Customers, Orders
will give me the Cartesian product of the two tables
SELECT Customers.First, Customers.Last, ItemDescription From Customers, Orders
WHERE Customers.CusId = Orders.CusID
called an INNER JOIN ON Customers.CusId = Orders.CusID
Subscribe to:
Posts (Atom)