|
|
|
Last revised November 26, 2017
The
contents of this website, the links contained therein directly and
indirectly, and the contents of the said links, are copyrighted.
They are provided exclusively for
non-profit educational use by the students currently enrolled in this
course and for the duration of this semester. No other use or any use
by others is allowed
without authorization of the professor in this course and copyright
holder or holders. No videotaping or
recording without professor's prior permission is allowed in class.
Labs
Click here to go to the current lab.
Week 3 (click here for the list of weeks of classes)
Working with Windows 7 - no
lab assignment due.
Here is a link to Windows 8 overview (video 3 min 25
sec.):
http://www.youtube.com/v/9BRMJFFzBfU?version=3&
autoplay=1&fs=1&hl=en_US&rel=0
and brief tutorial (minimum
read: Chapter 4: Getting started with Windows 8):
http://www.gcflearnfree.org/windows8
I recommend that you
also read other chapters of the above tutorial in order to learn more
features of Windows 8.
Week 4
System Utilities and
File Management.
Lab assignment #1
Credit: 20 pts.
a. Open My Documents directory
b. Open Folders pane (navigation chart on the left side of the active
window)
c. Create subdirectory CSC101lab in your My Documents directory.
d. Open subdirectory CSC101lab
e. Create subdirectory LAB1 in your CSC101lab
directory
f. Open subdirectory LAB1
g. Create folder Folder1 in your LAB1 subdirectory
h. Create folder Folder2 in your LAB1
subdirectory
i. Create folder Folder3 in your LAB1
subdirectory
j. Create text file File1 in your LAB1 subdirectory
k. Create text file File2 in your LAB1 subdirectory
l. Create text file File3 in your LAB1 subdirectory
m. Create MSWord file Report in your LAB1 subdirectory
n. Take a snapshot of the screen
o. Open file Report
p. Type "Lab 1 Report", your name,
course, and today's date.
q. Paste the snapshot of the screen two lines below what you typed.
r. Save file Report
s. Minimize window of file Report
t. Open each File1, File2, and File3, and type "This is file n" where n
is 1, 2, or 3, respectively.
u. Save each File1, File2, and File3.
v. Close each File1, File2, and File3.
w. Drop file File1 to subfolder Folder1
x. Drop file File2 to subfolder Folder2
y. Drop file File3 to subfolder Folder3
z. Take
a
snapshot
of
the
screen
A. Maximize file Report
B. Paste the snapshot of the
screen two lines below of the previous snapshot.
C. Save file Report
D. Minimize window of file Report
E. Open subdirectory Folder1
F. Take a snapshot of the screen
G. Maximize file Report
H. Paste the snapshot of the
screen two lines below of the previous snapshot.
I. Save file Report
J. Minimize window of file Report
K. Move up to the parent directory of Folder1
L. Repeat steps E through K for subdirectories Folder2 and Folder3.
M. Rename subdirectory Folder1 to deleteme
N. Rename subdirectory Folder2 to saveme
O. Repeat steps F through J (taking
and
pasting
a
snapshot
of
the
screen)
P. Delete subdirectory deleteme and its contents.
Q. Repeat steps F through J (taking and pasting a snapshot of the
screen)
R. Drop subfolder Folder3 into subfolder saveme
S. Click on + before saveme in the Folders pane (it should turn
to - and display subfolder Folder3 below saveme.
T. Repeat steps F through J (taking and pasting a snapshot of the
screen)
U. Print file Report; it should look similarly to this one:
http://csc.csudh.edu/suchenek/CSC101/Labs/Report.doc
V. E-mail the doc file
that you created with the
subject
line: CSC
101-01 Lab Assignment #1 to my TA,
Mr. Shawn Her Many Horses, at
Due at the beging of the first class week 5.
Don't
forget
to
take
your
scantron
test
before the class ends.
Weeks 5 and 6
MS
Word 2010
Lab assignment #2
Credit: 20 pts.
You will need
a USB flash memory for this assignment and for all future assignments.
1. Create folder Lab2 on your USB memory device.
2. Click and open this MS Word document:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab2source.doc
and save it in folder Lab2 as Lab2source.doc.
Your goal will
be to create document on MS Word 2010 format similar to this
one:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab2out.pdf
3. From menu Programs select MS Office 2010 and MS Word.
4. Open document Lab2source.doc just saved.
4.5.
Save the document as Lab2report.doc in folder Lab2.
5. Update document properties.
6.
Overtype your last name, first name, and insert date-and-time (with the
auto update option) in the places indicated in blueprint.
7. Correct all the spelling errors in the entire document, except for
publisher's note.
Tip: You may
use help (search for key word "review") that
provides informetion on how to do that:
8. Replace all the occurrences of text hard with text soft.
9. Change the font of the body of the article in Lab2source.doc to Arial 14 pt.
10. Create header that will
show:
Author
Page n of m
Date (September 24, 2014)
Do not type any of
these!
Tip:
You may use help (search for key word "footer") that
provides information on how to do that:
11. Cut the CSUDH logo and paste it into
the footer.
12.
From the menu Page Layout, change the format of the entire document
from one column to two columns. Manually fix small imperfections, if
any.
13. From the menu Page Layout, set
indentation (first line) to 0.49"
14. Align the body of the text to full justification.
15. From
the menu Page Layout, Page Color, Fill Effect, tab: texture, fill the
entire document with texture in the lower left corner of the texture
array.
16. Place the text highlighted yellow in a one-cell table.
17. Highlight in Turquoise the text the features previously found only in
desktop publishing software.
18. Activate changes tracking option with all text in balloons and with
connecting lines.
Tip:
You may use help (search for key word "review") that
provides information on how to do that:
19. Find three incorrect words in the document (one of them is repeated
several times) and correct them.
20. At the end of the document, create a table 3 x 2 and fill it with
this information:
Words
Characters (no spaces)
Lines
21. Submit it Before you
leave the class on October 1, e-mail the doc file
that you created with the subject line: CSC 101-01 Lab Assignment
#2 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of class week 6 beging of the first class week 7.
Don't
forget
to
take
your
scantron
test
week 5,
before
the
class ends.
Week 7
MS
Excel 2010
Lab assignment #3
Credit:
20 pts.
Using the plain text file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/List_of_students_grades_in.txt
create a grading sheet, following instructions posted here:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/Lab3instructions.doc
The output of your work should consist of 2 PDF files, 2 pages each,
that look similarly (the
names
in
the
examples
and
instructions
are different than in your input
file) to these:
1st page of 1st file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/List_of_students_grades_out_p1.jpg
2nd page of 1st file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/List_of_students_grades_out_p2.jpg
and
1st page of 2nd file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/List_of_students_grades_out2_p1.jpg
2nd page of 2nd file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab3/List_of_students_grades_out2_p2.jpg
Submit it Before you
leave the class on October 5 at the begining of class October 10, e-mail the doc file
that you created with the subject line: CSC 101-01 Lab Assignment
#3 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end begining of Tuesday class week 7 8 beging of the first class week 8.
Don't
forget
to
take
your
scantron
test
before the class ends.
Week 8
MS Excel 2010
Lab assignment #4
Credit:
20 pts.
Do two exercises.
1. Use spreadsheet
to compute price of an item before sales tax.
Here are the instructions:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab4/Exercise1.doc
Here are screen shots that may be helpful:
The formulas you cut and pasted:
Enabling recurrence and setting iterations:
This is what you should get:
Save
the resulting spreadsheet as an Excel file named PriceBeforeTax.xls.
2. Use spreadsheet
to compute fixed payments on a 30 years loan with predetermined but
variable interest rate.
Here are the instructions:
First, create a sheet
with this contents:
The formulas in the
above sheet are shown below:
Then copy cells C2,
D2, E2, F2
to:
C3, D3, E3, F3
...
C360, D360, E360, F360
Make the interest rate increase in 0.01% increments.
Adjust
the Monthly Payment B2 accordingly so that the Balance B3 is close to 0.
Save the resulting
spreadsheet as an Excel file named LoanPmnts.xls.
Before you
leave the class print the files on October 15, e-mail both xls files
PriceBeforeTax.xls and LoanPmnts.xls
that you created with the subject line: CSC 101-01 Lab Assignment
#4 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of class beging of the first class week 9.
Don't
forget
to
take
your
scantron test before the class ends.
Week 9 and 10
Using a Web page composer
Lab
assignment #5
Credit:
20 pts.
Create
a
professionally
looking resume in HTML fromat using KompoZer.
Use your creativity and good taste.
You will need the following files:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/Portfolio.html
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/Turing.jpg
and (courtesy of
http://www.backgrounds.free-animations.co.uk)
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/animated_3.gif
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/animated_17.gif
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/animated_111.gif
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_11.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_13.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_14.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_21.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_40.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab5/background_43.jpg
You
may download these files by clicking on the above links first and
saving them "as" in your subdirectory Lab5 (one at a time).
You
will also need your photo in a digital format (for instance, in JPG
format), but you can add it to your resume at a later time and use
temporarily Alan Turing's photo.
Now, you may run KompoZer and open file Portfolio.html that you just
saved.
Before you
leave the class on October 19 22, submit your printed work. e-mail the HTML file
that you created with the subject line: CSC 101-01 Lab Assignment
#5 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of this class; you can submit an improved version at the beging of the first class in week 10 11 but only if you have submitted your printed work at the end of this class.
Don't
forget
to
take your scantron test before the class ends.
Week 10
Using
a
Web
page composer
Lab assignment #6
Credit:
20 pts.
1. Using this file: file:///media/disk/Files/Courses/CSC101/Labs/Lab6/Quiz.html, create a multiple-choice quiz with three
(3) questions that e-mails the
answers to your e-mail account.
The third question
should be:
3. Which protocol is
used to upload and download files from web servers?
Telnet
HTTP
FTP
2. Using this file: http://csc.csudh.edu/suchenek/CSC101/Labs/Lab6/Survey.html,
add
a
survey to the end of the quiz you create.
3. Using this file: http://csc.csudh.edu/suchenek/CSC101/Labs/Lab6/Send_email.html,
add
an
e-mail instructions to the end of the same quiz.
4. Take your quiz and submit it.
Here is what you should see when you open the html file that you have
created and take the quiz:
Here is an example of automatically generated e-mail when you click on
Send button of your Quiz:
Before you
leave the class on October 29, e-mail the HTML file
that you created with the subject line: CSC 101-01 Lab Assignment
#6 to my TA,
Mr. Shawn Her Many Horses, at
Due at the beging of the first class week 11.
HTML help on TABLE:
- ALIGN: horizontal alignment of cell contents
- VALIGN:
vertical alignment of cell contents
- WIDTH:
width of cell
- HEIGHT:
height of cell
- COLSPAN:
number of columns to cover
- ROWSPAN:
number of rows to cover
- NOWRAP: don't word wrap
- BGCOLOR:
color of the background
-
BORDERCOLOR: color of border around the table
-
BORDERCOLORDARK: color of "dark" part of border around the table
-
BORDERCOLORLIGHT: color of "light" part of border around the table
-
BACKGROUND: picture to use as background
Eample:
The following HTML code
<table
border="1">
<tr>
<th>Column 1</th>
<th>Column 2</th>
<th>Column 3</th>
</tr>
<tr>
<td rowspan="2">Row 1 Cell
1</td>
<td>Row 1 Cell 2</td><td>Row 1 Cell
3</td>
</tr>
<tr>
<td>Row 2 Cell 2</td>
<td>Row 2 Cell 3</td></tr>
<tr>
<td colspan="3">Row 3 Cell
1</td>
</tr>
</table>
results in this table:
| Column 1 |
Column 2 |
Column 3 |
| Row 1 Cell 1 |
Row 1 Cell 2 |
Row 1 Cell 3 |
| Row 2 Cell 2 |
Row 2 Cell 3 |
| Row 3 Cell 1 |
Try it for yourself!
Here is a link to some helpful HTML commands for your future reference:
http://www.webmonkey.com/2010/02/html_cheatsheet/
and to an HTML tutorial should you be interested in learning some more
about designing cool pages:
http://www.w3schools.com/html/
Weeks 11 and 12
MS Access 2013
Lab
assignment #7
Credit: 20 pts.
The following files (in MS Excel format) contain
table of parts and table of vendors:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab7/Parts.xls
and
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab7/Vendors.xls.
1. Using MS Access 2013, create a data base PartsInventory.accdb that
contains two tables: Parts
and Vendors (see file
with instructions linked below).
2. Following the steps and SQL queries visualized in file:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab7/Instructions.pdf
(The following .doc file may not display correctly:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab7/Instructions.doc )
create tables TotalsPerPart
with fields:
RecordID, PartNo, Vendor, VendorID, PartValue
and TotalsPerVendors
with fields:
Vendor, VendorValue.
3. From table TotalsPerVendors, select
records
with
VendorValue not less than $20,000, sorted decreasingly by
the Vendorvalue. It should look like this:
4. Create a PDF file with a nicely edited report of the table created
in step 3 and the table Vendors that you populated with data from the Internet. Submit it for credit before you leave
the class.
Also print and submit table Vendors that you have populated as instructed in the file http://csc.csudh.edu/suchenek/CSC101/Labs/Lab7/Instructions.pdf
Before printing the above, overtype "Sony Electronics" with your fist namd and last name.
Before you
leave the class on November 12, e-mail the PDF file
that you created with the subject line: CSC 101-01 Lab Assignment
#7 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of the Thursday's class week 12.
Don't
forget
to take your scantron test before the class ends week 12.
Week 13
Mathematica
Lab assignment #8
Credit:
20 pts.
Create subdirectory Lab8 on your USB drive.
Open Mathematica and open Notebook.
Save it in subdirectory Lab8
as MathStuf.nb
Perform all computations visualized here:
http://csc.csudh.edu/suchenek/CSC101/MathLabInstructions.doc
Save the Notebook in
PDF format, print it, and submit it.
Before you
leave the class, e-mail the PDF file
that you created with the
subject
line: CSC
101-01 Lab Assignment
#8 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of this class.
Don't
forget
to
take your scantron test before the class ends.
Week 14
No lab - Happy Thanksgiving!
Week 15
MS Power
Point 2007
Lab assignment #9
Credit:
20 pts.
Copyright
Note
The figures linked from this exercise are copyrighted by © 2010 Wolfram
Demonstrations Project & Contributors. The pictures have been
adapted from the Wolfram Demonstrations Project website specified below
according to the Terms of Use posted here:
http://demonstrations.wolfram.com/termsofuse.html
Supply
and Demand
The following pictures:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab8/supply.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab8/demand.jpg
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab8/supply_demand.jpg
visualize
respectively: supply (red line), demand (blue line), and supply-demand
graphs of price as a function of quantity. Using these pictures and the
explanatory text posted at:
http://demonstrations.wolfram.com/SupplyAndDemand/
create a slide show that explains the Law of Supply and Demand.
Use
this file to create and insert appropriate copyright and fair use
notes, with live links, into your slides:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab8/Copyright_and_use.txt
Your slides should have the following color:
Example of the complete slide show (remember to put your
name, not mine) may be viewed here:
http://csc.csudh.edu/suchenek/CSC101/Labs/Lab8/Example_of_slide_show.doc
4. Save the PowerPoint file.
5. Export the PowerPoint file to PDF format.
Before you
leave the class, e-mail the pdf file
that you created with the
subject
line: CSC
101-01 Lab Assignment
#9 to my TA,
Mr. Shawn Her Many Horses, at
Due at the end of this class. beging of the first class week 16.
Don't
forget
to
take your scantron test before the class ends.
Week 15, 16
Making movies and recording music on Mac.
Lab assignment #10
This lab is demonstration only that uses MacIntosh computer. There is
no assignment due for this lab.
Watch the video "How To record Your Own Music 101" -
it will be covered on final exam.
Here is a link to a class movie "The Last Laboratory".
Weeks of classes in Fall 2017:
week 1: Aug 22, 24
week 2: Aug 29, 31
week 3: Sep 5, 7
week 4: Sep 12, 14
week 5: Sep 19, 21
week 6: Sep 26, 28
week 7: Oct 3, 5
week 8: Oct 10, 12
week 9: Oct 17, 19
week 10: Oct 24, 26
week 11: Sep 31, Nov 2
week 12: Nov 7, 9
week 13: Nov 14, 16
week 14: Nov 21
week 15: Nov 28, 30
week 16: Dec 5
week 17 (final): Dec 7
Note
This page and the entire course
website http://csc.csudh.edu/suchenek/CSC101/ may contain
copyrighted material that is included and/or used for non-profit
educational purposes only, and not for any other purpose, and only for
the duration of the course. Click here
for U.S. Code Tittle 17 Chapter 1 para 107 containing the "fair use" exception for
copyrighted material.
|
|
