CIS 700 Master Quiz
Prof. Auciello's Virtual Classroom Quiz
Runs best using Internet Explorer
Q001: My Computer
"My Computer" is another name for Windows Explorer that
is a file manager that can rename, delete, cut, copy, paste, print, open, etc
file and folders. It evolved from winfile.exe to Windows Explorer (explorer.exe)
to My Computer. I wanted to know more about "My
Computer" so I "google" and searched for "My Computer", and came up
with an amazing number of "hits".
1. How many hits do you come up with when
searching for "My Computer"? 2. Briefly
describe how you searched.
3. Why should you put My Computer in quotes?
Answer each one in the form of 1. xxxxx,
etc. If you don't know the answer just type "will discover
later."
|
Q002: Researching Information on "My Computer" using the
Help Files on my Desktop
In the previous question, we went to the Web for info, now we
will search our Desktop (our workstation) for info. I found
the button for "Help and Support" and typed in "My Computer" and
found an important but light summary. Find any description of
"My Computer" and type it in the box below. (Not more than 1
paragraph.)
|
|
Q003: "Exploring" My Computer
The
word "Exploring" is an attempt at humor, referring to My Computer's roots.
Click "My Computer" button,
then click "Views" -- the button on top, to see the (5) different optional
way of viewing.
Write just 1 or sentences each explaining what you see in Thumbnails
View, and in Details View. Try the other (3).
|
|
Q004: Showing Folders and Files
A while back I was searching for "explorer.exe" and I found it,
and made it into a shortcut on my Desktop. While playing
(hacking) with it, it generated this screen. This is a classic
Windows Layout Screen. Clicking the + will expand and show the
contents of, and clicking a Folder will reveal its contents.

Study
the screen above: 1. What drive are we looking at? 2. Give
me the name of a folder. 3. Give me the name of a movie file. 4.
Name of a image file (picture). 5. Name of a sound file. 6.
Where have you seen such a layout before?
|
|
Q005: Icons on the Standard "My Computer" Toolbar.

The Standard Toolbar contains (2) rows. On the 2nd row, there are
icons. Icons that are lit are "hot" and will operate when clicked.
There are (7) active icons. Hover the mouse over each of the
1st 6 and type in what each stands for.
(This kind of stuff can be boring -- If you already know it, just write
"I got it already, Mr. A." and skip it; Also understand that some
students may need the practice on this, so encourage them, and soon they
too will have this down.)
|
|
Q006: Sorting by File and Folder Attributes
Listed are (4) properties or attributes of files and folders:
Name, Size, Type, and Date Modified. Clicking on Name will
sort the name in Alphabetical Order (ascending). Clicking it again
will sort in descending order.

1. Sort your names in descending order. What is the first name to
appear?
2. I 'discovered" that I had a 26 MB (26,000 KB) file for
Partition Data. What is the largest file you found? Name and
Size.
3. Give me the name of an application files that you found.
|
|
Q007: Status Bar
 The
Status Bar, at bottom of desktop shown at the right, describes what
is occurring. Why it's called "Status Bar", of course.
I enabled the Status Bar by clicking View then
clicking Status Bar as shown on the left.
Enable the Status Bar, and describe your steps, please.
|
|
Q008: ADDRESS BAR

Look above and note the Address Bar. This is awesome! because it
means that I can type in the address where I want to go! I
maximized the screen. I just discovered this feature, and I
just tested it by typing in my website address (
http://auciello.tripod.com ) and
-- guess what? -- it worked! By hacking around, I taught
myself this important feature that I can share with you, so you could type
in any WEB address (or URL) to access it. or type in a
File Name like C:\7966\HB7.GIF
to access a file on your desktop. Locally or on the Web!
To say this another way: My Computer is a superset of
Desktop Explorer which is a File Manager supreme! which shares common
features with its twin, Internet Explorer, in that it also can
access the web! So, properly configured, you could run
everything from My Computer: from accessing programs, viewing
images, playing music, watching video either on the Desktop or on the Web.
Microsoft has "seamlessly" integrated running applications locally or from
the Internet. I could stay in My Computer all day long, and do all
my tasks -- copying, pasting, renaming, deleting, etc locally --
while accessing the webpages, and reading my email!
Please configure My Computer thus, by
clicking View-Toolbars-Address Bar, then maximizing your screen. Make it
look like the screen above. The try it out.
Describe the steps that you took:
|
|
Q009: My Computer as a Desktop Manager!

Use My Computer to access a screen like the one above. Click on
any icon once (to highlight it). A 2nd left click will "run" it, and
a Right Click will open up an Options Menu which has a number of features
such as -- copy, paste, delete, ____. Write down all the
actions that you can do to a file or folder, starting with 'executing'
(running) it. Here is a screen shot from a famous classic File
Manager, XTree, that you can use for clues:

Add Search, View, Edit, Zip, Unzip, Execute, and Sort.
Right-click on any icon. List below the functions that you could
perform on that file, separated by commas, for example: Copy,
Paste, _____.
(This just added a powerful tool in your skill set!)
|
|
Q010: Customizing the Display Features

Note that this display lists (5) features (properties) of a
file/folder: Name, Size, Type, Date Mod., Attributes.
I
added the show Attribute feature with this screen. How did I get to
this screen? It is a bit tricky, but try it. If you fail, I or
someone will show you, and just write below: "Mr. A. Please
show me how to do this." If you can do it, describe the steps
you took:
|
|
This is the MASTER
ASSIGNMENT LIST. Refer to it. Follow it. If you hit a project
too hard, wait a while until your classmates have done it, and explained
their technique in "701 MASTER HELP" https://auciello.tripod.com/701mashel.htm.txt
Questions: (1) How else besides the projects
on 'GRADE.DOC' can you earn points? (2)
How can you use this form for help? State exactly how to do
it. (3) I will reward the "front runners" with Letters of
Recommendation -- If we all help each other in this way, is this
approaching a "Virtual Learning Community"?
|
|
Q012: Getting points from the Master Help Form.
701mashel.htm
To help you along,
I am now giving points like this -- 25t (for Mandatory Attendance-Checking
In on Mon-Thurs) + 25mhx (where mhx designates an item on this form) +
25JA (helping a student with initials of JA) + 100xxx (xxx = name of
project, like MAP).
Questions: Explain these
lines:
0124,Young,Paul,03,07,08,650.(50
pvc-doc),hu17floor@aol.net 0124,Young,Paul,03,07,09,800.(50
pvc-doc+100mh1-4),hu17floor@aol.net 0124,Young,Paul,03,07,10,875.(75
mh5-7),hu17floor@aol.net
How many questions
on the Master Help Form did Paul Young answer? What are the numbers of the
Questions? What does "mh" stand for? Is this a sneaky way for
Mr. A. to get you to use this form and get information from your
peers? Can you learn from your
classmates?
|
|
This page has two
key principles: Movement and Color. Images and Text are
scrolling (click on any image on top to see their home page), and it is
color-coded with the "701" info in Yellow.
Look at the page now. Is it Page 1 or
Page 2? How do you get to Page 2? What color is the "ALL"
category? What color column is the email assignment in? How many points for submitting your email address?
What is the name and the html name of the Introductory Quiz? Why are
the Word Quiz 01 and Excel Quiz 02 worth 250 points? (No one in this class
has yet passed them yet with an 80 or above -- show me what you
know). Is the Space Science Test something that I co-developed with
Dr. Moreno? Name 3 links that are in the CIS 701 Topics
Column? What is the number of my Web Design
course?
|
|
What page number is
this? Does it have the same color coding as teh 1st Page? Do you like the
"light cream background? It takes a long time to load, (almost
impossible at 56K modem speeds) because it uses Java Applets, short Java
Programs that each have to individually load that it uses for the "hover"
buttons. If you can't load it, just pop in the CD and get it. The CD
contains the web site. Are the same programs that are on the web
site also on the CD? Why does the CD load faster? Take
"Required Quiz #1" if you think you need it for 50 points. How many pages
is 701-GLOSS? What is it about? Explain what you think the "Final
Projects" are?
|
|
Q015: Page 2 (continued)
Note "701 Quiz 01"
click it. It covers much the same material. Take it if you like for
50 points. How many points does it say on the page? Click "701 Quiz
01a" -- What is the subject of this quiz? Click https://auciello.tripod.com/14tqm.html
and see the version with cartoons! The "701 Quizzes" are called "Web
Quizzes". How many 701 Quizzes are there? Do they help you
learn? The "Check-in" projects are also a kind of a help file.
How many "Check-in" DE Students lessons are there? Take these for 50
points each if you need to.
|
|
Name (2)
point-generating projects in the "ALL" column. Check out "Interview with
God", an insightful link sent by my daughter. She also sent
"Courtroom Humor" to me years ago. Check out all the links in this
column -- which ones do you like best? Check out "757 Slide Show"
and Cindy Liu's Home Page http://clovejoe.tripod.com/ Which
do you like best? Why? OK. enough "Prep" time. Let's start the
projects! Go!
|
|
Download the above
link. Understand the page numbers and how it folds. Figure out how
to print on both sides. Understand that this is just a Table.
pg 5 |
|
pg 6 |
|
pg 1 |
pg 2 |
|
pg 3 |
|
pg 4 |
The 1st Row = 1st
Page. The smaller columns are at the seams of the folds. A good
Brochure communicates a message with High-Visual-Impact, with images and
text reinforcing each other! It takes about 3 pages of text and
images, so find a website, download and save about 3 pages of info to a
WORD document. Plan your brochure, and working one column at-at-time,
build it, saving as your go! Please describe below, step by step,
exactly how you built your brochure, so that you can teach others.
50ec-3f pts for doing this.
1003f -- for printing it out.
4003f -- for customizing it, producing a World Class Presentation Quality
"Work of Art" in color, that communicates a 'themed' message effectively
using color, text, Word Art, and images!
503f -- for writing a 'step-by-step' description of how to create this
brochure.
|
|
CR3 is a 200-point project needs to be
printed out, and all the questions answered in pen. Some questions
have been answered. Answer them yourself anyway. Sign it, and
put in Project Notebook, which is turned in for a Final Grade the last
week of class. Explain how you did this project.
|
|
THIS IS SO
IMPORTANT: TO WORK EFFECTIVELY IN TODAY'S BUSINESS-HI-TECH
ENVIRONMENT, ONE HAS TO PRESENT HIM/HERSELF DIGITALLY!
Business Cards with pictures, logos, email,
web addresses, cell #, street
addresses, etc. helps to define you! This is the only way to
work in today's world, and is something that I feel strongly about
teaching you!
I put
the format of 10 business cards in a WORD by making a table of 2 columns
and 5 rows (3" * 2.5"). The technique is to work on, say,
the upper left cell, inserting an image (learn to wrap text around image),
and
text info, artistically and clearly communicating. Then copy
that cell to the next column, then copy the entire row to the next row,
and so on. Putting this on glossy photo paper really takes this
"up a notch".
My TA's, Herlin Guerra
and Oswaldo Razo,
took this even further by making the cards in Portrait Mode, and adding a
colorful- watermarked background. This became "World
Class"! https://auciello.tripod.com/buscard3.doc Please
describe the steps you took in creating Business Cards, with
attention to any "special" techniques that you
took! Be Well. JA. Out.
|
|
Q020: Greeting Card Project. pages 4 & 1 pages 2 & 3

First of all -- If you "get" that the Spanish is "Fractured", give
yourself 10 points. Second -- this is not the best card, most of my
students have created cards that put mine to shame, but makes me proud of
them! To do this assignment, and I am trying so hard here to put
lessons OnLine for your, take a piece of paper, hold it landscape,
like above, and mark it 4, 1 on the outside, and 2, 3 on the inside.
Make sure that when you open it, you see 4, 1 outside, and 2, 3 on the
inside. Then understand that this is a table, with almost invisible
margins. (Pages 2, 3, are showing, right?). Put
text and images (insert Clipart) on these pages.
Showing outside pages (4, 1)
TAKE A MINUTE AT THIS POINT TO ENSURE THAT YOU UNDERSTAND THE
NUMBER OF EACH PAGE.
LET ME ADD SOME "SMACK" HERE -- I AM FINDING OUT THAT HAVING GOOD
RELATIONSHIPS, MADE BETTER BY AFFIRMING THEM, MAKES LIFE EASIER,
AND INCREASES YOUR SUCCESS. SO MAKE LOTS OF GREETING
CARDS.
50 POINTS FOR EACH PAGE. DO IT IN B+W FIRST, THEN EXTRA 100 IN
COLOR. PLS EXPLAIN, IN DETAIL, BELOW, EXACTLY, THE STEPS YOU
TOOK TO DO THIS PROJECT:
Download the card format from the links
above.
Question:
What are the steps to create the Greeting Card?
==============================================
Q021: Lakers Statistical Project
Steps are: (1) get Lakers Stats use Google or other search engine
(100 pts). (2) Open Excel. (3) Highlight Stats,
(4) Paste them to an Excel Sheet. (5) Sort by FG%. (6)
Format sheet like #5 below (100 pts). (7) Using Chart
Wizard, make a bar graph. (8) Copy and Paste (C and P) graph to
Paint where you make the "Team Average" line using the line tool, and the
words "Team Average" using the Text Tool. (9) C and P it to
WORD, where you center it, and add text to the bottom, and print it.
(200 pts). (400 pts total). Then of course enter it in the
ATT/PART form as 400LAKERS. This project will develop
some excellent computer skills! JA.
This is written as the Playoffs begin in April 2004. The goal
here is to develop Desktop Visual Information skills.
(1-3) I expect you to be able to find "Stats" on the Official
Lakers Web Site, then please highlight them as a "block of data"
. a rectangle. From "Player" upper left to the entry in the bottom
rights. If you can't find them, click http://www.nba.com/lakers/stats/2003/index.html
Extra credit (50): How did I find this link?
4) Paste it to Excel, corner A1.

(5) Check it out! The data is not sorted. What an impending
disaster. How could you make a clear graph unless the data is
organized? How could you visually represent data clearly unless it
first is organized? We have to "SORT" the data.
Note that the data is
sorted below. To sort, click "Data", and try to figure it out
/ "hack" it by following the prompts and your imagination and
intuition. (These programs are engineered to for you to use logic
and intuition. ) If you are stuck, come see me .
(6) Formatting the Sheet. Click the "Select All" cell in the
corner. With the "Format" toolbar enabled, ("fill color" with white,
then "Format Cells" put cell borders. Then use "Cell Alignment" to
align the column headers as shown above (5):
(7) Making a Bar Graph: The best method is to click on the
Chart Wizard (CW). But what if your Excel Program does not
have this button or icon showing on the Toolbar? So, now you
have to do some 'discovery' or 'hacking' .... There are toolbars at the
top of the screen. They are accessible through the View Tab on the
File Toolbar, the top toolbar. Go "Hack" at it. Turn
various Toolbars on and off, to help you understand them.
Usually, the Chart Wizard button comes on as part of the Standard
Toolbar. The first time it didn't for me; but by turning it off and
on, it appeared on my Standard Toolbar. CW is a tool on the
Standard Toolbar. Hack away until it appears by enabling / disabling
Toolbars thru the View Tab (right after File, Edit).

The trick is to highlight the data columns, by
dragging the mouse over each one while holding the "Ctrl" key down,
allowing multiple highlighting.
Repeat after me ... "Select the Player and his
corresponding FG% by dragging carefully down each column while holding the
Ctrl Key down!" (This is how to get data in non-adjacent
columns into the CW. If you are worrried, that the FG% for Shaq is
not highlighted, kudo yourself. It actually is, but does not
show it. Also, note col "F", FG%, is sorted in descending
order.
Follow the prompts from the CW until you
have a graph that looks like this. Each graph has its own
"areas" or sub-sections such as: Chart area, category, legend,
title, etc that can be accessed and modified by right-clicking (r-c) on
them. For example to modify the Category Area, r-c on it,
Format Axis, etc to achieve the alignment of the names. Hack it.
(8 - 9). The final product -- on a World
Class Presentation Quality Level befitting the Lakers -- has the Chart
Area filled with color, the Name Category aligned at 45%, is
elongated along the height dimension to make the differences in the FG%
more distinct, and using 'Paint' the Team Average Line and Caption are
inserted. C and P this image to Paint, where the
Team Average (find this number) is drawn by the line tool, and its caption
is written using the Text Tool, then save it.
Finally, insert this image to WORD where you center it, and add text
to the bottom. Print it out. Log 400 points on the A/P
form, 400LAKERS. ... Additional notes from Prof.
A.: This document vividly communicates! Pictures are
worth 1000 words: Enhanced pictures speak thousands of words!
This is truly a World-Class assignment, a vital tool to have in your skill
set portfolio. Make this happen. Put in your notebook
for me to see! JA. Out.
The following explanation was provided by
Herln Guerra, Prof. Auciello's T.A.
701
Lakers Project.
By
creating this project you will not only have fun working for the Lakers,
also you will learn some of the most common and useful tasks to work with
Microsoft Excel, the Microsoft software that can be used to compute
calculations, accounting and create interactive charts.
The first thing to know when you are working with a computer (today
in 2004) is that you don’t have to worry if you have done something
wrong. The operating systems
that computers use nowadays come with a feature which let users fix any
problems by “restoring the system” to a certain day.
So, for example, you find out that you have done something wrong to
your computer today you can restore it to yesterday functionality and
everything will be OK again. (Note
that your files will not change or be lost, the only thing that is
“restored” are the operating system files).
Similarly, with the Microsoft Suit (Word, Excel, Power Point,
Access and Outlook) there is the function called “Undo” which is
represented by an arrow that indicates “to go back.”
If you do something wrong while working in any of Mr. A’s
project, don’t worry, you just have to click this button and everything
will be back to normal. The
function is found in the “menu bar” in the “Edit” option and its
name is “Undo.” Then,
play around with the programs until you understand the functions.
Back to the Lakers Project!
Basically the project is about copying, modifying and outputting in
form of a chart the data that is found in the following website:
http://www.nba.com/lakers/
When in the website,
you will see a left-hand menu in which one of the options is “Stats”
(short for Statistics). This
is the link you want to click to start the project.
Now that you are in
the page, we will start the steps of copying/pasting your data:
- You can see a
page that contains a table in the middle with information regarding
the team and their performance for the year 2004.
You can use this information if you would like or either click
in the link that calls for the 2003 statistics.
- To copy this
information you will need to select it first.
Go ahead and position your mouse cursor in the number that is
at the last column and the last row of the ONE CHART TITLEd “PLAYER
AVERAGES.” The name of
the row is “Opponents” and the column is “PPG.”
( The number, when I wrote this, was: 85.2; the cursor has to
be on the number 2).
- Now click the
right button of your mouse and drag until you hit the first column and
first row, which is named “PLAYER.”
Make sure that the cursor ends at the “P” in “PLAYER.”
- You are
supposed to see the information highlighted (usually a dark blue
highlight). If so, proceed - If not, go back from step one.
- Right click
and “Copy.” (Before
copying any text or figure you have to make sure that the cursor is in
any of the highlighted area)
- Open a
Microsoft Excel spread sheet. (Just click the Excel icon, wherever you
have it. Usually you have to go to “Start,” then
“Programs,” then “Microsoft Office” and then the Excel icon)
- When the
application opens, go to “Edit” menu and then “Paste.”
- You can see
now all the information you copied, but now Excel has formatted it to
fit in the program. NOW
YOU HAVE COPIED AND PASTE THE INFORMATION.
NEXT WE WILL START FORMATTING.
Formatting the Lakers data
with Excel.
- First we need to clear the format
that the data has and leave as normal data. (If you notice the data
has some rows that have a different color and some of the row heights
are too big). Go to
“Edit,” look for the option “Clear” and in the sub-menu for
this section click “Formats”. Now you can see that all the
letters, numbers and the rows’ heights are all the same.
- Next, we need to change the font.
If you notice by now the date is still highlighted, the blue
shade is all over the data… if this is not true you need to go back
to step 8 of the previous section.
The font should be: type Arial - Bold, Size 9 and color Purple.
In the formatting toolbar make sure to make all those
selections and change the color to purple.
- No we deed to shorten the columns’
width and there are two ways to do it.
- The best way is by clicking on each
column’s heading. I
you notice there is a letter for each column and each letter is
divided a boundary, a dark line in between the two columns.
We can fix the width of the column by just double clicking in
the boundary of the column and the width will change to actually
feet the perfectly. So,
let’s use this system instead. Go in each of the columns and
double click in each
- The second way of doing it is more
general. Just go to
“Format” menu and then select “Column” and then “Width.” The problem with this option is that you will have to
select a width and all the columns will turn to that with. For this
project a width of 7 will do. However,
if you do this some of the data will not fit and some other, the
space will be too big.
- The data should look together now.
To start shaping the data similarly to the one Mr. A has done
for us (take a look at it: https://auciello.tripod.com/701lakers.xls),
we need to put borders on all the cells.
Go to “Format” menu “Cells.”
You should have a pop up menu with many option to format text.
Click in the tab that reads “Borders,” click the squares
that read “outline” and “inside.”
Then hit OK.
- We need to widen the row number ONE.
Put the cursor in the boundary that divides row 1 and row 2,
(the line in between them). Click
and hold while pulling down. Notice
that while you do this, there numbers appearing in a yellow strip;
this is giving you the dimensions of the row while you pull it down.
For this project pull down ‘til you hit 33.00, which in
pixels is 44.
- We have done all of this while the
data is still highlighted, but now is time to select only the firs
row. For that you just
need to put the cursor on the row heading 1 and then click it. You’ll see how only this row is now selected.
- Now we will make the headings in
this first row to look at about 45 degrees.
Go to “Format” and then click in “Cells” again.
You now have the same pop up window we used for the borders.
- Click in the tab “Alignment,”
and under the “Orientation” graph you will see the word “text”
and a line. Click the
first upper little square, which should turn red and the “text”
will look 45 degrees cricked. Click
OK to close.
YOUR DATA SHOULD NOW LOOK,
IF NOT EXACTLY LIKE MR. A’s, ALMOST THE SAME.
You are done with this part. We
need to create the Graph.
Creating the chart from the
data. For this part, we will
use column A which contains the names of the players, and column F, which
is FG%.
- Start by selecting the names of the
players only. Do not
select the two last rows as these two are not names of players. The names should be highlighted.
- Next we need to select the data in
column F while the information in column A is still selected.
For this task you will need to press the Ctrl (control) button,
hold it down and then with the mouse start selecting the information
in the column F. So go ahead and first press the “Ctrl” button and
then place the cursor over the first number on column F and drag down
until you select the number for the last player.
DO NOT SELECT ALL THE NUMBERS.
The numbers highlighted should be the same as the names of the
players.
- We need to call for the “Chart
Wizard,” which will assist us creating the chart.
In the “Insert” menu select the “Chart” option.
This will bring a pop-up window, which is the wizard.
- This function (Chart Wizard) will
help you create the chart, just make sure you are using the same chart
that Mr. A has in his sample. That
will be: in the “Chart
Type” you must have
selected “Column” and then the first type of graph in the right
hand square should be selected, it is named “Clustered Column.”
- Once you know the right chart is
selected click “Next.” Because
we have already selected the data, you don’t need to anything else
in this part.
- Click “Next” again. Now you need to insert the title of the chart.
Do it on the “Chart Title” field.
The title should be the same Mr. A has.
- You can click “Finish” now
because all the information has been entered.
- You can see a chart that appeared in
front of all the numbers (or you should see that).
Before we move down the chart let’s change the color of the
“Plot Area,” the area or background where the purple columns
appear. Just double click
anywhere on the gray area and a pop-up window will appear.
Select the color that you like.
- We need to move the chart down.
Click anywhere in White area and drag the chart to a position where
all the info can be see.
You are done with the chart.
Now, you have to enter all the other required information (name,
class, etc) and also you can play with the chart to make it look a bit
more interesting. For example
you can bold the letters or numbers in the axis by doing the same thing we
did to the “Plot area.”
That
is all for this project.
-- END OF THOROUGH, COMPLETE LESSON BY HERLIN
GUERRA. --
Describe the steps
necessary in detail to produce the document above.
|
|
|
|
|
|