it120 - fit - presentation jan 8 2013
DESCRIPTION
The presentation that I went through January 8, 2013TRANSCRIPT
![Page 1: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/1.jpg)
Focus on Information TechnologyInformation Technology 120
January 8, 2013
![Page 2: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/2.jpg)
Information Technology 120
IT120 BOM
CS ENT TS DT
![Page 3: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/3.jpg)
The Big Ideas of IT120 (GCOs)IT Perspective
ICT Project Management
Software Applications
![Page 4: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/4.jpg)
GCO #1 – IT PerspectiveStudents will understand key IT
function components and how they contribute to enterprise effectiveness
Throughout the 18 weeks
![Page 5: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/5.jpg)
GCO #2 – ICT Project MgmtStudents will apply formal project
management knowledge, principles and practices during the project lifecycle
Managements of resources, time, cost, quality, risk and communication
Throughout the 18 weeks
![Page 6: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/6.jpg)
GCO #3 – Software Applications
Word Processin
g
Spreadsheet
Desktop Publishing
Presentation
Database
![Page 7: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/7.jpg)
GCO #3 – Software Applications
Word Excel
Publisher PowerPoint
Access
![Page 8: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/8.jpg)
GCO #3 – Software Applications
Writer Calc
Desktop
Publishing
Impress
Base
![Page 9: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/9.jpg)
GCO #3 – Software Applications
Word Excel
Publisher PowerPoint
Access
20
20
12
16
12
![Page 10: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/10.jpg)
Top Course ObjectivesPrepare students to apply their
knowledge to real-world, unpredictable situations
Engage studentsPromote student-led exploration
![Page 11: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/11.jpg)
Access to the CourseADD SCREENSHOT OF JAMIE
O’TOOLE’S SITE
![Page 12: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/12.jpg)
FOR NOW… PBWORKSThanks to Kim Black
![Page 13: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/13.jpg)
Example of PBL Assignment
![Page 14: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/14.jpg)
The Point…You should have enough to get
you through the course without having to reinvent the wheel
Students should be able to adapt the assignments/projects to different versions of Word or even OpenOffice/GoogleDocs
![Page 15: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/15.jpg)
Tutorial Videos
In Production
![Page 16: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/16.jpg)
Tutorial Presentations
![Page 17: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/17.jpg)
PBL Assignments
![Page 18: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/18.jpg)
IT Perspective (GCO #1)This should be evident during the
duration of the course◦Understand key IT function
components Programming concepts using a structured
language Macros with Visual Basic for Applications (VBA)
Especially in Word and Excel Excel Formulas
KNOW
![Page 19: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/19.jpg)
IT Perspective (GCO #1)
◦Understand key IT function components Testing and Documentation Concepts
Macros with Visual Basic for Applications (VBA) Especially in Word and Excel Excel Formulas
KNOW
Testing Macros Testing
Formulas
Documentation of Procedures
![Page 20: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/20.jpg)
IT Perspective (GCO #1)
◦Programming and Testing Concepts Understand technical and operational
safeguards required to protect information Teacher-led instruction at the beginning of the
course File Management Protecting Data Concept of off-site storage of information,
cloud-computing Project-Based Learning reinforcing the concept
KNOW1.1
![Page 21: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/21.jpg)
IT Perspective (GCO #1)
◦Programming and Testing Concepts Understand technical and operational
safeguards required to protect information Project-Based Learning reinforcing the concept
Identify problems that can be addressed by applications
Evaluate/compare technical and operational safeguards to protect information
Debug problems Conduct simple tests at the application level
DO1.1
![Page 22: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/22.jpg)
IT Perspective (GCO #1)
◦Design/Manage Info and Databases How to Use Data to Create/Organize Info
Teacher-led instruction throughout to reinforce this Create and Organize Information Basic Project Management Concepts The Project Lifecycle Role of the Project Manager The Concept of a Platform
KNOW1.2
![Page 23: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/23.jpg)
IT Perspective (GCO #1)
◦Design/Manage Info and Databases How to Use Data to Create/Organize Info
The PBL will be more evident when using Access Manipulate an existing database
In other applications, manipulating info will happen
Basic understanding of databases and database management
Define the need for computing infrastructure and be able to perform basic platform procedures The bulk of the course
DO1.2
![Page 24: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/24.jpg)
IT Perspective (GCO #1)
◦ Understand Key IT Functions/Components Types of ICT Work
Teacher-led instruction or PBL Types of ICT work IT occupations in Canada Where/How different parts of the IT function
interacts with enterprise effectiveness
KNOW1.3
![Page 25: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/25.jpg)
IT Perspective (GCO #1)
◦ Understand Key IT Functions/Components Types of ICT Work
The PBL could be accomplished in Publisher/PowerPoint Types of ICT work (research)
Marked against a rubric IT occupations in Canada (research) Where/How different parts of the IT function
interacts with enterprise effectiveness Interviews with IT professionals from
community
DO1.3
![Page 26: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/26.jpg)
ICT Project Management (GCO #2)
◦ Apply Formal Project Mgmt Knowledge What is Project Management?
Why Project Management Aptitude is an Important Skill to Acquire in any enterprise
How Projects are Planned and Executed How to Plan a Project in Detail How to Cost Out a Project and Understand its
Importance
KNOW2.1
![Page 27: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/27.jpg)
ICT Project Management (GCO #2)
◦ Apply Formal Project Mgmt Knowledge What is Project Management?
Why Project Management Aptitude is an Important Skill to Acquire in any enterprise
How Projects are Planned and Executed How to Plan a Project in Detail How to Cost Out a Project and Understand its
Importance
DO2.1
Presentation
Research on MS Project
Interview with Project Mgr
![Page 28: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/28.jpg)
Software Applications (GCO #3)
The Meat and Potatoes of the Course
![Page 29: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/29.jpg)
Software Applications (GCO#3)
20
2012
16
12
Days
WordExcelPublisherPowerPointAccess
![Page 30: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/30.jpg)
Software ApplicationsFlexible enough to provide
enough rigor to prepare interested students for MOS certification
Interesting enough to attract a wide range of students
Basics should be familiar enough for many students to help them learn more about each application in-depth
![Page 31: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/31.jpg)
Word Processing (20 days)Create/format/customize
documentsPersonalize the applicationOrganize documents/content to
make them easier to find
![Page 32: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/32.jpg)
Word Processing (20 days)Formatting content
◦Text◦Paragraphs◦Pages
Manipulate textControl pagination
![Page 33: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/33.jpg)
![Page 34: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/34.jpg)
![Page 35: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/35.jpg)
![Page 36: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/36.jpg)
![Page 37: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/37.jpg)
![Page 38: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/38.jpg)
Word Processing (20 days)Work with Visual Content
◦Insert/Format Illustrations and Images Problem solving (editing externally) Copyright implications
◦Format Text Graphically Leading up to the desktop publishing
section
◦Insert/modify text boxes, shapes, symbols
![Page 39: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/39.jpg)
Word Processing (20 days)Organize Content
◦Structure content using Quick Parts◦Use tables and lists to organize
content◦Modify/troubleshoot tables◦Insert/format references and
captions◦Merging documents and source data
into documents
![Page 40: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/40.jpg)
Word Processing (20 days)Reviewing Documents
◦Navigating through documents◦Comparing documents (review)◦Merge document versions◦Manage tracked changes◦Insert/modify/delete comments
![Page 41: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/41.jpg)
Word Processing (20 days)Sharing and Securing Content
◦Prepare documents for sharing◦Converting to PDF, RTF, others◦Control document access
(passwords)◦Attach digital signatures
◦Emailing to classmates / publishing
![Page 42: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/42.jpg)
![Page 43: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/43.jpg)
![Page 44: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/44.jpg)
![Page 45: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/45.jpg)
Spreadsheet (20 days)Creating and Manipulating Data
◦Insert Data using AutoFill◦Ensuring Data Integrity◦Modify Cell Content and Format◦Change Worksheet Views◦Manage Worksheets
![Page 46: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/46.jpg)
![Page 47: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/47.jpg)
Spreadsheet (20 days)Format Data and Content
◦Formatting Cells and Worksheets◦Inserting rows/columns◦Formatting Cell Content◦Format Data as a Table
![Page 48: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/48.jpg)
Spreadsheet (20 days)Creating/Modifying Formulas
◦Basics of formulas◦Basic functions◦Absolute / Relative Cell Referencing◦Summarizing Data◦Conditionally Summarize Data◦Look Up ◦Format/Modify text based on formula◦Display and Print Formulas
![Page 49: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/49.jpg)
Spreadsheet (20 days)Presenting Data Visually
◦Create/Modify/Format Charts◦Conditional Formatting re: charts◦Insert/Modify Illustrations◦Outline Data◦Sort/Filter Data
![Page 50: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/50.jpg)
![Page 51: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/51.jpg)
Spreadsheet (20 days)Collaborating and Securing Data
◦Manage changes to workbooks◦Protect/share workbooks◦Prepare workbooks for distribution◦Set Print Options for Printing
Data/Worksheets/Workbooks◦Linking Data between Office
applications
![Page 52: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/52.jpg)
Desktop Publishing (12 days)
![Page 53: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/53.jpg)
Presentation ApplicationsStudents will research and
develop effective presentation techniques◦Create and format presentations
Slide Masters (discover and edit)
◦Create and change presentation elements
◦Rearranging slides
![Page 54: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/54.jpg)
Presentation ApplicationsCreating and Formatting Slide
Content◦Insert/format text boxes◦Manipulate text◦Add and link existing content
(hyperlinks to external sites, internal files, slides)
◦Apply/customize/modify animations
![Page 55: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/55.jpg)
Presentation ApplicationsWorking with Visual Content
◦Create/Modify SmartArt (diagrams)◦Insert/Customize
ClipArt/Images/Shapes◦Arranging illustrations and other
content◦Insert/modify charts and tables◦Link to external content (charts/data)
![Page 56: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/56.jpg)
Presentations Applications (16 days)Collaborating On / Delivering…
Presentations◦Review/protect/secure and share
presentations◦Prepare printed material◦Prepare for and rehearse
presentation delivery
![Page 57: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/57.jpg)
Database (12 days)Database and Information Design
Management Define data needs and types Database concepts Creating a database Setting the primary key (or unique data
field) Define/print table relationships (concept)
![Page 58: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/58.jpg)
Database (12 days)Creating and Formatting
Database Elements◦Create databases◦Create/modify tables◦Create fields and modify field
properties◦Create forms◦Create reports◦Modify the design of reports/forms
![Page 59: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/59.jpg)
Database (12 days)Creating and modifying queries
◦Create/modify queries
![Page 60: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/60.jpg)
Database (12 days)Presenting and Sharing Data
◦Sort/Filter Data◦Create/modify charts◦Export Data◦Save Database Objects as Other File
Types◦Print Database Objects
![Page 61: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/61.jpg)
End of Semester ProjectsBusiness PlanWedding Planner
![Page 62: IT120 - FIT - Presentation Jan 8 2013](https://reader031.vdocuments.us/reader031/viewer/2022013101/55776ec9d8b42a472c8b5386/html5/thumbnails/62.jpg)