Search
Purdue School of Engineering and Technology

Purdue School of Engineering and Technology

Using A Personal Computer

CIT 10600 / 3 Cr.

(Class 2, Lab 2; or Class 3.) This course provides an introduction to word processing, spreadsheet, and presentation software. It also includes instruction in basic computer concepts, Windows operating systems, the Internet, collaborative tools and database concepts. Applications are taught through the use of problem solving assignments, projects, and exams.

Software
  • Microsoft Office
Outcomes

Course Outcomes (What are these?)

  • Use the basic functions of an operating system and its built-in tools (CIT a)
  • Use internet tools necessary for productivity (CIT a)
  • Use word processing software for academic, personal, and professional use (CIT a, f)
  • Use electronic spreadsheet software for academic, personal, and professional use (CIT a)
  • Create and manipulate data in a database table (CIT a)
  • Use presentation software for academic, personal, and professional use (CIT a, f)

CIT Student Outcomes (What are these?)

(a) An ability to apply knowledge of computing and mathematics appropriate to the program’s student outcomes and to the discipline.

(f) An ability to communicate effectively with a range of audiences.

Topics
  • Course management system, collaboration, cloud storage
  • Operating System (Windows and File Management)
  • Internet/World Wide Web
  • Create professional documents using word processing software
  • Use text, values, formulas, and functions in spreadsheets
  • Use flat databases
  • Use presentation software to create a presentation
  • Integrate applications
Principles of Undergraduate Learning (PULs)

1a.  Communicate effectively in a variety of formats, particularly written, oral, and visual formats.

1b.  Identify and propose solutions for problems using quantitative tools and reasoning.

1c.  Make effective use of information resources and technology.

What You Will Learn

Course management system, collaboration, cloud storage

  • Acquire a username and password
  • Navigate through course management system
  • Access course email, announcements, syllabus, schedule, assignments, and gradebook
  • Download files
  • Attach (upload) files in course management system
  • Use IU’s cloud storage (Box)
  • Collaborate via cloud storage
  • Access software from iuware and iuanyware

Operating System (Windows and File Management)

  • Identify objects and icons on the Windows desktop
  • Open icons into windows
  • Identify common Windows components
  • Define a common user interface and explain why it is so important
  • Open multiple windows onto the Windows desktop
  • Use the taskbar to task switch between multiple open windows
  • Move and size windows
  • Format a drive
  • Shut down the computer
  • Identify the root directory
  • Create folders and subfolders
  • Move, copy, delete and rename files and folders
  • Display file extensions
  • Search for files by file name and text within a file
  • Select multiple files or folders in one window
  • Use the recycle bin
  • Access files from storage device or cloud storage
  • Compress or zip and decompress or unzip files and folders
  • Use Windows Help

Internet/World Wide Web

  • Use Internet Explorer as the browser in class
  • Use hyperlinks
  • Use favorites and history
  • Conduct Internet searches using search engines
  • Refine Internet searches using Boolean logic including the operators AND, OR, and NOT, plus (+) and minus (-)
  • Identify these abbreviations: isp, url, html, http, https, and www
  • Identify and evaluate reliable Internet resources for research
  • Locate resources for virus protection
  • Explain the differences between a web page, home page, website, and domain name
  • Download files from a website
  • Identify public domain sites
  • Explore copyright issues and understand "fair use"

Create professional documents using word processing software

  • Identify the screen parts
  • Create a new document
  • Use word wrap
  • Use insert &overtype mode
  • Use undo &redo to reverse actions
  • Use spell check, thesaurus, and grammar check
  • Use autocorrect
  • Select text and objects
  • Find and replace text
  • Print documents and use print preview
  • Save, open and close a file
  • Format text using character formats such as bold, italic, underline, shading, borders, font, font size, bullets/numbering
  • Use the format painter to format text
  • Use paragraph formatting to set line spacing, left, right, hanging indents, and tab stops
  • Use Undo/Redo to reverse actions
  • Use spell check, thesaurus, and grammar check
  • Use page setup to change margins
  • Find and replace text
  • Move (cut & paste) text
  • Copy (copy & paste) text
  • Convert text to newspaper-style columns
  • Insert symbols
  • Insert clip art and pictures
  • Use the drawing toolbar
  • Download files from a website
  • Insert downloaded files into an application
  • Copy from internet to an application
  • Copy a url to an application and create a hyperlink
  • Cite Internet resources in observance of copyright laws and understand "fair use"
  • Save a file in html format
  • Insert a footnote
  • Format text using bulleted, numbered, and outline numbered lists
  • Use page setup to change page layout
  • Insert headers and footers with auto codes for file names, page numbers, dates, etc
  • Create and edit tables: insert and delete rows and columns, set table properties, merge & center a row
  • Insert page breaks and section breaks
  • Insert footnotes

Use text, values, formulas, and functions in spreadsheets

  • Identify the screen parts
  • Provide worksheet documentation identifying the creator, date of creation, and purpose of spreadsheet
  • Navigate workbooks and worksheets using keyboard and mouse
  • Distinguish between workbooks and worksheets
  • Create and edit labels and values
  • Use arithmetic expressions (formulas)
  • Use functions: sum, average, min, max, today
  • Write a formula or function using cell address and no raw numbers
  • Use print and print preview commands
  • Change page setup to include gridlines, row and column headings, portrait or landscape, fit to 1 page, headers and footers
  • Change column and/or row width and height
  • Format cells for number, alignment, font, border and pattern, etc.
  • Write a formula or function using cell address and no raw numbers
  • Create an assumptions area for raw numbers so no raw numbers appear in formulas
  • Use relative and absolute references effectively
  • Use the fill handle to copy cells to adjacent area
  • Use the math order of operations to write percent-of-change formulas
  • Save Excel files in a different file format
  • Freeze and unfreeze window panes
  • Hide and unhide rows and columns
  • Use the function wizard to create an IF function with text responses
  • Use statistical function =max to find maximum value in a range
  • Use statistical function =min to find minimum value in a range
  • Use statistical function =average to find average value in a range
  • Merge and center text across a range of cells
  • Display formulas on the worksheet
  • Create a graph that could stand alone on its own if the spreadsheet were not present as supporting documentation
  • Create a graph using the chart wizard
  • Select spreadsheet data in adjacent and nonadjacent ranges
  • Use the column, line, pie or bar chart types
  • Move and size the graph
  • Edit a graph and change features such as line color, column style, background, etc.
  • Update spreadsheet numbers so it is reflected in the graph

Databases

  • Add, delete, move and edit fields and records in existing table and form objects
  • Navigate to and through existing table, form, query, and report objects
  • Create relationships between 2 existing tables, enforce referential integrity and cascade updates and deletes
  • Sort data in a table in both single and multiple columns
  • Filter by selection and form
  • Create a flat database known as one-table database
  • Create a table using the design view
  • Create a table using the wizard
  • Name tables and forms
  • Define field properties
  • Identify a primary key
  • Add a validation rule to enter data
  • Create an input mask to enter data
  • Create a form using the wizard
  • Edit the form layout in design view
  • Understand the difference between data and information
  • Create queries from one or more tables in a database
  • Create queries using design view
  • Create queries using the query wizard
  • Create queries with multiple criteria
  • Create queries using Boolean logic
  • Sort data in query
  • Filter data in a query
  • Create reports using the report wizard
  • Add headers and footers to a report
  • Name queries and reports
  • Get external data from an Excel spreadsheet
  • Convert the database to another format
  • Compact and repair a database

Use presentation software to create a presentation

  • Identify PowerPoint screen parts
  • Use good design principles
  • Use slide, notes, outline, slide show, and dual pane views
  • Move, copy and delete slides
  • Promote and demote text
  • Create a new slide
  • Choose slide layouts
  • Change templates
  • Use multiple templates in a file
  • Print black and white, slides, handouts, notes, and outlines
  • Insert, create edit, format, move, delete and size objects including pictures and clip art
  • Use drawing toolbar
  • Align and group objects
  • Apply animation to text and objects
  • Apply transitions
  • Use good design principles
  • Cdit a slide master to make global changes to a presentation
  • Create and edit a PowerPoint table
  • Navigate a slide show
  • Import a Word outline
  • Save a file in web page format
  • Create headers and footers
  • Create a hyperlink to another file or an Internet website
  • Add speaker notes to the notes pages

Integrate applications

  • Copy material within and between applications
  • Link material within and between applications
  • Hyperlink material within and between applications
  • Copy a URL to an application
  • Downloading a graphic from the Internet and insert it into an application