Introduction to Information Technology and Processing
Introduction to Information Technology and Processing MIS 1305
Popular in Course
Lexie Brakus V
verified elite notetaker
verified elite notetaker
verified elite notetaker
verified elite notetaker
verified elite notetaker
verified elite notetaker
Popular in Management Information Systems
This 6 page Class Notes was uploaded by Lexie Brakus V on Saturday October 3, 2015. The Class Notes belongs to MIS 1305 at Baylor University taught by Karen Moore in Fall. Since its upload, it has received 37 views. For similar materials see /class/217921/mis-1305-baylor-university in Management Information Systems at Baylor University.
Reviews for Introduction to Information Technology and Processing
Report this Material
What is Karma?
Karma is the currency of StudySoup.
You can buy or earn more Karma at anytime and redeem it for class notes, study guides, flashcards, and more!
Date Created: 10/03/15
Review Sheet Exam 2 Moore Fall 2010 Excel Workbook Worksheet Rows and columns Cell active cell Cell addresses Fill handle Ranges Formula bar Name box Naming worksheets Purposes of excel what you can do with it Moving around scientific notation Truncated Text How Excel handles dates Merge cells Wrap text Changing column row width height Hiding columns and rows Splitting into panes Freezing panes p 220 Autofill Moving data Data sorting Page setup Building formulas Using the sum function Ranges Relative and Absolute addressing referencing Inserting and deleting rows and columns 4 ways to edit cells Paste special p 76 Goal seek p 523 Complex formulas Auditing tools p 500 Formatting Alignments Number formats Borders fill Cell styles adding data bars Inserting manual page breaks Printing setting a print area centering vertically fit to one page Show formulas Order of precedence Protecting a worksheet p 414 Interpolate and extrapolate p 480 Math functions Sum SUMIF Statistical functions Average Median Mode Min Max Count Counta Date and Time functions Today Now Financial functions FV PV NPV PMT IPMT PPMT SLN SYD DDB NPER RATE IRR Logical functions lF AND OR Nested f VLOOKUP Study suggestionsReadings from your textbook For Introduction and definitions Tutorial 1 Forformatting Sam assignment 5 Tutorial 2 For formulas and functions Tutorials 3 and 9 Chapter 3 statistical functions p 122 date functions p 145 time value of money p491 PMT IPMT PPMT and amortization p 468 NPV function p 493 Depreciation p 481 IF p 141 AND p 343 OR p 352 VLOOKUP p 355 Work through all examples from class including labs 3 4 and 5 Include the files on Blackboard called class examples for Excel complex formulas Lookup class examples and Definitions of Financial concepts Review Sheet for Exam 3 Fall 2010 Moore ChartsTutorial 4 in Excel text Data series Category Category axis Value axis Category namesaxis labels Data series nameslegend Data point Data marker Embedded charts Dynamically linked Best uses for different chart types Tips for creating effective charts Formatting charts Adding labels and titles Moving charts to different locations Switching data from rows to columns Changing chart type PivotTablesTutorial 5 in Excel text Purpose of a PivotTable Database hierarchy Definition of field record database file Fieldcolumns Recordsrows Steps in creating a PivotTable Areas of the screen when creating a PivotTable Classic PivotTable layout Selecting the range Row fields area of report Column field area of report Data items value area of report Changing the field settings Formatting numbers Adding fields to the value area Pivoting values from columns to rows Adding and removing report totals Adding a calculated field Sorting within a PivotTable Filtering with in a PivotTable Purpose of refresh icon Pivot ChartsTutorial5 Inserting a Pivot Chart Linked to the PivotTable Adding fields to the area section of the field list Changing the field settings Formatting the chart Filters Tu torial 5 Applying a filter Using the custom filter Hidden rows Restoring the database Sorting and SubtotalsTutorial 5 Need to sort before adding subtotals Sort dialog box Collapsing the database to different subtotals levels Removing the subtotals Access Tutorials 14 in Access text Definition of DBMS database Data dictionary Table Query Report Form Primary Key foreign key Navigation pane Opening a new database Creating a new table Table design view Datasheet view Common data types Editing data Adding a field Renaminga table Importing data from Access and Excel Linking data from Excel Creating a query using the Query Design icon Record set Adding the Totals row Using the criteria and sort rows Using the Property Sheet Saving tables and queries Referential integrity Data redundancy Select Nested advanced and crosstab queries When to choose Access vs Excel Guidelines for good table design Custom fields calculated fields Creating formulas Using F FV PMTfunctions Expression builder Difference between labels and text boxes in reports 5 areas of the report design grid and their purpose Material to Study Review Labs 611 charts pivot tables tables queries functions reporting Study examples from the Excel and Access texts and class examples for pivot tables Go over notes from Powerpoint shows Charts Pivot Tables Access Access Formulas and Functions and Access Reporting Review Sheet for Exam 3 Fall 2010 Moore ChartsTutorial 4 in Excel text Data series id s the data series the name becomes the legend range and values with 3 components series namesvalues category values Category Category axis horizontal axis xaxis are the data series category values or xvalues Value axis vertical axis yaxis for example data values such as sales values are plotted Category namesaxis labels Data series nameslegend DS the chart wizard organizes data sources into a collection where each data series is a range of data values that is plotted as a unit on the chart legend used to identify the format of the data marker used for each series is a chart Used if the chart contains more than 1 data series Data point Data marker the graphical representation ofvalues in the data series ofa chart including items such as each column in a column chart the pie series in pie charts and points in XY chart DP each value in worksheet DM represents data point in the chart column top line symbol pie slice Embedded charts a chart that is displayed within a worksheet and one that you can place alongside the data source giving context to the chart Dynamically linked Best uses for different chart types 5 steps to creating a chart 1 identify the data that will be used to define xy axis 2 select chart type highlight the appropriate cells 3 select chart format 4 specify location 5 add andor adjust the chart and access titles Tips for creating effective charts limit details descriptive titles consistent categories special effects arrows text boxes etc watch out for 3D charts moderate gridlines limit text styles no more than 2 limit number of data series linecolumnno more than 34 pie chartno more than 6 Formatting charts Adding labels and titles Moving charts to different locations cutpaste embedded chart in Location group on Chart Tools Design tab click Move Chart button click quotobjects inquot Pie Chart ltlgt Switching data from rows to columns Changing chart type PivotTabesTutarial 5 in Excel text Purpose of a PivotTable store and update data sort data search and retrieve subsets of data create reports Database hierarchy data is made up of characteristics related characterfield related fieldsrecord related recordsfile related filesdatabase Field columns an attribute on characteristic of a reason place or thing last name city st in excel each column represents a field Represents an attribute or measurement of some object or event Record rows a collection of related tables that are grouped together in excel n excel each row represents a record Database a collection of related tables stored in the same file File a collection ofdata that has a name and is stored in a computer aka document Steps in creating a PivotTable familiarize yourselfw database visualize place active cell somewhere in data and click on quotpivot tablequot icon on insert ribbon under pivot table click quotclassic PT layoutquot click and drag field names to page field row column etc Areas of the screen when creating a PivotTable PT Field List list of column headings PT Report area used to construct and analyze the results PT Tools commands found on the ribbon under options and design tables used to adjust the settings and appearance of a PT Classic PivotTable layout row labels the fields you want to display as the rows in PT One row is displayed for each unique item column labels the field you want to display as columns as top of PT One column is displayed for each unique item report filter a field used to filter the report by selecting one or more items Enables you to display a subset of data values the fields you want to summarize Selecting the range Row fields area of report Column field area of report Data items value area of report Changing the field settings Formatting numbers 1 click any cell in column of PT report 2 click quotPT Tools Option tab on ribbon in active field group click quotField Settingsquot Box opens 3 click quotNumber Format Adding fields to the value area in PT list click quotLocationquot check box Click the quotAppraised Value check box in PT field list Pivoting values from columns to rows Adding and removing report totals Addinga calculated field Sorting within a PivotTable use any Sort button on Options tab Filtering with in a PivotTable click in PT the field arrow button that represents the data you want to hideshow Purpose of refresh icon can t change data directly you edit Excel table quotrefreshquot to update to have PT reflect current state Pivot ChartsTutorial 5 Inserting a Pivot Chart 1 click any cell in PT in Tools group click quotPivot Chart 2 click quotClustered Column Linked to the PivotTable Adding fields to the area section of the field list Changing the field settings Formatting the chart Axis Labels category names FiltersTu torial 5 Applying a filter Using the custom filter Hidden rows Restoring the database Sorting and SubtotalsTutorial 5 Need to sort before adding subtotals Sort dialog box Collapsing the database to different subtotals levels Removing the subtotals Access Tutorials 14 in Access text Database organized collection of reflected data in tables queries reports etc Database Management System DBMS package of computer programs and documentation that lets you establish and use a database that is made up of several reflected tables Relationships between tables are formed using a common field Data dictionary document that contains a list of tables that are designed and maintained for the business Table the part of the database that holds the data similar to a 2D table in which columns are fields and rows are records Content of fiedfield value Query set of conditions that provides for retrieval of certain records from a table Report provides the specification for output of data in a tabular format Form customized manner of inputting data into a database Primary Key uniquely identifies each record Foreign Key field in one table that also is stored in a different table as a primary key Navigation pane the area on the left of the program window that fits all the objects in the database Opening a new database cick quotblank database Creating a new table 1 Click quotcreatequot tab on ribbon 2 in tables group click Table button Table design view Datasheet view shows tables contents as a datasheet in rows and columns Common data types Editing data Adding a field must insert a row seect field that will be below the new field in tools group on Table Tools Design tab click quotInsert Row Renaming a table design view put insertion point under field name of Importing data from Access and Excel cick Import click quotExternal Data tab on nbbon Linking data from Excel Creating a query using the Query Design icon Record set set of records that results from running a query Adding the Totals row Using the criteria and sort rows Using the Property Sheet Saving tables and queries Referential integrity set of values that ensure that data stored in related tables remain consistent or the data are updated Data redundancy occurs when unnecessary duplicate info exists in database Select Nested advanced and crosstab queries Select Query basic simplify the fields and records you want Access to select and results are returned in form ofdatasheet Nested Query building a query from a query rather than a table Advanced Query using reveal comparison options to expand the types of criteria Crosstab Query used for evaluating trends over a period of time by placing data into a 2D table When to choose Access vs Excel Access relational database required multiple tables large amounts of data relying on external database need to remain converted to external database a lot of people working on database at one time Excel a flat database is needed mostly numeric run calculation and statistical comparisons data lt 15000 records Guidelines for good table design Custom fields cacuated fields Creating formulas Using F FV PMT functions Expression builder Difference between labels and text boxes in reports 5 areas of the report design grid and their purpose Material to Study Review Labs 611 charts pivot tables tables queries functions reporting Study examples from the Excel and Access texts and class examples for pivot tables Go over notes from Powerpoint shows Charts Pivot Tables Access Access Formulas and Functions and Access Reporting Review Sheet MIS 1305 Moore Fall 2010 Exam 1 O ice 07 Saving files in Of ce 07 Ribbon Of ce button Tabs and contextual tabs Dialog box launcher Galleries Live preview XIVIL and its advantages Shortcut ways to execute commands Purpose of the Alt key Use of the copy and shift keys Root directory and path Aero Snap Libraries or 3 steps in word processing Direct v indirect formatting Purposes of the 5 views in Word Ways to select text 3 levels of formatting Difference between serif and sans serif fonts Difference between proportional and nonproportional fonts examples by font names Leading character spacing What the showhide button turns on off Design rules for formatting at the character and paragraph level Format painter Identify the elements of the ruler Tab leaders Purpose of a table Tables are built by rows Ways to create a table Ways to move around a table Adjusting row and column height and width Deleting in a table Formatting a table Scaling and cropping images Purpose of a column Creating columns Inserting a continuous break to balance columns Optimum word width for columns Expect a few questions about the material that was on your two SAM assignments about Word The Internet De nition who is in charge Packet switching Protocol TCPIP ProtocolDomain nameTLDPath Ways to connect to the Internet Chapter 1 Bene ts and disadvantages of a digital society Digital divide Von Neumann s de nition of a computer Difference between systems software and application software De nitions of data v information Criteria used to categorize computers Bit byte ASCH Unicode Parity bit How graphic data is represented by bytes Criteria used to separate the generations of computers Input and Output How does a keyboardmouse work Speech recognition MIDI MICR OCR RFID LCD CRT Plasmai advantages and disadvantages Passive vs Active matrix Resolution Dot pitch Refresh rate response rate Inkj et printers v laser printers Thermal printers What determines printer quality Processing and Storage Motherboard CPU ALU control unit Know the machine cycle What determines a CPU s processing power System clock and clock speed Cache memory Registers Word size Bus width ROM CMOS BIOS POST Purpose of RAM what is stored in RAM DRAM v SRAM Virtual memory Magnetic storage 7 tracks sectors clusters What is perpendicular recording Defragmentation NTFS Optical storage 7 CD and DVD What is a head crash What is cloud storage Access time how measured Moore s Law Dualcore processing dual processing Pipelining Parallel processing Different kind of ports Materials to Study Chapters 1 2 4 5 6 and 7 from custom text PowerPoint Shows Chapter 1 the Internet Input and Output Processing Storage Of ce 07 and Windows 7 Wor You may want to review the SAM assignments Assn 4 is available and Assn 2 Training is available
Are you sure you want to buy this material for
You're already Subscribed!
Looks like you've already subscribed to StudySoup, you won't need to purchase another subscription to get this material. To access this material simply click 'View Full Document'