Transcript Introduction to Information Science

INFORMATION SYSTEMS AND
DATA MANAGEMENT - 27006
PRE-COURSE
Dott. Alessio Brutti
2

Alessio Brutti
 [email protected]
 [email protected]

Christian Zieger
 [email protected]

Office (check the time-table):
 E523
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Exercise Organization
3





Pre-course  2+2 hours (two groups)
Excel and financial functions in A51816 hours
(two groups: Brutti & Zieger). From 17/03 to 28/04.
Relational databases architecture  6 hours
(1 single group Brutti) from 11/5 to 19/5.
Access in A518  6 hours
(two groups Zieger), from 5/6 to 10/6
Old exams 4 hours
(two groups Zieger) 11/6 and 13/6
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Pre-Course Outline
4


It follows section 2 of the book
Basic Knowledge
 Keyboard;
 Windows
8;
 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 27006- Dr. Alessio Brutti
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 27006- Dr. Alessio Brutti
17/07/2015
Windows 8
7


The OS on the UniBZ computers have been updated
to Windows 8.1
Windows 7 is still available (multi-boot system):



Windows (which is Windows 8)  default
Linux
Local HD (which is Windows 7, when installed)  NO!!
NOT boot with Windows 7  DO NOT selecting
“local HD”
 DO

If you computer is already running with Windows 7,
restart the computer.
ISDM 27006- Dr. Alessio Brutti
17/07/2015
BK - In case of problems…
8




Try to kill the programs currently in use clicking on
the X button or using ALT+F4
Otherwise, press simultaneously the keys
“CTRL”+ “SHIFT”+ “ESC”
Select the program you want to stop and click “End
Task”
Or press “CTRL”+ “ALT” + “DELETE” and choose shut
down
ISDM 27006- Dr. Alessio Brutti
17/07/2015
BK – Regional and Language settings
9

Windows+I  Control Panel  Clock, Language, and
Region Region
 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
ISDM 27006- Dr. Alessio Brutti
17/07/2015
BK - How to change keyboard settings
10



Specific icon in the right-end part of the bar
Windows+space
Left ALT + SHIFT
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Basic Knowledge (BK) - The Keyboard
11
Windows Key 
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows
12

Preliminary activities:
 Modify
folder settings in order to avoid potential
misunderstandings:
 Windows + I  Control Panel 
Appearance and Personalization 
Folder Option  View
 Uncheck
“hide extensions for known file types”
 This
way Windows always shows the extension of each file;
 Relying on the icons only is potentially misleading!!
ISDM 27006- Dr. Alessio Brutti
17/07/2015
File system
13



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)
ISDM 27006- Dr. Alessio Brutti
17/07/2015
File system (2)
14



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 27006- Dr. Alessio Brutti
17/07/2015
File system (3)
15


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: find a file - solution
16

Double-Click on “This PC”;
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 “This PC” and then type the full path in the
address bar;
\ = ALTGR + ? key.

note how Windows suggests recent addresses.
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows: the Files
17


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: network disks
18


Network disks are located on remote machines.
The shared network folder for our course is:
\\ubz01fst\Courses\Course_Coletti

Shared networlk folder for your copy-paste exercise:

Attention: it is not mapped in your file system:
\\ubz01fst\Courses\scratchECO


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: Folders (directories)
19

Solve the following exercises in order to get familiar with
handling directories:


Create on your Desktop a new directory named
“course_computer”


Windows+D 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 27006- Dr. Alessio Brutti
17/07/2015
Main operations over files and folders
20
Mouse – Right Click







Copy
Paste
Cut
Delete
Rename
Undo
Open & Open with
ISDM 27006- Dr. Alessio Brutti
Short-Cuts






“CTRL” + “C”
“CTRL” + “V”
“CTRL” + “X”
“DEL”
“F2”
“CTRL” + “Z”
17/07/2015
Windows: copying files
21


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\Intro_Labs
contains three text files:
ex1_first.txt;
 ex1_second.txt;
 ex1_third.txt;

copy those files in course_ex1\first_folder;
 keep the same names;
 use a different copying method for each file.

ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows: copying files (1)
22

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 course_ex1\first_folder;
4. right-click (somewhere in the window)  “paste”.
1.
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows: copying files (2)
23

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 course_ex1\first_folder
CTRL + V;
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows: copying files (4)
24

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.
course_ex1\first_folder;
Drop the file (release the mouse button);
ISDM 27006- Dr. Alessio Brutti
17/07/2015
Windows: copying files (4)
25

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 27006- Dr. Alessio Brutti
17/07/2015
Windows: deleting files
26

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 27006- Dr. Alessio Brutti
17/07/2015
Windows: moving a file
27

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 27006- Dr. Alessio Brutti
17/07/2015
Windows: moving a file (2)
28

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 27006- Dr. Alessio Brutti
17/07/2015
Windows: links
29

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 27006- Dr. Alessio Brutti
17/07/2015
Windows: links and files (2)
30




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 27006- Dr. Alessio Brutti
17/07/2015
Windows: folders
31



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 27006- Dr. Alessio Brutti
17/07/2015
Windows: group of files/folders
32


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: creating an archive
33


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: extracting from archives
34


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 27006- Dr. Alessio Brutti
17/07/2015
Windows: compress folders
35




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 27006- Dr. Alessio Brutti
17/07/2015
Windows: extracting folders
36

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 27006- Dr. Alessio Brutti
17/07/2015
Protect archives
37


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 27006- Dr. Alessio Brutti
17/07/2015
Roaming Profile
38

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 27006- Dr. Alessio Brutti
17/07/2015
Disk Quota
39

Disks are shared and have a limited amount of space
 each
user has 300 MB available on the disk (emails do not
count)

E-mails from the system administrators about quota
exceeding are not jokes!
 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 27006- Dr. Alessio Brutti
17/07/2015