Computer Applications for Record Keeping
DIAGNOSTIC RADIOGRAPHY · NTA LEVEL 4 · SEMESTER TWO Computer Applications for Record Keeping CRT04207 · Radiology Informatics START READING NOTES Study Computer Applications for Record Keeping using the sections below. Use the topic navigation to continue through Radiology Informatics. Contents of This Topic ©Radiology Informatics Learning objective: FEATURES OF COMPUTER APPLICATIONS FEATURES OF MICROSOFT WORD FEATURES OF MICROSOFT EXCEL FEATURES OF STATISTICAL PACKAGES SCOPE OF COMPUTER INFORMATION SYSTEM CORE FUNCTIONS Computer Applications for Record Keeping BENEFITS OF CIS Cost reduction: by automating tasks, reducing errors and improving efficiency, can help organizations reduce costs CHALLENGES OF CIS Advantage of computer Packages Improved Data Management: Reduced Development Costs: Disadvantages of computer Packages Limited Customization: Dependency: Training: ©Radiology Informatics SESSION 2: Apply word processing program in keeping records Learning objective: Describe features of Microsoft excel, Microsoft access and statistical packages Demonstrate computer application in (excel, MS excel worksheet, charts) Describe the scope of Computer information system, functional support, benefits and challenges Discuss advantages and disadvantages of computer packages in information communication ©Radiology Informatics FEATURES OF COMPUTER APPLICATIONS Computer features encompass a wide range of capabilities, from basic functionalities like user interface elements and file management to advanced features like data analysis, multimedia integration and online collaboration. ©Radiology Informatics FEATURES OF MICROSOFT WORD Microsoft word is a versatile word processing program with features like: Text formatting Grammar and spelling check Image insertion and Advanced page layout ©Radiology Informatics FEATURES OF MICROSOFT EXCEL Microsoft excel is the powerful spreadsheet program with numerous features for data organization, analysis and visualization. Key features are: Formulas Chart tables Pivot tables Along with functionalities for sorting, filtering and conditional formatting ©Radiology Informatics FEATURES OF STATISTICAL PACKAGES Statistical packages are software suites designed for performing statistical analysis, data management and visualization, Key features: Data entry and data management Descriptive and inferential statistics Hypothesis testing Data visualization Reporting ©Radiology Informatics ©Radiology Informatics ADDING NEW COLUMN/ ROW OR WORKSHEET Click on a Column(S) heading/ Row(s) heading or Worksheet name beside a new one. Click on “Insert” menu. Click on the option you want. E.g. Columns, Rows or Worksheet. Note: New column(s) is added at the left side of a selected column. New row(s) is added above a selected row(s) New worksheet(s) is added at the left side of a selected worksheet(s) ©Radiology Informatics REMOVING COLUMN/ ROW OR WORKSHEET Click on a Column(s) heading/ Row(s) heading or Worksheet name(s) you wish to remove. Click on “Edit” menu. Click on “Delete” command. OR: Click on “Delete Sheet” command, then click on “Yes” button to confirm. Note: When you remove a Worksheet, it is permanently deleted i.e. you can’t restore. ©Radiology Informatics RENAMING A WORKSHEET Click on the sheet name you wish to rename. Click on ‘Format’ menu Select ‘Sheet’ command Click on ‘Rename’ option Type a new name. Press ‘Enter’ key REARRANGING WORKSHEETS Press and hold down left mouse button over the sheet name you wish to rearrange. Drag to a new position and then release the mouse button. ©Radiology Informatics HANDS ON PRACTICE Copy the data as shown on the worksheet above and answer all the question on the next slide ©Radiology Informatics HANDS ON PRACTICE CONT… Insert a new Column between Name and Residence Column and name it Age type any numbers Insert a new row between Maimuna and Zakaria ,and type any entries as per columns headings Copy all the contents and paste in the sheet number 2 ©Radiology Informatics CHANGING TEXT ALIGNMENT Select the text you wish to change alignment. Click on ‘Format’ menu. Click on ‘Cells’ command. Click on ‘Alignment’ tab. Under “Orientation” text box, set an angle you want. Click on ‘Ok’ button when you are done Note: Under “Text Control” text box you can apply a “Wrap text” effect in a Cell. ©Radiology Informatics ©Radiology Informatics WORKING WITH CHARTS A Chart is the graphical representation of data. Using Microsoft Excel, you can represent numbers in a chart, by choosing from a variety of chart types. When you change your data, your chart will automatically update. You can use Microsoft Excel's Chart Wizard to take you through the process step-by-step to accomplish creating your chart. ©Radiology Informatics CREATING A CHART Select the range of data in your spreadsheet that you wish to include in the chart. Click on ‘Insert’ menu. Click on ‘Chart’ command. Note: Chart Wizard dialog box will appear Select a Chart Type and Subtype, then click ‘Next’ Select data Series for the chart. Click ‘Next’ button Click on “Titles” tab, type Chart Title, Category (X) axis, Value (Y) axis, and then click ‘Next’ button. Select a location to place your chart. E.g. “As new sheet” or “As Object in…” option. Click ‘Finish’ when you are done. ©Radiology Informatics FORMATTING CHARTS You can modify your chart by using the Chart toolbar. Click on a down arrow beside “Chart Object” tool Select the object you wish to format. E.g. Legend Click on “Options” tool Select the tab you want, E.g. Pattern, Font e.t.c. Note; Under Pattern Tab, select the options you want, E.g. Border Style, Border Color, Border Weight, Shadow, Area (Fill) color or using Fill Effects colors. Click on “Ok” button when you are done. ©Radiology Informatics Hands on Practice Use the data above to create a 3D bar chart type Format the chart as much as you can ©Radiology Informatics Hands on Practice Copy the data as shown below and create a pie chart then answer the questions on the next slide ©Radiology Informatics Hands on Practice Using the data and the chart above do the following. Change the chart above to Cylinder chart type. Remove the data for UCC-Dodoma. Does the data in the chart changes? Change the data label of pie chart to percentage values SCOPE OF COMPUTER INFORMATION SYSTEM Computer information system(CIS) encompasses the broad fields of using technology to manage and process information for business and organizational purposes. Essentially CIS focus on how technology can be leveraged to improve efficiency, decision making and strategic initiatives with organizations. ©Radiology Informatics