Exchange of information in office programs

Office applications support several ways of exchanging data. The applications between which the data is exchanged will be called the receiver application and the source application. You can also use the terms source file and file-receiver or source document and document-receiver.

The easiest way to combine data from other programs in one document is to use the copy and move commands of the Edit menu that are available in all Office applications. This way of data exchange is statically.

The data becomes an integral part of the document in the receiving application when we use static copying or static moving., They are no longer connected with the source application. This type of copy or move is usually used when we work with one or several documents of the same application. It is not always possible to edit documents in the receiving application when we copy and move data from one application to another. If the data has been converted to a format that the receiving application supports, editing is possible. For example, you can edit text copied from an Excel workbook and pasted into a Word document.

We can also use technology of binding and implementation of an object called OLE (Object Linking and Embedding) to exchange data between Office programs. OLE allows you to insert data created in one program into files of another program. For example, you can insert an Excel worksheet into a Word document.

The inserted objects can be linked or embedded depending on the connection between the source and receiver files. In the first case, the data is stored in the source file, and the receiver file contains only information about the location of the source file. The embedded object becomes part of the receiver file and does not depend on the source file changes.

Although editing a linked and embedded object is done in the source program (source application), the associated object changes only when the source file is modified. The change in the embedded object does not affect the source file.

The choice of how to insert an object depends on the specific situation. Linking objects ensures timely updating and synchronization of data. The implementation of the object does not require the presence of the source file, but leads to an increase in the size of the document.

 

Specify the data representation stages in computer systems.

Graphical representation is the visual display of data using charts. Graphical representation helps to quantify, sort and present data in a method that is understandable to a large variety of audience.

Creating charts has several step process.

1. Select your data and pick the chart you want from a list of recommended charts. There are: bar, line, pie, column, area, scatter charts etc.

2. Add a chart title. You can replace the placeholder chart title with an appropriate chart title, format it the way you want, or move it to a different place in the chart.

3. Add data labels to a chart. Make a chart easier to understand by adding data labels that show details about a data series or its individual data points.

4. Change axis labels in a chart. Axis labels are shown for any horizontal, vertical, and depth axes in your chart. Labels automatically display text from the source data to describe the data that’s shown, but you can use your own text instead.

5. Change the color or style of a chart. If standard colors and chart styles don’t strike your fancy, it’s easy to change both. You can quickly pick what you like from a wide range of options in the color and style galleries.

6. Format your chart. A formatting task pane makes it easier to format any chart element. To open it, right-click any chart element.

7. Save a custom chart as a template. If you plan to use the chart you’ve created again, you can save it as a template that you can apply just like any other chart.

Specify concepts of mobile technologies.

In the computer world, the term mobile device refers to any electronic device that be easily moved from one location to another. Overtime, this category has expanded to include cell phones, laptops, smartphones, smartwatches, and other portable devices. The picture shows an example of one of the most common mobile devices today: the tablet computer.

Mobile device history.

Laptops became one of the first mobile computing devices by eliminating the wires between the computer and its peripherals; then integrating them in to one unit. Today, mobile device usually refers to any hand-held computer capable of running applications that can connect to the Internet wirelessly. However, even by today's more scrupulous standards, the category keeps expanding with new inventions. As is true in any branch of computing, our mobile devices continue to offer more advanced functions while reducing size and weight.

Mobile technology is the technology used for cellular communication. Mobile code division multiple access (CDMA) technology has evolved rapidly over the past few years. Since the start of this millennium, a standard mobile device has gone from being no more than a simple two-way pager to being a mobile phone, GPS navigation device, an embedded web browser and instant messaging client, and a handheld game console. Many experts argue that the future of computer technology rests in mobile computing with wireless networking. Mobile computing by way of tablet computers are becoming more popular. Tablets are available on the 3G and 4G networks.

One of the most important features in the 4G mobile networks is the domination of high speed packet transmission or brust traffic chanells. The same codes used to in the 2G 3G networks are applied to 4G mobile or wireless networks.