Tuesday, July 28, 2015
Creating and Sharing a DSS with Spreadsheet
In this video you will see how to create an analytical spreadsheet with parameters (inflation in this case) and then observe changes to your model when the parameters change (like changes in inflation)
Friday, July 17, 2015
Video on database and table creation
Since some features of zoho have recently changed I will show in two short videos how to do the zoho task.
Step 1. Database and table creation
Step 2. Publishing to the blog and the forum
After this task you should realize what a tremendous industrial power is this knowledge. Some students bring this technology to work and start using immediately. The database or particular tables could be created and maintained by different people or departments. The data could be made visible to only employees, to particular departments, or to the whole planet. Such skill can right there be the foundation of some business when you collect from people data (INPUT), process them (like in your formula column and even more powerful processing) - PROCESSING, and distribute data as table views or embedded parts of your web sites (like on your blog) - OUTPUT. Seeing the processed total results, the customers can change the input -FEEDBACK - to do a more precise job, or task.
Step 1. Database and table creation
Step 2. Publishing to the blog and the forum
After this task you should realize what a tremendous industrial power is this knowledge. Some students bring this technology to work and start using immediately. The database or particular tables could be created and maintained by different people or departments. The data could be made visible to only employees, to particular departments, or to the whole planet. Such skill can right there be the foundation of some business when you collect from people data (INPUT), process them (like in your formula column and even more powerful processing) - PROCESSING, and distribute data as table views or embedded parts of your web sites (like on your blog) - OUTPUT. Seeing the processed total results, the customers can change the input -FEEDBACK - to do a more precise job, or task.
DB Task on Zoho
After the table and the formula column have been created, you have to complete the last part of the task - sharing your table over the Internet! Here you will have two types of sharing: one for the forum link and another is an iframe to be embedded into your blog. Note that the first one is a link, that if you click on - you get to the table. Another one is an iframe that works only if embedded into the HTML gadget in the Blogger.
Here are the sharing steps that might be even easier than the task proposed:
1. Make the view of your table public (this is important for further sharing):
2. Copy the url that you will post into the Moodle forum and then confirm the public view
3. Select Publish, Embed in Website/Blog to copy the iframe and then paste it into the HTML gadget in Blogger
Here are the sharing steps that might be even easier than the task proposed:
1. Make the view of your table public (this is important for further sharing):
2. Copy the url that you will post into the Moodle forum and then confirm the public view
3. Select Publish, Embed in Website/Blog to copy the iframe and then paste it into the HTML gadget in Blogger
Databases
Although a database table might look like a spreadsheet, the capabilities of a database management system (software engine behind the databases) are quite different. For better understanding you might go to the Featured Samples (while on the Home page in your Zoho Reports site) to see that after the initial tables are created and filled with data, the rest of the database consists of various queries (that could be saved for future easy customer use), reports, charts, etc. All other database products, created from the data tables by using simple and effective tools, allow to SEE and ANALYZE a LOT of DATA form MULTIPLE POINTS OF VIEW, as compared to the relatively small amount in typical spreadsheets.
Well designed and developed (in terms of convenient analysis) databases - is what create added value to the initial data collection often stored in some input “flat” files. Data warehouses (or smaller data marts) are systems enhancing this analytical and decision support function of organizational (and even personal) data.
In my professional capacity, I was often asked by organizations that invested a lot of money into collection of valuable data – to help them make better use of this information (bang for the invested buck, if you want). This usually results into the development of an information system with a database at its core (this is why they call them “information systems” :)
Well designed and developed (in terms of convenient analysis) databases - is what create added value to the initial data collection often stored in some input “flat” files. Data warehouses (or smaller data marts) are systems enhancing this analytical and decision support function of organizational (and even personal) data.
In my professional capacity, I was often asked by organizations that invested a lot of money into collection of valuable data – to help them make better use of this information (bang for the invested buck, if you want). This usually results into the development of an information system with a database at its core (this is why they call them “information systems” :)
Tuesday, July 7, 2015
More about systems
Congratulations with the successful start of the course (since you are reading this post :) ! I noticed that most of you are in various biz majors (mainly marketing) as well as other non-IT ones. Therefore you might learn a few useful things here.
This course is designed to enhance/offer an understanding in systems theory and information systems and technologies in particular. The first week is may be the most important since you are getting here the fundamentals of the "so-called" systems vision. Regardless of the variety of entities and processes surrounding you in your personal or organizational lives, a stunning discovery has been made by Karl Ludwig von Bertalanffy - the founder of the General System Theory (GST) - that they all are systems. More than that, there can be created a science that can cover all types of systems as having common properties, features, and traits. Therefore, learning and understanding anything as a system allows to apply such most generally applicable knowledge to all situations. Since then the theory has been evolving and now many organizations require from their leading employees "systems thinking" as ability to apply GST to any situation of any kind that they encounter.
After you get familiar with the main systems concepts we move to the applications of this theory to a specific type of systems – information systems (IS) and information technologies (IT). You will often find a term ICT (information and communication technologies) instead of IT. And finally, we will move to the role of IS/ICT in business and organizational systems. The Information Systems major in the Business School (has a minor too) offers students a professional grasp of the most general and widely useful knowledge, which nowadays is being used in all organizations/jobs – IS/ICT. With deeper knowledge and skills in this area students learn of how to dramatically enhance individual abilities by using various methods, skills, and tools that are offered in the major in order to enhance personal ability of consistently making best decisions under all circumstances, of how to put artificial intelligence to your personal and organizational service, of how to design systems that are the most important competitive resource for individuals and organizations, and how to develop electronic businesses and start-ups. This course offers you a glimpse (although important) into the IS/ICT world.
As one of the extensions of the IS activities we offer a completely online Web Development Certificate Program (just like Business Essentials) increasing your knowledge and skills in developing modern Web-based systems, sites, and organizations. This course might be a good foundation for this program.
There is a lot more to the systems theory than we can fit into this course. Such areas a Complex Systems Theory, Dynamic Systems Theory, Chaos, fractal systems, and Theory of Catastrophes are some of the more specific areas that being actively used in economics, finance, business, marketing analysis, medical and biological studies.
This course is designed to enhance/offer an understanding in systems theory and information systems and technologies in particular. The first week is may be the most important since you are getting here the fundamentals of the "so-called" systems vision. Regardless of the variety of entities and processes surrounding you in your personal or organizational lives, a stunning discovery has been made by Karl Ludwig von Bertalanffy - the founder of the General System Theory (GST) - that they all are systems. More than that, there can be created a science that can cover all types of systems as having common properties, features, and traits. Therefore, learning and understanding anything as a system allows to apply such most generally applicable knowledge to all situations. Since then the theory has been evolving and now many organizations require from their leading employees "systems thinking" as ability to apply GST to any situation of any kind that they encounter.
After you get familiar with the main systems concepts we move to the applications of this theory to a specific type of systems – information systems (IS) and information technologies (IT). You will often find a term ICT (information and communication technologies) instead of IT. And finally, we will move to the role of IS/ICT in business and organizational systems. The Information Systems major in the Business School (has a minor too) offers students a professional grasp of the most general and widely useful knowledge, which nowadays is being used in all organizations/jobs – IS/ICT. With deeper knowledge and skills in this area students learn of how to dramatically enhance individual abilities by using various methods, skills, and tools that are offered in the major in order to enhance personal ability of consistently making best decisions under all circumstances, of how to put artificial intelligence to your personal and organizational service, of how to design systems that are the most important competitive resource for individuals and organizations, and how to develop electronic businesses and start-ups. This course offers you a glimpse (although important) into the IS/ICT world.
As one of the extensions of the IS activities we offer a completely online Web Development Certificate Program (just like Business Essentials) increasing your knowledge and skills in developing modern Web-based systems, sites, and organizations. This course might be a good foundation for this program.
There is a lot more to the systems theory than we can fit into this course. Such areas a Complex Systems Theory, Dynamic Systems Theory, Chaos, fractal systems, and Theory of Catastrophes are some of the more specific areas that being actively used in economics, finance, business, marketing analysis, medical and biological studies.
Purpose of the Blog
In this blog I will write reflections on your performance, on grading methods, explain possible task difficulties, provide additional help if needed, etc. Also will be a part of a small information system that you all will co-design, which will use blogs as one of its components. Check this blog periodically.
Subscribe to:
Comments (Atom)