Download CDMG 1150 Office Applications Course Description and more Lecture notes Operating Systems in PDF only on Docsity!
CDMG 1150 Office Applications
Course Description Orientation and operating procedures as practiced in the graphic communications industry by managers on a computer operating system. Proper operating system and menu terminology and definitions for working knowledge of: desktop organization, necessary applications and equipment for production management and customer service. Basic theory and use of office computers and menus for word processing, spreadsheet, database and presentation applications. Practice of proper start-up, file operations and maintenance procedures. Analysis and application of sets of data as practiced in the graphics arts industry by studio managers on a computer operating system, such as the Macintosh operating system.
2 cl hrs, 2 lab hrs, 3 cr
Prerequisite: CUNY Certification in reading, writing and mathematics
Course Objectives
New York City College of Technology The City University of New York
Department of Advertising Design and Graphic Arts
INSTRUCTIONAL OBJECTIVES ASSESSMENT
For the successful completion of this course, students should be able to:
Evaluation methods and criteria:
Define and clarify terminology for applied concepts, theory, ethics, and applications for graphic arts management office systems.
Use of appropriate and accurate terminology through homework, quizzes and presentations.
Identify and determine critical comparisons among various office system applications.
Use of appropriate and accurate specifications through homework and presentations. Describe the underlying principles and concepts essential for managing various office system applications.
Presentation of original material through research and presentations.
Learning from an engaging challenging resource material from which a student will interpret appropriately and accurately in his/her own words.
Citation and documentation of supporting material.
Evaluate a set of data and create information Students will display critical thinking with
graphics (slides) from those data sets. applied techniques for data analysis, and will display competence in creating visual solutions from that data.
Create a cohesive desktop presentation using programs such as Keynote and PowerPoint incorporating the information graphics and data sets collected in class, in addition to secondary sources.
Students will display basic proficiency in creating slideshow presentations from data they have organized.
General Education Outcomes
General Education Outcome covered: How the Outcome is covered:
The student will demonstrate the ability to read pertinent information using industry-specific sources.
The student will use the textbook to reinforce what is learned during class lectures and apply both to their homework assignments.
The student will demonstrate the ability to find proper resources.
The student will use the library, Internet, and other available resources to find information for their research project. The student will demonstrate an understanding of quantitative methods needed to interpret data.
Students will demonstrate the ability to work with large sets of data to create their research projects.
Teaching/Learning Methods Students in this class are expected to explore, construct and demonstrate knowledge of the technology, terminology, skills, tools, policies and procedures to understand the applied theory and manage graphic arts office systems. Students are expected to work individually to document, analyze and apply learning about office system applications.
Required Text
Problem Solving Cases in Microsoft Access and Excel [10 th^ Edition] By Ellen Monk, Joseph Brady Gerard S. Cook
Suggested Texts All-in-One Desk Reference, Microsoft Office Excel 2010 , by Greg Harvey, PhD. Published by Wiley Publishing, Inc.
Plain Simple, Microsoft Office Access 2010 , by Curtis D. Frye, Published by Microsoft Press
(^2) Topics in social media
and cloud computing. Introduce students to FTP/Cloud Storage functions such as uploading, sharing, and storing files, on services such as Google Drive, Dropbox, WeTransfer, and Yousendit. Introduce students to professional uses of social media such as Twitter, LinkedIn, Facebook, Facebook Pages, and more.
Go to cloud file-sharing service web portals. Open an account and demonstrate usability and navigation for uploading, downloading, and sharing files in a professional setting. Show case studies demonstrating best practice.
Go to social media sites and demonstrate how they are used by companies. Open a LinkedIn account and upload resume.
Write a one-page critical analysis of bad and good use of social media by Companies, citing specific cases. Provide students with examples.
Begin database project with dataset provided by instructor.
3 Introduction to basic formatting in Microsoft Word. The use of font terminology, style, size, color and case. How to differentiate between first line indent marker and the left indent marker. The use of measurements in the point system and their applications. Advanced formatting and editing. How to copy and paste between documents, word count command, footnotes and printing in portrait and landscape orientation.
Changing fonts, style, size, color and case of text. The use of the point system in the selection of fonts. Alignment of text, indents, sort, auto formatting, page breaks, headers and footers. Copy and paste between multiple documents. Work with multipage documents, printing in portrait and landscape orientation. Give students 4-5 different types of text, such as a cover letter, an RFP, and have them format the text properly.
Assigned reading on Microsoft Word. Finish reformatting provided text to specific styles. Due week 3. This is not a design project.
(^4) Demonstrate how to
use a worksheet. How to enter data into an
Move the highlights in a worksheet, select cells and enter data, save a worksheet,
In a document provided by instructor, add highlights, select and
existing worksheet, change column width and enter data, change change the appearance edit cells. Change the formats and appearance. of cells in the worksheet appearance of cells and print (^) Read, “Tutorial C: by boldfacing, a worksheet. Adding pages (^) Building a Decision underlining, and adding to a worksheet. (^) Support System in a border. (^) Excel.”
(^5) Moving data in a
worksheet. Insert and delete columns and rows, freeze titles, protect the worksheet and use print options. QUIZ #
Copy data to other cells, move data to other cells, insert and delete rows and columns, freeze titles, protect a worksheet, insert a note into the worksheet and the use of options when printing a worksheet.
Importing images and graphics into a worksheet.
In a document provided by instructor students must rearrange date, edit rows and columns, freeze titles, protect a worksheet, insert a note, and print document for week 5. Read, “Case 6: Future Cars, Inc. Product Strategy Decision,” and “Case 7: The Health Care Coverage Decision at Big Dog Collars.”
(^6) Worksheet formulas.
How to use simple formulas, complex formulas and function formulas. Construct formulas, calculate values, and update the total value.
Enter and edit formulas, distinguish among relative, absolute, and mixed cell references. AutoSum function and the Point-and- Click method of entering formulas. Display formulas in a worksheet, perform immediate and delayed calculations and the use of function formulas.
In a document supplied by instructor, students will demonstrate knowledge of formulas and tabulation.
(^7) Create charts from
data contained in the worksheet. Create column, line, pie, and scatter charts using the Chart Wizard. Use the same data displayed in
Create different types of worksheet charts. Switch between charts and worksheets, zoom, and rename a chart. Preview and print chart. Edit a chart and
Read, “Part 3: Decision Support Cases Using the Excel Problem Solver,” and “Tutorial D: Building a Decision Support System Using
data in a database. Using GPS data. Process of creating and Making labels remotely. modifying a report. Reports: Create a Groups/Totals Creating and using report using the Products table. macros for database management. Adding actions to a macro.
Sort by product name. Create a macro to open the Products table. Print all pages.
(^11) Basic PowerPoint.
Start PowerPoint, open an existing presentation, apply a design template. Change a slide layout; add a slide; change views and print; exit PowerPoint. QUIZ #
Opening an existing presentation, use the status bar; apply a template, changing a slide layout. how to add a slide, change views and print a presentation and exiting PowerPoint.
(Assigned Reading on PowerPoint Basics.)
12 Creating a new presentation. Slides, outlines, speakers notes and audience notes, delete slides, add text to slides, use the Pick a Look Wizard.
Create a presentation using wizards and templates, using the AutoContent wizard, deleting slides, adding text to slides, using the pick a look wizard and printing a presentation.
Collate data and create graphics for Final Presentations.
13 Show Keynote, Acrobat and InDesign as industry-standard desktop presentation tools. More Powerpoint Presentation of Final Projects: Part 1.
Create and export a slideshow from InDesign, and Acrobat Pro.
Prepare final Presentations.
14 Presentation of Final Projects: Part 2. QUIZ #4 – Take-home quiz
Oral presentations with slideshow presentations.
Review for Final Examination.
(^15) Final Examination. Complete and submit projects
on PowerPoint.
