Transcript Introduction to Information Science

INFORMATION SYSTEMS AND
DATA MANAGEMENT - 27000
PRE-COURSE
Christian Zieger
2

Christian Zieger
 [email protected]

Office (check the time-table):
 E525
 A518
ISDM 27000 - Christian Zieger
17/07/2015
Exercise Organization
3




Pre-course of introduction to Windows and to the UniBZ
computers  2 hours
10 hours of exercises on Excel in computer room A518
2 hours of exercises on Access in computer room A518
2 exams' solutions
ISDM 27000 - Christian Zieger
17/07/2015
Pre-Course Outline
4


It follows section 2 of the book
Basic Knowledge
Keyboard;
 Windows folders and options;
 OS settings: language and number&date format.


File handling under Windows
Network folders;
 How to copy/delete/move files and folders;
 Archives: compress and extract.


Other issues:

Roaming profile and disk quota.
ISDM 27000 - Christian Zieger
17/07/2015
Warning!!
5




Windows and computers in general are rather
unstable due to many possible reasons.
When working on something important remember
to:
SAVE OFTEN!
Create BACKUP COPIES!
ISDM 27000 - Christian Zieger
17/07/2015
Basic Knowledge
6

Start menu








Programs
User’s documents
Recent files
shut down button
Control panel  configure your operating systems
Quick launch icons
Running programs
Quick settings/notification on the bottom right
corner
ISDM 27000 - Christian Zieger
17/07/2015
BK - In case of problems…
7





Try to kill the programs currenlty in use clicking on
the X button or using ALT+F4
Otherwise, press simultaneously the keys
“CTRL”+ “SHIFT”+ “ESC”
Go to the tab named “Application”, select the
process with Status “Blocked” and push the button
“End Task”
Or press “CTRL”+ “ALT” + “DELETE” and choose shut
down
Press the computer on/off button
ISDM 27000 - Christian Zieger
17/07/2015
BK – Regional and Language settings
8

Start  Control panel  Clock, Language, and
Region Region and Language
 Modify
the language of the operating system:
 Keyboards and Languages (need to log off to apply)
 Modify date, number, currency, etc. formats:
 Formats
Choose a predefined format or Customize your own


Notice: these settings influence the behavior of some
applications like Excel
If you use the classical view, menus are slightly different
ISDM 27000 - Christian Zieger
17/07/2015
BK - How to change keyboard settings
9


See the left side of your task bar
Left click on the icon containing the simbol “IT” or
“EN” or “DE”
ISDM 27000 - Christian Zieger
17/07/2015
Basic Knowledge (BK) - The Keyboard
10
ISDM 27000 - Christian Zieger
17/07/2015
Windows
11

Preliminary activities:
 Modify
folder settings in order to avoid potential
misunderstandings:
 Start  Control Panel 
Appearance and Personalization 
Folder Option  View
 Uncheck
“hide extension for known file types”
 This
way Windows always shows the extension of each file;
 Relying on the icons only is potentially misleading!!
ISDM 27000 - Christian Zieger
17/07/2015
File system
12



Files: basic containers of the information
Folders: containers of files and other folders
Each storage device is a big directory
Data are arranged in a Tree-like structure stored
where hard disks are roots (physical devices
containing the information)
 Disks:
C (programs), E (courses), F (your homes)
ISDM 27000 - Christian Zieger
17/07/2015
File system (2)
13



The “absolute path” or “address” identifies the
location of a specific item in the file system
It is displayed in the address bar in the upper part
window
Note: Windows is not case sensitive!
Links (or shortcuts) are special items (later)
ISDM 27000 - Christian Zieger
17/07/2015
File system (3)
14


Consider the problem of finding a file (or a folder)
given its absolute path.
Windows provides you with two alternative ways:
 Browsing
the file system;
 Typing the absolute path in the address bar.

As an exercise, try to find the following file:
C:\Windows\System32\napipsec.dll
ISDM 27000 - Christian Zieger
17/07/2015
Windows: find a file - solution
15

Double-Click on “Computer”;
Double-Click on: C:\  Windows System32 …;
2. Search the file in the list:
press “n” to go to the first file (or folder) starting with “n”
 Organizelayoutnavigation pane to display the file system
tree; unfold folders by clicking the small triangle;
1.

Alternative:

double-click on “Computer” and then type the full path in the
address bar;
\ = ALTGR + ? key.

note how Windows suggests recent addresses.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: the Files
16


A computer file is a block of arbitrary information, or resource for storing
information, which is available to a computer program and is usually
based on some kind of storage.
The icon indicates to which program the file is associated with (which
program is run when double-clicking).
ISDM 27000 - Christian Zieger
17/07/2015
Windows: network disks
17


Network disks are located on remote machines and can be
accessed as common directories;
The shared network folder for our course is:
\\ubz01fst\Courses\Course_Coletti

The shared network folder for testing copying files is:
\\ubz01fst\Courses\scratchECO

Attention: it is not mapped in your file system:


You won’t find it if you browse through your disks.
You can get there only typing the full path in the address bar;


\ = ALTGR + ? key.
Windows will remember it and suggest later.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: Folders (directories)
18

Solve the following exercises in order to get familiar with
handling directories:


Create a new directory named “course_computer” in disk
“DATA:”


Computer  DATA:\  right-click  new  folder  type the
folder name (“course_computer”)
Rename the new folder as “course_ex1”:


Please use the correct names where specified.
right-click on the folder  rename  type the new name
(“course_ex1”)
Exercise:

In “course_ex1” create 2 new folders named: “first_folder” and
“second_folder”.
ISDM 27000 - Christian Zieger
17/07/2015
Main operations over files and folders
19
Mouse – Right Click







Copy
Paste
Cut
Delete
Rename
Undo
Open & Open with
ISDM 27000 - Christian Zieger
Short-Cuts






“CTRL” + “C”
“CTRL” + “V”
“CTRL” + “X”
“DEL”
“F2”
“CTRL” + “Z”
17/07/2015
Windows: copying files
20


Windows offers to the user 3 different ways to make a
copy of a file already present in the file system.
Consider the following exercise:
 \\ubz01fst\Courses\Course_Coletti\ISDM_27000\
Material\Intro_Labs contains three text files:
ex1_first.txt;
 ex1_second.txt;
 ex1_third.txt;

copy those files in DATA:\course_ex1\first_folder;
 keep the same names;
 use a different copying method for each file.

ISDM 27000 - Christian Zieger
17/07/2015
Windows: copying files (1)
21

First method:
right-click copy – right-click paste
browse to the network folder (type the full address);
2. right-click on ex1_first.txt  “copy”;
3. go to DATA:\course_ex1\first_folder;
4. right-click (somewhere in the window)  “paste”.
1.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: copying files (2)
22

Second method:
CTRL+C - CTRL+V
1.
2.
3.
4.
5.
Go to the network folder;
click on ex1_second.txt
CTRL + C;
Browse to DATA:\course_ex1\first_folder
CTRL + V;
ISDM 27000 - Christian Zieger
17/07/2015
Windows: copying files (4)
23

Third method:
drag and drop
1.
2.
Go to the network folder:
ex1_third.txt  drag the file keeping pressed the mouse button
There must be the “+” symbol!!
(if not keep CTRL pressed)
3.
4.
DATA:\course_ex1\first_folder;
Drop the file (release the mouse button);
ISDM 27000 - Christian Zieger
17/07/2015
Windows: copying files (4)
24

Exercise:
 Try
to copy files from first_folder to second_folder;
 Try to use each way;
 Rename each copied file adding “_copied” at the end of
the name (before the extension).
ISDM 27000 - Christian Zieger
17/07/2015
Windows: deleting files
25

Again there are 3 ways among which you can choose
to delete a file:
 delete and answer YES;
 drag the file in the “Recycle bin” and drop;
 click on the file and press DEL-ENTF and answer YES.
 right-click

As an exercise try to delete each file in
“second_folder” :
 Use
all 3 available methods.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: moving a file
26

Moving a file involves actually two actions:
 Windows
first copies the file;
 Then it deletes the original file.

Again you can choose among 3 different ways which
are very similar to those for copying:
 cut  right-click  paste;
 drag and drop:
(without “+” otherwise press SHIFT)
 CTRL + X and CTRL + V
 right-click
ISDM 27000 - Christian Zieger
17/07/2015
Windows: moving a file (2)
27

As an exercise consider the three files in
“first_folder” and move them to “second_folder”
 use

all the available ways (one for each file);
Exercise:
 Try
to move files back to their original folder;
 Use a different method for each file.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: links
28

Beware: a link is not a real file but only a shortcut to a file
(or a folder)



It is a sort of address
Links are identified by an arrow at the bottom left corner
of the icon.
2 ways to create a shortcut:
drag the file WITH THE ARROW
(otherwise press ALT or SHIFT + CTRL).
 right-click  create a shortcut  move the shortcut to
where you want;


Exercise:
in “second_folder” create a shortcut of files in “first_folder”.
 delete the links.

ISDM 27000 - Christian Zieger
17/07/2015
Windows: links and files (2)
29




REMEMBER what follows:
If you copy a link you do not copy the real file;
If you delete the real file, the link does not work
anymore;
General hint:
During the exam ensure that you actually copy
your work in the given folder instead of making
a link.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: folders
30



Moving, copying and deleting folders is the same as for
files;
When you do something to a folder you do the same to
its contents.
Exercise:
1.
2.
3.
Copy “second_folder” in “first_folder” with drag&drop and
rename it as “third_folder”;
Delete “third_folder” in “first_folder” with DEL;
Copy again “second_folder” with right-click copy and rename
it as “third_folder”;
ISDM 27000 - Christian Zieger
17/07/2015
Windows: group of files/folders
31


Any operation can be performed on a group of items
(files or folders);
Select a group of files:
Keep the left button of the mouse pressed and grab items ;
or
 CTRL + click on each item;
or
 select the first and SHIFT + click on the last;
(better if files are arranged in a list)


Exercise:
Copy all files in “first_folder” down to “third_folder” in one
shot;
 Move all files in “third_folder” to “second_folder”;
 Rename files in “second_folder” adding “_moved” at the end
of the file name (before the extension).

ISDM 27000 - Christian Zieger
17/07/2015
Windows: creating an archive
32


Your machines are equipped with a tool for file
compression named “IZarc”
To create an archive, select a file and then:
IZArc  add to …
 Here you can either:
 right-click
Select the suggested name
or
 Choose name and location of the archive (Add to Archive file)


Exercise:

Compress the file “ex1_first.txt” in “first_folder” as
“ex1_first.zip”.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: extracting from archives
33


Exercise: extract “ex1_first.zip” in “second_folder”;
Solution: double-click  IZArc opens a folder-like list

If not:
Open with  browse  Programs  IZArc  IZArc.exe
 Check: “always associate this extension to this program”
So that next time you can just double-click.


Drag the file where you want to extract it;
or


Use the extract button and specify the address;
Pay attention: the folder is only a list of the archive content
do not edit files directly from the application but extract
them first!!
ISDM 27000 - Christian Zieger
17/07/2015
Windows: compress folders
34




Exercise: compress the folder “course_ex1” in the
archive “course_ex1.zip”;
Same way as for files:
right-click  IZarc  add to;
Double-click on “course_ex1.zip” to see the archive
content;
Notice that the archive includes the whole directory
structure.
ISDM 27000 - Christian Zieger
17/07/2015
Windows: extracting folders
35

To extract single files:
Click on the file you want to extract and either:
Drag the file;
or
Click the extract button;
 Remember: in this way you lose the folder structure.


Extract “ex1_first.txt” from “course_ex1.zip”:


the directory structure is lost.
Extract the whole archive “course_ex1.zip”
Use the extract button without selecting any file;
 Hint: create a temporary folder to extract the archive;

ISDM 27000 - Christian Zieger
17/07/2015
Protect archives
36


Exercise: compress the folder “course_ex1” in the
archive “course_ex1_pwd.zip” adding a password
with AES 128 encryption.
Try to
 list
the content of the folder
 extract the content of the folder
ISDM 27000 - Christian Zieger
17/07/2015
Roaming Profile
37

UniBz network implements roaming profiles:
Wherever you log-in you find your desktop and your settings;
 When logging in, your profile is loaded from:
\\ubz01fst\students\YEAR\eco\LOGINNAME
 When you log off the machine stores all the changes you have
done (and your files) in the same folder;



You do not use the disks of the computer where you are
logged in!
Everything goes in the shared space (also e-mail
attachments).
ISDM 27000 - Christian Zieger
17/07/2015
Disk Quota
38

Disks are shared and have a limited amount of space


E-mails from the system administrators about quota
exceeding are not jokes!


each user has 300 MB available on the disk (emails do not count)
If there is no more space, the system fails to update your profile
on logoff and everything is lost!!
If you get a quota warning, go to:

\\ubz01fst\students\YEAR\eco\LOGINNAME
and remove some stuff!
 Removing locally (form the desktop) won’t work!!
ISDM 27000 - Christian Zieger
17/07/2015