ICT: Difference between revisions

From Wikistudy.ByJuho.fi
(various tweaks)
(various tweaks and improvements)
Line 2: Line 2:
== General info about computing facilities in HH ==
== General info about computing facilities in HH ==


* [[w:Windows 7 Enterprise]] and [[w:Microsoft Office 2013]] are used pervasively in HH.
* [[w:Windows 7 Enterprise]] and [[w:Microsoft Office 2013]] are used pervasively in HH. Maybe even too so if one is a [[w:FOSS]] oriented engineering student at HH.


* HH has purchased licenses for nearly everything that MSFT sells. ( Check Mynet for more info ?)
* HH has purchased licenses for nearly everything that MSFT sells. ( Check Mynet for more info ? )


* HH uses VDI [[w:desktop virtualization]] in its computers to bring an extremely available and responsive computing experience to thousands of users using the approximatelly 2000 computers there are in HH Pasila Campus.  
* HH uses VDI [[w:desktop virtualization]] in its computers to bring an extremely available and responsive computing experience to thousands of users using the approximatelly 2000 computers there are in HH Pasila Campus.  


* '''[[w:WinSCP]]'''[http://winscp.net/eng/download.php (.net)] is the tool of choice for Windows users moving files to network folders.  
* '''[[w:WinSCP]]'''[http://winscp.net/eng/download.php (.net)] is the tool of choice for Windows users moving files to network folders. ( Teacher ) Another option for Windows is the [http://www.chiark.greenend.org.uk/~sgtatham/putty/download.html PScp available here] ( jubo-jubo )
:: Winscp allows you to access Myy-disk at home etc.
:: Winscp allows you to access Myy-disk at home etc.
:::: If you are using OS X, Linux or FreeBSD at home you can use the pre-installed command line tool '''[[w:Secure copy|scp]]''' to get same functionality ( move files between machines securely ).  
:::: If you are using OS X, Linux or FreeBSD at home you can use the pre-installed command line tool '''[[w:Secure copy|scp]]''' to get same functionality ( move files between machines securely ).  
Line 22: Line 22:


== Excel ==
== Excel ==
A '''[[w:spreadsheet|spreadsheet]]''' ( [[w:fi:taulukkolaskentaohjelma]] ) is an interactive [[w:computer application|computer application]] program for organization and analysis of [[w:data|data]] in [[w:table (information)|tabular]] form. Spreadsheets developed as computerized simulations of paper accounting [[w:worksheet|worksheet]]s. The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a [[w:model–view–controller|model–view–controller]] element that can contain either numeric or text data, or the results of [[w:formula|formula]]s that automatically calculate and display a value based on the contents of other cells. ( Wikipedia )
'''[[w:Microsoft Excel|Microsoft Excel]]''' is a '''[[w:spreadsheet|spreadsheet]]''' ( [[w:fi:taulukkolaskentaohjelma]] ), an interactive [[w:computer application|computer application]] program for organization and analysis of [[w:data|data]] in [[w:table (information)|tabular]] form.  
::Spreadsheets developed as computerized simulations of paper [[accounting]] [[w:worksheet|worksheet]]s.  
::::The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a [[w:model–view–controller|model–view–controller]] element that can contain either numeric or text data, or the results of [[w:formula|formula]]s that automatically calculate and display a value based on the contents of other cells.
:::::: Excel features calculation, graphing tools, [[w:pivot table|pivot table]]s, and a macro programming language called [[w:Visual Basic for Applications|Visual Basic for Applications]]. ( Wikipedia on [[w:Microsoft Excel]] and [[w:spreadsheet]] mashed together )


'''[[w:Microsoft Excel|Microsoft Excel]]''' is a [[w:spreadsheet|spreadsheet]] [[w:Application software|application]] developed by [[w:Microsoft|Microsoft]] for [[w:Microsoft Windows|Microsoft Windows]] and [[w:Mac OS|Mac OS]]. It features calculation, graphing tools, [[w:pivot table|pivot table]]s, and a macro programming language called [[w:Visual Basic for Applications|Visual Basic for Applications]]. ( Wikipedia )





Revision as of 15:53, 30 January 2015

ICT skills for Business

General info about computing facilities in HH

  • HH has purchased licenses for nearly everything that MSFT sells. ( Check Mynet for more info ? )
  • HH uses VDI w:desktop virtualization in its computers to bring an extremely available and responsive computing experience to thousands of users using the approximatelly 2000 computers there are in HH Pasila Campus.
  • w:WinSCP(.net) is the tool of choice for Windows users moving files to network folders. ( Teacher ) Another option for Windows is the PScp available here ( jubo-jubo )
Winscp allows you to access Myy-disk at home etc.
If you are using OS X, Linux or FreeBSD at home you can use the pre-installed command line tool scp to get same functionality ( move files between machines securely ).
The scp uses underlying ssh tool for security and encryption which can be used to securely connect to a shell on a server. ( jubo-jubo )

Power Point 2010

Microsoft PowerPoint is a slide-based presentation program developed by Microsoft. ( Wikipedia )

Word 2010

Microsoft Word is a word processor developed by Microsoft. ( Wikipedia )

ICT Skills for Business 2

Excel

Microsoft Excel is a spreadsheet ( w:fi:taulukkolaskentaohjelma ), an interactive computer application program for organization and analysis of data in tabular form.

Spreadsheets developed as computerized simulations of paper accounting worksheets.
The program operates on data represented as cells of an array, organized in rows and columns. Each cell of the array is a model–view–controller element that can contain either numeric or text data, or the results of formulas that automatically calculate and display a value based on the contents of other cells.
Excel features calculation, graphing tools, pivot tables, and a macro programming language called Visual Basic for Applications. ( Wikipedia on w:Microsoft Excel and w:spreadsheet mashed together )


  • Payment calculation
w:Principal * w:Interest rate == w:Interest
w:Present value
w:Future value

More on using Excel:

Cloud computing

  • w:Cloud computing ( w:fi:Pilvilaskenta ) is a major pleasantifier of information technology systems acquisition and operation hassle and costs. Prices start as low as 15€ / VPS-from-cloud ( virtual private server ) with full w:root access. Additionally cloud computing is ecological. Think of a business buying a big physical server which is then utilized to 10% of it's maximum capacity whereas in cloud computing you can thanks to w:Virtualization technologies have much better utilization rates for actual physical devices. ( jubo-jubo )
  • In cloud computing multiple w:abstraction layers provide ability to move virtual servers around the cloud. It can anticipate breaking down of single physical components and move the services to a sound, functional piece of server hardware in advance to the physcial component breaking up. In addition to these fault surviving technology cloud computing is very w:ecologically efficient as several, even tens of w:virtual servers can live on one physical machine instead of expensive server hardware sitting idly as the load is much lower then the total processing power by a factor of 10x or so. ( jubo-jubo )

Things as a service


In the w:business model using software as a service, users are provided access to application software and databases. The cloud providers manage the infrastructure and platforms on which the applications run. SaaS is sometimes referred to as “on-demand software” and is usually priced on a pay-per-use basis. SaaS providers generally price applications using a subscription fee. ( Wikipedia )


SPSS

See Toolkit for Quantitative Surveys


Microsoft Project

See Project Management in Multicultural Environment

More information